gw_fct_pg2epa_check_network - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to check topology issues before inp file creation related to given result_id

Input example

SELECT gw_fct_pg2epa_check_network($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, "parameters":{"resultId":"1"}}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Analysis done successfully"
  },
  "version": "3.5.003",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 506,
            "message": "CHECK RESULT NETWORK ACORDING EPA RULES"
          },
          {
            "id": 507,
            "message": "---------------------------------------------------------"
          },
          {
            "id": 527,
            "message": ""
          },
          {
            "id": 508,
            "message": "CRITICAL ERRORS"
          },
          {
            "id": 509,
            "message": "----------------------"
          },
          {
            "id": 528,
            "message": ""
          },
          {
            "id": 510,
            "message": "WARNINGS"
          },
          {
            "id": 511,
            "message": "--------------"
          },
          {
            "id": 529,
            "message": ""
          },
          {
            "id": 512,
            "message": "INFO"
          },
          {
            "id": 513,
            "message": "-------"
          },
          {
            "id": 516,
            "message": "INFO: No orphan node(s) found on this result. "
          },
          {
            "id": 517,
            "message": "INFO: No duplicated node(s) found on this result."
          },
          {
            "id": 518,
            "message": "INFO: There is/are no arcs without start/end nodes on this result."
          },
          {
            "id": 519,
            "message": "INFO: No arcs topological disconnected found on this result from any tank or reservoir"
          },
          {
            "id": 520,
            "message": "INFO: No arcs topological disconnected found on this result from any tank or reservoir"
          },
          {
            "id": 521,
            "message": "INFO: No dry arcs found"
          },
          {
            "id": 522,
            "message": "INFO: No dry nodes with demand found"
          },
          {
            "id": 530,
            "message": ""
          },
          {
            "id": 514,
            "message": "NETWORK ANALYTICS"
          },
          {
            "id": 515,
            "message": "-------------------------"
          },
          {
            "id": 523,
            "message": "Data analysis for node elevation. Minimun and maximum values are: ( 19.69 - 81.5 )."
          },
          {
            "id": 524,
            "message": "Data analysis for pipe length. Minimun and maximum values are: (1.4 - 881.12 )."
          },
          {
            "id": 525,
            "message": "Data analysis for pipe diameter. Minimun and maximum values are: ( 56.7 - 204 )."
          },
          {
            "id": 526,
            "message": "Data analysis for pipe roughness. Minimun and maximum values are: ( 0.003 - 0.003 )."
          }
        ]
      },
      "point": {
        "geometryType": "Point",
        "features": {}
      },
      "line": {
        "geometryType": "LineString",
        "features": {}
      }
    },
    "returnManager": {
      "style": {
        "point": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        },
        "line": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        },
        "polygon": {
          "style": "unique",
          "values": {
            "width": 3,
            "color": [
              255,
              1,
              1
            ],
            "transparency": 0.5
          }
        }
      }
    }
  }
}