Layer: CNMB_ServiceLineInventory

View In: Map Viewer

Name: CNMB_ServiceLineInventory_Base

Display Field: UniqSrvcLineID

Type: Feature Layer

Geometry Type: esriGeometryPoint

Is View: true

Is Updatable View: true

Source Schema Changes Allowed: true

Sources

Description:

Copyright Text:

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":"simple","symbol":{"type":"esriSMS","style":"esriSMSCircle","color":[0,0,0,255],"size":4,"angle":0,"xoffset":0,"yoffset":0,"outline":{"color":[0,0,0,255],"width":0.7}}},"scaleSymbols":true,"transparency":0,"labelingInfo":[{"labelExpressionInfo":{"expression":"\"U: \"+DomainName($feature, 'U_UtiltyStat') + \", C: \"+DomainName($feature, 'C_cstmrStat')","title":"Custom"},"labelPlacement":"esriServerPointLabelPlacementAboveRight","deconflictionStrategy":"dynamic","removeDuplicates":"none","stackLabel":false,"useCodedValues":true,"maxScale":0,"minScale":0,"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":null,"haloSize":null,"font":{"family":"Tahoma","size":10,"style":"normal","weight":"normal","decoration":"none"}}}]}
HasZ: true

HasM: false

Has Attachments: false

Has Geometry Properties: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Object ID Field: OBJECTID

Unique ID Field:

Global ID Field:

Type ID Field:

Fields:

OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
UniqSrvcLineID (type: esriFieldTypeString, alias: Unique Service Line ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
StrtAdrs (type: esriFieldTypeString, alias: Street Address, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
SensPop (type: esriFieldTypeString, alias: Sensitive Population, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [No: No], [Yes - School: Yes - School], [Yes - Day Care: Yes - Day Care], ... 3 more ...)
DisadvntgedNeighborhd (type: esriFieldTypeString, alias: Disadvantaged Neighborhood, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
U_SystmOwndMat (type: esriFieldTypeString, alias: U_System Owned Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asbestos Cement - AC: Asbestos Cement - AC], [Cast Iron - CAS: Cast Iron - CAS], [Copper - COP: Copper - COP], ... 16 more ...)
U_WasMatEvrPrevLead (type: esriFieldTypeString, alias: U_Was Material Ever Previously Lead?, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
U_ServceLineInstalDate (type: esriFieldTypeDate, alias: U_Service Line Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
U_ServceLineInstalYr (type: esriFieldTypeSmallInteger, alias: U_Service Line Installation Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
U_ServceLineSize (type: esriFieldTypeString, alias: U_Service Line Size, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [1/2": 1/2"], [3/4": 3/4"], ... 13 more ...)
U_BasisofMatClas (type: esriFieldTypeString, alias: U_Basis of Material Classification, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Previous materials evaluation: Previous materials evaluation], [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Installation date after lead ban: Installation date after lead ban], ... 6 more ...)
U_WasSrvceLinMatFieldVerifd (type: esriFieldTypeString, alias: U_Was the Service Line Material Field Verified, SQL Type: sqlTypeOther, length: 5, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
U_DscrbeFieldVerifMethd (type: esriFieldTypeString, alias: U_Describe the Field Verification Method, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Customer self-identification: Customer self-identification], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external], ... 6 more ...)
U_EntrDateofFieldVerif (type: esriFieldTypeDate, alias: U_Enter the Date of Field Verification, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
U_UtiltyStat (type: esriFieldTypeString, alias: U_Utility Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Unknown: Unknown], ... 1 more ...)
U_Notes (type: esriFieldTypeString, alias: U_Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
C_CstmrOwnMat (type: esriFieldTypeString, alias: C_Costumer-Owned Material, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Asbestos Cement - AC: Asbestos Cement - AC], [Cast Iron - CAS: Cast Iron - CAS], [Copper - COP: Copper - COP], ... 16 more ...)
C_SrvcLineInstalDate (type: esriFieldTypeDate, alias: C_Service Line Installation Date, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
C_SrvcLineInstalYr (type: esriFieldTypeSmallInteger, alias: C_Service Line Installation Year, SQL Type: sqlTypeOther, nullable: true, editable: true)
C_SrvcLineSize (type: esriFieldTypeString, alias: C_Service Line Size, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true, Coded Values: [Unknown: Unknown], [1/2": 1/2"], [3/4": 3/4"], ... 13 more ...)
C_BasisofMatClas (type: esriFieldTypeString, alias: C_Basis of Material Classification, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true, Coded Values: [Previous materials evaluation: Previous materials evaluation], [Installation record (e.g., tap card): Installation record (e.g., tap card)], [Installation date after lead ban: Installation date after lead ban], ... 6 more ...)
C_WasSrvcLineMatFieldVerfid (type: esriFieldTypeString, alias: C_Was the Service Line Material Field Verified, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [No: No], [Yes: Yes])
C_DscrbeFieldVerifMethd (type: esriFieldTypeString, alias: C_Describe the Field Verification Method, SQL Type: sqlTypeOther, length: 60, nullable: true, editable: true, Coded Values: [Customer self-identification: Customer self-identification], [CCTV investigation at curb stop - internal: CCTV investigation at curb stop - internal], [CCTV investigation at curb stop - external: CCTV investigation at curb stop - external], ... 6 more ...)
C_DateofFieldVerif (type: esriFieldTypeDate, alias: C_Date of Field Verification , SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
C_Notes (type: esriFieldTypeString, alias: C_Notes, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
C_cstmrStat (type: esriFieldTypeString, alias: C_Customer Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Unknown: Unknown], ... 1 more ...)
EntireSrvcLineMat (type: esriFieldTypeString, alias: Entire Service Line Material, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true, Coded Values: [Lead: Lead], [Non-Lead: Non-Lead], [Unknown: Unknown], ... 1 more ...)
IsThereALeadConctr (type: esriFieldTypeString, alias: Is there a Lead Connector, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
IThereLeadSldrinSrvcLine (type: esriFieldTypeString, alias: Is there Lead Solder in the Service Line, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
FittingsandEquipContainLead (type: esriFieldTypeString, alias: Fittings and Equipment Connected to the Service Line that Contain Lead, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
BldgTypCnctdToSrvcLine (type: esriFieldTypeString, alias: Building Type Connected to Service Line, SQL Type: sqlTypeOther, length: 40, nullable: true, editable: true, Coded Values: [Single Family Residence: Single Family Residence], [Multiple Family Residence: Multiple Family Residence], [Building: Building], ... 2 more ...)
PntofEntryUseTreatmntPrsnt (type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment Present, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
LeadSolderPreLeadBan (type: esriFieldTypeString, alias: Does the Interior Building Plumbing Contain Copper Pipes with Lead Solder Installed Before Your State's Lead Band (Generally 1986-1988), SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
CurrentLCRSmplingSite (type: esriFieldTypeString, alias: Current LCR Sampling Site, SQL Type: sqlTypeOther, length: 10, nullable: true, editable: true, Coded Values: [Yes: Yes], [No: No], [Unknown: Unknown])
DateofSystmOwnLSLR (type: esriFieldTypeDate, alias: Date of System-owned LSLR, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
DateofCstmrOwnLSLR (type: esriFieldTypeDate, alias: Date of Customer-owned LSLR, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
AccNumb (type: esriFieldTypeString, alias: Account Number, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)

Templates:

Is Data Versioned: false

Has Contingent Values: false

Supports Rollback On Failure Parameter: true

Last Edit Date: 4/29/2026 1:56:15 PM

Schema Last Edit Date: 4/29/2026 1:56:15 PM

Data Last Edit Date: 4/29/2026 1:56:15 PM

Supported Operations: Query Query Pivot Query Top Features Query Analytic Query Bins Generate Renderer Validate SQL Get Estimates ConvertFormat

Layer: CNMB_ServiceLineInventory_Base (ID:20)