Baselight

Traffic Barrier Crash Cushion

State of Iowa

@usgov.state_of_iowa_traffic_barrier_crash_cushion_data

Loading...
Loading...

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
  • 65.08 KB
  • 280 rows
  • 31 columns
Loading...

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_utc_offset" VARCHAR,
  "county_number" BIGINT,
  "county_name" VARCHAR,
  "photo_taken" DOUBLE
);

Share link

Anyone who has the link will be able to view this.