gw_fct_getprofilevalues - Giswater/giswater_dbmodel GitHub Wiki


Description

Get profile dialog and values for new or given profile

Input example

SELECT gw_fct_getprofilevalues($${"client":{},
"data":{"initNode":"116", "endNode":"111", "composer":"mincutA4", "legendFactor":1, "linksDistance":1, 
"scale":{"scaleToFit":false, "eh":2000, "ev":500},"papersize":{"id":2, "customDim":{}},
"ComposerTemplates":[{"ComposerTemplate":"mincutA4", 
"ComposerMap":[{"width":"179.0","height":"140.826","index":0, "name":"map0"},
{"width":"77.729","height":"55.9066","index":1, "name":"map7"}]},
{"ComposerTemplate":"mincutA3",
"ComposerMap":[{"width":"53.44","height":"55.9066","index":0, "name":"map7"},
{"width":"337.865","height":"275.914","index":1, "name":"map6"}]}]}}$$); 

Output example

{
  "status": "Accepted",
  "message": {
    "level": 3,
    "text": "Profile done successfully"
  },
  "version": "3.4.019",
  "body": {
    "form": {},
    "data": {
      "legend": {
        "catalog": "CATALOG",
        "vs": "VS",
        "hs": "HS",
        "referencePlane": "RF",
        "dimensions": "SLOPE/LENGTH",
        "ordinates": "ORDINATES",
        "topelev": "ELEVATION",
        "ymax": "DEPTH",
        "elev": "ELEV",
        "code": "CODE"
      },
      "scale": "{}",
      "extension": {},
      "initpoint": {},
      "stylesheet": {
        "guitartext": {
          "color": "black",
          "italic": true,
          "bold": true
        },
        "legendtext": {
          "color": "black",
          "italic": true,
          "bold": true
        },
        "scaletext": {
          "color": "black",
          "height": 10,
          "italic": true,
          "bold": true
        },
        "ground": {
          "color": "black",
          "width": 0.2
        },
        "infra": {
          "color": "black",
          "width": 0.2
        },
        "guitar": {
          "color": "black",
          "width": 0.2
        },
        "estimated": {
          "color": "black",
          "width": 0.2
        }
      },
      "node": {},
      "terrain": {},
      "arc": {}
    }
  }
}