Name: Bridgelet
Creator: US Government
License: http://creativecommons.org/licenses/by/4.0/legalcode

About this Dataset

Bridgelet

BRIDGELET_PUB
Organization: State of Iowa
Last updated: 2024-04-12T12:48:28.519507
Tags: asset-inventory, assets, bridgelets, culverts, inventory, maintenance, primary-road, right-of-way, row

Tables

Table 1

@usgov.state_of_iowa_bridgelet_data.table_1

98.46 kB
289 rows
43 columns

CREATE TABLE table_1 (
  "the_geom" VARCHAR,
  "objectid" BIGINT,
  "fhwa_number" DOUBLE,
  "maintenance_number" VARCHAR,
  "bridge_position" VARCHAR,
  "route_type" DOUBLE,
  "stream" VARCHAR,
  "agency" DOUBLE,
  "agency_location" VARCHAR,
  "location" VARCHAR,
  "location_compiled" VARCHAR,
  "bridgelet_description" VARCHAR,
  "design_number" VARCHAR,
  "comments" VARCHAR,
  "other_type_description" VARCHAR,
  "length_feet" DOUBLE  -- Length (Feet),
  "width_feet" DOUBLE  -- Width (Feet),
  "skew_angle" DOUBLE,
  "sia113_code" DOUBLE,
  "sia113_description" VARCHAR,
  "record_date_utc" VARCHAR  -- Record Date (UTC),
  "record_created_by" VARCHAR,
  "record_created_date_utc" VARCHAR  -- Record Created Date (UTC),
  "record_edited_by" VARCHAR,
  "record_edited_date_utc" VARCHAR  -- Record Edited Date (UTC),
  "cost_center" DOUBLE,
  "latitude_wgs84_ll" DOUBLE  -- Latitude (WGS84-LL),
  "longitude_wgs84_ll" DOUBLE  -- Longitude (WGS84-LL),
  "bridgelet_id" VARCHAR,
  "bridgelet_guid" VARCHAR,
  "globalid_2" VARCHAR,
  "rest_service_last_updated_utc" VARCHAR  -- REST Service Last Updated (UTC),
  "route_id" VARCHAR,
  "rest_utc_offset" VARCHAR,
  "date_record_created_utc_offset" VARCHAR,
  "date_record_last_updated_utc_offset" VARCHAR,
  "county_number" DOUBLE,
  "county_name" VARCHAR,
  "garage_name" VARCHAR,
  "rail_type" DOUBLE,
  "deck_type" DOUBLE,
  "substrate_type" DOUBLE,
  "super_type" DOUBLE
);