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

Automated Traffic Volume Counts

7ym2-waytTransportation14 columns
New York City Department of Transportation (NYC DOT) uses Automated Traffic Recorders (ATR) to collect traffic sample volume counts at bridge crossings and roadways.These counts do not cover the entire year, and the number of days counted per location may vary from year to year.
View on NYC Open Data↗

Quality

B89.4 / 100

From a 500-row sample across 14 columns.

completeness100/ 25% weight
consistency71/ 20% weight
accuracy99/ 20% weight
timeliness82/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has geographic keys — joinable to other NYC datasets

Related datasets

  • Traffic Volume Counts (Historical)0.59
    joins ondirectionsegmentid
  • DOT Traffic Speeds0.33
  • Street Closures due to Construction Activities by Block0.32
    joins onsegmentid
  • TLC Approved LabCorp Patient Services Drug Test Locations0.31
  • Medallion Vehicles - Inactive0.31
  • 2017 Yellow Taxi Trip Data0.30
  • Bus Breakdown and Delays0.29

Geography

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

Sample rows

requestidboroyrmdhhmmvolsegmentidwktgeomstreetfromst
12512Queens201337415555135POINT (1035363.4 185093.4)122 PLSUTTER AV
12512Queens20133

Columns

14 queryable · 14 profiled

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

FieldTypeDescriptionNullValues
requestidintegerAn unique ID that is generated for each counts request.0%329702800634815
borocategoricalLists which of the five administrative divisions of New York City the location is within, written as a word0%QueensBrooklynManhattanof 5
yrintegerThe two digit year portion of the date when the count was conducted.0%201020142016
mcategoricalThe two digit month portion of the date when the count was conducted.0%510

Query this from your own app

GET /api/datasets/7ym2-wayt
GET /api/datasets/7ym2-wayt/quality
GET /api/datasets/7ym2-wayt/related
GET /api/columns?dataset=7ym2-wayt
joins onboro
  • FHV Base Aggregate Report0.29
    • 7
    4
    30
    8
    55135
    POINT (1035363.4 185093.4)
    122 PL
    SUTTER AV
    12512Queens201337445855135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens20133750755135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens201337515955135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens201337530455135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens201337545855135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens201337601355135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens2013376152755135POINT (1035363.4 185093.4)122 PLSUTTER AV
    12512Queens2013376301755135POINT (1035363.4 185093.4)122 PLSUTTER AV

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

    3
    of 12
    dintegerThe two digit day portion of the date when the count was conducted.0%11910
    hhintegerThe two digit hour portion of the time when the count was conducted.0%879
    mmcategoricalThe two digit start minute portion of the time when the count was conducted.0%01530of 8
    volintegerThe total sum of count collected within a 15 minute increments.0%012
    segmentidintegerThe ID that identifies each segment of a street in the LION street network version 14.0%728878362434332
    wktgeomtextA text markup language for representing vector geometry objects on a map and spatial reference systems of spatial objects.0%POINT (1024642.826238825…POINT (987087.2195708795…POINT (1007807.310218901…
    streettextThe 'On Street' where the count took place.0%BROADWAY111 STREETLINDEN BOULEVARD
    fromsttextThe 'From Street' where the count took place.0%Dead EndDead endHarlem River Shoreline
    tosttextThe 'To Street' where the count took place.0%Dead endHarlem River ShorelineBODY OF WATER
    directioncategoricalThe text-based direction of traffic where the count took place.0%NBSBEBof 6