> 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@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
