Pedestrian Signals by US Government | Transportation and Logistics

About this Dataset

Pedestrian Signals

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

Tables

Table 1

@usgov.city_of_sioux_falls_pedestrian_signals_fded6.table_1

185.9 KB
1199 rows
47 columns


CREATE TABLE table_1 (
  "x" DOUBLE,
  "y" DOUBLE,
  "objectid" BIGINT,
  "quadrant" VARCHAR,
  "crossingdirection" VARCHAR,
  "pushbutton" VARCHAR,
  "pushbuttontype" VARCHAR,
  "buttonoperational" VARCHAR,
  "orientedtoxwalk" VARCHAR,
  "crossingsign" VARCHAR,
  "signcondition" VARCHAR,
  "signtype" VARCHAR,
  "pbtoxwalkoffset" DOUBLE,
  "pbtofaceofcurb" DOUBLE,
  "pbreachtoclrgrnd" DOUBLE,
  "httocntrofpb" DOUBLE,
  "adaagstnrdclrspc" VARCHAR,
  "sizeofclearspaceifnotmet" VARCHAR,
  "runningslope" DOUBLE,
  "crossslope" DOUBLE,
  "wlkdistfrompbtoexitxwalk" DOUBLE,
  "crosswalklength" DOUBLE,
  "pedhead" VARCHAR,
  "countdowntimer" VARCHAR,
  "headtoxwalkoffset" DOUBLE,
  "created_user" VARCHAR,
  "created_date" TIMESTAMP,
  "last_edited_user" VARCHAR,
  "last_edited_date" TIMESTAMP,
  "globalid" VARCHAR,
  "distancebetweenpushbuttons" DOUBLE,
  "signalid" DOUBLE,
  "intersection" VARCHAR,
  "projectname" VARCHAR,
  "projectnumber" DOUBLE,
  "inspecteddate" TIMESTAMP,
  "compliancerating" DOUBLE,
  "installyear" DOUBLE,
  "condition" VARCHAR,
  "assetid" VARCHAR,
  "poletype" VARCHAR,
  "manufacturer" VARCHAR,
  "model" VARCHAR,
  "intersectionname" VARCHAR,
  "intersectionid" DOUBLE,
  "photo" VARCHAR,
  "status" VARCHAR
);