Baselight

Ecosystem Restoration Program [ds209]

State of California

@usgov.ca_gov_ecosystem_restoration_program_ds209_3b730

Loading...
Loading...

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: 2024-03-30T02:46:14.201827
Tags: anadromous, authcdfw, biota, california-department-of-fish-and-wildlife, california-natural-resources-agency, caopendata, cdfw, ds020920100510wm, habitat, inlandwaters, restoration, river, salmonid

Tables

Table 1

@usgov.ca_gov_ecosystem_restoration_program_ds209_3b730.table_1
  • 153.36 KB
  • 1006 rows
  • 20 columns
Loading...

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
);

Share link

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