gw_fct_setcheckproject - Giswater/giswater_dbmodel GitHub Wiki
Description
Network analysis to check nodes with more than one exit arc
Input example
SELECT gw_fct_setcheckproject($${
"client":{"device":4, "infoType":1, "lang":"ES"},
"form":{}, "feature":{},
"data":{"filterFields":{}, "pageInfo":{}, "version":"3.5.002", "fid":101,
"initProject":false, "addSchema":"NULL", "mainSchema":"NULL",
"projecRole":"", "infoType":"full", "qgisVersion":"3.10.5-A Coruña",
"osVersion":"Windows 10"}}$$)
Output example
{
"status": "Accepted",
"message": {
"level": 1,
"text": "Data quality analysis done succesfully"
},
"version": "3.4.021",
"body": {
"form": {},
"data": {
"info": {
"geometryType": "",
"values": [
{
"id": 3395,
"message": "AUDIT CHECK PROJECT"
},
{
"id": 3396,
"message": "-------------------------------------------------------------"
},
{
"id": 3404,
"message": "PostgreSQL versión: PostgreSQL 9.6.16, compiled by Visual C++ build 1800, 64-bit"
},
{
"id": 3405,
"message": "PostGIS versión: 2.5 USE_GEOS=1 USE_PROJ=1 USE_STATS=1"
},
{
"id": 3406,
"message": "QGIS versión: 3.10.5-A Coruña"
},
{
"id": 3407,
"message": "O/S versión: Windows 10"
},
{
"id": 3408,
"message": "QGIS variables: gwAddSchema:NULL, gwMainSchema:NULL, gwProjectRole:NULL, gwInfoType:'full'"
},
{
"id": 3409,
"message": "Logged as postgres on 2020-09-30 16:41:41.161819+02"
},
{
"id": 3410,
"message": "Reset all sequences on project data schema."
},
{
"id": 3411,
"message": "Inactive parameters have been deleted from sys_param_user."
},
{
"id": 3412,
"message": "Current psector: 3"
},
{
"id": 3633,
"message": null
},
{
"id": 3397,
"message": "CRITICAL ERRORS"
},
{
"id": 3398,
"message": "----------------------"
},
{
"id": 3403,
"message": "ERROR: Version of plugin is different than the database version. DB: 3.4.021, plugin: 3.5.002."
},
{
"id": 3634,
"message": null
},
{
"id": 3399,
"message": "WARNINGS"
},
{
"id": 3400,
"message": "--------------"
},
{
"id": 3453,
"message": "WARNING (DB OM): There is/are 1 system variables with out-of-standard values {edit_state_topocontrol}."
},
{
"id": 3469,
"message": "WARNING (DB OM): There is/are 12 connecs without links."
},
{
"id": 3476,
"message": "WARNING (DB OM): There is/are 1 features on service with value of end date."
},
{
"id": 3477,
"message": "WARNING (DB OM): There is/are 3 features with state 0 without value of end date."
},
{
"id": 3508,
"message": "WARNING (DB GRAPH): There is/are 4 nodes with ischange on 1 (true) without any variation of arcs in terms of diameter, pn or material. Please, check your data before continue."
},
{
"id": 3509,
"message": "SELECT * FROM anl_node WHERE fprocescat_id = 208 AND cur_user = current_user."
},
{
"id": 3510,
"message": "WARNING (DB GRAPH): There is/are 1 nodes where arc catalog changes without nodecat with ischange on 0 or 2 (false or maybe). Please, check your data before continue."
},
{
"id": 3511,
"message": "SELECT * FROM anl_node WHERE fprocescat_id = 209 AND cur_user = current_user."
},
{
"id": 3635,
"message": null
},
{
"id": 3401,
"message": "INFO"
},
{
"id": 3402,
"message": "-------"
},
{
"id": 3454,
"message": "INFO (DB OM): No arc's without node_1 or node_2 nodes found."
},
{
"id": 3455,
"message": "INFO (DB OM): No arcs with state=1 using nodes with state=0 found."
},
{
"id": 3456,
"message": "INFO (DB OM): No arcs with state=1 using nodes with state=0 found."
},
{
"id": 3457,
"message": "INFO (DB OM): No features with state=2 without psector assigned."
},
{
"id": 3458,
"message": "INFO (DB OM): No topologic features (arc, node) with state_type NULL values found."
},
{
"id": 3459,
"message": "INFO (DB OM): No nodes with state > 0 AND state_type.is_operative on FALSE found."
},
{
"id": 3460,
"message": "INFO (DB OM): No arcs with state > 0 AND state_type.is_operative on FALSE found."
},
{
"id": 3461,
"message": "INFO (DB OM): All tanks are defined in config_mincut_inlet."
},
{
"id": 3462,
"message": "INFO (DB OM): No arcs with drawing direction different than definition of node_1, node_2"
},
{
"id": 3463,
"message": "INFO (DB OM): No connecs with null customer code."
},
{
"id": 3464,
"message": "INFO (DB OM): No connecs with customer code duplicated."
},
{
"id": 3465,
"message": "INFO (DB OM): All features with id integer."
},
{
"id": 3466,
"message": "INFO (DB OM): No features without concordance againts state and state_type."
},
{
"id": 3467,
"message": "INFO (DB OM): No features (arc, node, connec, element) with NULL values on code found."
},
{
"id": 3468,
"message": "INFO (DB OM): No polygons without parent feature (register, tank, fountain) found."
},
{
"id": 3470,
"message": "INFO (DB OM): All connecs have correct arc_id."
},
{
"id": 3471,
"message": "INFO (DB OM): All vnode links have vnode."
},
{
"id": 3472,
"message": "INFO (DB OM): All vnodes have vnode link."
},
{
"id": 3473,
"message": "INFO (DB OM): All links state > 0 have feature_id."
},
{
"id": 3474,
"message": "INFO (DB OM): All links state > 0 have exit_id."
},
{
"id": 3475,
"message": "INFO (DB OM): All chained connecs have the same arc_id"
},
{
"id": 3478,
"message": "INFO (DB OM): No features with end date earlier than built date"
},
{
"id": 3479,
"message": "INFO (DB OM): No automatic links with out-of-range Longitude found."
},
{
"id": 3480,
"message": "INFO (DB OM): All features have a diferent ID to be correctly identified"
},
{
"id": 3512,
"message": "INFO (DB GRAPH): No valves's (state=1) with null values on closed and broken fields."
},
{
"id": 3513,
"message": "INFO (DB GRAPH): It seems config_mincut_inlet table is well configured. At least, table is filled with nodes from all exploitations."
},
{
"id": 3514,
"message": "INFO (DB GRAPH): The graph_delimiter column on cat_feature_node table has values for all rows."
},
{
"id": 3515,
"message": "INFO (DB GRAPH): All mapzones has graphconfig values not null."
},
{
"id": 3516,
"message": "INFO (DB GRAPH): All nodes with cat_feature_node.graphdelimiter='SECTOR' are defined as nodeParent on sector.graphconfig"
},
{
"id": 3517,
"message": "INFO (DB GRAPH): All mapzones has graphconfig values not null."
},
{
"id": 3518,
"message": "INFO (DB GRAPH): All nodes with cat_feature_node.graphdelimiter='DMA' are defined as nodeParent on dma.graphconfig"
},
{
"id": 3519,
"message": "INFO (DB GRAPH): All mapzones has graphconfig values not null."
},
{
"id": 3520,
"message": "INFO (DB GRAPH): All nodes with cat_feature_node.graphdelimiter='DQA' are defined as nodeParent on dqa.graphconfig"
},
{
"id": 3521,
"message": "INFO (DB GRAPH): All mapzones has graphconfig values not null."
},
{
"id": 3522,
"message": "INFO (DB GRAPH): All nodes with cat_feature_node.graphdelimiter='PRESSZONE' are defined as nodeParent on presszone.graphconfig"
},
{
"id": 3565,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_arc.active column."
},
{
"id": 3566,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_arc.cost column."
},
{
"id": 3567,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_arc.m2bottom_cost column."
},
{
"id": 3568,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_arc.m3protec_cost column."
},
{
"id": 3569,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_node.active column."
},
{
"id": 3570,
"message": "INFO (DB PLAN): There is/are no row(s) row(s) without values on cat_node.cost column."
},
{
"id": 3571,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_node.cost_unit column."
},
{
"id": 3572,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_node.estimated_depth column."
},
{
"id": 3573,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_connec.active column column."
},
{
"id": 3574,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_connec.cost_ut column."
},
{
"id": 3575,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_connec.cost_ml column."
},
{
"id": 3576,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_connec.cost_m3 column."
},
{
"id": 3577,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_pavement.thickness column."
},
{
"id": 3578,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_pavement.m2_cost column."
},
{
"id": 3579,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.y_param column."
},
{
"id": 3580,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.b column."
},
{
"id": 3581,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.m3exc_cost column."
},
{
"id": 3582,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.m3fill_cost column."
},
{
"id": 3583,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.m3excess_cost column."
},
{
"id": 3584,
"message": "INFO (DB PLAN): There is/are no row(s) without values on cat_soil.m2trenchl_cost column."
},
{
"id": 3585,
"message": "INFO (DB PLAN): The number of rows of row(s) of the plan_arc_x_pavement table is same than the arc table."
},
{
"id": 3586,
"message": "INFO (DB PLAN): There is/are no row(s) without values on row(s) without values on plan_arc_x_pavement.pavcat_id column."
},
{
"id": 3614,
"message": "INFO (DB ADMIN): All features have value on field \"active\""
},
{
"id": 3615,
"message": "INFO (DB ADMIN): All features have value on field \"code_autofill\""
},
{
"id": 3616,
"message": "INFO (DB ADMIN): All nodes have value on field \"num_arcs\""
},
{
"id": 3617,
"message": "INFO (DB ADMIN): All nodes have value on field \"isarcdivide\""
},
{
"id": 3618,
"message": "INFO (DB ADMIN): All nodes have value on field \"graph_delimiter\""
},
{
"id": 3619,
"message": "INFO (DB ADMIN): All nodes have value on field \"choose_hemisphere\""
},
{
"id": 3620,
"message": "INFO (DB ADMIN): All nodes have value on field \"isprofilesurface\""
},
{
"id": 3621,
"message": "INFO (DB ADMIN): All active features have child view name in cat_feature table"
},
{
"id": 3622,
"message": "INFO (DB ADMIN): All active features have child view defined in config_api_tableinfo_x_infotype"
},
{
"id": 3623,
"message": "INFO (DB ADMIN): All active features have child view defined in config_form_fields"
},
{
"id": 3624,
"message": "INFO (DB ADMIN): All feature form fields have defined data type."
},
{
"id": 3625,
"message": "INFO (DB ADMIN): All feature form fields have defined widget type."
},
{
"id": 3626,
"message": "INFO (DB ADMIN): All feature form fields with widget type combo or typeahead have dv_querytext defined."
},
{
"id": 3627,
"message": "INFO (DB ADMIN): All addfields are defined in config_form_fields."
},
{
"id": 3628,
"message": "INFO (DB ADMIN): All fields defined in config_form_fields have unduplicated order."
},
{
"id": 3629,
"message": "INFO (QGIS PROJ): All layers come from current host"
},
{
"id": 3630,
"message": "INFO (QGIS PROJ): All layers come from current database"
},
{
"id": 3631,
"message": "INFO (QGIS PROJ): All layers come from current schema"
},
{
"id": 3632,
"message": "INFO (QGIS PROJ): All layers have been added by current user"
},
{
"id": 3636,
"message": null
}
]
},
"point": {},
"line": {},
"polygon": {},
"missingLayers": {}
},
"actions": {
"hideForm": false,
"setQgisLayers": true,
"useGuideMap": false
}
}
}