Name: WaterValve

Display Field:

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 288896

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10257614.3126341
YMin: 5884047.98321746
XMax: -10241100.5563631
YMax: 5900895.92176695
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"simple","symbol":{"type":"esriPMS","url":"OrangeSphere.png","imageData":"iVBORw0KGgoAAAANSUhEUgAAAEAAAABACAYAAACqaXHeAAAABGdBTUEAALGPC/xhBQAAACBjSFJNAAB6JgAAgIQAAPoAAACA6AAAdTAAAOpgAAA6mAAAF3CculE8AAAACXBIWXMAAA7DAAAOwwHHb6hkAAAAGXRFWHRTb2Z0d2FyZQBQYWludC5ORVQgdjMuNS4xTuc4+QAABv9JREFUeF7tl31UVVUaxk/34uXCBeTjqqXQoA1oGgqOOprlFwKKOpqCCq4IyEJL1CEmyxUijkjDOBAGFgM6qSz8KPEbCQQFP2JQhmwmhmlVSwvTIbgIJOLl7vPMc8U/5v+Ll382az1rn7PP3ft9n99+9z4HRZF/koAkIAlIApKAJCAJSAKSgCQgCUgCkoAkIAlIApKAJCAJPH4CrqtHKN7bntX5pY7R+a8drvgwpNvjDzuwEbTpzyovHgvRp5ye73Tm6jJDU9Mq19tWXVtuaDoRbigtCXXekhGgzGCaDgObaj9HXzxYCawId9r7nxiXNvzBA0jxgiXVC72PZEkxAu8NAZKN+PZl97byeYZ9q55SJvZzGgMzXepYJboxyvCd+rYH1G1G9GQMg/kDb6i7R0L9+Jk+5Y5Cb9av0LN9OLDlKYikofhmpduNnRM0qwYm636K+sexStx3cW7tSPOGOcsPlsJA4OBvgU+nAiXUsenUi8BR6hBVNB0ifxLMmeNYEb5ojjV2ZARoVvdTOvad5tWRSsj38cY7oBlzPk0X0+zRF4CTNFo6GygPAT6fC5ydyftZwKlg4Dh1ZA6wbxbMufxt+gT8FDvs53f8lHD7Zm9jtHkuypC6COMV7PwNHuQ/32e+hMbPUFWLgNoEoD4ZuJoI1EQCFTRdRihnCOQEwRxhu28OHuSyL30K6pcZ62I8lRE2pmW/4e8HOa3r2MyVz6PxA1bzM4DTNF8Z3mf8273AjyeB74uBr9IIYRkrgpVQxgooDWUlhHGrsN1DCNmz0fP7Mdg9Wf+W/RzYFslwPdL9ssicDFFI84dp/iRLvIztpWigaRfQegW4/wPUuw1Qb+yDWr+OlUHD1io4ywo4NZ/bhbCKwtCbx+rYEoSr4Yb6UDfF07bU7DB6povyQnO8Vxv+MgHqfpo+ai3tRwBq42i4EKKzDkL8CNFzHaLlMMQ3qRDXYqBeXsrtsIDVMo9VwPYgIewJgznlObRFOPYk+ioz7WDBthBZ4x0Sb672EmqGL7Cf+/8493PpHKjn50NcXwtxcxdE6wlCqIZoL4No/itE0yaIL1+lXoOoI6TKCI7jWXFkMVAQDMvb3miN0GLHWCXJtuzsMPpssNP7pjeHQk3nOz3fj6+8aVzVcIj6WIivEmj2XYgb2X3Gb+Zy9bewfw1EQxz1OsQ/3iSENVBLeTgWEV7OeFiSvHA3UouDU5QcO1iwLcT5UOeczsRhUHd4A3kjeQiO4erPY4lHUdE0SRD/osmvk6gNrApCsZqvp67FP6wAURsL9RwPxr1TgJ2jITa4o2O5BiXTlQLbsrPD6PJgpz+1v0EA232AD0dBPTwJonoBxGVWwRXqC17XLoL4+++oxdQS6iX2U1eoi7yvZlsVCbWIZ8eOZyDWOOHuCg0OPf/Eh3awYFuIvCBN0s04o4o0AsgmgJKZNERTF2n40kKC4FnwUGGPxOqw3l/kM+tvapZCnI+EqFwJ9RDfDClPojdOi9aVDtgZ6PCObdnZYfQiTyXkhyi3DmweAWTye59vAXGeK1rN1X4IgatvBXGJlfBQ1mv21fB5Nc1fiKD55RDlBHCA3wYbnfEgRoO2aEfzhtHaMDtYsDmE+78X6hp61xkh0nwhiqfCfC4E5iqqei7MNcEwX/w/We9r2F8dCjPPCnPVApgrFsLMT2NLrj8sq7Xojdfh66WOjYtGGobZnJ09JsgNUDZ3Relh3jgEvR+NRnfpRHSXT0J35WR0X2BrVfUjXbD2TUF31VQ+n4buCupkILqLfWHe6oKe+EGwJDjjk1m6VOausUf+NscI9VB8GoKVf+IVR9zfZMQvxaPQeXocOs9OQGd5IDorgtBZSZ2b2KcKqpwq5fOSX6PzwFB05bngfqIOWGfAlyv1jbGjFD+bE7PnBBnjlGV3Fj7RpcYMQud7g2Ha/zRMn46G6VgATKcCYToTBNPpiRSvj7PvM3+YinxgKvSEabcrxzhDrDegda3TvYLZmmh75t5fsbRZ45Xklpc0PXhZg/ZNzvhvrhEthcPR8ren0bLft0+f+LDvSbTke6Elzx13dg1G+1Y3iGQXmDY4mwvCHN5lQtr+Ssre8zhkB2rWNy9x+NkS44DujXrc3uaK5j+741a2B259QOVQvG7O8sDtTA/cSxsMy2ZX3FqvN+0J1Vj/Axxk76T7Pd4b/kpw7fxBZc0rHH9RE5ygbnJF11Zui+0eMO3wRFeGJ0S6O9/5LvjpLed7dfG68uQAZW6/JzLAExq2BWgjGpboCupX6L+oj3JsbozRdzTGOXU0xOlvXU3Q115/Xbcnc5o2knm6DHCujz38iNf8lck5M7SzrVrLa0b0fuxRZQBJQBKQBCQBSUASkAQkAUlAEpAEJAFJQBKQBCQBSUAS+B/qhLD6M6wGWAAAAABJRU5ErkJggg==","contentType":"image/png","width":15,"height":15}}}

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)
• ANCILLARYROLE (type: esriFieldTypeSmallInteger, alias: ANCILLARYROLE, SQL Type: sqlTypeOther, nullable: true, editable: true)
• ENABLED (type: esriFieldTypeSmallInteger, alias: ENABLED, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: False], [1: True])
• CREATIONUSER (type: esriFieldTypeString, alias: Creation User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• DATECREATED (type: esriFieldTypeDate, alias: Date Created, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• DATEMODIFIED (type: esriFieldTypeDate, alias: Date Modified, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
• LASTUSER (type: esriFieldTypeString, alias: Last User, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: false)
• LOCATION (type: esriFieldTypeString, alias: LOCATION, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• CONDITION (type: esriFieldTypeString, alias: CONDITION, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CONDITIONDATE (type: esriFieldTypeDate, alias: Condition Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSTALLDATE (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• LIFECYCLESTATUS (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [PROP: Proposed], [ACT: Active], [ABN: Abandoned], ... 1 more ...)
• WORKORDERID (type: esriFieldTypeString, alias: Work Order ID, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• ELEVATION (type: esriFieldTypeDouble, alias: ELEVATION, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTYPE (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [POT: Potable Water], [RAW: Raw Water])
• SYMBOLROTATION (type: esriFieldTypeDouble, alias: SymbolRotation, SQL Type: sqlTypeOther, nullable: true, editable: true)
• WATERTRACEWEIGHT (type: esriFieldTypeInteger, alias: Water Trace Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
• SUBTYPECD (type: esriFieldTypeInteger, alias: Subtype, SQL Type: sqlTypeOther, nullable: true, editable: true)
• VALVENUMBER (type: esriFieldTypeString, alias: VALVENUMBER, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• BONDEDINDICATOR (type: esriFieldTypeString, alias: Bonded Indicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• CPSYSTEMSTATUS (type: esriFieldTypeInteger, alias: CP System Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• EMERISOLATIONSYSSTATUS (type: esriFieldTypeString, alias: Emergency Isolation System Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• MATERIAL (type: esriFieldTypeString, alias: MATERIAL, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [DI: Ductile Iron], [CI: Cast Iron], [PVC: Polyvinylchloride], ... 7 more ...)
• NORMALPOSITION (type: esriFieldTypeInteger, alias: Normal Position, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
• OPERATINGCLASSIFICATION (type: esriFieldTypeString, alias: Operating Classification, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [CIR: Critical/Inspection Required], [CINR: Critical/Inspection Not Required], [NC: Non-Critical])
• WATERPRESSURESYSTEMSTATUS (type: esriFieldTypeInteger, alias: Water Pressure System Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Not Barrier], [1: Barrier])
• WATERSYSTEMSTATUS (type: esriFieldTypeString, alias: Water System Status, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• CROSSOVERVALVE (type: esriFieldTypeInteger, alias: Cross Over Valve Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• CLOCKWISETOCLOSEINDICATOR (type: esriFieldTypeInteger, alias: Clockwise to Close Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• MOTORIZEDINDICATOR (type: esriFieldTypeInteger, alias: Motorized Indicator, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: No], [1: Yes])
• PRESSURESETTING (type: esriFieldTypeString, alias: Pressure Setting, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
• INSULATEDINDICATOR (type: esriFieldTypeString, alias: InsulatedIndicator, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• STATUS (type: esriFieldTypeString, alias: Status, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [OFF: Offline], [ONL: Online], [UNK: Unknown])
• MAPNUM (type: esriFieldTypeString, alias: MAPNUM, SQL Type: sqlTypeOther, length: 16, nullable: true, editable: true)
• HYDRANTVALVE (type: esriFieldTypeString, alias: HydrantValve, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• FLUSHVALVE (type: esriFieldTypeString, alias: FlushValve, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• CURBSTOP (type: esriFieldTypeString, alias: CurbStop, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• MAINLINE (type: esriFieldTypeString, alias: MainLine, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• TAPPING (type: esriFieldTypeString, alias: Tapping, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• CORPORATION (type: esriFieldTypeString, alias: Corporation, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• VALVEACCESS (type: esriFieldTypeString, alias: ValveAccess, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [VAULT: In Vault], [MANH: In Manhole], [BOX: Valve Box], ... 1 more ...)
• LABELTEXT (type: esriFieldTypeString, alias: LABELTEXT, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• OPERABLE (type: esriFieldTypeString, alias: Operable, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• DIAMETER (type: esriFieldTypeDouble, alias: DIAMETER, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: 1''], [1.25: 1-1/4"], [1.5: 1-1/2''], ... 18 more ...)
• TURNSTOCLOSE (type: esriFieldTypeString, alias: TURNSTOCLOSE, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
• SYSTEMVALVETYPE (type: esriFieldTypeString, alias: SystemValveType, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Ball: Ball Valve], [Butterfly: Butterfly], [Globe: Globe], ... 3 more ...)
• GPS_LAT (type: esriFieldTypeDouble, alias: GPS_LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GPS_LONG (type: esriFieldTypeDouble, alias: GPS_LONG, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LINKEDDOC (type: esriFieldTypeString, alias: Linked Documents, SQL Type: sqlTypeOther, length: 128, nullable: true, editable: true)
• INSPECTIONDATE (type: esriFieldTypeDate, alias: Inspection Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• INSPECTED (type: esriFieldTypeString, alias: INSPECTED, SQL Type: sqlTypeOther, length: 3, nullable: true, editable: true, Coded Values: [N: No], [Y: Yes])
• ServerOID (type: esriFieldTypeInteger, alias: ServerOID, SQL Type: sqlTypeOther, nullable: true, editable: true)
• GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• INSPDAYS (type: esriFieldTypeInteger, alias: Days since inspection, SQL Type: sqlTypeOther, nullable: true, editable: true)
• LASTINSPGUID (type: esriFieldTypeGUID, alias: LASTINSPGUID, SQL Type: sqlTypeOther, length: 38, nullable: true, editable: true)
• INSPBY (type: esriFieldTypeString, alias: Inspected by, SQL Type: sqlTypeOther, length: 25, nullable: true, editable: true)

Templates:

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

Attributes:

• ENABLED: 1
• LIFECYCLESTATUS: ACT
• WATERTYPE: POT
• SYMBOLROTATION: 0
• SUBTYPECD: 6
• CPSYSTEMSTATUS: 1
• NORMALPOSITION: 1
• CROSSOVERVALVE: 0
• CLOCKWISETOCLOSEINDICATOR: 1
• MOTORIZEDINDICATOR: 0

Relationships:

• WaterValve_InspectionValve (1) -- Related To: InspectionValve (5)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 11/14/2023 7:32:09 PM

Schema Last Edit Date: 10/27/2023 7:21:19 PM

Data Last Edit Date: 11/14/2023 7:32:09 PM

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