Skip to main content
added 71 characters in body
Source Link
Georg
  • 1k
  • 1
  • 10
  • 21

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.

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?

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 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.

Source Link
Georg
  • 1k
  • 1
  • 10
  • 21

How to import OSM data into postgis and add Elevation Information from raster

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?