Arquitetura

%%{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
                

%%{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
                

%%{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