Commissioner's Correspondence

b4mf-rg6hTransportation45 columns

DOT receives, tracks, and responds to correspondences sent to the Commissioner's Correspondence Unit (CCU) and Borough Commissioner’s (BC) offices. This includes some requests initially sent to 311 and the Mayor's Office, and then forwarded to DOT.

View on NYC Open Data

Quality

B85.3 / 100

From a 500-row sample across 31 columns.

completeness56/ 25% weight

consistency82/ 20% weight

accuracy99/ 20% weight

timeliness100/ 15% weight

usability100/ 20% weight

· Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

Sidewalk Correspondences (Historical)0.37
joins onboroughlatitudelongitude
Street Construction Permits (2022 - Present)0.33
Street Sign Work Orders0.31
joins onborough
Bus Breakdown and Delays0.30
Open Restaurant Applications (Historical)0.30
joins onboroughlatitudelongitude
Sidewalk Management Database - Violations0.29

Geography

Mappable — coordinate pair `latitude` / `longitude`.

Open on the map →

Sample rows

createddate	casenumber	casechannel	casetopic	caseissue	caseaddressedto	clienttype	translationneeded	pressname	acknowledgesent	locationtype	status
2009-05-20T04:00:00.000	DOT-192139-Y7P4	Email	Other	Concern	Customer Service	Citizen	No	0	2009-06-04T04:00:00.000	Citywide Concern	Resolved
2009-04-23T04:00:00.000

Columns

45 queryable · 45 profiled

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

Field	Type	Description	Null	Values
`createddate`	datetime	—	0%	`2013-04-30T04:00:00.0002013-06-25T04:00:00.0002012-11-30T05:00:00.000`
`casenumber`	text	—	0%	`DOT-396555-P6R8DOT-521200-N0L6DOT-57323-P8H6`
`seibelnumber`	text	—	81%	`EC-01613753EC-013993161-1-5644485`
`casechannel`	categorical	—	0%	`Web FormEmailLetter`of 9

Query this from your own app

GET /api/datasets/b4mf-rg6h
GET /api/datasets/b4mf-rg6h/quality
GET /api/datasets/b4mf-rg6h/related
GET /api/columns?dataset=b4mf-rg6h