Traffic Signal Re-Timing

City of Austin

@usgov.city_of_austin_traffic_signal_re_timing

Table List

1 table(33.6 KB)

Table 1

@usgov.city_of_austin_traffic_signal_re_timing.table_1

33.6 KB
176 rows
11 columns

atd_retiming_id Atd Retiming Id	system_id System Id	system_name System Name	scheduled_fy Scheduled Fy	retime_status Retime Status	status_date Status Date	total_vol Total Vol	vol_wavg_tt_pct_change Vol Wavg Tt Pct Change	vol_wavg_tt_seconds Vol Wavg Tt Seconds	signal_count Signal Count	engineer_note Engineer Note
37	48	7TH - EAST	2016	COMPLETED	09/26/2016 05:00:00 AM +0000	1217	0.0874176626	106.3872954444	12
47	11	US 183 - SOUTH	2017	COMPLETED	03/09/2017 06:00:00 AM +0000	1884	0.1955033403	368.3282932	8
48	4	LAMAR - CENTRAL	2017	COMPLETED	03/09/2017 06:00:00 AM +0000	1698	0.2467728446	419.0202901951	15
49	53	RM 2222 - EAST	2017	COMPLETED	05/22/2017 05:00:00 AM +0000	2569	0.1277766224	328.2581429652	3
50	56	TRINITY	2018	COMPLETED	09/06/2017 05:00:00 AM +0000	148	0.0150433559	2.2264166788	6
36	50	38TH	2016	COMPLETED	09/26/2016 05:00:00 AM +0000	1217	0.2585350642	314.6371731202	12	The 38th, Red River, Dean Keeton, and IH 35 Service Road corridors were timed as a group, for an average travel time reduction of 9.1% across all four corridors.
35	47	AIRPORT	2016	COMPLETED	09/26/2016 05:00:00 AM +0000				27
34	45	BARTON SPRINGS	2016	COMPLETED	09/26/2016 05:00:00 AM +0000	1479	0.0204620205	30.2633283876	9
33	43	BRAKER	2016	COMPLETED	09/26/2016 05:00:00 AM +0000	2478	0.1997937087	495.0888100457	19
32	42	BURLESON	2016	COMPLETED	09/26/2016 05:00:00 AM +0000	1232	0.0905418032	111.5475015363	11


CREATE TABLE table_1 (
  "atd_retiming_id" BIGINT,
  "system_id" BIGINT,
  "system_name" VARCHAR,
  "scheduled_fy" BIGINT,
  "retime_status" VARCHAR,
  "status_date" VARCHAR,
  "total_vol" BIGINT,
  "vol_wavg_tt_pct_change" DOUBLE,
  "vol_wavg_tt_seconds" DOUBLE,
  "signal_count" BIGINT,
  "engineer_note" VARCHAR
);