Name: Water Service Connections

Display Field: PWS_Name

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Within this feature class there is information for VDH based upon the requirements for the Lead Service Replacement project. These fields include information about the service lines/connections that are on city side of the water meters as well as information about the private side of the meter. Included in the layer there are fields with the pipe diameter, pipe type, lead presence, and the methods of collection, identification, and verification of the service lines.In addition to the water service line information data specific to the water meters is also included. In these fields the meter size, location, cycle, route and replacement status are shown.The Public Utilities GIS staff will update the records by using information from field crews, record drawings and other relative information. The data is updated and corrected on an as needed basis.

Service Item Id: db89f07629cc4f9e95e4f1251019950a

Copyright Text: City of Chesapeake, Department of Public Utilities

Default Visibility: false

MaxRecordCount: 2000

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Has Labels: false

Can Modify Layer: true

Can Scale Symbols: false

Use Standardized Queries: true

Supports Datum Transformation: true

Extent:

XMin: -1.1114059999359E8
YMin: -9.15320999924232E7
XMax: 1.2183140549639165E7
YMax: 3481789.009660125
Spatial Reference: 102747  (2284)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: SysMaterial
Field 2: CustMaterial
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Non-Lead - Copper,Non-Lead - Copper
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Non-Lead - Other
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Non-Lead - Plastic
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Non-Lead - Copper
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Non-Lead - Other
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Non-Lead - Plastic
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Non-Lead - Copper
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Non-Lead - Other
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Non-Lead - Plastic
  Label: Non-Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Unknown - Likely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Unknown - Material Unknown
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Unknown - Unlikely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Unknown - Likely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Unknown - Material Unknown
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Unknown - Unlikely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Unknown - Likely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Unknown - Material Unknown
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Unknown - Unlikely Lead
  Label: Non-Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Non-Lead - Plastic
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Non-Lead - Copper
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Non-Lead - Other
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Non-Lead - Plastic
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Non-Lead - Copper
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Non-Lead - Other
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Non-Lead - Copper
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Non-Lead - Other
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Non-Lead - Plastic
  Label: Unknown, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Unknown - Unlikely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Unknown - Material Unknown
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Unknown - Likely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Unknown - Unlikely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Unknown - Material Unknown
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Unknown - Likely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Unknown - Unlikely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Unknown - Material Unknown
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Unknown - Likely Lead
  Label: Unknown, Unknown
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Lead-Lined Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Lead-Lined Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Lead-Lined Galvanized
  Label: Non-Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Non-Lead - Copper
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Non-Lead - Other
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Non-Lead - Plastic
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Galvanized,Non-Lead - Copper
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Galvanized,Non-Lead - Other
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Galvanized,Non-Lead - Plastic
  Label: Galvanized, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Lead-Lined Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Lead-Lined Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Lead-Lined Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Galvanized
  Label: Unknown, Galvanized
  Description: N/A
  Symbol:
  
• Value: Galvanized,Unknown - Likely Lead
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Galvanized,Unknown - Material Unknown
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Galvanized,Unknown - Unlikely Lead
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Unknown - Likely Lead
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Unknown - Material Unknown
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Unknown - Unlikely Lead
  Label: Galvanized, Unknown
  Description: N/A
  Symbol:
  
• Value: Galvanized,Galvanized
  Label: Galvanized, Galvanized
  Description: N/A
  Symbol:
  
• Value: Galvanized,Lead-Lined Galvanized
  Label: Galvanized, Galvanized
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Galvanized
  Label: Galvanized, Galvanized
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Lead-Lined Galvanized
  Label: Galvanized, Galvanized
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Plastic,Lead
  Label: Non-Lead, Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Copper,Lead
  Label: Non-Lead, Lead
  Description: N/A
  Symbol:
  
• Value: Non-Lead - Other,Lead
  Label: Non-Lead, Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Likely Lead,Lead
  Label: Unknown, Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Material Unknown,Lead
  Label: Unknown, Lead
  Description: N/A
  Symbol:
  
• Value: Unknown - Unlikely Lead,Lead
  Label: Unknown, Lead
  Description: N/A
  Symbol:
  
