Name: Iowa 511
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Iowa 511

Iowa Department of Transportation 511 feature layer. Updated every 10 minutes. Events can be found on the 511 Website (www.511ia.org)
Organization: State of Iowa
Last updated: 2024-04-12T12:48:15.080555
Tags: 511, atms, commercial-vehicle-restrictions, its, operations, road-closures, road-conditions, road-work, tms, traffic

Tables

Table 1

@usgov.state_of_iowa_iowa_511_95bb9.table_1

19.77 kB
2 rows
28 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "alternate_route" VARCHAR,
  "end_time" VARCHAR,
  "cars_id" VARCHAR,
  "event_expire_date" BIGINT,
  "event_expire_time" BIGINT,
  "event_issue_date" BIGINT,
  "event_issue_time" BIGINT,
  "priority" BIGINT,
  "route" VARCHAR,
  "start_time" VARCHAR,
  "update_date" TIMESTAMP,
  "update_time" VARCHAR,
  "state_orgid" VARCHAR,
  "instructions" VARCHAR,
  "gis_updated" TIMESTAMP,
  "symbol_style" VARCHAR,
  "cars_headline" VARCHAR,
  "phrase" VARCHAR,
  "cause" VARCHAR,
  "restrictions" VARCHAR,
  "message" VARCHAR,
  "message1" VARCHAR,
  "description" VARCHAR,
  "description1" VARCHAR,
  "link_text" VARCHAR,
  "date_record_edited" VARCHAR
);