gw_fct_om_check_data - Giswater/giswater_dbmodel GitHub Wiki
Description
Function to chjeck errors and data inconsistency on database
Input example
SELECT gw_fct_om_check_data($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{}, "feature":{},
"data":{"filterFields":{}, "pageInfo":{},
"parameters":{"selectionMode":"userSelectors"}}}$$);
Output example
{
"status": "Accepted",
"message": {
"level": 1,
"text": "Data quality analysis done succesfully"
},
"version": "3.5.002",
"body": {
"form": {},
"data": {
"info": {
"geometryType": "",
"values": [
{
"id": 3460,
"message": "DATA QUALITY ANALYSIS ACORDING O&M RULES"
},
{
"id": 3461,
"message": "-------------------------------------------------------------"
},
{
"id": 3500,
"message": ""
},
{
"id": 3462,
"message": "CRITICAL ERRORS"
},
{
"id": 3463,
"message": "----------------------"
},
{
"id": 3501,
"message": ""
},
{
"id": 3464,
"message": "WARNINGS"
},
{
"id": 3465,
"message": "--------------"
},
{
"id": 3477,
"message": "WARNING: There is/are 1 arcs with drawing direction different than definition of node_1, node_2"
},
{
"id": 3485,
"message": "WARNING: There is/are 1 connecs without links."
},
{
"id": 3502,
"message": ""
},
{
"id": 3466,
"message": "INFO"
},
{
"id": 3467,
"message": "-------"
},
{
"id": 3468,
"message": "INFO: No system variables with values out-of-standars found."
},
{
"id": 3469,
"message": "INFO: No arc's without node_1 or node_2 nodes found."
},
{
"id": 3470,
"message": "INFO: No arcs with state=1 using nodes with state=0 found."
},
{
"id": 3471,
"message": "INFO: No arcs with inverted slope checked found."
},
{
"id": 3472,
"message": "INFO: No arcs with state=1 using nodes with state=0 found."
},
{
"id": 3473,
"message": "INFO: No features with state=2 without psector assigned."
},
{
"id": 3474,
"message": "INFO: No topologic features (arc, node) with state_type NULL values found."
},
{
"id": 3475,
"message": "INFO: No nodes with state > 0 AND state_type.is_operative on FALSE found."
},
{
"id": 3476,
"message": "INFO: No arcs with state > 0 AND state_type.is_operative on FALSE found."
},
{
"id": 3478,
"message": "INFO: No connecs with null customer code."
},
{
"id": 3479,
"message": "INFO: No connecs with customer code duplicated."
},
{
"id": 3480,
"message": "INFO: All features with id integer."
},
{
"id": 3481,
"message": "INFO: No features without concordance againts state and state_type."
},
{
"id": 3482,
"message": "INFO: No features (arc, node, connec, gully, element) with NULL values on code found."
},
{
"id": 3483,
"message": "INFO: No polygons without parent feature (gully, netgully, chamber, storage or wwtp) found."
},
{
"id": 3484,
"message": "INFO: No rows without feature found on man_addfields_value table."
},
{
"id": 3486,
"message": "INFO: All gullies have links."
},
{
"id": 3487,
"message": "INFO: All connecs have correct arc_id."
},
{
"id": 3488,
"message": "INFO: All gullies have correct arc_id."
},
{
"id": 3489,
"message": "INFO: All vnode links have vnode."
},
{
"id": 3490,
"message": "INFO: All vnodes have vnode link."
},
{
"id": 3491,
"message": "INFO: All links state > 0 have feature_id."
},
{
"id": 3492,
"message": "INFO: All links state > 0 have exit_id."
},
{
"id": 3493,
"message": "INFO: All chained connecs and gullies have the same arc_id"
},
{
"id": 3494,
"message": "INFO: No features on service have value of end date"
},
{
"id": 3495,
"message": "INFO: No features with state 0 are missing the end date"
},
{
"id": 3496,
"message": "INFO: No features with end date earlier than built date"
},
{
"id": 3497,
"message": "INFO: No automatic links with out-of-range Longitude found."
},
{
"id": 3498,
"message": "INFO: All features have a diferent ID to be correctly identified"
},
{
"id": 3499,
"message": "INFO: All features have a diferent ID to be correctly identified"
},
{
"id": 3503,
"message": ""
}
]
},
"point": {
"geometryType": "Point",
"features": [
{
"type": "Feature",
"geometry": {
"type": "Point",
"coordinates": [
419277.185095152,
4576479.47107959
]
},
"properties": {
"id": 4,
"fid": 204,
"state": null,
"expl_id": null,
"descript": "Connecs without links",
"feature_id": "100020",
"feature_catalog": "PVC-CC025_T"
}
}
]
},
"line": {
"geometryType": "LineString",
"features": [
{
"type": "Feature",
"geometry": {
"type": "LineString",
"coordinates": [
[
419270.082,
4576441.02
],
[
419244.856879588,
4576447.2188753
],
[
419267.993290697,
4576466.33156274
],
[
419270.082,
4576441.02
]
]
},
"properties": {
"id": 10,
"fid": 223,
"state": null,
"arc_id": "332",
"expl_id": null,
"descript": "Drawing direction different than definition of node_1, node_2",
"arccat_id": "CC040"
}
}
]
},
"polygon": {
"geometryType": "",
"values": []
}
},
"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": 2670
}
}
}