gw_fct_setnodefromarc - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Massive builder assistant. Built as many nodes as network need to achieve the topological rules. To do this, all nodes are inserted using default values of user (catalog, workcat_id, state, state_type and node_type). Before execute it, check all new nodes will be inserted into mapzones boudaries. Uncheck direct insert into node table if you are looking to use intermediate table (anl_node).

Input example

SELECT gw_fct_setnodefromarc($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, "feature":{"tableName":"v_edit_arc", "featureType":"ARC", "id":[]}, 
"data":{"filterFields":{}, "pageInfo":{}, "selectionMode":"wholeSelection",
"parameters":{"insertIntoNode":"false", "nodeTolerance":"0.01", "exploitation":"1", 
"stateType":"2", "workcatId":"work2", "builtdate":"2020/09/30", "nodeType":"AIR_VALVE", 
"nodeCat":"AIR VALVE DN50"}}}$$);

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Process done successfully"
  },
  "version": "3.5.002",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": {}
      },
      "point": {
        "geometryType": "Point",
        "features": [
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                419195.037368965,
                4576615.56860714
              ]
            },
            "properties": {
              "id": 5,
              "fid": 116,
              "state": 1,
              "expl_id": 1,
              "node_id": "114472",
              "descript": null,
              "nodecat_id": "AIR VALVE DN50"
            }
          },
          {
            "type": "Feature",
            "geometry": {
              "type": "Point",
              "coordinates": [
                419065.572156943,
                4576659.67201367
              ]
            },
            "properties": {
              "id": 4,
              "fid": 116,
              "state": 1,
              "expl_id": 1,
              "node_id": "114471",
              "descript": null,
              "nodecat_id": "AIR VALVE DN50"
            }
          }
        ]
      }
    },
    "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": 2118
    }
  }
}