About this Dataset

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.
Organization: State of Iowa
Last updated: 2024-04-12T12:48:42.397585
Tags: assets, deer, deer-kill, inventory, maintenance

Tables

Table 1

@usgov.state_of_iowa_historic_deer_kill_locations_data.table_1

10.48 MB
132,730 rows
29 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "cost_center" BIGINT,
  "calendar_year" VARCHAR,
  "fiscal_year" BIGINT,
  "fiscal_year_quarter" BIGINT,
  "deer_kill_date_utc" VARCHAR  -- Deer Kill Date (UTC),
  "county_number" VARCHAR,
  "comments" VARCHAR,
  "latitude_wgs84" DOUBLE  -- Latitude (WGS84),
  "longitude_wgs84" DOUBLE  -- Longitude (WGS84),
  "burial_description" VARCHAR,
  "maintenance_district_number" VARCHAR,
  "globalid" VARCHAR,
  "rams_route_id" VARCHAR,
  "county_name" VARCHAR,
  "record_created_by" VARCHAR,
  "date_record_created_utc" VARCHAR  -- Date Record Created (UTC),
  "edited_by" VARCHAR,
  "date_last_edited_utc" VARCHAR  -- Date Last Edited (UTC),
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "utc_offset_for_rest_service_date" VARCHAR,
  "utc_offset_for_deer_kill_date" VARCHAR,
  "reference_post" VARCHAR,
  "reference_post_offset" VARCHAR,
  "common_route_name" VARCHAR,
  "burial_method" VARCHAR,
  "sex_of_deer" VARCHAR,
  "response_to_complaint_y_n" BIGINT  -- Response To Complaint (Y/N)
);