gw_fct_pg2epa_check_result - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to check errors and data inconsistency for price catalog elements.

Input example

SELECT gw_fct_pg2epa_check_result($${
"data":{"parameters":{"resultId":"gw_check_project","fid":227}}}$$); --when is called from go2epa_main from toolbox

SELECT gw_fct_pg2epa_check_result($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{}, 
"data":{"filterFields":{}, "pageInfo":{}, 
"parameters":{"resultId":"1"}}}$$); -- when is called from toolbox

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Data quality analysis done succesfully"
  },
  "version": "3.5.003",
  "body": {
    "form": {},
    "data": {
      "options": {
        "inp_options_interval_from": null,
        "inp_options_interval_to": null
      },
      "info": {
        "geometryType": "",
        "values": [
          {
            "message": "CHECK RESULT WITH CURRENT USER-OPTIONS ACORDING EPA RULES"
          },
          {
            "message": "-------------------------------------------------------------------------------------"
          },
          {
            "message": "Result id: 1"
          },
          {
            "message": "Created by: postgres, on 2021-04-01 08-04-55"
          },
          {
            "message": "Network export mode: NODE (MANDATORY NODARCS)"
          },
          {
            "message": "Demand type: NODE ESTIMATED"
          },
          {
            "message": "Pattern method: UNIQUE ESTIMATED (NODE)"
          },
          {
            "message": "Valve mode: INVENTORY VALUES"
          },
          {
            "message": "Quality mode: NONE"
          },
          {
            "message": "Number of Presspump (Double-n2a): 1"
          },
          {
            "message": "Buildup mode: TRANSPORT. Parameters:"
          },
          {
            "message": "Default values: No default values used"
          },
          {
            "message": "Advanced settings: No advanced settings used"
          },
          {
            "message": ""
          },
          {
            "message": "CRITICAL ERRORS"
          },
          {
            "message": "----------------------"
          },
          {
            "message": ""
          },
          {
            "message": "WARNINGS"
          },
          {
            "message": "--------------"
          },
          {
            "message": ""
          },
          {
            "message": "INFO"
          },
          {
            "message": "-------"
          },
          {
            "message": "INFO: Pumps with 3-point curves checked. No results founded. Due a EPANET's bug with 3-point curves, it is forbidden to export curves like this because newer it will work on EPANET."
          },
          {
            "message": "INFO: The node2arc parameter is ok for the whole analysis. Current value is 0.300"
          },
          {
            "message": "INFO: Roughness values have been checked againts head-loss formula using the minimum and maximum EPANET user's manual values. Any out-of-range values have been detected."
          },
          {
            "message": "INFO: Pumps checked. No curve_id mandatory values missed."
          },
          {
            "message": "INFO: Demand type estimated is used. No inconsistence have been analyzed."
          },
          {
            "message": "INFO: No dma period values are need."
          },
          {
            "message": "INFO: All nodes have epa_type defined."
          },
          {
            "message": "INFO: All arcs have epa_type defined."
          },
          {
            "message": "INFO: There aren't any shortpipe and valves without diameter defined on dint column in cat_node table"
          },
          {
            "message": "INFO: All roughness values used for shortpipes have been taken from neighbourg values"
          },
          {
            "message": "INFO: All features have sector_id different than 0."
          },
          {
            "message": ""
          }
        ]
      },
      "point": {
        "geometryType": "Point",
        "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
          }
        }
      }
    }
  }
}