View In:   ArcGIS Online Map Viewer

Name: Service_Line

Display Field: streetname

Type: Feature Layer

Geometry Type: esriGeometryPolyline

Description: 25 Jan 2024: Lead Service Category (LEADSERVICECLASSIFICATION) added to facilitate Lead Service Line Replacement Program. The types represent all combinations of service line material composition over line ownership (customer owned and utility owned). 31 Jan 2023: In 2022, GIS dept added three fields to wLateralLine for the purpose of tracking lead replacement efforts started the same year. Those fields are "Removed Lead" (REMOVEDLEAD), "Removed Lead Date" (REMOVEDLEADDATE), "Lead Comments" (LEADCOMMENTS)."Removed Lead" is a true/false domain used to indicate that lead is completely removed from a service line. When lead material is found, "Removed Lead" is first made FALSE, and changed to TRUE when the service line is completely non-lead. From June 2021, the materials were filled by reviewing historic workorders. In the old 2022 workflow, If lead was discovered via the unknown lateral material inspection process, or if material was discovered from a workorder related to that service line, "Lead Comment" is used to indicate lead found and date. Prior to that, information was contained in the Bentley database. KN23 Feb 2023: 14 new fields added; C-B Found Lead, C-B Found Lead Date, C-B Lead Removed, C- B Lead Removed Date, C-B Found Source. M-C Found Lead, M-C Found Lead Date, M-C Lead Removed, M-C Lead Removed Date, M-C Found Source. The preceding ten fields are used to collect information related to LEAD SERVICE LINE INVENTORY and NOTIFICATION documentation for customers. Four fields related to customer documentation have been added; Filter (Was a filter provided to customers affected by lead service?), Filter Date (When the filter was provided?), Mixed Material Letter (Did the customer receive a mixed material letter?), Letter Date (When the letter was mailed?). WorkFlow: At the time of writing, per GIS Supervisor, Lead Service Line questions with a "Yes/No" domain (C-B Found Lead? C-B Lead Removed? M-C Found Lead?, M-C Lead Removed?) should only use "Yes" or <Null>. Dates and Source information should be recorded following the "LSL Inspection Map (Collector)". Prior to the addition of new fields, information pertaining to Lead Service Line Inspections is contained in the "Comments", "Lead Comments", or "Temp Text" fields.

Service Item Id: d5f26fad3ab542e69dd1141422a6b29f

Copyright Text:

Default Visibility: true

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0

Max Scale: 0

Supports Advanced Queries: true

Supports Statistics: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: 576528.5353632495
YMin: 770728.2655610517
XMax: 608875.332942199
YMax: 798666.9182255268
Spatial Reference: 103106  (6527)  VCSWkid(5703)  LatestVCSWkid(5703)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSLSSolid
Color: [41, 173, 171, 255]
Width: 1
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Advanced Query Capabilities:

Supports Statistics: true
Supports OrderBy: true
Supports Distinct: true
Supports Pagination: true
Supports TrueCurve: false
Supports Returning Query Extent: true
Supports Query With Distance: true
Supports Sql Expression: true
Supports Query With ResultType: true
Supports Returning Geometry Centroid: false
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true

HasZ: false

HasM: true

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• objectid ( nullable: false, defaultValue: null, editable: false, length: 4, type: esriFieldTypeOID, modelName: OBJECTID, alias: OBJECTID )
• streetnumb ( modelName: streetnumb, nullable: true, editable: true, defaultValue: null, alias: Street Number, type: esriFieldTypeDouble )
• streetname ( modelName: streetname, nullable: true, editable: true, defaultValue: null, length: 80, alias: Street Name, type: esriFieldTypeString , Coded Values: [10TH AVE: 10TH AVE] , [11TH AVE: 11TH AVE] , [1ST ST: 1ST ST] , ...1082 more... )
• municipality ( modelName: municipality, nullable: true, editable: true, defaultValue: null, length: 80, alias: Municipality, type: esriFieldTypeString , Coded Values: [RIDGEWOOD: RIDGEWOOD] , [WYCKOFF: WYCKOFF] , [MIDLAND PARK: MIDLAND PARK] , ...8 more... )
• pressurezone ( modelName: pressurezone, nullable: true, editable: true, defaultValue: null, length: 80, alias: Pressure Zone, type: esriFieldTypeString , Coded Values: [L: Low] , [I: Intermediate] , [H: High] , ...5 more... )
• globalid ( nullable: false, editable: false, defaultValue: null, length: 38, type: esriFieldTypeGlobalID, modelName: globalid, alias: GlobalID )
• estpressure ( modelName: estpressure, nullable: true, editable: true, defaultValue: null, alias: Estimated Pressure, type: esriFieldTypeDouble )
• leadserviceclassification ( modelName: leadserviceclassification, nullable: true, editable: true, defaultValue: null, length: 255, alias: Lead Service Category or Type, type: esriFieldTypeString )
• boilwater ( modelName: boilwater, nullable: true, editable: true, defaultValue: null, length: 255, alias: Boil Water, type: esriFieldTypeString , Coded Values: [Boil Water: Boil Water] , [No Boil Water: No Boil Water] )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )

Templates:

• Name: Service_Line
  Description:
  Prototype:
  estpressure: null
  streetnumb: null
  streetname: null
  municipality: null
  pressurezone: null
  leadserviceclassification: null
  boilwater: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: true

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Calculate   Validate SQL   Generate Renderer   Return Updates   Metadata