gw_fct_getinfocrossection - Giswater/giswater_dbmodel GitHub Wiki

---

Description

Get crossection values for given arc_id

Input example

SELECT gw_fct_getinfocrossection($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"feature":{"id":"2001"}}$$)

Output example

{
  "status": "Accepted",
  "message": {},
  "apiVersion": {
    "value": "3.4.019"
  },
  "body": {
    "form": {},
    "feature": {},
    "data": {
      "shapepng": "ws_shape.png",
      "fields": [
        {
          "label": "m2mlpav",
          "columnname": "m2mlpav",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.978
        },
        {
          "label": "thickness",
          "columnname": "thickness",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.1
        },
        {
          "label": "bulk",
          "columnname": "bulk",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.0085
        },
        {
          "label": "y_param",
          "columnname": "y_param",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 7
        },
        {
          "label": "Crossection area:",
          "columnname": "area",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.0227
        },
        {
          "label": "m3/ml Excav",
          "columnname": "m3mlexc",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.792
        },
        {
          "label": "m3/ml Filling",
          "columnname": "m3mlfill",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.525
        },
        {
          "label": "m3/ml Excess",
          "columnname": "m3mlexcess",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.267
        },
        {
          "label": "% Trenchlining",
          "columnname": "m2mltrenchl",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 1.174
        },
        {
          "columnname": "b2",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.25
        },
        {
          "columnname": "m2mlbottom",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.67
        },
        {
          "columnname": "width",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.17
        },
        {
          "columnname": "b1",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.25
        },
        {
          "columnname": "m2mlpav",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.978
        },
        {
          "columnname": "z1",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.1
        },
        {
          "columnname": "geom1",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.153
        },
        {
          "columnname": "z2",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.1
        },
        {
          "columnname": "total_y",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 1.08
        },
        {
          "columnname": "rec_y",
          "widgettype": "text",
          "datatype": "string",
          "iseditable": false,
          "layoutorder": 1,
          "value": 0.61
        }
      ]
    }
  }
}