Re: [postgis-users] selected aligned tiles in pgraster between several large raster tables.

2013-06-17 Thread Bborie Park
Graeme, robe2 and I were discussing this thread and we were wondering if using the ~= operator would work for your problem. http://www.postgis.net/docs/manual-2.0/ST_Geometry_Same.html -bborie On Mon, Jun 17, 2013 at 7:22 AM, Graeme B. Bell wrote: > > Hello bborie (and everyone else). > > To r

Re: [postgis-users] ST_AsPNG is problematic in Java

2013-06-17 Thread Bborie Park
Ahmet, Can you try one of the example code found in the docs? http://www.postgis.net/docs/manual-dev/using_raster_dataman.html#RT_Raster_Applications By testing out one of the examples, you should be able to tell if the problem is in the database or in your java code. -bborie On Mon, Jun 17, 2

Re: [postgis-users] selected aligned tiles in pgraster between several large raster tables.

2013-06-17 Thread Graeme B. Bell
Hello bborie (and everyone else). To recap. I'm trying to do some work with 4 gigantic raster tables which have been set up in the same way (e.g. georeferenced/tiled identically). I want to compare equivalent tiles in each raster with one another. Each raster has 7 million rows now but I'll b

Re: [postgis-users] ST_AsPNG is problematic in Java

2013-06-17 Thread Ahmet Temiz
hello postgresql (9.2.2) postgresql-jdbc 9.2 here is the result of SELECT postgis_full_version(); postgis_full_version POSTGIS="2.1.0SVN r10952" GE

Re: [postgis-users] ST_AsPNG is problematic in Java

2013-06-17 Thread Paragon Corporation
Which JDBC driver are you using and which PostgreSQL version. You might be affected by the escape/hex change in 9.0 detailed here: http://postgis.net/docs/manual-2.0/PostGIS_FAQ.html#id338804 _ From: postgis-users-boun...@lists.osgeo.org [mailto:postgis-users-boun...@lists.osgeo.org]

[postgis-users] ST_AsPNG is problematic in Java

2013-06-17 Thread Ahmet Temiz
hello I am dealing with java-jpa2-postgis(raster) I tried to get an image from postgis(raster) as: List list_rast = session.createSQLQuery("SELECT ST_AsPNG(rast) As rastpng FROM geoslp5 where rid=184 ;").list(); and converting object to byte[] and with usual java process ByteArrayOutputStream

[postgis-users] select two sides of a polygon

2013-06-17 Thread Pedro Costa
Hi guys, I have many polygons that I want to get the minimum width (FROM POINTS A TO B IN PRINT EXAMPLE)... I have search in the web many things. My problem is that don't know how to differentiate 'the two sides of the polygons' to get the shortest line between them... Anybody have a suggesti