• Value: Lead-Lined Galvanized,Lead
  Label: Galvanized, Lead
  Description: N/A
  Symbol:
  
• Value: Galvanized,Lead
  Label: Galvanized, Lead
  Description: N/A
  Symbol:
  
• Value: Lead,Unknown - Likely Lead
  Label: Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead,Unknown - Material Unknown
  Label: Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead,Unknown - Unlikely Lead
  Label: Lead, Unknown
  Description: N/A
  Symbol:
  
• Value: Lead,Non-Lead - Copper
  Label: Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead,Non-Lead - Other
  Label: Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead,Non-Lead - Plastic
  Label: Lead, Non-Lead
  Description: N/A
  Symbol:
  
• Value: Lead,Galvanized
  Label: Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Lead,Lead-Lined Galvanized
  Label: Lead, Galvanized
  Description: N/A
  Symbol:
  
• Value: Lead,Lead
  Label: Lead, Lead
  Description: N/A
  Symbol:
  
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: false
Supports Returning Geometry Centroid: false
Supports Binning LOD: false
Supports Query With LOD Spatial Reference: false
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: true
Supports Sql Format: false
Supports Query Analytic: true
Supports Query With Current User: true

HasZ: false

HasM: false

Has Attachments: false

HTML Popup Type: esriServerHTMLPopupTypeAsHTMLText

Type ID Field: null

Fields:

