Litter Study (Litterati) - Litter Per Meter

In 2022, Keep Norfolk Beautiful received a grant from Litterati to participate in the City Fingerprint Project. Litterati is a global litter data science company that records, analyzes, and provides insights into litter hotspots worldwide. Through the City Fingerprint Project, Litterati focused on observing and recording litter data in specific and repeatable locations in Norfolk through the Spring, Summer, and Fall of 2022 in order to provide a baseline of where litter is in Norfolk and what type is litter appears in the City. This dataset contains the distance in meters that were walked at each project location during each project phase (Spring, Summer, Fall). It also includes the number of objects of litter per meter that were observed during this project.

This dataset is a one-time data release and will not be updated.

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 \"norfolk-gov/litter-study-litterati-litter-per-meter-fq5y-c2yn\".\"litter_study_litterati_litter_per_meter\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.