Hi,
As usual with SQL, there must be several other ways to perform the same
query.
As the edge view stores 2 faces id per row (left and right), I duplicated
the joins to join both left_face and right face against the original
polygon table (p1 and p2 aliases)
Nicolas
On 8 February 2015 at
Dear PostGIS users,
I am currently planning to set up a PostGIS instance for my lab. Turns out
I believe this would be useful for the whole center, so that I'm now
considering setting up a PostGIS server for everyone—if interest is shared
of course. At the moment, I am however struggling with
Hi,
1. I advanced ...and I used the topology.toTopoGeom() and now the relation
is populated.
2. I try to understand the following join
*pe.parcelle** p1 on (1, (p1.topo).id) *= (r1.layer_id, r1.topogeo_id)
the second part of the join is clear -- comes from the relation table
however the first
On Sun, Feb 8, 2015 at 9:31 PM, John Abraham j...@hbaspecto.com wrote:
Well I could say that using PostGIS ST_Intersects with messy data always
seems to give me TopologyExceptions. I've had luck with various
combinations of ST_SnapToGrid and ST_Buffer(0), but with messy data there
always
Hey,
I executed your data,
the following command solve the problem (with very recent GEOS for me)
(POSTGIS=2.2.0dev r12846 GEOS=3.5.0dev-CAPI-1.9.0 r0 PROJ=Rel. 4.8.0,
6 March 2012 GDAL=GDAL 2.0.0dev, released 2014/04/16 LIBXML=2.8.0
RASTER)
:
DROP TABLE IF EXISTS unique_polygon ;
CREATE TABLE
Hey Sandro,
this is a precision related issue,
coordinates are way too big and should be translated.
Cheers,
Rémi-C
2015-02-09 12:25 GMT+01:00 Sandro Santilli s...@keybit.net:
On Tue, Feb 03, 2015 at 11:28:35AM -0500, BladeOfLight16 wrote:
On Tue, Feb 03, 2015 at 11:28:35AM -0500, BladeOfLight16 wrote:
https://drive.google.com/file/d/0B_6I7kRgE8teVUpha2Q4ZlNDMWs/view?usp=sharing.
...
DO $$
DECLARE problem_row error_generating_polygons%ROWTYPE;
BEGIN
FOR problem_row IN (SELECT * FROM error_generating_polygons) LOOP
Hi Nicolas,
1. I used ST_CreateTopoGeo() to build the topology (not the
topology.toTopoGeom()
as you mentioned )
When I look at the relation table its empty ? should I use
topology.toTopoGeom()
instead, and it will populate it ?
2. can you explain what the parentheses (special the 1, ...)