Solving WIDTH field is not taken into account in "Enrich_DEM_with_road.groovy"

[pierromond]

Discussed in https://github.com/Universite-Gustave-Eiffel/NoiseModelling/discussions/633

^{Originally posted by IsotoCedex November 20, 2023} wps_scripts/src/main/groovy/org/noise_planet/noisemodelling/wps/Geometric_Tools/Enrich_DEM_with_road.groovy

Include: $roadWidth IS NOT NULL

def import_roads = """
    ------------
    -- Import roads (that are on the floor --> POS_SOL=0)
    -- Road width is precalculated into WIDTH column. When largeur < 3, then 3m

    DROP TABLE IF EXISTS dem_roads;
    CREATE TABLE dem_roads AS SELECT THE_GEOM, 'ROAD' as SOURCE, 
        (CASE WHEN $roadWidth IS NOT NULL AND $roadWidth>3 THEN $roadWidth/2 ELSE 1.5 END) as WIDTH 
        FROM $inputRoad WHERE POS_SOL = '0' AND st_zmin(THE_GEOM) > 0;
    CREATE SPATIAL INDEX ON dem_roads(THE_GEOM);
    ALTER TABLE dem_roads ADD PK_LINE INT AUTO_INCREMENT NOT NULL;
    ALTER TABLE dem_roads add primary key(PK_LINE);
    
    -- Roads: layer $inputRoad imported
"""


```</div>