{
 "currentVersion": 11.5,
 "cimVersion": "3.5.0",
 "id": 1,
 "name": "Latest Sampling Results",
 "type": "Table",
 "description": "Table is based on an selection on the latest sampling event for each water treatment plant. The results of the most recent sampling event for each parameter are selected from the PFAS_RESULTS_TBL. The view PFAS_LATEST_SAMPLE_VW selects the most recent sampling event for each water treatment unit. The table is updated by script weekday evenings or manually after a results have been entered in Safe Drinking Water Information System tables. ",
 "copyrightText": "Division of Drinking and Ground Waters, Ohio EPA",
 "hasAttachments": false,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "displayField": "SYSNAME",
 "typeIdField": null,
 "subtypeFieldName": null,
 "subtypeField": null,
 "defaultSubtypeCode": null,
 "fields": [
  {
   "name": "OBJECTID",
   "type": "esriFieldTypeOID",
   "alias": "OBJECTID",
   "domain": null
  },
  {
   "name": "DISTRICT",
   "type": "esriFieldTypeString",
   "alias": "District",
   "length": 40,
   "domain": null
  },
  {
   "name": "COUNTY",
   "type": "esriFieldTypeString",
   "alias": "County",
   "length": 40,
   "domain": null
  },
  {
   "name": "PWSID",
   "type": "esriFieldTypeString",
   "alias": "Public Water System ID",
   "length": 12,
   "domain": null
  },
  {
   "name": "SYSNAME",
   "type": "esriFieldTypeString",
   "alias": "System Name",
   "length": 40,
   "domain": null
  },
  {
   "name": "SYS_STATUS",
   "type": "esriFieldTypeString",
   "alias": "System Status",
   "length": 1,
   "domain": null
  },
  {
   "name": "FAC_ID",
   "type": "esriFieldTypeString",
   "alias": "Facility ID",
   "length": 12,
   "domain": null
  },
  {
   "name": "WTP_ID",
   "type": "esriFieldTypeInteger",
   "alias": "Water Treatment Plant ID",
   "domain": null
  },
  {
   "name": "WTPNAME",
   "type": "esriFieldTypeString",
   "alias": "Water Treatment Plant Name",
   "length": 40,
   "domain": null
  },
  {
   "name": "SAMP_PT_ID",
   "type": "esriFieldTypeString",
   "alias": "Sample Point ID",
   "length": 12,
   "domain": null
  },
  {
   "name": "SAMP_TYPE",
   "type": "esriFieldTypeString",
   "alias": "Sample Type",
   "length": 2,
   "domain": null
  },
  {
   "name": "COMPL_SAMP",
   "type": "esriFieldTypeString",
   "alias": "COMPL_SAMP",
   "length": 1,
   "domain": null
  },
  {
   "name": "SAMP_LAB_ID",
   "type": "esriFieldTypeString",
   "alias": "Sample Lab ID",
   "length": 20,
   "domain": null
  },
  {
   "name": "SAMP_DATE",
   "type": "esriFieldTypeString",
   "alias": "Sample Date",
   "length": 10,
   "domain": null
  },
  {
   "name": "SAMP_TS",
   "type": "esriFieldTypeDate",
   "alias": "SAMP_TS",
   "length": 8,
   "domain": null
  },
  {
   "name": "ANALYTE_CD",
   "type": "esriFieldTypeString",
   "alias": "Analyte Code",
   "length": 4,
   "domain": null
  },
  {
   "name": "ANALYTE",
   "type": "esriFieldTypeString",
   "alias": "Analyte",
   "length": 40,
   "domain": null
  },
  {
   "name": "RESULTNUM",
   "type": "esriFieldTypeDouble",
   "alias": "Result Number",
   "domain": null
  },
  {
   "name": "LESSTHANDETECT",
   "type": "esriFieldTypeString",
   "alias": "Less Than Detect",
   "length": 1,
   "domain": null
  },
  {
   "name": "SAMPLE_RESULT",
   "type": "esriFieldTypeString",
   "alias": "Sample Result",
   "length": 43,
   "domain": null
  },
  {
   "name": "UNIT",
   "type": "esriFieldTypeString",
   "alias": "Unit",
   "length": 9,
   "domain": null
  },
  {
   "name": "RESULT_PPT",
   "type": "esriFieldTypeDouble",
   "alias": "Result PPT",
   "domain": null
  },
  {
   "name": "ACTIONLEVEL",
   "type": "esriFieldTypeString",
   "alias": "Action level",
   "length": 11,
   "domain": null
  },
  {
   "name": "PRCNTACTLVL",
   "type": "esriFieldTypeDouble",
   "alias": "Percent Action Level",
   "domain": null
  },
  {
   "name": "LATITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Latitude",
   "domain": null
  },
  {
   "name": "LONGITUDE",
   "type": "esriFieldTypeDouble",
   "alias": "Longitude",
   "domain": null
  }
 ],
 "indexes": [
  {
   "name": "FDO_OBJECTID",
   "fields": "OBJECTID",
   "isAscending": true,
   "isUnique": true,
   "description": ""
  },
  {
   "name": "GDB_4_WTP_ID",
   "fields": "WTP_ID",
   "isAscending": true,
   "isUnique": false,
   "description": ""
  }
 ],
 "subtypes": [],
 "relationships": [
  {
   "id": 0,
   "name": "toWtrTreatmnt",
   "relatedTableId": 0,
   "role": "esriRelRoleDestination",
   "keyField": "WTP_ID",
   "cardinality": "esriRelCardinalityOneToMany",
   "composite": false,
   "catalogID": "{A0139E91-81BA-4F93-993E-C7223C7E4EB3}"
  }
 ],
 "capabilities": "Query,Map,Data",
 "maxRecordCount": 2000,
 "supportsStatistics": true,
 "supportsExceedsLimitStatistics": true,
 "supportsAdvancedQueries": true,
 "supportedQueryFormats": "JSON, PBF",
 "isDataVersioned": false,
 "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": false,
  "supportsCurrentUserQueries": true
 },
 "dateFieldsTimeReference": null,
 "preferredTimeReference": null,
 "datesInUnknownTimezone": false,
 "hasMetadata": true,
 "isDataArchived": false,
 "archivingInfo": {
  "supportsQueryWithHistoricMoment": false,
  "startArchivingMoment": -1
 },
 "serviceItemId": "fe4a9c3d46e1454d869a16d6f0aec029"
}