{
 "currentVersion": 10.91,
 "cimVersion": "2.9.0",
 "id": 101,
 "name": "SW Priority Substance",
 "type": "Table",
 "description": null,
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "swPrioritySubstanceCode",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "SWPrioritySubstance_ID",
   "type": "esriFieldTypeDouble",
   "alias": "Row ID",
   "domain": null
  },
  {
   "name": "SurfaceWaterBody_ID",
   "type": "esriFieldTypeDouble",
   "alias": "Surface Water Body ID",
   "domain": null
  },
  {
   "name": "swPrioritySubstanceCode",
   "type": "esriFieldTypeString",
   "alias": "swPrioritySubstanceCode",
   "length": 20,
   "domain": {
    "type": "codedValue",
    "name": "PS_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "CAS_107-06-2 - Dichloroethane",
      "code": "CAS_107-06-2"
     },
     {
      "name": "CAS_115-29-7 - Endosulfan",
      "code": "CAS_115-29-7"
     },
     {
      "name": "CAS_115-32-2 - Dicofol",
      "code": "CAS_115-32-2"
     },
     {
      "name": "CAS_117-81-7 - Di(2-ethylhexyl)phthalate (DEHP)",
      "code": "CAS_117-81-7"
     },
     {
      "name": "CAS_118-74-1 - Hexachlorobenzene",
      "code": "CAS_118-74-1"
     },
     {
      "name": "CAS_12002-48-1 - Trichlorobenzenes (all isomers)",
      "code": "CAS_12002-48-1"
     },
     {
      "name": "CAS_120-12-7 - Anthracene",
      "code": "CAS_120-12-7"
     },
     {
      "name": "CAS_122-34-9 - Simazine",
      "code": "CAS_122-34-9"
     },
     {
      "name": "CAS_124495-18-7 - Quinoxyfen",
      "code": "CAS_124495-18-7"
     },
     {
      "name": "CAS_127-18-4 - Tetrachloroethylene",
      "code": "CAS_127-18-4"
     },
     {
      "name": "CAS_140-66-9 - Octylphenol (4-(1,1',3,3'-tetramethylbutyl)-phenol)",
      "code": "CAS_140-66-9"
     },
     {
      "name": "CAS_1582-09-8 - Trifluralin",
      "code": "CAS_1582-09-8"
     },
     {
      "name": "CAS_15972-60-8 - Alachlor",
      "code": "CAS_15972-60-8"
     },
     {
      "name": "CAS_1763-23-1 - Perfluorooctane sulfonic acid (PFOS) and its derivatives",
      "code": "CAS_1763-23-1"
     },
     {
      "name": "CAS_1912-24-9 - Atrazine",
      "code": "CAS_1912-24-9"
     },
     {
      "name": "CAS_191-24-2 - Benzo(g,h,i)perylene",
      "code": "CAS_191-24-2"
     },
     {
      "name": "CAS_205-99-2 - Benzo(b)fluoranthene",
      "code": "CAS_205-99-2"
     },
     {
      "name": "CAS_206-44-0 - Fluoranthene",
      "code": "CAS_206-44-0"
     },
     {
      "name": "CAS_207-08-9 - Benzo(k)fluoranthene",
      "code": "CAS__207-08-9"
     },
     {
      "name": "CAS_28159-98-0 - Cybutryne",
      "code": "CAS_28159-98-0"
     },
     {
      "name": "CAS_2921-88-2 - Chlorpyrifos",
      "code": "CAS_2921-88-2"
     },
     {
      "name": "CAS_330-54-1 - Diuron",
      "code": "CAS_330-54-1"
     },
     {
      "name": "CAS_34123-59-6 - Isoproturon",
      "code": "CAS_34123-59-6"
     },
     {
      "name": "CAS_36643-28-4 - Tributyltin-cation",
      "code": "CAS_36643-28-4"
     },
     {
      "name": "CAS_42576-02-3 - Bifenox",
      "code": "CAS_42576-02-3"
     },
     {
      "name": "CAS_470-90-6 - Chlorfenvinphos",
      "code": "CAS_470-90-6"
     },
     {
      "name": "CAS_50-29-3 - DDT, p,p'",
      "code": "CAS_50-29-3"
     },
     {
      "name": "CAS_50-32-8 - Benzo(a)pyrene",
      "code": "CAS_50-32-8"
     },
     {
      "name": "CAS_52315-07-8 - Cypermethrin",
      "code": "CAS_52315-07-8"
     },
     {
      "name": "CAS_56-23-5 - Carbon tetrachloride",
      "code": "CAS_56-23-5"
     },
     {
      "name": "CAS_608-73-1 - Hexachlorocyclohexane",
      "code": "CAS_608-73-1"
     },
     {
      "name": "CAS_608-93-5 - Pentachlorobenzene",
      "code": "CAS_608-93-5"
     },
     {
      "name": "CAS_62-73-7 - Dichlorvos",
      "code": "CAS_62-73-7"
     },
     {
      "name": "CAS_67-66-3 - Trichloromethane",
      "code": "CAS_67-66-3"
     },
     {
      "name": "CAS_71-43-2 - Benzene",
      "code": "CAS_71-43-2"
     },
     {
      "name": "CAS_74070-46-5 - Aclonifen",
      "code": "CAS_74070-46-5"
     },
     {
      "name": "CAS_7439-92-1 - Lead and its compounds",
      "code": "CAS_7439-92-1"
     },
     {
      "name": "CAS_7439-97-6 - Mercury and its compounds",
      "code": "CAS_7439-97-6"
     },
     {
      "name": "CAS_7440-02-0 - Nickel and its compounds",
      "code": "CAS_7440-02-0"
     },
     {
      "name": "CAS_7440-43-9 - Cadmium and its compounds",
      "code": "CAS_7440-43-9"
     },
     {
      "name": "CAS_75-09-2 - Dichloromethane",
      "code": "CAS_75-09-2"
     },
     {
      "name": "CAS_79-01-6 - Trichloroethylene",
      "code": "CAS_79-01-6"
     },
     {
      "name": "CAS_85535-84-8 - Chloroalkanes C10-13",
      "code": "CAS_85535-84-8"
     },
     {
      "name": "CAS_87-68-3 - Hexachlorobutadiene",
      "code": "CAS_87-68-3"
     },
     {
      "name": "CAS_87-86-5 - Pentachlorophenol",
      "code": "CAS_87-86-5"
     },
     {
      "name": "CAS_886-50-0 - Terbutryn",
      "code": "CAS_886-50-0"
     },
     {
      "name": "CAS_91-20-3 - Naphthalene",
      "code": "CAS_91-20-3"
     },
     {
      "name": "EEA_32-02-0 - Total cyclodiene pesticides (aldrin + dieldrin + endrin + isodrin)",
      "code": "EEA_32-02-0"
     },
     {
      "name": "EEA_32-03-1 - Total DDT (DDT, p,p' + DDT, o,p' + DDE, p,p' + DDD, p,p')",
      "code": "EEA_32-03-1"
     },
     {
      "name": "EEA_32-04-2 - Brominated diphenylethers (congener numbers 28, 47, 99, 100, 153 and 154)",
      "code": "EEA_32-04-2"
     },
     {
      "name": "CAS_25154-52-3 - Nonylphenol",
      "code": "CAS_25154-52-3"
     },
     {
      "name": "EEA_33-50-1 - Heptachlor and heptachlor epoxide",
      "code": "EEA_33-50-1"
     },
     {
      "name": "EEA_33-58-9 - Dioxins and dioxin-like compounds (7 PCDDs + 10 PCDFs + 12 PCB-DLs)",
      "code": "EEA_33-58-9"
     },
     {
      "name": "EEA_33-57-8 -Hexabromocyclododecanes (alpha + beta + gamma + 1,3,5,7,9,11 + 1,2,5,6,9,10 -HBCDD)",
      "code": "EEA_33-57-8"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "swPrioritySubstanceCausingFailu",
   "type": "esriFieldTypeString",
   "alias": "SW Priority Substance Causing Failure",
   "length": 10,
   "domain": {
    "type": "codedValue",
    "name": "YesNoUnknownCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "True",
      "code": "Yes"
     },
     {
      "name": "False",
      "code": "No"
     },
     {
      "name": "Unknown",
      "code": "Unknown"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  },
  {
   "name": "swPrioritySubstanceExceedanceIn",
   "type": "esriFieldTypeString",
   "alias": "SW PS Exceedance In Mixing Zone",
   "length": 3,
   "domain": {
    "type": "codedValue",
    "name": "YesNoCode_Enum",
    "description": "",
    "codedValues": [
     {
      "name": "Yes",
      "code": "Yes"
     },
     {
      "name": "No",
      "code": "No"
     }
    ],
    "mergePolicy": "esriMPTDefaultValue",
    "splitPolicy": "esriSPTDefaultValue"
   }
  }
 ],
 "indexes": [
  {
   "name": "R156_SDE_ROWID_UK",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "G371SWPrioritySu",
   "fields": "SWPrioritySubstance_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  },
  {
   "name": "G371SurfaceWater",
   "fields": "SurfaceWaterBody_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 104,
   "name": "SWChemicalExemptionType",
   "relatedTableId": 98,
   "role": "esriRelRoleOrigin",
   "keyField": "SWPrioritySubstance_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 105,
   "name": "SWPrioritySubstanceExceedanceType",
   "relatedTableId": 102,
   "role": "esriRelRoleOrigin",
   "keyField": "SWPrioritySubstance_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  },
  {
   "id": 101,
   "name": "SurfaceWaterBody",
   "relatedTableId": 92,
   "role": "esriRelRoleDestination",
   "keyField": "SurfaceWaterBody_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false
  }
 ],
 "capabilities": "Map,Query,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "advancedQueryCapabilities": {
  "useStandardizedQueries": false,
  "supportsStatistics": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true,
  "supportsOrderBy": true,
  "supportsDistinct": true,
  "supportsCountDistinct": true,
  "supportsPagination": true,
  "supportsTrueCurve": false,
  "supportsReturningQueryExtent": true,
  "supportsQueryWithDistance": true,
  "supportsSqlExpression": true,
  "supportsTimeRelation": true,
  "supportsSqlFormat": true,
  "supportsQueryAnalytic": true
 },
 "advancedQueryAnalyticCapabilities": {
  "supportsLinearRegression": true,
  "supportsAsync": false,
  "supportsPercentileAnalytic": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "730675cccb964c548dbb4f181faa4a6c"
}