Structures and Asbestos Management App


I designed and built the SAM app to center on a list of all structures in Virginia and their currently known status of asbestos containing materials (ACM).
Users can search for bridges via a number of filters and quickly see relevant details. Selecting a structure displays further editable information in a set of CRUD forms. Further information is stored as “events.” Each structure has a one-to-many nested table relationship with events that allow multiple results, details, and documents to be stored for each record.
By-the-way there’s a story behind this one. Sometimes in the government, initiatives that are no-brainers get shoved under the rug. VDOT’s structure and bridge division had a regulatory need to keep track of asbestos in bridges. Yet, they continually trimmed it from their enterprise software requirements. Over the intervening decades, one rogue consultant armed with an access database made a listing of bridges and testing results for asbestos containing materials. While it started in one district, it  eventually covered the entire state.  After another project dropped its from their requirments, I was tasked with setting up requirements to add it into CEDAR for environmental HAZMAT. In the requirements process we determined we would need to get off the old access database based app ASAP, as it was no longer supported and crashed regularly. While waiting for the lengthy state funding and development process, I’ve created this as an intermediary stable system.  
The underlying data was extracted from a two seperate databases using custom coded python scripting. Lots of cleaning had to be employed to create standardized, validated, useable data.
In addtion, I wrote a web scraper to pull out old inventory attachments from a legacy system and then automatically associated them to the corresponding event.

*power apps, power automate, ms lists, and python used to create the app and underlying data structure

The CEDAR Log


Version 2.0 of the CEDAR Log is an app I created to help keep track of all the ongoing enhancement and bug tickets submitted by the Environmental Data Management team. It automatically prioritizes submissions based on their attributes and has useful links to related documents and IT ticket systems.

The original version was custom coded entirely using javascript! Eventually VDOT IT moved away from the hosting development environment, and I was forced to pivot to power apps instead.

*power apps, power automate, ms lists, and python used to create the app and underlying data structure