I've done this before using a similar approach you have and using GDAL to read the elevations from the GeoTiff and dump them into an elevations table with point geoms. If I had to do it again, now that we have WKT Raster in the works, I'd probably try that if you don't mind compiling yourself.
http://trac.osgeo.org/postgis/wiki/WKTRaster Mateusz has a nice test drive example of WKTRaster http://mateusz.loskot.net/2009/03/30/crunching-wkt-rasters/ Hope that helps, Regina -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of yoda2nd Sent: Thursday, April 16, 2009 6:06 PM To: PostGIS User Group Subject: [postgis-users] Rasters in PostGIS Hello All, I am working on a project where we need to be able to query a raster image (i.e. GeoTiff) to obtain elevation information. Basically, I need to be able to import a rather large data set and be able to query it on demand and export just the data I need at the time back into a raster format for further processing (very similar to the USGS Seamless Data server). I am thinking importing the raster data as individual points (x,y,z) in the EWKT format is probably my best bet. I am not totally sure I am on the right track here, so I am hoping someone can let me know if I am going down the right track or nudge me back onto it. So I just have a few basic questions: _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
