About this Dataset

Sustainable Agricultural Land Conservation Program Awards (SALC)

The Sustainable Agricultural Lands Conservation (SALC) program is a component of the Strategic Growth Council’s Affordable Housing and Sustainability Program (AHSC). The program supports the protection and management of California's agricultural lands through planning and permanent protection of farm and ranch lands via agricultural easements. SALC will prevent increases in GHG emissions by limiting opportunities for expansive, vehicle dependent forms of development in favor of more focused, compact, and transit oriented development within discrete growth boundaries. In future years, SALC is proposed to support farm-scale conservation management practices that further promote reductions in GHG emissions and increases in soil carbon sequestration.
Organization: State of California
Last updated: 2021-09-08T16:15:36.321323
Tags: agriculture, cdfa, conservation, doc, farmland, resources, salc, sgc

Tables

Sustainable Agricultural Land Conservation Program (SALC) Data Dictionary

@usgov.ca_gov_sustainable_agricultural_land_conservation_prog_297481b6.sustainable_agricultural_land_conservation_program_sal_ba37ace5

4.99 KB
16 rows
4 columns


CREATE TABLE sustainable_agricultural_land_conservation_program_sal_ba37ace5 (
  "field_title" VARCHAR,
  "field_name" VARCHAR,
  "data_type" VARCHAR,
  "description" VARCHAR
);

Sustainable Agricultural Land Conservation (SALC) Program Awards

@usgov.ca_gov_sustainable_agricultural_land_conservation_prog_297481b6.sustainable_agricultural_land_conservation_salc_program_awards

20.74 KB
11 rows
18 columns


CREATE TABLE sustainable_agricultural_land_conservation_salc_program_awards (
  "project_id_number" VARCHAR,
  "project_name" VARCHAR,
  "project_type" VARCHAR,
  "project_description" VARCHAR,
  "address" VARCHAR,
  "census_tract" VARCHAR,
  "total_project_cost" VARCHAR,
  "fy_funding_project" VARCHAR,
  "total_ggrf_funding" VARCHAR,
  "project_start_date" TIMESTAMP,
  "project_completion_date" TIMESTAMP,
  "estimated_total_project_ghg_reductions_in_metric_tons" DOUBLE,
  "vmt_reductions" DOUBLE,
  "agricultural_land_acres_preserved" DOUBLE,
  "describe_other_project_benefits_or_results" VARCHAR,
  "does_the_project_benefit_disadvantaged_communities" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);