Skip to content
Gabriel Catimbang
All projects

Project Bedrock

Drop a pin anywhere in Naga City and get a property report: flood, earthquake and landslide risk, terrain, access and an AI-written summary, ready as a PDF.

Year
2026
Role
Solo
Type
Product
Built with
TanStack Start, PostGIS, Prisma, AWS Lightsail, MapLibre, Gemini, Clerk
Live project-bedrock-wheat.vercel.app

The code is private.

Project Bedrock, a screenshot of the live site.

What I built

  • A spatial database on PostgreSQL and PostGIS, hosted on AWS Lightsail and queried through Prisma.
  • Data pipelines that pull UP NOAH 10 m LiDAR flood depths, PHIVOLCS fault lines, USGS earthquakes since 1970 and OpenStreetMap.
  • A map on MapLibre where the pin and the report stay in step.
  • A summary written by Gemini 2.5 Flash, and a downloadable PDF report.
  • A free snapshot for everyone, with the full report behind Clerk sign-in.