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

New York City Truck Routes

jjja-shxyTransportation23 columns
The New York City Truck Route Network is a set of roads that commercial vehicles must use in New York City. NYC Truck Routes are also available in LION data. https://data.cityofnewyork.us/City-Government/LION/2v4z-66xt
View on NYC Open Data↗

Quality

B83.0 / 100

From a 500-row sample across 23 columns.

completeness71/ 25% weight
consistency78/ 20% weight
accuracy98/ 20% weight
timeliness80/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Parking Meters - ParkNYC Block Faces0.32
    joins onthe_geomshape_leng
  • Parking Meters Locations and Status0.30
  • Taxi and For Hire Vehicle (FHV) Relief Stands0.30
    joins onthe_geom
  • Traffic Volume Counts (Historical)0.30
    joins onsegmentid
  • TLC Driver Exam Testing Center Locations0.30
  • Street Resurfacing Schedule0.29

Geography

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

Sample rows

the_geomobjectid_1streetstreetcoderoutetypeboronamerestrictioborocodetruckrouteltdlocalnyc_regsegmentid
{"type":"MultiLineString","coordinates":[[[-73.9073328972562,40.853816414220894],[-73.9055700725689,40.855787322184376]]]}1.0JEROME AVENUE242820LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0073071

Columns

23 queryable · 22 profiled

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

FieldTypeDescriptionNullValues
the_geomunknown———
objectid_1integer—0%0.024481.03446.0
streettext—0%LONG ISLAND EXPRESSWAYQUEENS BOULEVARDBROADWAY
streetcodetext—0%450290459990466290
routetypecategorical—0%

Query this from your own app

GET /api/datasets/jjja-shxy
GET /api/datasets/jjja-shxy/quality
GET /api/datasets/jjja-shxy/related
GET /api/columns?dataset=jjja-shxy
2022 Yellow Taxi Trip Data
0.29
  • Street Sign Work Orders0.29
    • {"type":"MultiLineString","coordinates":[[[-73.9034172033414,40.81150688331628],[-73.90324273473266,40.8107128849091]]]}
    2.0
    EAST 149 STREET
    226130
    Local
    Bronx
    —
    2.0
    Y
    —
    NYCDOT Traffic Rules, Section 4-13-(f)(2)
    0077201
    {"type":"MultiLineString","coordinates":[[[-73.90052119946623,40.84512281047548],[-73.8993475788999,40.844737929289245]]]}3.0EAST 175 STREET226910LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0078397
    {"type":"MultiLineString","coordinates":[[[-73.83433721039573,40.872027022621374],[-73.83445854079302,40.87236150355387],[-73.83456586664148,40.87269900881651],[-73.83465901108151,40.87303902221425],[-73.83473780909308,40.873381032967266],[-73.83480217874046,40.873724509698825]]]}4.0NEW ENGLAND THRUWAY253870ThroughBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(1)0119835
    {"type":"MultiLineString","coordinates":[[[-73.86497363145573,40.88066526948053],[-73.86490445559285,40.88082042362102],[-73.86481816682199,40.88097177652515],[-73.86471539832534,40.88111771432262],[-73.86459709870695,40.88125671896007],[-73.8644645687045,40.88138740426624],[-73.86431936139405,40.88150858337487]]]}5.0WHITE PLAINS ROAD277150LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0132595
    {"type":"MultiLineString","coordinates":[[[-73.86724818914004,40.840343803534275],[-73.866361308481,40.84059268543396]]]}6.0EAST TREMONT AVENUE229620LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0107321
    {"type":"MultiLineString","coordinates":[[[-73.8647032629666,40.84155256935982],[-73.86516639854744,40.842466275615756]]]}7.0WHITE PLAINS ROAD277150LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0085997
    {"type":"MultiLineString","coordinates":[[[-73.86737121006759,40.84871631096197],[-73.86739373657203,40.84877825475126]]]}8.0WHITE PLAINS ROAD277150LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0108898
    {"type":"MultiLineString","coordinates":[[[-73.87283453865224,40.83975486303385],[-73.87277204706108,40.83975128219168]]]}9.0EAST TREMONT AVENUE229620LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0176185
    {"type":"MultiLineString","coordinates":[[[-73.86725770332306,40.83162391825064],[-73.86635554693976,40.83187448379259]]]}10.0WESTCHESTER AVENUE276950LocalBronx—2.0Y—NYCDOT Traffic Rules, Section 4-13-(f)(2)0085786

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

    LocalThroughLimited Localof 3
    boronamecategorical—0%QueensBrooklynBronxof 5
    restrictiocategorical—0%Upper Rdwy- Height-11'6"…InRd- Ht-12'11" Wt-10 To…Frm MN- Height-13'-5", F…of 12
    borocodecategorical—0%4.03.02.0of 5
    truckroutetext—0%Yof 1
    ltdlocaltext—0%Yof 2
    nyc_regcategorical—0%NYCDOT Traffic Rules, Se…NYCDOT Traffic Rules, Se…NYCDOT Traffic Rules, Se…of 9
    segmentidtext—0%025794201407640133603
    shape_lengfloat—0%66.78868610984.816146538329.9351663325
    localtunltext—0%—
    localbrgtext—0%Yof 2
    thrutunltext—0%Yof 2
    thrubrgtext—0%Yof 2
    assem_distinteger—0%63.062.082.0
    cong_distcategorical—0%11.06.015.0of 14
    coun_distinteger—0%50.051.026.0
    st_sen_disinteger—0%24.034.016.0
    thruexwytext—0%Yof 2
    borocdinteger—0%501.0402.0503.0