Name: Service

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: 3466191

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

XMin: -119508221.287868
YMin: -97895201.6377498
XMax: 120508221.287948
YMax: 89777202.5655492
Spatial Reference: 103735 (103735)

Drawing Info:

{"renderer":{"authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[0,76,168,255],"toColor":[0,76,168,255]}]}},"type":"uniqueValue","field1":"assettype","fieldDelimiter":",","defaultSymbol":{"color":[255,255,255,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"defaultLabel":"Other","uniqueValueInfos":[{"label":"Unknown","symbol":{"color":[156,156,156,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"0"},{"label":"Residential Service","symbol":{"color":[0,77,168,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"11"},{"label":"Commercial Service","symbol":{"color":[0,197,255,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"12"},{"label":"Industrial Service","symbol":{"color":[0,77,168,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"13"},{"label":"Fire Service","symbol":{"color":[255,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"14"},{"label":"Hydrant Service","symbol":{"color":[168,0,0,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"15"},{"label":"Irrigation Service","symbol":{"color":[197,0,255,255],"width":1,"type":"esriSLS","style":"esriSLSLongDashDot"},"value":"16"},{"label":"Sampling Service","symbol":{"color":[0,77,168,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"17"},{"label":"Blow Off Service","symbol":{"color":[0,77,168,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"18"},{"label":"Air and Vacuum Service","symbol":{"color":[0,77,168,255],"width":1,"type":"esriSLS","style":"esriSLSSolid"},"value":"19"}]},"labelingInfo":[{"labelExpression":null,"labelExpressionInfo":{"expression":"$feature[\"diameter\"]\nDomainName($feature,\"diameter\")"},"fieldInfos":[{"fieldName":"diameter","format":{"places":6,"digitSeparator":false}},{"fieldName":"diameter","format":{"places":6,"digitSeparator":false}}],"useCodedValues":true,"maxScale":0,"minScale":0,"where":null,"labelPlacement":"esriServerLinePlacementAboveAlong","symbol":{"color":[255,255,255,255],"type":"esriTS","haloSize":0,"haloColor":null,"horizontalAlignment":"center","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"text":"","rotated":false,"kerning":true,"font":{"size":9,"style":"normal","decoration":"none","weight":"bold","family":"Arial"}}}],"transparency":0}

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:

• assettype (type: esriFieldTypeSmallInteger, alias: Asset type, SQL Type: sqlTypeOther, nullable: false, editable: true, Coded Values: [0: Unknown], [11: Residential Service], [12: Commercial Service], ... 7 more ...)
• 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, Coded Values: [0: Unknown], [0.5: 1/2"], [0.75: 3/4"], ... 13 more ...)
• material (type: esriFieldTypeSmallInteger, alias: Material, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [83: Cast Iron - CAS], [84: Copper - COP], ... 3 more ...)
• designtype (type: esriFieldTypeSmallInteger, alias: Water Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Potable], [2: Irrigation], ... 4 more ...)
• installdate (type: esriFieldTypeDate, alias: Install Date, 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 ...)
• 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)
• 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])
• notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
• measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
• adddetails (type: esriFieldTypeSmallInteger, alias: Tracer Wire, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: Yes], [2: No])
• 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 ...)
• OBJECTID (type: esriFieldTypeOID, alias: Object ID, SQL Type: sqlTypeOther, length: 0, 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)
• globalid (type: esriFieldTypeGlobalID, alias: Global ID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
• Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

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: ownedby
  Inherited
  
• Field Name: maintby
  Inherited
  
• Field Name: adddetails
  Inherited
  
• Field Name: spatialsource
  Inherited
  
• Field Name: spatialconfidence
  Inherited
  
Templates:

Name: Unknown
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 11
Name: Residential Service
Domains:

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

Name: Residential Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

• ownedby: 1
• diameter: 0
• material: 0
• adddetails: 0
• spatialsource: 0
• spatialconfidence: 0
• lifecyclestatus: 8
• maintby: 1
• assettype: 11
• designtype: 1
Name: Residential Service - Private
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 12
Name: Commercial Service
Domains:

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

Name: Commercial Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 13
Name: Industrial Service
Domains:

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

Name: Industrial Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 14
Name: Fire Service
Domains:

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

Name: Fire Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 15
Name: Hydrant Service
Domains:

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

Name: Hydrant Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 16
Name: Irrigation Service
Domains:

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

Name: Irrigation Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 17
Name: Sampling Service
Domains:

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

Name: Sampling Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 18
Name: Blow Off Service
Domains:

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

Name: Blow Off Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

ID: 19
Name: Air and Vacuum Service
Domains:

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

Name: Air and Vacuum Service
Description:
Drawing Tool: esriFeatureEditToolLine
Prototype:

Attributes:

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

---

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/12/2025 2:29:46 PM

Schema Last Edit Date: 6/12/2025 2:29:46 PM

Data Last Edit Date: 6/12/2025 2:29:46 PM

Supported Operations:   Query   Query Pivot   Query Top Features   Query Analytic   Query Bins   Query Attachments   Add Features   Update Features   Delete Features   Apply Edits   Calculate   Generate Renderer   Validate SQL   Get Estimates   ConvertFormat