gw_fct_getmincut - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function that returns the details of existing mincut.

Input example

SELECT gw_fct_getmincut('{"data":{"mincutId":"1"}}');

Output example

{
  "status": "Accepted",
  "version": "3.5.003",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 546,
            "message": ""
          },
          {
            "id": 547,
            "message": "Mincut stats"
          },
          {
            "id": 548,
            "message": "-----------------"
          },
          {
            "id": 549,
            "message": "Number of arcs: 44"
          },
          {
            "id": 550,
            "message": "Length of affected network: 2125.8 mts"
          },
          {
            "id": 551,
            "message": "Total water volume: 17.93 m3"
          },
          {
            "id": 552,
            "message": "Number of connecs affected: 90"
          },
          {
            "id": 553,
            "message": "Total of hydrometers affected: 367"
          },
          {
            "id": 554,
            "message": "Hydrometers classification: [{\"category\":\"business\",\"number\":\"20\"},
             {\"category\":\"Domestic\",\"number\":\"65\"},{\"category\":\"Industry\",\"number\":\"117\"},
             {\"category\":\"Other\",\"number\":\"113\"},{\"category\":\"Shops\",\"number\":\"52\"}]"
          }
        ]
      }
    }
  }
}