Name: WaterValve

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

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: -8893128.11495529
YMin: 3871412.60230983
XMax: -8882902.8424721
YMax: 3878154.56689292
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriSMS","style":"esriSMSSquare","color":[230,0,0,255],"size":7,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: false

HasM: false

Has Attachments: false

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: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• TYPE (type: esriFieldTypeString, alias: TYPE, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• LOCATIONDESC (type: esriFieldTypeString, alias: LOCATIONDESC, SQL Type: sqlTypeOther, length: 18, nullable: true, editable: true)
• OPENDIRECTION (type: esriFieldTypeString, alias: OPENDIRECTION, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true)
• SOURCE (type: esriFieldTypeString, alias: Source, SQL Type: sqlTypeOther, length: 6, nullable: true, editable: true)
• PROJ_PHASE (type: esriFieldTypeString, alias: PROJ_PHASE, SQL Type: sqlTypeOther, length: 29, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: INSTALLDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• STATUS (type: esriFieldTypeInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Surveyed], [1: Surveyed], [2: Not Found], ... 2 more ...)
• BOLTMATERIAL (type: esriFieldTypeString, alias: BOLTMATERIAL, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true)
• REPAIRDATE (type: esriFieldTypeDate, alias: REPAIRDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ACCESSIBILITY (type: esriFieldTypeString, alias: ACCESSIBILITY, SQL Type: sqlTypeOther, length: 15, nullable: true, editable: true)
• COMMENT_1 (type: esriFieldTypeString, alias: COMMENT_1, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• COMMENT_2 (type: esriFieldTypeString, alias: COMMENT_2, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
• STREET_NAME (type: esriFieldTypeString, alias: STREET_NAME, SQL Type: sqlTypeOther, length: 36, nullable: true, editable: true)
• SUBDIVISION (type: esriFieldTypeString, alias: SUBDIVISION, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• MAXGISID (type: esriFieldTypeString, alias: MAXGISID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OWNERSHIP (type: esriFieldTypeString, alias: OWNERSHIP, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true)
• MXASSETNUM (type: esriFieldTypeString, alias: MXASSETNUM, SQL Type: sqlTypeOther, length: 12, nullable: true, editable: true)
• MXSITEID (type: esriFieldTypeString, alias: MXSITEID, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• ROWSTAMP (type: esriFieldTypeInteger, alias: Maximo Rowstamp, SQL Type: sqlTypeOther, nullable: true, editable: true)
• Inspector (type: esriFieldTypeString, alias: Inspector, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• InspectionDate (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ValveLocated (type: esriFieldTypeString, alias: Valve Located, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true)
• ValveRaising (type: esriFieldTypeString, alias: Valve Needs Raising, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ValveExercised (type: esriFieldTypeString, alias: Valve Was Exercised, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ValveBoxVacuum (type: esriFieldTypeString, alias: Valve Box Needs Vacuum, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• ValveSize (type: esriFieldTypeSingle, alias: Valve Size, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ValveType (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)
• Comments (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
• GISID (type: esriFieldTypeInteger, alias: GISID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WQ10Zone (type: esriFieldTypeInteger, alias: WQ10Zone, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ValveProblems (type: esriFieldTypeString, alias: Valve Problems, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• NumberOfTurns (type: esriFieldTypeSingle, alias: Number of Turns, SQL Type: sqlTypeOther, nullable: true, editable: true)
• created_user (type: esriFieldTypeString, alias: created_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• created_date (type: esriFieldTypeDate, alias: created_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• last_edited_user (type: esriFieldTypeString, alias: last_edited_user, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• last_edited_date (type: esriFieldTypeDate, alias: last_edited_date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• esritask_type (type: esriFieldTypeInteger, alias: Task Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Task Type 1])
• esritask_assignee (type: esriFieldTypeString, alias: Assignee, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [assignee_username: Assignee name])
• esritask_status (type: esriFieldTypeInteger, alias: Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Surveyed], [1: Surveyed], [2: Not Found], ... 2 more ...)
• esritask_priority (type: esriFieldTypeInteger, alias: Priority, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: None], [1: Low], [2: Medium], ... 2 more ...)
• esritask_duedate (type: esriFieldTypeDate, alias: Due Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• esritask_description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
• esritask_notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)

Templates:

Name: WaterValve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:

Attributes:

• TYPE: GATE
• LOCATIONDESC: Grass
• OPENDIRECTION: LEFT
• SOURCE: SRVASB
• STATUS: 1
• ACCESSIBILITY: ACCESSIBLE
• ENABLED: 1
• OWNERSHIP: MPW
• ROWSTAMP: 0
• ValveLocated: Y
• ValveRaising: Ok
• ValveExercised: N
• ValveBoxVacuum: Ok
• ValveProblems: No Problems

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 12/24/2025 3:33:52 AM

Schema Last Edit Date: 12/24/2025 3:33:52 AM

Data Last Edit Date: 12/23/2025 8:14:14 PM

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