Traffic and Pedestrian Signals

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.austintexas.gov
Id p53x-x73x
Name Traffic and Pedestrian Signals
Attribution Austin Transportation Department Arterial Management Division
Tags transportation, transit, mobility, traffic signals, pedestrians, phbs, safety
Created 2016-11-19T21:55:06Z
Publication Date 2017-04-19T22:55:39Z

Description

This data contains information about traffic and pedestrian signals in the city of Austin, Texas. The data is maintained by the Austin Transportation Department Arterial Management Division.

Columns

| Included | Schema Type    | Field Name             | Name                   | Data Type     | Render Type   |
| ======== | ============== | ====================== | ====================== | ============= | ============= |
| Yes      | series tag     | atd_location_id        | ATD_LOCATION_ID        | text          | text          |
| Yes      | series tag     | signal_id              | SIGNAL_ID              | text          | number        |
| Yes      | series tag     | coa_intersection_id    | COA_INTERSECTION_ID    | text          | number        |
| Yes      | series tag     | comm_plan              | COMM_PLAN              | text          | text          |
| Yes      | series tag     | control                | CONTROL                | text          | text          |
| Yes      | series tag     | council_district       | COUNCIL_DISTRICT       | text          | number        |
| Yes      | series tag     | cross_st               | CROSS_ST               | text          | text          |
| Yes      | series tag     | cross_st_aka           | CROSS_ST_AKA           | text          | text          |
| Yes      | series tag     | cross_st_segment_id    | CROSS_ST_SEGMENT_ID    | text          | number        |
| Yes      | numeric metric | ip_control             | IP_CONTROL             | number        | number        |
| Yes      | numeric metric | ip_switch              | IP_SWITCH              | number        | number        |
| Yes      | series tag     | jurisdiction           | JURISDICTION           | text          | text          |
| Yes      | series tag     | landmark               | LANDMARK               | text          | text          |
| Yes      | series tag     | location_name          | LOCATION_NAME          | text          | text          |
| Yes      | series tag     | primary_signal_id      | PRIMARY_SIGNAL_ID      | text          | number        |
| Yes      | series tag     | primary_st             | PRIMARY_ST             | text          | text          |
| Yes      | series tag     | primary_st_aka         | PRIMARY_ST_AKA         | text          | text          |
| Yes      | series tag     | primary_st_segment_id  | PRIMARY_ST_SEGMENT_ID  | text          | number        |
| Yes      | series tag     | signal_eng_area        | SIGNAL_ENG_AREA        | text          | text          |
| Yes      | series tag     | signal_status          | SIGNAL_STATUS          | text          | text          |
| Yes      | series tag     | signal_type            | SIGNAL_TYPE            | text          | text          |
| Yes      | series tag     | switch_comm            | SWITCH_COMM            | text          | text          |
| Yes      | series tag     | traffic_eng_area       | TRAFFIC_ENG_AREA       | text          | text          |
| No       |                | turn_on_date           | TURN_ON_DATE           | calendar_date | calendar_date |
| Yes      | time           | modified_date          | MODIFIED_DATE          | calendar_date | calendar_date |
| No       |                | latitude               | LATITUDE               | number        | number        |
| No       |                | longitude              | LONGITUDE              | number        | number        |
| Yes      | numeric metric | cross_st_block         | CROSS_ST_BLOCK         | number        | number        |
| Yes      | numeric metric | primary_st_block       | PRIMARY_ST_BLOCK       | number        | number        |
| No       |                | pm_max_fiscal_year     | PM_MAX_FISCAL_YEAR     | number        | number        |
| Yes      | series tag     | pedestrian_signal_type | PEDESTRIAN_SIGNAL_TYPE | text          | text          |
| Yes      | series tag     | secondary_signals      | SECONDARY_SIGNALS      | text          | text          |
| Yes      | series tag     | source_db_id           | SOURCE_DB_ID           | text          | text          |

Time Field

Value = modified_date
Format & Zone = yyyy-MM-dd'T'HH:mm:ss

Series Fields

Excluded Fields = turn_on_date,latitude,longitude,pm_max_fiscal_year

Data Commands

series e:p53x-x73x d:2016-12-04T11:08:00.000Z t:switch_comm=Both t:cross_st="LAMAR BLVD" t:control=PRIMARY t:coa_intersection_id=5158418 t:location_name="GUADALUPE ST / LAMAR BLVD" t:source_db_id=58164b9af9195edb2a5e3a07 t:cross_st_segment_id=2046174 t:primary_st_segment_id=2046169 t:council_district=9 t:signal_id=2 t:atd_location_id=LOC16-000005 t:signal_type=TRAFFIC t:primary_st="GUADALUPE ST" t:signal_status=TURNED_ON m:ip_control=1 m:ip_switch=1 m:primary_st_block=4700 m:cross_st_block=4701

