Name: Bridges
Creator: US Government
License: http://www.opendefinition.org/licenses/cc-by

About this Dataset

Bridges

Feature layer containing authoritative bridge points for Sioux Falls, South Dakota.
Organization: City of Sioux Falls
Last updated: 2024-04-01T20:45:55.962592
Tags: bridges, lincoln, minnehaha, sd, sioux-falls, south-dakota, transportation

Tables

Table 1

@usgov.city_of_sioux_falls_bridges_ee3ec.table_1

67.41 KB
109 rows
67 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "assetid" VARCHAR,
  "bridgetype" VARCHAR,
  "bridgenumber" VARCHAR,
  "bridgedesign" VARCHAR,
  "material" VARCHAR,
  "size" VARCHAR,
  "featurecrossed" VARCHAR,
  "structurenumber" VARCHAR,
  "oldstructurenum" VARCHAR,
  "originaluse" VARCHAR,
  "traffictype" VARCHAR,
  "spantype" DOUBLE,
  "spanlength" VARCHAR,
  "numberofspans" DOUBLE,
  "decktype" VARCHAR,
  "deckthickness" DOUBLE,
  "lanesonbridge" DOUBLE,
  "medianonbridge" DOUBLE,
  "approachwidth" DOUBLE,
  "dailytrafficvolume" DOUBLE,
  "yeartrafficcounted" DOUBLE,
  "condition" VARCHAR,
  "ownedby" VARCHAR,
  "managedby" VARCHAR,
  "installyear" DOUBLE,
  "name" VARCHAR,
  "sufficiencyrating" DOUBLE,
  "ratingdate" TIMESTAMP,
  "hl93rfop" DOUBLE,
  "hl93operatingload" DOUBLE,
  "hl93rfinv" DOUBLE,
  "hl93inventoryload" DOUBLE,
  "type3rfop" DOUBLE,
  "type3operatingload" DOUBLE,
  "type3rfinv" DOUBLE,
  "type3inventoryload" DOUBLE,
  "type3s2rfop" DOUBLE,
  "type3s2operatingload" DOUBLE,
  "type3s2rfinv" DOUBLE,
  "type3s2inventoryload" DOUBLE,
  "type32rfop" DOUBLE,
  "type32operatingload" DOUBLE,
  "type32rfinv" DOUBLE,
  "type32inventoryload" DOUBLE,
  "su4rfop" DOUBLE,
  "su4operatingload" DOUBLE,
  "su4rfinv" DOUBLE,
  "su4inventoryload" DOUBLE,
  "su5rfop" DOUBLE,
  "su5operatingload" DOUBLE,
  "su5rfinv" DOUBLE,
  "su5inventoryload" DOUBLE,
  "su6rfop" DOUBLE,
  "su6operatingload" DOUBLE,
  "su6rfinv" DOUBLE,
  "su6inventoryload" DOUBLE,
  "su7rfop" DOUBLE,
  "su7operatingload" DOUBLE,
  "su7rfinv" DOUBLE,
  "su7inventoryload" DOUBLE,
  "nrlrfop" DOUBLE,
  "nrloperatingload" DOUBLE,
  "nrlrfinv" DOUBLE,
  "nrlinventoryload" DOUBLE
);