About this Dataset

Geospatial Transportation Typology

This dataset includes the inputs and results for developing a transportation geo-typology that categorizes every location in the United States in terms of their main drivers of transportation demand and supply. It provides the raw inputs to the census tract level microtypes and county or CBSA level geotypes as well as the final typology labels at both the tract (microtype) and county/CBSA (geotype) levels. Inputs include information on the street network, economic characteristics, topography, commute patterns, and land use. The methodology is published in "Popovich, N., Spurlock, C. A., Needell, Z., Jin, L., Wenzel, T., Sheppard, C., & Asudegi, M. (2021). A methodology to develop a geospatial transportation typology. Journal of transport geography, 93, 103061".
Organization: Department of Transportation
Last updated: 2022-08-14T01:15:54.936128
Tags: analysis, commute-patterns, geo-economic, geo-typology, geotype, land-use, microtype, street-network, transportation

Tables

Table 1

@usgov.dot_gov_geo_spatial_transportation_typology.table_1

16.2 MB
73,056 rows
44 columns

CREATE TABLE table_1 (
  "geoid" BIGINT,
  "fips_state" BIGINT,
  "fips_county" BIGINT,
  "st_code" VARCHAR,
  "ctyname" VARCHAR,
  "spatial_id" BIGINT,
  "microtypeid" VARCHAR,
  "microtype" BIGINT,
  "geotype" VARCHAR,
  "broadband" DOUBLE,
  "pollutant_count" DOUBLE,
  "pct_ag_land" DOUBLE,
  "pct_water" DOUBLE,
  "dev_intensity" DOUBLE,
  "circuity_avg" DOUBLE,
  "dead_end_proportion" DOUBLE,
  "intersection_density_km" DOUBLE,
  "self_loop_proportion" DOUBLE,
  "street_density_km" DOUBLE,
  "street_length_avg" DOUBLE,
  "pct_jobs_manuf" DOUBLE,
  "pct_jobs_mining" DOUBLE,
  "avg_iri" DOUBLE,
  "pct_controlf" DOUBLE,
  "pct_controlp" DOUBLE,
  "pct_aadt_combi" DOUBLE,
  "aadt_combi_per_lm" DOUBLE,
  "lane_miles_sqkm" DOUBLE,
  "pop_density" DOUBLE,
  "job_density" DOUBLE,
  "road_grade" DOUBLE,
  "lanemeters_per_capita" DOUBLE,
  "jobs_housing_bal" DOUBLE,
  "pct_hiway" DOUBLE,
  "pct_local_roads" DOUBLE,
  "pct_mid_roads" DOUBLE,
  "pct_trips_bin1" DOUBLE,
  "pct_trips_bin2" DOUBLE,
  "pct_trips_bin3" DOUBLE,
  "pct_trips_bin4" DOUBLE,
  "sink_mag" DOUBLE,
  "emp_centers" BIGINT,
  "hhi_normalized" DOUBLE,
  "pct_microtype_1" DOUBLE
);