Surplus Crown Property Recycle

This category encompasses items of surplus that have been removed from various pieces of furniture and equipment destined for landfills throughout the Province. These pieces are then sent to, or picked up by, various organizations committed to the Province’s continuing program on the diversion of solid waste from Provincial or Municipal landfills. There are other pieces of surplus equipment, such as IT assets, that may be broken, causing removal of sensitive information to be impossible in the traditional manner. In such cases, these items are securely disposed of by the Province’s contracted metal recycler. Other surplus or obsolete electronic items are recycled through the Atlantic Canada’s Electronic Stewardship (ACES) in accordance with the Electronic Product Stewardship Regulations.

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 \"novascotia-ca/surplus-crown-property-recycle-9bm5-tg9g\".\"surplus_crown_property_recycle\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.