Skip to content

Instantly share code, notes, and snippets.

@tbuckl
Created September 6, 2017 17:51
Show Gist options
  • Select an option

  • Save tbuckl/bde85668377fad0cb63292469d6b99a0 to your computer and use it in GitHub Desktop.

Select an option

Save tbuckl/bde85668377fad0cb63292469d6b99a0 to your computer and use it in GitHub Desktop.
Bay Area Greenprint Data Dictionary
Glossary Reference Definition Field name Unit Math to be performed Theme
Additional water (mm) for irrigation - hotter and drier Additional acre-feet per year needed for agriculture in a hotter and drier climate change scenario MIROC Acre-feet per year Sum Agriculture
Additional water (mm) for irrigation - warmer and wetter Additional acre-feet per year needed for agriculture in a warmer and wetter climate change scenario CRNM Acre-feet per year Sum Agriculture
Crop production Dollar value of crop production, according to Ag Commissioner's data cropval Dollar value Sum Agriculture
Fallow cropland Percent of farmland (crops) in your area of interest not fallowed in recent years idle0_ac Acres Sum (idle0_ac), divide by Sum (idle01_ac) Agriculture
Fallow cropland Total acres of farmland for which fallowing was tracked (metric denominator) idle01_ac Acres Sum Agriculture
Suitable Grazing land Acres of grazing land, per FMMP graz_ac Acres Sum Agriculture
Farmland of Local Importance Acres of farmland of local importance, per FMMP local_ac Acres Sum Agriculture
Prime farmland Acres of prime farmland, per FMMP prime_ac Acres Sum Agriculture
Farmland of Statewide Importance Acres of farmland of state importance, per FMMP state_ac Acres Sum Agriculture
Unique farmland Acres of unique farmland, per FMMP unique_ac Acres Sum Agriculture
Agricultural lands Acres of grazing and all categories of farmland, per FMMP (for use as metric denominator) allfarm_ac Acres Sum Agriculture
Fish passage priority and total barriers (combined) Count of fish barriers (priority and total, combined) FPB_ct Count Sum Biodiversity & Habitat
Key Riparian Corridor Miles of key riparian corridor KRC_mi Miles Sum Biodiversity & Habitat
Bay Area Critical Linkages - Large landscape Blocks Acres of large landscape blocks block_ac Acres Sum Biodiversity & Habitat
Bay Area Critical Linkages - Linkage Acres of critical linkages link_ac Acres Sum Biodiversity & Habitat
Baylands Acres of baylands bayland_ac Acres Sum Biodiversity & Habitat
Linkage highway barrier Yes/No within a half-mile of linkage with pinch points (1 = yes) pinch Yes/No > 0 = "Yes" Biodiversity & Habitat
Vernal pools Acres of vernal pools vernal_ac Acres Sum Biodiversity & Habitat
Wetlands Acres of wetlands wetl_ac Acres Sum Biodiversity & Habitat
Landscape Resilience - resilient areas Mean value of resilience measure (to compare with 0.50497, total Bay Area mean). NOTE: null values were replaced with -999, you must filter those out before calculating an average value. resi_val Mean Mean Biodiversity & Habitat
Important habitat for T&E Vertebrates Average value of important habitat for threatened and endangered (breaks provided). NOTE: null values were replaced with -999, you must filter those out before calculating an average value. TE_val Mean Mean Biodiversity & Habitat
Landscape refugia Percent of prioritized natural habitats in your area of interest that will remain in suitable climates ref1_ac Acres Sum (ref1_ac), divide by Sum (exp_t_ac) Biodiversity & Habitat
Prioritized natural habitats (Landscape refugia; Exposure) Acres of prioritized natural habitats (denominator for ref1_ac, exp1_ac) exp_t_ac Acres Sum Biodiversity & Habitat
Exposure Percent of prioritized natural habitats in your area of inerest that will be in marginal climates exp1_ac Acres Sum (exp1_ac), divide by Sum (exp_t_ac) Biodiversity & Habitat
CNDDB Rare and Protected Species Yes/No presence of CNDDB listed species (1 = yes) cnddb Yes/No > 0 = "Yes" Biodiversity & Habitat
Hotspots of species requiring compensatory mitigation Average value of habitat mitigation measure (breaks provided). NOTE: null values were replaced with -999, you must filter those out before calculating an average value. ramp Mean Mean Biodiversity & Habitat
Regional Connectivity - Diffuse Acres of regional connectivity - Diffuse RC_d Acres Sum * 0.222395 Biodiversity & Habitat
Glossary Reference Definition Field name Unit Math to be performed Theme
Regional Connectivity - Intensified Acres of regional connectivity - Intensified RC_i Acres Sum * 0.222395 Biodiversity & Habitat
Conservation Lands Network Acres of important/essential/fragme nted lands CLNefi_ac Acres Sum Biodiversity & Habitat
Aboveground live carbon storage Metric tons of carbon stock above ground BA_AGC Metric tons Sum Carbon
Soil Carbon Storage Metric tons of carbon stock in soil soc0_30 Metric tons Sum Carbon
Protected lands by fee Acres of fee lands, CPAD 2016b CPAD_ac Acres Sum Overview
Conservation easement Acres of easement lands, CCED 2016 CCED_ac Acres Sum Overview
Publicly accessible recreational lands Acres of publicly-accessible fee lands (from BPAD flat file, filtered to lands with Open or Restricted Access) cpad_or_ac Acres Sum Recreation
Regional Trails - existing Miles of existing regional trails trl_e_mi Miles Sum Recreation
Regional Trails - proposed Miles of proposed regional trails trl_p_mi Miles Sum Recreation
Areas with high recharge potential Acres of areas with high permeability, therefore high recharge potential. Same as hydrologically vulnerable areas. vuln_ac Acres Sum Water
Hydrogeologically Vulnerable areas Acres of areas with high permeability, therefore high vulnerability to pollution. Same as areas with high recharge potential vuln_ac Acres Sum Water
Impaired waterbodies Yes/No presence of 303d listed waterbody (1 = yes) wb303d Yes/No > 0 = "Yes" Water
Impaired waterways - 303d listed streams Yes/No presence of 303d listed stream (1 = yes) ln303d Yes/No > 0 = "Yes" Water
Priority groundwater basins Yes/No area of interest overlaps with a priority groundwater basin. (1 = yes) PGB Yes/No > 0 = "Yes" Water
Reservoir catchment areas Yes/No are of interest overlaps with a reservoir catchment area (1 = yes) RCA Yes/No > 0 = "Yes" Water
100 year Floodplain Acres within a 100 year flood area fl100_ac Acres Sum Water
500-year Floodplain Acres within a 500 year flood area fl500_ac Acres Sum Water
Naturalness of Active River Area Acres of natural river area natri_ac Acres Sum Water
Municipal drinking water supply watersheds Acres of drinking water watershed drink_ac Acres Sum Water
Water quality index Average value of water quality index. NOTE: null values were replaced with -999, you must filter those out before calculating an average value. WQ_val Mean Mean (compare to Bay Area-wide mean of 0.49033) Water
Runoff Acre-feet per year of water runoff Acre-feet per year Sum Water
Groundwater recharge Acre-feet per year of water recharge Acre-feet per year Sum Water
Natural Baylands Acres of natural baylands natbay_ac Acres Sum Water
Coastal Resilience Acres of coastal resilient areas natbay_ac Acres Sum Water
Sea level rise Acres within 2050 inundation zone slr2050_ac Acres Sum Water
Sea level rise -- 5' inundation area Acres within 2100 inundation zone slr2100_ac Acres Sum Water
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment