Point In Time Homeless Survey Data

The County of Sonoma conducts an annual homeless count for the entire county. The survey data is derived from a sample of about 600 homeless persons countywide per year. The resulting information is statistically reliable only for the county as a whole, not for individual locations. The exception is the City of Santa Rosa, where the sample taken within the city is large enough to be predictive of the overall homeless population in that city.

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 \"sonomacounty-ca-gov/point-in-time-homeless-survey-data-d5jk-fziy\".\"point_in_time_homeless_survey_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.