[postgis-users] ST_Buffer + grid problem

Ed Linde edolinde at gmail.com
Thu Mar 22 13:27:19 PDT 2012

Thanks. The raster I need to visualise is a 4m by 4m grid on the entire map
of Denmark! :)
So do you classify that as a large raster? If so is there a way to see a
portion of it or something?
I just want to manually check for a few areas on the map that the
intersection indeed works
as expected and things haven't gone awry thanks to projection differences
or that I had degrees
instead of meters or some such thing. Well, I still have to first test if
this GDAL upgrade will fix
things and if make empty raster .. makes a difference.

On Thu, Mar 22, 2012 at 9:07 PM, Pierre Racine
<Pierre.Racine at sbf.ulaval.ca>wrote:

> > Is there an OpenJump tutorial that shows how I can view rasters and
> geometries
> > from postgis? I do an "Add postgis layer" in QGis and clicking on the
> layer I can
> > set some SQL in there to filter the data coming back...but its still
> extremely slow!
> > So wouldn't mind figuring out how I can get OpenJump to work :)
> OpenJump is very simple. There is a Run Database Query in the file menu.
> Two details:
> -Make sure to surround every geometry with ST_Asbinary()
> -Rasters do not display native. You have to vectorize them with
> ST_DumpAsPolygons() or ST_PixelAsPolygons()
> A typical OpenJump to display raster:
> SELECT ST_AsBinary((gv).geom) geom, (gv).val
> FROM (SELECT ST_DumpAsPolygons(rast) gv FROM rastertable) foo
> do not do this with big rasters...
> Pierre
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120322/57566ecb/attachment.html>

More information about the postgis-users mailing list