Description: This point feature class represents fixed sampling locations along creeks, tributaries, and drainage channels where the Environmental Services Department regularly collects water samples and performs environmental testing.Environmental Monitoring & Compliance Workflow:Program Purpose: Tracks long-term surface water quality trends, identifies illicit discharge impacts, and monitors ecological health across local watersheds (e.g., Big Bear Creek, Denton Creek tributaries).Testing Parameters: Used to record field measurements and laboratory analytical data including pH, dissolved oxygen, turbidity, conductivity, temperature, bacterial indicators, and pollutant concentrations.Maintenance & Update Frequency: Periodic / As Needed (Updated when new monitoring stations are established or sampling access locations change)Process Step (Lineage Description):Station Establishment: Sampling sites selected by Environmental Services staff based on watershed coverage, access considerations, and stormwater program requirements.Attribute Integration: Station IDs, stream names, watersheds, and monitoring program protocols populated and maintained within the enterprise geodatabase.
Service Item Id: a5427ff3a05d4aabbd035d86984f5a46
Copyright Text: City of Grapevine Public Works Department - Environmental Services Division, PW GIS Division
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.
Service Item Id: a5427ff3a05d4aabbd035d86984f5a46
Copyright Text: City of Grapevine Public Works Department - Environmental Services Division, PW GIS Division.
Default Visibility: false
Max Result Window: N/A
Max Record Count: 2000
Standard Max Record Count No Geometry: N/A
Max Record Count Factor: 1
Standard MaxRecord Count: 32000
Tile Max Record Count: 2000
MaxSelectionCount: 0
Supported Query Formats: JSON, PBF
Supports Advanced Queries: true
Supports Statistics: true
Use Standardized Queries: true
Extent:
Drawing Info:
N/A
Feature Draw Order:
N/A
Advanced Query Capabilities:
Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports Result Pagination Token: false
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Cache Hint: false
Supports Query With Current User: true
Supports Query With Result Type: true
HasZ: false
HasM: false
Time Info:
Start Time Field: N/A
End Time Field: N/A
Track ID Field: N/A
Time Extent:
N/A
Time Reference:
Time Zone: Central Standard Time Respects Daylight Saving: true
Time Interval: N/A
Time Interval Units: N/A
Has Live Data: false