Welcome to map-dashboard Discussions!

[priyadam]

🧠 Step-by-Step Plan

1. Data Sources

You'll have four main data sources:

• Notion database: Structured or semi-structured data (e.g., lists of plants, animals, locations).
• Postgres database: More formal structured data (e.g., water volume measurements, lat/long coordinates).
• Meta’s Canopy Map: High-resolution canopy cover data (available via open datasets or APIs).
• Water Department Data: Typically shapefiles (SHP), CSVs, or GeoJSON about water bodies, volumes, water flow.

2. Architecture Summary

Component	Technology
Notion Database	Notion API
PostgreSQL Storage	Postgres + (PostGIS optional)
Water Data	Shapefiles / CSVs into Postgres
Canopy Data	Meta Canopy Map GeoTIFF/GeoJSON
Visualization	Tableau (Desktop/Server/Cloud)
Automation	GitHub Actions / Cron Jobs

3. Backend batches

• Script that syncs Notion to Postgres
• Prepare Spatial Data
• Load into Tableau

4. Frontend batches

• Build the Visualization