gw_fct_setfeaturereplace - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Function to replace one node, connec or gully with on service state for another one, copying all attributes, setting old one to obsolete state and reconnecting other features with the new one.

Input example

SELECT gw_fct_setfeaturereplace($${
"client":{"device":4, "infoType":1, "lang":"ES"}, 
"form":{}, 
"feature":{"type":"node"}, 
"data":{"filterFields":{}, "pageInfo":{}, "old_feature_id":"1006", "workcat_id_end":"work1", 
"enddate":"2017-12-06", "keep_elements":"True"}}$$)::text

Output example

{
  "status": "Accepted",
  "message": {
    "level": 3,
    "text": "Replace feature done successfully"
  },
  "version": "3.5.002",
  "body": {
    "form": {},
    "data": {
      "info": {
        "geometryType": "",
        "values": [
          {
            "id": 757,
            "message": "REPLACE FEATURE"
          },
          {
            "id": 758,
            "message": "------------------------------"
          },
          {
            "id": 759,
            "message": "Insert new feature into node table."
          },
          {
            "id": 760,
            "message": "Insert new feature id into man_junction."
          },
          {
            "id": 761,
            "message": "Insert new feature id into inp_junction."
          },
          {
            "id": 762,
            "message": "Copy value of elevation: 53.6136."
          },
          {
            "id": 763,
            "message": "Copy value of depth: 0.0000."
          },
          {
            "id": 764,
            "message": "Copy value of presszone_id: 3."
          },
          {
            "id": 765,
            "message": "Copy value of soilcat_id: soil1."
          },
          {
            "id": 766,
            "message": "Copy value of function_type: St. Function."
          },
          {
            "id": 767,
            "message": "Copy value of category_type: St. Category."
          },
          {
            "id": 768,
            "message": "Copy value of fluid_type: St. Fluid."
          },
          {
            "id": 769,
            "message": "Copy value of location_type: St. Location."
          },
          {
            "id": 770,
            "message": "Copy value of workcat_id: work1."
          },
          {
            "id": 771,
            "message": "Copy value of buildercat_id: builder1."
          },
          {
            "id": 772,
            "message": "Copy value of builtdate: 2017-12-06."
          },
          {
            "id": 773,
            "message": "Copy value of ownercat_id: owner1."
          },
          {
            "id": 774,
            "message": "Copy value of muni_id: 1."
          },
          {
            "id": 775,
            "message": "Copy value of postcode: 08830."
          },
          {
            "id": 776,
            "message": "Copy value of streetaxis_id: 1-10000C."
          },
          {
            "id": 777,
            "message": "Copy value of link: https://www.giswater.org."
          },
          {
            "id": 778,
            "message": "Copy value of verified: TO REVIEW."
          },
          {
            "id": 779,
            "message": "Copy value of rotation: 33.420."
          },
          {
            "id": 780,
            "message": "Copy value of inventory: true."
          },
          {
            "id": 781,
            "message": "Copy value of feature_type: NODE."
          },
          {
            "id": 782,
            "message": "Copy value of tstamp: 2020-08-13 09:15:52.215974."
          },
          {
            "id": 783,
            "message": "Copy value of lastupdate: 2020-08-13 09:15:52.215974."
          },
          {
            "id": 784,
            "message": "Copy value of lastupdate_user: postgres."
          },
          {
            "id": 785,
            "message": "Copy value of insert_user: postgres."
          },
          {
            "id": 786,
            "message": "Copy value of dqa_id: 1."
          },
          {
            "id": 787,
            "message": "Copy value of staticpressure: 0.000."
          },
          {
            "id": 788,
            "message": "Copy value of district_id: 1."
          },
          {
            "id": 789,
            "message": "Copy value of demand: 0.004236."
          },
          {
            "id": 790,
            "message": "Copy value of pattern_id: pattern_02."
          },
          {
            "id": 791,
            "message": "Assign 2 elements to the new feature."
          },
          {
            "id": 792,
            "message": "Reconnect arc 2066."
          },
          {
            "id": 793,
            "message": "Reconnect arc 2055."
          },
          {
            "id": 794,
            "message": "Downgrade old feature, set state: 0, workcat_id_end: work1, enddate: 2017-12-06."
          },
          {
            "id": 795,
            "message": "Update new feature, set state: 1, workcat_id: work1, builtdate: 2017-12-06."
          }
        ]
      }
    }
  }
}