bts-gov/county-transportation-profiles-qdmf-cxm3

  • counties
  • county

County Transportation Profiles

County Transportation Profiles

Profiles of transportation features of U.S. counties

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
Number of residentsnumber_of_residentsnumber_of_residentsNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
County FIPScounty_fipscounty_fipsTextFive-digit FIPS county code
Total Marinastotal_marinastotal_marinasNumberMaritime data is from the Master Docks file from the U.S. Army Corps of Engineers (USACE) and the U.S. Maritime Administration’s Waterborne Commerce Data 2009-2018 which includes docks that have been active since 2009. The number of Docks and Marina are separated out as Docks are for commercial use and Marina's for recreational use. Counts include Docks that fall in two or more counties, which account for 7% of the data.
Number of resident workers who work at homenumber_of_resident_workers_who_work_at_homenumber_of_resident_workers_who_work_at_homeNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
County Namecounty_namecounty_nameTextCounty Name
State FIPSstate_fipsstate_fipsNumberTwo-digit FIPS state code
State Namestate_namestate_nameTextState Name
Primary and Commercial Airportsprimary_and_commercial_airportsprimary_and_commercial_airportsNumberAirports data is compiled in the National Transportation Atlas Database (NTAD) using data from the Federal Aviation Administration and the T-100 Domestic Market & Segment (All Carriers) database. The National Plan of Integrated Airport Systems (NPIAS) report was used for the breakdown of airports into Primary and Commercial Airports, and Non-Commercial -Civil Public Use Airports and Seaplane base. Non-Commercial -Other Aerodromes represents remaining public and private facilities.
Non-Commercial -Civil Public Use Airports and Seaplane basenon_commercial_civil_public_use_airports_and_seaplane_basenon_commercial_civil_public_use_airports_and_seaplane_baseNumberAirports data is compiled in the National Transportation Atlas Database (NTAD) using data from the Federal Aviation Administration and the T-100 Domestic Market & Segment (All Carriers) database. The National Plan of Integrated Airport Systems (NPIAS) report was used for the breakdown of airports into Primary and Commercial Airports, and Non-Commercial -Civil Public Use Airports and Seaplane base. Non-Commercial -Other Aerodromes represents remaining public and private facilities.
Non-Commercial -Other Aerodromesnon_commercial_other_aerodromesnon_commercial_other_aerodromesNumberAirports data is compiled in the National Transportation Atlas Database (NTAD) using data from the Federal Aviation Administration and the T-100 Domestic Market & Segment (All Carriers) database. The National Plan of Integrated Airport Systems (NPIAS) report was used for the breakdown of airports into Primary and Commercial Airports, and Non-Commercial -Civil Public Use Airports and Seaplane base. Non-Commercial -Other Aerodromes represents remaining public and private facilities.
Number of Bridgesnumber_of_bridgesnumber_of_bridgesNumberBridges data is compiled in the National Transportation Atlas Database (NTAD) using data from the Federal Highway Administration National Bridge Inventory (NBI). The dataset includes bridges located on public roads as of December 31, 2018, including Interstate Highways, U.S. highways, State and county roads, as well as publicly-accessible bridges on Federal and Tribal lands.
% of Poor Condition Bridgesof_poor_condition_bridgesof_poor_condition_bridgesNumberBridges data is compiled in the National Transportation Atlas Database (NTAD) using data from the Federal Highway Administration National Bridge Inventory (NBI). The dataset includes bridges located on public roads as of December 31, 2018, including Interstate Highways, U.S. highways, State and county roads, as well as publicly-accessible bridges on Federal and Tribal lands.
Number of business establishmentsnumber_of_business_establishmentsnumber_of_business_establishmentsNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Percent of resident workers who commute by transitpercent_of_resident_workers_who_commute_by_transitpercent_of_resident_workers_who_commute_by_transitNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Number of workers from other counties who commute to work in the countynumber_of_workers_from_other_counties_who_commute_to_work_in_the_countynumber_of_workers_from_other_counties_who_commute_to_work_in_thNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Number of resident workers who commute to work in other countiesnumber_of_resident_workers_who_commute_to_work_in_other_countiesnumber_of_resident_workers_who_commute_to_work_in_other_countieNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Number of resident workers who commute within countynumber_of_resident_workers_who_commute_within_countynumber_of_resident_workers_who_commute_within_countyNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Number of resident workersnumber_of_resident_workersnumber_of_resident_workersNumberDemographic data are from the 2012-2016 Census Transportation Planning Products (CTPP), based on the 2012-2016 5-year American Community Survey. Business establishment data are from the U.S. Census Bureau’s County Business Patterns.
Route miles of passenger railroad and rail transitroute_miles_of_passenger_railroad_and_rail_transitroute_miles_of_passenger_railroad_and_rail_transitNumberRailroad is from the North American Rail Lines NTAD dataset, which is a comprehensive database of North America's railway system at 1: 24,000 to 1: 100,000 scale as of April 1, 2020. Route miles of freight railroad are filtered to include only 'NET' field, 1) "Main sub network", & 2) "Major Industrial Lead". Route miles of passenger railroad and rail transit are filtered to include only 'NET' field, 1)"Main sub network", 2) "Major Industrial Lead", & 3) Where 'PASSNGR' == A, B, C, D, R, or T (i.e. including US passenger railroad companies). It should be noted that Passenger Miles here mean passenger over passenger-owned, passenger over freight-owned, or passenger-exclusive.
% of Medium to Fair Condition Bridgesof_medium_to_fair_condition_bridgesof_medium_to_fair_condition_bridgesNumber
Route miles of freight railroadroute_miles_of_freight_railroadroute_miles_of_freight_railroadNumberRailroad is from the North American Rail Lines NTAD dataset, which is a comprehensive database of North America's railway system at 1: 24,000 to 1: 100,000 scale as of April 1, 2020. Route miles of freight railroad are filtered to include only 'NET' field, 1) "Main sub network", & 2) "Major Industrial Lead". Route miles of passenger railroad and rail transit are filtered to include only 'NET' field, 1)"Main sub network", 2) "Major Industrial Lead", & 3) Where 'PASSNGR' == A, B, C, D, R, or T (i.e. including US passenger railroad companies). It should be noted that Passenger Miles here mean passenger over passenger-owned, passenger over freight-owned, or passenger-exclusive.
Total Dockstotal_dockstotal_docksNumberMaritime data is from the Master Docks file from the U.S. Army Corps of Engineers (USACE) and the U.S. Maritime Administration’s Waterborne Commerce Data 2009-2018 which includes docks that have been active since 2009. The number of Docks and Marina are separated out as Docks are for commercial use and Marina's for recreational use. Counts include Docks that fall in two or more counties, which account for 7% of the data.

Upstream Metadata