gw_fct_setmincut - Giswater/giswater_dbmodel GitHub Wiki


Description

Upsert values for given mincut

Input example

SELECT gw_fct_setmincut($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},"feature":{},
"data":{"valveUnaccess":{"status":"false"},"mincutId":"1", "arcId":"2061"}}$$)


Output example

  "mincutOverlap": "",
  "geometry": "POLYGON((418815.714659005 4576173.4743415,418815.714659005 4576970.71087728,419588.981142369 
4576970.71087728,419588.981142369 4576173.4743415,418815.714659005 4576173.4743415))",
  "minsector_id": "2061",
  "arcs": {
    "number": "131",
    "length": "7253.7",
    "volume": "5.8"
  },
  "connecs": {
    "number": "281",
    "hydrometers": {
      "total": "1199",
      "classified": [
        {
          "category": "1",
          "number": "254"
        },
        {
          "category": "2",
          "number": "372"
        },
        {
          "category": "3",
          "number": "355"
        },
        {
          "category": "4",
          "number": "169"
        },
        {
          "category": "5",
          "number": "49"
        }
      ]
    }
  },
  "body": {
    "layerManager": {
      "zoom": {
        "layer": "v_om_mincut_arc",
        "margin": 20
      },
      "functionId": 2980,
      "visible": [
        {
          "v_om_mincut_arc": {
            "style_id": null,
            "geom_field": "the_geom",
            "pkey_field": "id",
            "group_layer": null
          }
        },
        {
          "v_om_mincut_connec": {
            "style_id": null,
            "geom_field": "the_geom",
            "pkey_field": "id",
            "group_layer": null
          }
        },
        {
          "v_om_mincut_initpoint": {
            "style_id": null,
            "geom_field": "anl_the_geom",
            "pkey_field": "id",
            "group_layer": null
          }
        },
        {
          "v_om_mincut_node": {
            "style_id": null,
            "geom_field": "the_geom",
            "pkey_field": "id",
            "group_layer": null
          }
        }
      ]
    }
  }
}