The problem
Plant safety information, such as exits, shelters and safety equipment, existed only in old drawings and paper scans. The staff in/out calendar everyone relied on was old and hard to maintain.
What I did
- Built an interactive plant map as a single offline HTML file, with layers for exits, shelters, safety equipment and IT devices that can be switched on and off and printed. Layers were pulled out of old CAD prints by color, and a scanned safety map was aligned to the same coordinates.
- Added a place mode for positioning new devices on the map, and built a second site’s map from its plant layout drawing.
- Built a replacement in/out calendar in Flask and SQLite, imported about 3,400 existing events, and added a change log with restore and an API for a colleague’s automation jobs.
- Kept the old and new calendars in step with an hourly one-way merge while the final cutover is finished.
Outcome
Safety and IT share one plant map instead of separate drawings, and the new calendar is ready to take over from the old one.