This does sound like a job for PostGIS raster in v2.0. I hope to do the same in the near future. You can query values (ST_Value) and perform other functions listed here<br><br><a href="http://postgis.refractions.net/documentation/manual-svn/RT_reference.html">http://postgis.refractions.net/documentation/manual-svn/RT_reference.html</a><br>
<br>Generating maps from PostGIS rasters would come through GDAL (MapServer, Quantum GIS) and others.<br><br>- John<br><br clear="all">***********************************<br>John Callahan, Research Scientist<br>Delaware Geological Survey<br>
University of Delaware<br>URL: <a href="http://www.dgs.udel.edu" target="_blank">http://www.dgs.udel.edu</a><br>*******************************<br>
<br><br><div class="gmail_quote">On Mon, May 9, 2011 at 11:28 AM, Stephen Crawford <span dir="ltr"><<a href="mailto:src176@psu.edu">src176@psu.edu</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Hi,<br>
<br>
How do I best use gridded data in postgres-postgis (I've only used vector data before)?<br>
<br>
I want to use daily weather variables that are in a grid for USA. I would want store the daily variables ( a new grid each day) so I can have a database that will allow the client to send a point lat/lon and then return a calculation based on a few days worth of two or three variables.<br>
<br>
Do I store each day (or variable) as a new table? How does a grid get stored in postgres? Is this a job for PostGIS Raster (though I do not want to produce images, just queries at a point)?<br>
<br>
Any thoughts on this will be greatly appreciated.<br>
<br>
Thanks,<br>
Steve<br>
<br>
<br>
-- <br>
Stephen Crawford<br>
Center for Environmental Informatics<br>
The Pennsylvania State University<br>
<a href="mailto:src176@psu.edu" target="_blank">src176@psu.edu</a><br>
<br>
<br>
<br>
_______________________________________________<br>
postgis-users mailing list<br>
<a href="mailto:postgis-users@postgis.refractions.net" target="_blank">postgis-users@postgis.refractions.net</a><br>
<a href="http://postgis.refractions.net/mailman/listinfo/postgis-users" target="_blank">http://postgis.refractions.net/mailman/listinfo/postgis-users</a><br>
</blockquote></div><br>