gw_fct_graphanalytics_check_data - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to check data quality of data used on graph analytics functions

Input example

SELECT gw_fct_graphanalytics_check_data($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{},
"data":{"parameters":{"selectionMode":"wholeSystem", "graphClass":"ALL"}}}$$)

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Data quality analysis done succesfully"
  },
  "version": "3.4.019",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 3013,
            "message": "DATA QUALITY ANALYSIS ACORDING GRAPH ANALYTICS RULES"
          },
          {
            "id": 3014,
            "message": "-------------------------------------------------------------"
          },
          {
            "id": 3035,
            "message": ""
          },
          {
            "id": 3015,
            "message": "CRITICAL ERRORS"
          },
          {
            "id": 3016,
            "message": "----------------------"
          },
          {
            "id": 3036,
            "message": ""
          },
          {
            "id": 3017,
            "message": "WARNINGS"
          },
          {
            "id": 3018,
            "message": "--------------"
          },
          {
            "id": 3021,
            "message": "WARNING: There is/are 1 nodes with ischange on 1 (true) without any variation of arcs in terms of diameter, pn or material. Please, check your data before continue."
          },
          {
            "id": 3022,
            "message": "SELECT * FROM anl_node WHERE fprocescat_id = 208 AND cur_user = current_user."
          },
          {
            "id": 3037,
            "message": ""
          },
          {
            "id": 3019,
            "message": "INFO"
          },
          {
            "id": 3020,
            "message": "-------"
          },
          {
            "id": 3023,
            "message": "INFO: No nodes without 'ischange' where arc changes have been found"
          },
          {
            "id": 3024,
            "message": "INFO: No valves's (state=1) with null values on closed and broken fields."
          },
          {
            "id": 3025,
            "message": "INFO: It seems config_mincut_inlet table is well configured. At least, table is filled with nodes from all exploitations."
          },
          {
            "id": 3026,
            "message": "INFO: The graph_delimiter column on cat_feature_node table has values for all rows."
          },
          {
            "id": 3027,
            "message": "INFO: All mapzones has graphconfig values not null."
          },
          {
            "id": 3028,
            "message": "INFO: All nodes with cat_feature_node.graphdelimiter='SECTOR' are defined as nodeParent on sector.graphconfig"
          },
          {
            "id": 3029,
            "message": "INFO: All mapzones has graphconfig values not null."
          },
          {
            "id": 3030,
            "message": "INFO: All nodes with cat_feature_node.graphdelimiter='DMA' are defined as nodeParent on dma.graphconfig"
          },
          {
            "id": 3031,
            "message": "INFO: All mapzones has graphconfig values not null."
          },
          {
            "id": 3032,
            "message": "INFO: All nodes with cat_feature_node.graphdelimiter='DQA' are defined as nodeParent on dqa.graphconfig"
          },
          {
            "id": 3033,
            "message": "INFO: All mapzones has graphconfig values not null."
          },
          {
            "id": 3034,
            "message": "INFO: All nodes with cat_feature_node.graphdelimiter='PRESSZONE' are defined as nodeParent on presszone.graphconfig"
          },
          {
            "id": 3038,
            "message": ""
          }
        ]
      },
      "setVisibleLayers": [],
      "point": {
        "geometryType": "Point",
        "features": [
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                419094.702013136,
                4576516.93020319
              ]
            },
            "properties": {
              "id": 1251,
              "fid": 208,
              "state": null,
              "expl_id": null,
              "descript": "Node with ischange=1 without any variation of arcs in terms of diameter, pn or material",
              "feature_id": "1044",
              "feature_catalog": "JUNCTION CHNGMAT"
            }
          }
        ]
      },
      "line": {},
      "polygon": {}
    },
    "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
          }
        }
      },
      "functionId": 2790
    }
  }
}