View In:   ArcGIS Online Map Viewer

Name: SLI_Status_181120

Display Field: survey_name

Type: Feature Layer

Geometry Type: esriGeometryPolygon

Description: This map displays the lead service line inventory status with the service areas of community public water system in California. The attributes for each water system include the number of lead or unknown material service lines or fittings, a link to the certification form for all systems that submitted one, a link to a map of locations with lead or unknown material service lines or fittings if applicable. This layer is intended for public viewing, there are no use constraints.

Service Item Id: 6237c5cf1c804c919daa612568455615

Copyright Text: Service Area shapefile downloaded from http://www.cehtp.org/water/, Lead Service Line inventory data was exported from the 2017 EAR, Certification forms and maps uploaded to DRINC portal by water systems as part of the LSLR invetory.

Default Visibility: true

MaxRecordCount: 3000

MaxSelectionCount: 0

Supported Query Formats: JSON, geoJSON, PBF

Min Scale: 0.0

Max Scale: 0.0

Supports Advanced Queries: true

Supports Statistics: true

Use Standardized Queries: true

Supports ValidateSQL: true

Supports Calculate: true

Extent:

XMin: -124.31608999999997
YMin: 32.534250000000156
XMax: -114.16859114999988
YMax: 41.99870700000014
Spatial Reference: 0  (0)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Unique Value Renderer:
Field 1: sli_status
Field 2: N/A
Field 3: N/A
Field Delimiter: ,
Default Symbol:
N/A
Default Label: N/A
UniqueValueInfos:
• Value: Inventory incomplete
  Label: Inventory incomplete; EAR section missing data
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 255, 115, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Lead service lines or fittings
  Label: 1 or more Lead service lines or fittings
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [255, 0, 0, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: No lead or unknown materials
  Label: No lead/No unknown materials service lines or fittings
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [204, 204, 204, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
• Value: Unknown service lines reported
  Label: 1 or more Unknown service lines or fittings
  Description: N/A
  Symbol:
  Style: esriSFSSolid
  Color: [197, 0, 255, 255]
  Outline:
  Style: esriSLSSolid
  Color: [110, 110, 110, 255]
  Width: 0
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: true
Supports Binning LOD: true
Supports Query With LOD Spatial Reference: true
Supports Percentile Statistics: true
Supports Having Clause: true
Supports Count Distinct: true
Supports Time Relation: false
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: sli_status

Fields:

• objectid ( nullable: false, editable: false, defaultValue: null, alias: objectid, type: esriFieldTypeOID )
• pwsid ( nullable: true, editable: true, defaultValue: null, length: 254, alias: pwsid, type: esriFieldTypeString )
• sli_status ( nullable: true, editable: true, defaultValue: null, length: 100, alias: Service Line Inventory Status, type: esriFieldTypeString )
• objectid_1 ( nullable: true, editable: true, defaultValue: null, alias: objectid_1, type: esriFieldTypeInteger )
• regulating_agency ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Regulating_Agency, type: esriFieldTypeString )
• county ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: COUNTY, type: esriFieldTypeString )
• survey_name ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: SURVEY_NAME, type: esriFieldTypeString )
• pwsid_1 ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: PWSID, type: esriFieldTypeString )
• water_system_name ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: Water_System_Name, type: esriFieldTypeString )
• status ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: STATUS, type: esriFieldTypeString )
• ear_completed ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: EAR_COMPLETED, type: esriFieldTypeString )
• lsl_reported_serv_conn ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: LSL_REPORTED_SERV_CONN, type: esriFieldTypeString )
• curr_sc ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CURR_SC, type: esriFieldTypeString )
• lead_status ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: LEAD_STATUS, type: esriFieldTypeString )
• reported_inventory_date ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: REPORTED_INVENTORY_DATE, type: esriFieldTypeString )
• lead_lines ( nullable: true, editable: true, defaultValue: null, alias: LEAD_LINES, type: esriFieldTypeInteger )
• unknown_lines ( nullable: true, editable: true, defaultValue: null, alias: UNKNOWN_LINES, type: esriFieldTypeInteger )
• total_lines ( nullable: true, editable: true, defaultValue: null, alias: TOTAL_LINES, type: esriFieldTypeInteger )
• lead_length ( nullable: true, editable: true, defaultValue: null, alias: LEAD_LENGTH, type: esriFieldTypeInteger )
• unknown_length ( nullable: true, editable: true, defaultValue: null, alias: UNKNOWN_LENGTH, type: esriFieldTypeInteger )
• lead_fittings_not_on_lead_line ( nullable: true, editable: true, defaultValue: null, alias: LEAD_FITTINGS_NOT_ON_LEAD_LINE, type: esriFieldTypeInteger )
• lead_fittings_on_lead_line ( nullable: true, editable: true, defaultValue: null, alias: LEAD_FITTINGS_ON_LEAD_LINE, type: esriFieldTypeInteger )
• unknown_fittings ( nullable: true, editable: true, defaultValue: null, alias: UNKNOWN_FITTINGS, type: esriFieldTypeInteger )
• sum_lead_fittings_not_on_lead_l ( nullable: true, editable: true, defaultValue: null, alias: SUM_LEAD_FITTINGS_NOT_ON_LEAD_LINE, type: esriFieldTypeInteger )
• cert_form_hyperlink ( nullable: true, editable: true, defaultValue: null, length: 8000, alias: CERT_FORM_HYPERLINK, type: esriFieldTypeString )
• maplink ( nullable: true, editable: true, defaultValue: null, length: 225, alias: maplink, type: esriFieldTypeString )
• SHAPE__Length ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Length, type: esriFieldTypeDouble )
• SHAPE__Area ( virtual: true, nullable: true, editable: false, defaultValue: null, alias: SHAPE__Area, type: esriFieldTypeDouble )

