Name: Water Service

Display Field: assetid

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: Water Line

Copyright Text:

Min. Scale: 5000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: 1565122.92900631
YMin: 516393.60298489
XMax: 1574371.30060139
YMax: 522186.187200233
Spatial Reference: 102700 (102700)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"ASSETTYPE","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[115,178,255,255],"width":1},"defaultLabel":"Other","uniqueValueGroups":[{"heading":"Asset type","classes":[{"label":"Residential Service","description":"Residential Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":1},"values":[["11"]]},{"label":"Institutional Service","description":"Institutional Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"values":[["21"]]},{"label":"Industrial Service","description":"Industrial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,132,168,255],"width":1},"values":[["13"]]},{"label":"Fire Service","description":"Fire Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"values":[["14"]]},{"label":"Hydrant Service","description":"Hydrant Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"values":[["15"]]},{"label":"Irrigation Service","description":"Irrigation Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"values":[["16"]]},{"label":"Commercial Service","description":"Commercial Service","symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[68,137,112,255],"width":1},"values":[["12"]]}]}],"uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,92,230,255],"width":1},"value":"11","label":"Residential Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,38,115,255],"width":1},"value":"21","label":"Institutional Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,132,168,255],"width":1},"value":"13","label":"Industrial Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"value":"14","label":"Fire Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[168,0,0,255],"width":1.5},"value":"15","label":"Hydrant Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":1},"value":"16","label":"Irrigation Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[68,137,112,255],"width":1},"value":"12","label":"Commercial Service"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[0,76,168,255],"toColor":[0,76,168,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}

HasZ: true

HasM: true

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field:

Type ID Field: ASSETTYPE

Fields:

• 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)
• assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true)
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true)
• designtype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true)
• measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, 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 ...)
• ownedby (type: esriFieldTypeSmallInteger, alias: Owned By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Private], [100: Other], [1: MSU], ... 1 more ...)
• maintby (type: esriFieldTypeSmallInteger, alias: Maintained By, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [2: Private], [100: Other], [1: MSU], ... 1 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• 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], ... 4 more ...)
• spatialconfidence (type: esriFieldTypeSmallInteger, alias: Spatial Confidence, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: High], [2: Medium], ... 1 more ...)
• adddetails (type: esriFieldTypeSmallInteger, alias: Additional Details, SQL Type: sqlTypeOther, nullable: true, editable: true)
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• 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])
• cpoverride (type: esriFieldTypeSmallInteger, alias: Cathodic Protection Override, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Traceable], [2: Not Traceable])
• accesstype (type: esriFieldTypeSmallInteger, alias: Access Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Surface], [2: Tunnel], ... 1 more ...)
• ASSOCIATIONSTATUS (type: esriFieldTypeSmallInteger, alias: Association status, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: None], [1: Container], [2: Structure], ... 33 more ...)
• ISCONNECTED (type: esriFieldTypeSmallInteger, alias: Is connected, SQL Type: sqlTypeOther, nullable: false, editable: false, Coded Values: [0: False], [1: True], [2: Unknown])
• SystemSubnetworkName (type: esriFieldTypeString, alias: System Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• FROMDEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: From device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 31 more ...)
• TODEVICETERMINAL (type: esriFieldTypeSmallInteger, alias: To device terminal, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: None], [1: Single Terminal], [2: High Pressure In], ... 31 more ...)
• 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)
• IsolationSubnetworkName (type: esriFieldTypeString, alias: Isolation Subnetwork Name, SQL Type: sqlTypeOther, length: 2000, nullable: false, editable: false)
• cpsubnetworkname (type: esriFieldTypeString, alias: CP 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)
• 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)
• 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 ...)
• GLOBALID (type: esriFieldTypeGUID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

ID: 11
Name: Residential Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 11
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 11
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 21
Name: Institutional Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 21
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 21
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 13
Name: Industrial Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 13
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 13
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 14
Name: Fire Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 14
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 14
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 15
Name: Hydrant Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 15
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 15
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 16
Name: Irrigation Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 16
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 16
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

ID: 12
Name: Commercial Service
Domains:

• Field Name: lifecyclestatus
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
• Field Name: bondedinsulated
  Inherited
  
• Field Name: cptraceability
  Inherited
  
• Field Name: cpoverride
  Inherited
  
• Field Name: accesstype
  Inherited
  
• Field Name: ASSOCIATIONSTATUS
  Inherited
  
• Field Name: ISCONNECTED
  Inherited
  
• Field Name: FROMDEVICETERMINAL
  Inherited
  
• Field Name: TODEVICETERMINAL
  Inherited
  
• Field Name: VALIDATIONSTATUS
  Inherited
  
Templates:

Name: 12
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• FROMDEVICETERMINAL: 0
• ASSETGROUP: 0
• ASSETTYPE: 12
• lifecyclestatus: 0
• ownedby: 1
• maintby: 1
• cptraceability: 0
• accesstype: 0
• TODEVICETERMINAL: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 9/18/2024 8:48:44 PM

Schema Last Edit Date: 9/18/2024 8:48:44 PM

Data Last Edit Date: 9/18/2024 8:48:44 PM

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