[gdal-dev] Storing Gdal datasets in Postgis

Ricardo Cezar Bonfim Rodrigues rikardocezar at msn.com
Mon Mar 1 07:37:06 EST 2010

Hi Jorge,

I've implemented a customized gdal reader using the method readBlock instead of using RasterIO and now it seems to be much faster and will propably be adequate to my problem.
But thanks by the tips, I'll keep it in mind if I need it.

Ricardo Rodrigues

From: jorgearevalo at gis4free.org
Date: Mon, 1 Mar 2010 11:03:04 +0100
Subject: Re: [gdal-dev] Storing Gdal datasets in Postgis
To: rikardocezar at msn.com
CC: gdal-dev at lists.osgeo.org

On Fri, Feb 26, 2010 at 2:51 PM, Ricardo Cezar Bonfim Rodrigues <rikardocezar at msn.com> wrote:


I'm using Gdal to load dted files and get max elevations of a region, but I have constraints concerning speed. Inspite of loading geotifs generated from dted has reduced a lot the processing time, its still not enough to the constraints I have. I'm loading geotiffs which represents dted L1 files, reading its points using rasterIO and verifying the max elevation of a rectangle area given ( lat, lon, width).

I've noticed the more expensive is the data reading, so I'm thinking about storing the dted (or geotiff) files in a Postgis. Would it increase the search speed?
Does anyone know the best way to store dted files in a Postgis? I thought about storing geotiffs (generated from deted using gdal), but I dont now exactly how it would work. I know there are spatial queries in Postgis and I think it would be very useful in my case.

I look forwarding to receving any tip of how to do this.

Thanks in Advance,

Ricardo Rodrigues

Hi Ricardo,
If you're planning to manage raster data in PostGIS, you should know we're working in a new extension (WKT Raster). Check this: http://trac.osgeo.org/postgis/wiki/WKTRaster

It's under development yet, just like the GDAL WKT Raster driver: http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html

Most of the spatial queries involving rasters are under development, I say, but it may be useful for you in the future... Keep an eye.
Best regards,Jorge 


gdal-dev mailing list

gdal-dev at lists.osgeo.org


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/gdal-dev/attachments/20100301/8cb94b7f/attachment.html

More information about the gdal-dev mailing list