Load Cost Bases into OpenConstructionERP

The catalog of bases (2026)

National bases ship a 95-column parquet each plus 26 language editions and a markets/ folder of 48 PPP-repriced resource catalogs.

Region id	Base	Positions	Currency	Priced?
`TR_NATIONAL`	Turkey (Birim Fiyat, ÇŞB+10 institutions)	22,704	TRY	yes
`ZH_CHINA`	China (Beijing Dinge + Bole 2022)	11,312	CNY	yes
`BR_NATIONAL`	Brazil (SINAPI, CAIXA/IBGE)	9,723	BRL	yes
`ES_ANDALUCIA`	Spain (BCCA 2023, Andalucía)	6,453	EUR	yes
`IT_TOSCANA`	Italy (Prezzario Regione Toscana 2026)	5,836	EUR	yes
`VN_NATIONAL`	Vietnam (Dinh Muc, TT 12/2021)	4,299	VND	coefficient (rate 0)
`ID_NATIONAL`	Indonesia (AHSP, Permen PUPR)	2,784	IDR	coefficient (rate 0)
`GR_NATIONAL`	Greece (GGDE)	2,647	EUR	partly

Plus the flagship global base: 30 markets under CIS-Russia-GESN-FER-TER (USA_USD, DE_BERLIN, RU_STPETERSBURG, …).

Load a base (API)

POST /api/v1/costs/load-cwicr/TR_NATIONAL

Reads the parquet (local WORLD_COST_BASES, cache, bundled dir, then GitHub download fallback).
Groups rows by rate_code (one row per work item, components[] inline).
Idempotent on (code, region): second call → {"status": "already_loaded", ...}.
After load, the backend swaps the region's text to the base's home language parquet (TR___DDC_CWICR/TR_tr_...), so a Turkish user sees Turkish.

Verify the load

GET /api/v1/costs/regions/stats/      # item count per region
GET /api/v1/costs/?region=TR_NATIONAL&limit=5   # check currency and descriptions
GET /api/v1/costs/{id}                # components[] = labour/material/machine lines
GET /api/v1/costs/category-tree/?region=TR_NATIONAL

Import the resource catalog

POST /api/v1/catalog/import/TR_NATIONAL

Reads DDC_CWICR_TR_Catalog.csv (resource_code, name, type, category, unit, price_avg, price_min, price_max, currency, usage_count + parent_* classification preserved in specifications).

Reprice a base into a market (PPP)

Pick a market card from GET /api/v1/costs/base-catalog (e.g. TR_NATIONAL:DE_BERLIN_de).
The platform downloads the market's DDC_CWICR_DE_BERLIN_de_Catalog.csv (resources already PPP-repriced to EUR and translated to German).
It re-prices the base region's resource price sheet in place — text follows the language, price follows the market.

Troubleshooting

404 "not found" → no local parquet and GitHub download failed; check ~/.openestimator/cache/{db_id}.parquet and network.
Empty currency → region missing from the currency map; add it to cwicr_v3_catalogue.py / _REGION_CURRENCY.
Coefficient base shows rate 0 → expected for VN/ID; seed prices via ResourcePriceService.seed_region.
Duplicate rows → importer collapses by (code, region); multiple price layers per code keep the first.

oce-load-cost-bases