AB 617 "Path to Clean Air" - Jurisdictional Boundaries

This dataset is based on digitized census data from census-designated places and cities. Jurisdictions included within the Richmond/San Pablo jurisdictional boundary are:

City of Richmond: the full city is included, with the exception of the following small, disconnected areas located on either side of Pinole Valley Park, to the east of the Richmond/San Pablo Boundary:

Greenridge Heights, May Valley, El Sobrante Hills, Greenbriar, Carriage Hills North, Castro Heights, and Carriage Hills south.

City of San Pablo: the full city;

City of Pinole: a small portion of the city (located in the northeast corner of the CERP Boundary);

Unincorporated Contra Costa County:

North Richmond: the full unincorporated place;

Tara Hills: the full unincorporated place;

Montalvin Manor: the full unincorporated place;

Bayview: the full unincorporated place;

East Richmond Heights: most of the unincorporated place is included, other than a small area within a census tract that included El Cerrito (Census Tract #06013384000);

Rollingwood: the full unincorporated place; and

El Sobrante: less than half of the unincorporated place.

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/ab-617-path-to-clean-air-jurisdictional-boundaries-pwgz-y7cs\".\"ab_617_path_to_clean_air_jurisdictional_boundaries\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.