About this Dataset

Recreational Routes

Recreational Routes: A simplified line layer of California State Parks recreational routes, providing location, name, Park name and other attributes. Current as of October 2024.
Organization: State of California
Last updated: 2025-07-23T15:52:33.546441
Tags: activities, california-department-of-parks-and-recreation, california-natural-resources-agency, california-state-parks, caopendata, department-of-parks-and-recreation, nature, parks, recreationalroutes, roads, roadstrails, trails

Tables

Table 1

@usgov.ca_gov_recreational_routes_6d5a9.table_1

1.45 MB
20,698 rows
15 columns

CREATE TABLE table_1 (
  "fid" BIGINT,
  "routename" VARCHAR,
  "gisid" VARCHAR,
  "routeclass" VARCHAR,
  "unitnbr" BIGINT,
  "unitname" VARCHAR,
  "routecat" VARCHAR,
  "routetype" VARCHAR,
  "seglngth" BIGINT,
  "share" VARCHAR,
  "shape_leng" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length,
  "globalid" VARCHAR,
  "routedes" VARCHAR,
  "traildes" VARCHAR
);