Public K-12 Schools - BAAQMD Jurisdiction

Dataset Name: California School Campus Database (CSCD, last updated 2021)

Where dataset is from: Hosted by GreenInfo Network

URL: https://www.californiaschoolcampusdatabase.org/#about

When obtained: 10/12/2021

For what purpose it was obtained: General AB 617 Planning

User Manual: https://www.dropbox.com/s/yrup22l3dxy8d6i/CSCD2021%20UserManual.pdf?dl=0

Other information / Disclaimers:

California School Campus Database (CSCD) is now available for all public schools and colleges/universities in California.

CSCD is suitable for a wide range of planning, assessment, analysis, and display purposes. It should not be used as the basis for official regulatory, legal, or other such governmental actions unless reviewed by the user and deemed appropriate for their use. See the user manual for more information.

The first release of CSCD was developed by the Stanford Prevention Research Center and GreenInfo Network, with funding from the Tobacco-Related Disease Research Program grant #22RT-0142, PI: Lisa Henriksen, PhD.

CSCD 2018 was funded by a grant from the National Cancer Institute to Stanford Prevention Research Center grant 1R01-CA217165, PI: Lisa Henriksen, PhD.

CSCD 2021 was funded by the California Department of Parks and Recreation, Office of Grants and Local Services and a grant from the Chan Zuckerberg Initiative to the Center for Cities + Schools at the University of California, Berkeley grant 2020-218603, PI: Jeff Vincent, PhD.

CSCD was developed using Esri software under the Conservation Program.

CSCD is published by GreenInfo Network. Updates will be published as funding is available.

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/public-k12-schools-baaqmd-jurisdiction-uxua-nhg5\".\"public_k12_schools_baaqmd_jurisdiction\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.