{
 "currentVersion": 10.51,
 "id": 36,
 "name": "sPump",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "AssetID",
 "typeIdField": "SubType",
 "subtypeFieldName": "SubType",
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "AssetID",
   "length": 30,
   "domain": null
  },
  {
   "name": "LegacyID",
   "type": "esriFieldTypeString",
   "alias": "LegacyID",
   "length": 30,
   "domain": null
  },
  {
   "name": "InstallDate",
   "type": "esriFieldTypeDate",
   "alias": "InstallDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "SubType",
   "type": "esriFieldTypeInteger",
   "alias": "Sub Tpye",
   "domain": null
  },
  {
   "name": "Status",
   "type": "esriFieldTypeString",
   "alias": "Status",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "LifecycleStatus_2",
    "codedValues": [
     {
      "name": "Abandoned",
      "code": "Abandoned"
     },
     {
      "name": "Active",
      "code": "Active"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Proposed",
      "code": "Proposed"
     },
     {
      "name": "Removed",
      "code": "Removed"
     },
     {
      "name": "Under Construction",
      "code": "Under Construction"
     },
     {
      "name": "Active New",
      "code": "ActiveNew"
     },
     {
      "name": "Inactive New",
      "code": "Inactive New"
     },
     {
      "name": "Inquiry",
      "code": "Inquiry"
     },
     {
      "name": "CIP",
      "code": "CapitalImprovementProject"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "WarrantyDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "Condition",
   "type": "esriFieldTypeString",
   "alias": "Condition",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "Condition_Text",
    "codedValues": [
     {
      "name": "Excellent",
      "code": "Excellent"
     },
     {
      "name": "Good",
      "code": "Good"
     },
     {
      "name": "Fair",
      "code": "Fair"
     },
     {
      "name": "Poor",
      "code": "Poor"
     },
     {
      "name": "Out of Service",
      "code": "Out of Service"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ConditionDate",
   "type": "esriFieldTypeDate",
   "alias": "ConditionDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "PrimaryImage",
   "type": "esriFieldTypeString",
   "alias": "PrimaryImage",
   "length": 250,
   "domain": null
  },
  {
   "name": "PumpType",
   "type": "esriFieldTypeString",
   "alias": "PumpType",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "sPumpType",
    "codedValues": [
     {
      "name": "Centrifugal",
      "code": "Centrifugal"
     },
     {
      "name": "Ejector",
      "code": "Ejector"
     },
     {
      "name": "Grinder",
      "code": "Grinder"
     },
     {
      "name": "Diaphram",
      "code": "Diaphram"
     },
     {
      "name": "Other",
      "code": "Other"
     },
     {
      "name": "Pos Displacement",
      "code": "Pos Displacement"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "SPumpManufacturer",
    "codedValues": [
     {
      "name": "Chicago",
      "code": "Chicago"
     },
     {
      "name": "Flygt",
      "code": "Flygt"
     },
     {
      "name": "Fairbanks-Morris",
      "code": "Fairbanks-Morris"
     },
     {
      "name": "Gorman-Rupp",
      "code": "Gorman-Rupp"
     },
     {
      "name": "Smith & Loveless",
      "code": "Smith & Loveless"
     },
     {
      "name": "Hydromatic",
      "code": "Hydromatic"
     },
     {
      "name": "Myers",
      "code": "Myers"
     },
     {
      "name": "ABS",
      "code": "ABS"
     },
     {
      "name": "Aurora",
      "code": "Aurora"
     },
     {
      "name": "Cornell",
      "code": "Cornell"
     },
     {
      "name": "Gardner",
      "code": "Gardner"
     },
     {
      "name": "Goulds-Morris",
      "code": "Goulds-Morris"
     },
     {
      "name": "Quincy Corp",
      "code": "Quincy Corp"
     },
     {
      "name": "PACO",
      "code": "PACO"
     },
     {
      "name": "Barnes",
      "code": "Barnes"
     },
     {
      "name": "Sulzer",
      "code": "Sulzer"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Model",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "length": 20,
   "domain": null
  },
  {
   "name": "Serial",
   "type": "esriFieldTypeString",
   "alias": "Serial",
   "length": 20,
   "domain": null
  },
  {
   "name": "DesignCapacity",
   "type": "esriFieldTypeDouble",
   "alias": "DesignCapacity",
   "domain": null
  },
  {
   "name": "TotalDynamicHead",
   "type": "esriFieldTypeInteger",
   "alias": "TotalDynamicHead",
   "domain": null
  },
  {
   "name": "DEVICE_UID",
   "type": "esriFieldTypeString",
   "alias": "DEVICE_UID",
   "length": 30,
   "domain": null
  },
  {
   "name": "DEVICE_SID",
   "type": "esriFieldTypeString",
   "alias": "DEVICE_SID",
   "length": 10,
   "domain": null
  },
  {
   "name": "FEATURE_ID",
   "type": "esriFieldTypeString",
   "alias": "FEATURE_ID",
   "length": 10,
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "StationFacilityID",
   "type": "esriFieldTypeString",
   "alias": "StationFacilityID",
   "length": 50,
   "domain": null
  },
  {
   "name": "InletDiameter",
   "type": "esriFieldTypeDouble",
   "alias": "InletDiameter",
   "domain": {
    "type": "codedValue",
    "name": "piValveDiam",
    "codedValues": [
     {
      "name": "2\"",
      "code": 2
     },
     {
      "name": "2.5\"",
      "code": 2.5
     },
     {
      "name": "3\"",
      "code": 3
     },
     {
      "name": "4\"",
      "code": 4
     },
     {
      "name": "6\"",
      "code": 6
     },
     {
      "name": "8\"",
      "code": 8
     },
     {
      "name": "10\"",
      "code": 10
     },
     {
      "name": "12\"",
      "code": 12
     },
     {
      "name": "14\"",
      "code": 14
     },
     {
      "name": "15\"",
      "code": 15
     },
     {
      "name": "16\"",
      "code": 16
     },
     {
      "name": "18\"",
      "code": 18
     },
     {
      "name": "20\"",
      "code": 20
     },
     {
      "name": "21\"",
      "code": 21
     },
     {
      "name": "24\"",
      "code": 24
     },
     {
      "name": "27\"",
      "code": 27
     },
     {
      "name": "30\"",
      "code": 30
     },
     {
      "name": "36\"",
      "code": 36
     },
     {
      "name": "42\"",
      "code": 42
     },
     {
      "name": "48\"",
      "code": 48
     },
     {
      "name": "50\"",
      "code": 50
     },
     {
      "name": "54\"",
      "code": 54
     },
     {
      "name": "60\"",
      "code": 60
     },
     {
      "name": "72\"",
      "code": 72
     },
     {
      "name": "84\"",
      "code": 84
     },
     {
      "name": "90\"",
      "code": 90
     },
     {
      "name": "96\"",
      "code": 96
     },
     {
      "name": "5\"",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "OutletDiameter",
   "type": "esriFieldTypeDouble",
   "alias": "OutletDiameter",
   "domain": {
    "type": "codedValue",
    "name": "piValveDiam",
    "codedValues": [
     {
      "name": "2\"",
      "code": 2
     },
     {
      "name": "2.5\"",
      "code": 2.5
     },
     {
      "name": "3\"",
      "code": 3
     },
     {
      "name": "4\"",
      "code": 4
     },
     {
      "name": "6\"",
      "code": 6
     },
     {
      "name": "8\"",
      "code": 8
     },
     {
      "name": "10\"",
      "code": 10
     },
     {
      "name": "12\"",
      "code": 12
     },
     {
      "name": "14\"",
      "code": 14
     },
     {
      "name": "15\"",
      "code": 15
     },
     {
      "name": "16\"",
      "code": 16
     },
     {
      "name": "18\"",
      "code": 18
     },
     {
      "name": "20\"",
      "code": 20
     },
     {
      "name": "21\"",
      "code": 21
     },
     {
      "name": "24\"",
      "code": 24
     },
     {
      "name": "27\"",
      "code": 27
     },
     {
      "name": "30\"",
      "code": 30
     },
     {
      "name": "36\"",
      "code": 36
     },
     {
      "name": "42\"",
      "code": 42
     },
     {
      "name": "48\"",
      "code": 48
     },
     {
      "name": "50\"",
      "code": 50
     },
     {
      "name": "54\"",
      "code": 54
     },
     {
      "name": "60\"",
      "code": 60
     },
     {
      "name": "72\"",
      "code": 72
     },
     {
      "name": "84\"",
      "code": 84
     },
     {
      "name": "90\"",
      "code": 90
     },
     {
      "name": "96\"",
      "code": 96
     },
     {
      "name": "5\"",
      "code": 5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ImpellerSize",
   "type": "esriFieldTypeDouble",
   "alias": "ImpellerSize",
   "domain": {
    "type": "codedValue",
    "name": "psImpellerSize",
    "codedValues": [
     {
      "name": "1\"",
      "code": 1
     },
     {
      "name": "2\"",
      "code": 2
     },
     {
      "name": "3\"",
      "code": 3
     },
     {
      "name": "4\"",
      "code": 4
     },
     {
      "name": "5\"",
      "code": 5
     },
     {
      "name": "6\"",
      "code": 6
     },
     {
      "name": "7\"",
      "code": 7
     },
     {
      "name": "8\"",
      "code": 8
     },
     {
      "name": "9\"",
      "code": 9
     },
     {
      "name": "10\"",
      "code": 10
     },
     {
      "name": "11\"",
      "code": 11
     },
     {
      "name": "12\"",
      "code": 12
     },
     {
      "name": "13\"",
      "code": 13
     },
     {
      "name": "14\"",
      "code": 14
     },
     {
      "name": "15\"",
      "code": 15
     },
     {
      "name": "16\"",
      "code": 16
     },
     {
      "name": "17\"",
      "code": 17
     },
     {
      "name": "18\"",
      "code": 18
     },
     {
      "name": "19\"",
      "code": 19
     },
     {
      "name": "20\"",
      "code": 20
     },
     {
      "name": "17.5\"",
      "code": 17.5
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Description",
   "type": "esriFieldTypeString",
   "alias": "Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "Voltage",
   "type": "esriFieldTypeDouble",
   "alias": "Voltage",
   "domain": null
  },
  {
   "name": "Amperage",
   "type": "esriFieldTypeDouble",
   "alias": "Amperage",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R861_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_861",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1954StationFaci",
   "fields": "StationFacilityID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G1954AssetID",
   "fields": "AssetID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_861",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "types": [
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 1,
   "name": "Dry Pit "
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 2,
   "name": "Dry Pit Submersible"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 3,
   "name": "Submersible"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 4,
   "name": "Self Prime"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 5,
   "name": "Vacuum Prime"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "id": 6,
   "name": "Split Case"
  }
 ],
 "subtypes": [
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 1,
   "name": "Dry Pit "
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 2,
   "name": "Dry Pit Submersible"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 3,
   "name": "Submersible"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 4,
   "name": "Self Prime"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 5,
   "name": "Vacuum Prime"
  },
  {
   "domains": {
    "Status": {"type": "inherited"},
    "Condition": {"type": "inherited"},
    "PumpType": {"type": "inherited"},
    "Manufacturer": {"type": "inherited"},
    "InletDiameter": {"type": "inherited"},
    "OutletDiameter": {"type": "inherited"},
    "ImpellerSize": {"type": "inherited"}
   },
   "defaultValues": {
    "AssetID": null,
    "LegacyID": null,
    "InstallDate": null,
    "SubType": null,
    "Status": null,
    "WarrantyDate": null,
    "Condition": null,
    "ConditionDate": null,
    "PrimaryImage": null,
    "PumpType": null,
    "Manufacturer": null,
    "Model": null,
    "Serial": null,
    "DesignCapacity": null,
    "TotalDynamicHead": null,
    "DEVICE_UID": null,
    "DEVICE_SID": null,
    "FEATURE_ID": null,
    "GlobalID": null,
    "StationFacilityID": null,
    "InletDiameter": null,
    "OutletDiameter": null,
    "ImpellerSize": null,
    "Description": null,
    "Voltage": null,
    "Amperage": null
   },
   "code": 6,
   "name": "Split Case"
  }
 ],
 "relationships": [
  {
   "id": 7,
   "name": "sMotor",
   "relatedTableId": 35,
   "role": "esriRelRoleOrigin",
   "keyField": "AssetID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false
  },
  {
   "id": 8,
   "name": "sPumpController",
   "relatedTableId": 37,
   "role": "esriRelRoleOrigin",
   "keyField": "AssetID",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false
  },
  {
   "id": 9,
   "name": "sValve",
   "relatedTableId": 40,
   "role": "esriRelRoleOrigin",
   "keyField": "AssetID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 3,
   "name": "ssLiftStation",
   "relatedTableId": 41,
   "role": "esriRelRoleDestination",
   "keyField": "StationFacilityID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 1000,
 "supportsStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, AMF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true
 },
 "dateFieldsTimeReference": null
}