search

cityofaustin / atd-data-tech

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

Add signalized intersection and signal engineer area attributes to crashes #18365

Open atdservicebot opened 1 month ago

atdservicebot commented 1 month ago

What application are you using?

Vision Zero Editor

Describe the problem.

Two sources of data can improve Vision Zero analyses significantly. (1) Traffic and Pedestrian Signals at https://austin.maps.arcgis.com/apps/mapviewer/index.html?layers=e6eb94d1e7cc45c2ac452af6ae6aa534 and (2) Transportation Signal Engineering Areas at https://austin.maps.arcgis.com/apps/mapviewer/index.html?layers=a5e9ead2ee7d49cca9bd7d64747730d2.

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

We ask that these two datasets be added as tables to the PostgreSQL database (atd_vz_data) to enable Vision Zero to stream data from them into SQL queries, geospatial queries, or geoprocessing.

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

We get the data into a local GIS project and convert the tables to be consumed in other platforms. Not all projects or requests are required to go through GIS. Therefore, having the data in the database is practical instead of having it as a feature layer.

Requested By Milad M.

Request ID: DTS24-116380

johnclary commented 1 month ago

This request is partly redundant to https://github.com/cityofaustin/atd-data-tech/issues/12016

xavierapostol commented 4 weeks ago

There are 2 parts to leveraging the Signal and Signal Engineer data. The are:

  1. This issue is to house the geospatial data (ArcGIS/AGOL process to the VZ Database as a table)
  2. Use this data in another issue (Enhancement: 12016 to request leveraging the table geometry to engineer an outcome in a specific field)