search

cityofaustin / atd-vz-data

The technology that powers the City of Austin's Vision Zero program
https://visionzero.austin.gov/viewer/
11 stars 2 forks source link

Add `id` column to crashes #1465

Closed johnclary closed 2 months ago

johnclary commented 2 months ago

This PR changes the primary key column of the crash tables to a serial id column, and it relegates the crash_id column to essentially any other CRIS column.

I have pointed this PR against https://github.com/cityofaustin/atd-vz-data/pull/1468 since that PR included some significant competing VZE changes.

Testing

  1. Start your data model stack and run the CRIS import as described in https://github.com/cityofaustin/atd-vz-data/pull/1440
  2. In the VZE, everything should work as expected. Search the crashes list, view crashes, edit crash attributes as well as unit and people attributes 👍