{
"currentVersion": 10.81,
"id": 269,
"name": "stp_Pump",
"type": "Table",
"description": "",
"copyrightText": "",
"editFieldsInfo": {
"creationDateField": "created_date",
"creatorField": "created_user",
"editDateField": "last_edited_date",
"editorField": "last_edited_user"
},
"ownershipBasedAccessControlForFeatures": null,
"syncCanReturnChanges": false,
"relationships": [
{
"id": 29,
"name": "tp_PointsOfInterest",
"relatedTableId": 127,
"cardinality": "esriRelCardinalityOneToMany",
"role": "esriRelRoleDestination",
"keyField": "POINT_OF_INTEREST_ID",
"composite": false
}
],
"isDataVersioned": false,
"isDataArchived": false,
"isCoGoEnabled": false,
"supportsRollbackOnFailureParameter": false,
"archivingInfo": {
"supportsQueryWithHistoricMoment": false,
"startArchivingMoment": -1
},
"supportsStatistics": true,
"supportsAdvancedQueries": true,
"supportsValidateSQL": true,
"supportsCoordinatesQuantization": false,
"supportsCalculate": true,
"advancedQueryCapabilities": {
"supportsPagination": true,
"supportsTrueCurve": true,
"supportsQueryWithDistance": true,
"supportsReturningQueryExtent": true,
"supportsStatistics": true,
"supportsHavingClause": true,
"supportsOrderBy": true,
"supportsDistinct": true,
"supportsCountDistinct": true,
"supportsQueryWithResultType": true,
"supportsReturningGeometryCentroid": false,
"supportsSqlExpression": true
},
"hasAttachments": true,
"supportsAttachmentsByUploadId": true,
"supportsApplyEditsWithGlobalIds": false,
"htmlPopupType": "esriServerHTMLPopupTypeNone",
"objectIdField": "OBJECTID",
"globalIdField": "GlobalID",
"displayField": "NAME",
"typeIdField": "",
"subtypeField": "",
"fields": [
{
"name": "OBJECTID",
"type": "esriFieldTypeOID",
"alias": "OBJECTID",
"domain": null,
"editable": false,
"nullable": false,
"defaultValue": null,
"modelName": "OBJECTID"
},
{
"name": "FACILITYID",
"type": "esriFieldTypeString",
"alias": "Facility ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "FACILITYID"
},
{
"name": "LEGACY_ID",
"type": "esriFieldTypeString",
"alias": "Legacy ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LEGACY_ID"
},
{
"name": "CITY_ASSET_ID",
"type": "esriFieldTypeString",
"alias": "City Asset ID",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "CITY_ASSET_ID"
},
{
"name": "LOCATION",
"type": "esriFieldTypeString",
"alias": "Location Description",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "LOCATION"
},
{
"name": "PROJECT_NUMBER",
"type": "esriFieldTypeString",
"alias": "Project Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PROJECT_NUMBER"
},
{
"name": "MANUFACTURER",
"type": "esriFieldTypeString",
"alias": "Manufacturer",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "MANUFACTURER"
},
{
"name": "MODEL",
"type": "esriFieldTypeString",
"alias": "Model",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "MODEL"
},
{
"name": "SERIAL_NUMBER",
"type": "esriFieldTypeString",
"alias": "Serial Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "SERIAL_NUMBER"
},
{
"name": "PURCHASE_DATE",
"type": "esriFieldTypeDate",
"alias": "Purchase Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "PURCHASE_DATE"
},
{
"name": "INITIAL_COST",
"type": "esriFieldTypeInteger",
"alias": "Initial Cost",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "INITIAL_COST"
},
{
"name": "INSTALLATION_DATE",
"type": "esriFieldTypeDate",
"alias": "Installation Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "INSTALLATION_DATE"
},
{
"name": "WARRANTYDATE",
"type": "esriFieldTypeDate",
"alias": "Warranty Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "WARRANTYDATE"
},
{
"name": "REPLACEMENT_COST",
"type": "esriFieldTypeInteger",
"alias": "Replacement Cost",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "REPLACEMENT_COST"
},
{
"name": "REMAINING_VALUE",
"type": "esriFieldTypeInteger",
"alias": "Remaining Value",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "REMAINING_VALUE"
},
{
"name": "OWNED_BY",
"type": "esriFieldTypeString",
"alias": "Owned By",
"domain": {
"type": "codedValue",
"name": "tp_Owned_Maint_By",
"description": "Owned/Maintained By",
"codedValues": [
{
"name": "MyCodeName",
"code": "MyCodedValue"
},
{
"name": "HARRF Operations",
"code": "HARRF_OPS"
},
{
"name": "HARRF Plant Systems Technician",
"code": "HARRF_PST"
},
{
"name": "HARRF Control Systems Technician",
"code": "HARRF_CST"
},
{
"name": "HARRF Control Systems Analyst",
"code": "HARRF_CSA"
},
{
"name": "Laboratory Technician",
"code": "LAB"
},
{
"name": "WTP Operations",
"code": "WTP_OPS"
},
{
"name": "WTP Plant Systems Technician",
"code": "WTP_PST"
},
{
"name": "WTP Control Systems Technician",
"code": "WTP_CST"
},
{
"name": "WTP Control Systems Analyst",
"code": "WTP_CSA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "OWNED_BY"
},
{
"name": "MAINTAINED_BY",
"type": "esriFieldTypeString",
"alias": "Maintained By",
"domain": {
"type": "codedValue",
"name": "tp_Owned_Maint_By",
"description": "Owned/Maintained By",
"codedValues": [
{
"name": "MyCodeName",
"code": "MyCodedValue"
},
{
"name": "HARRF Operations",
"code": "HARRF_OPS"
},
{
"name": "HARRF Plant Systems Technician",
"code": "HARRF_PST"
},
{
"name": "HARRF Control Systems Technician",
"code": "HARRF_CST"
},
{
"name": "HARRF Control Systems Analyst",
"code": "HARRF_CSA"
},
{
"name": "Laboratory Technician",
"code": "LAB"
},
{
"name": "WTP Operations",
"code": "WTP_OPS"
},
{
"name": "WTP Plant Systems Technician",
"code": "WTP_PST"
},
{
"name": "WTP Control Systems Technician",
"code": "WTP_CST"
},
{
"name": "WTP Control Systems Analyst",
"code": "WTP_CSA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "MAINTAINED_BY"
},
{
"name": "LIFECYCLE_STATUS",
"type": "esriFieldTypeString",
"alias": "Lifecycle Status",
"domain": {
"type": "codedValue",
"name": "tp_Lifecycle_Status",
"description": "Lifecycle Status",
"codedValues": [
{
"name": "Installed",
"code": "INSTALLED"
},
{
"name": "Uninstalled",
"code": "UNINSTALLED"
},
{
"name": "Abandoned-In-Place",
"code": "ABANDONEDINPLACE"
},
{
"name": "Salvaged",
"code": "SALVAGED"
},
{
"name": "Disposed/Removed",
"code": "DISPOSEDREMOVED"
},
{
"name": "Planned/On Order",
"code": "PLANNEDONORDER"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LIFECYCLE_STATUS"
},
{
"name": "CRITICAL",
"type": "esriFieldTypeString",
"alias": "Critical?",
"domain": {
"type": "codedValue",
"name": "tp_glblBoolean",
"description": "Global Boolean",
"codedValues": [
{
"name": "Yes",
"code": "YES"
},
{
"name": "No",
"code": "NO"
},
{
"name": "Not Applicable",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "CRITICAL"
},
{
"name": "CONDITION",
"type": "esriFieldTypeSmallInteger",
"alias": "Condition",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CONDITION"
},
{
"name": "CONDITIONDATE",
"type": "esriFieldTypeDate",
"alias": "Condition Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "CONDITIONDATE"
},
{
"name": "YR_EXPECTED_END_PHYSICAL_LIFE",
"type": "esriFieldTypeSmallInteger",
"alias": "Expected End of Physical Life",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "YR_EXPECTED_END_PHYSICAL_LIFE"
},
{
"name": "TYPICAL_YRS_FULLY_DEPRECIATE",
"type": "esriFieldTypeSmallInteger",
"alias": "Typical Years to Fully Depreciate",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "TYPICAL_YRS_FULLY_DEPRECIATE"
},
{
"name": "DEPRECIATION_DETAILS",
"type": "esriFieldTypeString",
"alias": "Depreciation Details",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "DEPRECIATION_DETAILS"
},
{
"name": "CONSEQUENCE_OF_FAILURE",
"type": "esriFieldTypeDouble",
"alias": "Consequence of Failure (COF)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CONSEQUENCE_OF_FAILURE"
},
{
"name": "PROBABILITY_OF_FAILURE",
"type": "esriFieldTypeDouble",
"alias": "Probability of Failure (POF)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "PROBABILITY_OF_FAILURE"
},
{
"name": "BUSINESS_RISK_EXPOSURE",
"type": "esriFieldTypeDouble",
"alias": "Business Risk Exposure (BRE)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "BUSINESS_RISK_EXPOSURE"
},
{
"name": "DATE_CALCULATED",
"type": "esriFieldTypeDate",
"alias": "COF, POF, and BRE Calculation",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "DATE_CALCULATED"
},
{
"name": "MAINTENANCE_DATE",
"type": "esriFieldTypeDate",
"alias": "Maintenance Date",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "MAINTENANCE_DATE"
},
{
"name": "MAINTENANCE_COMMENTS",
"type": "esriFieldTypeString",
"alias": "Maintenance Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "MAINTENANCE_COMMENTS"
},
{
"name": "IMAGE_URL",
"type": "esriFieldTypeString",
"alias": "Image URL",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "IMAGE_URL"
},
{
"name": "COMMENTS",
"type": "esriFieldTypeString",
"alias": "Comments",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "COMMENTS"
},
{
"name": "SITE_NAME",
"type": "esriFieldTypeString",
"alias": "Site Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "SITE_NAME"
},
{
"name": "PROCESS_NAME",
"type": "esriFieldTypeString",
"alias": "System Name",
"domain": {
"type": "codedValue",
"name": "tp_Process_Name",
"description": "Process Name",
"codedValues": [
{
"name": "Preliminary Treatment",
"code": "PRETREAT"
},
{
"name": "Primary Treatment",
"code": "PRIMTREAT"
},
{
"name": "Secondary Treatment",
"code": "SECTREAT"
},
{
"name": "Tertiary Treatment",
"code": "TERTREAT"
},
{
"name": "Reclaimed Water Storage and Pumping",
"code": "RCWSTOREPUMP"
},
{
"name": "Solids Handling",
"code": "SOLIDSHANDLING"
},
{
"name": "Raw Water Supply",
"code": "RAWSUPPLY"
},
{
"name": "Chemical",
"code": "CHEMICAL"
},
{
"name": "Microfiltration",
"code": "MICROFILTRATION"
},
{
"name": "Reverse Osmosis",
"code": "REVERSEOSMOSIS"
},
{
"name": "Odor Control",
"code": "ODORCNTRL"
},
{
"name": "Stormwater Bypass",
"code": "SWBYPASS"
},
{
"name": "Facility Support",
"code": "FACILITYSUPPORT"
},
{
"name": "Electrical",
"code": "ELECTRICAL"
},
{
"name": "Life Safety",
"code": "LIFESAFETY"
},
{
"name": "Recycled Water",
"code": "RECYCLEWATER"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "PROCESS_NAME"
},
{
"name": "SUBPROCESS_NAME",
"type": "esriFieldTypeString",
"alias": "Subsystem Name",
"domain": {
"type": "codedValue",
"name": "tp_Subprocess_Name",
"description": "Subprocess Name",
"codedValues": [
{
"name": "Screening",
"code": "SCREENING"
},
{
"name": "Pumping",
"code": "PUMPING"
},
{
"name": "Grit Removal",
"code": "GRITREMOVAL"
},
{
"name": "Scum Collection",
"code": "SCUMCOLLECT"
},
{
"name": "Clarification",
"code": "CLARIFICATION"
},
{
"name": "Air Supply",
"code": "AIRSUPPLY"
},
{
"name": "Difffusion",
"code": "DIFFUSION"
},
{
"name": "Return Activated Sludge",
"code": "RETACTSLUDGE"
},
{
"name": "Waste Activated Sludge",
"code": "WASTEACTSLUDGE"
},
{
"name": "Effluent",
"code": "EFFLUENT"
},
{
"name": "Secondary Effluent",
"code": "SECEFFLUENT"
},
{
"name": "Agricultural Water",
"code": "AGWATER"
},
{
"name": "Storage",
"code": "STORAGE"
},
{
"name": "Filtration",
"code": "FILTRATION"
},
{
"name": "Disinfection",
"code": "DISINFECTION"
},
{
"name": "Chlorination",
"code": "CHLORINATION"
},
{
"name": "Neutralization",
"code": "NEUTRALIZATION"
},
{
"name": "Primary Digestion",
"code": "PRIMDIGESTION"
},
{
"name": "Secondary Digestion",
"code": "SECDIGESTION"
},
{
"name": "Sludge Thickening",
"code": "SLUDGETHICK"
},
{
"name": "Dewatering",
"code": "DEWATER"
},
{
"name": "Piping",
"code": "PIPING"
},
{
"name": "Coagulation",
"code": "COAGULATION"
},
{
"name": "Flocculation",
"code": "FLOCCULATION"
},
{
"name": "Feed",
"code": "FEED"
},
{
"name": "Clean In Place (CIP)",
"code": "CIP"
},
{
"name": "Backwash",
"code": "BACKWASH"
},
{
"name": "Reverse Osmosis",
"code": "REVOSMOSIS"
},
{
"name": "Odor Collection",
"code": "ODORCOLLECT"
},
{
"name": "Nutrient Feed System",
"code": "NUTFEEDSYS"
},
{
"name": "Air Scrubbing",
"code": "AIRSCRUBBING"
},
{
"name": "Pressure Reduction",
"code": "PRESSREDUCTION"
},
{
"name": "Security Access Control",
"code": "SECACCESSCNTRL"
},
{
"name": "HVAC",
"code": "HVAC"
},
{
"name": "Plumbing",
"code": "PLUMBING"
},
{
"name": "Building Electrical",
"code": "BLDGELECTRICAL"
},
{
"name": "Building Structural Maintenance",
"code": "BLDGSTRUCTMAINT"
},
{
"name": "Generation",
"code": "GENERATION"
},
{
"name": "Transfer",
"code": "TRANSFER"
},
{
"name": "Distribution",
"code": "DISTRIBUTION"
},
{
"name": "Grounding/Lightning Protection",
"code": "GRNDLIGHTPROTECT"
},
{
"name": "Fire Suppression",
"code": "FIRESUPPRESS"
},
{
"name": "Personal Protection",
"code": "PERSONALPROTECT"
},
{
"name": "Fire Alarm",
"code": "FIREALARM"
},
{
"name": "Recycle Water Chlorination",
"code": "DECHLORINATION"
},
{
"name": "Brine",
"code": "BRINE"
},
{
"name": "Sodium Hypochlorite",
"code": "SODIUM_HYPOCHLORITE"
},
{
"name": "Ferric",
"code": "FERRIC"
},
{
"name": "Coagulant",
"code": "COAGULANT"
},
{
"name": "Polymer",
"code": "POLYMER"
},
{
"name": "Supervisory Control and Data Acquisition",
"code": "SCADA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 100,
"defaultValue": null,
"modelName": "SUBPROCESS_NAME"
},
{
"name": "PUMP_TYPE",
"type": "esriFieldTypeString",
"alias": "Pump Type",
"domain": {
"type": "codedValue",
"name": "tp_Pump_Type",
"description": "Pump Type",
"codedValues": [
{
"name": "Axial Flow",
"code": "AXIALFLOW"
},
{
"name": "Centrifugal (Submersible)",
"code": "CENTRIFUGALSUB"
},
{
"name": "Centrifugal (Non-Submersible)",
"code": "CENTRIFUGALNONSUB"
},
{
"name": "Jet",
"code": "JET"
},
{
"name": "Reciprocating",
"code": "RECIPROCATING"
},
{
"name": "Rotary (Positive Displacement)",
"code": "ROTARYPOSDISP"
},
{
"name": "Diaphragm",
"code": "DIAPHRAGM"
},
{
"name": "Peristaltic",
"code": "PERISTALTIC"
},
{
"name": "Horizontal Split Case",
"code": "HRZNTLSPLITCASE"
},
{
"name": "Vertical Turbine",
"code": "VERTICALTURBINE"
},
{
"name": "Gear IMO",
"code": "GEARIMO"
},
{
"name": "Piston",
"code": "PISTON"
},
{
"name": "Progressive Cavity",
"code": "PROGRESSIVECAVITY"
},
{
"name": "Flygt",
"code": "FLYGT"
},
{
"name": "Other",
"code": "OTHER"
},
{
"name": "Unknown",
"code": "UNKNOWN"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PUMP_TYPE"
},
{
"name": "PUMP_FUNCTION",
"type": "esriFieldTypeString",
"alias": "Pump Function",
"domain": {
"type": "codedValue",
"name": "tp_Pump_Function",
"description": "Pump Function",
"codedValues": [
{
"name": "Wash Water",
"code": "WASHWATER"
},
{
"name": "Raw Water",
"code": "RAWWATER"
},
{
"name": "Finished Water",
"code": "FINISHEDWATER"
},
{
"name": "Sample",
"code": "SAMPLE"
},
{
"name": "Sludge",
"code": "SLUDGE"
},
{
"name": "HVAC",
"code": "HVAC"
},
{
"name": "Sanitary",
"code": "SANITARY"
},
{
"name": "Hydraulic",
"code": "HYDRAULIC"
},
{
"name": "Dewatering",
"code": "DEWATERING"
},
{
"name": "Condensate Return",
"code": "CONDENSATERETURN"
},
{
"name": "Transfer",
"code": "TRANSFER"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PUMP_FUNCTION"
},
{
"name": "INLET_DIAMETER",
"type": "esriFieldTypeString",
"alias": "Inlet Diameter",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "INLET_DIAMETER"
},
{
"name": "DISCHARGE_DIAMETER",
"type": "esriFieldTypeString",
"alias": "Discharge Diameter",
"domain": null,
"editable": true,
"nullable": true,
"length": 10,
"defaultValue": null,
"modelName": "DISCHARGE_DIAMETER"
},
{
"name": "RATED_FLOW",
"type": "esriFieldTypeString",
"alias": "Rated Flow",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "RATED_FLOW"
},
{
"name": "RATED_PRESS",
"type": "esriFieldTypeString",
"alias": "Rated Press",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "RATED_PRESS"
},
{
"name": "TOTAL_DYNAMIC_HEAD",
"type": "esriFieldTypeString",
"alias": "Total Dynamic Head",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "TOTAL_DYNAMIC_HEAD"
},
{
"name": "SHUTOFF_HEAD",
"type": "esriFieldTypeDouble",
"alias": "Shutoff Head",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "SHUTOFF_HEAD"
},
{
"name": "DESIGN_HEAD",
"type": "esriFieldTypeDouble",
"alias": "Design Head",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DESIGN_HEAD"
},
{
"name": "MAXIMUM_OPERATING_HEAD",
"type": "esriFieldTypeDouble",
"alias": "Max Operating Head",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "MAXIMUM_OPERATING_HEAD"
},
{
"name": "NAME",
"type": "esriFieldTypeString",
"alias": "Name",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "NAME"
},
{
"name": "DESIGN_GPM",
"type": "esriFieldTypeDouble",
"alias": "Design GPM",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "DESIGN_GPM"
},
{
"name": "MAXIMUM_OPERATING_DISCHARGE",
"type": "esriFieldTypeDouble",
"alias": "Max Operating Discharge",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "MAXIMUM_OPERATING_DISCHARGE"
},
{
"name": "EFFICIENCY_DESIGN_POINT",
"type": "esriFieldTypeDouble",
"alias": "Efficiency at Design Point (%)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "EFFICIENCY_DESIGN_POINT"
},
{
"name": "NUMBER_STAGES",
"type": "esriFieldTypeSmallInteger",
"alias": "Number of Stages",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "NUMBER_STAGES"
},
{
"name": "HORSEPOWER",
"type": "esriFieldTypeDouble",
"alias": "Horsepower (HP)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "HORSEPOWER"
},
{
"name": "MOTOR_VOLTAGE",
"type": "esriFieldTypeString",
"alias": "Motor Voltage (Volts)",
"domain": {
"type": "codedValue",
"name": "tp_Voltage",
"description": "Voltage",
"codedValues": [
{
"name": "12 (DC)",
"code": "12DC"
},
{
"name": "24 (DC)",
"code": "24DC"
},
{
"name": "24 VDC (Loop Powered)",
"code": "24VDCLOOPEDWRD"
},
{
"name": "110/120 (AC)",
"code": "110120AC"
},
{
"name": "208 (AC)",
"code": "208AC"
},
{
"name": "240 (DC)",
"code": "240DC"
},
{
"name": "460/480 (AC)",
"code": "460480AC"
},
{
"name": "4160 (AC)",
"code": "4160AC"
},
{
"name": "12.47K (AC)",
"code": "1247KAC"
},
{
"name": "2400 (AC)",
"code": "2400AC"
},
{
"name": "120/240 (AC)",
"code": "120240AC"
},
{
"name": "115/230 (AC)",
"code": "115230AC"
},
{
"name": "90 (AC)",
"code": "90AC"
},
{
"name": "220 (AC)",
"code": "220AC"
},
{
"name": "4000 (AC)",
"code": "4000AC"
},
{
"name": "2.3kV (AC)",
"code": "23kVAC"
},
{
"name": "240 (AC)",
"code": "240AC"
},
{
"name": "12/24 (AC)",
"code": "1224AC"
},
{
"name": "4.76 kV",
"code": "476kV"
},
{
"name": "15 kV",
"code": "15kV"
},
{
"name": "11000 V",
"code": "11000V"
},
{
"name": "240/480 V",
"code": "240480V"
},
{
"name": "230/460 V",
"code": "230460V"
},
{
"name": "208/120 V",
"code": "208120V"
},
{
"name": "4760 V",
"code": "4760V"
},
{
"name": "11500 V",
"code": "11500V"
},
{
"name": "Unknown",
"code": "UNKNOWN"
},
{
"name": "Not Applicable",
"code": "NA"
},
{
"name": "700 (DC)",
"code": "700DC"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "MOTOR_VOLTAGE"
},
{
"name": "MOTOR_AMPERAGE",
"type": "esriFieldTypeDouble",
"alias": "Motor Amperage (Amps)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "MOTOR_AMPERAGE"
},
{
"name": "POWER_PHASE",
"type": "esriFieldTypeString",
"alias": "Power Phase",
"domain": {
"type": "codedValue",
"name": "tp_Power_Phase",
"description": "Power Phase",
"codedValues": [
{
"name": "Single",
"code": "SINGLE"
},
{
"name": "Three",
"code": "THREE"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "POWER_PHASE"
},
{
"name": "PUMP_DRIVE_TYPE",
"type": "esriFieldTypeString",
"alias": "Pump Drive Type",
"domain": {
"type": "codedValue",
"name": "tp_Pump_Drive_Type",
"description": "Pump Drive Type",
"codedValues": [
{
"name": "Spider",
"code": "SPIDER"
},
{
"name": "Threaded Coupling",
"code": "THREADEDCOUPLING"
},
{
"name": "Direct",
"code": "DIRECT"
},
{
"name": "Falk",
"code": "FALK"
},
{
"name": "Jack Shaft",
"code": "JACKSHAFT"
},
{
"name": "Belt",
"code": "BELT"
},
{
"name": "Gear",
"code": "GEAR"
},
{
"name": "Other",
"code": "OTHER"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "PUMP_DRIVE_TYPE"
},
{
"name": "IMPELLER_MODEL_NUMBER",
"type": "esriFieldTypeString",
"alias": "Impeller Model Number",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "IMPELLER_MODEL_NUMBER"
},
{
"name": "IMPELLER_DIAMETER",
"type": "esriFieldTypeDouble",
"alias": "Impeller Diameter (In)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "IMPELLER_DIAMETER"
},
{
"name": "NUMBER_IMPELLERS",
"type": "esriFieldTypeSmallInteger",
"alias": "Number of Impellers",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "NUMBER_IMPELLERS"
},
{
"name": "IMPELLER_MATERIAL",
"type": "esriFieldTypeString",
"alias": "Impeller Material",
"domain": {
"type": "codedValue",
"name": "tp_Impeller_Material",
"description": "Impeller Material",
"codedValues": [
{
"name": "Bronze",
"code": "BRONZE"
},
{
"name": "Stainless Steel",
"code": "STAINLESSSTEEL"
},
{
"name": "Unknown",
"code": "UNKNOWN"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "IMPELLER_MATERIAL"
},
{
"name": "BEARING_TYPE",
"type": "esriFieldTypeString",
"alias": "Bearing Type",
"domain": {
"type": "codedValue",
"name": "tp_Bearing_Type",
"description": "Bearing Type",
"codedValues": [
{
"name": "Babbit",
"code": "BABBIT"
},
{
"name": "Ball",
"code": "BALL"
},
{
"name": "Needle",
"code": "NEEDLE"
},
{
"name": "Pillow Block",
"code": "PILLOWBLOCK"
},
{
"name": "Roller",
"code": "ROLLER"
},
{
"name": "Sealed",
"code": "SEALED"
},
{
"name": "Sleeve",
"code": "SLEEVE"
},
{
"name": "Unknown",
"code": "UNKNOWN"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "BEARING_TYPE"
},
{
"name": "CENTERLINE_ELEVATION",
"type": "esriFieldTypeDouble",
"alias": "Centerline Elevation (Ft USGS)",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": null,
"modelName": "CENTERLINE_ELEVATION"
},
{
"name": "TRAILERED",
"type": "esriFieldTypeString",
"alias": "Trailered?",
"domain": {
"type": "codedValue",
"name": "tp_glblBoolean",
"description": "Global Boolean",
"codedValues": [
{
"name": "Yes",
"code": "YES"
},
{
"name": "No",
"code": "NO"
},
{
"name": "Not Applicable",
"code": "NA"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDuplicate"
},
"editable": true,
"nullable": true,
"length": 3,
"defaultValue": null,
"modelName": "TRAILERED"
},
{
"name": "POINT_OF_INTEREST_ID",
"type": "esriFieldTypeString",
"alias": "Position ID (Relate)",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "POINT_OF_INTEREST_ID"
},
{
"name": "GlobalID",
"type": "esriFieldTypeGlobalID",
"alias": "GlobalID",
"domain": null,
"editable": false,
"nullable": false,
"length": 38,
"defaultValue": null,
"modelName": "GlobalID"
},
{
"name": "created_user",
"type": "esriFieldTypeString",
"alias": "created_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "created_user"
},
{
"name": "created_date",
"type": "esriFieldTypeDate",
"alias": "created_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "created_date"
},
{
"name": "last_edited_user",
"type": "esriFieldTypeString",
"alias": "last_edited_user",
"domain": null,
"editable": false,
"nullable": true,
"length": 255,
"defaultValue": null,
"modelName": "last_edited_user"
},
{
"name": "last_edited_date",
"type": "esriFieldTypeDate",
"alias": "last_edited_date",
"domain": null,
"editable": false,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "last_edited_date"
},
{
"name": "LASTUPDATE",
"type": "esriFieldTypeDate",
"alias": "LASTUPDATE",
"domain": null,
"editable": true,
"nullable": true,
"length": 8,
"defaultValue": null,
"modelName": "LASTUPDATE"
},
{
"name": "LASTEDITOR",
"type": "esriFieldTypeString",
"alias": "LASTEDITOR",
"domain": null,
"editable": true,
"nullable": true,
"length": 50,
"defaultValue": null,
"modelName": "LASTEDITOR"
},
{
"name": "ASSETSTATUS",
"type": "esriFieldTypeString",
"alias": "ASSETSTATUS",
"domain": {
"type": "codedValue",
"name": "AssetStatus",
"description": "Current, Retired or Abandoned - Instead of deleting assets they are retired (replaced wholly or partly by new features) or abandoned (blocked and left in ground).",
"codedValues": [
{
"name": "Current",
"code": "C"
},
{
"name": "Retired",
"code": "R"
},
{
"name": "Abandoned",
"code": "A"
},
{
"name": "Geometric Network Only",
"code": "G"
},
{
"name": "Proposed",
"code": "P"
},
{
"name": "Needs Review",
"code": "N"
},
{
"name": "to Delete",
"code": "D"
},
{
"name": "Transposed",
"code": "T"
}
],
"mergePolicy": "esriMPTDefaultValue",
"splitPolicy": "esriSPTDefaultValue"
},
"editable": true,
"nullable": true,
"length": 1,
"defaultValue": "C",
"modelName": "ASSETSTATUS"
},
{
"name": "SCADA_RUNTIME",
"type": "esriFieldTypeDouble",
"alias": "SCADA_RUNTIME",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": 0,
"modelName": "SCADA_RUNTIME"
},
{
"name": "SCADA_INITIATED",
"type": "esriFieldTypeDouble",
"alias": "SCADA_INITIATED",
"domain": null,
"editable": true,
"nullable": true,
"defaultValue": 0,
"modelName": "SCADA_INITIATED"
}
],
"indexes": [
{
"name": "R748_SDE_ROWID_UK",
"fields": "OBJECTID",
"isAscending": true,
"isUnique": true,
"description": ""
},
{
"name": "UUID_748",
"fields": "GlobalID",
"isAscending": true,
"isUnique": false,
"description": ""
},
{
"name": "G2950POINT_OF_IN",
"fields": "POINT_OF_INTEREST_ID",
"isAscending": true,
"isUnique": false,
"description": ""
}
],
"dateFieldsTimeReference": {
"timeZone": "UTC",
"respectsDaylightSaving": false
},
"types": [],
"templates": [
{
"name": "stp_Pump",
"description": "",
"prototype": {
"attributes": {
"SCADA_RUNTIME": 0,
"ASSETSTATUS": "C",
"FACILITYID": null,
"LEGACY_ID": null,
"CITY_ASSET_ID": null,
"LOCATION": null,
"PROJECT_NUMBER": null,
"MANUFACTURER": null,
"MODEL": null,
"SERIAL_NUMBER": null,
"PURCHASE_DATE": null,
"INITIAL_COST": null,
"INSTALLATION_DATE": null,
"WARRANTYDATE": null,
"REPLACEMENT_COST": null,
"REMAINING_VALUE": null,
"OWNED_BY": null,
"MAINTAINED_BY": null,
"LIFECYCLE_STATUS": null,
"CRITICAL": null,
"CONDITION": null,
"CONDITIONDATE": null,
"YR_EXPECTED_END_PHYSICAL_LIFE": null,
"TYPICAL_YRS_FULLY_DEPRECIATE": null,
"DEPRECIATION_DETAILS": null,
"CONSEQUENCE_OF_FAILURE": null,
"PROBABILITY_OF_FAILURE": null,
"BUSINESS_RISK_EXPOSURE": null,
"DATE_CALCULATED": null,
"MAINTENANCE_DATE": null,
"MAINTENANCE_COMMENTS": null,
"IMAGE_URL": null,
"COMMENTS": null,
"SITE_NAME": null,
"PROCESS_NAME": null,
"SUBPROCESS_NAME": null,
"PUMP_TYPE": null,
"PUMP_FUNCTION": null,
"INLET_DIAMETER": null,
"DISCHARGE_DIAMETER": null,
"RATED_FLOW": null,
"RATED_PRESS": null,
"TOTAL_DYNAMIC_HEAD": null,
"SHUTOFF_HEAD": null,
"DESIGN_HEAD": null,
"MAXIMUM_OPERATING_HEAD": null,
"NAME": null,
"DESIGN_GPM": null,
"MAXIMUM_OPERATING_DISCHARGE": null,
"EFFICIENCY_DESIGN_POINT": null,
"NUMBER_STAGES": null,
"HORSEPOWER": null,
"MOTOR_VOLTAGE": null,
"MOTOR_AMPERAGE": null,
"POWER_PHASE": null,
"PUMP_DRIVE_TYPE": null,
"IMPELLER_MODEL_NUMBER": null,
"IMPELLER_DIAMETER": null,
"NUMBER_IMPELLERS": null,
"IMPELLER_MATERIAL": null,
"BEARING_TYPE": null,
"CENTERLINE_ELEVATION": null,
"TRAILERED": null,
"POINT_OF_INTEREST_ID": null,
"SCADA_INITIATED": 0,
"LASTEDITOR": null,
"LASTUPDATE": null
}
},
"drawingTool": "esriFeatureEditToolNone"
}
],
"maxRecordCount": 1000,
"supportedQueryFormats": "JSON, geoJSON",
"capabilities": "Query",
"useStandardizedQueries": true,
"standardMaxRecordCount": 32000,
"tileMaxRecordCount": 1000,
"maxRecordCountFactor": 1,
"serviceItemId": "6aa3f52844c748d88820036a76e0ab74"
}