Litter Index
The Community Appearance Index, also known as the Litter Index, is a tool designed by Keep America Beautiful to visually evaluate the overall appearance of a community using litter as an indicator. Every year, 60 routes throughout the five wards of Norfolk are analyzed to determine the cleanliness of the city. After a thorough training, a team of volunteers conduct the analysis using a scoring system ranging from 1-4 with “1” indicating minimal to no litter and “4” indicating extremely littered. Methodology for this process includes recruiting volunteers who commit to attend a one-and-a-half-day Community Appearance Index scan. Each volunteer is thoroughly trained on the index to accurately and consistently survey a statistical sample of the city. The results of the scan are then averaged to produce the City of Norfolk Community Appearance Index score.
This dataset is updated annually; the data begins in 2010. The Litter Index survey is normally conducted in August; the 2020 survey will be delayed due to COVID-19.
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-index-nbz2-dgus\".\"litter_index\"
LIMIT 100
"}
EOF
See the Splitgraph documentation
for more information.