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
"}
EOFSee the Splitgraph documentation
for more information.
