gw_fct_anl_arc_no_startend_node - Giswater/giswater_dbmodel GitHub Wiki
Description
Network analysis to check how many arcs do not have start or end nodes
Input example
SELECT gw_fct_anl_arc_no_startend_node($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{},
"feature":{"tableName":"v_edit_arc", "featureType":"ARC", "id":[]},
"data":{"filterFields":{}, "pageInfo":{}, "selectionMode":"wholeSelection",
"parameters":{"arcSearchNodes":"0.1", "saveOnDatabase":"true"}}}$$);
Output example
{
"status": "Accepted",
"message": {
"level": 1,
"text": "Analysis done successfully"
},
"version": "3.5.002",
"body": {
"form": {},
"data": {
"info": {
"geometryType": "",
"values": {}
},
"point": {
"geometryType": "Point",
"features": [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [
419106.867487931,
4576515.40421601
]
},
"properties": {
"id": 7,
"fid": 103,
"state": 2,
"expl_id": 1,
"node_id": null,
"descript": null,
"arccat_id": "PEHD110-PN16"
}
},
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [
419106.867487931,
4576515.40421601
]
},
"properties": {
"id": 8,
"fid": 103,
"state": 2,
"expl_id": 1,
"node_id": null,
"descript": null,
"arccat_id": "PEHD110-PN16"
}
}
]
},
"line": {
"geometryType": "LineString",
"features": [
{
"type": "Feature",
"geometry": {
"type": "LineString",
"coordinates": [
[
419204.605031965,
4576509.24939368
],
[
419203.341545794,
4576508.35712221
],
[
419112.215561913,
4576511.82254247
],
[
419112.234577296,
4576511.82184881
],
[
419112.12744452,
4576511.82652714
],
[
419112.020409709,
4576511.83307449
],
[
419111.913505467,
4576511.84148885
],
[
419111.806764357,
4576511.85176767
],
[
419111.700218895,
4576511.86390781
],
[
419111.593901535,
4576511.87790558
],
[
419111.487844662,
4576511.89375671
],
[
419111.382080583,
4576511.91145638
],
[
419111.276641513,
4576511.93099918
],
[
419111.171559571,
4576511.95237918
],
[
419111.066866767,
4576511.97558985
],
[
419110.962594989,
4576512.00062412
],
[
419110.858776001,
4576512.02747438
],
[
419110.755441426,
4576512.05613244
],
[
419110.652622742,
4576512.08658957
],
[
419110.550351267,
4576512.1188365
],
[
419110.448658156,
4576512.1528634
],
[
419110.347574384,
4576512.18865991
],
[
419110.247130743,
4576512.22621511
],
[
419110.147357828,
4576512.26551759
],
[
419110.048286032,
4576512.30655535
],
[
419109.949945533,
4576512.34931591
],
[
419109.852366286,
4576512.39378623
],
[
419109.755578015,
4576512.43995277
],
[
419109.659610203,
4576512.48780146
],
[
419109.564492081,
4576512.53731774
],
[
419109.470252625,
4576512.58848652
],
[
419109.37692054,
4576512.64129221
],
[
419109.284524256,
4576512.69571873
],
[
419109.193091918,
4576512.75174949
],
[
419109.102651378,
4576512.80936744
],
[
419109.013230183,
4576512.86855501
],
[
419108.924855574,
4576512.92929418
],
[
419108.837554469,
4576512.99156646
],
[
419108.751353461,
4576513.05535286
],
[
419108.666278809,
4576513.12063397
],
[
419108.582356426,
4576513.18738988
],
[
419108.499611876,
4576513.25560028
],
[
419108.418070364,
4576513.32524438
],
[
419106.864209308,
4576515.40093739
],
[
419106.867487931,
4576515.40421601
]
]
},
"properties": {
"id": 7,
"fid": 103,
"state": 2,
"arc_id": "20851",
"expl_id": 1,
"descript": null,
"arccat_id": "PEHD110-PN16"
}
},
{
"type": "Feature",
"geometry": {
"type": "LineString",
"coordinates": [
[
419106.867487931,
4576515.40421601
],
[
419095.86850589,
4576515.92882589
],
[
419094.702013136,
4576516.93020319
]
]
},
"properties": {
"id": 8,
"fid": 103,
"state": 2,
"arc_id": "20861",
"expl_id": 1,
"descript": null,
"arccat_id": "PEHD110-PN16"
}
}
]
}
},
"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": 2102
}
}
}