Vital Signs: Bay Restoration - Bay Area

VITAL SIGNS INDICATOR

Bay Restoration (EN10)

FULL MEASURE NAME

Change in San Francisco Bay surface area

LAST UPDATED

April 2017

DESCRIPTION

Bay restoration refers to the acreage of San Francisco Bay. This measure reflects either the Bay’s expansion from restoration projects (such as wetland restorations) or contraction from projects that fill the Bay to create new land for development. This measure is a key indicator of Bay conservation efforts, as well as nearby development activities. The dataset includes acreage of Bay restoration or fill on a regional level.

DATA SOURCE

San Francisco Bay Conservation and Development Commission: Annual Report

2001-2015

http://www.bcdc.ca.gov/cm/2015/2014Annual-Report.pdf

http://www.bcdc.ca.gov/reports/2015AnnualRpt.pdf

CONTACT INFORMATION

vitalsigns.info@mtc.ca.gov

METHODOLOGY NOTES (across all datasets for this indicator)

BCDC defines the change in Bay acreage as “any area of the Bay created or restored, including salt ponds converted into tidal action, less the area of the Bay authorized to be filled pursuant to major permits and major consistency determinations through 1987”. This definition includes any administrative amendments to the data.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/vital-signs-bay-restoration-bay-area-mba6-sgwr\".\"vital_signs_bay_restoration_bay_area\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.