Name: Traffic Signals And Pedestrian Signals
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Traffic Signals And Pedestrian Signals

This data contains information about traffic and pedestrian signals in the city of Austin, Texas. The data is updated on a daily basis and maintained by the Austin Transportation & Public Works Department's Arterial Management Division.

You may also be interested in the following resources:

Traffic Signal Monitor
https://data.mobility.austin.gov/signal-monitor
Signal Evaluations
https://data.mobility.austin.gov/signal-evaluations
Organization: City of Austin
Last updated: 2020-11-12T13:30:40.411235
Tags: atms, mobility, pedestrians, phbs, safety, traffic-signals, transit, transportation

Tables

Table 1

@usgov.city_of_austin_traffic_signals_and_pedestrian_signals.table_1

199.5 kB
1,303 rows
45 columns

CREATE TABLE table_1 (
  "signal_id" BIGINT,
  "location_name" VARCHAR,
  "signal_type" VARCHAR,
  "signal_status" VARCHAR,
  "atd_location_id" VARCHAR,
  "coa_intersection_id" DOUBLE,
  "control" VARCHAR,
  "council_district_s" VARCHAR  -- Council District(s),
  "primary_st" VARCHAR,
  "cross_st" VARCHAR,
  "cross_st_segment_id" DOUBLE,
  "landmark" VARCHAR,
  "primary_signal" VARCHAR,
  "secondary_signal_s" VARCHAR  -- Secondary Signal(s),
  "jurisdiction_label" VARCHAR,
  "primary_st_segment_id" BIGINT,
  "signal_eng_area" VARCHAR  -- Signal Eng. Area,
  "traffic_engineer_area" VARCHAR,
  "turn_on_date" TIMESTAMP,
  "cross_st_block" DOUBLE,
  "primary_st_block" DOUBLE,
  "signal_pm_max_fiscal_year" DOUBLE,
  "pedestrian_button_type" VARCHAR,
  "leading_pedestrian_interval" BOOLEAN,
  "date_leading_pedestrian_interval_installed" VARCHAR,
  "north_south_pedestrian_interval" VARCHAR,
  "east_west_pedestrian_interval" VARCHAR,
  "leading_pedestrian_interval_comment" VARCHAR,
  "bicycle_signal" BOOLEAN,
  "bus_stops" VARCHAR,
  "source_db_id" VARCHAR,
  "ip_communication_status" VARCHAR,
  "comm_status_datetime" VARCHAR,
  "owner" VARCHAR,
  "detection_status" VARCHAR,
  "detection_status_date" VARCHAR,
  "construction_note" VARCHAR,
  "construction_note_date" VARCHAR,
  "modified_date" VARCHAR,
  "location" VARCHAR,
  "corridor_retiming_zone" VARCHAR,
  "backplate_installed" BOOLEAN,
  "backplate_type" VARCHAR,
  "intersection_backplate_status" VARCHAR,
  "dark_signal" VARCHAR
);