Name: Water_Samples_History

Display Field: sampletime

Type: Table

Description:

Copyright Text:

Max Record Count: 1000

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: objectid, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• globalid (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• sampledate (type: esriFieldTypeDate, alias: At what time the water sample is taken?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• sampletime (type: esriFieldTypeString, alias: sampletime, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• tides (type: esriFieldTypeString, alias: Please describe the tides at the time of sampling., SQL Type: sqlTypeOther, length: 19, nullable: true, editable: true, Coded Values: [ebb: Ebb], [quarter-flood: 1/4 Flood], [half-flood: 1/2 Flood], ... 6 more ...)
• weather (type: esriFieldTypeString, alias: Please describe the weather at the time of sampling., SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [clear: Clear], [fair: Fair], [cloud: Cloud], ... 1 more ...)
• winddir (type: esriFieldTypeString, alias: Please describe the wind direction at the time of sampling., SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true, Coded Values: [calm: Calm], [variable: Variable], [north: North], ... 7 more ...)
• rainfall (type: esriFieldTypeDouble, alias: What is the rainfall measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• watertemp (type: esriFieldTypeDouble, alias: What is the water temperature?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• airtemp (type: esriFieldTypeDouble, alias: What is the air temperature?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• coolertemp (type: esriFieldTypeDouble, alias: What is the cooler temperature?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• dissolvedoxygen (type: esriFieldTypeDouble, alias: What is the dissolved oxygen measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• mercury (type: esriFieldTypeDouble, alias: What is the mercury measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• pcbs (type: esriFieldTypeDouble, alias: What is the PCB measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ecoli (type: esriFieldTypeInteger, alias: What is the E. coli measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• etoc (type: esriFieldTypeInteger, alias: What is the Enterococcus bacteria (ETCOC) measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ph (type: esriFieldTypeDouble, alias: What is the pH measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• salinity (type: esriFieldTypeDouble, alias: What is the salinity measurement?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• comment (type: esriFieldTypeString, alias: Please provide any additional comments., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• advisory (type: esriFieldTypeString, alias: Is there a water quality advisory in place? Or, based on the measurements, should there be?, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: Not Applicable])
• advisorydesc (type: esriFieldTypeString, alias: Please describe the water quality advisory., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• advisorystartdate (type: esriFieldTypeDate, alias: On what date does the water quality advisory start?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• advisoryenddate (type: esriFieldTypeDate, alias: On what date does the water quality advisory end?, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• sample_start (type: esriFieldTypeDate, alias: sample_start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• sample_end (type: esriFieldTypeDate, alias: sample_end, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• stationum (type: esriFieldTypeInteger, alias: What is the Station Number?, SQL Type: sqlTypeOther, nullable: true, editable: true)
• parentglobalid (type: esriFieldTypeGUID, alias: parentglobalid, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• CreationDate_1 (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator_1 (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditDate_1 (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor_1 (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• Inspection_ID (type: esriFieldTypeString, alias: Inspection ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)

Templates:

Name: Water_Samples_History
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• station (0) -- Related To: Water_Stations (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 1/5/2026 9:14:01 PM

Schema Last Edit Date: 1/24/2024 12:14:55 AM

Data Last Edit Date: 1/5/2026 9:14:01 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat