SuperAPI AI Directory
Partner with us中文AI newsFavorites
Skillsoce-load-cost-bases

oce-load-cost-bases

Coding & development

View repository

Updated 10-15 20:33

About this skill

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)

  1. Pick a market card from GET /api/v1/costs/base-catalog (e.g. TR_NATIONAL:DE_BERLIN_de).
  2. The platform downloads the market's DDC_CWICR_DE_BERLIN_de_Catalog.csv (resources already PPP-repriced to EUR and translated to German).
  3. 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.