Name: Water System Valves
Display Field: FACILITYID
Type: Feature Layer
Geometry Type: esriGeometryPoint
Is View: true
Is Updatable View: true
Source Schema Changes Allowed: true
Sources
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: 12646866.7845511
YMin: 295141.172702701
XMax: 12658271.8300525
YMax: 305063.481570403
Spatial Reference: 2253 (2253)
Drawing Info:
{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"6524a110c44525300eb5fa01f979fab6","imageData":"iVBORw0KGgoAAAANSUhEUgAAAA4AAAAOCAYAAAAfSC3RAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABZ0lEQVQoka3STyjDcRjH8ff8ZqERsWgjaTKlxFZSOKyRpDgSixyUHOSClj9Ryt9aXJekzJ+csAglJdQipN9OkqOEbGwzTA4LrV9zkO/p6el59Xzq+cr545P/N8wiNaMYv/sBj2cf8P0OlUoVeSV2qlsKyS9NwesOsjF3yeneIi7nUCQoo8DooKy2CFNdqKPSCLT063h96UUmCIhHA1KoN1rosBp4foSteag0g+8Jlq3QPhbN7HAT4tHoV+wfmJ5tRKMVvpazZoP7G2jsBkUMVNRncrxTjcu5Eg5jlXHftUYL23bIzA0hgLh4UCamSaN6Hm75CILvGVamoW0Eri5gcw6qmsHlfCfg3ZVCuaKPJauJgD8ecw9EK0BnCMV2zMDJrovzA1EK120iNa3j5BRaEOQ/sZNUIDqviVLURjoHrNmGaehyMNU5SUKymuDbC493h+jVHQwOfkSGAAsTZ0B5WG9VMvX3v/oJX9Bq7tOpOsgAAAAASUVORK5CYII=","contentType":"image/png","width":10,"height":10,"angle":0,"xoffset":0,"yoffset":0}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: false
HasM: false
Has Attachments: true
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field: GlobalID
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- FACILITYID (type: esriFieldTypeString, alias: Facility Identifier, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
- ROTATION (type: esriFieldTypeDouble, alias: Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
- DIAMETER (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.75: 3/4"], [1: 1"], [1.25: 1 1/4"], ... 27 more ...)
- VALVETYPE (type: esriFieldTypeString, alias: Valve Type, SQL Type: sqlTypeOther, length: 30, nullable: true, editable: true, Coded Values: [Ball: Ball], [Butterfly: Butterfly], [Cone: Cone], ... 5 more ...)
- BYPASSVALVE (type: esriFieldTypeSmallInteger, alias: Bypass Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- CLOCKTOCLOSE (type: esriFieldTypeSmallInteger, alias: Clockwise To Close, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- NORMALLYOPEN (type: esriFieldTypeSmallInteger, alias: Normally Open, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- TURNSTOCLOSE (type: esriFieldTypeInteger, alias: Turns To Close, SQL Type: sqlTypeOther, nullable: true, editable: true)
- OPERABLE (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- HYDRFLAG (type: esriFieldTypeSmallInteger, alias: Hydrant Valve, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
- CURROPEN (type: esriFieldTypeSmallInteger, alias: Currently Open, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- ACTIVEFLAG (type: esriFieldTypeSmallInteger, alias: Active Flag, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
- OWNEDBY (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [-2: Other], [1: City of Bangor])
- MAINTBY (type: esriFieldTypeSmallInteger, alias: Managed By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [-1: Private], [-2: Other], [1: City of Bangor])
- LifeCycleStatus (type: esriFieldTypeString, alias: Life Cycle Status, SQL Type: sqlTypeOther, length: 14, nullable: true, editable: true, Coded Values: [Abandoned: Abandoned], [In Service: In Service], [Out of Service: Out of Service], ... 1 more ...)
- Notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
- 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)
- VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No calculation required, no validation required, no error], [1: No calculation required, no validation required, has error(s)], [2: No calculation required, validation required, no error], ... 5 more ...)
- LocationPlacement (type: esriFieldTypeString, alias: Location Placement, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true, Coded Values: [GPS: GPS])
Templates:
Name: wSystemValve
Description:
Drawing Tool: esriFeatureEditToolPoint
Prototype:
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 7/21/2025 12:38:14 PM
Schema Last Edit Date: 11/14/2024 1:18:28 PM
Data Last Edit Date: 11/14/2024 1:18:28 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Query Attachments
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat