LASAN: Solid Resources Abandoned Waste Collection Activity

LA Sanitation information on abandoned waste requests updated monthly. This includes requests for Illegal Dumping, Illegal Bulky, Illegal E-Waste, and Illegal Metal Household Appliance collections.

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 \"lacity/lasan-solid-resources-abandoned-waste-collection-97ra-aqza\".\"lasan_solid_resources_abandoned_waste_collection\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.