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

Brooklyn Bridge Automated Pedestrian Counts Demonstration Project (Historic)

6fi9-q3taTransportation21 columns
DOT is testing automated technology to count pedestrians. The counter is located on the Manhattan approach of the Brooklyn Bridge.
View on NYC Open Data↗

Quality

B86.2 / 100

From a 500-row sample across 17 columns.

completeness94/ 25% weight
consistency62/ 20% weight
accuracy100/ 20% weight
timeliness82/ 15% weight
usability90/ 20% weight
  • · No obvious temporal column — limits time-series joins
  • · Has coordinates — directly mappable, and joinable to other NYC datasets

Related datasets

  • Accessible Pedestrian Signal Locations0.39
    joins on:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+3
  • NYC DOT Pedestrian Plazas - Point Feature0.38
    joins on:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q+2
  • Automated Traffic Volume Counts0.34
  • Street Closures due to Construction Activities by Intersection0.34
    joins on:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_sbqj_enih+1

Geography

Mappable — Socrata point column `geocoded_column`.

Open on the map →

Sample rows

hour_beginninglocationpedestrianstowards_manhattantowards_brooklynlatlonggeocoded_column:@computed_region_efsh_h5xi:@computed_region_f5dn_yrer:@computed_region_yeji_bk3q:@computed_region_92fq_4b7q
2019-04-30T00:00:00.000Brooklyn Bridge33040.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432

Columns

12 queryable · 11 profiled

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

FieldTypeDescriptionNullValues
hour_beginningdatetimeDate and time of hourly count0%2019-11-03T01:00:00.0002018-03-27T06:00:00.0002019-03-25T20:00:00.000
locationtextName of site where count was obtained0%Brooklyn Bridgeof 1
pedestriansintegerTotal count (sum of directions)0%012
towards_manhattanintegerPedestrians crossing towards Manhattan0%012

Query this from your own app

GET /api/datasets/6fi9-q3ta
GET /api/datasets/6fi9-q3ta/quality
GET /api/datasets/6fi9-q3ta/related
GET /api/columns?dataset=6fi9-q3ta
  • Pedestrian Mobility Plan Pedestrian Demand0.33
  • Traffic Volume Counts (Historical)0.33
  • TLC Driver Exam Testing Center Locations0.32
    joins on:@computed_region_efsh_h5xigeocoded_column:@computed_region_f5dn_yrer+3
  • Parking Meters Locations and Status0.32
    joins on:@computed_region_efsh_h5xilat:@computed_region_f5dn_yrer+5
    • 2019-12-31T22:00:00.000Brooklyn Bridge109140.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-12-31T23:00:00.000Brooklyn Bridge20240.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-12-31T21:00:00.000Brooklyn Bridge1201240.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-04-01T03:00:00.000Brooklyn Bridge10140.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-12-25T14:00:00.000Brooklyn Bridge31711685148640.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-01-27T21:00:00.000Brooklyn Bridge135840.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-02-07T04:00:00.000Brooklyn Bridge00040.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-01-03T21:00:00.000Brooklyn Bridge97240.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432
    2019-08-13T09:00:00.000Brooklyn Bridge52028123940.7081639691088-73.999508701481640.7081639691088, -73.99950870148161309656432

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

    towards_brooklyn
    integer
    Pedestrian crossing towards Brooklyn
    0%
    012
    weather_summarycategoricalOverall daily weather (cloudy, clear, rain, etc.)0%clear-nightpartly-cloudy-dayclear-dayof 10
    temperatureintegerHourly temperature, in Fahrenheit degrees0%364238
    precipitationfloatHourly precipitation, in inches0%00.000100.00020
    latfloatlatitude0%40.7081639691088of 1
    longfloatlongitude0%-73.9995087014816of 1
    eventstextHolidays93%Christmas DayIndependence DayChristmas Eve
    geocoded_columncoordinate———