Bi-Annual Pedestrian Counts by US Government | Demographics and Population Studies

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

139.02 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
);