Layer: Service (ID:15)

View In: Map Viewer

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

Max. Scale: 0

Default Visibility: true

Max Record Count: 2000

Supported query Formats: JSON, geoJSON, PBF

Use Standardized Queries: True

Extent:

Drawing Info:

{"renderer":{"type":"uniqueValue","field1":"assettype","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[255,0,0,255],"width":1},"value":"Fire Service","label":"Fire Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[112,68,137,255],"width":1},"value":"Hydrant Service","label":"Hydrant Service"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[202,122,245,255],"width":1},"value":"Service","label":"Service"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,211,252,255],"toColor":[187,211,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[194,252,179,255],"toColor":[194,252,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,196,179,255],"toColor":[252,196,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,187,247,255],"toColor":[252,187,247,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[187,252,248,255],"toColor":[187,252,248,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,238,179,255],"toColor":[252,238,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[188,182,252,255],"toColor":[188,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,204,225,255],"toColor":[252,204,225,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[220,252,212,255],"toColor":[220,252,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[204,240,252,255],"toColor":[204,240,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[230,212,252,255],"toColor":[230,212,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,229,212,255],"toColor":[252,229,212,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,189,255],"toColor":[252,179,189,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":null}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field: GlobalID

Type ID Field: assettype

Fields:

assettype (type: esriFieldTypeString, alias: Asset type, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [Fire Service: Fire Service], [Hydrant Service: Hydrant Service], [Service: Service])
servicetype (type: esriFieldTypeString, alias: Service Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Blow Off: Blow Off], [Commercial: Commercial], [Industrial: Industrial], ... 2 more ...)
assetid (type: esriFieldTypeString, alias: Asset ID, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
lifecyclestatus (type: esriFieldTypeString, alias: Lifecycle Status, SQL Type: sqlTypeOther, length: 100, nullable: false, editable: true, Coded Values: [Proposed: Proposed], [Approved: Approved], [Under Construction: Under Construction], ... 6 more ...)
installdate (type: esriFieldTypeDate, alias: Install Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
diameter (type: esriFieldTypeDouble, alias: Diameter, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 12 more ...)
material (type: esriFieldTypeString, alias: Material, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Cast Iron - CAS: Cast Iron - CAS], [Copper - COP: Copper - COP], [Ductile Iron - DIP: Ductile Iron - DIP], ... 1 more ...)
watertype (type: esriFieldTypeString, alias: Water Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Potable: Potable], [Irrigation: Irrigation], [Fire: Fire], ... 1 more ...)
treatmentlevel (type: esriFieldTypeString, alias: Treatment Level, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Primary: Primary], [Secondary: Secondary], [Tertiary: Tertiary])
inservicedate (type: esriFieldTypeDate, alias: In-Service Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
lastmaint (type: esriFieldTypeDate, alias: Last Maintenance, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
retireddate (type: esriFieldTypeDate, alias: Retired Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
measuredlength (type: esriFieldTypeDouble, alias: Measured Length, SQL Type: sqlTypeOther, nullable: true, editable: true)
notes (type: esriFieldTypeString, alias: Notes, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
ownedby (type: esriFieldTypeString, alias: Owned By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Our Agency: Our Agency], [Private: Private], [Other: Other])
maintby (type: esriFieldTypeString, alias: Maintained By, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Our Agency: Our Agency], [Private: Private], [Other: Other])
spatialsource (type: esriFieldTypeString, alias: Spatial Source, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [As-Built: As-Built], [CAD: CAD], [Digitized: Digitized], ... 2 more ...)
spatialconfidence (type: esriFieldTypeString, alias: Spatial Confidence, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [High: High], [Medium: Medium], [Low: Low])
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)
EditDate (type: esriFieldTypeDate, alias: Last update, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: false)
Editor (type: esriFieldTypeString, alias: Updated by, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: false)
OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ESRIGNSS_AVG_H_RMS (type: esriFieldTypeDouble, alias: Average Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_AVG_V_RMS (type: esriFieldTypeDouble, alias: Average Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_WORST_H_RMS (type: esriFieldTypeDouble, alias: Worst Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_WORST_V_RMS (type: esriFieldTypeDouble, alias: Worst Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_WORST_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Worst Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_MANUAL_LOCATIONS (type: esriFieldTypeInteger, alias: Number of Manual Locations, SQL Type: sqlTypeOther, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: assettype
Inherited
Field Name: servicetype
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: diameter
Inherited
Field Name: material
Inherited
Field Name: watertype
Inherited
Field Name: treatmentlevel
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ESRIGNSS_WORST_FIXTYPE
Inherited

ownedby: Our Agency
assettype: Fire Service
lifecyclestatus: In Service
maintby: Our Agency

Field Name: assettype
Inherited
Field Name: servicetype
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: diameter
Inherited
Field Name: material
Inherited
Field Name: watertype
Inherited
Field Name: treatmentlevel
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ESRIGNSS_WORST_FIXTYPE
Inherited

ownedby: Our Agency
assettype: Hydrant Service
lifecyclestatus: In Service
maintby: Our Agency

Field Name: assettype
Inherited
Field Name: servicetype
Inherited
Field Name: lifecyclestatus
Inherited
Field Name: diameter
Inherited
Field Name: material
Inherited
Field Name: watertype
Inherited
Field Name: treatmentlevel
Inherited
Field Name: ownedby
Inherited
Field Name: maintby
Inherited
Field Name: spatialsource
Inherited
Field Name: spatialconfidence
Inherited
Field Name: ESRIGNSS_WORST_FIXTYPE
Inherited

ownedby: Our Agency
assettype: Service
lifecyclestatus: In Service
maintby: Our Agency

Relationships:

ServiceRelate (14) -- Related To: ServiceRelate (36)

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 6/22/2025 9:01:14 PM

Schema Last Edit Date: 6/27/2024 8:32:23 PM

Data Last Edit Date: 6/22/2025 9:01:14 PM

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