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

About this Dataset

Streets

Feature layer containing authoritative street lines for Sioux Falls, South Dakota.
Organization: City of Sioux Falls
Last updated: 2024-04-01T20:49:46.555776
Tags: lincoln, minnehaha, sd, sioux-falls, south-dakota, streets, transportation

Tables

Table 1

@usgov.city_of_sioux_falls_streets_65e54.table_1

1.02 MB
10,685 rows
66 columns

CREATE TABLE table_1 (
  "objectid" BIGINT,
  "unittype" VARCHAR,
  "lt1" DOUBLE,
  "rt1" DOUBLE,
  "lt2" DOUBLE,
  "rt2" DOUBLE,
  "pr1" VARCHAR,
  "stnm1" VARCHAR,
  "typ1" VARCHAR,
  "pd1" VARCHAR,
  "ziplt" DOUBLE,
  "ziprt" DOUBLE,
  "pr2" VARCHAR,
  "stnm2" VARCHAR,
  "typ2" VARCHAR,
  "pd2" VARCHAR,
  "pr3" VARCHAR,
  "stnm3" VARCHAR,
  "typ3" VARCHAR,
  "pd3" VARCHAR,
  "county" VARCHAR,
  "subarea" VARCHAR,
  "owner" VARCHAR,
  "surftype" VARCHAR,
  "surfwid" DOUBLE,
  "rw" DOUBLE,
  "nolanes" DOUBLE,
  "parklanes" DOUBLE,
  "turnlane" VARCHAR,
  "speedlimit" BIGINT,
  "oneway" VARCHAR,
  "major" VARCHAR,
  "route" DOUBLE,
  "prtyp1" VARCHAR,
  "hwyno1" DOUBLE,
  "hwyno2" DOUBLE,
  "venue_l" VARCHAR,
  "venue_r" VARCHAR,
  "streetname" VARCHAR,
  "built" DOUBLE,
  "source" VARCHAR,
  "county_l" VARCHAR,
  "county_r" VARCHAR,
  "msagcomm_l" VARCHAR,
  "msagcomm_r" VARCHAR,
  "gisid" DOUBLE,
  "country" VARCHAR,
  "units" VARCHAR,
  "assetid" VARCHAR,
  "from_elev" BIGINT,
  "to_elev" BIGINT,
  "pci" DOUBLE,
  "divtype" VARCHAR,
  "streetwidth" DOUBLE,
  "surfacedepth" DOUBLE,
  "basedepth" DOUBLE,
  "reconstructeddate" DOUBLE,
  "status" VARCHAR,
  "maintainedby" VARCHAR,
  "budgetvaluationyear" DOUBLE,
  "basetype" VARCHAR,
  "curbgutter" VARCHAR,
  "esn_l" DOUBLE,
  "esn_r" DOUBLE,
  "truckroute" VARCHAR,
  "shapestlength" DOUBLE
);