Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Error in Enrich_DEM_with_roads #615

Open
IsotoCedex opened this issue Sep 21, 2023 · 0 comments
Open

Error in Enrich_DEM_with_roads #615

IsotoCedex opened this issue Sep 21, 2023 · 0 comments
Assignees
Labels

Comments

@IsotoCedex
Copy link

IsotoCedex commented Sep 21, 2023

NoiseModelling version
4.0.5

Describe the bug
When "enrich_DEM_with_roads" is run, it gives the following error:

"Process failed during execution javax.script.ScriptException: org.h2.jdbc.JdbcSQLSyntaxErrorException: Columna "POS_SOL" no encontrada Column "POS_SOL" not found; SQL statement: CREATE TABLE dem_roads AS SELECT THE_GEOM, 'ROAD' as SOURCE, (CASE WHEN ROADWIDTH>3 THEN ROADWIDTH/2 ELSE 1.5 END) as WIDTH FROM ROADS_z WHERE POS_SOL = '0' AND st_zmin(THE_GEOM [42122-214] org.h2.jdbc.JdbcSQLSyntaxErrorException: Columna "POS_SOL" no encontrada Column "POS_SOL" not found; SQL statement: CREATE TABLE dem_roads AS SELECT THE_GEOM, 'ROAD' as SOURCE, (CASE WHEN ROADWIDTH>3 THEN ROADWIDTH/2 ELSE 1.5 END) as WIDTH FROM ROADS_z WHERE POS_SOL = '0' AND st_zmin(THE_GEOM [42122-214] Columna "POS_SOL" no encontrada Column "POS_SOL" not found; SQL statement: CREATE TABLE dem_roads AS SELECT THE_GEOM, 'ROAD' as SOURCE, (CASE WHEN ROADWIDTH>3 THEN ROADWIDTH/2 ELSE 1.5 END) as WIDTH FROM ROADS_z WHERE POS_SOL = '0' AND st_zmin(THE_GEOM [42122-214]"

To Solve

It seems that it is necessary that the "roads" layer has the "POS_SOL" field, with value = "0".
If this field exists, it works!

image

For more details

Enriching the DEM avoids errors in the calculation.
In the following images it is observed that, without DEM enrichment, "strange" results are predicted. Possibly due to sources that remain below the terrain.

DEM enrichment works like the "raise all sources above terrain" option available in other softwares.

Without DEM enrichment:

image

With DEM enrichment:

image

good job guys!

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Projects
None yet
Development

No branches or pull requests

3 participants