Name: TIM Alt Routes
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

TIM Alt Routes

This layer contains Iowa DOT Office of Transportation Operations Transportation Incident Management (TIM) Alternative Routes.
Organization: State of Iowa
Last updated: 2024-04-12T12:53:03.837114
Tags: incident, operations, tim, traveler

Tables

Table 1

@usgov.state_of_iowa_tim_alt_routes_data.table_1

23.53 MB
16,841 rows
24 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "rams_unique_id" VARCHAR,
  "route_id" VARCHAR,
  "from_measure" DOUBLE,
  "to_measure" DOUBLE,
  "effective_start_date" VARCHAR,
  "effective_end_date" VARCHAR,
  "created_by" VARCHAR,
  "system_create_date" VARCHAR,
  "system_modified_date" VARCHAR,
  "tim_id" BIGINT,
  "digital_message_signs" VARCHAR,
  "traffic_signals" VARCHAR,
  "type_of_alternate_route" BIGINT,
  "priority" DOUBLE,
  "beginning_of_segment" VARCHAR,
  "direction" VARCHAR,
  "alternate_tim_route" BIGINT,
  "alternate_route_sequence" BIGINT,
  "status_0_inactive_1_active" BIGINT  -- Status (0 = Inactive, 1 = Active),
  "utc_offset" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "shape_length" DOUBLE  -- Shape, Length
);