Baselight

Traffic Volumes AADT

State of California

@usgov.ca_gov_traffic_volumes_aadt_ee8d6

Table 1
@usgov.ca_gov_traffic_volumes_aadt_ee8d6.table_1

  • 584.33 KB
  • 13874 rows
  • 17 columns
x

X

y

Y

objectid

OBJECTID

district

DISTRICT

route

ROUTE

route_sfx

ROUTE SFX

county

COUNTY

pm_pfx

PM PFX

pm

PM

pm_sfx

PM SFX

location_description

LOCATION DESCRIPTION

back_peak_hour

BACK PEAK HOUR

back_peak_madt

BACK PEAK MADT

back_aadt

BACK AADT

ahead_peak_hour

AHEAD PEAK HOUR

ahead_peak_madt

AHEAD PEAK MADT

ahead_aadt

AHEAD AADT

-117.22499833832.89966008400011115SDR30.345LBEG INDEP ALIGN LT LNS8600940008000038505100046000
-117.22466914232.90081389000012115SDR30.426LSAN DIEGO, SORRENTO VALLEY ROAD4200550005000038004650040000
-117.22482071532.9044991683115SDR30.682LSAN DIEGO, NORTH JCT RTE 8056500820007000047006300060000
-117.22822430532.91064942700014115SDR31.155LR31.155 EQUATES R31.188, END INDEP ALIGN840010400081000
-117.97514716333.8539935615125ORA41.84LBEG INDEP ALIGN LT LNS1920024300022300011600147000133900
-117.97891751233.85611367600016125ORA42.1LFULLERTON, JCT. RTE. 911160014700013390011600147000133900
-117.98564614333.859034697125ORA42.515LEND LEFT ALIGN1700023200021020018800232000210200
-118.49001032234.315155272875SLAC43.899LLOS ANGELES, BEGIN TRUCK FREEWAY11501820017400
-118.50220786234.325645449975SLAC44.924LLOS ANGELES, END INDEPENDENT ALIGNMENT11501820017400
-118.89661642734.8780482621065KER5.152LBEGIN INDEP ALIGN LT LANES85001050008300046005000043000

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "district" BIGINT,
  "route" BIGINT,
  "route_sfx" VARCHAR,
  "county" VARCHAR,
  "pm_pfx" VARCHAR,
  "pm" DOUBLE,
  "pm_sfx" VARCHAR,
  "location_description" VARCHAR,
  "back_peak_hour" DOUBLE,
  "back_peak_madt" DOUBLE,
  "back_aadt" DOUBLE,
  "ahead_peak_hour" DOUBLE,
  "ahead_peak_madt" DOUBLE,
  "ahead_aadt" DOUBLE
);

Share link

Anyone who has the link will be able to view this.