Street Name Signs Work Orders (Historical)

guiy-frxtTransportation14 columns

Street Sign Name Work Order has migrated to Street Sign Work Order Dataset: https://data.cityofnewyork.us/Transportation/Street-Sign-Work-Orders/qt6m-xctn Work orders are used to repair and install street name signs located at street corners.

View on NYC Open Data

Quality

A90.8 / 100

From a 500-row sample across 14 columns.

completeness95/ 25% weight

consistency79/ 20% weight

accuracy95/ 20% weight

timeliness82/ 15% weight

usability100/ 20% weight

· Has geographic keys — joinable to other NYC datasets

Related datasets

Street Sign Work Orders0.35
joins onsupport
Parking Regulation Locations and Signs0.33
joins onsupport
Real Time Passenger Information Sign Locations0.32
joins onwo
Street Resurfacing Schedule0.32
Historical Driver Application Status0.30
joins onstatus
Automated Traffic Volume Counts0.30

Geography

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

Sample rows

batchno	wo	createddate	assigneddate	status	nodeid	boro	support	supportaction	streetsignname	signaction	size
B-1003	110	2018-06-20T15:31:12.000	2018-06-22T13:58:34.000	W/CONTRACTOR	104285	Queens	Pipe	Install	174 St	Install	30
B-1003	110

Columns

14 queryable · 14 profiled

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

Field	Type	Description	Null	Values
`batchno`	categorical	—	0%	`B-1012B-1011Un assigned`of 8
`wo`	integer	—	0%	`39120562609`
`createddate`	datetime	—	0%	`2018-09-06T15:28:07.0002018-07-18T10:38:30.0002020-11-27T13:43:25.000`
`assigneddate`	datetime	—	25%	`2021-04-16T19:01:11.0002021-02-11T18:35:45.0002018-07-11T12:43:43.000`

Query this from your own app

GET /api/datasets/guiy-frxt
GET /api/datasets/guiy-frxt/quality
GET /api/datasets/guiy-frxt/related
GET /api/columns?dataset=guiy-frxt