About this Dataset

Ecosystem Restoration Program [ds209]

This layer contains the locations of ongoing and completed habitat restoration projects funded by the Ecosystem Restoration Program, and contained as a subset of the California Habitat Restoration Project Database (CHRPD). Project locations are georeferenced by heads-up digitizing in as much detail as possible based on maps submitted by grant recipients. A background layer of 1:24,000 DRG Quads was used to locate the projects precisely. WHAT EACH RECORD REPRESENTS: The records represent individual project sites of a completed or ongoing restoration project funded by the Ecosystem Restoration Program through 2008. Many of the projects have multiple sites. Each site is represented by a center point. A separate shapefile records the entire footprint of those sites in this shapefile that occur over a larger area, and is available on request.
Organization: State of California
Last updated: 2025-07-24T00:29:43.887894
Tags: anadromous, auth_cdfw, biota, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, ds0209_20100510_wm, habitat, inlandwaters, restoration, river, salmonid

Tables

Table 1

@usgov.ca_gov_ecosystem_restoration_program_ds209_04f58.table_1

157.04 kB
1,006 rows
20 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "projid" BIGINT,
  "erpnumber" VARCHAR,
  "siteid" BIGINT,
  "location" VARCHAR,
  "sitedesc" VARCHAR,
  "dfgid" VARCHAR,
  "title" VARCHAR,
  "begindate" TIMESTAMP,
  "enddate" TIMESTAMP,
  "status" VARCHAR,
  "amount" DOUBLE,
  "projdesc" VARCHAR,
  "recipient" VARCHAR,
  "topicarea" VARCHAR,
  "projtype" VARCHAR,
  "ecoelement" VARCHAR,
  "waterqual" VARCHAR
);