gw_fct_anl_node_flowregulator - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Network analysis to check nodes with more than one exit arc

Input example

SELECT gw_fct_anl_node_flowregulator($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, 
"feature":{"tableName":"v_edit_node", "featureType":"NODE", "id":[]}, 
"data":{"filterFields":{}, "pageInfo":{}, "selectionMode":"wholeSelection",
"parameters":{}}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Analysis done successfully"
  },
  "version": "3.5.002",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": {}
      },
      "point": {
        "geometryType": "Point",
        "features": [
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                419619.964929625,
                4576466.49425227
              ]
            },
            "properties": {
              "id": 31,
              "fid": 112,
              "state": 1,
              "expl_id": 1,
              "node_id": "238",
              "descript": null,
              "nodecat_id": "SEW_STORAGE-01"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                419597.71911167,
                4576460.64008965
              ]
            },
            "properties": {
              "id": 30,
              "fid": 112,
              "state": 1,
              "expl_id": 1,
              "node_id": "237",
              "descript": null,
              "nodecat_id": "CHAMBER-01"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418564.654700161,
                4577881.39314394
              ]
            },
            "properties": {
              "id": 29,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18876",
              "descript": null,
              "nodecat_id": "JUNCTION-01"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418320.173619172,
                4577851.65566449
              ]
            },
            "properties": {
              "id": 28,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18867",
              "descript": null,
              "nodecat_id": "C_MANHOLE_80"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418374.773581427,
                4577805.58694634
              ]
            },
            "properties": {
              "id": 27,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18860",
              "descript": null,
              "nodecat_id": "JUNCTION-01"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418580.985938872,
                4577784.380711
              ]
            },
            "properties": {
              "id": 26,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18856",
              "descript": null,
              "nodecat_id": "C_MANHOLE_80"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418481.779757453,
                4577767.07447296
              ]
            },
            "properties": {
              "id": 25,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18854",
              "descript": null,
              "nodecat_id": "C_MANHOLE_80"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418384.279824855,
                4577751.47448375
              ]
            },
            "properties": {
              "id": 24,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18852",
              "descript": null,
              "nodecat_id": "C_MANHOLE_80"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418593.904679941,
                4577697.60577099
              ]
            },
            "properties": {
              "id": 23,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18836",
              "descript": null,
              "nodecat_id": "C_MANHOLE_80"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                418716.02334552,
                4577601.81208721
              ]
            },
            "properties": {
              "id": 22,
              "fid": 112,
              "state": 1,
              "expl_id": 2,
              "node_id": "18828",
              "descript": null,
              "nodecat_id": "SEW_STORAGE-01"
            }
          }
        ]
      }
    },
    "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": 2208
    }
  }
}