Advertisement
This is comment for paste
Untitled
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT m.name_2 AS Kommun,
- rasdaman.aggregated_result_numeric(CONCAT('select avg_cells(clip((c[20, 0:* , 0:*]*0.02) - 273.15,',rasdaman.geo_index2grid_index(ST_AsText((ST_Dump(m.geom)).geom)),')) from Surface_Temperature_Sweden AS c')) AS avg_temp_°C ,
- rasdaman.aggregated_result_numeric(CONCAT('select max_cells(clip((c[20, 0:* , 0:*]*0.02) - 273.15,',rasdaman.geo_index2grid_index(ST_AsText((ST_Dump(m.geom)).geom)),')) from Surface_Temperature_Sweden AS c')) AS max_temp_°C ,
- rasdaman.aggregated_result_numeric(CONCAT('select min_cells(clip((c[20, 0:* , 0:*]*0.02) - 273.15,',rasdaman.geo_index2grid_index(ST_AsText((ST_Dump(m.geom)).geom)),')) from Surface_Temperature_Sweden AS c')) AS min_temp_°C
- FROM municipalswe as m
- WHERE m.name_2 in ('Åsele',
- 'Dorotea',
- 'Lycksele',
- 'Linköping',
- 'Malå',
- 'Sorsele');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement