What Inspired Us: The constant news of public infrastructure failures, such as collapsing bridges and deteriorating buildings, inspired us to create this project. We wanted to build a proactive solution that helps the government detect structural damages before they turn into disasters, ultimately saving public funds and human lives. How We Built It: We built this entire system using a powerful no-code/low-code stack. We utilized Airtable as our central database to store, organize, and track the structural health data of various buildings and bridges. To automate the entire workflow, we used Make.com, which connects our data sources, triggers early-warning alerts, and dispatches automated repair advisories to government authorities. Challenges We Faced: One of the biggest challenges was structuring the incoming satellite and monitoring data into a clean format inside Airtable. Additionally, designing a seamless, automated logic in Make.com that correctly triggers alerts based on damage severity—without causing false alarms—required a lot of trial and error. What We Learned: We learned how to leverage powerful automation tools like Make.com and flexible databases like Airtable to build a scalable, real-world solution without writing thousands of lines of code. We also gained deep insights into how data-driven predictive maintenance can revolutionize public infrastructure management.
Built With
- airtable
- make.com
- softr
Log in or sign up for Devpost to join the conversation.