[postgis-users] Problem with Geomunion after upgrade

[Ethan Alpert]

Here's an example:

spatialdb=> select isvalid(the_geom), the_geom from snaps where stripid
='1010010003623C00';
 isvalid |
the_geom

---------+--------------------------------------------------------------
------------------------------------------------------------------------
--------------------------------------------------------
 t       | SRID=4326;POLYGON((-93.4522944444444
18.2313055555556,-93.2902638888889 18.2283027777778,-93.2910694444444
18.0634,-93.4521916666667 18.0660055555556,-93.4522944444444
18.2313055555556))
 t       | SRID=4326;POLYGON((-93.4523444444444
18.0946944444444,-93.2908472222222 18.0919777777778,-93.2912
17.9268111111111,-93.4519333333333 17.9290777777778,-93.4523444444444
18.0946944444444))
 t       | SRID=4326;POLYGON((-93.4521361111111
17.9578083333333,-93.2910638888889 17.9554111111111,-93.291025
17.7985222222222,-93.4514666666667 17.8003916666667,-93.4521361111111
17.9578083333333))
(3 rows)

spatialdb=> select geomunion(the_geom) from snaps where stripid
='1010010003623C00';
 
geomunion

------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
-----------------------------------
 SRID=-1;POLYGON((-93.4521361111111 17.9578083333333,-93.4520046464836
17.957806376758,-93.4523444444444 18.0946944444444,-93.4522095030064
18.0946921744926,-93.4522944444444 18.2313055555556,-93.2902638888889
18.2283027777778,-93.2909298342606 18.0919791674573,-93.2908472222222
18.0919777777778,-93.2911389111705 17.9554122276604,-93.2910638888889
17.9554111111111,-93.291025 17.7985222222222,-93.4514666666667
17.8003916666667,-93.4521361111111 17.9578083333333))
(1 row)



-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of
Ethan Alpert
Sent: Monday, November 15, 2004 12:25 PM
To: PostGIS Users Discussion
Subject: [postgis-users] Problem with Geomunion after upgrade




I upgraded to 0.9.0 (I'll have a post on what a PITA that was soon)

Was it always the case that Geomunion returns and SRID=-1 ? I'm doing a
geomunion of a table in which all geometries are SRID=4326. How come
geomunion now drops the SRID? If this has always been the case then does
that mean prior to 0.9.0 constaints weren't being checked?

-e
_______________________________________________
postgis-users mailing list postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users