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
E20N10 E30N10

---

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.

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

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

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