View or edit on GitHub
This page is synchronized from trase/data/brazil/logistics/sicasq/out/sicasq_2026.ipynb. Last modified on 2026-06-21 06:35 CEST by GitHub Actions.
Please view or edit the original file there; changes should be reflected here after a midnight build (CET time),
or manually triggering it with a GitHub action (link).
from trase.tools.aws.aws_helpers import read_geojson
Description
The data below was downloaded from Ministério da Agricultura e Pecuária website and filtered for soy products.
- Soja
- Óleo de soja burto e demogago
- Farelo de soja
- Óleo de soja refinado
- Proteína de soja
- Lecitina de soja
PATH_INPUT = 'brazil/logistics/sicasq/out/SICASQ_2026.geojson'
PATH_SILOS = 'brazil/logistics/silos/silo_map_v3/silos_consolidated_capacity_brazil_2024_2.geojson'
Input Data
df_sicasq = read_geojson(key=PATH_INPUT, dtype={"cnpj": "string"})
df_silos = read_geojson(key=PATH_SILOS)
# Renaming sicasq geometry col
df_sicasq = df_sicasq.rename(columns={'geometry': 'geom'})
/Users/jailsonsoares/repos/TRASE/.venv/lib/python3.11/site-packages/pyogrio/raw.py:200: RuntimeWarning: driver GeoJSON does not support open option DTYPE
return ogr_read(
print('Total records',
df_sicasq.query('status == "Ativo"').shape[0]
)
print('Total records with coordinates',
df_sicasq[
(df_sicasq['latitude'].notna())
].shape[0]
)
print('Unique CNPJ',
df_sicasq[['cnpj']].drop_duplicates().shape[0]
)
Total records 2186
Total records with coordinates 1825
Unique CNPJ 2186
print('Total records per destination')
df_sicasq.groupby('destination')[['company']].count()
Total records per destination
| company | |
|---|---|
| destination | |
| BRAZIL | 544 |
| CHINA (MAINLAND) | 1535 |
| PANAMA | 1 |
| RUSSIAN FEDERATION | 106 |
print('Total records per combined products')
df_sicasq.groupby('product')[['company']].count()
Total records per combined products
| company | |
|---|---|
| product | |
| SOY LECITHIN, SOYBEAN CAKE, SOYBEAN OIL, SOYBEANS | 1 |
| SOY PROTEIN | 1 |
| SOY PROTEIN, SOYBEAN CAKE | 4 |
| SOY PROTEIN, SOYBEAN CAKE, SOYBEAN OIL | 1 |
| SOY PROTEIN, SOYBEAN CAKE, SOYBEAN OIL, SOYBEANS | 14 |
| SOY PROTEIN, SOYBEAN CAKE, SOYBEANS | 23 |
| SOY PROTEIN, SOYBEANS | 2 |
| SOYBEAN CAKE | 18 |
| SOYBEAN CAKE, SOYBEAN OIL | 19 |
| SOYBEAN CAKE, SOYBEAN OIL, SOYBEANS | 126 |
| SOYBEAN CAKE, SOYBEANS | 130 |
| SOYBEAN OIL | 43 |
| SOYBEAN OIL, SOYBEANS | 13 |
| SOYBEANS | 1791 |