DOHMH Beach Water Quality Data

The DOHMH office of Public Health Engineering administers the Beach Surveillance and Monitoring Program for all permitted New York City beaches. The Beach Water Samples data set contains the enterococci measurements of beach water samples collected while administering the Monitoring Program. Monitoring Program conducts inspections from April through September of each year. For more information on the program, see: https://www.nyc.gov/site/doh/health/healthtopics/beach-class.page

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 \"cityofnewyork-us/dohmh-beach-water-quality-data-2xir-kwzz\".\"dohmh_beach_water_quality_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.