View or edit on GitHub
This page is synchronized from trase/models/peru/gold/TODO.md. Last modified on 2025-12-10 18:30 CET by Trase Admin.
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).
- Output a CSV for analysis
-
Look at the pattern of demand in the artisinal volume: in particular the demand per department, per company, and number of mining assets / area of mining assets
-
Grams to troy-ounces
-
Switch to provinces in assets Department > Province > District
-
Issues with some rows that have province but no district, and vice-versa
E.g. department geocode and name there but nothing else, province mentioned by name
YEAR 2018
NAME COMPANIA MINERA CONDESTABLE S.A.
ASSET_TYPE SMELTER
CAP_KG_DAY 7400000
AREA_HA 188.42
GEOCODE_DEP 15
GEOCODE_PROV NA
GEOCODE_DIST NA
DEPARTMENT LIMA
PROVINCE CANETE
DISTRICT MALA
June 11th - Switch to correct customs data
Total vol_raw = 168723.47998999144 status == SOLVED: 88,698.7 (52.57%) status == UNKNOWN: 80,024.8 (47.43%)
Total vol_raw = 168723.47998999144 branch == None: 77,640.5 (46.02%) branch == 1.1 - Source from production in single province : 50,958.7 (30.2%) branch == 1.2 - Source from production in multiple provinces (also smelts elsewhere): 15,847.6 (9.39%) branch == 1.2 - Source from production in multiple provinces : 13,044.8 (7.73%) branch == 1.1 - Source from production in single province (also smelts elsewhere): 8,847.6 (5.24%) branch == 1.3 - Demand exceeds production: 2,384.4 (1.41%)
What do the multi-level values in the asset lists mean?
August 4th 2020
-
How much of this demand could be covered by the production records? -> Deal with artisinal mines first -> In three provinces we can take this from the production records -> Can they be deemed to be artisinal?
-
Will eventually get to the point where we add production because
# Assumptions and DT - September 2nd 2020
# September 10th 2020
sum percentage
status
SOLVED 98,000 58%
UNKNOWN 71,000 42%
sum percentage
branch
UNKNOWN 66,000 39%
1.1 - official production / single province 60,000 35%
1.2 - official production / multiple provinces 29,000 17%
1.2 - Artisinal 8,900 5%
UNKNOWN - 1.2.3 - Artisinal / processing operat... 1,600 1%
UNKNOWN - 1.3 - official production / excess de... 1,500 1%
UNKNOWN - 1.2.1 - Artisinal / some non-artisina... 950 1%
UNKNOWN - 1.2.4 - Artisinal / excess demand 780 0%
UNKNOWN - 1.2.2 - Artisinal / more than one dep... 76 0%
- We have a large amount of companies exporting gold
- We have some remaining volumes in the offical production records, linked to companoes
- None of the exporting companies are in the official production records
- The exporting companies have assets (mines/trading posts/smelters)
- The question is who gets preferential access to the production records (and in which province)
-
If a company has one or more mining asset(s) but is not in the official production records, they should go to the back of the queue, under the logic that if they were operating legitimately, their volume would have been in the official records
-
Source from offical production records via "offical" route (tax IDs and artisinal)
-
Sourcing from offical production records via trading assets (excluding big miners as per above)
-
Add to production via assets
Early Septemner
sum percentage
status
SOLVED 99,000 58%
UNKNOWN 70,000 42%
sum percentage
branch
1.1 - official production / single province 60,000 35%
UNKNOWN 48,000 29%
1.2 - official production / multiple provinces 29,000 17%
UNKNOWN - 2.1 - Traded with offical production ... 15,000 9%
1.2 - Artisinal 6,600 4%
2.1 - Traded with offical production 3,300 2%
UNKNOWN - 1.2.4 - Artisinal / excess demand 3,100 2%
UNKNOWN - 1.2.3 - Artisinal / processing operat... 1,600 1%
UNKNOWN - 1.3 - official production / excess de... 1,400 1%
UNKNOWN - 1.2.1 - Artisinal / some non-artisina... 950 1%
UNKNOWN - 1.2.2 - Artisinal / more than one dep... 76 0%
September 21st 2020 (after clustering provinces)
sum percentage
status
SOLVED 110,000 62%
UNKNOWN 63,000 38%
sum percentage
branch
1.1 - official production / single province 60,000 35%
UNKNOWN 48,000 29%
1.2 - official production / multiple provinces 29,000 17%
2.1 - Traded with offical production 10,000 6%
UNKNOWN - 2.1 - Traded with offical production ... 7,900 5%
1.2 - Artisinal 6,600 4%
UNKNOWN - 1.2.4 - Artisinal / excess demand 3,100 2%
UNKNOWN - 1.2.3 - Artisinal / processing operat... 1,600 1%
UNKNOWN - 1.3 - official production / excess de... 1,400 1%
UNKNOWN - 1.2.1 - Artisinal / some non-artisina... 950 1%
UNKNOWN - 1.2.2 - Artisinal / more than one dep... 76 0%