[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Raster/vector intersections with PostGIS
From:       "Paragon Corporation" <lr () pcorp ! us>
Date:       2010-06-29 18:51:31
Message-ID: AD04D22601C4485FAB19FE6D96CF6DFD () J
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


Just to add to Pierre's note,
 
We have windows binaries available that have the new functionality.
 
http://www.postgis.org/download/windows/experimental.php#wktraster
 
These binaries should work for PostGIS 1.4/1.5
 
and PostgreSQL -- 8.3, 8.4, 9.0
 
Please give it a try and submit bugs.  We like bug reports.
http://trac.osgeo.org/postgis/
 
Regina and Leo
http://www.postgis.us
 
 

  _____  

From: postgis-users-bounces@postgis.refractions.net
[mailto:postgis-users-bounces@postgis.refractions.net] On Behalf Of George
Silva
Sent: Tuesday, June 29, 2010 1:56 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Raster/vector intersections with PostGIS
WKTRaster


Congratulations on the great job done!

George


On Tue, Jun 29, 2010 at 12:55 PM, Nicolas Ribot <nicolas.ribot@gmail.com>
wrote:


Waoo !
Real nice.

Thank you for this work.

Nicolas


On 29 June 2010 17:29, Pierre Racine <Pierre.Racine@sbf.ulaval.ca> wrote:
> Hi everybody,
>
> 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).
>
> 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:
>
> SELECT polyid,
>       (ST_Intersection(the_geom, rast)).geom,
>       (ST_Intersection(the_geom, rast)).val
> FROM my_polygons, srtm_tiled
> WHERE ST_Intersects(rast, the_geom)
>
> or, a bit more complex, but much faster and returning the same result:
>
> SELECT polyid, (gv).geom, (gv).val
> FROM (SELECT polyid, ST_Intersection(the_geom, rast, 1) AS gv
>     FROM my_polygons, srtm_tiled
>     WHERE ST_Intersects(rast, the_geom)) foo
>
> 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).
>
> You will find a complete tutorial on how to use those two new functions
here: http://trac.osgeo.org/postgis/wiki/WKTRasterTutorial01. A reference is
available here:
http://postgis.refractions.net/documentation/manual-svn/RT_reference.html
and chapter 13 of "PostGIS in Action" is also a very good introduction to
WKT Raster.
>
> Compilation and installation info are available in the project home page:
http://trac.osgeo.org/postgis/wiki/WKTRaster
>
> 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.
>
> 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.
>
> Let us know your need and your experience with WKT Raster.
>
> Thanks,
>
> Pierre Racine
>
> _______________________________________________
> postgis-users mailing list
> postgis-users@postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users





-- 
George R. C. Silva

Desenvolvimento em GIS
http://blog.geoprocessamento.net


[Attachment #5 (text/html)]

<!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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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>&nbsp;</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.&nbsp; We like bug 
reports.&nbsp; <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>&nbsp;</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>&nbsp;</DIV>
<DIV dir=ltr align=left><SPAN class=145404818-29062010><FONT color=#0000ff 
size=2 face=Arial></FONT></SPAN>&nbsp;</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>&lt;<A 
href="mailto:nicolas.ribot@gmail.com">nicolas.ribot@gmail.com</A>&gt;</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 &lt;<A 
  href="mailto:Pierre.Racine@sbf.ulaval.ca">Pierre.Racine@sbf.ulaval.ca</A>&gt; 
  wrote:<BR>&gt; Hi everybody,<BR>&gt;<BR>&gt; 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>&gt;<BR>&gt; 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>&gt;<BR>&gt; SELECT 
  polyid,<BR>&gt; &nbsp; &nbsp; &nbsp; (ST_Intersection(the_geom, 
  rast)).geom,<BR>&gt; &nbsp; &nbsp; &nbsp; (ST_Intersection(the_geom, 
  rast)).val<BR>&gt; FROM my_polygons, srtm_tiled<BR>&gt; WHERE 
  ST_Intersects(rast, the_geom)<BR>&gt;<BR>&gt; or, a bit more complex, but much 
  faster and returning the same result:<BR>&gt;<BR>&gt; SELECT polyid, 
  (gv).geom, (gv).val<BR>&gt; FROM (SELECT polyid, ST_Intersection(the_geom, 
  rast, 1) AS gv<BR>&gt; &nbsp; &nbsp; FROM my_polygons, srtm_tiled<BR>&gt; 
  &nbsp; &nbsp; WHERE ST_Intersects(rast, the_geom)) foo<BR>&gt;<BR>&gt; 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>&gt;<BR>&gt; 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>&gt;<BR>&gt; 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>&gt;<BR>&gt; 
  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>&gt;<BR>&gt; 
  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>&gt;<BR>&gt; Let us know your need and your 
  experience with WKT Raster.<BR>&gt;<BR>&gt; Thanks,<BR>&gt;<BR>&gt; Pierre 
  Racine<BR>&gt;<BR>&gt; _______________________________________________<BR>&gt; 
  postgis-users mailing list<BR>&gt; <A 
  href="mailto:postgis-users@postgis.refractions.net">postgis-users@postgis.refractions.net</A><BR>&gt; \
  <A href="http://postgis.refractions.net/mailman/listinfo/postgis-users" 
  target=_blank>http://postgis.refractions.net/mailman/listinfo/postgis-users</A><BR>&gt;<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>




_______________________________________________
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread] 

Configure | About | News | Add a list | Sponsored by KoreLogic