Case Study · Geospatial

Public Works Platform

Geospatial visualization system

Alejandro Mendoza
March 20265 min

React + Vite

public SPA

MapLibre + PostGIS

geospatial core

Supabase

auth, data and storage

Public Works Platform

Public transparency needs architecture, not only dashboards.

Public web platform to communicate public works in Jujuy: interactive map, work detail pages, citizen participation, verification, and content administration.

Problem#

Without a unified territorial view, works tracking becomes opaque and fragmented. Data exists, but not in an interface suitable for decisions and traceability.

Solution#

I implemented an end-to-end system where map → detail page → immersive view → participation connects public transparency, internal operations, and citizen control in one experience.

How it works#

●

SPA built with React + Vite and client-side routing.

●

Data delivered from Supabase (PostgreSQL, Auth, RLS, and Storage).

●

Interactive map with works layers, filters, and search.

●

360 experience with fallback for low-end devices.

●

Admin panel for works CRUD and publication control.

Core technical stack#

●

Frontend: React 18, TypeScript, Vite, Tailwind, shadcn/ui, Framer Motion.

●

Mapping: MapLibre GL + supercluster.

●

Backend as a Service: Supabase (Auth, DB, Storage, RLS).

●

State/data: React Query + custom hooks.

●

UI/UX: mobile-first approach and reusable components.

Platform modules#

●

Institutional landing page.

●

Works map (/obras): filters, search, list, and map.

●

Work detail page (/obra/:id): details, budget, status, geolocation, and 360 CTA.

●

Immersive 360 view with compatibility mode for modest devices.

●

Participation (/participacion): citizen forms.

●

Verification (/verificacion): citizen validation and control.

●

Admin (/admin): CRUD, publication, and works management.

●

Auth (/auth): login and role handling.

Integrations#

●

Supabase Auth for login and roles.

●

Supabase DB for works, participation, verification, and profiles.

●

Supabase Storage for images and assets.

●

MapLibre for interactive geospatial visualization.

Technical strengths#

Modular, scalable architecture by feature, map clustering and search, robust 360 fallback for low-end devices, role + RLS security, and production-grade end-to-end flows.

Product strengths#

Public works transparency, evidence-based citizen interaction (participation and verification), clear geospatial communication, and an immersive experience that differentiates the platform.

If you are hiring for geospatial projects with real impact, I am interested in joining.

I can contribute across architecture design, implementation, and production rollout of territorial platforms.

Alejandro Mendoza

Alejandro Mendoza

Software Engineer · Systems Builder · AI Developer

Builds digital systems and products by integrating backend, frontend, data and artificial intelligence. Focused on creating complete, scalable platforms applied to real-world problems.

More about the author →
© 2026 Alejandro Mendoza. All rights reserved.|Privacy