Name: AVL Direct
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

AVL Direct

AVL_DIRECT
Organization: State of Iowa
Last updated: 2024-04-12T12:52:55.545455
Tags: avl, operations, plow, plow-truck, snow, snow-plow, snow-removal, winter-operations

Tables

Table 1

@usgov.state_of_iowa_avl_direct_5d73e.table_1

29.15 KB
56 rows
37 columns


CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "truck_label_a_name" VARCHAR,
  "x_coordinate_ll84" DOUBLE,
  "y_coordinate_ll84" DOUBLE,
  "heading" DOUBLE,
  "velocity_mph" DOUBLE,
  "road_temp_f" VARCHAR,
  "air_temp_f" VARCHAR,
  "solid_material" VARCHAR,
  "liquid_material" VARCHAR,
  "prewet_material" VARCHAR,
  "solid_rate" VARCHAR,
  "liquid_rate" VARCHAR,
  "prewet_rate" VARCHAR,
  "front_plow_state" BIGINT,
  "right_wing_plow_state" BIGINT,
  "left_wing_plow_state" BIGINT,
  "underbelly_plow_state" BIGINT,
  "solid_run_total" VARCHAR,
  "liquid_run_total" VARCHAR,
  "prewet_run_total" VARCHAR,
  "solid_set_rate" VARCHAR,
  "liquid_set_rate" VARCHAR,
  "prewet_set_rate" VARCHAR,
  "blast_mode_over_500lbs_mile" VARCHAR,
  "total_active_trucks" BIGINT,
  "active_material" VARCHAR,
  "route_name" VARCHAR,
  "avl_ping_date_time_local_iowa" VARCHAR,
  "avl_ping_date_time_utc" VARCHAR,
  "ping_datetime_utc_offset" VARCHAR,
  "rest_service_last_updated" VARCHAR,
  "rest_service_last_updated_utc_offset" VARCHAR,
  "cost_center" VARCHAR,
  "maintenance_district" VARCHAR,
  "garage_name" VARCHAR
);