Name: TIM Closures
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

TIM Closures

This layer contains Iowa DOT Office of Transportation Operations Transportation Incident Management (TIM) Closures.
Organization: State of Iowa
Last updated: 2024-04-12T12:49:24.860932

Tables

Table 1

@usgov.state_of_iowa_tim_closures_data.table_1

1.24 MB
1,029 rows
23 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,
  "critical_locations_to_monitor" VARCHAR,
  "beginning_of_segment" VARCHAR,
  "digital_message_sign" VARCHAR,
  "traffic_signals" VARCHAR,
  "type_of_alternate_route" VARCHAR,
  "priority" VARCHAR,
  "pdf" VARCHAR,
  "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
);