Icon for Socrata external plugin
Open repository in Console
Updated 2 years ago
Indexed 2 hours ago

Infrastructure Access Areas (2021)

The Infrastructure Access Area data set is a composite data set that consists of Water Service Areas, Water Districts, and Urban Service Areas (USAs). Census designated Urbanized Areas and Urban Clusters were used as a proxy for infrastructure access in areas without adequate infrastructure data available. The Census Bureau identifies two types of urban areas:

Urbanized Areas (UAs) of 50,000 or more people;

Urban Clusters (UCs) of at least 2,500 and less than 50,000 people.

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 \
    -H "Content-Type: application/json" \
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/infrastructure-access-areas-2021-bv8n-cszu\".\"infrastructure_access_areas_2021\"
    LIMIT 100 

See the Splitgraph documentation for more information.

  • infrastructure_access_areas_2021