[OSM-talk] Mysterious PostGIS Problem with Polygons
John Smith
delta_foxtrot at yahoo.com
Sat Aug 22 07:00:35 BST 2009
--- On Sat, 22/8/09, Jon Burgess <jburgess777 at googlemail.com> wrote:
> In part it could be caused by invalid geometries. Postgis
> reports that
> only Polska is actually a valid polygon geometry. Any
> errors could upset
> algorithms like ST_Within().
>
> gis=> select name,isvalid(way) from planet_osm_polygon
> where
> boundary='administrative' AND admin_level='2' AND name in
> ('Deutschland','Danmark','Polska','Nederland','Australia','Italia');
> NOTICE: Hole lies outside shell
> name | isvalid
> -------------+---------
> Australia | f
Is Australia listed as false because the polygon used doesn't just cover Australia but 4 or so external territories? These are islands in the Pacific and Indian Oceans.
More information about the talk
mailing list