[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