Deprecate the Crashmapping app

[nathankota]

Summary

DPS and UDOT have contracted with Numetric to present and interact with Utah vehicle collision summary data and information. Therefore, we no longer need to support the Utah Vehicle Collision application that was built and maintained by UGRC. Because many users have become accustomed to the crashmapping site over the years, DPS DTS has built a lightweight application to redirect to the Numetric solution. However, while the transfer of ownership of the crashmapping DNS occurs over the next couple of weeks, UGRC will do a temporary redirect from the UGRC crashmapping app to the Numetric app, after which DPS DTS will utilize the crashmapping DNS for their own redirect app.

• Application Name: Utah Vehicle Collisions (a.k.a Crashmapping)
• Application Url: crashmapping.utah.gov

This is the Numetric app UGRC will redirect to temporarily.

https://udps.numetric.net/utah-crash-summary#/

This is the app that DPS DTS built to handle the redirect once they take ownership of the crashmapping DNS.
http://dps-gov-utah-crashmapping.s3-website-us-west-2.amazonaws.com/

Action items

1. Assign a person who should complete the task by replacing name with their github @name.
2. Check [x] the box when the task is completed and add the date of completion.
3. Strike out all items that do not apply.

• Update relevant gis.utah.gov application pages (@steveoh, completed: 2021/09/22)
• Remove forklift pallet (@steveoh, completed: 2021/09/22)
• Remove application-specific Databases DDACTS (@nathankota & @MichaelAGRC , taken offline by dbase 2021/09/22, completed: 2021/10/01)
• AGRC Projects team drive folder (@nathankota, completed: 2021/09/22)

Is there a website?

• Remove DNS entry (name, completed: 2021/00/00)
• Archive source code repositories (@steveoh, completed: 2021/09/22)
• Transfer DNS to DPS - INC1540589 (@nathankota, completed 2021/09/28)
• Release the crashmapping.dev.utah.gov DNS - INC1540608 (@nathankota, completed 2021/09/23)
• Remove cloud infrastructure (@steveoh, completed 2021/10/05)
• Remove SFTP storage and users - INC1540618 (@nathankota, completed 2021/09/22)

Choose one.

• Remove from the web server (name, completed: 2021/00/00)
• Replace app with a static page with information (name, completed: 2021/00/00)
• Redirect somewhere else (@steveoh, completed: 2021/09/22)

Is there a map service?

• Stop (name, completed: 2021/00/00)
• Delete (@steveoh, completed: 2021/09/22)

Is there a forklift pallet?

• Remove repo (@steveoh, completed: 2021/09/22)
• Remove stale data from forklift hashing and receiving (@steveoh, completed: 2021/00/00)
• Remove row from data/hashed/changedetection.gdb/TableHashes (@steveoh, completed: 2021/00/00)

Are there service dependencies?

• Validate that the web api does not query it (@steveoh, completed: 2021/09/22)
• Validate that AGRC or applications widgets do not reference it (@steveoh, completed: 2021/09/22)

Notification

• Twitter (@steveoh)

Group Task Assignments

1. Check [x] the box when you have assigned all the tasks relevant to your group.

• Data Team (@gregbunce)
• Dev Team (@steveoh)
• Cadastre Team (@rkelson)

[steveoh]

Thanks @nathankota, I triaged and assigned you a few tasks. There is a test and prod db in our clusters.

Is the 30 day redirect going to be documented here or is that unnecesary?

[steveoh]

Here's my audit log

• archived https://github.com/agrc/crash-db and https://github.com/agrc/crash-web.
• removed the pallet from the forklift config and deleted it from the warehouse.
• merged the pr to remove the app from our website
• deleted the map services
• set up redirect pages in firebase hosting.
• removed the google drive folder that had the data downloads
• deleted all the cloud infrastructure except the firebase hosting
• deleted google analyitcs property

[github-actions]

@steveoh set a reminder for 10/22/2021

[steveoh]

@nathankota you can release the crashmapping.dev.utah.gov DNS

[steveoh]

greetings! I double-checked with Michael and dbase yesterday about DDACTs database and neither knew of or found a test database, but production db has been removed, so you should be able to proceed with crashmapping cloud infrastructure removal at your convenience - even if you want to before your 2021/10/22 reminder. Totally up to you. #155

[steveoh]

ok this is done.