Texas Stream Team Datamap Automation

This form was built in Survey123 Connect to allow community scientists to request new water quality monitoring sites. Submitted data is stored in the siteAttributes feature layer.

Features:

• Autopopulated geographic attributes: County, river basin, and HUCs are automatically filled based on the user’s selected location using pulldata("@layer") queries from authoritative ArcGIS Online layers

• Latitude and longitude capture: Coordinates are extracted from the selected geopoint and rounded for precision

• Conditional field visibility: Administrative fields are hidden during public submissions and only shown to internal staff when the form is edited in the internal dashboard

This web map is the main visual component the Internal Site Request Review Dashboard. The web map supports internal review and data visualization by displaying current and requested monitoring sites alongside key geographic context layers.

Features:

• View layer: A filtered view layer of siteAttributes was created to separate site records from related monitoring data and ensure dashboard compatibility

• Symbology and pop-up configuration: Monitoring sites are symbolized by status category, and pop-ups are customized to display relevant site details for reviewers

• Attribute expressions for stream segment and TCEQ station info: Because point and line features cannot be autopopulated like polygon features, (county, river basin, etc.) Arcade expressions dynamically return the nearest segment and station information in the site's pop-up. This information is not stored in the feature layer, but staff can add this information manually using the Site Request Form in the internal dashboard

This form was built in Survey123 Connect to collect surface water quality data from approved, active, and inactive monitoring sites. Submitted records are stored in the monitoringData table, which is linked to the corresponding site in the siteAttributes layer through a GlobalID-GUID relationship. 

Features:

•  Dynamic list of sites: Allows users to select from an up-to-date list of sites, storing the GlobalID for proper data linkage

• Time constraint for sample time: Ensures submissions follow a valid 4-digit military time format using regular expression and substring logic

• Automatic calculations: Calculates Total Dissolved Solids (TDS) from conductivity and averages Dissolved Oxygen (DO) values if within an acceptable range

• Data validation: Compares user-submitted measurements against official segment-specific TCEQ water quality standards, with warnings for out-of-range values

The internal ArcGIS Dashboard was designed to support internal review and management of new monitoring site requests. It combines real-time data, site request form submissions, and spatial visualization in one streamlined interface to help staff efficiently evaluate submissions.

Features:

• Status indicators (top): Automatically updated counters showing how many sites fall under each review and operational status (e.g., New, Approved, In Progress, etc.)

• Details panel (left): Displays key information from the selected site record for quick reference

• Web map (center): Shows monitoring site locations using the siteAttributes view layer, with symbology and pop-ups configured for clarity

• Embedded form (right): The New Monitoring Site Request Form is embedded and set to edit mode, allowing staff to update submissions directly within the dashboard

• Data table (bottom): An interactive table of all records from the siteAttributes view layer—selecting a row updates the map, details panel, and form simultaneously