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.75 MB
73,057 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
);