Name: Algal Assessments

Display Field: Complaint_Contact_Name

Type: Table

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

HasZ: false

HasM: false

Has Attachments: true

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)
• STAT (type: esriFieldTypeString, alias: STAT, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• Date_Time (type: esriFieldTypeDate, alias: Date_Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• Depth_M (type: esriFieldTypeDouble, alias: Depth_M, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Water_Temp_C (type: esriFieldTypeDouble, alias: Water_Temp_C, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Toxin_Analysis (type: esriFieldTypeString, alias: Toxin_Analysis, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [N/A: Not Applicable])
• Algal_Species (type: esriFieldTypeString, alias: Algal_Species, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Aphanizomenon sp.: Aphanizomenon sp.], [Dolichospermum sp.: Dolichospermum sp.], [Lyngbya sp.: Lyngbya sp.], ... 6 more ...)
• Addtl_Algal_Species (type: esriFieldTypeString, alias: Addtl_Algal_Species, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Aphanizomenon sp.: Aphanizomenon sp.], [Dolichospermum sp.: Dolichospermum sp.], [Lyngbya sp.: Lyngbya sp.], ... 6 more ...)
• Microcystins_ug_L (type: esriFieldTypeDouble, alias: Microcystins_ug_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Cylindrospermopsin_ug_L (type: esriFieldTypeDouble, alias: Cylindrospermopsin_ug_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Chlorophyll_ug_L (type: esriFieldTypeDouble, alias: Chlorophyll_ug_L, SQL Type: sqlTypeOther, nullable: true, editable: true)
• HAB_Advisory_Tier (type: esriFieldTypeString, alias: HAB_Advisory_Tier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [HAB Not Present: HAB Not Present], [Watch: Watch], [Advisory: Advisory])
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Additional_Comments (type: esriFieldTypeString, alias: Additional_Comments, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Complaint_Contact_Name (type: esriFieldTypeString, alias: Complaint_Contact_Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• Complaint_Contact_Phone (type: esriFieldTypeString, alias: Complaint_Contact_Phone, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• Complaint_Contact_Address (type: esriFieldTypeString, alias: Complaint_Contact_Address, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Conductivity (type: esriFieldTypeDouble, alias: Conductivity (uS/cm), SQL Type: sqlTypeOther, nullable: true, editable: true)
• pH (type: esriFieldTypeDouble, alias: pH, SQL Type: sqlTypeOther, nullable: true, editable: true)
• DO (type: esriFieldTypeDouble, alias: DO (mg/L), SQL Type: sqlTypeOther, nullable: true, editable: true)

Templates:

Name: algal_assessments
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Relationships:

• algal_monitoring_sites (0) -- Related To: algal_monitoring_sites (0)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/24/2025 3:47:41 PM

Schema Last Edit Date: 7/24/2025 3:47:41 PM

Data Last Edit Date: 7/24/2025 3:47:41 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Related Records   Query Attachments   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat