Arquitetura Geral

100%
%%{init: {'theme': 'dark'}}%%
flowchart TB

subgraph "User Layer"
    LANDING[datageoparana.github.io
Landing Page] VBP[VBP Parana
Valor Bruto Producao] DIARIOS[Precos Diarios
Cotacoes SIMA] FLORESTAIS[Precos Florestais
Serie 1997+] TERRAS[Precos de Terras
Serie 1998+] COMEX[ComexStat Parana
Comercio Exterior] EMPREGO[Emprego Agro
Vinculos Formais] CENSO[Censo Parana
Evolucao Demografica] CREDITO[Credito Rural
BCB/SICOR] end subgraph "Application Layer" REACT[React 18 + Vite
Tailwind CSS] RECHARTS[Recharts
Graficos Basicos] D3[D3.js
Graficos Avancados] LEAFLET[Leaflet
Mapas Interativos] FLASK[Flask API
REST + Forecast] end subgraph "Visualization Components" RADAR[RadarChart
Comparativo Top 5] SUNBURST[SunburstChart
Hierarquia Produtos] RIDGE[RidgelineChart
Distribuicao Anual] TREEMAP[TreemapChart
Proporcoes] CONNMAP[ConnectionMap
Fluxos Geograficos] SANKEY[SankeyChart
Fluxos Exportacao] LOLLIPOP[LollipopChart
Rankings] BUMP[BumpChart
Evolucao Rankings] PYRAMID[PyramidChart
Piramide Etaria] end subgraph "Processing Layer" DOWNLOAD[download_data.py
Coleta Arquivos] SCRAPER[scraper.py
Web Scraping] ETL[etl_process.py
Transformacao] PREPROCESS[preprocess_data.py
Geracao JSON] FORECAST[forecast.py
ML Predictions] PIPELINE[pipeline.py
Orquestrador] end subgraph "Data Sources" DERAL[DERAL/SEAB
VBP + Precos + Terras] SIMA[SIMA
Cotacoes Diarias] MDIC[ComexStat/MDIC
Exp/Imp Agricolas] MTE[RAIS/MTE
Emprego Formal] IBGE[IBGE
Malhas + Censos] SIDRA[API SIDRA
Censos 1991-2022] BCB[BCB/SICOR
Credito Rural] end subgraph "Data Storage" RAW[data/raw
ZIP/RAR/Excel] PROCESSED[data/processed
CSV + Parquet] JSON[public/data
JSON Otimizado] GEOJSON[GeoJSON
399 Municipios PR] end subgraph "Infrastructure" GHPAGES[GitHub Pages
Hosting Estatico] RENDER[Render
API + Cron Jobs] GHACTIONS[GitHub Actions
CI/CD Automatico] GAPPS[Google Apps Script
Analytics + Bug Report] CONTROLPANEL[Control Panel
Monitoramento] end LANDING --> VBP & DIARIOS & FLORESTAIS & TERRAS & COMEX & EMPREGO & CENSO & CREDITO VBP & DIARIOS & FLORESTAIS & TERRAS & COMEX & EMPREGO & CENSO & CREDITO --> REACT REACT --> RECHARTS & D3 & LEAFLET DIARIOS --> FLASK D3 --> RADAR & SUNBURST & RIDGE & TREEMAP & CONNMAP & SANKEY & LOLLIPOP & BUMP & PYRAMID FLASK --> PIPELINE REACT --> JSON LEAFLET --> GEOJSON PIPELINE --> DOWNLOAD & SCRAPER DOWNLOAD --> ETL SCRAPER --> ETL ETL --> PREPROCESS ETL --> FORECAST PREPROCESS --> JSON DOWNLOAD --> DERAL & SIMA & MDIC & MTE SCRAPER --> SIMA IBGE --> GEOJSON SIDRA --> CENSO BCB --> CREDITO DOWNLOAD --> RAW ETL --> PROCESSED JSON --> GHPAGES GEOJSON --> GHPAGES FLASK --> RENDER GHACTIONS --> GHPAGES GHACTIONS --> RENDER LANDING --> GAPPS GAPPS --> CONTROLPANEL
Scroll para zoom | Arraste para mover

Resumo das Camadas

