cityofaustin / atd-data-tech

Austin Transportation Data & Technology Services
17 stars 2 forks source link

[Enhancement] Identify signalized locations in the Vision Zero Database #12016

Open atdservicebot opened 1 year ago

atdservicebot commented 1 year ago

What application are you using?

Other / Not sure

Describe the problem.

We are requesting a way to identify signalized locations in the Vision Zero Database. We currently don't have a way to see what new traffic signals have been implemented and its association with existing Vision Zero polygons.

Describe the outcome you'd like to see when this feature is implemented.

We are requesting a new column be added to the Vision Zero Database's table: atd_txdot_locations. The value is generated from the intersection of the geometry in the locations table and points from the following GIS framework: https://austin.maps.arcgis.com/home/item.html?id=e6eb94d1e7cc45c2ac452af6ae6aa534

Describe any workarounds you currently have in place or alternative solutions you've considered.

Currently, we are using a SQL query of outdated locations to identify signalized locations.

Is there anything else we should know?

12/31/2023

Requested By Xavier A.

Request ID: DTS23-107125

patrickm02L commented 1 year ago

Related to #8322