{ "isCoGoEnabled": false, "isDataBranchVersioned": false, "supportsApplyEditsWithGlobalIds": true, "maxRecordCount": 2000, "attachmentProperties": [ { "fieldName": "ATTACHMENTID", "isEnabled": true, "name": "id" }, { "fieldName": "GLOBALID", "isEnabled": true, "name": "globalId" }, { "fieldName": "ATT_NAME", "isEnabled": true, "name": "name" }, { "fieldName": "DATA_SIZE", "isEnabled": true, "name": "size" }, { "fieldName": "CONTENT_TYPE", "isEnabled": true, "name": "contentType" }, { "fieldName": "KEYWORDS", "isEnabled": false, "name": "keywords" }, { "fieldName": "EXIFINFO", "isEnabled": false, "name": "exifInfo" } ], "attachmentFields": [ { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "ATTACHMENTID", "alias": "ATTACHMENTID", "type": "esriFieldTypeOID" }, { "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GLOBALID", "length": 38, "alias": "GLOBALID", "type": "esriFieldTypeGlobalID" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "ATT_NAME", "length": 250, "alias": "ATT_NAME", "type": "esriFieldTypeString" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "DATA_SIZE", "alias": "DATA_SIZE", "type": "esriFieldTypeInteger" }, { "nullable": false, "editable": true, "defaultValue": null, "domain": null, "name": "CONTENT_TYPE", "length": 150, "alias": "CONTENT_TYPE", "type": "esriFieldTypeString" } ], "infoInEstimates": ["count"], "datesInUnknownTimezone": false, "ownershipBasedAccessControlForFeatures": null, "type": "Table", "supportsAttachmentsByUploadId": true, "relationships": [{ "keyField": "SiteIdentifier", "role": "esriRelRoleDestination", "catalogID": "{4632E615-93DC-4295-B944-2ADBE07A9549}", "composite": false, "name": "DBO.ENVSAMPLING_StreamMonitoring", "relatedTableId": 6, "id": 0, "cardinality": "esriRelCardinalityOneToMany" }], "supportsAttachmentsResizing": true, "cimVersion": "3.7.0", "isDataArchived": false, "id": 7, "archivingInfo": { "startArchivingMoment": -1, "supportsQueryWithHistoricMoment": false }, "supportsStatistics": true, "supportedExportFormats": "sqlite,filegdb,shapefile,csv,geojson,kml,excel,featureCollection", "hasLastEditTime": false, "standardMaxRecordCount": 32000, "isDataVersioned": false, "templates": [{ "name": "StreamSamples", "description": "", "drawingTool": "esriFeatureEditToolNone", "prototype": {"attributes": { "DOWarningExtremelyLow": null, "WaterColor": null, "CollectionDate": null, "SpecificCondWarningMod": null, "ChlorineWarningHigh": null, "WaterTemp": null, "CopperWarningMod": null, "DOWarningLow": null, "DOWarningExtraLow": null, "PhenCompWarningHigh": null, "SiteIdentifier": null, "ChromiumWarning": null, "AirTemp": null, "Turbidity": null, "pH": null, "Bacteria": null, "DetergentWarningMod": null, "TotalDissolvedSolids": null, "Copper": null, "pHWarningLow": null, "TDSWarningHigh": null, "Detergent": null, "TurbWarningHigh": null, "Chlorine": null, "CopperWarningHigh": null, "WeatherCond": null, "pHWarningHigh": null, "PhenCompWarningExHigh": null, "PhenCompWarningMod": null, "DetergentWarningHigh": null, "Salinity": null, "TDSWarningModeratelyHigh": null, "Ammonia": null, "DissolvedOxygen": null, "FlowMeasure": null, "AmmoniaWarning": null, "SpecificConductance": null, "SpecificCondWarningHigh": null, "TDSWarningExtremelyHigh": null, "Chromium": null, "TurbWarningExtraHigh": null, "StreamFlow": null, "SalinityWarningHigh": null, "PhenolicCompounds": null }} }], "supportsAdvancedQueries": true, "currentVersion": 12.1, "advancedEditingCapabilities": { "supportsSessionBasedAddAttachments": true, "supportsAsyncApplyEdits": true, "supportsApplyEditsbyUploadID": true, "supportsSessionBasedUpdateFeatures": true, "supportsSessionBasedDeleteAttachments": true, "supportsDivideCombineGroupedObjects": true, "supportsDeleteAssociations": true, "supportsSessionBasedUpdateAttachments": true, "supportedSqlFormatsInCalculate": ["standard"], "supportedApplyEditsUploadIDFormats": "JSON,PBF", "supportsSessionBasedDeleteFeatures": true, "supportsSessionBasedAddFeatures": true }, "timeInfo": {"timeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" }}, "objectIdField": "OBJECTID", "name": "StreamSamples", "displayField": "WeatherCond", "supportsCalculate": true, "fields": [ { "modelName": "OBJECTID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "OBJECTID", "alias": "OBJECTID", "type": "esriFieldTypeOID" }, { "modelName": "CollectionDate", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "CollectionDate", "length": 8, "alias": "Collection Date", "type": "esriFieldTypeDate" }, { "modelName": "WeatherCond", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "WeatherCond", "length": 100, "alias": "Weather Condition", "type": "esriFieldTypeString" }, { "modelName": "StreamFlow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "StreamFlow", "length": 100, "alias": "Stream Flow", "type": "esriFieldTypeString" }, { "modelName": "WaterColor", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "WaterColor", "length": 50, "alias": "Water Color", "type": "esriFieldTypeString" }, { "modelName": "SiteIdentifier", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SiteIdentifier", "length": 38, "alias": "SiteIdentifier", "type": "esriFieldTypeGUID" }, { "modelName": "GlobalID", "nullable": false, "editable": false, "defaultValue": null, "domain": null, "name": "GlobalID", "length": 38, "alias": "GlobalID", "type": "esriFieldTypeGlobalID" }, { "modelName": "created_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_user", "length": 255, "alias": "created_user", "type": "esriFieldTypeString" }, { "modelName": "created_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "created_date", "length": 8, "alias": "created_date", "type": "esriFieldTypeDate" }, { "modelName": "last_edited_user", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_user", "length": 255, "alias": "last_edited_user", "type": "esriFieldTypeString" }, { "modelName": "last_edited_date", "nullable": true, "editable": false, "defaultValue": null, "domain": null, "name": "last_edited_date", "length": 8, "alias": "last_edited_date", "type": "esriFieldTypeDate" }, { "modelName": "AirTemp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AirTemp", "alias": "Air Temperature", "type": "esriFieldTypeSingle" }, { "modelName": "WaterTemp", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "WaterTemp", "alias": "Water Temperature", "type": "esriFieldTypeSingle" }, { "modelName": "pH", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pH", "alias": "pH", "type": "esriFieldTypeSingle" }, { "modelName": "Turbidity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Turbidity", "alias": "Turbidity", "type": "esriFieldTypeSingle" }, { "modelName": "DissolvedOxygen", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DissolvedOxygen", "alias": "Dissolved Oxygen (DO)", "type": "esriFieldTypeSingle" }, { "modelName": "SpecificConductance", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SpecificConductance", "alias": "Specific Conductance (SC)", "type": "esriFieldTypeSingle" }, { "modelName": "Salinity", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Salinity", "alias": "Salinity (Sal)", "type": "esriFieldTypeSingle" }, { "modelName": "TotalDissolvedSolids", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TotalDissolvedSolids", "alias": "Total Dissolved Solids (TDS)", "type": "esriFieldTypeSingle" }, { "modelName": "Chlorine", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Chlorine", "alias": "Chlorine (Cl2)", "type": "esriFieldTypeSingle" }, { "modelName": "Copper", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Copper", "alias": "Copper (Cu)", "type": "esriFieldTypeSingle" }, { "modelName": "Detergent", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Detergent", "alias": "Detergent", "type": "esriFieldTypeSingle" }, { "modelName": "PhenolicCompounds", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "PhenolicCompounds", "alias": "Phenolic Compounds (Phenol)", "type": "esriFieldTypeSingle" }, { "modelName": "Ammonia", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Ammonia", "alias": "Ammonia", "type": "esriFieldTypeSingle" }, { "modelName": "Chromium", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Chromium", "alias": "Chromium", "type": "esriFieldTypeSingle" }, { "modelName": "Bacteria", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "Bacteria", "alias": "Bacteria?", "type": "esriFieldTypeSingle" }, { "modelName": "FlowMeasure", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "FlowMeasure", "alias": "Flow Measure (m/s)", "type": "esriFieldTypeSingle" }, { "modelName": "pHWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pHWarningHigh", "length": 255, "alias": "pHWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "pHWarningLow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "pHWarningLow", "length": 255, "alias": "pHWarningLow", "type": "esriFieldTypeString" }, { "modelName": "TurbWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TurbWarningHigh", "length": 255, "alias": "TurbWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "TurbWarningExtraHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TurbWarningExtraHigh", "length": 255, "alias": "TurbWarningExtraHigh", "type": "esriFieldTypeString" }, { "modelName": "DOWarningLow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DOWarningLow", "length": 255, "alias": "DOWarningLow", "type": "esriFieldTypeString" }, { "modelName": "DOWarningExtraLow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DOWarningExtraLow", "length": 255, "alias": "DOWarningExtraLow", "type": "esriFieldTypeString" }, { "modelName": "DOWarningExtremelyLow", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DOWarningExtremelyLow", "length": 255, "alias": "DOWarningExtremelyLow", "type": "esriFieldTypeString" }, { "modelName": "SpecificCondWarningMod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SpecificCondWarningMod", "length": 255, "alias": "SpecificCondWarningMod", "type": "esriFieldTypeString" }, { "modelName": "SpecificCondWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SpecificCondWarningHigh", "length": 255, "alias": "SpecificCondWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "SalinityWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "SalinityWarningHigh", "length": 255, "alias": "SalinityWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "TDSWarningModeratelyHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TDSWarningModeratelyHigh", "length": 255, "alias": "TDSWarningModeratelyHigh", "type": "esriFieldTypeString" }, { "modelName": "TDSWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TDSWarningHigh", "length": 255, "alias": "TDSWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "TDSWarningExtremelyHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "TDSWarningExtremelyHigh", "length": 255, "alias": "TDSWarningExtremelyHigh", "type": "esriFieldTypeString" }, { "modelName": "ChlorineWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ChlorineWarningHigh", "length": 255, "alias": "ChlorineWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "CopperWarningMod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "CopperWarningMod", "length": 255, "alias": "CopperWarningMod", "type": "esriFieldTypeString" }, { "modelName": "CopperWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "CopperWarningHigh", "length": 255, "alias": "CopperWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "DetergentWarningMod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DetergentWarningMod", "length": 255, "alias": "DetergentWarningMod", "type": "esriFieldTypeString" }, { "modelName": "DetergentWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "DetergentWarningHigh", "length": 255, "alias": "DetergentWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "PhenCompWarningMod", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "PhenCompWarningMod", "length": 255, "alias": "PhenCompWarningMod", "type": "esriFieldTypeString" }, { "modelName": "PhenCompWarningHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "PhenCompWarningHigh", "length": 255, "alias": "PhenCompWarningHigh", "type": "esriFieldTypeString" }, { "modelName": "PhenCompWarningExHigh", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "PhenCompWarningExHigh", "length": 255, "alias": "PhenCompWarningExHigh", "type": "esriFieldTypeString" }, { "modelName": "AmmoniaWarning", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "AmmoniaWarning", "length": 255, "alias": "AmmoniaWarning", "type": "esriFieldTypeString" }, { "modelName": "ChromiumWarning", "nullable": true, "editable": true, "defaultValue": null, "domain": null, "name": "ChromiumWarning", "length": 255, "alias": "ChromiumWarning", "type": "esriFieldTypeString" } ], "maxRecordCountFactor": 1, "dateFieldsTimeReference": { "timeZoneIANA": "America/Chicago", "respectsDaylightSaving": true, "timeZone": "Central Standard Time" }, "bigIntegerRestrictedTo53Bits": true, "preferredTimeReference": null, "useStandardizedQueries": true, "globalIdField": "GlobalID", "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.", "syncCanReturnChanges": false, "supportsRollbackOnFailureParameter": false, "isDataReplicaTracked": false, "indexes": [ { "name": "R379_SDE_ROWID_UK", "isUnique": true, "description": "", "isAscending": true, "fields": "OBJECTID" }, { "name": "GDB_2345_SiteIde", "isUnique": false, "description": "", "isAscending": true, "fields": "SiteIdentifier" }, { "name": "UUID_379", "isUnique": true, "description": "", "isAscending": true, "fields": "GlobalID" } ], "editFieldsInfo": { "editDateField": "last_edited_date", "editorField": "last_edited_user", "creationDateField": "created_date", "creatorField": "created_user", "dateFieldsTimeReference": { "timeZoneIANA": "Etc/UTC", "respectsDaylightSaving": false, "timeZone": "UTC" } }, "htmlPopupType": "esriServerHTMLPopupTypeNone", "hasAttachments": true, "advancedQueryCapabilities": { "supportsSqlExpression": true, "supportsQueryWithResultType": true, "supportsUseEstimateForExceedsLimit": true, "supportsQueryRelatedPagination": true, "supportsQueryWithCacheHint": false, "supportsCurrentUserQueries": true, "supportsQueryAttachmentsWithReturnUrl": true, "fullTextSearchCapabilities": { "supportsSqlExpressionInFullText": true, "supportsOperator": false, "supportsSearchOperator": true }, "supportsQueryWithLodSR": false, "supportsPagination": true, "supportsMaxRecordCountFactor": false, "fullTextSearchableFields": [], "supportsStatistics": true, "supportsOrderBy": true, "supportsFullTextSearch": true, "supportsQueryWithDistance": true, "supportsQueryAttachmentOrderByFields": true, "supportsLod": false, "supportsCountDistinct": true, "supportsAdvancedQueryRelated": true, "supportsQueryAttachments": true, "supportsReturningQueryExtent": true, "supportsReturningGeometryEnvelope": false, "supportsDistinct": true, "supportsReturningGeometryCentroid": false, "supportsQueryAnalytic": true, "supportsPercentileStatistics": true, "supportsHavingClause": true }, "subtypeField": "", "supportsValidateSQL": true, "serviceItemId": "64d6c86b88e44a03bcab62869ffd3f59", "supportsCoordinatesQuantization": false, "types": [], "capabilities": "Query,Create,Update,Delete,Uploads,Editing", "supportsAppend": true, "supportsExceedsLimitStatistics": true, "advancedQueryAnalyticCapabilities": { "supportsAsync": true, "supportsLinearRegression": true, "supportsPercentileAnalytic": true }, "supportedTrueCurvePbfFeatureEncodings": [ "esriCompressedShapeBuffer", "esriDefault" ], "hasMetadata": true, "supportedAppendFormats": "FILEGDB,PBF,CSV", "tileMaxRecordCount": 2000, "typeIdField": "", "supportsASyncCalculate": true, "supportedQueryFormats": "JSON, geoJSON, PBF", "copyrightText": "City of Grapevine Public Works Department - Environmental Services Division, PW GIS Division." }