Types:

ID: Inventory incomplete
Name: Inventory incomplete
Domains:
Templates:
• Name: Inventory incomplete
  Description:
  Prototype:
  unknown_fittings: null
  lsl_reported_serv_conn: null
  pwsid: null
  county: null
  pwsid_1: null
  reported_inventory_date: null
  lead_fittings_not_on_lead_line: null
  sli_status: Inventory incomplete
  curr_sc: null
  lead_fittings_on_lead_line: null
  ear_completed: null
  water_system_name: null
  regulating_agency: null
  survey_name: null
  lead_lines: null
  lead_status: null
  cert_form_hyperlink: null
  total_lines: null
  unknown_lines: null
  objectid_1: null
  unknown_length: null
  maplink: null
  sum_lead_fittings_not_on_lead_l: null
  status: null
  lead_length: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Lead service lines or fittings
Name: Lead service lines or fittings
Domains:
Templates:
• Name: Lead service lines or fittings
  Description:
  Prototype:
  unknown_fittings: null
  lsl_reported_serv_conn: null
  pwsid: null
  county: null
  pwsid_1: null
  reported_inventory_date: null
  lead_fittings_not_on_lead_line: null
  sli_status: Lead service lines or fittings
  curr_sc: null
  lead_fittings_on_lead_line: null
  ear_completed: null
  water_system_name: null
  regulating_agency: null
  survey_name: null
  lead_lines: null
  lead_status: null
  cert_form_hyperlink: null
  total_lines: null
  unknown_lines: null
  objectid_1: null
  unknown_length: null
  maplink: null
  sum_lead_fittings_not_on_lead_l: null
  status: null
  lead_length: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: No lead or unknown materials
Name: No lead or unknown materials
Domains:
Templates:
• Name: No lead or unknown materials
  Description:
  Prototype:
  unknown_fittings: null
  lsl_reported_serv_conn: null
  pwsid: null
  county: null
  pwsid_1: null
  reported_inventory_date: null
  lead_fittings_not_on_lead_line: null
  sli_status: No lead or unknown materials
  curr_sc: null
  lead_fittings_on_lead_line: null
  ear_completed: null
  water_system_name: null
  regulating_agency: null
  survey_name: null
  lead_lines: null
  lead_status: null
  cert_form_hyperlink: null
  total_lines: null
  unknown_lines: null
  objectid_1: null
  unknown_length: null
  maplink: null
  sum_lead_fittings_not_on_lead_l: null
  status: null
  lead_length: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

ID: Unknown service lines reported
Name: Unknown service lines reported
Domains:
Templates:
• Name: Unknown service lines reported
  Description:
  Prototype:
  unknown_fittings: null
  lsl_reported_serv_conn: null
  pwsid: null
  county: null
  pwsid_1: null
  reported_inventory_date: null
  lead_fittings_not_on_lead_line: null
  sli_status: Unknown service lines reported
  curr_sc: null
  lead_fittings_on_lead_line: null
  ear_completed: null
  water_system_name: null
  regulating_agency: null
  survey_name: null
  lead_lines: null
  lead_status: null
  cert_form_hyperlink: null
  total_lines: null
  unknown_lines: null
  objectid_1: null
  unknown_length: null
  maplink: null
  sum_lead_fittings_not_on_lead_l: null
  status: null
  lead_length: null
  
  Drawing Tool: esriFeatureEditToolPolygon

---

Capabilities: Query

Sync Can Return Changes: true

Is Data Versioned: false

Supports Rollback On Failure: true

Supports ApplyEdits With Global Ids: false

Supports ApplyEdits By Upload Id: true

Supports Query With Historic Moment: false

Supports Coordinates Quantization: true

Child Resources:

Supported Operations:   Query   Query Attachments   Query Analytic   Query Top Features   Query Bins   Append   Validate SQL   Generate Renderer   Return Updates   Metadata   Update Metadata