Name: Water Main

Display Field: assettype

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

Min. Scale: 80000

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -10621333.9429519
YMin: 3440523.02140198
XMax: -10587759.637917
YMax: 3507768.60548875
Spatial Reference: 102100 (3857)

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","defaultSymbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,255,255,255],"width":1},"defaultLabel":"Other","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[130,130,130,255],"width":2},"value":"0","label":"Unknown"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,77,168,255],"width":2},"value":"1","label":"Transmission Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":2},"value":"2","label":"Distribution Main"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":2},"value":"3","label":"Production"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[169,0,230,255],"width":2},"value":"5","label":"Overflow"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,115,223,255],"width":2},"value":"4","label":"Drain"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[209,252,192,255],"toColor":[209,252,192,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[218,179,252,255],"toColor":[218,179,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,200,189,255],"toColor":[252,200,189,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,234,252,255],"toColor":[202,234,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,246,212,255],"toColor":[252,246,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,207,241,255],"toColor":[252,207,241,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,234,255],"toColor":[187,252,234,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,194,252,255],"toColor":[182,194,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,251,179,255],"toColor":[252,251,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[210,215,252,255],"toColor":[210,215,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,184,240,255],"toColor":[252,184,240,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,207,255],"toColor":[252,187,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,222,179,255],"toColor":[252,222,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"domainName($feature, 'diameter') + \" \" + Trim(Split(domainName($feature, 'material'),'-')[-1])"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"assettype = 1","useCodedValues":true,"maxScale":0,"minScale":10000,"name":"Transmission Main","priority":-1,"symbol":{"type":"esriTS","color":[0,77,168,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":0.5,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"domainName($feature, 'diameter') + \" \" + Trim(Split(domainName($feature, 'material'),'-')[-1])"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"assettype = 2","useCodedValues":true,"maxScale":0,"minScale":7500,"name":"Distribution Main","priority":-1,"symbol":{"type":"esriTS","color":[0,112,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":9,"style":"normal","weight":"bold","decoration":"none"}}},{"labelExpressionInfo":{"expression":"domainName($feature, 'diameter') + \" \" + Trim(Split(domainName($feature, 'material'),'-')[-1])"},"labelPlacement":"esriServerLinePlacementAboveAlong","textLayout":"straight","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackRowLength":24,"stackAlignment":"dynamic","removeDuplicates":"none","where":"assettype = 3","useCodedValues":true,"maxScale":0,"minScale":0,"name":"Production","priority":-1,"symbol":{"type":"esriTS","color":[0,197,255,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[255,255,255,255],"haloSize":1,"font":{"family":"Tahoma","size":9,"style":"normal","weight":"bold","decoration":"none"}}}]}

HasZ: true

HasM: true

Has Attachments: true

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Name : OBJECTID

IsSystemMaintained : True

Global ID Field: globalid

Type ID Field: assettype

Fields:

• OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
• assettype (type: esriFieldTypeSmallInteger, alias: assettype, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [2: Distribution Main], [4: Drain], ... 3 more ...)
• assetid (type: esriFieldTypeString, alias: assetid, SQL Type: sqlTypeOther, length: 64, nullable: true, editable: true)
• diameter (type: esriFieldTypeDouble, alias: diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [4: 4"], [6: 6"], ... 19 more ...)
• material (type: esriFieldTypeSmallInteger, alias: material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [81: Asbestos Cement - AC], [82: Brick - BR], ... 26 more ...)
• designtype (type: esriFieldTypeSmallInteger, alias: designtype, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Potable], [2: Irrigation], ... 4 more ...)
• installdate (type: esriFieldTypeDate, alias: installdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• lifecyclestatus (type: esriFieldTypeSmallInteger, alias: lifecyclestatus, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [1: Proposed], [2: Approved], ... 7 more ...)
• notes (type: esriFieldTypeString, alias: notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• measuredlength (type: esriFieldTypeDouble, alias: measuredlength, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adddetails (type: esriFieldTypeSmallInteger, alias: adddetails, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• inservicedate (type: esriFieldTypeDate, alias: inservicedate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• retireddate (type: esriFieldTypeDate, alias: retireddate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• ownedby (type: esriFieldTypeSmallInteger, alias: ownedby, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• maintby (type: esriFieldTypeSmallInteger, alias: maintby, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Our Agency], [2: Private], [100: Other])
• globalid (type: esriFieldTypeGlobalID, alias: globalid, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• creationdate (type: esriFieldTypeDate, alias: creationdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• creator (type: esriFieldTypeString, alias: creator, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• lastupdate (type: esriFieldTypeDate, alias: lastupdate, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
• updatedby (type: esriFieldTypeString, alias: updatedby, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: true)
• Alias_ID (type: esriFieldTypeString, alias: Alias_ID, SQL Type: sqlTypeOther, length: 256, nullable: true, editable: true)
• LAT (type: esriFieldTypeInteger, alias: LAT, SQL Type: sqlTypeOther, nullable: true, editable: true)

Types:

ID: 0
Name: Unknown
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 0
• adddetails: 0
• ownedby: 1
• lifecyclestatus: 8
• designtype: 1
• cptraceability: 0
• diameter: 0
• material: 0
• maintby: 1
• spatialsource: 0
• spatialconfidence: 0

---

ID: 1
Name: Transmission Main
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Transmission Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• designtype: 1
• assettype: 1
• adddetails: 0
• ownedby: 1
• lifecyclestatus: 8
• cptraceability: 0
• diameter: 0
• material: 0
• maintby: 1
• spatialsource: 0
• spatialconfidence: 0

---

ID: 2
Name: Distribution Main
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Distribution Main
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 2
• adddetails: 0
• ownedby: 1
• lifecyclestatus: 8
• designtype: 1
• cptraceability: 0
• diameter: 0
• material: 0
• maintby: 1
• spatialsource: 0
• spatialconfidence: 0

---

ID: 3
Name: Production
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Production
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• assettype: 3
• adddetails: 0
• ownedby: 1
• lifecyclestatus: 8
• designtype: 0
• cptraceability: 0
• diameter: 0
• material: 0
• maintby: 1
• spatialsource: 0
• spatialconfidence: 0

---

ID: 5
Name: Overflow
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Overflow
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• spatialsource: 0
• adddetails: 0
• ownedby: 1
• assettype: 5
• lifecyclestatus: 8
• designtype: 1
• diameter: 0
• material: 0
• maintby: 1
• spatialconfidence: 0

---

ID: 4
Name: Drain
Domains:

• Field Name: assettype
  Inherited
  
• Field Name: diameter
  Inherited
  
• Field Name: material
  Inherited
  
• Field Name: designtype
  Inherited
  
• Field Name: lifecyclestatus
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Drain
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• spatialsource: 0
• adddetails: 0
• ownedby: 1
• assettype: 4
• lifecyclestatus: 8
• designtype: 1
• diameter: 0
• material: 0
• maintby: 1
• spatialconfidence: 0

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 7/18/2025 8:22:44 PM

Schema Last Edit Date: 5/15/2024 2:51:18 PM

Data Last Edit Date: 7/18/2025 8:22:44 PM

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