Background
This project analyzes data from the Cadastro Nacional de Produtores Orgânicos maintained by the Coordenação de Produção Orgânica (CPO/DTEC/SDA/MAPA). Brazil has seen significant growth in organic farming, but adoption varies widely across regions. This analysis identifies patterns and opportunities for expansion.
Goals
- Identify municipalities with highest concentration of organic farmers
- Analyze regional patterns in organic farming adoption
- Discover potential municipalities for organic farming expansion based on rural population and credit investment
Results
Top 5 Municipalities
Lago do Junco (MA), Brasilia (DF), Viamão (RS), São Sebastião da Boa Vista (PA), Tijucas do Sul (PR) lead in organic farmer concentration
Regional Cluster
South region shows highest density of organic farmers
Expansion Potential
Identified municipalities with high rural population and credit investment but low organic adoption
SQL Queries and Results
1. Municipalities with Significant Organic Farmers
SELECT
municipality,
state,
COUNT(*) AS organic_farmers
FROM organic_data
GROUP BY municipality, state
ORDER BY organic_farmers DESC
LIMIT 5;
| Municipality | State | Organic Farmers |
|---|---|---|
| Lago do Junco | MA | 709 |
| Brasilia | DF | 320 |
| Viamão | RS | 267 |
| São Sebastião da Boa Vista | PA | 259 |
| Tijucas do Sul | PR | 247 |
2. Organic Farming Penetration by Region
SELECT
state,
SUM(organic_farmers_count) AS total_organic_farmers,
((total_organic_farmers * 1000) / (sa.total_rural_pop)) AS penetration,
CASE
WHEN penetration_per_100_rural > 5 THEN 'Very High (>5%)'
WHEN penetration_per_100_rural > 2 THEN 'High (2-5%)'
WHEN penetration_per_100_rural > 1 THEN 'Medium (1-2%)'
WHEN penetration_per_100_rural > 0 THEN 'Low (<1%)'
ELSE 'None'
END AS penetration_category
FROM organic_data
FROM organic_data
GROUP BY state
ORDER BY penetration DESC
LIMIT 10;
| State | Total Organic Farmers | Penetration (%) | Category |
|---|---|---|---|
| PR | 4351 | 3.44 | High (2-5%) |
| DF | 320 | 3.22 | High (2-5%) |
| AP | 221 | 2.68 | High (2-5%) |
| RS | 3325 | 2.45 | High (2-5%) |
| RJ | 579 | 1.72 | Medium (1-2%) |
| SC | 1351 | 1.52 | Medium (1-2%) |
| PA | 2475 | 1.22 | Medium (1-2%) |
| AM | 820 | 1.21 | Medium (1-2%) |
| SP | 1672 | 1.18 | Medium (1-2%) |
| RN | 691 | 1.16 | Medium (1-2%) |
3. High-Potential Municipalities for Expansion
WITH high_potential_mun AS (
SELECT
md.municipality,
md.state,
md.organic_farmers_count,
md.agriculture_produced_values,
md.rural_credit_investment,
ROUND(
(LOG(md.agriculture_produced_values) * 0.3) +
(LOG(md.rural_credit_investment) * 0.2) +
(LOG(md.total_area_harvest) * 0.2) +
(1 - (md.organic_farmers_count / NULLIF(pm.avg_organic_farmers, 0)) * 0.3),
2
) AS potential_conversion_index
FROM md
CROSS JOIN production_metric pm
)
SELECT
RANK() OVER(ORDER BY hpm.potential_conversion_index DESC) AS potential_rank,
hpm.municipality,
hpm.state,
hpm.organic_farmers_count,
hpm.potential_conversion_index
FROM high_potential_mun hpm
WHERE
organic_farmers_count > 1
ORDER BY
potential_rank ASC
LIMIT 5;
| Municipality | UF | Conversion Potential Index |
|---|---|---|
| São Félix do Araguaia | MT | 5.94 |
| Ponta Porã | MS | 5.90 |
| Paracatu | MG | 5.88 |
| Sinop | MT | 5.83 |
| Ipameri | GO | 5.81 |
| Coromandel | MG | 5.78 |
| Bebedouro | SP | 5.75 |
| São Borja | RS | 5.75 |
| Araguari | MG | 5.74 |
| Santa Vitória do Palmar | RS | 5.73 |
Interactive Dashboard
Click to view interactive dashboard on Tableau Public