Camada Componentes
User Layer Landing page + 8 dashboards (VBP, Precos Diarios, Florestais, Terras, ComexStat, Emprego, Censo, Credito Rural)
Application Layer React 18 Vite Tailwind CSS Recharts D3.js Leaflet Flask API
Visualization RadarChart, SunburstChart, RidgelineChart, TreemapChart, ConnectionMap, SankeyChart, LollipopChart, BumpChart, PyramidChart
Processing Layer Python ETL Pandas OpenPyXL Web Scraper ML Forecasting
Data Sources DERAL/SEAB, SIMA, ComexStat/MDIC, RAIS/MTE, IBGE, API SIDRA, BCB/SICOR
Data Storage JSON GeoJSON Parquet CSV
Infrastructure GitHub Pages Render GitHub Actions Google Apps Script

Dashboards

Dashboard Descricao Graficos D3
VBP Parana Valor Bruto da Producao Agropecuaria RadarChart, SunburstChart
Precos Diarios Cotacoes diarias SIMA com previsao ML RidgelineChart, CircularBarChart, LollipopChart
Precos Florestais Serie historica desde 1997 TreemapChart, LollipopChart
Precos de Terras Serie historica desde 1998 RadarChart, LollipopChart
ComexStat Parana Comercio exterior agricola ConnectionMap, SankeyChart, HeatmapChart
Emprego Agro Vinculos formais no agronegocio BumpChart, CircularBarChart, LollipopChart
Censo Parana Evolucao demografica 1991-2022 PyramidChart, PopulationMap
Credito Rural Financiamentos BCB/SICOR desde 2013 SankeyChart, BumpChart, TreemapChart, LollipopChart
Saude Parana Indicadores de saude publica DATASUS ChoroplethMap, PyramidChart, TreemapChart, SankeyChart

Fluxo de Filtros Interativos

100%
%%{init: {'theme': 'dark'}}%%
flowchart LR

subgraph "User Interaction"
    CLICK[Clique no Grafico]
    DROPDOWN[Filtros Dropdown]
end

subgraph "State Management"
    FILTERS[filters state]
    INTERACTIVE[interactiveFilters state]
    MERGED[mergedFilters]
end

subgraph "Data Processing"
    USEFILTERED[useFilteredData]
    USEAGG[useAggregations]
    FILTERED[filteredData]
end

subgraph "Visualization"
    CHARTS[Todos os Graficos
Recharts + D3] end CLICK --> INTERACTIVE DROPDOWN --> FILTERS FILTERS --> MERGED INTERACTIVE --> MERGED MERGED --> USEFILTERED USEFILTERED --> FILTERED FILTERED --> USEAGG USEAGG --> CHARTS FILTERED --> CHARTS
Scroll para zoom | Arraste para mover

Tracking e Analytics

100%
%%{init: {'theme': 'dark'}}%%
flowchart LR

subgraph "Dashboards"
    D1[VBP Parana]
    D2[Precos Diarios]
    D3[Precos Florestais]
    D4[Precos de Terras]
    D5[ComexStat]
    D6[Emprego Agro]
    D7[Censo Parana]
    D8[Credito Rural]
    D9[Portfolio]
end

subgraph "Google Apps Script"
    PROXY[Proxy Router]
    TRACKING[Tracking Unified]
end

subgraph "Google Sheets"
    S1[Sheet VBP]
    S2[Sheet Precos Diarios]
    S3[Sheet Florestais]
    S4[Sheet Terras]
    S5[Sheet ComexStat]
    S6[Sheet Emprego]
    S7[Sheet Censo]
    S8[Sheet Credito Rural]
    S9[Sheet Portfolio]
end

subgraph "Control Panel"
    CP[controlpanel
Visualizacao Unificada] end D1 & D2 & D3 & D4 & D5 & D6 & D7 & D8 & D9 --> PROXY PROXY --> TRACKING TRACKING --> S1 & S2 & S3 & S4 & S5 & S6 & S7 & S8 & S9 S1 & S2 & S3 & S4 & S5 & S6 & S7 & S8 & S9 --> CP
Scroll para zoom | Arraste para mover

Tecnologias Principais

Categoria Tecnologia Uso
Frontend React 18 SPA Framework
Build Vite Bundler + Dev Server
Styling Tailwind CSS Utility-first CSS
Charts Recharts Graficos basicos (Line, Bar, Area)
Advanced Charts D3.js Graficos customizados
Maps Leaflet Mapas interativos
Backend Flask API REST + ML
ML Prophet scikit-learn Forecasting
ETL Pandas OpenPyXL Processamento de dados
Hosting GitHub Pages Sites estaticos
API Hosting Render Flask API
CI/CD GitHub Actions Automacao
Analytics Google Apps Script Tracking LGPD-compliant