Hello,
my problem concerns condition classification using the QKan plugin.
I work in an engineering office with QGIS on a sewer rehabilitation project.
For this, I received the raw data from a CCTV inspection of a sewer network,
where the defects were recorded separately for reaches, pipes, and manholes.
Among these files is, for example, an XML file containing all information on
geometry, inspection date, and inspection results. The inspection results were
documented as AI condition codes according to DWA-M 149-2 and Isybau.
I am a beginner in QGIS and this project is my first time working with the
software. I managed to create both a Spatialite and a PostgreSQL database and
uploaded my data into them. The data also appears as layers in my layer tree
and in my map. When I now start the condition classification, QKan shows the
following message:
"2025-09-22T15:43:05 INFO Qkan.Zustandsklassen - Creating DB
2025-09-22T15:43:05 INFO Qkan.Zustandsklassen - DB creation finished, starting
Zustandsklassen"
In my layer tree, the layers "Ergebnis_ZK_Haltungen" ("Result_ZK_Reaches") and
the condition classes 0–5 appear. However, when I open the layer
"Ergebnis_ZK_Haltungen" to check the condition classes in the column
"Objektspalte_gesamt" ("ObjectColumn_Total"), it only shows "-" or
"Einzelfallbetrachtung" ("Case-by-case consideration") everywhere. No condition
class was determined anywhere.
I have already checked the following:
I have all read and write permissions for QKan. My QGIS version is 3.44.3 and I
installed the QKan plugin only a few days ago. I am working on an Apple Mac. In
my table "untersuchdat_haltung_bewertung" ("inspectiondata_reach_evaluation"),
all fields are now filled, none contains "NULL". The table includes the columns
"Kuerzel" (“code”), "charakt1", "charakt2", "quantnr1", "quantnr2",
"streckenschaden" ("section_damage"), "haltnam" ("reach_name"), "Baujahr"
("year_of_construction"), "Material", "Durchmesser" (diameter"), and "Länge"
("length"). The columns "Zustandsklasse_D" ("Condition_Class_D"),
"Zustandsklasse_S", and "Zustandsklasse_B" cannot be filled; they always show
"NULL".
I modified the table using query statements in the DB Manager after the
condition classification showed the following error:
"2025-09-22T13:36:01 WARNING Traceback (most recent call last):
File "/Users/celineschmidt/Library/Application
Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/application.py",
line 103, in run_import self._doimport()
File "/Users/celineschmidt/Library/Application
Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/application.py",
line 160, in _doimport zustand.run()
File "/Users/celineschmidt/Library/Application
Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/zustandsklassen_funkt.py",
line 90, in run self.bewertung_dwa_leitung()
File "/Users/celineschmidt/Library/Application
Support/QGIS/QGIS3/profiles/default/python/plugins/qkan/zustandsklassen/zustandsklassen_funkt.py",
line 7552, in bewertung_dwa_leitung curs.execute(sql, data)
sqlite3.OperationalError: near ",": syntax error"
I filled the fields for the condition codes with "." wherever "NULL" was
present, since I read that no mandatory fields are allowed to be empty. The
columns "haltnam", "Baujahr", "Material", "Durchmesser", and "Länge" were added
later and copied from the table "Haltungen" ("Reaches"). The two tables are
also linked via the column "haltnam". After making these changes, I restarted
the program to refresh the tables.
Now I am wondering: what mistake am I making that no condition classes are
being calculated? What should the input data I import look like? Which tables
and columns are required by QKan in order to perform the calculation? Do I have
to activate any function? I would be really thankful if you have any ideas on
how to solve my problem!
Kind regards / Mit freundlichen Grüßen –/i. A. Céline Schmidt
--
B.Sc. Céline Schmidt
Junior-Projektingenieurin
[Ein Bild, das Text, Schrift, Grafiken, Screenshot enthält. Automatisch
generierte Beschreibung]
Sebrathweg 5
44149 Dortmund
T: 0151 46700621
E: [email protected]<mailto:[email protected]>
I: www.bbp-gruppe.de<http://www.bbp-gruppe.de/>
[Ein Bild, das Symbol, Schrift, Kreis, Logo enthält. Automatisch generierte
Beschreibung]<https://www.linkedin.com/company/bbp-beratende-ingenieure-becker-&-barenberg-partg-mbb/>
[Ein Bild, das Kreis, Entwurf, Grafiken, Design enthält. Automatisch
generierte Beschreibung]<https://www.instagram.com/bbp_ingenieure/>
BBP Becker & Barenberg PartG mbB
Beratende Ingenieure für Projektmanagement und Baubetrieb
Sitz: Dortmund
Register: Amtsgericht Essen PR 2576
Geschäftsführende Partner: Pecco Becker, Volker Barenberg
[Ein Bild, das Muster, nähen, monochrom enthält. Automatisch generierte
Beschreibung]
_______________________________________________
QGIS-User mailing list
[email protected]
List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
