gw_fct_setelevfromdem - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to update elevation values of node / connec / vnode using values from DEM raster. (DOCUMENTAR AQUI EL PROTOCOL 27)

Input example

SELECT gw_fct_setelevfromdem($${"client":{"device":4, "infoType":1, "lang":"ES"}, "form":{},
"feature":{"tableName":"v_edit_connec", "featureType":"CONNEC", "id":["3111", "3114", "3110"]}, 
"data":{"filterFields":{}, "pageInfo":{}, 
"parameters":{"exploitation":"1", "updateValues":"allValues"}}}$$)::text

Output example

{
  "status": "Accepted",
  "message": {
    "level": 1,
    "text": "Process done successfully"
  },
  "version": "3.4.021",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 2831,
            "message": "ELEVATION UPDATED - FEATURE TYPE:CONNEC, ID: 3110"
          },
          {
            "id": 2832,
            "message": "ELEVATION UPDATED - FEATURE TYPE:CONNEC, ID: 3111"
          },
          {
            "id": 2833,
            "message": "ELEVATION UPDATED - FEATURE TYPE:CONNEC, ID: 3114"
          }
        ]
      },
      "point": {
        "geometryType": "Point",
        "values": [
          {
            "id": 952,
            "feature_id": "3114",
            "state": 1,
            "expl_id": 1,
            "descript": "CONNEC",
            "the_geom": "0101000020E76400001D396E5490911941C99021DB47755141"
          },
          {
            "id": 951,
            "feature_id": "3111",
            "state": 1,
            "expl_id": 1,
            "descript": "CONNEC",
            "the_geom": "0101000020E76400000507C05ED49119410DA3D07B4C755141"
          },
          {
            "id": 950,
            "feature_id": "3110",
            "state": 1,
            "expl_id": 1,
            "descript": "CONNEC",
            "the_geom": "0101000020E7640000EEDE26569A911941BD02371C4F755141"
          }
        ]
      },
      "setVisibleLayers": []
    }
  }
}