Smart Rat Boxes

This dataset provides a list of locations and catch/kill data for City of Cambridge "Smart Box" and "Smart Pipe" devices through the City's contractor, Modern Pest.

Smart boxes are placed primarily on public property, and smart pipes are located in the sewers.

Rodent sightings reported on Commonwealth Connect, 311 and see-click-fix can help us locate new or additional problem areas for box or pipe placement.

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 \"cambridgema-gov/smart-rat-boxes-78bs-b5ig\".\"smart_rat_boxes\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.