This is a submission for the DEV Weekend Challenge: Community The Community This app was built for the citizens of San José Pinula, a municipality in Guatemala, and designed to scale to any municipality in my country …

Sichere Programmierung dev.to 28.02.2026, 10:34 Uhr 4 Min. Lesezeit KRITIS / Energie Gov & Defense Cloud & IT-Enterprise

↗ Quelle (dev.to)

Reagiere als Erste:r — dein Feedback zählt!

STANDARD — Regulärer Patch-Zyklus ~5 Min. (775 W.)

Deep Tech

CiudadActiva - Bridging the gap between citizens and their Municipality (government)

Angriffsfläche

PostgreSQL / MySQL

Exploit-Status

Geringe Ausnutzungswahrscheinlichkeit / Keine aktiven Kampagnen

Sofortmaßnahme

Asset-Inventar prüfen & Upstream-Advisory überwachen

This is a submission for the DEV Weekend Challenge: Community

The Community

This app was built for the citizens of San José Pinula, a municipality in Guatemala, and designed to scale to any municipality in my country (Guatemala).

San José Pinula is a growing urban area where residents face daily infrastructure problems like potholes that damage vehicles, broken streetlights that create unsafe conditions at night, water leaks that waste resources, and uncollected trash, among others. The real problem isn't that these issues exist, it's that there's no structured, accessible way for citizens to report them to local authorities.

Reports get lost in WhatsApp groups. Photos get buried in Facebook comments. The municipality has no centralized visibility into what problems exist, where, or how many people are affected. Problems go unaddressed for months (even years).

CiudadActiva was built for this community, giving every neighbor a direct, visual channel to communicate with their municipality, and giving the municipality a real-time dashboard to manage and respond.

What I Built

CiudadActiva is a mobile-first civic reporting web app with two sides:

For Citizens

Submit a report with a photo or video, problem category, and exact GPS location (or tap on the map)

Browse all reports on a public interactive map with color-coded markers by category

Tap "This affects me too" to show community support for existing reports

Share any report directly to social media or copy the link

No account required, anonymous reporting is fully supported

For the Municipality

Admin dashboard with all reports, filterable by municipality and status

Change report status: Pending -> In Progress -> Resolved

Stats panel: total reports, pending, in progress, resolved

Platform

Multi-municipality support, built with municipality_id on every record from day one. Currently includes San José Pinula, Mixco, Fraijanes, Santa Catarina Pinula, Villa Canales, Villa Nueva, and Guatemala City.

Fully responsive, mobile-first UI with direct camera access on smartphones

Row Level Security is enforced at the database level via Supabase

Demo

Live app: https://ciudad-activa-gt.vercel.app

Code

ZarakiLancelot
/
ciudad-activa

Civic reporting app for municipalities in Guatemala — citizens report urban issues with photos, geolocation and community support.

CiudadActiva 🏙️

🇪🇸 Leer en Español / Read in Spanish

A civic reporting platform that empowers citizens to report urban problems directly to their municipality — with photos, exact location, and community support.

Built for the DEV Weekend Challenge 🏆

🌎 The Problem

In municipalities like San José Pinula, Guatemala, citizens have no efficient way to report urban issues (potholes, broken streetlights, water leaks, etc.) to local authorities. Reports get lost in WhatsApp groups or never reach the right people. Problems go unfixed for months.

CiudadActiva bridges that gap — giving every citizen a direct, visual, geolocated channel to communicate with their municipality, and giving municipalities a real-time dashboard to manage and respond to issues.

✨ Features

For Citizens

📍 Report issues with photo/video, category, and exact GPS location

🗺️ View all reports on an interactive public map

❤️ "This affects me too" — support existing reports with one tap

View on GitHub

How I Built It

Tech Stack

Layer	Technology
Frontend	React 18 + TypeScript + Vite
Routing	React Router v7
Backend	Supabase (Auth, PostgreSQL, Storage)
Maps	Leaflet.js + React Leaflet + OpenStreetMap
Hosting	Vercel

Why Supabase as the entire backend

The biggest architectural decision was to eliminate a custom Node.js backend. Supabase gave me everything I needed out of the box:

Anonymous Auth: citizens can report without creating an account

Row Level Security: public read, auth-only write, admin-only updates

Storage: photo and video uploads with public URLs

