About this Dataset

2022 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: 2025-07-23T21:23:45.095410
Tags: california-department-of-transportation, california-state-transportation-agency, calsta, caltrans, caopendata, named-appurtenances, named-freeways, named-highways, named-structures, transportation

Tables

BLUE STAR MEMORIAL HIGHWAYS

@usgov.ca_gov_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.blue_star_memorial_highways

6.39 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_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.historical_usage_names

7.76 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_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.listing_by_route_number

95.66 kB
1,120 rows
8 columns

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

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

@usgov.ca_gov_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.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_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.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
);

Metadata Named Freeways, Highways, Structures And Other Appurtenances In California Publication

@usgov.ca_gov_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.metadata_named_freeways_highways_structures_and_other__0c091b02

54.93 kB
7 rows
33 columns

CREATE TABLE metadata_named_freeways_highways_structures_and_other__0c091b02 (
  "dataset_name" VARCHAR,
  "tags" VARCHAR,
  "summary" VARCHAR,
  "description" VARCHAR,
  "public_access_level" VARCHAR,
  "access_constraints" VARCHAR,
  "topic" VARCHAR,
  "gis_theme" VARCHAR,
  "created_date" TIMESTAMP,
  "revised_date" TIMESTAMP,
  "publisher_organization" VARCHAR,
  "contact_name" VARCHAR,
  "contact_organization" VARCHAR,
  "contact_position" VARCHAR,
  "contact_email" VARCHAR,
  "status" VARCHAR,
  "frequency" VARCHAR,
  "data_life_span" VARCHAR,
  "use_constraints" VARCHAR,
  "methodology" VARCHAR,
  "data_dictionary" VARCHAR,
  "place" VARCHAR,
  "temporal_coverage_begin" VARCHAR,
  "temporal_coverage_end" TIMESTAMP,
  "next_update" VARCHAR,
  "source_link" VARCHAR,
  "data_dictionary_type" VARCHAR,
  "coordinate_system_epsg" VARCHAR,
  "vert_datum_epsg" VARCHAR,
  "horiz_accuracy" VARCHAR,
  "vert_accuracy" VARCHAR,
  "data_standard" VARCHAR,
  "notes" VARCHAR
);

NAMED BRIDGES TUNNELS AND OTHER STRUCTURES

@usgov.ca_gov_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.named_bridges_tunnels_and_other_structures

29.98 kB
331 rows
7 columns

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

NAMED FREEWAYS AND HIGHWAYS

@usgov.ca_gov_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.named_freeways_and_highways

50.71 kB
616 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_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.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_2022_named_freeways_highways_structures_and_oth_c3d0e8bd.safety_roadside_rest_areas_and_scenic_overlooks

8.97 kB
75 rows
5 columns

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