series e:p53x-x73x d:2016-09-20T19:00:00.000Z t:switch_comm=Both t:cross_st="51ST ST" t:control=PRIMARY t:coa_intersection_id=5158588 t:location_name="LAMAR BLVD / 51ST ST" t:source_db_id=58164b9af9195edb2a5e3a09 t:cross_st_segment_id=2019845 t:primary_st_segment_id=2019844 t:council_district=9 t:signal_id=3 t:atd_location_id=LOC16-000010 t:signal_type=TRAFFIC t:primary_st="LAMAR BLVD" t:signal_status=TURNED_ON m:ip_control=1 m:ip_switch=1 m:primary_st_block=5000 m:cross_st_block=601

series e:p53x-x73x d:2016-09-20T19:00:00.000Z t:switch_comm=Both t:cross_st="NORTH LOOP BLVD" t:control=PRIMARY t:coa_intersection_id=5158745 t:location_name="LAMAR BLVD / NORTH LOOP BLVD" t:source_db_id=58164b9af9195edb2a5e3a0b t:cross_st_segment_id=2019848 t:primary_st_segment_id=2019847 t:council_district=7 t:signal_id=4 t:atd_location_id=LOC16-000015 t:signal_type=TRAFFIC t:primary_st="LAMAR BLVD" t:signal_status=TURNED_ON m:ip_control=1 m:ip_switch=1 m:primary_st_block=5200 m:cross_st_block=801

Meta Commands

metric m:ip_control p:integer l:IP_CONTROL t:dataTypeName=number

metric m:ip_switch p:integer l:IP_SWITCH t:dataTypeName=number

metric m:cross_st_block p:integer l:CROSS_ST_BLOCK t:dataTypeName=number

metric m:primary_st_block p:integer l:PRIMARY_ST_BLOCK t:dataTypeName=number

entity e:p53x-x73x l:"Traffic and Pedestrian Signals" t:attribution="Austin Transportation Department Arterial Management Division" t:url=https://data.austintexas.gov/api/views/p53x-x73x

property e:p53x-x73x t:meta.view v:id=p53x-x73x v:attributionLink=http://transportation.austintexas.io v:averageRating=0 v:name="Traffic and Pedestrian Signals" v:attribution="Austin Transportation Department Arterial Management Division"

property e:p53x-x73x t:meta.view.license v:name="Public Domain"

property e:p53x-x73x t:meta.view.owner v:id=8t3r-wq64 v:profileImageUrlMedium=/api/users/8t3r-wq64/profile_images/THUMB v:profileImageUrlLarge=/api/users/8t3r-wq64/profile_images/LARGE v:screenName="Austin Transportation" v:profileImageUrlSmall=/api/users/8t3r-wq64/profile_images/TINY v:displayName="Austin Transportation"

property e:p53x-x73x t:meta.view.tableauthor v:id=8t3r-wq64 v:profileImageUrlMedium=/api/users/8t3r-wq64/profile_images/THUMB v:profileImageUrlLarge=/api/users/8t3r-wq64/profile_images/LARGE v:screenName="Austin Transportation" v:profileImageUrlSmall=/api/users/8t3r-wq64/profile_images/TINY v:roleName=editor_stories v:displayName="Austin Transportation"

Top Records

