Lead Service Line Location Coordinates

jqfp-uff7Environment9 columns

The Department of Environmental Protection (DEP) is offering the following data to provide residents and property owners with information regarding their water service lines.

View on NYC Open Data

Quality

B89.6 / 100

From a 500-row sample across 9 columns.

completeness100/ 25% weight

consistency78/ 20% weight

accuracy97/ 20% weight

timeliness78/ 15% weight

usability90/ 20% weight

· No obvious temporal column — limits time-series joins
· Has geographic keys — joinable to other NYC datasets

Related datasets

New York City's Flood Vulnerability Index0.33
joins onthe_geom
Water and Sewer Permits (Historic)0.30
Local Law 84 Monthly Data (Calendar Year)0.30
Historic Land Use Data0.29
NYCDEP Recreation Area Maps0.27
Watershed Water Quality Data0.27
New York City Climate Projections: Temperature and Precipitation0.27

Geography

Has street addresses (`address`) — needs geocoding before it can be drawn.

Sample rows

the_geom	objectid	tbbl	shape_area	shape_leng	address	material	record_ty	city_owned
{"type":"MultiPolygon","coordinates":[[[[-74.04269514356403,40.69005662619552],[-74.0425594671567,40.690022230055106],[-74.04264761176623,40.68974096072732],[-74.04383075371672,40.68993983226053],[-74.04384877171407,40.68992773691879],[-74.04371208813116,40.68918219982018],[-74.04399408396961,40.68888892928792],[-74.04476791089778,40.688754398562935],[-74.0454010481542,40.688930591674854],[-74.04595701437228,40.689326778815975],[-74.04641432633052,40.690014563191845],[-74.04755387795808,40.68957553892502],[-74.04767078237079,40.68975199477988],[-74.04690637146851,40.69004649310133],[-74.047330468548,40.69068430168526],[-74.04698533002136,40.690817268787995],[-74.04706544992848,40.690937761662845],[-74.04678450534088,40.691042997628],[-74.04467492753926,40.69062157532036],[-74.04396208821038,40.69006636014297],[-74.04303126424533,40.68990990283614],[-74.04293832380718,40.68999466958992],[-74.04274598202713,40.689937923239235],[-74.04269514356403,40.69005662619552]]]]}

Columns

9 queryable · 8 profiled

The machine field names SoQL needs, with the publisher's own description of each.

Field	Type	Description	Null	Values
`the_geom`	unknown	Geometry column used for mapping	—	—
`objectid`	integer	Sequential unique whole numbers that are automatically generated	0%	`282804616133461061`
`tbbl`	text	A concatenation of the borough code, tax block and tax lot	0%	`404556006130154801284110780020`
`shape_area`	float	Area of feature in internal units squared	0%	`4000.07903214000.008295054260.86224556`
`shape_leng`	integer

Query this from your own app

GET /api/datasets/jqfp-uff7
GET /api/datasets/jqfp-uff7/quality
GET /api/datasets/jqfp-uff7/related
GET /api/columns?dataset=jqfp-uff7