Is there a PostGIS solution to a 3D intersection between a DEM raster (with elevation in band 1) and a 3D line?
Here are some facts:
- Rasters only support 2D processing so I can't use ST_3DIntersects directly unless I could convert the rater to a 3D TIN or some other 3D geometry. If I could do this I could use ST_3DIntersects.
- However there isn't a raster to TIN method and the only potential option to convert a raster to 3D Geometry (ST_DRAPE https://trac.osgeo.org/postgis/ticket/2327) is not yet implemented in PostGIS.
Here are two potential solutions that would be desirable but do not seem available:
- a custom 3D raster intersection OR
- a raster to 3d geomtery conversion so I could use ST_3DIntersects.