| atd_location_id | signal_id | coa_intersection_id | comm_plan | control | council_district | cross_st        | cross_st_aka | cross_st_segment_id | ip_control | ip_switch | jurisdiction | landmark | location_name                | primary_signal_id | primary_st   | primary_st_aka | primary_st_segment_id | signal_eng_area | signal_status | signal_type | switch_comm | traffic_eng_area | turn_on_date        | modified_date       | latitude   | longitude   | cross_st_block | primary_st_block | pm_max_fiscal_year | pedestrian_signal_type | secondary_signals         | source_db_id             | 
| =============== | ========= | =================== | ========= | ======= | ================ | =============== | ============ | =================== | ========== | ========= | ============ | ======== | ============================ | ================= | ============ | ============== | ===================== | =============== | ============= | =========== | =========== | ================ | =================== | =================== | ========== | =========== | ============== | ================ | ================== | ====================== | ========================= | ======================== | 
| LOC16-000005    | 2         | 5158418             |           | PRIMARY | 9                | LAMAR BLVD      |              | 2046174             | 1          | 1         |              |          | GUADALUPE ST / LAMAR BLVD    |                   | GUADALUPE ST |                | 2046169               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1965-03-16T18:00:00 | 2016-12-04T11:08:00 | 30.3166466 | -97.7322464 | 4701           | 4700             |                    |                        |                           | 58164b9af9195edb2a5e3a07 | 
| LOC16-000010    | 3         | 5158588             |           | PRIMARY | 9                | 51ST ST         |              | 2019845             | 1          | 1         |              |          | LAMAR BLVD / 51ST ST         |                   | LAMAR BLVD   |                | 2019844               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1976-10-26T19:00:00 | 2016-09-20T19:00:00 | 30.3187695 | -97.7308197 | 601            | 5000             |                    |                        |                           | 58164b9af9195edb2a5e3a09 | 
| LOC16-000015    | 4         | 5158745             |           | PRIMARY | 7                | NORTH LOOP BLVD |              | 2019848             | 1          | 1         |              |          | LAMAR BLVD / NORTH LOOP BLVD |                   | LAMAR BLVD   |                | 2019847               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1951-08-01T19:00:00 | 2016-09-20T19:00:00 | 30.3210888 | -97.729393  | 801            | 5200             |                    |                        |                           | 58164b9af9195edb2a5e3a0b | 
| LOC16-000020    | 5         | 5159119             |           | PRIMARY | 4                | LAMAR BLVD      |              | 2012199             | 1          | 1         |              |          | KOENIG LN / LAMAR BLVD       |                   | KOENIG LN    |                | 2040437               |                 | TURNED_ON     | TRAFFIC     | Both        |                  |                     | 2016-09-20T19:00:00 | 30.325943  | -97.7263336 | 5630           | 600              | 2017               |                        |                           | 58164b9af9195edb2a5e3a0d | 
| LOC16-000025    | 6         | 5159402             |           | PRIMARY | 7                | DENSON DR       |              | 2012025             | 1          | 1         |              |          | LAMAR BLVD / DENSON DR       |                   | LAMAR BLVD   |                | 2012002               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1970-11-17T18:00:00 | 2016-09-20T19:00:00 | 30.3303776 | -97.7235413 | 701            | 6203             | 2015               |                        |                           | 58164b9af9195edb2a5e3a0f | 
| LOC16-000030    | 7         | 5159639             |           | PRIMARY | 7                | BRENTWOOD ST    |              | 2011842             | 1          | 1         |              |          | LAMAR BLVD / BRENTWOOD ST    |                   | LAMAR BLVD   |                | 2011841               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1962-07-16T19:00:00 | 2016-09-20T19:00:00 | 30.3339996 | -97.7212448 | 801            | 6600             | 2017               |                        |                           | 58164b9af9195edb2a5e3a11 | 
| LOC16-000040    | 9         | 5159899             |           | PRIMARY | 4                | LAMAR BLVD      |              | 2011669             | 1          | 1         |              |          | AIRPORT BLVD / LAMAR BLVD    |                   | AIRPORT BLVD |                | 3257640               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1965-06-13T19:00:00 | 2016-09-20T19:00:00 | 30.3376293 | -97.7188721 | 7001           | 7001             | 2017               |                        | 8: LAMAR BLVD / JUSTIN LN | 58164b9af9195edb2a5e3a15 | 
| LOC16-000045    | 10        | 5159393             |           | PRIMARY | 4                | GUADALUPE ST    |              | 2012280             | 1          | 1         |              |          | KOENIG LN / GUADALUPE ST     |                   | KOENIG LN    |                | 2040437               |                 | TURNED_ON     | TRAFFIC     | Both        |                  |                     | 2016-09-20T19:00:00 | 30.3235016 | -97.7238312 | 5510           | 600              |                    |                        |                           | 5817c079e052e0422be6c408 | 
| LOC16-000050    | 11        | 5160009             |           | PRIMARY | 7                | ST JOHNS AVE    |              | 2011643             | 1          | 1         |              |          | LAMAR BLVD / ST JOHNS AVE    |                   | LAMAR BLVD   |                | 2011600               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1972-11-14T18:00:00 | 2016-09-20T19:00:00 | 30.339407  | -97.7178421 | 613            | 7200             | 2017               |                        |                           | 5817c079e052e0422be6c40a | 
| LOC16-000055    | 12        | 5158705             |           | PRIMARY | 7                | GROVER AVE      |              | 2012020             | 1          | 1         |              |          | KOENIG LN / GROVER AVE       |                   | KOENIG LN    |                | 2012021               |                 | TURNED_ON     | TRAFFIC     | Both        |                  | 1969-09-17T19:00:00 | 2016-09-20T19:00:00 | 30.3298817 | -97.7294846 | 5900           | 1200             | 2017               |                        |                           | 5817c079e052e0422be6c40c |