About this Dataset

Fisheries Restoration Grant Program (FRGP) Projects [ds168]

The Fisheries Restoration Grant Program (FRGP) was established in 1981 in response to rapidly declining populations of wild salmon and steelhead trout and deteriorating fish habitat in California. This competitive grant program has invested millions of dollars to support projects from sediment reduction to watershed education throughout coastal California. Contributing partners include federal and local governments, tribes, water districts, fisheries organizations, watershed restoration groups, the California Conservation Corps, AmeriCorps, and private landowners. The FRGP Database began in 1999 to capture and maintain data about habitat restoration projects in California benefiting anadromous fish. The database is managed California Department of Fish and Wildlife (CDFW) and funded by NOAA Fisheries and CDFW. Project locations are based on the grantees maps. For more information about FRGP grants, see https://wildlife.ca.gov/Grants/FRGP/Grant-Process.
Organization: State of California
Last updated: 2025-07-23T21:18:09.296709
Tags: california-department-of-fish-and-wildlife, cdfw, census, distribution, ds0168_20250114_wm, fish, habitat-attributes, management, monitoring, planning

Tables

Table 1

@usgov.ca_gov_fisheries_restoration_grant_program_frgp_projec_605d0e7e.table_1

1.21 MB
4,335 rows
23 columns

CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "award_year" BIGINT,
  "objectid" BIGINT,
  "frgp_grant_number" VARCHAR,
  "project_name" VARCHAR,
  "wg_grant_status" VARCHAR,
  "project_type_code" VARCHAR,
  "project_type" VARCHAR,
  "proposed_description" VARCHAR,
  "final_description" VARCHAR,
  "agency" VARCHAR,
  "counties" VARCHAR,
  "center_latitude" DOUBLE,
  "center_longitude" DOUBLE,
  "awardedamount" DOUBLE,
  "projecttypegeneral" VARCHAR,
  "agencylegacy" VARCHAR,
  "region" BIGINT,
  "name" VARCHAR,
  "huc_8" BIGINT,
  "hu_8_name" VARCHAR,
  "county_name" VARCHAR
);