Historic_Deer_Kill_Locations

This dataset provides information regarding the location of deer kills. The records are generated from a view that comes from the Maintenance Resource Management System. The data is input from the field staff who are responsible for removal of the deer from the roadway. Data does not necessarily correlate to crash data related to deer impacts; this is strictly deer downed within the right of way that are documented and moved by Maintenance staff.

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 \"mydata-iowa-gov/historicdeerkilllocations-ghav-kspb\".\"historicdeerkilllocations\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.