{
 "currentVersion": 11.3,
 "cimVersion": "3.3.0",
 "id": 76,
 "name": "swPump",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "NAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "AssetID",
   "type": "esriFieldTypeString",
   "alias": "AssetID",
   "length": 35,
   "domain": null
  },
  {
   "name": "Location",
   "type": "esriFieldTypeString",
   "alias": "Location",
   "length": 130,
   "domain": null
  },
  {
   "name": "WarrantyDate",
   "type": "esriFieldTypeDate",
   "alias": "WarrantyDate",
   "length": 8,
   "domain": null
  },
  {
   "name": "ControlPanelID",
   "type": "esriFieldTypeString",
   "alias": "ControlPanelID",
   "length": 35,
   "domain": null
  },
  {
   "name": "VaultID",
   "type": "esriFieldTypeString",
   "alias": "VaultID",
   "length": 130,
   "domain": null
  },
  {
   "name": "CatchBasinID",
   "type": "esriFieldTypeString",
   "alias": "CatchBasinID",
   "length": 130,
   "domain": null
  },
  {
   "name": "ManholeID",
   "type": "esriFieldTypeString",
   "alias": "ManholeID",
   "length": 130,
   "domain": null
  },
  {
   "name": "LegacyID",
   "type": "esriFieldTypeString",
   "alias": "LegacyID",
   "length": 30,
   "domain": null
  },
  {
   "name": "EstimatedEffectiveLife",
   "type": "esriFieldTypeSmallInteger",
   "alias": "EstimatedEffectiveLife",
   "domain": null
  },
  {
   "name": "InstallYear",
   "type": "esriFieldTypeSmallInteger",
   "alias": "InstallYear",
   "domain": null
  },
  {
   "name": "Condition",
   "type": "esriFieldTypeSmallInteger",
   "alias": "Condition",
   "domain": null
  },
  {
   "name": "GlobalID",
   "type": "esriFieldTypeGlobalID",
   "alias": "GlobalID",
   "length": 38,
   "domain": null
  },
  {
   "name": "created_user",
   "type": "esriFieldTypeString",
   "alias": "created_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "created_date",
   "type": "esriFieldTypeDate",
   "alias": "created_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "last_edited_user",
   "type": "esriFieldTypeString",
   "alias": "last_edited_user",
   "length": 255,
   "domain": null
  },
  {
   "name": "last_edited_date",
   "type": "esriFieldTypeDate",
   "alias": "last_edited_date",
   "length": 8,
   "domain": null
  },
  {
   "name": "Notes",
   "type": "esriFieldTypeString",
   "alias": "Notes",
   "length": 3000,
   "domain": null
  },
  {
   "name": "BASIN",
   "type": "esriFieldTypeString",
   "alias": "BASIN",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "swBasin",
    "description": "Basin Names",
    "codedValues": [
     {
      "name": "Boeing Creek",
      "code": "BC"
     },
     {
      "name": "McAleer Creek",
      "code": "MC"
     },
     {
      "name": "Middle Puget Sound",
      "code": "MPS"
     },
     {
      "name": "Thornton Creek",
      "code": "TC"
     },
     {
      "name": "West Lake Washington",
      "code": "WLW"
     },
     {
      "name": "Puget Sound",
      "code": "PS"
     },
     {
      "name": "Lyon Creek",
      "code": "LC"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "LifeCycle",
   "type": "esriFieldTypeString",
   "alias": "LifeCycle",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "swLifeCycle",
    "description": "Stormwater Life Cycle Status",
    "codedValues": [
     {
      "name": "Active",
      "code": "AC"
     },
     {
      "name": "Proposed",
      "code": "PR"
     },
     {
      "name": "Abandoned",
      "code": "AB"
     },
     {
      "name": "Removed",
      "code": "RE"
     },
     {
      "name": "Scrapped",
      "code": "SC"
     },
     {
      "name": "Planned Decommission",
      "code": "PD"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DIGITIZE_METHOD",
   "type": "esriFieldTypeString",
   "alias": "DIGITIZE_METHOD",
   "length": 50,
   "domain": {
    "type": "codedValue",
    "name": "DigitizeMethod",
    "description": "Method to Digitize Facility",
    "codedValues": [
     {
      "name": "Import of Digital CAD file",
      "code": "CAD"
     },
     {
      "name": "Georeferenced, scanned Image of CAD drawing",
      "code": "SCAN"
     },
     {
      "name": "Rough Sketch",
      "code": "SKETCH"
     },
     {
      "name": "On screen, using high accuracy aerials (2009)",
      "code": "AERIAL"
     },
     {
      "name": "Low Accuracy GPS 1-5 Meters",
      "code": "GPS-LOW"
     },
     {
      "name": "Sub-meter GPS Accuracy",
      "code": "GPS-High"
     },
     {
      "name": "Field Observation and interpolated using base map",
      "code": "DO"
     },
     {
      "name": "Other",
      "code": "OTH"
     },
     {
      "name": "On screen, using high accuracy aerials (2012)",
      "code": "AERIAL12"
     },
     {
      "name": "Remote video inspection",
      "code": "VIDEO"
     },
     {
      "name": "Van Collection",
      "code": "VAN"
     },
     {
      "name": "On screen, using high accuracy aerials (2015)",
      "code": "AERIAL15"
     },
     {
      "name": "On screen, using high accuracy aerials (King County 2019)",
      "code": "AERIAL19"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "DIGITIZE_SOURCE",
   "type": "esriFieldTypeString",
   "alias": "DIGITIZE_SOURCE",
   "length": 50,
   "domain": null
  },
  {
   "name": "FacilityID",
   "type": "esriFieldTypeString",
   "alias": "FacilityID",
   "length": 35,
   "domain": null
  },
  {
   "name": "MAINTAIN_ZONE",
   "type": "esriFieldTypeString",
   "alias": "MAINTAIN_ZONE",
   "length": 5,
   "domain": {
    "type": "codedValue",
    "name": "MAINTAINZONE",
    "description": "MAINTAINZONE",
    "codedValues": [
     {
      "name": "A-01",
      "code": "A-01"
     },
     {
      "name": "A-02",
      "code": "A-02"
     },
     {
      "name": "A-05",
      "code": "A-05"
     },
     {
      "name": "A-04",
      "code": "A-04"
     },
     {
      "name": "A-03",
      "code": "A-03"
     },
     {
      "name": "A-06",
      "code": "A-06"
     },
     {
      "name": "A-08",
      "code": "A-08"
     },
     {
      "name": "A-07",
      "code": "A-07"
     },
     {
      "name": "A-11",
      "code": "A-11"
     },
     {
      "name": "A-10",
      "code": "A-10"
     },
     {
      "name": "A-09",
      "code": "A-09"
     },
     {
      "name": "B-05",
      "code": "B-05"
     },
     {
      "name": "B-04",
      "code": "B-04"
     },
     {
      "name": "B-03",
      "code": "B-03"
     },
     {
      "name": "B-02",
      "code": "B-02"
     },
     {
      "name": "B-01",
      "code": "B-01"
     },
     {
      "name": "B-07",
      "code": "B-07"
     },
     {
      "name": "B-06",
      "code": "B-06"
     },
     {
      "name": "C-02",
      "code": "C-02"
     },
     {
      "name": "C-04",
      "code": "C-04"
     },
     {
      "name": "C-03",
      "code": "C-03"
     },
     {
      "name": "C-01",
      "code": "C-01"
     },
     {
      "name": "C-07",
      "code": "C-07"
     },
     {
      "name": "C-06",
      "code": "C-06"
     },
     {
      "name": "C-05",
      "code": "C-05"
     },
     {
      "name": "D-07",
      "code": "D-07"
     },
     {
      "name": "D-06",
      "code": "D-06"
     },
     {
      "name": "D-05",
      "code": "D-05"
     },
     {
      "name": "D-04",
      "code": "D-04"
     },
     {
      "name": "D-03",
      "code": "D-03"
     },
     {
      "name": "D-02",
      "code": "D-02"
     },
     {
      "name": "D-01",
      "code": "D-01"
     },
     {
      "name": "E-06",
      "code": "E-06"
     },
     {
      "name": "E-05",
      "code": "E-05"
     },
     {
      "name": "E-04",
      "code": "E-04"
     },
     {
      "name": "E-03",
      "code": "E-03"
     },
     {
      "name": "E-02",
      "code": "E-02"
     },
     {
      "name": "E-01",
      "code": "E-01"
     },
     {
      "name": "F-10",
      "code": "F-10"
     },
     {
      "name": "F-08",
      "code": "F-08"
     },
     {
      "name": "F-07",
      "code": "F-07"
     },
     {
      "name": "F-05",
      "code": "F-05"
     },
     {
      "name": "F-04",
      "code": "F-04"
     },
     {
      "name": "F-06",
      "code": "F-06"
     },
     {
      "name": "F-09",
      "code": "F-09"
     },
     {
      "name": "F-03",
      "code": "F-03"
     },
     {
      "name": "F-02",
      "code": "F-02"
     },
     {
      "name": "F-01",
      "code": "F-01"
     },
     {
      "name": "R-01",
      "code": "R-01"
     },
     {
      "name": "Highlands",
      "code": "HIGH"
     },
     {
      "name": "Outside City Boundary",
      "code": "OUT"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OperatedBy",
   "type": "esriFieldTypeString",
   "alias": "OperatedBy",
   "length": 25,
   "domain": {
    "type": "codedValue",
    "name": "swOperatedBy",
    "description": "Responsibility for SWES",
    "codedValues": [
     {
      "name": "City-Regional",
      "code": "CREG"
     },
     {
      "name": "City-Residential",
      "code": "CRES"
     },
     {
      "name": "City-Commercial",
      "code": "CCOM"
     },
     {
      "name": "City-ROW",
      "code": "CROW"
     },
     {
      "name": "City-Parks",
      "code": "CPAR"
     },
     {
      "name": "Other-Outside City",
      "code": "OTHO"
     },
     {
      "name": "County-King",
      "code": "COUK"
     },
     {
      "name": "City-Facility",
      "code": "CFAC"
     },
     {
      "name": "Private",
      "code": "PVT"
     },
     {
      "name": "State-WSDOT",
      "code": "WSDOT"
     },
     {
      "name": "Private-BNSF",
      "code": "PVTRR"
     },
     {
      "name": "City-Pollution Prevention",
      "code": "CPOLL"
     },
     {
      "name": "Sound Transit",
      "code": "CPSRTA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "OwnedBy",
   "type": "esriFieldTypeString",
   "alias": "OwnedBy",
   "length": 255,
   "domain": {
    "type": "codedValue",
    "name": "swOwnedBy",
    "description": "Owner of Asset",
    "codedValues": [
     {
      "name": "City of Shoreline",
      "code": "CITY"
     },
     {
      "name": "City (Other)",
      "code": "CITYO"
     },
     {
      "name": "County",
      "code": "COUNTY"
     },
     {
      "name": "State",
      "code": "STATE"
     },
     {
      "name": "Other",
      "code": "OTHER"
     },
     {
      "name": "Private",
      "code": "PVT"
     },
     {
      "name": "Sound Transit",
      "code": "CPSRTA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDuplicate"
   }
  },
  {
   "name": "Manufacturer",
   "type": "esriFieldTypeString",
   "alias": "Manufacturer",
   "length": 50,
   "domain": null
  },
  {
   "name": "NIMS_TYPE",
   "type": "esriFieldTypeString",
   "alias": "NIMS_TYPE",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "NIMSType",
    "description": "Different types of National Emergency Management Classifications, minimum values ",
    "codedValues": [
     {
      "name": "Type 1",
      "code": "T1"
     },
     {
      "name": "Type 2",
      "code": "T2"
     },
     {
      "name": "Type 3",
      "code": "T3"
     },
     {
      "name": "Type 4",
      "code": "T4"
     },
     {
      "name": "Type 5",
      "code": "T5"
     },
     {
      "name": "Type 6",
      "code": "T6"
     },
     {
      "name": "N/A",
      "code": "NA"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "BackupGeneratorType",
   "type": "esriFieldTypeString",
   "alias": "BackupGeneratorType",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "swBackupGenType",
    "description": "Different Types of Backup Generators for Surface Water",
    "codedValues": [
     {
      "name": "Permanent",
      "code": "PER"
     },
     {
      "name": "Trailer Mounted",
      "code": "TM"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "GPM",
   "type": "esriFieldTypeInteger",
   "alias": "GPM",
   "domain": null
  },
  {
   "name": "HorsePower",
   "type": "esriFieldTypeInteger",
   "alias": "HorsePower",
   "domain": null
  },
  {
   "name": "Amperage",
   "type": "esriFieldTypeDouble",
   "alias": "Amperage",
   "domain": null
  },
  {
   "name": "PowerSupply",
   "type": "esriFieldTypeString",
   "alias": "PowerSupply",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "swPowerSupply",
    "description": "Different Types of Power Supply for Surface Water Assets",
    "codedValues": [
     {
      "name": "Diesel",
      "code": "D"
     },
     {
      "name": "Electric",
      "code": "E"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "Volts",
   "type": "esriFieldTypeInteger",
   "alias": "Volts",
   "domain": null
  },
  {
   "name": "Phase",
   "type": "esriFieldTypeString",
   "alias": "Phase",
   "length": 6,
   "domain": {
    "type": "codedValue",
    "name": "swPumpPhase",
    "description": "Different phases for Surface Water Pumps",
    "codedValues": [
     {
      "name": "Phase 1",
      "code": "P1"
     },
     {
      "name": "Phase 2",
      "code": "P2"
     },
     {
      "name": "Phase 3",
      "code": "P3"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "ModelNumber",
   "type": "esriFieldTypeString",
   "alias": "ModelNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "SerialNumber",
   "type": "esriFieldTypeString",
   "alias": "SerialNumber",
   "length": 50,
   "domain": null
  },
  {
   "name": "NAME",
   "type": "esriFieldTypeString",
   "alias": "NAME",
   "length": 100,
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "R1470_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "UUID_1470",
   "fields": "GlobalID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G43315swCatchBas",
   "fields": "CatchBasinID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G43315swManholeI",
   "fields": "ManholeID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G43315swPumpStat",
   "fields": "ControlPanelID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G43315swVaultID",
   "fields": "VaultID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "UUID_OID_1470",
   "fields": "GlobalID,OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 9,
   "name": "swControlPanel",
   "relatedTableId": 73,
   "role": "esriRelRoleDestination",
   "keyField": "ControlPanelID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{3A58EEAB-98BE-4B02-9A0F-962872F474AC}"
  },
  {
   "id": 10,
   "name": "swControlPanel",
   "relatedTableId": 10,
   "role": "esriRelRoleDestination",
   "keyField": "ControlPanelID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{3A58EEAB-98BE-4B02-9A0F-962872F474AC}"
  },
  {
   "id": 25,
   "name": "swControlPanel",
   "relatedTableId": 50,
   "role": "esriRelRoleDestination",
   "keyField": "ControlPanelID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{3A58EEAB-98BE-4B02-9A0F-962872F474AC}"
  },
  {
   "id": 6,
   "name": "swManhole",
   "relatedTableId": 4,
   "role": "esriRelRoleDestination",
   "keyField": "ManholeID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{6443A93E-AAA2-461C-91C4-E90A5A5E4640}"
  },
  {
   "id": 22,
   "name": "swManhole",
   "relatedTableId": 44,
   "role": "esriRelRoleDestination",
   "keyField": "ManholeID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{6443A93E-AAA2-461C-91C4-E90A5A5E4640}"
  },
  {
   "id": 37,
   "name": "swManhole",
   "relatedTableId": 87,
   "role": "esriRelRoleDestination",
   "keyField": "ManholeID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{6443A93E-AAA2-461C-91C4-E90A5A5E4640}"
  },
  {
   "id": 12,
   "name": "swVault",
   "relatedTableId": 32,
   "role": "esriRelRoleDestination",
   "keyField": "VaultID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{C080E529-EFD8-4DB4-98B9-1DDEF287C5D6}"
  },
  {
   "id": 27,
   "name": "swVault",
   "relatedTableId": 65,
   "role": "esriRelRoleDestination",
   "keyField": "VaultID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{C080E529-EFD8-4DB4-98B9-1DDEF287C5D6}"
  },
  {
   "id": 4,
   "name": "swCatchBasin",
   "relatedTableId": 3,
   "role": "esriRelRoleDestination",
   "keyField": "CatchBasinID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{87FB4B83-2671-4137-B42C-7819C23AE73B}"
  },
  {
   "id": 20,
   "name": "swCatchBasin",
   "relatedTableId": 43,
   "role": "esriRelRoleDestination",
   "keyField": "CatchBasinID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{87FB4B83-2671-4137-B42C-7819C23AE73B}"
  },
  {
   "id": 35,
   "name": "swCatchBasin",
   "relatedTableId": 86,
   "role": "esriRelRoleDestination",
   "keyField": "CatchBasinID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{87FB4B83-2671-4137-B42C-7819C23AE73B}"
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 4000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": true,
 "useStandardizedQueries": true,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": true,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "supportsQueryAnalytic": true,
  "supportsCurrentUserQueries": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "0430ed826b6c47d39aed3e82239b70eb"
}