Urban Wind Field: URock v2023a - SRID problem

[AlexandraStankulova]

Input data.zip
Hello, the "Urban Wind Field: URock v2023a" is giving an error when calculatin the wind raster, connected to the SRID of the vector file of the buildings and the vector file of the vegetation, saying that they have two different reference systems, while this is not true and they have two identical reference systems.

This is the Log that is giving:

QGIS version: 3.34.11-Prizren
QGIS code revision: 2904bcec
Qt version: 5.15.13
Python version: 3.12.6
GDAL version: 3.9.2
GEOS version: 3.12.2-CAPI-1.18.2
PROJ version: Rel. 9.4.0, March 1st, 2024
PDAL version: 2.6.3 (git-version: b5523a)
Algorithm started at: 2025-01-03T18:35:06
Algorithm 'Urban Wind Field: URock v2023a' starting…
Input parameters:
{ 'ATTENUATION_FIELD' : '', 'BUILDINGS' : 'D:\University\04_PHD\02_ICARUS\GIS\QGIS_PROJECT\PreparationData_Wind\BuildingFootprint_extended\N36_BuildingFootprint_Extended_NewCRS.shp', 'HEIGHT_FIELD_BUILD' : 'HEIGHT_up', 'HORIZONTAL_RESOLUTION' : 5, 'INPUT_PROFILE_FILE' : '', 'INPUT_PROFILE_TYPE' : 0, 'INPUT_WIND_DIRECTION' : 309, 'INPUT_WIND_HEIGHT' : 10, 'INPUT_WIND_SPEED' : 1.5, 'LOAD_OUTPUT' : True, 'OUTPUT_FILENAME' : 'urock_output', 'RASTER_OUTPUT' : 'D:/University/04_PHD/02_ICARUS/GIS/QGIS_PROJECT/PreparationData_Wind/DSM/N36_DSM.tif', 'SAVE_NETCDF' : True, 'SAVE_RASTER' : True, 'SAVE_VECTOR' : True, 'UROCK_OUTPUT' : 'D:\University\04_PHD\02_ICARUS\GIS\QGIS_PROJECT\OutputData\URock_Wind Raster\15h\N36', 'VEGETATION' : None, 'VEGETATION_CROWN_BASE_HEIGHT' : '', 'VEGETATION_CROWN_TOP_HEIGHT' : '', 'VERTICAL_RESOLUTION' : 5, 'WIND_HEIGHT' : '1.5' }

Writing settings for this model run to specified output folder (Filename: RunInfoURock_YYYY_DOY_HHMM.txt)
Initiating algorithm
Creates an H2GIS Instance and load data
Creates the stacked blocks used as obstacles
Rotates obstacles to the right direction and calculates geometry properties
Traceback (most recent call last):
File "JdbcPreparedStatement.java", line 256, in org.h2.jdbc.JdbcPreparedStatement.execute
java.sql.java.sql.SQLException: java.sql.SQLException: Operation on mixed SRID geometries not supported

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "JdbcPreparedStatement.java", line 256, in org.h2.jdbc.JdbcPreparedStatement.execute
Exception: Java Exception

The above exception was the direct cause of the following exception:

Traceback (most recent call last):
File "C:\Users\Alexandra\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 534, in execute
is_rs = self._prep.execute()
^^^^^^^^^^^^^^^^^^^^
org.h2.jdbc.org.h2.jdbc.JdbcSQLException: org.h2.jdbc.JdbcSQLException: Operation on mixed SRID geometries not supported; SQL statement:

SELECT ST_XMAX(ST_EXTENT(THE_GEOM)),
ST_YMAX(ST_EXTENT(THE_GEOM))
FROM (
SELECT THE_GEOM FROM ST_EXPLODE('(SELECT THE_GEOM FROM stacked_block_table)')
UNION ALL
SELECT THE_GEOM FROM ST_EXPLODE('(SELECT THE_GEOM FROM VEGETATION)')
[0-232]

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
File "C:\Users/Alexandra/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\processor\urock_processing_algorithm.py", line 447, in processAlgorithm
MainCalculation.main(javaEnvironmentPath = javaEnvVar,
File "C:\Users/Alexandra/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\functions\URock\MainCalculation.py", line 191, in main
Obstacles.windRotation(cursor = cursor,
File "C:\Users/Alexandra/AppData/Roaming/QGIS/QGIS3\profiles\default/python/plugins\processing_umep\functions\URock\Obstacles.py", line 54, in windRotation
cursor.execute("""
File "C:\Users\Alexandra\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 536, in execute
handle_sql_exception()
File "C:\Users\Alexandra\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init.py", line 165, in handle_sql_exception_jpype
reraise(exc_type, exc_info[1], exc_info[2])
File "C:\Users\Alexandra\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init.py", line 57, in reraise
raise value.with_traceback(tb)
File "C:\Users\Alexandra\AppData\Roaming\Python\Python312\site-packages\jaydebeapi_init_.py", line 534, in execute
is_rs = self._prep.execute()
^^^^^^^^^^^^^^^^^^^^
jaydebeapi.DatabaseError: org.h2.jdbc.JdbcSQLException: Operation on mixed SRID geometries not supported; SQL statement:

SELECT ST_XMAX(ST_EXTENT(THE_GEOM)),
ST_YMAX(ST_EXTENT(THE_GEOM))
FROM (
SELECT THE_GEOM FROM ST_EXPLODE('(SELECT THE_GEOM FROM stacked_block_table)')
UNION ALL
SELECT THE_GEOM FROM ST_EXPLODE('(SELECT THE_GEOM FROM VEGETATION)')
[0-232]

Execution failed after 2.65 seconds

Loading resulting layers
Algorithm 'Urban Wind Field: URock v2023a' finished

Here I upload also the files that I have used as input data.

[j3r3m1]

I could reproduce the error and I have reported the error to the repository of the database developer orbisgis/h2gis#1403

[AlexandraStankulova]

Thank you so much for the update. I will be waiting for the adjustments on the script. Thank you once more.

[AlexandraStankulova]

Hello. I just wanted to ask if there is any update about this problem?
Wish you a good day.

[j3r3m1]

It should be solved in the last UMEP version (Download from GitHub zip)

[AlexandraStankulova]

Hello. I now upgraded my UMEP downloading the latest from GitHub and I am making a test now. I will let you know as soon as possible.

[AlexandraStankulova]

Yes, I confirm that the problem with the SRID has been resolved.
Thank you so much.

[j3r3m1]

Solved according to UMEP-dev/UMEP-processing@1cf009d