Name: Concrete Barriers
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Concrete Barriers

TB_CONCRETE
Organization: State of Iowa
Last updated: 2024-04-12T12:48:15.060330

Tables

Table 1

@usgov.state_of_iowa_concrete_barriers_data.table_1

1.59 MB
738 rows
41 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "inventory_date" VARCHAR,
  "route_name" VARCHAR,
  "station" VARCHAR,
  "milepost_start" VARCHAR,
  "milepost_end" DOUBLE,
  "placement" VARCHAR,
  "cost_center" DOUBLE,
  "type" VARCHAR,
  "barrier_purpose" VARCHAR,
  "bridge_number" VARCHAR,
  "curb_height" VARCHAR,
  "inventory_comments" VARCHAR,
  "latitude_start" DOUBLE,
  "latitude_end" DOUBLE,
  "longitude_start" DOUBLE  -- Longitude - Start,
  "longitude_end" DOUBLE  -- Longitude - End,
  "county" DOUBLE,
  "length" VARCHAR,
  "inspection_id" VARCHAR,
  "processed" VARCHAR,
  "date_record_created" VARCHAR,
  "record_created_by" VARCHAR,
  "date_last_edited" VARCHAR,
  "edited_by" VARCHAR,
  "globalid_1" VARCHAR,
  "status" DOUBLE,
  "route_id" VARCHAR,
  "from_measure" DOUBLE,
  "to_measure" DOUBLE,
  "project_number" VARCHAR,
  "district" DOUBLE,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "shape_length" DOUBLE  -- Shape, Length,
  "concrete_end" DOUBLE,
  "barrier_end_1" DOUBLE  -- Barrier End (1),
  "photo_taken" DOUBLE  -- Photo Taken?,
  "curb" DOUBLE,
  "barrier_end_2" DOUBLE  -- Barrier End (2)
);