{ "snippet": "Non-spatial standalone related table storing historical water quality testing logs, field parameter measurements, and chemical analysis results collected at designated Stream Monitoring sites. Linked 1-to-Many ($1:M$) to the Stream Monitoring feature class via SiteIdentifier (GUID).", "summary": "Non-spatial standalone related table storing historical water quality testing logs, field parameter measurements, and chemical analysis results collected at designated Stream Monitoring sites. Linked 1-to-Many ($1:M$) to the Stream Monitoring feature class via SiteIdentifier (GUID).", "accessInformation": "City of Grapevine Public Works Department - Environmental Services Division, PW GIS Division.", "thumbnail": "", "maxScale": 5000, "typeKeywords": [], "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.<\/SPAN><\/P>

Collected Parameters & Automated Alerts<\/SPAN>:<\/SPAN><\/P>

  • Physical & Environmental Conditions: Tracks sampling timestamp, ambient weather, flow conditions, visual water clarity/color, air and water temperatures, and physical flow rates ($m/s$).<\/SPAN><\/P><\/LI>

  • 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).<\/SPAN><\/P><\/LI>

  • 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.<\/SPAN><\/P><\/LI><\/UL>

    Maintenance & Update Frequency<\/SPAN>: Continual / Event-Driven (Updated directly by field staff following each sampling event)<\/SPAN><\/P>

    Process Step (Lineage Description):<\/SPAN><\/P>

    • Field Collection: Environmental Services staff log water quality measurements directly in the field using mobile GIS apps (e.g., ArcGIS Field Maps or Survey123).<\/SPAN><\/P><\/LI>

    • Relationship Linking: Each submitted record captures the parent station's GlobalID into the SiteIdentifier GUID field to maintain the $1:M$ relationship class.<\/SPAN><\/P><\/LI>

    • Threshold Checking: Analytical results populate warning fields automatically or during field entry if measured values fall outside expected water quality standard ranges.<\/SPAN><\/P><\/LI><\/UL><\/DIV><\/DIV><\/DIV>", "licenseInfo": "

      Non-spatial tabular data managed within the enterprise geodatabase. Relies on valid SiteIdentifier GUID values to link to parent Stream Monitoring locations. For environmental reporting, trend analysis, and MS4 permit compliance monitoring.<\/SPAN><\/P><\/DIV><\/DIV>", "catalogPath": "", "title": "Stream Sampling Records Table", "type": "", "url": "", "tags": [ "Stream Monitoring", "Water Quality Samples", "Field Measurements", "Environmental Services", "Water Chemistry", "MS4", "Stormwater", "Related Table", "City of Grapevine", "Public Works" ], "culture": "en-US", "portalUrl": "", "name": "", "guid": "", "minScale": 50000, "spatialReference": "" }