About this Dataset

2021 Named Freeways, Highways, Structures And Other Appurtenances In California

Named Freeways, Highways, Structures and Other Appurtenances in California Publication
Named Freeways, Highways, Structures and Other Appurtenances in California are shown in the Name Freeway Publication as a reference to the many named facilities that are part of the California State Highway System. This publication provides information on officially named freeways; highways; structures such as bridges, tunnels, and interchanges; Blue Star Memorial Highways; Safety Roadside Rest Areas; and memorial plaques.
Organization: State of California
Last updated: 2023-08-12T10:14:18.145613
Tags: california-department-of-transportation, california-state-transportation-agency, named-appurtenances, named-freeways, named-highways, named-structures, open-data, transportation

Tables

BLUE STAR MEMORIAL HIGHWAYS

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.blue_star_memorial_highways

6.38 kB
19 rows
6 columns

CREATE TABLE blue_star_memorial_highways (
  "name" VARCHAR,
  "route_no" VARCHAR,
  "district" VARCHAR,
  "how_named" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR
);

HISTORICAL USAGE NAMES

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.historical_usage_names

7.74 kB
54 rows
6 columns

CREATE TABLE historical_usage_names (
  "name" VARCHAR,
  "route_no" VARCHAR,
  "district" VARCHAR,
  "how_named" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR
);

LISTING BY ROUTE NUMBER

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.listing_by_route_number

91.98 kB
1,086 rows
8 columns

CREATE TABLE listing_by_route_number (
  "section" VARCHAR,
  "name" VARCHAR,
  "route_no" VARCHAR,
  "district" VARCHAR,
  "location" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR,
  "how_named" VARCHAR
);

List Of Values Named Freeways, Highways, Structures And Other Appurtenances In California Publication

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.list_of_values_named_freeways_highways_structures_and__cb07c34b

6.75 kB
21 rows
6 columns

CREATE TABLE list_of_values_named_freeways_highways_structures_and__cb07c34b (
  "system" VARCHAR,
  "data_table" VARCHAR,
  "data_element" VARCHAR,
  "code" VARCHAR,
  "meaning" VARCHAR,
  "list_of_values_source" VARCHAR
);

MEMORIAL PLAQUES AND OTHER MARKERS

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.memorial_plaques_and_other_markers

6.92 kB
25 rows
5 columns

CREATE TABLE memorial_plaques_and_other_markers (
  "name" VARCHAR,
  "route_no" VARCHAR,
  "district" BIGINT,
  "location" VARCHAR,
  "how_named" VARCHAR
);

NAMED BRIDGES TUNNELS AND OTHER STRUCTURES

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.named_bridges_tunnels_and_other_structures

29.54 kB
324 rows
7 columns

CREATE TABLE named_bridges_tunnels_and_other_structures (
  "name" VARCHAR,
  "route_no" VARCHAR,
  "bridge_number" VARCHAR,
  "year_built" VARCHAR,
  "district" VARCHAR,
  "location" VARCHAR,
  "how_named" VARCHAR
);

NAMED FREEWAYS AND HIGHWAYS

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.named_freeways_and_highways

48.37 kB
590 rows
6 columns

CREATE TABLE named_freeways_and_highways (
  "name" VARCHAR,
  "route_no" VARCHAR,
  "district" VARCHAR,
  "how_named" VARCHAR,
  "from" VARCHAR,
  "to" VARCHAR
);

Data Dictionary Named Freeways, Highways, Structures And Other Appurtenances In California Publication

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.n__dictionary_named_freeways_highways_structures_and_o_0afc5c64

14.52 kB
43 rows
18 columns

CREATE TABLE n__dictionary_named_freeways_highways_structures_and_o_0afc5c64 (
  "table_name" VARCHAR,
  "field_name" VARCHAR,
  "field_alias" VARCHAR,
  "field_description" VARCHAR,
  "field_type" VARCHAR,
  "field_length" BIGINT,
  "domain_type" VARCHAR,
  "confidential" VARCHAR,
  "sensitive" VARCHAR,
  "pii" VARCHAR,
  "pci" VARCHAR,
  "system_name" VARCHAR,
  "field_description_authority" VARCHAR,
  "field_precision" VARCHAR,
  "units" VARCHAR,
  "allowable_min_value" VARCHAR,
  "allowable_max_value" VARCHAR,
  "usage_notes" VARCHAR
);

SAFETY ROADSIDE REST AREAS AND SCENIC OVERLOOKS

@usgov.ca_gov_2021_named_freeways_highways_structures_and_oth_f591fac5.safety_roadside_rest_areas_and_scenic_overlooks

8.93 kB
74 rows
5 columns

CREATE TABLE safety_roadside_rest_areas_and_scenic_overlooks (
  "name" VARCHAR,
  "route_no" BIGINT,
  "district" BIGINT,
  "location" VARCHAR,
  "how_named" VARCHAR
);