In my usecase I want to use OSM data for my routing server, but first, I'd like to add elevation data. And I'd prefer to do that in postgis as I'd need to do further analysis of the data using postgis.
So my question is which tools I should use for that task?
I've found osmosis
but so far I haven't managed to export data using that tool. With osm2pgsql
I haven't found a way to export data again.
I guess I would use gdal to somehow import the elevation information from a raster-source? But how would a proper postgis sql command for that look?
EDIT: My raster file is a .vrt file that combines about 3TB of data. So loading the whole raster into a DB will now work. I'd need a solution to go through each geometry in my DB and convert it from 2D to 3D.