Name: Stream Samples

Display Field: WeatherCond

Type: Table

Geometry Type: N/A

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: cfba511bdbea48c2adcd76eff1340ded

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

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field: N/A

Fields:

• OBJECTID ( nullable: false, alias: OBJECTID, type: esriFieldTypeOID )
• CollectionDate ( nullable: true, length: 8, alias: Date, type: esriFieldTypeDate )
• WeatherCond ( nullable: true, length: 100, alias: Weather Condition, type: esriFieldTypeString )
• StreamFlow ( nullable: true, length: 100, alias: Stream Flow, type: esriFieldTypeString )
• WaterColor ( nullable: true, length: 50, alias: Water Color, type: esriFieldTypeString )
• SiteIdentifier ( nullable: true, length: 38, alias: SiteIdentifier, type: esriFieldTypeGUID )
• GlobalID ( nullable: false, length: 38, alias: GlobalID, type: esriFieldTypeGlobalID )
• created_user ( nullable: true, length: 255, alias: created_user, type: esriFieldTypeString )
• created_date ( nullable: true, length: 8, alias: created_date, type: esriFieldTypeDate )
• last_edited_user ( nullable: true, length: 255, alias: last_edited_user, type: esriFieldTypeString )
• last_edited_date ( nullable: true, length: 8, alias: last_edited_date, type: esriFieldTypeDate )
• AirTemp ( nullable: true, alias: Air Temperature, type: esriFieldTypeSingle )
• WaterTemp ( nullable: true, alias: Water Temperature, type: esriFieldTypeSingle )
• pH ( nullable: true, alias: pH, type: esriFieldTypeSingle )
• Turbidity ( nullable: true, alias: Turbidity, type: esriFieldTypeSingle )
• DissolvedOxygen ( nullable: true, alias: Dissolved Oxygen (DO), type: esriFieldTypeSingle )
• SpecificConductance ( nullable: true, alias: Specific Conductance (SC), type: esriFieldTypeSingle )
• Salinity ( nullable: true, alias: Salinity (Sal), type: esriFieldTypeSingle )
• TotalDissolvedSolids ( nullable: true, alias: Total Dissolved Solids (TDS), type: esriFieldTypeSingle )
• Chlorine ( nullable: true, alias: Chlorine (Cl2), type: esriFieldTypeSingle )
• Copper ( nullable: true, alias: Copper (Cu), type: esriFieldTypeSingle )
• Detergent ( nullable: true, alias: Detergent, type: esriFieldTypeSingle )
• PhenolicCompounds ( nullable: true, alias: Phenolic Compounds (Phenol), type: esriFieldTypeSingle )
• Ammonia ( nullable: true, alias: Ammonia, type: esriFieldTypeSingle )
• Chromium ( nullable: true, alias: Chromium, type: esriFieldTypeSingle )
• Bacteria ( nullable: true, alias: Bacteria?, type: esriFieldTypeSingle )
• FlowMeasure ( nullable: true, alias: Flow Measure (m/s), type: esriFieldTypeSingle )
• pHWarningHigh ( nullable: true, length: 255, alias: pH Warning High, type: esriFieldTypeString )
• pHWarningLow ( nullable: true, length: 255, alias: pH Warning Low, type: esriFieldTypeString )
• TurbWarningHigh ( nullable: true, length: 255, alias: Turb Warning High, type: esriFieldTypeString )
• TurbWarningExtraHigh ( nullable: true, length: 255, alias: Turb Warning Extra High, type: esriFieldTypeString )
• DOWarningLow ( nullable: true, length: 255, alias: DO Warning Low, type: esriFieldTypeString )
• DOWarningExtraLow ( nullable: true, length: 255, alias: DO Warning Extra Low, type: esriFieldTypeString )
• DOWarningExtremelyLow ( nullable: true, length: 255, alias: DO Warning Extremel Low, type: esriFieldTypeString )
• SpecificCondWarningMod ( nullable: true, length: 255, alias: Specific Conductance Warning Moderate, type: esriFieldTypeString )
• SpecificCondWarningHigh ( nullable: true, length: 255, alias: Specific Conductance Warning High, type: esriFieldTypeString )
• SalinityWarningHigh ( nullable: true, length: 255, alias: Salinity Warning High, type: esriFieldTypeString )
• TDSWarningModeratelyHigh ( nullable: true, length: 255, alias: TDS Warning Moderately High, type: esriFieldTypeString )
• TDSWarningHigh ( nullable: true, length: 255, alias: TDS Warning High, type: esriFieldTypeString )
• TDSWarningExtremelyHigh ( nullable: true, length: 255, alias: TDSWarningExtremelyHigh, type: esriFieldTypeString )
• ChlorineWarningHigh ( nullable: true, length: 255, alias: Chlorine Warning High, type: esriFieldTypeString )
• CopperWarningMod ( nullable: true, length: 255, alias: Copper Warning Moderate, type: esriFieldTypeString )
• CopperWarningHigh ( nullable: true, length: 255, alias: Copper Warning High, type: esriFieldTypeString )
• DetergentWarningMod ( nullable: true, length: 255, alias: Detergent Warning Moderate, type: esriFieldTypeString )
• DetergentWarningHigh ( nullable: true, length: 255, alias: Detergent Warning High, type: esriFieldTypeString )
• PhenCompWarningMod ( nullable: true, length: 255, alias: Phenolic Compounds Warning Moderate, type: esriFieldTypeString )
• PhenCompWarningHigh ( nullable: true, length: 255, alias: Phenolic Copmpounds Warning High, type: esriFieldTypeString )
• PhenCompWarningExHigh ( nullable: true, length: 255, alias: Phenolic Compounds Warning Extra High, type: esriFieldTypeString )
• AmmoniaWarning ( nullable: true, length: 255, alias: Ammonia Warning, type: esriFieldTypeString )
• ChromiumWarning ( nullable: true, length: 255, alias: Chromium Warning, type: esriFieldTypeString )

Relationships:

• DBO.ENVSAMPLING_StreamMonitoring (0) -- Related To: Stream Monitoring (6)

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata