Layer: Service Lines (ID:54)

View In: Map Viewer

Name: Service Lines

Display Field: STREET_NAME

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description:

This feature represents service connection lines on the corporation side, from corp stop to curb stop. Based on the ESRI Local Government Information Model, modified as seen fit to meet our needs and the needs of our clients in order to store, manage, and display geographic data. Data is 1.) Collected (through line markers) using mapping-grade GPS receivers using SBAS corrections, and/or 2.) Digitized based on best available references.

Copyright Text: RCAP Solutions, Geographic Information Services, ESRI Local Government Information Model

Min. Scale: 0

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":"OWNER","uniqueValueInfos":[{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,197,255,255],"width":1.5},"value":"1","label":"Utility Owned"},{"symbol":{"type":"esriSLS","style":"esriSLSSolid","color":[0,112,255,255],"width":1.5},"value":"0","label":"Private / Customer"}],"fieldDelimiter":",","authoringInfo":{"colorRamp":{"type":"multipart","colorRamps":[{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[192,252,237,255],"toColor":[192,252,237,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,179,251,255],"toColor":[252,179,251,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,194,179,255],"toColor":[252,194,179,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[250,252,182,255],"toColor":[250,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[189,209,252,255],"toColor":[189,209,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[182,252,182,255],"toColor":[182,252,182,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,212,244,255],"toColor":[252,212,244,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[202,182,252,255],"toColor":[202,182,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,244,215,255],"toColor":[252,244,215,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[216,252,207,255],"toColor":[216,252,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,182,207,255],"toColor":[252,182,207,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[199,237,252,255],"toColor":[199,237,252,255]},{"type":"algorithmic","algorithm":"esriCIELabAlgorithm","fromColor":[252,224,179,255],"toColor":[252,224,179,255]}]}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"(DomainName($feature, 'SIZE')) + '-' + $feature.MATERIAL","title":"Water_Main_Label_UPDATED2"},"labelPlacement":"esriServerLinePlacementCenterAlong","textLayout":"followFeature","deconflictionStrategy":"dynamic","allowOverrun":true,"repeatLabel":false,"lineConnection":"minimizeLabels","stackLabel":true,"stackAlignment":"dynamic","removeDuplicates":"none","stackRowLength":24,"useCodedValues":true,"maxScale":0,"minScale":2000,"name":"Class 1","priority":-1,"symbol":{"type":"esriTS","color":[0,0,0,255],"backgroundColor":null,"borderLineColor":null,"borderLineSize":null,"verticalAlignment":"bottom","horizontalAlignment":"left","rightToLeft":false,"angle":0,"xoffset":0,"yoffset":0,"kerning":true,"haloColor":[115,223,255,255],"haloSize":1.5,"font":{"family":"Arial","size":8,"style":"normal","weight":"bold","decoration":"none"}}}]}
HasZ: false

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

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
SERVICE_LINE_ID (type: esriFieldTypeString, alias: Service Line ID, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ACTIVE (type: esriFieldTypeString, alias: Active Status, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
OWNER (type: esriFieldTypeSmallInteger, alias: Utility or Customer Owned?, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [1: Utility Owned], [0: Private / Customer])
INSTALLDATE (type: esriFieldTypeDate, alias: Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
STREET_NAME (type: esriFieldTypeString, alias: Street Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
STREET_NO (type: esriFieldTypeString, alias: House Number, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
LOCDESC (type: esriFieldTypeString, alias: Location Description, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
OWNER_NAME (type: esriFieldTypeString, alias: Owner Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SIZE (type: esriFieldTypeDouble, alias: Size / Diameter Pipe, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0.5: 1/2"], [0.75: 3/4"], [1: 1"], ... 8 more ...)
MATERIAL (type: esriFieldTypeString, alias: Material Service Line (Utility Side), SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [COP: Copper], [CI: Cast Iron], [DI: Ductile Iron], ... 9 more ...)
COMMENTS (type: esriFieldTypeString, alias: Comments, SQL Type: sqlTypeOther, length: 200, nullable: true, editable: true)
DAMAGE (type: esriFieldTypeString, alias: Damage / Maintenance Request, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
CONDITION (type: esriFieldTypeString, alias: Condition, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [3: Fair (some aging / wear & tear)], [1: Very Good (relatively new)], [2: Good (newer, with no problems)], ... 2 more ...)
INSPECTED (type: esriFieldTypeString, alias: Inspected, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No])
INSPECTION_DATE (type: esriFieldTypeDate, alias: INSPECTION_DATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
LENGTH (type: esriFieldTypeDouble, alias: Length (Design Engineering), SQL Type: sqlTypeOther, nullable: true, editable: true)
DISTANCE (type: esriFieldTypeInteger, alias: Distance, SQL Type: sqlTypeOther, nullable: true, editable: true)
RISK (type: esriFieldTypeSmallInteger, alias: Risk, SQL Type: sqlTypeOther, nullable: true, editable: true)
RISK_RANKING (type: esriFieldTypeSmallInteger, alias: Risk Ranking, SQL Type: sqlTypeOther, nullable: true, editable: true)
EXPECTED_USEFUL_LIFE (type: esriFieldTypeSmallInteger, alias: Expected Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REMAINING_USEFUL_LIFE (type: esriFieldTypeSingle, alias: Remaining Useful Life, SQL Type: sqlTypeOther, nullable: true, editable: true)
REPLACEMENT_COST (type: esriFieldTypeSingle, alias: Replacement Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
UNIT_COST (type: esriFieldTypeSingle, alias: Unit Cost, SQL Type: sqlTypeOther, nullable: true, editable: true)
COF (type: esriFieldTypeSmallInteger, alias: Consequence of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
CF_ASSET_SIZE (type: esriFieldTypeString, alias: CF Asset Size, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Less than 4" = 1], [2: 4" = 2], [3: 6" = 3], ... 4 more ...)
CF_OVERALL_CUST_IMPACT (type: esriFieldTypeString, alias: CF Overall Customer Imapct, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: 10% = 1], [2: 10-30% = 2], [3: 30-50% = 3], ... 4 more ...)
CF_SIGNIF_IMPORTANT_CUST (type: esriFieldTypeString, alias: CF Critical Customers, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Residential Only = 1], [2: School / Church = 2], [3: Downtown Businesses = 3], ... 4 more ...)
CF_MAINTENANCE_ACCESSIBILITY (type: esriFieldTypeString, alias: CF Maintenance Accesibility, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Right of Way - no traffic control = 1], [2: Right of Way - with traffic control = 2], [3: Public lands with vehicle access = 3], ... 4 more ...)
POF (type: esriFieldTypeSmallInteger, alias: Probability of Failure, SQL Type: sqlTypeOther, nullable: true, editable: true)
PF_ASSET_STATUS (type: esriFieldTypeString, alias: PF Asset Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Fully Functional = 1], [2: Operates with difficulty = 2], [3: Operates but unreliable = 3], ... 4 more ...)
PF_MAINTENANCE_HISTORY (type: esriFieldTypeString, alias: PF Maintenance History, SQL Type: sqlTypeOther, length: 150, nullable: true, editable: true, Coded Values: [1: Recommended best practices regularly followed = 1], [2: Assets are adequately maintained = 2], [3: No maintenance history = 3], ... 4 more ...)
PF_CAPACITY (type: esriFieldTypeString, alias: PF Capacity, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [1: Excess capacity = 1], [2: Limited capacity concerns = 2], [3: Moderate concerns / Limited Fire Flow / Sewer Surcharges = 3], ... 4 more ...)
MODIFYUSER (type: esriFieldTypeString, alias: Last Editor, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
MODIFYDATE (type: esriFieldTypeDate, alias: Last Update Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
CREATOR (type: esriFieldTypeString, alias: CREATOR, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
CREATEDATE (type: esriFieldTypeDate, alias: CREATEDATE, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
GlobalID (type: esriFieldTypeGlobalID, alias: GlobalID, SQL Type: sqlTypeOther, length: 38, nullable: false, editable: false)
ESRIGNSS_H_RMS (type: esriFieldTypeDouble, alias: Horizontal Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_V_RMS (type: esriFieldTypeDouble, alias: Vertical Accuracy (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LATITUDE (type: esriFieldTypeDouble, alias: Latitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_LONGITUDE (type: esriFieldTypeDouble, alias: Longitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_POSITIONSOURCETYPE (type: esriFieldTypeSmallInteger, alias: Position source type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Unknown], [1: User defined], [2: Integrated (System) Location Provider], ... 2 more ...)
ESRIGNSS_RECEIVER (type: esriFieldTypeString, alias: Receiver Name, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
ESRIGNSS_ALTITUDE (type: esriFieldTypeDouble, alias: Altitude, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_FIXDATETIME (type: esriFieldTypeDate, alias: Fix Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
ESRIGNSS_FIXTYPE (type: esriFieldTypeSmallInteger, alias: Fix Type, SQL Type: sqlTypeOther, nullable: true, editable: true, Coded Values: [0: Fix not valid], [1: GPS], [2: Differential GPS], ... 2 more ...)
ESRIGNSS_CORRECTIONAGE (type: esriFieldTypeDouble, alias: Correction Age, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_STATIONID (type: esriFieldTypeSmallInteger, alias: Station ID, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 1023])
ESRIGNSS_NUMSATS (type: esriFieldTypeSmallInteger, alias: Number of Satellites, SQL Type: sqlTypeOther, nullable: true, editable: true, Range: [0 - 99])
ESRIGNSS_PDOP (type: esriFieldTypeDouble, alias: Positional dilution of precision (3D), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_HDOP (type: esriFieldTypeDouble, alias: Horizontal Ground Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_VDOP (type: esriFieldTypeDouble, alias: Vertical (Elevation) Precision, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_DIRECTION (type: esriFieldTypeDouble, alias: Direction of travel (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_SPEED (type: esriFieldTypeDouble, alias: Ground Speed (km/h), SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRISNSR_AZIMUTH (type: esriFieldTypeDouble, alias: Compass reading of Phone / Tablet (°), SQL Type: sqlTypeOther, nullable: true, editable: true)
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_AVG_POSITIONS (type: esriFieldTypeSmallInteger, alias: Averaged Positions, SQL Type: sqlTypeOther, nullable: true, editable: true)
ESRIGNSS_H_STDDEV (type: esriFieldTypeDouble, alias: Standard Deviation (m), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_X (type: esriFieldTypeDouble, alias: Calculated Point X (Longitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Y (type: esriFieldTypeDouble, alias: Calculated Point Y (Latitude), SQL Type: sqlTypeOther, nullable: true, editable: true)
POINT_Z (type: esriFieldTypeDouble, alias: Calculated Point Z (Elevation Height), SQL Type: sqlTypeOther, nullable: true, editable: true)
CALC_XYZ_SOURCE (type: esriFieldTypeString, alias: Calculated Coordinate Source Reference, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SEQUENTIAL_ID (type: esriFieldTypeString, alias: Sequential ID to assist with Asset ID., SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
Shape__Length (type: esriFieldTypeDouble, alias: Shape__Length, SQL Type: sqlTypeDouble, nullable: true, editable: false)

Types:

Field Name: OWNER
Inherited
Field Name: SIZE
Inherited
Field Name: MATERIAL
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: INSPECTED
Inherited
Field Name: CF_ASSET_SIZE
Inherited
Field Name: CF_OVERALL_CUST_IMPACT
Inherited
Field Name: CF_SIGNIF_IMPORTANT_CUST
Inherited
Field Name: CF_MAINTENANCE_ACCESSIBILITY
Inherited
Field Name: PF_ASSET_STATUS
Inherited
Field Name: PF_MAINTENANCE_HISTORY
Inherited
Field Name: PF_CAPACITY
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited

SIZE: 1
OWNER: 1
MATERIAL: COP
DAMAGE: No
INSPECTED: No

Field Name: OWNER
Inherited
Field Name: SIZE
Inherited
Field Name: MATERIAL
Inherited
Field Name: DAMAGE
Inherited
Field Name: CONDITION
Inherited
Field Name: INSPECTED
Inherited
Field Name: CF_ASSET_SIZE
Inherited
Field Name: CF_OVERALL_CUST_IMPACT
Inherited
Field Name: CF_SIGNIF_IMPORTANT_CUST
Inherited
Field Name: CF_MAINTENANCE_ACCESSIBILITY
Inherited
Field Name: PF_ASSET_STATUS
Inherited
Field Name: PF_MAINTENANCE_HISTORY
Inherited
Field Name: PF_CAPACITY
Inherited
Field Name: ESRIGNSS_POSITIONSOURCETYPE
Inherited
Field Name: ESRIGNSS_FIXTYPE
Inherited
Field Name: ESRIGNSS_STATIONID
Inherited
Field Name: ESRIGNSS_NUMSATS
Inherited

SIZE: 1
OWNER: 0
MATERIAL: COP
DAMAGE: No
INSPECTED: No

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/1/2024 5:43:13 PM

Schema Last Edit Date: 8/22/2023 12:33:02 PM

Data Last Edit Date: 4/1/2024 5:43:13 PM

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