| name | oce-load-cost-bases |
| description | Load national and market cost bases into OpenConstructionERP: the 8 national bases (Turkey Birim Fiyat, China Dinge, Brazil SINAPI, Spain BCCA, Italy Prezzario Toscana, Greece GGDE, Vietnam Dinh Muc, Indonesia AHSP), the 30 global markets, and 48 PPP market catalogs per base. Use when importing a cost database, repricing into a market, or troubleshooting a load. |
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.
