Make My Trip Count 2015 by US Government | Environmental and Climate Sciences

About this Dataset

Make My Trip Count 2015

The Make My Trip Count (MMTC) commuter survey, conducted in September and October 2015 by GBA, the Pittsburgh 2030 District, and 10 other regional transportation stakeholders, asked respondents a series of questions related to zip code of residence, destination location, and mode(s) for making the commute to and from work or school. More than 20,000 responses were successfully completed and analyzed for measured performance against local modeled commuter patterns.
Organization: Allegheny County / City of Pittsburgh / Western PA Regional Data Center
Last updated: 2023-01-24T18:11:11.146048
Tags: alternative-transportation, bike, bus, commuters, commuting, downtown, oakland, parking, pittsburgh, sustainability, transportation, walking

Tables

Make My Trip Count Survey Response Data

@usgov.allegheny_county_city_of_pitts_make_my_trip_count_2015.make_my_trip_count_survey_response_data

251.01 KB
19918 rows
15 columns


CREATE TABLE make_my_trip_count_survey_response_data (
  "wprdc_id" BIGINT,
  "homezipcode" DOUBLE,
  "destination" VARCHAR,
  "other" VARCHAR,
  "milesoneway" DOUBLE,
  "commutedays" BIGINT,
  "primarymode" VARCHAR,
  "primarymodepercentcommute" BIGINT,
  "primarymodenumbertrips" DOUBLE,
  "secondarymode" VARCHAR,
  "secondarymodepercentcommute" DOUBLE,
  "secondarymodenumbertrips" DOUBLE,
  "tertiarymode" VARCHAR,
  "tertiarymodepercentcommute" BIGINT,
  "tertiarymodenumbertrips" DOUBLE
);

Data Dictionary

@usgov.allegheny_county_city_of_pitts_make_my_trip_count_2015.data_dictionary

4.3 KB
15 rows
3 columns


CREATE TABLE data_dictionary (
  "field_name" VARCHAR,
  "response_type" VARCHAR,
  "description" VARCHAR
);