Name: Water_Samples_History

Display Field:

Type: Table

Description:

Copyright Text:

Max Record Count: 5

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: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• EditDate (type: esriFieldTypeDate, alias: EditDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Editor (type: esriFieldTypeString, alias: Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• 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)

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: 3/24/2022 5:58:04 PM

Schema Last Edit Date: 3/24/2022 5:58:04 PM

Data Last Edit Date: 3/24/2022 5:58:04 PM

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