<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=us-ascii" http-equiv=Content-Type>
<META name=GENERATOR content="MSHTML 8.00.7600.16588"></HEAD>
<BODY>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>Just to add to Pierre's note,</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>We have windows binaries available that have the new
functionality.</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.org/download/windows/experimental.php#wktraster">http://www.postgis.org/download/windows/experimental.php#wktraster</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>These binaries should work for PostGIS
1.4/1.5</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>and PostgreSQL -- 8.3, 8.4, 9.0</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>Please give it a try and submit bugs. We like bug
reports. <A
href="http://trac.osgeo.org/postgis/">http://trac.osgeo.org/postgis/</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial>Regina and Leo</FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial><A
href="http://www.postgis.us">http://www.postgis.us</A></FONT></SPAN></DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff
size=2 face=Arial></FONT></SPAN> </DIV><BR>
<DIV dir=ltr lang=en-us class=OutlookMessageHeader align=left>
<HR tabIndex=-1>
<FONT size=2 face=Tahoma><B>From:</B>
postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] <B>On Behalf Of
</B>George Silva<BR><B>Sent:</B> Tuesday, June 29, 2010 1:56 PM<BR><B>To:</B>
PostGIS Users Discussion<BR><B>Subject:</B> Re: [postgis-users] Raster/vector
intersections with PostGIS WKTRaster<BR></FONT><BR></DIV>
<DIV></DIV>Congratulations on the great job done!<BR><BR>George<BR><BR>
<DIV class=gmail_quote>On Tue, Jun 29, 2010 at 12:55 PM, Nicolas Ribot <SPAN
dir=ltr><<A
href="mailto:nicolas.ribot@gmail.com">nicolas.ribot@gmail.com</A>></SPAN>
wrote:<BR>
<BLOCKQUOTE
style="BORDER-LEFT: rgb(204,204,204) 1px solid; MARGIN: 0pt 0pt 0pt 0.8ex; PADDING-LEFT: 1ex"
class=gmail_quote>Waoo !<BR>Real nice.<BR><BR>Thank you for this
work.<BR><FONT color=#888888><BR>Nicolas<BR></FONT>
<DIV>
<DIV></DIV>
<DIV class=h5><BR>On 29 June 2010 17:29, Pierre Racine <<A
href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</A>>
wrote:<BR>> Hi everybody,<BR>><BR>> I'm pleased to announce that you
can now do intersections between rasters and geometries very much like you
used to do geometry/geometry intersections in PostGIS. For this, PostGIS WKT
Raster introduces two new functions to PostGIS: ST_Intersects(geometry,
raster, band) and ST_Intersection(geometry, raster, band).<BR>><BR>> As
its geometry/geometry sister, ST_Intersects(geometry, raster, band) returns
TRUE if the withvalue area of a raster or a raster tile (nodata value are
ignored) intersects a geometry and ST_Intersection(geometry, raster, band)
returns the geometry/value set of geometries representing the intersection
between the geometry and each polygonized group of pixel sharing a same value
from the raster and its associated value. Example:<BR>><BR>> SELECT
polyid,<BR>> (ST_Intersection(the_geom,
rast)).geom,<BR>> (ST_Intersection(the_geom,
rast)).val<BR>> FROM my_polygons, srtm_tiled<BR>> WHERE
ST_Intersects(rast, the_geom)<BR>><BR>> or, a bit more complex, but much
faster and returning the same result:<BR>><BR>> SELECT polyid,
(gv).geom, (gv).val<BR>> FROM (SELECT polyid, ST_Intersection(the_geom,
rast, 1) AS gv<BR>> FROM my_polygons, srtm_tiled<BR>>
WHERE ST_Intersects(rast, the_geom)) foo<BR>><BR>> These
functions works with any kind of geometry so you can intersect any road,
river, polygons or point layer with your favorite elevation or land cover
raster of any resolution and any size. You can also load any number of raster
in the database with one command line to constitute a unique table raster
coverage of any shape (no matter if your group of raster do not form a
rectangular coverage).<BR>><BR>> You will find a complete tutorial on
how to use those two new functions here: <A
href="http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01"
target=_blank>http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01</A>. A
reference is available here: <A
href="http://postgis.refractions.net/documentation/manual-svn/RT_reference.html"
target=_blank>http://postgis.refractions.net/documentation/manual-svn/RT_reference.html</A>
and chapter 13 of "PostGIS in Action" is also a very good introduction to WKT
Raster.<BR>><BR>> Compilation and installation info are available in the
project home page: <A href="http://trac.osgeo.org/postgis/wiki/WKTRaster"
target=_blank>http://trac.osgeo.org/postgis/wiki/WKTRaster</A><BR>><BR>>
These features are the result of two years of collaboration between many
people and companies interested in bringing raster into PostGIS. I would like
to thanks particularly Steve Cumming who initially made all this possible,
Sandro Santilli who wrote the base code, Mateusz Loskot who wrote the Python
loader, Jorge Arevalo who wrote the GDAL driver and ST_DumpAsPolygons(),
Regina and Leo Obe who are doing so many things and believed in the project
from the beginning by adding a chapter about WKT Raster in "PostGIS in Action"
and also David Zwarg who wrote most of the setter functions.<BR>><BR>>
This is the first step toward a first complete raster/vector analysis and
manipulation SQL API. We hope to make of PostGIS with WKT Raster the most
powerful and complete GIS analysis and manipulation high level language ever
(!!!). WKT Raster should normally be totally integrated into PostGIS in
PostGIS release 2.0. Upcoming functions should include ST_Reclass, ST_Clip,
ST_AsRaster, ST_Resample.<BR>><BR>> Let us know your need and your
experience with WKT Raster.<BR>><BR>> Thanks,<BR>><BR>> Pierre
Racine<BR>><BR>> _______________________________________________<BR>>
postgis-users mailing list<BR>> <A
href="mailto:postgis-users@postgis.refractions.net">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>><BR>_______________________________________________<BR>postgis-users
mailing list<BR><A
href="mailto:postgis-users@postgis.refractions.net">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></DIV></DIV></BLOCKQUOTE></DIV><BR><BR
clear=all><BR>-- <BR>George R. C. Silva<BR><BR>Desenvolvimento em GIS<BR><A
href="http://blog.geoprocessamento.net">http://blog.geoprocessamento.net</A><BR></BODY></HTML>