Data·Citizenan agentic layer over NYC Open Data
CatalogExploreAnalyticsMapAsk the agentFindingsGuideStatus
Data from NYC Open Data via the Socrata Discovery API. Quality scores are computed from a sample and are indicative, not authoritative.
← Catalog

Street Sign Work Orders

qt6m-xctnTransportation25 columns
Department of Transportation manages approximately 1,000,000 signs on the streets of New York. This dataset contains completed sign installations for current and historical signs, including regulatory, warning, guide and parking.
View on NYC Open Data↗

Quality

B87.6 / 100

From a 500-row sample across 25 columns.

completeness62/ 25% weight
consistency90/ 20% weight
accuracy96/ 20% weight
timeliness100/ 15% weight
usability100/ 20% weight
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Parking Regulation Locations and Signs0.82
    joins onsign_notessign_sizeto_street+22
  • Street Resurfacing Schedule0.37
  • Traffic Volume Counts (Historical)0.35
  • Street Construction Inspections and Corrective Action Requests0.35
  • Sidewalk Management Database - Violations0.35
  • Street Pothole Work Orders - Closed (Dataset)0.35

Geography

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

Sample rows

order_numberrecord_typeorder_typeboroughon_streetfrom_streetside_of_streetorder_completed_on_datesign_codesign_descriptionsign_sizesign_location
R-01673513HistoricalR-BrooklynDEKALB AVENUELEWIS AVENUE@2023-10-04T00:00:00.000R6-1ONE WAY ARROW036 X 012S/E C
S-01505617

Columns

25 queryable · 25 profiled

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

FieldTypeDescriptionNullValues
order_numbertext—0%R-01301846P-01280786P-01503914
record_typecategorical—0%HistoricalCurrentof 2
order_typecategorical—0%R-S-P-of 12
boroughcategorical—0%BrooklynQueensManhattanof 5
on_street

Query this from your own app

GET /api/datasets/qt6m-xctn
GET /api/datasets/qt6m-xctn/quality
GET /api/datasets/qt6m-xctn/related
GET /api/columns?dataset=qt6m-xctn
  • Historical Driver Application Status0.34
  • Open Restaurants Inspections (Historical)0.34
    joins onborough
    • Historical
    S-
    Brooklyn
    AVENUE U
    EAST 9 STREET
    S
    2021-04-29T00:00:00.000
    CL
    CURB LINE
    N/A
    —
    R-786719HistoricalR-ManhattanWEST 11 STREETWASHINGTON STREETS2009-04-10T00:00:00.000CLCURB LINEN/A—
    S-01676600CurrentS-BronxNETHERLAND AVENUEWEST 236 STREETE2023-10-24T00:00:00.000PLPROPERTY LINEN/A—
    S-922068HistoricalS-Queens83 DRIVEKEW GARDENS ROADN1995-02-14T00:00:00.000CLCURB LINEN/A—
    R-01676464HistoricalR-Queens60 STREET59 DRIVE@2023-10-23T00:00:00.000R6-1ONE WAY ARROW036 X 012S/E C
    S-065863HistoricalS-ManhattanGOUVERNEUR STREETWATER STREETE2000-12-27T00:00:00.000CLCURB LINEN/A—
    R-01673596HistoricalR-QueensMASPETH AVENUEMAURICE AVENUE@2023-10-04T00:00:00.000SI-184GTRUCK ROUTE W/ TRUCK SYMBOL036 X 024*NOTE
    R-01672631HistoricalR-Manhattan6 AVENUEWEST 14 STREET@2023-10-04T00:00:00.000R6-1ONE WAY ARROW036 X 012N/E C
    S-953270HistoricalS-Brooklyn21 AVENUE66 STREETW1997-10-23T00:00:00.000CLCURB LINEN/A—

    Showing 12 of 21 columns. All of them are listed below.

    text
    —
    0%
    BROADWAY3 AVENUE5 AVENUE
    on_street_suffixtext—97%N S/RS S/RW S/R
    from_streettext—0%BROADWAY3 AVENUE5 AVENUE
    from_street_suffixtext—99%EXT RAMPS RDWYN
    to_streettext—37%BROADWAY5 AVENUEDEAD END
    to_street_suffixtext—100%ENT RAMPSS RDWY
    side_of_streetcategorical—0%@SNof 5
    order_completed_on_datedatetime—0%1993-07-17T00:00:00.0001982-01-01T00:00:00.0001995-10-31T00:00:00.000
    sign_codetext—0%CLR6-1PL
    sign_descriptiontext—0%CURB LINEONE WAY ARROWPROPERTY LINE
    sign_sizetext—0%N/A018 X 012030 X 030
    sign_design_voided_on_datedatetime—77%2019-05-22T00:00:00.0002017-06-02T00:00:00.0002026-04-06T00:00:00.000
    sign_locationtext—63%N/E CS/W CS/E C
    distance_from_intersectioninteger—0%01510
    arrow_directioncategorical—80%NorthSouthWestof 12
    facing_directioncategorical—73%NorthSouthEastof 10
    sheeting_typecategorical—32%PNTDTIIIENGGof 5
    supporttext—22%DRSAMELP
    sign_notestext—84%UNDER PREVIOUS SEQ.15 MPHSUPERCEDES SCHOOL MAP FI…
    sign_x_coordtext—51%965889963370997180
    sign_y_coordtext—51%163012194092173227