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: 3dc627de15614bcf9b48216ae71fe4d9

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

Supports Datum Transformation: true

Extent:

XMin: 576528.5354125127
YMin: 770728.2656624466
XMax: 608875.3329235129
YMax: 798669.2875361964
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: true
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: false
Supports Query With LOD Spatial Reference: false

HasZ: false

HasM: true

Has Attachments: true

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field:

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID, editable: false, nullable: false, defaultValue: null, modelName: OBJECTID )
• TAPNUMBER ( type: esriFieldTypeString, alias: Tap Number, editable: true, nullable: true, length: 80, defaultValue: null, modelName: TAPNUMBER )
• LINETYPE ( type: esriFieldTypeString, alias: Line Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LINETYPE , Coded Values: [Hydrant: Hydrant] , [Irrigation: Irrigation] , [Other: Other] , ...5 more... )
• SERVICEFOR ( type: esriFieldTypeString, alias: Service For, editable: true, nullable: true, length: 80, defaultValue: null, modelName: SERVICEFOR )
• CBDIAMETER ( type: esriFieldTypeDouble, alias: Curb to Building Diameter, editable: true, nullable: true, defaultValue: null, modelName: CURBBLDDIAM , Coded Values: [0.5: 1/2"] , [0.75: 3/4"] , [1: 1"] , ...11 more... )
• CBINSTALL ( type: esriFieldTypeDate, alias: Curb to Building Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CURBBLDINST )
• CBMATERIAL ( type: esriFieldTypeString, alias: Curb to Building Material, editable: true, nullable: true, length: 80, defaultValue: null, modelName: CURBBLDMAT , Coded Values: [CU: Copper] , [LL: Lead Lined] , [PB: Lead] , ...10 more... )
• CBDEPTH ( type: esriFieldTypeDouble, alias: Curb to Building Depth, editable: true, nullable: true, defaultValue: null, modelName: CURBBLDDEPTH )
• MCDIAMETER ( type: esriFieldTypeDouble, alias: Main to Curb Diameter, editable: true, nullable: true, defaultValue: null, modelName: MCDIAMETER , Coded Values: [0.5: 1/2"] , [0.75: 3/4"] , [1: 1"] , ...11 more... )
• MCINSTALL ( type: esriFieldTypeDate, alias: Main to Curb Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MCINSTALL )
• MCMATERIAL ( type: esriFieldTypeString, alias: Main to Curb Material, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MCMATERIAL , Coded Values: [CU: Copper] , [LL: Lead Lined] , [PB: Lead] , ...10 more... )
• MCDEPTH ( type: esriFieldTypeDouble, alias: Main to Curb Depth, editable: true, nullable: true, defaultValue: null, modelName: MCDEPTH )
• MAINDEPTH ( type: esriFieldTypeDouble, alias: Main Depth, editable: true, nullable: true, defaultValue: null, modelName: MAINDEPTH )
• STREETNUMB ( type: esriFieldTypeDouble, alias: Street Number, editable: true, nullable: true, defaultValue: null, modelName: STREETNUMB )
• STREETNAME ( type: esriFieldTypeString, alias: Street Name, editable: true, nullable: true, length: 80, defaultValue: null, modelName: STREETNAME , Coded Values: [10TH AVE: 10TH AVE] , [11TH AVE: 11TH AVE] , [1ST ST: 1ST ST] , ...1082 more... )
• MUNICIPALITY ( type: esriFieldTypeString, alias: Municipality, editable: true, nullable: true, length: 80, defaultValue: null, modelName: MUNICIPALI , Coded Values: [RIDGEWOOD: RIDGEWOOD] , [WYCKOFF: WYCKOFF] , [MIDLAND PARK: MIDLAND PARK] , ...8 more... )
• PRESSUREZONE ( type: esriFieldTypeString, alias: Pressure Zone, editable: true, nullable: true, length: 80, defaultValue: null, modelName: PRESSURE_Z , Coded Values: [L: Low] , [I: Intermediate] , [H: High] , ...5 more... )
• LOCDESC ( type: esriFieldTypeString, alias: Location Description, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LOCDESC )
• CBOXLOCDESC ( type: esriFieldTypeString, alias: Curb Box Location, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CURBBOXLOC )
• INSTWORKORD ( type: esriFieldTypeString, alias: Install Work Order Number, editable: true, nullable: true, length: 255, defaultValue: null, modelName: INSTWORKORD )
• COMMENTS ( type: esriFieldTypeString, alias: Comments, editable: true, nullable: true, length: 1020, defaultValue: null, modelName: COMMENTS )
• OWNEDBY ( type: esriFieldTypeSmallInteger, alias: Owned By, editable: true, nullable: true, defaultValue: 1, modelName: OWNEDBY , Coded Values: [-2: Other] , [-1: Private] , [1: Ridgewood Water] )
• MAINTBY ( type: esriFieldTypeSmallInteger, alias: Managed By, editable: true, nullable: true, defaultValue: 1, modelName: MAINTBY , Coded Values: [-2: Other] , [-1: Private] , [1: Ridgewood Water] )
• WATERTYPE ( type: esriFieldTypeString, alias: Water Type, editable: true, nullable: true, length: 30, defaultValue: null, modelName: WATERTYPE , Coded Values: [Potable: Potable Water] , [Raw: Raw Water] , [Reclaimed: Reclaimed Water] , ...3 more... )
• ENABLED ( type: esriFieldTypeSmallInteger, alias: Enabled, editable: true, nullable: true, defaultValue: null, modelName: ENABLED , Coded Values: [0: False] , [1: True] )
• ACTIVEFLAG ( type: esriFieldTypeSmallInteger, alias: Active Flag, editable: true, nullable: true, defaultValue: null, modelName: ACTIVEFLAG , Coded Values: [0: False] , [1: True] )
• FACILITYCAT ( type: esriFieldTypeString, alias: Facility Category, editable: true, nullable: true, length: 80, defaultValue: null, modelName: FACILITY_C , Coded Values: [D: Distribution] , [T: Transmission] , [F: Facility] , ...2 more... )
• LIFECYCLESTATUS ( type: esriFieldTypeString, alias: Lifecycle Status, editable: true, nullable: true, length: 80, defaultValue: null, modelName: LIFECYCLES , Coded Values: [Proposed Install: Proposed Install] , [Proposed Remove: Proposed Remove] , [Proposed Abandon: Proposed Abandon] , ...5 more... )
• TYPE ( type: esriFieldTypeDouble, alias: Type, editable: true, nullable: true, defaultValue: null, modelName: TYPE , Coded Values: [1: Domestic Service] , [2: Fire Service] , [3: Stub Service] )
• ATLASPAGE ( type: esriFieldTypeString, alias: Atlas Page, editable: true, nullable: true, length: 80, defaultValue: null, modelName: ATLAS_PAGE , Coded Values: [A3: A3] , [A4: A4] , [A5: A5] , ...101 more... )
• WATERENDID ( type: esriFieldTypeString, alias: Water End ID, editable: true, nullable: true, length: 80, defaultValue: null, modelName: WATERENDID )
• WATERNETID ( type: esriFieldTypeString, alias: Water Net ID, editable: true, nullable: true, length: 80, defaultValue: null, modelName: WATERNETID )
• WATERSTARTID ( type: esriFieldTypeString, alias: Water Start ID, editable: true, nullable: true, length: 80, defaultValue: null, modelName: WATERSTARTID )
• MATERIAL ( type: esriFieldTypeString, alias: Material, editable: true, nullable: true, length: 20, defaultValue: null, modelName: MATERIAL , Coded Values: [CU: Copper] , [LL: Lead Lined] , [PB: Lead] , ...10 more... )
• INSTALLDATE ( type: esriFieldTypeDate, alias: Install Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: INSTALLDATE )
• DIAMETER ( type: esriFieldTypeDouble, alias: Diameter, editable: true, nullable: true, defaultValue: null, modelName: DIAMETER )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, editable: false, nullable: false, length: 38, defaultValue: null, modelName: GlobalID )
• created_user ( type: esriFieldTypeString, alias: Created By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: created_user )
• created_date ( type: esriFieldTypeDate, alias: Created Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: created_date )
• last_edited_user ( type: esriFieldTypeString, alias: Updated By, editable: false, nullable: true, length: 255, defaultValue: null, modelName: last_edited_user )
• last_edited_date ( type: esriFieldTypeDate, alias: Updated Date, editable: false, nullable: true, length: 8, defaultValue: null, modelName: last_edited_date )
• ASSETID ( type: esriFieldTypeInteger, alias: Asset Identifier, editable: true, nullable: true, defaultValue: null, modelName: ASSETID )
• SUBTYPE ( type: esriFieldTypeSmallInteger, alias: Subtype, editable: true, nullable: true, defaultValue: null, modelName: SUBTYPE )
• ESTPRESSURE ( type: esriFieldTypeDouble, alias: Estimated Pressure, editable: true, nullable: true, defaultValue: null, modelName: ESTPRESSURE )
• TAPASSETID ( type: esriFieldTypeInteger, alias: Tap Asset ID, editable: true, nullable: true, defaultValue: null, modelName: TAPASSETID )
• TEMPTEXT ( type: esriFieldTypeString, alias: Temp Text, editable: true, nullable: true, length: 255, defaultValue: null, modelName: TEMPTEXT )
• TEMPNUM ( type: esriFieldTypeDouble, alias: Temp Number, editable: true, nullable: true, defaultValue: null, modelName: TEMPNUM )
• REMOVEDLEAD ( type: esriFieldTypeString, alias: Removed Lead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: REMOVEDLEAD , Coded Values: [True: True] , [False: False] )
• REMOVALDATE ( type: esriFieldTypeDate, alias: Removed Lead Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: REMOVALDATE )
• LEADCOMMENTS ( type: esriFieldTypeString, alias: Lead Comments, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEADCOMMENTS )
• MCFOUNDLEAD ( type: esriFieldTypeString, alias: M-C Found Lead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MCFOUNDLEAD , Coded Values: [Yes: Yes] , [No: No] )
• MCFOUNDLEADDATE ( type: esriFieldTypeDate, alias: M-C Found Lead Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MCFOUNDLEADDATE )
• MCLEADREMOVED ( type: esriFieldTypeString, alias: M-C Lead Removed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MCLEADREMOVED , Coded Values: [Yes: Yes] , [No: No] )
• MCLEADREMOVEDDATE ( type: esriFieldTypeDate, alias: M-C Lead Removed Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: MCLEADREMOVEDDATE )
• MCFOUNDSOURCE ( type: esriFieldTypeDouble, alias: M-C Found Source, editable: true, nullable: true, defaultValue: null, modelName: MCFOUNDSOURCE , Coded Values: [1: Inspection App] , [2: Work Order App] , [3: House Inspection] , ...1 more... )
• CBFOUNDLEAD ( type: esriFieldTypeString, alias: C-B Found Lead, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CBFOUNDLEAD , Coded Values: [Yes: Yes] , [No: No] )
• CBFOUNDLEADDATE ( type: esriFieldTypeDate, alias: C-B Found Lead Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CBFOUNDLEADDATE )
• CBLEADREMOVED ( type: esriFieldTypeString, alias: C-B Lead Removed, editable: true, nullable: true, length: 255, defaultValue: null, modelName: CBLEADREMOVED , Coded Values: [Yes: Yes] , [No: No] )
• CBLEADREMOVEDDATE ( type: esriFieldTypeDate, alias: C-B Lead Romoved Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: CBLEADREMOVEDDATE )
• CBFOUNDSOURCE ( type: esriFieldTypeDouble, alias: C-B Found Source, editable: true, nullable: true, defaultValue: null, modelName: CBFOUNDSOURCE , Coded Values: [1: Inspection App] , [2: Work Order App] , [3: House Inspection] , ...1 more... )
• FILTER ( type: esriFieldTypeString, alias: Filter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: FILTER , Coded Values: [Yes: Yes] , [No: No] )
• FILTERDATE ( type: esriFieldTypeDate, alias: Filter Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: FILTERDATE )
• MIXEDMATLTR ( type: esriFieldTypeString, alias: Mixed Material Letter, editable: true, nullable: true, length: 255, defaultValue: null, modelName: MIXEDMATLTR , Coded Values: [Yes: Yes] , [No: No] )
• LETTERDATE ( type: esriFieldTypeDate, alias: Mixed Material Letter Date, editable: true, nullable: true, length: 8, defaultValue: null, modelName: LETTERDATE )
• OVERBURDENEDCOM ( type: esriFieldTypeDouble, alias: Overburdened Community Criteria, editable: true, nullable: true, defaultValue: null, modelName: OVERBURDENEDCOM , Coded Values: [1: Adjacent] , [2: Limited English] , [3: Low Income] , ...5 more... )
• LEADSERVICECLASSIFICATION ( type: esriFieldTypeString, alias: Lead Service Category or Type, editable: true, nullable: true, length: 255, defaultValue: null, modelName: LEADSERVICECLASSIFICATION )
• MANIFOLD ( type: esriFieldTypeString, alias: Manifold?, editable: true, nullable: true, length: 3, defaultValue: null, modelName: MANIFOLD , Coded Values: [Yes: Yes] , [No: No] )
• SERVICESENTRY ( type: esriFieldTypeString, alias: SERVICESENTRY, editable: true, nullable: true, length: 255, defaultValue: null, modelName: SERVICESENTRY , Coded Values: [Yes: Yes] , [No: No] )
• ACCNUM ( type: esriFieldTypeInteger, alias: ACCNUM, editable: true, nullable: true, defaultValue: null, modelName: ACCNUM )
• Shape__Length ( type: esriFieldTypeDouble, alias: Shape Length, editable: false, nullable: false, defaultValue: null, modelName: Shape.STLength() )

Templates:

• Name: Service Line
  Description:
  Prototype:
  ACCNUM: null
  SERVICESENTRY: null
  TAPNUMBER: null
  LINETYPE: null
  SERVICEFOR: null
  CBDIAMETER: null
  CBINSTALL: null
  CBMATERIAL: null
  CBDEPTH: null
  MCDIAMETER: null
  MCINSTALL: null
  MCMATERIAL: null
  MCDEPTH: null
  MAINDEPTH: null
  STREETNUMB: null
  STREETNAME: null
  MUNICIPALITY: null
  PRESSUREZONE: null
  LOCDESC: null
  CBOXLOCDESC: null
  INSTWORKORD: null
  COMMENTS: null
  OWNEDBY: 1
  MAINTBY: 1
  WATERTYPE: null
  ENABLED: null
  ACTIVEFLAG: null
  FACILITYCAT: null
  LIFECYCLESTATUS: null
  TYPE: null
  ATLASPAGE: null
  WATERENDID: null
  WATERNETID: null
  WATERSTARTID: null
  MATERIAL: null
  INSTALLDATE: null
  DIAMETER: null
  MANIFOLD: null
  LEADSERVICECLASSIFICATION: null
  OVERBURDENEDCOM: null
  LETTERDATE: null
  MIXEDMATLTR: null
  ASSETID: null
  SUBTYPE: null
  ESTPRESSURE: null
  TAPASSETID: null
  TEMPTEXT: null
  TEMPNUM: null
  REMOVEDLEAD: null
  REMOVALDATE: null
  LEADCOMMENTS: null
  MCFOUNDLEAD: null
  MCFOUNDLEADDATE: null
  MCLEADREMOVED: null
  MCLEADREMOVEDDATE: null
  MCFOUNDSOURCE: null
  CBFOUNDLEAD: null
  CBFOUNDLEADDATE: null
  CBLEADREMOVED: null
  CBLEADREMOVEDDATE: null
  CBFOUNDSOURCE: null
  FILTER: null
  FILTERDATE: null
  
  Drawing Tool: esriFeatureEditToolLine

Capabilities: Query,Create,Update,Delete,Uploads,Editing

Sync Can Return Changes: true

Is Data Versioned: true

Supports Rollback On Failure: false

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Edit Fields Info:

• Creation Date Field: created_date
• Creator Field: created_user
• Edit Date Field: last_edited_date
• Editor Field: last_edited_user

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Supported Operations:   Query   Query Attachments   Query Analytic   Apply Edits   Add Features   Update Features   Delete Features   Calculate   Validate SQL   Generate Renderer   Return Updates   Iteminfo   Thumbnail   Metadata