Name: Plowcam Images
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Plowcam Images

AVL_Images
Organization: State of Iowa
Last updated: 2024-04-12T12:50:26.690564
Tags: avl, operations, plow, plow-camera, plow-images, plow-truck, snow-plow, winter, winter-operations

Tables

Table 1

@usgov.state_of_iowa_plowcam_images_25d8b.table_1

25.12 kB
6 rows
30 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "photo_uid" BIGINT,
  "truck_id" VARCHAR,
  "latitude_ll84" DOUBLE  -- Latitude (LL84),
  "longitude_ll84" DOUBLE  -- Longitude (LL84),
  "photo_file_date_utc" VARCHAR  -- Photo File Date (UTC),
  "photo_url" VARCHAR,
  "secure_photo_url" VARCHAR,
  "truck_speed_mph" BIGINT  -- Truck Speed (MPH),
  "truck_bearing_degrees" BIGINT  -- Truck Bearing (Degrees),
  "route_name" VARCHAR,
  "reference_post" BIGINT,
  "reference_post_offset" DOUBLE,
  "photo_filename" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "photo_rank_by_truck_oldest_photo_is_1" BIGINT  -- Photo Rank By Truck (Oldest Photo Is 1),
  "utc_offset" VARCHAR,
  "cost_center" BIGINT,
  "dot_maintenance_district" BIGINT,
  "county_number" VARCHAR,
  "maintenance_garage" VARCHAR,
  "county_name" VARCHAR,
  "phote_filedate_utc_offset" VARCHAR,
  "photo_rank_by_truck_newest_is_1" BIGINT  -- Photo Rank By Truck (Newest Is 1),
  "numeric_reference_posts_for_marc_2_0" DOUBLE,
  "globalid" VARCHAR,
  "route_direction" VARCHAR,
  "school_district_name" VARCHAR,
  "route_name_no_direction" VARCHAR  -- Route Name (No Direction)
);