back to wiki main page [..]

https://land.copernicus.eu/imagery-in-situ/eu-dem/eu-dem-v1.1/view
Four tiles for Spain and portugal
------------
E20N20 E30N20 [[BR]]
E20N10 E30N10 [[BR]]
------------


{{{#!sh
raster2pgsql -t auto eu_dem_v11_E20N10.TIF altitude.eu_dem_v11_E20N10 | psql -U postgres -d eda2.3
}}} 
too long...
-I  Create a GIST spatial index on the raster column. The ANALYZE
      command will automatically be issued for the created index.
  -C  Set the standard set of constraints on the raster
      column after the rasters are loaded. Some constraints may fail
      if one or more rasters violate the constraint.
{{{#!sh
cd C:\Users\cedric.briand\Desktop\eu_dem_v11_E20N10
raster2pgsql -s 3035 -t 25x25 -I -C eu_dem_v11_E20N10.TIF altitude.eu_dem_v11_E20N10 | psql -U postgres -d eda2.3
}}} 

{{{#!sql
with centroid as
(select idsegment,ST_Centroid(geom) as geom from spain.rn),
  altitude as (
SELECT ST_Value(rast,geom) as alt, idsegment
FROM altitude.eu_dem_v11_e20n10 join centroid 
ON ST_Intersects(rast,  geom))
UPDATE spain.rna set altitudem = altitude.alt from altitude where rna.idsegment=altitude.idsegment; --52417 41.3
}}}

{{{#!sh
cd C:\Users\cedric.briand\Desktop\eu_dem_v11_E20N20
raster2pgsql -s 3035 -t 25x25 -I -C eu_dem_v11_E20N20.TIF altitude.eu_dem_v11_E20N20 | psql -U postgres -d eda2.3
}}}