About this Dataset

Truck And Bus Through Route

For the purposes of the map, a Truck is defined as a vehicle with a gross vehicle weight rating greater than 26,000 pounds with a carrying capacity of more than 1 and ¼ ton. For the purposes of the map, a Bus is defined as a vehicle with a carrying capacity of greater than 15 passengers. This does not include WMATA or Circulator buses. A through route, or primary route, signifies a roadway that may be used by trucks and buses that have neither an origin or destination within the city or on the route. A non-through route (all other roadways not highlighted in blue), signifies a roadway that that may be used by trucks or buses only for the purpose of making a delivery or pickup of passengers or freight. Trucks and buses should only use a non-through route at the beginning or end of a trip, when traveling between their origin/destination and a through route.
Organization: District of Columbia
Last updated: 2024-04-30T19:12:50.834205
Tags: bus, dc, ddot, district-of-columbia, roadway, transportation, truck, washington-dc

Tables

Table 1

@usgov.district_of_columbia_truck_and_bus_through_route.table_1

139.8 kB
2,046 rows
16 columns

CREATE TABLE table_1 (
  "name" VARCHAR,
  "routeid" VARCHAR,
  "frommeasure" DOUBLE,
  "tomeasure" DOUBLE,
  "fromdate" TIMESTAMP,
  "todate" VARCHAR,
  "eventid" VARCHAR,
  "locerror" VARCHAR,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "se_anno_cad_data" VARCHAR,
  "objectid" BIGINT,
  "shape" VARCHAR,
  "shapelen" BIGINT
);