{
 "preferredTimeReference": null,
 "useStandardizedQueries": true,
 "maxRecordCount": 2000,
 "description": "This related table logs individual water sampling events conducted by the Environmental Services Department. Multiple sample records link back to a single parent monitoring site over time, establishing a historical time-series of watershed health and physical/chemical water conditions.Collected Parameters & Automated Alerts:Physical & Environmental Conditions: Tracks sampling timestamp, ambient weather, flow conditions, visual water clarity/color, air and water temperatures, and physical flow rates ($m/s$).Water Chemistry & Pollutants: Measures key field indicators ($pH$, $DO$, Turbidity, Specific Conductance, TDS, Salinity) and tests for potential illicit discharges or contaminant indicators (Chlorine, Heavy Metals like $Cu$ and $Cr$, Detergents, Phenol, Ammonia, and Bacteria).Automated Exceedance Indicators: Contains calculated warning fields (pHWarningHigh, TurbWarningExtraHigh, DOWarningLow, etc.) used in ArcGIS web applications and dashboards to instantly flag parameter values that exceed environmental safety or regulatory thresholds.Maintenance & Update Frequency: Continual / Event-Driven (Updated directly by field staff following each sampling event)Process Step (Lineage Description):Field Collection: Environmental Services staff log water quality measurements directly in the field using mobile GIS apps (e.g., ArcGIS Field Maps or Survey123).Relationship Linking: Each submitted record captures the parent station's GlobalID into the SiteIdentifier GUID field to maintain the $1:M$ relationship class.Threshold Checking: Analytical results populate warning fields automatically or during field entry if measured values fall outside expected water quality standard ranges.",
 "attachmentProperties": [
  {
   "fieldName": "ATTACHMENTID",
   "isEnabled": true,
   "name": "id"
  },
  {
   "fieldName": "GLOBALID",
   "isEnabled": true,
   "name": "globalid"
  },
  {
   "fieldName": "KEYWORDS",
   "isEnabled": false,
   "name": "keywords"
  },
  {
   "fieldName": "ATT_NAME",
   "isEnabled": true,
   "name": "name"
  },
  {
   "fieldName": "CONTENT_TYPE",
   "isEnabled": true,
   "name": "contentType"
  },
  {
   "fieldName": "DATA_SIZE",
   "isEnabled": true,
   "name": "size"
  },
  {
   "fieldName": "EXIFINFO",
   "isEnabled": false,
   "name": "exifInfo"
  }
 ],
 "attachmentFields": [
  {
   "nullable": false,
   "editable": false,
   "domain": null,
   "name": "ATTACHMENTID",
   "length": 4,
   "alias": "ATTACHMENTID",
   "type": "esriFieldTypeOID"
  },
  {
   "nullable": false,
   "editable": false,
   "domain": null,
   "name": "GLOBALID",
   "length": 38,
   "alias": "GLOBALID",
   "type": "esriFieldTypeGlobalID"
  },
  {
   "nullable": false,
   "editable": true,
   "domain": null,
   "name": "ATT_NAME",
   "length": 250,
   "alias": "ATT_NAME",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": false,
   "editable": true,
   "domain": null,
   "name": "CONTENT_TYPE",
   "length": 150,
   "alias": "CONTENT_TYPE",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": false,
   "editable": true,
   "domain": null,
   "name": "DATA_SIZE",
   "length": 4,
   "alias": "DATA_SIZE",
   "type": "esriFieldTypeInteger"
  }
 ],
 "datesInUnknownTimezone": false,
 "type": "Table",
 "subtypes": [],
 "relationships": [{
  "keyField": "SiteIdentifier",
  "role": "esriRelRoleDestination",
  "catalogID": "{4632E615-93DC-4295-B944-2ADBE07A9549}",
  "composite": false,
  "name": "DBO.ENVSAMPLING_StreamMonitoring",
  "relatedTableId": 6,
  "id": 0,
  "cardinality": "esriRelCardinalityOneToMany"
 }],
 "indexes": [
  {
   "name": "R379_SDE_ROWID_UK",
   "isUnique": true,
   "description": "",
   "fields": "OBJECTID",
   "isAscending": true
  },
  {
   "name": "GDB_2345_SiteIde",
   "isUnique": false,
   "description": "",
   "fields": "SiteIdentifier",
   "isAscending": true
  },
  {
   "name": "UUID_379",
   "isUnique": true,
   "description": "",
   "fields": "GlobalID",
   "isAscending": true
  }
 ],
 "supportsAttachmentsResizing": true,
 "htmlPopupType": "esriServerHTMLPopupTypeNone",
 "cimVersion": "3.7.0",
 "isDataArchived": false,
 "id": 7,
 "archivingInfo": {
  "startArchivingMoment": -1,
  "supportsQueryWithHistoricMoment": false
 },
 "hasAttachments": true,
 "advancedQueryCapabilities": {
  "supportsSqlExpression": true,
  "supportsQueryWithResultType": true,
  "supportsQueryRelatedPagination": true,
  "supportsSqlFormat": false,
  "useStandardizedQueries": true,
  "supportsResultPaginationToken": false,
  "supportsQueryWithCacheHint": false,
  "supportsCurrentUserQueries": true,
  "supportsQueryAttachmentsWithReturnUrl": true,
  "supportsPagination": true,
  "supportsMaxRecordCountFactor": false,
  "supportsStatistics": true,
  "supportsTrueCurve": false,
  "supportsOrderBy": true,
  "supportsQueryWithDistance": true,
  "supportsQueryAttachmentOrderByFields": true,
  "supportsCountDistinct": true,
  "supportsAdvancedQueryRelated": true,
  "supportsQueryAttachments": true,
  "supportsReturningQueryExtent": true,
  "supportsDistinct": true,
  "supportsTimeRelation": true,
  "supportsQueryAnalytic": true,
  "supportsPercentileStatistics": true,
  "supportsHavingClause": true
 },
 "subtypeField": null,
 "subtypeFieldName": null,
 "supportsStatistics": true,
 "serviceItemId": "a5427ff3a05d4aabbd035d86984f5a46",
 "capabilities": "Query,Map,Data",
 "hasLastEditTime": false,
 "supportsExceedsLimitStatistics": true,
 "standardMaxRecordCount": 32000,
 "isDataVersioned": false,
 "supportsAdvancedQueries": true,
 "advancedQueryAnalyticCapabilities": {
  "supportsAsync": false,
  "supportsLinearRegression": true,
  "supportsPercentileAnalytic": true
 },
 "hasMetadata": true,
 "tileMaxRecordCount": 2000,
 "currentVersion": 12.1,
 "typeIdField": null,
 "defaultSubtypeCode": null,
 "timeInfo": {"timeReference": {
  "timeZoneIANA": "America/Chicago",
  "respectsDaylightSaving": true,
  "timeZone": "Central Standard Time"
 }},
 "supportedQueryFormats": "JSON, PBF",
 "name": "StreamSamples",
 "displayField": "WeatherCond",
 "copyrightText": "City of Grapevine Public Works Department - Environmental Services Division, PW GIS Division.",
 "fields": [
  {
   "nullable": false,
   "domain": null,
   "name": "OBJECTID",
   "alias": "OBJECTID",
   "type": "esriFieldTypeOID"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "CollectionDate",
   "length": 8,
   "alias": "Collection Date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "WeatherCond",
   "length": 100,
   "alias": "Weather Condition",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "StreamFlow",
   "length": 100,
   "alias": "Stream Flow",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "WaterColor",
   "length": 50,
   "alias": "Water Color",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "SiteIdentifier",
   "length": 38,
   "alias": "SiteIdentifier",
   "type": "esriFieldTypeGUID"
  },
  {
   "nullable": false,
   "domain": null,
   "name": "GlobalID",
   "length": 38,
   "alias": "GlobalID",
   "type": "esriFieldTypeGlobalID"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "created_user",
   "length": 255,
   "alias": "created_user",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "created_date",
   "length": 8,
   "alias": "created_date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "last_edited_user",
   "length": 255,
   "alias": "last_edited_user",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "last_edited_date",
   "length": 8,
   "alias": "last_edited_date",
   "type": "esriFieldTypeDate"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "AirTemp",
   "alias": "Air Temperature",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "WaterTemp",
   "alias": "Water Temperature",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "pH",
   "alias": "pH",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Turbidity",
   "alias": "Turbidity",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DissolvedOxygen",
   "alias": "Dissolved Oxygen (DO)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "SpecificConductance",
   "alias": "Specific Conductance (SC)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Salinity",
   "alias": "Salinity (Sal)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TotalDissolvedSolids",
   "alias": "Total Dissolved Solids (TDS)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Chlorine",
   "alias": "Chlorine (Cl2)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Copper",
   "alias": "Copper (Cu)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Detergent",
   "alias": "Detergent",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "PhenolicCompounds",
   "alias": "Phenolic Compounds (Phenol)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Ammonia",
   "alias": "Ammonia",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Chromium",
   "alias": "Chromium",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "Bacteria",
   "alias": "Bacteria?",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "FlowMeasure",
   "alias": "Flow Measure (m/s)",
   "type": "esriFieldTypeSingle"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "pHWarningHigh",
   "length": 255,
   "alias": "pHWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "pHWarningLow",
   "length": 255,
   "alias": "pHWarningLow",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TurbWarningHigh",
   "length": 255,
   "alias": "TurbWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TurbWarningExtraHigh",
   "length": 255,
   "alias": "TurbWarningExtraHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DOWarningLow",
   "length": 255,
   "alias": "DOWarningLow",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DOWarningExtraLow",
   "length": 255,
   "alias": "DOWarningExtraLow",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DOWarningExtremelyLow",
   "length": 255,
   "alias": "DOWarningExtremelyLow",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "SpecificCondWarningMod",
   "length": 255,
   "alias": "SpecificCondWarningMod",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "SpecificCondWarningHigh",
   "length": 255,
   "alias": "SpecificCondWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "SalinityWarningHigh",
   "length": 255,
   "alias": "SalinityWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TDSWarningModeratelyHigh",
   "length": 255,
   "alias": "TDSWarningModeratelyHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TDSWarningHigh",
   "length": 255,
   "alias": "TDSWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "TDSWarningExtremelyHigh",
   "length": 255,
   "alias": "TDSWarningExtremelyHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "ChlorineWarningHigh",
   "length": 255,
   "alias": "ChlorineWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "CopperWarningMod",
   "length": 255,
   "alias": "CopperWarningMod",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "CopperWarningHigh",
   "length": 255,
   "alias": "CopperWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DetergentWarningMod",
   "length": 255,
   "alias": "DetergentWarningMod",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "DetergentWarningHigh",
   "length": 255,
   "alias": "DetergentWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "PhenCompWarningMod",
   "length": 255,
   "alias": "PhenCompWarningMod",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "PhenCompWarningHigh",
   "length": 255,
   "alias": "PhenCompWarningHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "PhenCompWarningExHigh",
   "length": 255,
   "alias": "PhenCompWarningExHigh",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "AmmoniaWarning",
   "length": 255,
   "alias": "AmmoniaWarning",
   "type": "esriFieldTypeString"
  },
  {
   "nullable": true,
   "domain": null,
   "name": "ChromiumWarning",
   "length": 255,
   "alias": "ChromiumWarning",
   "type": "esriFieldTypeString"
  }
 ],
 "maxRecordCountFactor": 1,
 "dateFieldsTimeReference": {
  "timeZoneIANA": "America/Chicago",
  "respectsDaylightSaving": true,
  "timeZone": "Central Standard Time"
 }
}