Importing asset data
During the import process, if your .inp file includes no projections and you haven’t imported GIS files, Q will help you select the most accurate one among various possible options.
If projections are present in your .inp file, Qatium detects them when they have the following variables:
- Q_VAR_PROJECTION to specify the EPSG code
- Q_VAR_PRJ to specify the .prj file content
Naming asset IDs
You can provide IDs to your assets and Qatium will do its best to maintain them, as long as they meet certain conditions.
Asset IDs must:
- include up to 31 valid characters
All characters are considered valid, including space, tab and line break.
Qatium will automatically shorten a longer ID to 31 characters and replace any unidentified character with a number.
- be unique
If 2 or more of your assets have the same ID, Qatium will assign that ID to the asset with the higher priority in the hierarchy list below:
|+||1. Reservoir (Supply source)|
The rest of the assets will be renamed in the following way:
original ID + # (separator) + sequential number
Pipe1, Pipe1→ Pipe1, Pipe1#1
Junction1, Junction1, Junction1 → Junction1, Junction1#1, Junction1#2
We recommend that you specify which junctions represent hydrants directly on your EPANET model. Otherwise, Qatium will not be able to identify them.
There are 2 ways to do it:
- By adding H_ as a prefix to the ID of the relevant junctions
- By adding the word hydrant (or any of the accepted aliases) to the description of the relevant junctions. You can do that in EPANET or on the exported .inp file (;hydrant)
“Hydrant” can be replaced by one of the following aliases: boca, faucet, fire, hidrante, hydrant, incendio, riego, salida, spigot.
Tip from Q:
You can always drag & drop your hydrant and valve layers after your model import.
You can also define lateral pipes in your network, so that you can visualize and filter them in the Network elements panel:
To do that, add the word “lateral” to the description of the relevant pipes. You can do that in EPANET or on the exported .inp file (;lateral).
Visualizing customer points on the map of your model can provide useful insights when running scenarios, as it may allow you to see the impact of an operation to the customers.
In order to import customer points in your EPANET model, simply add "customer" to the corresponding junction description.
;Junction ID Elevation Demand Modulation curve
J3 26.09 0 2.1 ; customer
Additional asset properties
For pipes, you can provide material and installation date, as well as minimum and maximum warning threshold values. For tanks and junctions, you can only specify threshold values.
To do so, just add the data to the description of the file before the import, following the format below:
e.g. installation date for a pipe: DI_20220706_1.2_12.5
e.g. thresholds for junction: J__25_35
The installation date information must be in this format: YYYYMMDD.
If the format is valid the installation date will be displayed in the following format in the pop-overs: YYYY-MM-DD
It is also possible to maintain the element description field information in the following way:
If you don't have all this information available, there’s no need to specify all the fields; you can provide any combination of the data that you do have.
However, it is crucial that the fields are in the correct order, as shown in the table below:
|App pop-over||Material||Installation Date||Min. Threshold||Max. Threshold|
Once you’ve done this, you’ll be able to see them by clicking on or hovering over each asset on the platform, for example:
Below you can see a list of the accepted pipe materials:
|Material full name||Aliases|
|Asbestos Cement||AC, Asbestos cement, FC, Fibrocemento, fibrocement, uralite, uralita|
|Abrasion Resistant Outerwrap||ARO, Abrasion Resistant Outerwrap, Envoltura exterior resistente a la abrasion|
|Cast Iron||CI, Cast Iron, Hierro fundido, Fundicion Gris|
|Cooper||COPP, Cooper, Cobre|
|Concrete Without Sheet Metal Jacket||CWOSMJ, CONC, Concrete Without Sheet Metal Jacket, Hormigon sin camisa de chapa,|
|Concrete With Sheet Metal Jacket||CWSMJ, CONCC, Concrete With Sheet Metal Jacket, HCC, Hormigon con camisa de chapa|
|Ductile Iron||DI, Ductile Iron, Hierro ductil, FD, Fundicion ductil|
|Lined Ductile Iron||DIL, Lined Ductile Iron, Hierro ductil revestido|
|Iron||FE, Iron, Hierro|
|Galvanized Iron||GI, Galvanized Iron, HG, Hierro galvanizado|
|Lined Galvanized Iron||GIL, Lined galvanised iron, Lined galvanized iron, Hierro galvanizado revestido|
|High Density Polyethylene||HDPE, High Density Polyethylene, Polietileno de alta densidad|
|Lead||L, Lead, Plomo|
|Low Density Polyethylene||LDPE, Low Density Polyethylene, Polietileno de baja densidad, Polietileno de densidad baja|
|Medium Density Polyethylene||MDPE, Medium Density Polyethylene, Polietileno de densidad media|
|Not available||NA, N/A, Not available, No disponible|
|Pretressed Concrete||PC, Pretressed Concrete, Hormigon pretensado|
|Polyethylene||PE, Polyethylene, Polietileno|
|Polyethylene 100||PE100, Polietileno 100, Polyethylene 100|
|Polyethylene 80||PE80, Polietileno 80, Polyethylene 80|
|Polyvinylchloride||PVC, Polyvinylchloride, Polyvinyl Chloride, Policloruro de vinilo|
|Orientated PVC||PVCO, Orientated PVC, PVC orientado|
|Reinforced Concrete||RC, Reinforced Concrete, Hormigon armado|
|Steel||S, Steel, Acero|
|Spun Iron||SI, Spun Iron, Hierro (spun)|
|Stainless Steel||SS, Stainless Steel, Acero inoxidable|
|Unknown||NIL, UNK, Unknown, Sin determinar, Desconocido|
|Unplasticized PVC||UPVC,Unplasticized PVC, PVC no plastificado, Unplasticized polyvinylchloride, Policloruro de vinilo no plastificado|
Aliases are insensitive to case, accents and more than one space. For example, if you write steel instead of Steel the platform will still process it correctly.
If you specify threshold values during your import, they will be compared with the live data. If the live data values exceed the threshold values for more than 1 hour, they are considered an issue, raising an alert. If you don’t preset the threshold values, no alert will be raised.
To add threshold values to your .inp file:
- Download the file
- Add the minimum or maximum threshold value next to the semicolon (;) of the specific asset line, like this:
- ;__20 (min.value)
- ;___80 (max. value)
- ;__20_80 (both values)
At the moment, Qatium supports water quality modeling based on water age only.
In order to see the results of water age simulation in your network, you have to specify in the .inp file in the [OPTIONS] that the QUALITY is AGE.
For more information about water age, see this article.
Qatium will create a simulation of 24 hours maximum. In order to obtain useful results, it’s necessary to define values that correspond to the initial quality of the network nodes.