Annual Average Daily Traffic - MDOT SHA Statewide AADT Lines
State of Maryland
@usgov.state_of_maryland_annual_average_daily_traffic_mdot_sh_e4bd90fc
State of Maryland
@usgov.state_of_maryland_annual_average_daily_traffic_mdot_sh_e4bd90fc
CREATE TABLE table_1 (
"the_geom" VARCHAR,
"gis_object_id" BIGINT,
"location_id" VARCHAR,
"county_code" BIGINT,
"county_name" VARCHAR,
"municipal_code" BIGINT,
"municipality_name" VARCHAR,
"road_name" VARCHAR,
"route_prefix" VARCHAR,
"route_number" BIGINT,
"route_suffix" VARCHAR,
"milepoint" DOUBLE,
"begin_section" DOUBLE,
"end_section" DOUBLE,
"station_description" VARCHAR,
"road_section" VARCHAR,
"rural_urban" VARCHAR,
"functional_class_code" BIGINT,
"functional_class" VARCHAR,
"route_id_legacy" VARCHAR,
"route_id_new" VARCHAR,
"mainline_code" BIGINT,
"peak_hour_direction" VARCHAR,
"number_of_lanes" BIGINT,
"counted_factored" VARCHAR,
"stmp_sequence" BIGINT,
"k_factor" DOUBLE,
"d_factor" DOUBLE,
"north_east_split" DOUBLE,
"south_west_split" DOUBLE,
"average_vehicle_miles_traveled" DOUBLE,
"link_to_count_details" VARCHAR,
"aadt_2010" DOUBLE,
"aadt_2011" DOUBLE,
"aadt_2012" DOUBLE,
"aadt_2013" DOUBLE,
"aadt_2014" DOUBLE,
"aadt_2015" DOUBLE,
"aadt_2016" DOUBLE,
"aadt_2017" DOUBLE,
"aadt_2018" DOUBLE,
"aadt_current" BIGINT,
"aawdt_2010" DOUBLE,
"aawdt_2011" DOUBLE,
"aawdt_2012" DOUBLE,
"aawdt_2013" DOUBLE,
"aawdt_2014" DOUBLE,
"aawdt_2015" DOUBLE,
"aawdt_2016" DOUBLE,
"aawdt_2017" DOUBLE,
"aawdt_2018" DOUBLE,
"aawdt_current" BIGINT,
"aadt_motorcycle" DOUBLE,
"aadt_car" DOUBLE,
"aadt_light_truck" DOUBLE,
"aadt_bus" DOUBLE,
"aadt_single_unit_truck" DOUBLE,
"aadt_combination_unit_truck" DOUBLE,
"location_error" VARCHAR,
"gis_shape_length" DOUBLE,
"aadt_truck" DOUBLE,
"aadt_single_unit_truck_utilization_truck" DOUBLE,
"aadt_combination_unit_truck_utilization_truck" DOUBLE,
"aadt_motorcycle_utilization" DOUBLE,
"aadt_car_utilization" DOUBLE,
"aadt_light_truck_utilization" DOUBLE,
"aadt_bus_utilization" DOUBLE,
"aadt_single_unit_truck_utilization" DOUBLE,
"aadt_combination_unit_truck_utilization" DOUBLE,
"aadt_truck_utilization" DOUBLE,
"number_of_lanes_text" BIGINT,
"k_factor_text" VARCHAR,
"d_factor_text" VARCHAR,
"north_east_split_text" VARCHAR,
"south_west_split_text" VARCHAR,
"aadt_2010_text" VARCHAR,
"aadt_2011_text" VARCHAR,
"aadt_2012_text" VARCHAR,
"aadt_2013_text" VARCHAR,
"aadt_2014_text" VARCHAR,
"aadt_2015_text" VARCHAR,
"aadt_2016_text" VARCHAR,
"aadt_2017_text" VARCHAR,
"aadt_2018_text" VARCHAR,
"aadt_current_text" BIGINT,
"aawdt_2010_text" VARCHAR,
"aawdt_2011_text" VARCHAR,
"aawdt_2012_text" VARCHAR,
"aawdt_2013_text" VARCHAR,
"aawdt_2014_text" VARCHAR,
"aawdt_2015_text" VARCHAR,
"aawdt_2016_text" VARCHAR,
"aawdt_2017_text" VARCHAR,
"aawdt_2018_text" VARCHAR,
"aawdt_current_text" BIGINT,
"aadt_motorcycle_text" VARCHAR,
"aadt_car_text" VARCHAR,
"aadt_bus_text" VARCHAR,
"aadt_light_truck_text" VARCHAR,
"aadt_single_unit_truck_text" VARCHAR
);
Anyone who has the link will be able to view this.