Auto-generated REST API: no endpoints to write

This let me focus 100% of my weekend on the product, not infrastructure.

Maps without Google

Using Leaflet.js + OpenStreetMap kept the project fully free with no API keys required for maps. I also used Nominatim (OpenStreetMap's geocoding API) for reverse geocoding, automatically converting GPS coordinates into human-readable addresses.

Mobile-first camera access

On mobile, the report form offers two options for media: upload from the gallery or open the camera directly. This is handled with a capture="environment" attribute on a hidden file input, triggered via useRef for reliable behavior across iOS and Android browsers.

Multi-municipality from day one

Even though this is a pilot for San José Pinula, every table has a municipality_id column. Switching municipalities on the map filters reports and re-centers to the correct coordinates, with each municipality's official logo appearing in the loading spinner.

What I'd build next

Push notifications when a report status changes

Municipality analytics dashboard with charts

PWA with offline support

Duplicate detection by GPS proximity

Self-service municipality onboarding

Thanks for this opportunity!

1. Sofort-Triage & Abwehrmaßnahmen

IR-PLAYBOOK-RCEHIGH

Schritte anzeigen

SOC Incident Playbook: Remote Code Execution (RCE) Defense

WAF MitigationSofort

Virtuelles Patchen am Reverse Proxy / WAF für gefährdete URL-Pfade und Payloads aktivieren.

SecRule REQUEST_URI "@rx ..." "id:1001,phase:1,deny,status:403"

Web Shell ScanSofort

Web-Root auf neu angelegte Scripts, anomal modifizierte Dateien und Persistence scannen.

find /var/www -type f -name "*.php" -mmin -120

Outbound FilteringSofort

Ausgehenden Datenverkehr (Reverse Shells zu unbekannten IPs/Ports) blockieren.

ss -tunp | grep -E ":(4444|1337|8080|9001)"

Vendor Patching

Hersteller-Update in Staging validieren und schnellstmöglich in Produktion ausrollen.

apt update && apt --only-upgrade install <pkg>

1-Click Detection Engineering: Multi-Dialect SIEM Rules5 Formate

Regeln anzeigen

Syntax validiert (0 Fehler)

title: Detect Exploitation - CiudadActiva - Bridging the gap between citizens and their Municipality (government)
id: abc67429-0099-4d44-aa9b-cf0924f24cc8
status: experimental
description: Automatisch generierte SIEM-Erkennungsregel basierend auf CTI Intelligence
references:
  - https://tsecurity.de/
author: iShareStuff CTI Automated Detection Engine
date: 2026-09-25
logsource:
  category: network_connection
  product: any
detection:
  selection:
      CommandLine|contains:
        - 'exploit'
  condition: selection
falsepositives:
  - Legitime administrative Zugriffe oder Penetrationstests
level: high
tags:
  - attack.initial_access

Syntax validiert (0 Fehler)

rule CTI_Threat_Indicator {
    meta:
        author = "iShareStuff CTI Automated Detection Engine"
        date = "2026-09-25"
        description = "YARA Signature for "
    strings:
        $str = "CiudadActiva - Bridging the ga" ascii wide
    condition:
        any of them
}

Syntax validiert (0 Fehler)

index=security sourcetype IN ("cisco:asa", "pan:traffic", "zeek_conn", "suricata", "WinEventLog:Security")
("CiudadActiva - Bridging the gap between ")
| stats count earliest(_time) as first_seen latest(_time) as last_seen by src_ip, dest_ip, dest_host, signature
| eval first_seen=strftime(first_seen, "%Y-%m-%d %H:%M:%S"), last_seen=strftime(last_seen, "%Y-%m-%d %H:%M:%S")
| sort - count

Syntax validiert (0 Fehler)

message: "*CiudadActiva - Bridging the gap between *"

Syntax validiert (0 Fehler)

CommonSecurityLog
| where Message has "CiudadActiva - Bridging the gap between "
| summarize EventCount = count(), FirstSeen = min(TimeGenerated), LastSeen = max(TimeGenerated) by SourceIP, DestinationIP, DestinationPort, Activity
| extend DetectionRule = "iShareStuff-CTI-Compiled"
| sort by EventCount desc

2. Cyber Threat Intelligence & Forensik

CTI Threat Relationship Graph3 Knoten / 2 Relationen

CVE / Incident Software MITRE ATT&CK CWE Weakness IoC

🎯

MITRE ATT&CK Matrix Navigator 14 Taktiken

Reconnaissance

Resource Development

Initial Access

Execution

Persistence

Privilege Escalation

Defense Evasion

Credential Access

Discovery

Lateral Movement

Collection

Command and Control

Exfiltration

Impact

💡 Tipp: Klicken Sie auf eine TTP, um Gegenmaßnahmen und SIEM-Erkennungsregeln anzuzeigen.Enterprise Matrix v14.1

🚀 Auf tsecurity.de entdecken

◀ VORHERIGER BEITRAG 1 Min

CVE-2026-2634 | Mozilla Firefox up to 147.3 on iOS Web Contents clickjacking

Sicherheitslücken (CVE)

NÄCHSTER BEITRAG 1 Min

Durch diesen Effekt wird die Rente im März bei vielen geringer ausfallen

IT NachrichtenWeiterlesen ▶

Blättern: Pfeiltasten [ ← ] [ → ] · Tasten j / k · mobil: Wischen

Fokus-Vektor:

Kognitive Analyse für identifizierte Bedrohung: Erhöhte Bedrohungslage im Bereich CiudadActiva - Bridging the gap between .... Basierend auf 368k Vektor-Korrelationen werden sofortige Isolationsmaßnahmen für betroffene Endpunkte empfohlen.

🛡️ Angriffsfläche & Exposure

Netzwerk/Remote-Zugriff ohne Vorauthentifizierung möglich.

⚡ Empfohlene Sofortmaßnahmen

1. Perimeter-Inspektion: Relevante Portfreigaben und exponierte Endpunkte unverzüglich scannen.
2. Patch-Applikation: Hersteller-Hotfix einspielen oder betroffene Daemons in isolierte DMZ-Segmente überführen.
3. Telemetrie & EDR-Alerts: Prozessaufrufe und Child-Processes auf anomale Shell-Spawns überwachen.

🔗 Semantisch verwandte Zero-Days MariaDB 11.7 VEC

Schnell-Prompts für Analysten

⚠️ DEFANGED SANDBOX VIEW (tsecurity.de): Alle Netzwerkindikatoren und URLs wurden neutralisiert (2 Indikatoren entschärft). Nur zur defensiven Analyse!

Format: python

#!/usr/bin/env python3
# Exploit Title: PoC for Target
import socket, sys
target = '192[.]168[.]1[.]10'
url = 'hxxp://target[.]local/vuln'
s = socket.socket()
s.connect((target, 80))
s.send(b'GET / HTTP/1.1\r\nHost: target.local\r\n\r\n')

Auch interessante Nachrichten CiudadActiva - Bridging the gap between citizens and their Municipality (government)

Thematisch verwandte Begriffe: CiudadActiva, Bridging, between, citizens · 6 Treffer

IT Nachrichten heise online News

Missing Link: OSINT-Aktivismus bis Korkenzieher-Ballett auf der Ars Electronica

vor 4 Tagen 📆 20.09.2026 um 08:16 Uhr

Weiterlesen ↗

IT Security Video Chaos Computer Club - last 1

Digital Fight Club: Kann ein Algorithmus Brücken bauen? (DS2026)

vor 5 Tagen 📆 18.09.2026 um 00:00 Uhr

Weiterlesen ↗

IT Security Nachrichten The CyberWire

Defending Space as Critical Infrastructure.

vor 4 Tagen 📆 20.09.2026 um 07:00 Uhr

Weiterlesen ↗

Sichere Programmierung DEV Community

I’m building a tool to discover who holds your personal data (and delete it) 🛠️

vor 5 Tagen 📆 20.09.2026 um 00:21 Uhr

Weiterlesen ↗

Sichere Programmierung DEV Community

Edge Computing in Practice: Lowering Latency with Cloudflare Workers

vor 4 Tagen 📆 20.09.2026 um 07:23 Uhr

Weiterlesen ↗

Sichere Programmierung DEV Community

From KEV to Exposure: Mapping the September 2026 Batch to Measurable Services

vor 5 Tagen 📆 20.09.2026 um 00:40 Uhr

Weiterlesen ↗

Videos werden geladen ...

Beiträge werden geladen ...

Videos werden geladen ...

Beiträge werden geladen ...

Videos werden geladen ...

Beiträge werden geladen ...

Videos werden geladen ...

Beiträge werden geladen ...

Videos werden geladen ...

🚀 Auf tsecurity.de entdecken

Kommentare über CiudadActiva - Bridging the gap between citizens and their Municipality (government)

💬 Social News Network

Community Debatte 0 Beiträge

Tags:Noch keine Tags.

Noch keine Diskussion eröffnet

Sei der Erste, der seine Einschätzung oder PoC zu diesem Thema teilt.

🚀 Auf tsecurity.de entdecken

Echtzeit-Radar & Feeds

👥 Community & Social

🕒 tsecurity.de Such-Trends & Chronologie

CiudadActiva - Bridging the gap between citizens and their Municipality (government)

The Community

What I Built

For Citizens

For the Municipality

Platform

Demo

Code

ZarakiLancelot
/
ciudad-activa

Civic reporting app for municipalities in Guatemala — citizens report urban issues with photos, geolocation and community support.

CiudadActiva 🏙️

🌎 The Problem

✨ Features

For Citizens

How I Built It

Tech Stack

Why Supabase as the entire backend

Maps without Google

Mobile-first camera access

Multi-municipality from day one

1. Sofort-Triage & Abwehrmaßnahmen

SOC Incident Playbook: Remote Code Execution (RCE) Defense

2. Cyber Threat Intelligence & Forensik

MITRE ATT&CK Matrix Navigator 14 Taktiken

tsecurity.de Cognitive Threat RAG

Auch interessante Nachrichten CiudadActiva - Bridging the gap between citizens and their Municipality (government)

Missing Link: OSINT-Aktivismus bis Korkenzieher-Ballett auf der Ars Electronica

Digital Fight Club: Kann ein Algorithmus Brücken bauen? (DS2026)

Defending Space as Critical Infrastructure.

I’m building a tool to discover who holds your personal data (and delete it) 🛠️

Edge Computing in Practice: Lowering Latency with Cloudflare Workers

From KEV to Exposure: Mapping the September 2026 Batch to Measurable Services

tsecurity.de Live Threat Radar

Community-Puls — was gerade passiert

Aktivitäten deiner Analysten

Neues Thema oder Eilmeldung einreichen

Heiß diskutierte Einreichungen

tsecurity.de LIVE

Echtzeit-Radar & Feeds

👥 Community & Social

CiudadActiva - Bridging the gap between citizens and their Municipality (government)

The Community

What I Built

For Citizens

For the Municipality

Platform

Demo

Code

ZarakiLancelot / ciudad-activa

Civic reporting app for municipalities in Guatemala — citizens report urban issues with photos, geolocation and community support.

CiudadActiva 🏙️

🌎 The Problem

✨ Features

For Citizens

How I Built It

Tech Stack

Why Supabase as the entire backend

Maps without Google

Mobile-first camera access

Multi-municipality from day one

1. Sofort-Triage & Abwehrmaßnahmen

SOC Incident Playbook: Remote Code Execution (RCE) Defense

2. Cyber Threat Intelligence & Forensik

MITRE ATT&CK Matrix Navigator 14 Taktiken

Mehr aus dieser Kategorie

tsecurity.de Cognitive Threat RAG

Auch interessante Nachrichten CiudadActiva - Bridging the gap between citizens and their Municipality (government)

Missing Link: OSINT-Aktivismus bis Korkenzieher-Ballett auf der Ars Electronica

Digital Fight Club: Kann ein Algorithmus Brücken bauen? (DS2026)

Defending Space as Critical Infrastructure.

I’m building a tool to discover who holds your personal data (and delete it) 🛠️

Edge Computing in Practice: Lowering Latency with Cloudflare Workers

From KEV to Exposure: Mapping the September 2026 Batch to Measurable Services

tsecurity.de App

Themen-Radar & Intelligence Matrix

tsecurity.de Live Threat Radar

Community Radar & Live Chat

Community-Puls — was gerade passiert

Aktivitäten deiner Analysten

Neues Thema oder Eilmeldung einreichen

Heiß diskutierte Einreichungen Aktualisieren

🔖 Gespeicherte Artikel

ZarakiLancelot
/
ciudad-activa

Heiß diskutierte Einreichungen