Sidewalk Management Database - Lot Info

i642-2fxqTransportation5 columns

Sidewalk Management System is used to track and organize inspections, violations and the status of New York City sidewalks. This identifies sidewalk locations by borough, block and lot numbers. For more information please visit NYC DOT website: www.nyc.gov/sidewalks

View on NYC Open Data

Quality

B89.7 / 100

From a 500-row sample across 5 columns.

completeness100/ 25% weight

consistency60/ 20% weight

accuracy98/ 20% weight

timeliness100/ 15% weight

usability90/ 20% weight

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

Related datasets

Sidewalk Management Database - All Tree Damage (ATD)0.58
joins onbblid
Sidewalk Management Database - Inspection0.56
Sidewalk Management Database - ReInspection0.55
Sidewalk Management Database - Built0.55
joins onbblid
Sidewalk Management Database - Violations0.54
joins onbblid
Sidewalk Weekly Construction Schedule0.33

Geography

Has borough codes (`boro`) — joinable, but needs boundary shapes to draw.

Sample rows

bblid	block	boro	lot	zipcode
479840	6685	3	115	11223-3233
479841	6689	3	73	11230-2421
479842	6685	3	116	11223-3233
479843	6689	3	75	11230-2421
479844

Columns

5 queryable · 5 profiled

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

Field	Type	Description	Null	Values
`bblid`	integer	The ID number assigned to a Borough-Block-Lot (BBL) value in the Lotinfo table; BBLID is an identifier for a BBL and should not be interpreted as the BBL itself.	0%	`527545799817932`
`block`	integer	The unique tax block number.	0%	`1639441171`
`boro`	categorical	The one digit New York City borough code for the block and lot.	0%	`431`of 5
`lot`	integer	The unique lot number.	0%	`12015`

Query this from your own app

GET /api/datasets/i642-2fxq
GET /api/datasets/i642-2fxq/quality
GET /api/datasets/i642-2fxq/related
GET /api/columns?dataset=i642-2fxq