I assume it is possible to obtain a map in LDEN. However I have no idea of how to do it. I have separate data for day, evening and night. The combination of the three maps takes probably place after calculating the noise propagation with ST_BRTriGrid3D, but how do you do it? Is there a function for that?
This is a Groovy code. It just call SQL commands. You don’t have to use this groovy code as it is not adapted to your data.
The important SQL code is this:
createtable LE_HCN asSELECT the_geom,10*(Log10((2/4)*Power(10,db_m/10))) as db_m FROM hcn_roads_dbm_global where db_m>0;createtable LE_HCJ asSELECT the_geom,10*(Log10((1/4)*Power(10,db_m/10))) as db_m FROM hcj_roads_dbm_global where db_m>0;createtable LE_HPS asSELECT the_geom,10*(Log10((1/4)*Power(10,db_m/10))) as db_m FROM hps_roads_dbm_global where db_m>0;
First is Night, second is day third is evening.
You can after merge the levels using energetic sum or by concatenate the tables using UNION ALL query.
2/4, 1/4 and 1/4 must fit with the time range of emission levels.
-- Nicolas Fortin
IRSTV FR CNRS 2488
Spatial DB http://h2gis.org
Le 2015-02-25 14:05, Rodolphe [via OrbisGIS] a écrit :
Thanks, but there is something I don't understand. I am currently using OrbisGis version 5.0.0 and I have only access to an SQL Console. The script does not seem to be directly in SQL.
On the V3.0 documentation, I have read there is a Beanshell’s console but never find it. So I assume it is the code for the Beanshell’s console but how can I make this console appear ?