About this Dataset

Bi-Annual Pedestrian Counts

An index of pedestrian volumes tracking the long-term trends of neighborhood commercial corridors. Data is collected at 114 locations, including 100 on-street locations (primarily retail corridors), 13 East River and Harlem River bridge locations, and the Hudson River Greenway. Screenline sampling is conducted during May and September on the sidewalk, mid-block (or mid-bridge) on both sides of street where applicable. Pedestrian volumes at 50 sample locations around the City are combined to create the Pedestrian Volume Index for the Mayor’s Management Report.

Click here for metadata - http://www.nyc.gov/html/dot/downloads/pdf/bi-annual-ped-count-readme.pdf
Organization: City of New York
Last updated: 2024-11-15T21:11:51.713584

Tables

Table 1

@usgov.city_of_new_york_bi_annual_pedestrian_counts_6cc0a.table_1

142.35 kB
114 rows
110 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "loc" BIGINT,
  "borough" VARCHAR,
  "street_nam" VARCHAR,
  "from_stree" VARCHAR,
  "to_street" VARCHAR,
  "iex" VARCHAR,
  "may07_am" BIGINT,
  "may07_pm" BIGINT,
  "may07_md" BIGINT,
  "sept07_am" BIGINT,
  "sept07_pm" BIGINT,
  "sept07_md" BIGINT,
  "may08_am" BIGINT,
  "may08_pm" BIGINT,
  "may08_md" BIGINT,
  "sept08_am" BIGINT,
  "sept08_pm" BIGINT,
  "sept08_md" BIGINT,
  "may09_am" BIGINT,
  "may09_pm" BIGINT,
  "may09_md" BIGINT,
  "sept09_am" BIGINT,
  "sept09_pm" BIGINT,
  "sept09_md" BIGINT,
  "may10_am" BIGINT,
  "may10_pm" BIGINT,
  "may10_md" BIGINT,
  "sept10_am" BIGINT,
  "sept10_pm" BIGINT,
  "sept10_md" BIGINT,
  "may11_am" BIGINT,
  "may11_pm" BIGINT,
  "may11_md" BIGINT,
  "sept11_am" BIGINT,
  "sept11_pm" BIGINT,
  "sept11_md" BIGINT,
  "may12_am" BIGINT,
  "may12_pm" BIGINT,
  "may12_md" BIGINT,
  "sept12_am" BIGINT,
  "sept12_pm" BIGINT,
  "sept12_md" BIGINT,
  "may13_am" BIGINT,
  "may13_pm" BIGINT,
  "may13_md" BIGINT,
  "sept13_am" BIGINT,
  "sept13_pm" BIGINT,
  "sept13_md" BIGINT,
  "may14_am" BIGINT,
  "may14_pm" BIGINT,
  "may14_md" BIGINT,
  "sept14_am" BIGINT,
  "sept14_pm" BIGINT,
  "sept14_md" BIGINT,
  "may15_am" BIGINT,
  "may15_pm" BIGINT,
  "may15_md" BIGINT,
  "sept15_am" BIGINT,
  "sept15_pm" BIGINT,
  "sept15_md" BIGINT,
  "may16_am" BIGINT,
  "may16_pm" BIGINT,
  "may16_md" BIGINT,
  "sept16_am" BIGINT,
  "sept16_pm" BIGINT,
  "sept16_md" BIGINT,
  "may17_am" BIGINT,
  "may17_pm" BIGINT,
  "may17_md" BIGINT,
  "sept17_am" BIGINT,
  "sept17_pm" BIGINT,
  "sept17_md" BIGINT,
  "may18_am" BIGINT,
  "may18_pm" BIGINT,
  "may18_md" BIGINT,
  "sept18_am" BIGINT,
  "sept18_pm" BIGINT,
  "sept18_md" BIGINT,
  "may19_am" BIGINT,
  "may19_pm" BIGINT,
  "may19_md" BIGINT,
  "oct20_am" BIGINT,
  "oct20_pm" BIGINT,
  "oct20_md" BIGINT,
  "may21_am" BIGINT,
  "may21_pm" BIGINT,
  "may21_md" BIGINT,
  "oct21_am" DOUBLE,
  "oct21_pm" BIGINT,
  "oct21_md" DOUBLE,
  "may22_am" BIGINT,
  "may22_pm" BIGINT,
  "may22_md" BIGINT,
  "oct22_am" BIGINT,
  "oct22_pm" BIGINT,
  "oct22_md" BIGINT,
  "may23_am" BIGINT,
  "may23_pm" BIGINT
);