Name: StreamSamples

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: 64d6c86b88e44a03bcab62869ffd3f59

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, geoJSON, PBF

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: 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: false
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

Has Attachments: true

Has Last Edit Time: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Type ID Field:

Fields:

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

Templates:

• Name: StreamSamples
  Description:
  Prototype:
  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
  
  Drawing Tool: esriFeatureEditToolNone

Relationships:

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

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: false

Is Data Versioned: false

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: false

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Related Records   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Append   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata