Name: Traffic Barrier Crash Cushion
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Traffic Barrier Crash Cushion

TB_CRASHCUSHION
Organization: State of Iowa
Last updated: 2024-04-12T12:47:06.589086
Tags: asset-inventory, assets, barriers, crash-cushions, guardrail, inventory, maintenance, traffic-barriers

Tables

Table 1

@usgov.state_of_iowa_traffic_barrier_crash_cushion_data.table_1

66.64 kB
280 rows
31 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "inventory_date" VARCHAR,
  "route_name" VARCHAR,
  "placement" VARCHAR,
  "cost_center" DOUBLE,
  "type" VARCHAR,
  "cushion_purpose" VARCHAR,
  "additional_inventory_comments" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "county" DOUBLE,
  "inspection_id" VARCHAR,
  "offset" DOUBLE,
  "date_record_created" VARCHAR,
  "record_created_by" VARCHAR,
  "date_last_edited" VARCHAR,
  "record_edited_by" VARCHAR,
  "globalid_1" VARCHAR,
  "status" DOUBLE,
  "route_id" VARCHAR,
  "from_measure" DOUBLE,
  "effective_start_date" VARCHAR,
  "effective_end_date" VARCHAR,
  "project_number" VARCHAR,
  "district" DOUBLE,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "county_number" BIGINT,
  "county_name" VARCHAR,
  "photo_taken" DOUBLE  -- Photo Taken?
);