DBT Source: Crushing Facilities 2003 2022

File location: s3://trase-storage/brazil/logistics/jjhinrichsen/out/CRUSHING_FACILITIES_2003_2022.csv

DBT source: trase-storage-raw.crushing_facilities_2003_2022

Explore on Metabase: Full table; summary statistics

Explore dependencies/lineage: link

---

Description

Can be sourced from ABOIVE. Note that capacity is in metric tonnes per day.

---

Details

ColumnsData TestsReferenced ByDBT details

Column	Type	Description
YEAR	VARCHAR
COMPANY	VARCHAR
UF	VARCHAR
MUNICIPALITY	VARCHAR
GEOCODE	VARCHAR
CAPACITY	VARCHAR	Crushing capacity in metric tonnes per day
CAPACITY_SOURCE	VARCHAR
CNPJ	VARCHAR
LAT	VARCHAR
LONG	VARCHAR
RESOLUTION	VARCHAR

No data tests defined 🧐

Models

• m1_seipcs_brazil_soy_2018
• m2_6_1_seipcs_brazil_soy_2019
• m2_6_1_seipcs_brazil_soy_2020
• m2_6_1_seipcs_brazil_soy_2021
• m2_6_1_seipcs_brazil_soy_2022

• Dbt source path: memory.trase-storage-raw.crushing_facilities_2003_2022

• Source yml: trase/data_pipeline/models/_sources_trase_storage.yml

• Original dbt_docs