Layer: System Valve (ID:7)

View In: Map Viewer

Name: System Valve

Display Field: name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description:

Copyright Text:

Min. Scale: 62982

Max. Scale: 0

Default Visibility: false

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","valueExpression":"//Arcade for wSystemValve\n//presentstatus: 1 = Open, 0 = Closed\n//lifecyclestatus: 1 = proposed, 8 = in service, \nvar status = $feature.presentstatus\nvar openText = ''\nif (status == 1){\n openText = 'Open'\n}else if(status == 0){\n openText = 'Closed'\n}\n\n//variable for lifecyclestatus values and empty variable for translation\nvar lifecycle = $feature.lifecyclestatus\nvar lifenew = ''\n//if statements for translation of lifecyclestatus\nif(lifecycle == 1){\n lifenew = 'Proposed'\n}else if(lifecycle == 8){\n lifenew = 'Active'\n}else if(lifecycle == 32){\n lifenew = 'Abandoned'\n}else if(lifecycle == 256){\n lifenew = 'Inactive'\n}\n\nif(lifenew == 'Abandoned'){\n return lifenew\n}else if(lifenew == 'Proposed'){\n return lifenew + \" - \" + openText\n}else if(lifenew == 'Active'){\n return lifenew + \" - \" + openText\n}else if(lifenew == 'Inactive'){\n return lifenew + \" - \" + openText\n}\n","valueExpressionTitle":"wSystemValve Symbology","uniqueValueGroups":[{"heading":"wSystemValve Symbology","classes":[{"label":"Abandoned","description":"Abandoned","symbol":{"type":"esriPMS","url":"4102822302da02871ec93b05853bb2eb","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABJElEQVQokWNhIBGwUKqBS0dHZx4fH58xExMT88ePH+/evXs3/tu3b8+waWCVlZW9HRQUJGViYgIWePHihWJtbe0tQUFBjadPnz5B0aCnpzc1NTVVatu2bQyioqIMfHx8DMuXL2dobW3lnjJlytKnT5/ao2hgZ2e3lJeXZ0hLS2OYPn06w/fv3xmysrIYuLm5Gfj5+VUxnMTIyAimP3z4wPD7928GDg4Ohvfv34M1MDAwMGFo4ODg2LFv3z6dCxcuMGRkZDCwsbExzJgxg8HOzo7h169flzE0HDp0qPT9+/dBfn5+SlxcXGAxT09PhsmTJ38SFBQMwRqsly9fVpaUlJx68OBBDwYGBmYmJqYLxsbGkatXr/6OKx4Ydu3alY0z1siJaQC17lyoJlBtswAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Abandoned"]]},{"label":"Active - Open","description":"Active - Open","symbol":{"type":"esriPMS","url":"13a26bd464566253c54cd6a895954768","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA3klEQVQokaXRsUpCARTG8R9qEBkh1BAOgmVQ4NbklARBOEqLU0Mt0dDkA/gEUnAjCBoEe4agwVcIoqV0k7JwqiGaii6X4KIO0rcc+A7/cz7OSZlSqf8Cc8quLNqUkPSm58G+oedxwIwNT+qyKpHTk7fjUca6rn4c2BY4lXWOHJbQQEfagbaurTiQVlLEGY7wgQtksGxtNFIiqq/4wjwGEfD9141tuNFSdIsAszhGLRxwPwpcq3tRdWLFQuT9Rjv0rmBv/Fk7VhUE2nbDsybdKatp+pz0By7DIBM19ad/ANMFKjSEr3/vAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Active - Open"]]},{"label":"Active - Closed","description":"Active - Closed","symbol":{"type":"esriPMS","url":"60e7daa7316e34c29c3519a9c7b91872","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA/klEQVQokZXRzyvDARjH8VdsfpSy8qPcdiA5SKiVk7NMjYN/Qu3koKa409rFReTHTXJx5CRFVtrFcaXVHHZYrMbBAX03qW+h9um5PE/Pu+fzPE9Ei4r8UuuNk+qir8xFnYc/gWnSg6wtMhTDNfUbru5ZxlsImCLZzvYC0eR3bZieIvMJzvLMhYBOsidEczhvTrOBLewxW2GyROEH6GcgSFaxjiPsI7A2Q3eBxRDw0QjKqGAMt5o+XtBBLWTpneIdiV1kg1NhE2245LXGYQiIsZTm8YBo0BwogxSfcXJ5qiHglKcVRrKcRxjtIvJMdZzMcWPvX/6wQwkTrX76X30BAP07VpKN1IYAAAAASUVORK5CYII=","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Active - Closed"]]},{"label":"Proposed - Open","description":"Proposed - Open","symbol":{"type":"esriPMS","url":"277f5430439946d7c349044d10210abe","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQokaWRvWrCABSFPxIL0ogEdBAHoW2ECtmcnAyCUBxLl0wOukgGpzyATyAKEUHoIMRnEBzyCoXioslW6g9OdRAni41LMCLSs1y4l+/eyzkRblTkv8C9pvGeSJAXBMT1Gm86pbrZ8B0G3OVyzE2TdKXiNzyPh3KZmSzz7Lp8BYBSCavTId3rQSYDySS0WuA4SLUatutSDACSREFVoduFRgO2W+j3QZYhlSJ79pIg+HW1gv0eYjFYLn3gcOA0DV4YD4eokwlYFkSjYBig638LPs+A0QhzseC12eQxHvd7x9fqdX4UhbdQWx2HJ0XBsm1ejraKIh+aht5us7uUA4MBxoXMwoFr+gUgaUTEPcGBBwAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Proposed - Open"]]},{"label":"Proposed - Closed","description":"Proposed - Closed","symbol":{"type":"esriPMS","url":"96c43bb0f3f149f744567746108cbfc5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGUlEQVQokaXRMUsCARjG8f/dqWhncZWDSAWWgZIOUUs0JEERDg3R4mSRDeLQ5BziB4iCiwOrIbDFL1BESER7FC6l0JCVEVEGiRTVcJPcSYTP8sILP3h5Hwv/jKVd0BEeYa/XyZgoID3VKBdviT1/cG8GrIE+blLzeCKj+qJcxTuT4Vrpxl+qcNcEpkOom0t4to9gwAWuTkjnobCOvKKRK1WYagKyjYlgP2wtQ2IH3uugrYIig1th2HCSKOiz+gaNT3Da4fFVBz/fiAYgOzjcPyV4fAlqHOxWSO5CdBIaX1wZwMEZqYcXFtYiDHY59F1iFuIaNV8Pi6ZvLRQZ8rlRc+fMiSBJAhfhcaIbeeqteiB7QrJFZ+bgr/wC64ZE4HHMrWEAAAAASUVORK5CYII=","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"values":[["Proposed - Closed"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriPMS","url":"4102822302da02871ec93b05853bb2eb","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABJElEQVQokWNhIBGwUKqBS0dHZx4fH58xExMT88ePH+/evXs3/tu3b8+waWCVlZW9HRQUJGViYgIWePHihWJtbe0tQUFBjadPnz5B0aCnpzc1NTVVatu2bQyioqIMfHx8DMuXL2dobW3lnjJlytKnT5/ao2hgZ2e3lJeXZ0hLS2OYPn06w/fv3xmysrIYuLm5Gfj5+VUxnMTIyAimP3z4wPD7928GDg4Ohvfv34M1MDAwMGFo4ODg2LFv3z6dCxcuMGRkZDCwsbExzJgxg8HOzo7h169flzE0HDp0qPT9+/dBfn5+SlxcXGAxT09PhsmTJ38SFBQMwRqsly9fVpaUlJx68OBBDwYGBmYmJqYLxsbGkatXr/6OKx4Ydu3alY0z1siJaQC17lyoJlBtswAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Abandoned","label":"Abandoned"},{"symbol":{"type":"esriPMS","url":"13a26bd464566253c54cd6a895954768","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA3klEQVQokaXRsUpCARTG8R9qEBkh1BAOgmVQ4NbklARBOEqLU0Mt0dDkA/gEUnAjCBoEe4agwVcIoqV0k7JwqiGaii6X4KIO0rcc+A7/cz7OSZlSqf8Cc8quLNqUkPSm58G+oedxwIwNT+qyKpHTk7fjUca6rn4c2BY4lXWOHJbQQEfagbaurTiQVlLEGY7wgQtksGxtNFIiqq/4wjwGEfD9141tuNFSdIsAszhGLRxwPwpcq3tRdWLFQuT9Rjv0rmBv/Fk7VhUE2nbDsybdKatp+pz0By7DIBM19ad/ANMFKjSEr3/vAAAAAElFTkSuQmCC","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Active - Open","label":"Active - Open"},{"symbol":{"type":"esriPMS","url":"60e7daa7316e34c29c3519a9c7b91872","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAAA/klEQVQokZXRzyvDARjH8VdsfpSy8qPcdiA5SKiVk7NMjYN/Qu3koKa409rFReTHTXJx5CRFVtrFcaXVHHZYrMbBAX03qW+h9um5PE/Pu+fzPE9Ei4r8UuuNk+qir8xFnYc/gWnSg6wtMhTDNfUbru5ZxlsImCLZzvYC0eR3bZieIvMJzvLMhYBOsidEczhvTrOBLewxW2GyROEH6GcgSFaxjiPsI7A2Q3eBxRDw0QjKqGAMt5o+XtBBLWTpneIdiV1kg1NhE2245LXGYQiIsZTm8YBo0BwogxSfcXJ5qiHglKcVRrKcRxjtIvJMdZzMcWPvX/6wQwkTrX76X30BAP07VpKN1IYAAAAASUVORK5CYII=","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Active - Closed","label":"Active - Closed"},{"symbol":{"type":"esriPMS","url":"277f5430439946d7c349044d10210abe","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABCUlEQVQokaWRvWrCABSFPxIL0ogEdBAHoW2ECtmcnAyCUBxLl0wOukgGpzyATyAKEUHoIMRnEBzyCoXioslW6g9OdRAni41LMCLSs1y4l+/eyzkRblTkv8C9pvGeSJAXBMT1Gm86pbrZ8B0G3OVyzE2TdKXiNzyPh3KZmSzz7Lp8BYBSCavTId3rQSYDySS0WuA4SLUatutSDACSREFVoduFRgO2W+j3QZYhlSJ79pIg+HW1gv0eYjFYLn3gcOA0DV4YD4eokwlYFkSjYBig638LPs+A0QhzseC12eQxHvd7x9fqdX4UhbdQWx2HJ0XBsm1ejraKIh+aht5us7uUA4MBxoXMwoFr+gUgaUTEPcGBBwAAAABJRU5ErkJggg==","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Proposed - Open","label":"Proposed - Open"},{"symbol":{"type":"esriPMS","url":"96c43bb0f3f149f744567746108cbfc5","imageData":"iVBORw0KGgoAAAANSUhEUgAAAAwAAAAMCAYAAABWdVznAAAACXBIWXMAAA7EAAAOxAGVKw4bAAABGUlEQVQokaXRMUsCARjG8f/dqWhncZWDSAWWgZIOUUs0JEERDg3R4mSRDeLQ5BziB4iCiwOrIbDFL1BESER7FC6l0JCVEVEGiRTVcJPcSYTP8sILP3h5Hwv/jKVd0BEeYa/XyZgoID3VKBdviT1/cG8GrIE+blLzeCKj+qJcxTuT4Vrpxl+qcNcEpkOom0t4to9gwAWuTkjnobCOvKKRK1WYagKyjYlgP2wtQ2IH3uugrYIig1th2HCSKOiz+gaNT3Da4fFVBz/fiAYgOzjcPyV4fAlqHOxWSO5CdBIaX1wZwMEZqYcXFtYiDHY59F1iFuIaNV8Pi6ZvLRQZ8rlRc+fMiSBJAhfhcaIbeeqteiB7QrJFZ+bgr/wC64ZE4HHMrWEAAAAASUVORK5CYII=","contentType":"image/png","width":9,"height":9,"angle":0,"xoffset":0,"yoffset":0},"value":"Proposed - Closed","label":"Proposed - Closed"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,218,215,255],"toColor":[252,218,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[179,252,189,255],"toColor":[179,252,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[201,179,252,255],"toColor":[201,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,230,252,255],"toColor":[182,230,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,248,184,255],"toColor":[252,248,184,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,218,255],"toColor":[252,182,218,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[212,252,233,255],"toColor":[212,252,233,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[225,210,252,255],"toColor":[225,210,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[249,184,252,255],"toColor":[249,184,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,179,255],"toColor":[252,179,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,210,255],"toColor":[252,238,210,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,252,204,255],"toColor":[220,252,204,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,195,252,255],"toColor":[182,195,252,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GLOBALID

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
ASSETGROUP (type: esriFieldTypeInteger, alias: Asset group, SQL Type: sqlTypeOther, nullable: false, editable: true)
ASSETTYPE (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true)
ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
ISSUBNETWORKCONTROLLER (type: esriFieldTypeSmallInteger, alias: Is subnetwork controller, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True])
ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True], [2: Unknown])
SUBNETWORKCONTROLLERNAME (type: esriFieldTypeString, alias: Subnetwork controller name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
TIERNAME (type: esriFieldTypeInteger, alias: Tier name, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: Unknown], [1: Water Cathodic Protection], [2: Water System], ... 3 more ...)
TIERRANK (type: esriFieldTypeInteger, alias: Tier rank, SQL Type: sqlTypeOther, nullable: false, editable: false)
TERMINALCONFIGURATION (type: esriFieldTypeString, alias: Terminal path, SQL Type: sqlTypeOther, length: 128, nullable: false, editable: true)
GLOBALID (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
cpsubnetworkname (type: esriFieldTypeString, alias: CP Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
SUPPORTEDSUBNETWORKNAME (type: esriFieldTypeString, alias: Supported subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
SUPPORTINGSUBNETWORKNAME (type: esriFieldTypeString, alias: Supporting subnetwork name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
PressureSubnetworkName (type: esriFieldTypeString, alias: Pressure Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
DMASubnetworkName (type: esriFieldTypeString, alias: DMA Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
creationdate (type: esriFieldTypeDate, alias: Creation date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
creator (type: esriFieldTypeString, alias: Creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
lastupdate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
updatedby (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
diameter (type: esriFieldTypeDouble, alias: diameter: Diameter, Diameter 1, Height, Inlet Diameter, Pipe Diameter, Weight, SQL Type: sqlTypeOther, nullable: true, editable: true)
secondarydiameter (type: esriFieldTypeDouble, alias: secondarydiameter: Diameter 2, Nozzle Diameter, Outlet Diameter, Width, SQL Type: sqlTypeOther, nullable: true, editable: true)
pressure (type: esriFieldTypeDouble, alias: pressure: Amperage, Pressure, Rated Pressure, Volume, SQL Type: sqlTypeOther, nullable: true, editable: true)
designtype (type: esriFieldTypeSmallInteger, alias: designtype: Anode Count, Design Type, Manufacturer, Pump Type, Test Wire Count, Valve Type, Wire Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
normalstatus (type: esriFieldTypeSmallInteger, alias: Normal Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
presentstatus (type: esriFieldTypeSmallInteger, alias: Present Status, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Closed], [1: Open])
additionaldetails (type: esriFieldTypeSmallInteger, alias: additionaldetails: Clockwise to Close, Cooling Method, Critical, Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
designinfo (type: esriFieldTypeDouble, alias: designinfo: Anode Depth, Rated Flow, Turns to Close, Voltage, SQL Type: sqlTypeOther, nullable: true, editable: true)
operable (type: esriFieldTypeSmallInteger, alias: Operable, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: False], [1: True])
name (type: esriFieldTypeString, alias: Name, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
accountid (type: esriFieldTypeString, alias: Account ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
additionaldevice (type: esriFieldTypeSmallInteger, alias: additionaldevice: Additional Device, Has Bypass, Internal Meter, Metered, SQL Type: sqlTypeOther, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
symbolrotation (type: esriFieldTypeSmallInteger, alias: Symbol Rotation, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 359])
lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
lifecyclestatus (type: esriFieldTypeSmallInteger, alias: Lifecycle Status, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 14 more ...)
bondedinsulated (type: esriFieldTypeSmallInteger, alias: Bonded/Insulated, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Bonded], [2: Insulated])
cptraceability (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Traceability, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
spatialsource (type: esriFieldTypeSmallInteger, alias: Spatial Source, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: As-Built], [2: CAD], ... 3 more ...)
spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
manufacturer (type: esriFieldTypeSmallInteger, alias: Manufacturer, SQL Type: sqlTypeOther, nullable: true, editable: true)
operator (type: esriFieldTypeSmallInteger, alias: Postindicator Valve, SQL Type: sqlTypeOther, nullable: true, editable: true)
GISOBJID (type: esriFieldTypeInteger, alias: GISOBJID, SQL Type: sqlTypeOther, nullable: true, editable: true)
LocationDescription (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MTUNumber (type: esriFieldTypeString, alias: MTU Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MTUInstallDate (type: esriFieldTypeDate, alias: MTU Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MeterNumber (type: esriFieldTypeString, alias: Meter Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MeterInstallDate (type: esriFieldTypeDate, alias: Meter Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
MeterStyle (type: esriFieldTypeString, alias: Meter Style, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Compound: Compound], [Displacement: Displacement], [Turbine: Turbine], ... 2 more ...)
MeterType (type: esriFieldTypeString, alias: Meter Type, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
MeterMake (type: esriFieldTypeString, alias: Meter Make, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Badger: Badger], [Hersey: Hersey], [Sensus: Sensus], ... 4 more ...)
BuryDepth (type: esriFieldTypeString, alias: Bury Depth, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ModelYear (type: esriFieldTypeString, alias: Model Year, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
InforLifecycleStatus (type: esriFieldTypeString, alias: Infor Lifecycle Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
UPDATE_COUNT (type: esriFieldTypeSmallInteger, alias: UPDATE_COUNT, SQL Type: sqlTypeOther, nullable: true, editable: true)
Elevation (type: esriFieldTypeDouble, alias: Elevation, SQL Type: sqlTypeOther, nullable: true, editable: true)
UpstreamPSIG (type: esriFieldTypeString, alias: UpstreamPSIG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
DownstreamPSIG (type: esriFieldTypeString, alias: DownstreamPSIG, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
ProjectNumber (type: esriFieldTypeString, alias: Project Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Clean_Route (type: esriFieldTypeString, alias: Clean_Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
HydrantInspection_Route (type: esriFieldTypeString, alias: HydrantInspection_Route, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
VALIDATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Validation status, SQL Type: sqlTypeOther, nullable: true, editable: false, 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 ...)

Templates:

ASSETGROUP: 0
ASSETTYPE: 0
TERMINALCONFIGURATION: Default
operable: 1
ownedby: 1
maintby: 1
lifecyclestatus: 0
cptraceability: 0

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 8/12/2026 10:33:48 AM

Schema Last Edit Date: 7/21/2026 1:46:33 PM

Data Last Edit Date: 8/12/2026 10:33:48 AM

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