Open repository in Console
Readme
Updated 3 years ago
‧ Indexed 1 month ago
Census Incorporated Places 2020
Jurisdictions in the San Francisco Bay Area, where counties' unincorporated portions are included as separate entities to form a mutually exclusive set of geographies for the region.
The boundaries come from Census Places TIGER file 2020 vintage - places are cut out from the counties to form the remainder, and those are added as separate line items
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/census-incorporated-places-2020-jwv4-mqxs\".\"census_incorporated_places_2020\" LIMIT 100 "} EOF
See the Splitgraph documentation for more information.