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 https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"bayareametro-gov/infrastructure-access-areas-2021-bv8n-cszu\".\"infrastructure_access_areas_2021\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.