Name: Lead In Drinking Water

Display Field: FACILITY_NAME

Type: Feature Layer

Geometry Type: esriGeometryPoint

Description: Data provides information on lead sampling results for drinking water at licensed child development facilities across Washington, DC. Sampling is conducted by the District Department of Energy & Environment (DOEE) to assist facilities in accordance with the Childhood Lead Exposure Prevention Amendment Act of 2017 and D.C. Code § 7-2051, which requires testing for lead in drinking water at child development facilities. The dataset covers calendar years 2018 through 2026 and includes facilities in all eight Wards. Data are updated monthly as new results become available. Users can explore facility‑level sampling results, Ward‑level trends, and compliance information. Sampling results include detected lead values, non-detects, and indicators for whether lead levels met or exceeded the 5-ppb threshold that requires corrective actions such as tagging outlets out of service, installing filters, or providing alternative drinking water.Symbols such as "<" indicate values below detection limits, while "≥" indicates results equal to or above defined thresholds. This dashboard allows users to view mapped facility locations, filter results by year, ward, address, and facility name, and access resources on reducing exposure to lead in drinking water and information about District partners working in collaboration to prevent childhood lead poisoning.

Copyright Text: Department of Energy and Environment

Default Visibility: false

MaxRecordCount: 1000

MaxSelectionCount: 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: -8583389.496555258
YMin: 4696086.690899753
XMax: -8561722.455512177
YMax: 4719557.596096933
Spatial Reference: 102100  (3857)  LatestVCSWkid(0)

Drawing Info:

Renderer:
Simple Renderer:
Symbol:
Style: esriSMSCircle
Color: [158, 69, 72, 255]
Size: 4.0
Angle: 0.0
XOffset: 0
YOffset: 0
Outline:
[0, 0, 0, 255] Width: 0
Label: N/A
Description: N/A
Transparency: 0
Labeling Info:

Feature Draw Order:

N/A

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: FID )
• LICENSE_NUMBER ( type: esriFieldTypeString, alias: License Number, length: 50 )
• FACILITY_NAME ( type: esriFieldTypeString, alias: Facility Name, length: 200 )
• PHYSICAL_ADDRESS ( type: esriFieldTypeString, alias: Physical Address, length: 200 )
• ADDRESS_FOR_GEOCODE ( type: esriFieldTypeString, alias: Address For Geocode, length: 200 )
• DC_WARD ( type: esriFieldTypeInteger, alias: DC Ward )
• SOURCE_ID ( type: esriFieldTypeString, alias: Source Identifier, length: 30 )
• SAMPLE_NUMBER ( type: esriFieldTypeString, alias: Sample Number, length: 30 )
• SAMPLE_TYPE ( type: esriFieldTypeString, alias: Sample Type, length: 50 )
• SAMPLE_COLLECTION_DATE ( type: esriFieldTypeDate, alias: Sample Collection Date, length: 8 )
• SAMPLE_COLLECTION_TIME ( type: esriFieldTypeString, alias: Sample Collection Time, length: 10 )
• ANALYTICAL_RESULT ( type: esriFieldTypeDouble, alias: Analytical Result in Parts Per Billion )
• ELEVATED_LEAD ( type: esriFieldTypeString, alias: Elevated Lead Concentration, length: 10 )
• YEAR ( type: esriFieldTypeInteger, alias: Year )
• FACILITY_COUNTER_CHART ( type: esriFieldTypeInteger, alias: Facility Counter Chart )
• FACILITY_COUNT ( type: esriFieldTypeInteger, alias: Facility Count )
• FACILITY_MONTH_LINK_KEY ( type: esriFieldTypeString, alias: Facility Month Link Key, length: 255 )
• SOFT_DELETE ( type: esriFieldTypeString, alias: Soft Delete, length: 10 )
• ELEVATED_BLOOD_LEAD_SAMPLES ( type: esriFieldTypeInteger, alias: Elevated Blood Lead Samples )
• NUMBER_OF_FACILITIES_SAMPLED ( type: esriFieldTypeInteger, alias: Number of Facilities Sampled )
• NUMBER_SAMPLES_GREATER_THAN_5P ( type: esriFieldTypeInteger, alias: Number of Samples Greater Than 5 Parts Per Billion )
• NUMBER_OF_FACILITIES ( type: esriFieldTypeInteger, alias: Number of Facilities )
• MAR_MARID ( type: esriFieldTypeInteger, alias: Master Address Repository Identifier )
• MAR_MATCHADDRESS ( type: esriFieldTypeString, alias: Master Address Repository Match Address, length: 255 )
• MAR_XCOORD ( type: esriFieldTypeDouble, alias: Master Address Repository X Coordinate )
• MAR_YCOORD ( type: esriFieldTypeDouble, alias: Master Address Repository Y Coordinate )
• LATITUDE ( type: esriFieldTypeDouble, alias: Master Address Repository Latitude )
• LONGITUDE ( type: esriFieldTypeDouble, alias: Master Address Repository Longitude )
• MAR_WARD ( type: esriFieldTypeString, alias: Master Address Repository Ward , length: 20 )
• MAR_ANC ( type: esriFieldTypeString, alias: Advisory Neighborhood Commission, length: 20 )
• MAR_RESIDENCETYPE ( type: esriFieldTypeString, alias: Master Address Repository Residence Type, length: 30 )
• SE_ANNO_CAD_DATA ( type: esriFieldTypeBlob, alias: SE_ANNO_CAD_DATA )
• GLOBALID ( type: esriFieldTypeGlobalID, alias: GLOBALID, length: 38 )
• SHAPE ( type: esriFieldTypeGeometry, alias: SHAPE )

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

  Iteminfo   Thumbnail   Metadata