• OBJECTID ( type: esriFieldTypeOID, alias: OBJECTID )
• StreetAddress ( type: esriFieldTypeString, alias: Street Address, length: 255 )
• City_1 ( type: esriFieldTypeString, alias: City, length: 255 )
• SensitivePop ( type: esriFieldTypeString, alias: Sensitive Population?, length: 255 , Coded Values: [No: No] , [Yes - School: Yes - School] , [Yes - Daycare: Yes - Daycare] , ...2 more... )
• Disadvantaged ( type: esriFieldTypeString, alias: Disadvantaged Neighborhood?, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• SysMaterial ( type: esriFieldTypeString, alias: Sys Service Line Material Classification, length: 255 , Coded Values: [Lead: Lead] , [Lead-Lined Galvanized: Lead-Lined Galvanized] , [Galvanized: Galvanized] , ...6 more... )
• SysPrevLead ( type: esriFieldTypeString, alias: Sys if Non-Lead, Ever Previously Lead?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• SysInstDate ( type: esriFieldTypeString, alias: Sys Service Line Install Date, length: 255 )
• SysDiameter ( type: esriFieldTypeString, alias: Sys Service Line Size Inches, length: 255 , Coded Values: [3/8: 3/8] , [1/2: 1/2] , [5/8: 5/8] , ...15 more... )
• SysMatBasis ( type: esriFieldTypeString, alias: Sys Basis of Material Classification, length: 255 , 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... )
• SysMatVerif ( type: esriFieldTypeString, alias: Sys Field Verified?, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• SysMatVerifMethod ( type: esriFieldTypeString, alias: Sys Field Verification Method, length: 255 , 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] , ...5 more... )
• SysMatVerifDate ( type: esriFieldTypeString, alias: Sys Field Verification Date, length: 255 )
• SysNotes ( type: esriFieldTypeString, alias: Sys Notes, length: 255 )
• CustMaterial ( type: esriFieldTypeString, alias: Cust Service Line Material Classification, length: 255 , Coded Values: [Lead: Lead] , [Lead-Lined Galvanized: Lead-Lined Galvanized] , [Galvanized: Galvanized] , ...6 more... )
• CustInstDate ( type: esriFieldTypeString, alias: Cust Service Line Install Date, length: 255 )
• CustDiameter ( type: esriFieldTypeString, alias: Cust Service Line Size Inches, length: 255 , Coded Values: [3/8: 3/8] , [1/2: 1/2] , [5/8: 5/8] , ...15 more... )
• CustMatBasis ( type: esriFieldTypeString, alias: Cust Basis of Material Classification, length: 255 , 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... )
• CustMatVerif ( type: esriFieldTypeString, alias: Cust FIeld Verification?, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• CustMatVerifMethod ( type: esriFieldTypeString, alias: Cust Field Verification Method, length: 255 , 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] , ...5 more... )
• CustMatVerifDate ( type: esriFieldTypeString, alias: Cust Field Verification Date, length: 255 )
• CustNotes ( type: esriFieldTypeString, alias: Cust Notes, length: 255 )
• LeadConnector ( type: esriFieldTypeString, alias: Lead Connector?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• LeadSolder ( type: esriFieldTypeString, alias: Lead Solder?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Don't Know: Don't Know] )
• OtherFittings ( type: esriFieldTypeString, alias: List Other Service Line Fittings Containing Lead, length: 255 )
• BuildingType ( type: esriFieldTypeString, alias: Building Type, length: 255 , Coded Values: [Multiple Family Residence: Multiple Family Residence] , [Building: Building] , [Other: Other] , ...1 more... )
• PointOfEntry ( type: esriFieldTypeString, alias: Point-of-Entry or Point-of-Use Treatment?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• CopperWithLead ( type: esriFieldTypeString, alias: Int. Plumbing Contains Copper Pipes with Lead Solder Pre 4/86?, length: 255 , Coded Values: [Yes: Yes] , [No: No] , [Unknown: Unknown] )
• SamplingSite ( type: esriFieldTypeString, alias: Current LCR Sampling Site?, length: 255 , Coded Values: [YES: YES] , [NO: NO] )
• SysLSLRDate ( type: esriFieldTypeString, alias: Date of System-Owned LSLR, length: 255 )
• CustLSLRDate ( type: esriFieldTypeString, alias: Date of Customer-Owned LSLR, length: 255 )
• Latitude ( type: esriFieldTypeDouble, alias: Latitude )
• Longitude ( type: esriFieldTypeDouble, alias: Longitude )
• PWS_ID ( type: esriFieldTypeInteger, alias: PWS ID , Coded Values: [3550050: 3550050] , [3550051: 3550051] )
• PWS_Name ( type: esriFieldTypeString, alias: PWS Name, length: 64 , Coded Values: [Western Branch System: Western Branch System] , [Northwest River System: Northwest River System] )
• Submitted ( type: esriFieldTypeString, alias: Submitted, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• Date_Updated ( type: esriFieldTypeDate, alias: VDH Update Date, length: 8 )
• Meter_Point ( type: esriFieldTypeString, alias: Meter Point, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• SP_ID ( type: esriFieldTypeString, alias: Service Point ID, length: 25 )
• Premise_ID ( type: esriFieldTypeString, alias: Premise ID, length: 25 )
• Cycle ( type: esriFieldTypeString, alias: Cycle, length: 10 )
• Route ( type: esriFieldTypeString, alias: Route, length: 10 )
• Seq_Number ( type: esriFieldTypeString, alias: Sequence Number, length: 10 )
• Remote_Read ( type: esriFieldTypeString, alias: Remote Read?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• Install_Date ( type: esriFieldTypeDate, alias: Meter Installation Date, length: 8 )
• Meter_Size ( type: esriFieldTypeString, alias: Meter Size, length: 10 )
• Meter_Notes ( type: esriFieldTypeString, alias: Meter Notes, length: 255 )
• GPS ( type: esriFieldTypeString, alias: GPS Collected?, length: 10 , Coded Values: [YES: YES] , [NO: NO] )
• Shape ( type: esriFieldTypeGeometry, alias: Shape )
• GlobalID ( type: esriFieldTypeGlobalID, alias: GlobalID, length: 38 )
• created_user ( type: esriFieldTypeString, alias: created_user, length: 255 )
• created_date ( type: esriFieldTypeDate, alias: created_date, length: 8 )
• last_edited_user ( type: esriFieldTypeString, alias: last_edited_user, length: 255 )
• last_edited_date ( type: esriFieldTypeDate, alias: last_edited_date, length: 8 )

Supported Operations:   Query   Query Attachments   Query Analytic   Generate Renderer   Return Updates

  Iteminfo   Thumbnail   Metadata