# GridScope

A grid-intelligence platform that fuses three government data sources, the ERCOT interconnection queue, TCEQ air permits, and PUCT dockets, into one de-duplicated, geolocated view of 1,100+ Texas projects across ~12.7k historical snapshots. I led the backend. None of the three sources share an ID or a coordinate, so I built coordinate-free entity resolution using token-set Jaccard matching on name and county, tiered into resolved, review, and unresolved, plus two-tier geolocation from Census county centroids to exact EPA FRS coordinates so every project still got a map pin. I owned ingestion end to end: multi-sheet ERCOT .xlsx reports, the TCEQ Socrata API, and PUCT docket filings, normalized into snapshotted Postgres tables.

Context: Candid Intelligence Texas Grid Hackathon · Aug 2026

Built with FastAPI, Supabase/Postgres, MapLibre.


Author: Nayab Rehmat
Site: https://nayabdev.com/