{
 "currentVersion": 10.41,
 "id": 64,
 "name": "Pump",
 "type": "Table",
 "description": null,
 "hasAttachments": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "AssetId",
 "typeIdField": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "AssetId",
   "type": "esriFieldTypeString",
   "alias": "Asset ID",
   "length": 16,
   "domain": null
  },
  {
   "name": "Description",
   "type": "esriFieldTypeString",
   "alias": "Description",
   "length": 50,
   "domain": null
  },
  {
   "name": "ParentAsset",
   "type": "esriFieldTypeString",
   "alias": "Parent Asset",
   "length": 16,
   "domain": {
    "type": "codedValue",
    "name": "hwupump_parentid",
    "codedValues": [
     {
      "name": "psBentlyHughs",
      "code": "psBentlyHughs"
     },
     {
      "name": "psRollingHills",
      "code": "psRollingHills"
     },
     {
      "name": "psPeriodTables",
      "code": "psPeriodTables"
     },
     {
      "name": "psSmith",
      "code": "psSmith"
     },
     {
      "name": "psMyrene",
      "code": "psMyrene"
     },
     {
      "name": "psHighlander",
      "code": "psHighlander"
     },
     {
      "name": "psGoldenCorral",
      "code": "psGoldenCorral"
     },
     {
      "name": "psCottsAmerica",
      "code": "psCottsAmerica"
     },
     {
      "name": "psCresline",
      "code": "psCresline"
     },
     {
      "name": "psFreetown",
      "code": "psFreetown"
     },
     {
      "name": "psCustomResin",
      "code": "psCustomResin"
     },
     {
      "name": "psJanalee",
      "code": "psJanalee"
     },
     {
      "name": "psAirport",
      "code": "psAirport"
     },
     {
      "name": "psSonic",
      "code": "psSonic"
     },
     {
      "name": "psCorydonMain",
      "code": "psCorydonMain"
     },
     {
      "name": "psWright",
      "code": "psWright"
     },
     {
      "name": "psSpruce",
      "code": "psSpruce"
     },
     {
      "name": "psRonCollins",
      "code": "psRonCollins"
     },
     {
      "name": "psSaddleBrook",
      "code": "psSaddleBrook"
     },
     {
      "name": "psHayes",
      "code": "psHayes"
     },
     {
      "name": "psSandLane",
      "code": "psSandLane"
     },
     {
      "name": "psParagon",
      "code": "psParagon"
     },
     {
      "name": "psWalnut",
      "code": "psWalnut"
     },
     {
      "name": "psNorthFork",
      "code": "psNorthFork"
     },
     {
      "name": "psScum",
      "code": "psScum"
     },
     {
      "name": "psDewtr",
      "code": "psDewtr"
     },
     {
      "name": "psGrndWtr",
      "code": "psGrndWtr"
     },
     {
      "name": "psMainBldg",
      "code": "psMainBldg"
     },
     {
      "name": "psDecantSouth",
      "code": "psDecantSouth"
     },
     {
      "name": "psSldgPrs",
      "code": "psSldgPrs"
     },
     {
      "name": "psScumPit",
      "code": "psScumPit"
     },
     {
      "name": "psEfflnt",
      "code": "psEfflnt"
     },
     {
      "name": "psRAS1",
      "code": "psRAS1"
     },
     {
      "name": "psRAS2",
      "code": "psRAS2"
     },
     {
      "name": "psOldRAS2",
      "code": "psOldRAS2"
     },
     {
      "name": "psOldRAS1",
      "code": "psOldRAS1"
     },
     {
      "name": "psRAS3",
      "code": "psRAS3"
     },
     {
      "name": "psEQBasin",
      "code": "psEQBasin"
     },
     {
      "name": "psDecant",
      "code": "psDecant"
     },
     {
      "name": "psSldgTfr",
      "code": "psSldgTfr"
     },
     {
      "name": "psLocalSanitary",
      "code": "psLocalSanitary"
     },
     {
      "name": "psMLWW",
      "code": "psMLWW"
     },
     {
      "name": "psCentral",
      "code": "psCentral"
     },
     {
      "name": "psLarue",
      "code": "psLarue"
     },
     {
      "name": "psIrishIvy",
      "code": "psIrishIvy"
     },
     {
      "name": "psChimney",
      "code": "psChimney"
     },
     {
      "name": "psCarriagePark",
      "code": "psCarriagePark"
     },
     {
      "name": "psHazex",
      "code": "psHazex"
     },
     {
      "name": "psCSO",
      "code": "psCSO"
     },
     {
      "name": "psHatchery",
      "code": "psHatchery"
     },
     {
      "name": "psSebreeMain",
      "code": "psSebreeMain"
     },
     {
      "name": "psAudubon",
      "code": "psAudubon"
     },
     {
      "name": "psWeyerhauser",
      "code": "psWeyerhauser"
     },
     {
      "name": "psPresidential",
      "code": "psPresidential"
     },
     {
      "name": "psRussel",
      "code": "psRussel"
     },
     {
      "name": "psBrenntag",
      "code": "psBrenntag"
     },
     {
      "name": "psAtkinsonPark",
      "code": "psAtkinsonPark"
     },
     {
      "name": "psTheHills",
      "code": "psTheHills"
     },
     {
      "name": "psHospital",
      "code": "psHospital"
     },
     {
      "name": "psCrossCreek",
      "code": "psCrossCreek"
     },
     {
      "name": "psHendrStation",
      "code": "psHendrStation"
     },
     {
      "name": "psGardenside",
      "code": "psGardenside"
     },
     {
      "name": "psBentCreek",
      "code": "psBentCreek"
     },
     {
      "name": "psFairStreet",
      "code": "psFairStreet"
     },
     {
      "name": "psFourStar2",
      "code": "psFourStar2"
     },
     {
      "name": "psRiverPort",
      "code": "psRiverPort"
     },
     {
      "name": "psFairmont",
      "code": "psFairmont"
     },
     {
      "name": "psCanoeCreek",
      "code": "psCanoeCreek"
     },
     {
      "name": "psGardenMile",
      "code": "psGardenMile"
     },
     {
      "name": "psCemetary",
      "code": "psCemetary"
     },
     {
      "name": "psStratman",
      "code": "psStratman"
     },
     {
      "name": "psFeedMill",
      "code": "psFeedMill"
     },
     {
      "name": "psDollarStore",
      "code": "psDollarStore"
     },
     {
      "name": "psGreenValley",
      "code": "psGreenValley"
     },
     {
      "name": "psHalliburton2",
      "code": "psHalliburton2"
     },
     {
      "name": "psOhioDrive",
      "code": "psOhioDrive"
     },
     {
      "name": "psSecond2",
      "code": "psSecond2"
     },
     {
      "name": "psStatePolice",
      "code": "psStatePolice"
     },
     {
      "name": "psBobRomans",
      "code": "psBobRomans"
     },
     {
      "name": "psIndustrialPrk",
      "code": "psIndustrialPrk"
     },
     {
      "name": "bsSouth",
      "code": "bsSouth"
     },
     {
      "name": "bsAtkinsonPark",
      "code": "bsAtkinsonPark"
     },
     {
      "name": "bsBarret",
      "code": "bsBarret"
     },
     {
      "name": "NMaint1",
      "code": "NMaint1"
     },
     {
      "name": "NChem1",
      "code": "NChem1"
     },
     {
      "name": "NHs1",
      "code": "NHs1"
     },
     {
      "name": "NCrbn1",
      "code": "NCrbn1"
     },
     {
      "name": "NPuls2",
      "code": "NPuls2"
     },
     {
      "name": "NPuls1",
      "code": "NPuls1"
     },
     {
      "name": "NSldg1",
      "code": "NSldg1"
     },
     {
      "name": "NIntk1",
      "code": "NIntk1"
     },
     {
      "name": "SHs1",
      "code": "SHs1"
     },
     {
      "name": "SHfs1",
      "code": "SHfs1"
     },
     {
      "name": "SChem1",
      "code": "SChem1"
     },
     {
      "name": "SBlch1",
      "code": "SBlch1"
     },
     {
      "name": "SCrbn1",
      "code": "SCrbn1"
     },
     {
      "name": "SLS1",
      "code": "SLS1"
     },
     {
      "name": "SCl2",
      "code": "SCl2"
     },
     {
      "name": "SCone2",
      "code": "SCone2"
     },
     {
      "name": "SCone1",
      "code": "SCone1"
     },
     {
      "name": "NPlnt1",
      "code": "NPlnt1"
     },
     {
      "name": "NwBlwr1",
      "code": "NwBlwr1"
     },
     {
      "name": "SwMain1",
      "code": "SwMain1"
     },
     {
      "name": "SHw1",
      "code": "SHw1"
     },
     {
      "name": "SABlwr1",
      "code": "SABlwr1"
     },
     {
      "name": "SDBlwr1",
      "code": "SDBlwr1"
     },
     {
      "name": "SChlrn1",
      "code": "SChlrn1"
     },
     {
      "name": "SSldgTrk1",
      "code": "SSldgTrk1"
     },
     {
      "name": "SSldgPrs1",
      "code": "SSldgPrs1"
     },
     {
      "name": "SEffChm1",
      "code": "SEffChm1"
     },
     {
      "name": "NBlwr1",
      "code": "NBlwr1"
     },
     {
      "name": "NBlwr2",
      "code": "NBlwr2"
     },
     {
      "name": "NBslft1",
      "code": "NBslft1"
     },
     {
      "name": "NHw1",
      "code": "NHw1"
     },
     {
      "name": "NChlrn1",
      "code": "NChlrn1"
     },
     {
      "name": "NPSMaint1",
      "code": "NPSMaint1"
     },
     {
      "name": "NPlntMaint1",
      "code": "NPlntMaint1"
     },
     {
      "name": "NDigstBldg1",
      "code": "NDigstBldg1"
     },
     {
      "name": "NSldgPrs1",
      "code": "NSldgPrs1"
     },
     {
      "name": "NSldgHpr1",
      "code": "NSldgHpr1"
     },
     {
      "name": "NSldgStrg1",
      "code": "NSldgStrg1"
     },
     {
      "name": "NSldgStrg2",
      "code": "NSldgStrg2"
     },
     {
      "name": "NDigstBldg2",
      "code": "NDigstBldg2"
     },
     {
      "name": "NSptcStn1",
      "code": "NSptcStn1"
     },
     {
      "name": "NFlwSplt1",
      "code": "NFlwSplt1"
     },
     {
      "name": "NBlwr3",
      "code": "NBlwr3"
     },
     {
      "name": "NUVBldg1",
      "code": "NUVBldg1"
     },
     {
      "name": "NHw2",
      "code": "NHw2"
     },
     {
      "name": "NElec1",
      "code": "NElec1"
     },
     {
      "name": "NMLDist1",
      "code": "NMLDist1"
     },
     {
      "name": "NRAWDist1",
      "code": "NRAWDist1"
     },
     {
      "name": "NRASCntrl1",
      "code": "NRASCntrl1"
     },
     {
      "name": "NEffDist1",
      "code": "NEffDist1"
     },
     {
      "name": "SMain1",
      "code": "SMain1"
     },
     {
      "name": "NAdmin1",
      "code": "NAdmin1"
     },
     {
      "name": "psPublicWorks",
      "code": "psPublicWorks"
     },
     {
      "name": "psSpringfield",
      "code": "psSpringfield"
     },
     {
      "name": "psMyrene2",
      "code": "psMyrene2"
     }
    ]
   }
  },
  {
   "name": "ServArea",
   "type": "esriFieldTypeString",
   "alias": "Service Area",
   "length": 7,
   "domain": {
    "type": "codedValue",
    "name": "hwuArea",
    "codedValues": [
     {
      "name": "North",
      "code": "North"
     },
     {
      "name": "South",
      "code": "South"
     },
     {
      "name": "City of Sebree",
      "code": "City of Sebree"
     }
    ]
   }
  },
  {
   "name": "LifeCycleStatus",
   "type": "esriFieldTypeString",
   "alias": "Life Cycle Status",
   "length": 15,
   "domain": {
    "type": "codedValue",
    "name": "Life Cycle Status",
    "codedValues": [
     {
      "name": "In Service",
      "code": "In Service"
     },
     {
      "name": "Disposed",
      "code": "Disposed"
     },
     {
      "name": "Proposed",
      "code": "Proposed"
     },
     {
      "name": "Inactive",
      "code": "Inactive"
     },
     {
      "name": "Abandoned",
      "code": "Abandoned"
     },
     {
      "name": "False Asset",
      "code": "False Asset"
     }
    ]
   }
  },
  {
   "name": "InServDate",
   "type": "esriFieldTypeDate",
   "alias": "In Service Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "DisposeDate",
   "type": "esriFieldTypeDate",
   "alias": "Dispose Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "Warranty Date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 35,
   "domain": null
  },
  {
   "name": "SerialNum",
   "type": "esriFieldTypeString",
   "alias": "Serial Number",
   "length": 50,
   "domain": null
  },
  {
   "name": "Model",
   "type": "esriFieldTypeString",
   "alias": "Model",
   "length": 50,
   "domain": null
  },
  {
   "name": "PmpType",
   "type": "esriFieldTypeString",
   "alias": "Pump Type",
   "length": 20,
   "domain": null
  },
  {
   "name": "ImpellarDia",
   "type": "esriFieldTypeString",
   "alias": "Impellar Diameter",
   "length": 10,
   "domain": null
  },
  {
   "name": "Voltage",
   "type": "esriFieldTypeString",
   "alias": "Voltage",
   "length": 5,
   "domain": null
  },
  {
   "name": "Phase",
   "type": "esriFieldTypeString",
   "alias": "Phase",
   "length": 3,
   "domain": null
  },
  {
   "name": "Horsepower",
   "type": "esriFieldTypeString",
   "alias": "Horsepower",
   "length": 5,
   "domain": null
  },
  {
   "name": "Amps",
   "type": "esriFieldTypeString",
   "alias": "Amps",
   "length": 10,
   "domain": null
  },
  {
   "name": "FLA",
   "type": "esriFieldTypeString",
   "alias": "Full Load Amps",
   "length": 10,
   "domain": null
  },
  {
   "name": "Frequency",
   "type": "esriFieldTypeString",
   "alias": "Frequency",
   "length": 10,
   "domain": null
  },
  {
   "name": "RPM",
   "type": "esriFieldTypeString",
   "alias": "RPM",
   "length": 4,
   "domain": null
  },
  {
   "name": "Location",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "pumpLocation",
    "codedValues": [
     {
      "name": "NWWTP",
      "code": "NWWTP"
     },
     {
      "name": "SWWTP",
      "code": "SWWTP"
     },
     {
      "name": "NWTP",
      "code": "NWTP"
     },
     {
      "name": "SWTP",
      "code": "SWTP"
     },
     {
      "name": "Booster Station",
      "code": "Booster Station"
     },
     {
      "name": "Collection PS",
      "code": "Collection PS"
     }
    ]
   }
  },
  {
   "name": "Compkey",
   "type": "esriFieldTypeInteger",
   "alias": "Compkey",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R39_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_463_ParentAs",
   "fields": "ParentAsset",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "relationships": [
  {
   "id": 33,
   "name": "hwugis.HWU.wwtpStructure",
   "relatedTableId": 39,
   "role": "esriRelRoleDestination",
   "keyField": "ParentAsset",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false
  },
  {
   "id": 5,
   "name": "hwugis.HWU.wwStructure",
   "relatedTableId": 19,
   "role": "esriRelRoleDestination",
   "keyField": "ParentAsset",
   "cardinality": "esriRelCardinalityOneToOne",
   "composite": false
  },
  {
   "id": 25,
   "name": "hwugis.HWU.wtpStructure",
   "relatedTableId": 33,
   "role": "esriRelRoleDestination",
   "keyField": "ParentAsset",
   "cardinality": "esriRelCardinalityOneToOne",
   "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
 },
 "dateFieldsTimeReference": null
}