Layers:

Layer: siteAttributes (0)


Name: siteAttributes

Display Field: siteId

Type: Feature Layer

Geometry Type: esriGeometryPoint

Has Views: true

Source Schema Changes Allowed: true

Description: <span style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;">A point layer that stores information about individual water quality monitoring sites submitted by trained community scientists and reviewed by staff.</span><div><ul><li>Site location and hydrologic attributes (site ID, coordinates, county, river basin, HUC codes, TCEQ segment ID/name)</li><li>Community scientist contact information and request details</li><li>Staff-reviewed status fields and internal tracking fields</li><li>Editor tracking fields (Creator, CreationDate, etc.)</li><li>Attachments enabled for submitted site photos</li><li>Each record includes a unique GlobalID used to establish relationships with monitoring data records</li></ul></div>

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10901979.0773885
YMin: 3489265.14542459
XMax: -10781683.2341098
YMax: 3868571.19225433
Spatial Reference: 102100 (3857)


Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[77,67,150,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• siteId (type: esriFieldTypeString, alias: Site ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• siteDescription (type: esriFieldTypeString, alias: Site Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• siteIdAndDescription (type: esriFieldTypeString, alias: Site ID and Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latitude (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• longitude (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
• county (type: esriFieldTypeString, alias: County, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• riverBasin (type: esriFieldTypeString, alias: River Basin, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• huc6 (type: esriFieldTypeString, alias: HUC6 (Basin), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• huc8 (type: esriFieldTypeString, alias: HUC8 (Subbasin), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• huc10 (type: esriFieldTypeString, alias: HUC10 (Watershed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• huc12 (type: esriFieldTypeString, alias: HUC12 (Subwatershed), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tceqStation (type: esriFieldTypeString, alias: TCEQ Station, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tceqSegmentNo (type: esriFieldTypeString, alias: TCEQ Stream Segment No., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• segmentName (type: esriFieldTypeString, alias: Segment Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• latestSamplingEvent (type: esriFieldTypeDateOnly, alias: Latest Sampling Event, SQL Type: sqlTypeOther, nullable: true, editable: true)
• firstName (type: esriFieldTypeString, alias: First Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastName (type: esriFieldTypeString, alias: Last Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• csEmail (type: esriFieldTypeString, alias: Email, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• monitoringGroup (type: esriFieldTypeString, alias: Monitoring Group, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• requestReason (type: esriFieldTypeString, alias: Reason for Site Request, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• privateProperty (type: esriFieldTypeString, alias: Private Property, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
• siteStatus (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Approved: Approved], [Active: Active], [Inactive: Inactive], ... 6 more ...)
• dateAssignedSiteId (type: esriFieldTypeDateOnly, alias: Date Assigned Site ID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dateLastReviewed (type: esriFieldTypeDateOnly, alias: Site Request Date Last Reviewed, SQL Type: sqlTypeOther, nullable: true, editable: true)
• reviewedBy (type: esriFieldTypeString, alias: Site Request Reviewed By, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• staffComments (type: esriFieldTypeString, alias: Comments (staff use), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• creationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• editDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: siteAttributes
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:


Relationships:
• Monitoring Data (0) -- Related To: monitoringData (1)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/14/2025 10:25:39 PM

Schema Last Edit Date: 5/14/2025 10:23:49 PM

Data Last Edit Date: 5/14/2025 10:25:39 PM

Tables:

monitoringData (1)


Name: monitoringData

Display Field: sampleDate

Type: Table

Description: <div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;">A related table that stores water quality monitoring data linked to each site in the siteAttributes layer.</div><div style="font-family:&quot;Avenir Next W01&quot;, &quot;Avenir Next W00&quot;, &quot;Avenir Next&quot;, Avenir, &quot;Helvetica Neue&quot;, sans-serif; font-size:16px;"><ul><li>Sampling metadata (site ID, sample date/time, community scientist name, group affiliation, testing type)</li><li>Core environmental measurements (temperature, pH, DO titrations and average, conductivity, total dissolved solids, indicator bacteria)</li><li>Editor tracking fields (Creator, CreationDate, etc.)</li><li>Contains a siteGlobalID (GUID) field that references the GlobalID of the associated site record</li></ul></div>

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeNone

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True


Global ID Field: GlobalID

Type ID Field:

Fields:
• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• siteGlobalID (type: esriFieldTypeGUID, alias: Site Global ID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• sampleDate (type: esriFieldTypeDateOnly, alias: Sample Date, SQL Type: sqlTypeOther, nullable: true, editable: true)
• sampleTime (type: esriFieldTypeString, alias: Sample Time (military), SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• sampleDepth (type: esriFieldTypeDouble, alias: Sample Depth (meters), SQL Type: sqlTypeOther, nullable: true, editable: true)
• monitoringGroup (type: esriFieldTypeString, alias: Group or Affiliation, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• csNames (type: esriFieldTypeString, alias: Community Scientist's Names, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• testingType (type: esriFieldTypeString, alias: Core Monitoring Type Conducted, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Probe: Probe], [Standard: Standard], [Other: Other])
• waterTemp (type: esriFieldTypeDouble, alias: Water Temperature (°C), SQL Type: sqlTypeOther, nullable: true, editable: true)
• DO1stTitration (type: esriFieldTypeDouble, alias: Dissolved Oxygen: 1st Titration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DO2ndTitration (type: esriFieldTypeDouble, alias: Dissolved Oxygen: 2nd Titration, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DOAverage (type: esriFieldTypeDouble, alias: Dissolved Oxygen Average (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• conductivity (type: esriFieldTypeInteger, alias: Conductivity (µS/cm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• totalDissolvedSolids (type: esriFieldTypeDouble, alias: Total Dissolved Solids (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pH (type: esriFieldTypeDouble, alias: pH Range (SU), SQL Type: sqlTypeOther, nullable: true, editable: true)
• indicatorBacteria (type: esriFieldTypeInteger, alias: Indicator Bacteria (#/100 mL) , SQL Type: sqlTypeOther, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• creationDate (type: esriFieldTypeDate, alias: Creation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• editDate (type: esriFieldTypeDate, alias: Edit Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)

Templates:

Name: monitoringData
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:


Relationships:
• Monitoring Site (0) -- Related To: siteAttributes (0)
Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 5/14/2025 10:25:39 PM

Schema Last Edit Date: 5/14/2025 10:25:39 PM

Data Last Edit Date: 5/14/2025 10:25:39 PM