Name: Drinking Water Advisory

Display Field: ADVISEID

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Has Views: true

Source Schema Changes Allowed: true

Views

Description:

Copyright Text:

Min. Scale: 0

Max. Scale: 0

Default Visibility: true

Max Record Count: 1000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -9333274.6112
YMin: 5099191.64571555
XMax: -9291253.9612511
YMax: 5125598.06661047
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"// Write a script that returns a value that will be used to draw features.\n// For example, find the percentage of males:\n// Round(($feature.MalePop / $feature.TotalPop) * 100, 2)\n\n/* First code \nvar boilAdvisory = $feature.ADVISEEND;\nif (boilAdvisory >= NOW() ){\n return \"Advisory Alert\";\n}\nelse \n{\n return \"No Alert\";\n}*/\n\n//This is second code\n\nvar started = $feature.ADVISESTART\nvar closed = $feature.ADVISEEND\nvar present = Now()\n\n\n// if current date/time is greater than or equal to the start time\n// AND current date/time is less than or equal to the close time \n// return open, otherwise its closed\nIf (present >= started && present <= closed) {\n return \"Open\"\n} else {\n return \"Closed\"\n}\n","valueExpressionTitle":"Custom","defaultSymbol":null,"uniqueValueInfos":[{"value":"Open","symbol":{"color":[255,127,127,255],"outline":{"color":[115,0,0,255],"width":7.5,"type":"esriSLS","style":"esriSLSSolid"},"type":"esriSFS","style":"esriSFSSolid"},"label":"Active Alert"}]},"transparency":20}

HasZ: false

HasM: false

Has Attachments: true

Has Geometry Properties: true

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: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• ADVISEID (type: esriFieldTypeString, alias: Advisory Identifier, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• ADVISESTART (type: esriFieldTypeDate, alias: Advisory Start, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADVISEEND (type: esriFieldTypeDate, alias: Advisory End, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ADVISETYPE (type: esriFieldTypeString, alias: Advisory Type, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Boil Water: Boil Water], [Do Not Drink: Do Not Drink], [Do Not Use: Do Not Use], ... 2 more ...)
• ADVISETYPE_ES (type: esriFieldTypeString, alias: Advisory Type(Spanish), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Informativas: Informativas], [Hervir el agua: Hervir el agua], [No Tomar el agua: No Tomar el agua], ... 2 more ...)
• CONTACT (type: esriFieldTypeString, alias: Contact Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NUMAFF (type: esriFieldTypeSmallInteger, alias: Number of Affected Customers, SQL Type: sqlTypeOther, nullable: true, editable: true)
• NUMCON (type: esriFieldTypeSmallInteger, alias: Number of Affected Connections, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WTRSOURCE (type: esriFieldTypeString, alias: Water Source, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Ground Water: Ground Water], [Reservoir: Reservoir], [River: River], ... 2 more ...)
• WTRSOURCE_ES (type: esriFieldTypeString, alias: Water Source(Spanish), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Agua Subterránea: Agua Subterránea], [Embalse: Embalse], [Río: Río], ... 2 more ...)
• DISINFECT (type: esriFieldTypeString, alias: Disinfect With, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [Chloramine: Chloramine], [Free Chlorine: Free Chlorine], [Other: Other], ... 1 more ...)
• DISINFECT_ES (type: esriFieldTypeString, alias: Disinfect With(Spanish), SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [N/A: N/A], [Cloraminas: Cloraminas], [Cloro: Cloro], ... 5 more ...)
• DESCRIPTION (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• DESCRIPTION_ES (type: esriFieldTypeString, alias: Description(Spanish), SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Area (type: esriFieldTypeDouble, alias: Shape__Area, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)
• CreationDate (type: esriFieldTypeDate, alias: CreationDate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• Creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 128, 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: 128, nullable: true, editable: false)

Templates:

Name: New Feature
Description:
Drawing Tool: esriFeatureEditToolNone
Prototype:

Attributes:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/23/2026 12:21:41 PM

Schema Last Edit Date: 2/12/2026 6:28:49 PM

Data Last Edit Date: 9/23/2026 12:21:41 PM

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