<html>
<head>
<style><!--
.hmmessage P
{
margin:0px;
padding:0px
}
body.hmmessage
{
font-size: 10pt;
font-family:Verdana
}
--></style>
</head>
<body class='hmmessage'>
Hi Jorge,<br><br>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.<br>But thanks by the tips, I'll keep it in mind if I need it.<br><br>Ricardo Rodrigues<br>Brazil<br><br><hr id="stopSpelling">From: jorgearevalo@gis4free.org<br>Date: Mon, 1 Mar 2010 11:03:04 +0100<br>Subject: Re: [gdal-dev] Storing Gdal datasets in Postgis<br>To: rikardocezar@msn.com<br>CC: gdal-dev@lists.osgeo.org<br><br>On Fri, Feb 26, 2010 at 2:51 PM, Ricardo Cezar Bonfim Rodrigues <span dir="ltr"><<a href="mailto:rikardocezar@msn.com">rikardocezar@msn.com</a>></span> wrote:<br><div class="ecxgmail_quote"><blockquote class="ecxgmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div>
Hi,<br><br>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).<br>
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?<br>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.<br>
<br>I look forwarding to receving any tip of how to do this.<br><br>Thanks in Advance,<br><br>Ricardo Rodrigues<br>Brazil<br> </div>
<br></blockquote><div><br></div><div>Hi Ricardo,</div><div><br></div><div>If you're planning to manage raster data in PostGIS, you should know we're working in a new extension (WKT Raster). Check this: <a href="http://trac.osgeo.org/postgis/wiki/WKTRaster">http://trac.osgeo.org/postgis/wiki/WKTRaster</a></div>
<div><br></div><div>It's under development yet, just like the GDAL WKT Raster driver: <a href="http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html">http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html</a></div><div>
<br>
</div><div>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.</div><div><br></div><div>Best regards,</div><div>Jorge</div><div> </div><blockquote class="ecxgmail_quote" style="border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
_______________________________________________<br>
gdal-dev mailing list<br>
<a href="mailto:gdal-dev@lists.osgeo.org">gdal-dev@lists.osgeo.org</a><br>
<a href="http://lists.osgeo.org/mailman/listinfo/gdal-dev">http://lists.osgeo.org/mailman/listinfo/gdal-dev</a><br></blockquote></div><br> </body>
</html>