Local Area Transportation Characteristics By Household 2009 by US Government | Demographics and Population Studies

About this Dataset

Local Area Transportation Characteristics By Household 2009

Estimates of average weekday household person trips, vehicle trips, person miles traveled, and vehicle miles traveled (per day), for all Census tracts in the United States for 2009.

For latest data (2017), see https://data.bts.gov/Research-and-Statistics/Local-Area-Transportation-Characteristics-by-House/va72-z8hz

For methodology, see attachments
Organization: Department of Transportation
Last updated: 2024-08-09T04:32:29.599842
Tags: local, person-miles-traveled, person-trips, travel, vehicle-miles-traveled, vehicle-trips

Tables

Table 1

@usgov.dot_gov_local_area_transportation_characteristics_by_h_b5a5a7be.table_1

13.12 MB
73057 rows
116 columns


CREATE TABLE table_1 (
  "geoid" BIGINT,
  "cluster" DOUBLE,
  "pden_group_ua" DOUBLE,
  "est_pmiles2007_11" DOUBLE,
  "est_ptrp2007_11" DOUBLE,
  "est_vmiles2007_11" DOUBLE,
  "est_vtrp2007_11" DOUBLE,
  "median_hh_inc2007_11" DOUBLE,
  "mean_hh_veh2007_11" DOUBLE,
  "mean_hh_mem2007_11" DOUBLE,
  "pct_owner2007_11" DOUBLE,
  "mean_hh_worker2007_11" DOUBLE,
  "pct_lchd2007_11" DOUBLE,
  "pct_lhd12007_11" DOUBLE,
  "pct_lhd22007_11" DOUBLE,
  "pct_lhd42007_11" DOUBLE,
  "ptrp_1mem_0veh" DOUBLE,
  "ptrp_1mem_1veh" DOUBLE,
  "ptrp_1mem_2veh" DOUBLE,
  "ptrp_1mem_3veh" DOUBLE,
  "ptrp_1mem_4veh" DOUBLE,
  "ptrp_2mem_0veh" DOUBLE,
  "ptrp_2mem_1veh" DOUBLE,
  "ptrp_2mem_2veh" DOUBLE,
  "ptrp_2mem_3veh" DOUBLE,
  "ptrp_2mem_4veh" DOUBLE,
  "ptrp_3mem_0veh" DOUBLE,
  "ptrp_3mem_1veh" DOUBLE,
  "ptrp_3mem_2veh" DOUBLE,
  "ptrp_3mem_3veh" DOUBLE,
  "ptrp_3mem_4veh" DOUBLE,
  "ptrp_4mem_0veh" DOUBLE,
  "ptrp_4mem_1veh" DOUBLE,
  "ptrp_4mem_2veh" DOUBLE,
  "ptrp_4mem_3veh" DOUBLE,
  "ptrp_4mem_4veh" DOUBLE,
  "ptrp_5mem_0veh" DOUBLE,
  "ptrp_5mem_1veh" DOUBLE,
  "ptrp_5mem_2veh" DOUBLE,
  "ptrp_5mem_3veh" DOUBLE,
  "ptrp_5mem_4veh" DOUBLE,
  "pmiles_1mem_0veh" DOUBLE,
  "pmiles_1mem_1veh" DOUBLE,
  "pmiles_1mem_2veh" DOUBLE,
  "pmiles_1mem_3veh" DOUBLE,
  "pmiles_1mem_4veh" DOUBLE,
  "pmiles_2mem_0veh" DOUBLE,
  "pmiles_2mem_1veh" DOUBLE,
  "pmiles_2mem_2veh" DOUBLE,
  "pmiles_2mem_3veh" DOUBLE,
  "pmiles_2mem_4veh" DOUBLE,
  "pmiles_3mem_0veh" DOUBLE,
  "pmiles_3mem_1veh" DOUBLE,
  "pmiles_3mem_2veh" DOUBLE,
  "pmiles_3mem_3veh" DOUBLE,
  "pmiles_3mem_4veh" DOUBLE,
  "pmiles_4mem_0veh" DOUBLE,
  "pmiles_4mem_1veh" DOUBLE,
  "pmiles_4mem_2veh" DOUBLE,
  "pmiles_4mem_3veh" DOUBLE,
  "pmiles_4mem_4veh" DOUBLE,
  "pmiles_5mem_0veh" DOUBLE,
  "pmiles_5mem_1veh" DOUBLE,
  "pmiles_5mem_2veh" DOUBLE,
  "pmiles_5mem_3veh" DOUBLE,
  "pmiles_5mem_4veh" DOUBLE,
  "vtrp_1mem_0veh" DOUBLE,
  "vtrp_1mem_1veh" DOUBLE,
  "vtrp_1mem_2veh" DOUBLE,
  "vtrp_1mem_3veh" DOUBLE,
  "vtrp_1mem_4veh" DOUBLE,
  "vtrp_2mem_0veh" DOUBLE,
  "vtrp_2mem_1veh" DOUBLE,
  "vtrp_2mem_2veh" DOUBLE,
  "vtrp_2mem_3veh" DOUBLE,
  "vtrp_2mem_4veh" DOUBLE,
  "vtrp_3mem_0veh" DOUBLE,
  "vtrp_3mem_1veh" DOUBLE,
  "vtrp_3mem_2veh" DOUBLE,
  "vtrp_3mem_3veh" DOUBLE,
  "vtrp_3mem_4veh" DOUBLE,
  "vtrp_4mem_0veh" DOUBLE,
  "vtrp_4mem_1veh" DOUBLE,
  "vtrp_4mem_2veh" DOUBLE,
  "vtrp_4mem_3veh" DOUBLE,
  "vtrp_4mem_4veh" DOUBLE,
  "vtrp_5mem_0veh" DOUBLE,
  "vtrp_5mem_1veh" DOUBLE,
  "vtrp_5mem_2veh" DOUBLE,
  "vtrp_5mem_3veh" DOUBLE,
  "vtrp_5mem_4veh" DOUBLE,
  "vmiles_1mem_0veh" DOUBLE,
  "vmiles_1mem_1veh" DOUBLE,
  "vmiles_1mem_2veh" DOUBLE,
  "vmiles_1mem_3veh" DOUBLE,
  "vmiles_1mem_4veh" DOUBLE,
  "vmiles_2mem_0veh" DOUBLE,
  "vmiles_2mem_1veh" DOUBLE,
  "vmiles_2mem_2veh" DOUBLE,
  "vmiles_2mem_3veh" DOUBLE
);