Connect prices with features to set build cost - Giswater/giswater_dbmodel GitHub Wiki

Mains

Giswater connects prices with feature elements through catalogs. Only the information related to dimensions (depth or length) is captured from feature. The rest of data comes from catalogs

Steps

1. Import prices into database.

You can use the import csv tool and the sample csv files \plugins\giswater\resources\example\csv\db_prices_* to import your first prices database Tables plan_price and plan_price_cat will be filled

2. Set currency

On config_param_system set parameter admin_currency

3. Connect prices with catalogs and set dimension values.

CAT_ARC

PRICES: [cost], [cost_unit], [m2bottom_cost], [m3protect_cost]

DIMENSION VALUES: [dext(mm-ws)(m-ud)], [z1(m)], [z2(m)], [width(m)], [area(m2)], [estimated_depth(m)], [bulk(mm)]

For more detail: cat_arc

CAT_NODE

PRICES: [cost], [cost_unit]

DIMENSION VALUES [estimated_depth(m)]

For more detail: cat_node

CAT_PAVEMENT

PRICES: [m2_cost]

DIMENSION VALUES: [thickness(m)]

For more detail: cat_pavement

CAT_SOIL

PRICES: [m3exc_cost], [m3fill_cost], [m3excess_cost], [m2trenchl_cost]

DIMENSION VALUES: [y_param(m/m)], [b(m)], [trenchlinning(%)]

For more detail: cat_soil

4. Check data

Check arcs have values on pavcat_id, soilcat_id and arccat_id

Check nodes have values on nodecat_id

Check connecs have links relateds and values on arc_id column

Hint:

To get more informatión you can take a look on example projects

5. Enjoy it!!!