Name: Steel Beam Guardrails
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Steel Beam Guardrails

TB_STEELBEAM
Organization: State of Iowa
Last updated: 2024-04-12T12:50:36.906177
Tags: asset, asset-inventory, barriers, cable-barrier, concrete-barrier, crash-cushions, guardrail, maintenance, steel-beam, traffic-barriers

Tables

Table 1

@usgov.state_of_iowa_steel_beam_guardrails_data.table_1

56.23 kB
78 rows
51 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "inventory_date" VARCHAR,
  "route_name" VARCHAR,
  "station" VARCHAR,
  "milepost_start" VARCHAR  -- Milepost - Start,
  "milepost_end" VARCHAR  -- Milepost - End,
  "placement" VARCHAR,
  "garage" BIGINT,
  "steel_beam_type" VARCHAR,
  "barrier_purpose" VARCHAR,
  "bridge_number" VARCHAR,
  "post_type" VARCHAR,
  "curb" DOUBLE  -- Curb?,
  "curb_height_if_applicable" DOUBLE  -- Curb Height (If Applicable),
  "guardrail_approach_end" VARCHAR,
  "guardrail_trailing_end" VARCHAR,
  "inventory_comments" VARCHAR,
  "photo_taken" DOUBLE  -- Photo Taken?,
  "inspectionid" VARCHAR,
  "processed" VARCHAR  -- Processed?,
  "date_created" VARCHAR,
  "created_by" VARCHAR,
  "date_edited" VARCHAR,
  "edited_by" VARCHAR,
  "steel_beam_id" VARCHAR,
  "transition_end_type_1" DOUBLE  -- Transition End Type - 1,
  "transition_end_type_2" DOUBLE  -- Transition End Type -2,
  "latitude_start" DOUBLE,
  "latitude_end" DOUBLE,
  "longitude_start" DOUBLE,
  "longitude_end" DOUBLE,
  "steelbeam_serial_nm" VARCHAR,
  "steelbeam_tag_comments" VARCHAR,
  "savegid" VARCHAR,
  "connected_to" DOUBLE,
  "globalid" VARCHAR,
  "status" BIGINT,
  "route_id" VARCHAR,
  "from_measure" DOUBLE,
  "to_measure" DOUBLE,
  "effective_start_date" VARCHAR,
  "effective_end_date" VARCHAR,
  "project_number" VARCHAR,
  "district" DOUBLE,
  "county" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- Rest Service Last Updated (UTC),
  "rest_utc_offset" VARCHAR,
  "county_name" VARCHAR,
  "county_number" BIGINT,
  "shape_length" DOUBLE  -- Shape, Length
);