Reports from Report It! SMC

Report It! SMC allows citizens, residents, and visitors to report illegal dumping issues quickly and easily via web tools and mobile apps. You can even take photos of issues and submit them on your phone! These reports are then forwarded directly to County departments to respond and address. See more at: http://nfoforward.org/about-our-community/report-it-smc

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 \"datahub-smcgov/reports-from-report-it-smc-4u6x-x6rk\".\"reports_from_report_it_smc\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.