[postgis-users] topology exception??
Brian Hamlin
maplabs at light42.com
Sat Oct 13 22:35:59 PDT 2007
after backing up, I built and installed postGIS 1.3.1. I am trying a
few more queries..
However, almost immediately I ran into
TopologyException: side location conflict xxx yyyy
ERROR: GEOS within() threw an error!
SQL State: XX000
I can reproduce it with a certain point, as in
SELECT count(*) FROM just_ca
WHERE st_within('POINT(-121.552 38.5126)', just_ca.the_geom)
and also
SELECT count(*) FROM just_ca, gectable
WHERE just_ca.city = 'San Francisco'
AND
st_within( SetSRID(gectable.geom_pts2,4326),
SetSRID( just_ca.the_geom,4326) )
TopologyException:... -122.422 37.7728
ok, so I attempted to add an isValid() constraint to check things,
and yes, it failed..I have about 1200 polys.. how to find the failures,
and why?
and what is this topology exception?
thanks in advance
-Brian
More information about the postgis-users
mailing list