Historic Deer Kill Locations by US Government | Ecommerce and Consumer Trends

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

9.99 MB
132730 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,
  "county_number" VARCHAR,
  "comments" VARCHAR,
  "latitude_wgs84" DOUBLE,
  "longitude_wgs84" DOUBLE,
  "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,
  "edited_by" VARCHAR,
  "date_last_edited_utc" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR,
  "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
);