gw_fct_import_swmm_inp - Giswater/giswater_dbmodel GitHub Wiki

---

Description

"Function to import network data from swmm inp file into database. Create subcatchment geometry will store on database all information related hydrological model of SWMM"

Input example

SELECT gw_fct_import_swmm_inp($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, 
"parameters":{"createSubcGeom":"True"}}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Import inp done successfully"
  },
  "version": "3.4.021",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "message": "Constraints of schema temporary disabled -> Done"
          },
          {
            "message": "Inserting data from inp file to temp_csv table -> Done"
          },
          {
            "message": "Creating map zones and catalogs -> Done"
          },
          {
            "message": "Setting selectors -> Done"
          },
          {
            "message": "WARNING: Values of options / times / report are not updated. Default values of Giswater are keeped"
          },
          {
            "message": "Inserting data into tables using vi_* views -> Done"
          },
          {
            "message": "WARNING: Controls rules will be stored on inp_controls_inmortinp table. This is a temporary table. Data need to be moved to inp_controls_x_arc table to be used later"
          },
          {
            "message": "Creating arc geometry from extremal nodes and intermediate vertex -> Done"
          },
          {
            "message": "WARNING: Link geometries as ORIFICE, WEIRS, PUMPS AND OULETS will not transformed using reverse nod2arc strategy as nodes. It will keep as arc"
          },
          {
            "message": "Creating subcathcment polygons -> Done"
          },
          {
            "message": "Enabling constraints -> Done"
          },
          {
            "message": "Process finished"
          }
        ]
      },
      "point": {},
      "line": {}
    }
  }
}