Advertisement
aghoshpro
Jul 7th, 2023
32
0
Never
This is comment for paste Untitled
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT m.name_2 AS Kommun,
  2. 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 ,
  3. 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 ,
  4. 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
  5. FROM municipalswe as m
  6. WHERE m.name_2 in ('Åsele',
  7. 'Dorotea',
  8. 'Lycksele',
  9. 'Linköping',
  10. 'Malå',
  11. 'Sorsele');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement