How it works
- The app takes a photo from a construction site and runs it through three Snowflake Cortex AI functions
- AI_FILTER checks whether the image actually shows a hazard worth flagging
- AI_CLASSIFY sorts the hazard into a category: missing PPE, unsafe scaffolding, blocked exits, and so on
- AI_COMPLETE writes a plain language explanation of the risk and suggests what to do about it
- Each site gets a running risk score out of 10, built from the history of flagged images at that location
- The dashboard shows which sites are trending worse over time, not just a single snapshot
- When a site crosses a risk threshold, the system sends an email automatically so the safety team finds out the same day instead of at a weekly review
- Users can export a full report as HTML or pull a checklist as CSV for site audits
Tech stack
Snowflake AI SQL
Streamlit
Python