...@postgis.refractions.net [mailto:postgis-users-
boun...@postgis.refractions.net] On Behalf Of Paolo Cavallini
Sent: Thursday, July 26, 2012 1:33 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] ST_Clip
Il 26/07/2012 01:54, Pierre Racine ha scritto:
Is this table tiled
Il 26/07/2012 16:33, Pierre Racine ha scritto:
So the big square, in your image, is a whole 64x64 tile?
not; I tried with a smaller buffer, I obtained a smaller square.
I gave a try to the same kind of query here and everything is fine. Are you
sure the circle is the same geometry used to
Paolo
I am not sure if this is related to your issue but you may want to
upgrade to GEOS 3.3.5 as there was an issue in 3.3.3 and 3.3.4
http://trac.osgeo.org/geos/ticket/558
Regards
Stefano
---
41.95581N 12.52854E
Il 26/07/2012 17:23, Stefano Iacovella ha scritto:
Paolo
I am not sure if this is related to your issue but you may want to
upgrade to GEOS 3.3.5 as there was an issue in 3.3.3 and 3.3.4
http://trac.osgeo.org/geos/ticket/558
Thanks Stefano. I do not understand how this bug could affect my
Cavallini
Sent: Thursday, July 26, 2012 10:53 AM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] ST_Clip
Il 26/07/2012 16:33, Pierre Racine ha scritto:
So the big square, in your image, is a whole 64x64 tile?
not; I tried with a smaller buffer, I obtained a smaller
Il 26/07/2012 19:39, Pierre Racine ha scritto:
What happen if do a query like this:
SELECT (gv).geom, (gv).val
FROM (SELECT
ST_PixelAsPolygons(ST_AsRaster(ST_Buffer(ST_Centroid(ST_Envelope(rast)),
0.5000), rast, ST_BandPixelType(rast, 1), 1, -1)) gv
FROM hdr
WHERE rid = 4
)
Il 26/07/2012 19:54, Paolo Cavallini ha scritto:
Il 26/07/2012 19:39, Pierre Racine ha scritto:
What happen if do a query like this:
SELECT (gv).geom, (gv).val
FROM (SELECT
ST_PixelAsPolygons(ST_AsRaster(ST_Buffer(ST_Centroid(ST_Envelope(rast)),
0.5000), rast, ST_BandPixelType(rast, 1),
: Thursday, July 26, 2012 2:04 PM
To: postgis-users@postgis.refractions.net
Subject: Re: [postgis-users] ST_Clip
Il 26/07/2012 19:54, Paolo Cavallini ha scritto:
Il 26/07/2012 19:39, Pierre Racine ha scritto:
What happen if do a query like this:
SELECT (gv).geom, (gv).val
FROM (SELECT
Is this table tiled? Why does your WHERE is about the rid and not
ST_Intersects(rast, geom)?
Pierre
From: postgis-users-boun...@postgis.refractions.net
[postgis-users-boun...@postgis.refractions.net] On Behalf Of Paolo Cavallini
[cavall...@faunalia.it]
Il 26/07/2012 01:54, Pierre Racine ha scritto:
Is this table tiled?
yes, -t 64x64
Why does your WHERE is about the rid and not ST_Intersects(rast, geom)?
To make the clip on a tile only, and test how it works, I started
following the example in http://www.postgis.org/docs/RT_ST_Clip.html ,
but
10 matches
Mail list logo
