On Sun, 2009-05-10 at 13:19 +0100, Jon Burgess wrote:
> > I also tried to access "Thüringen" by its osm_id, but also no
> success.
> >
> > In "PSQL gis":
> >
> > gis=> select osm_id, name from planet_osm_polygon where name like
> > 'Thüringen'
> > limit 1000;
> > osm_id | name
> > --------+-----------
> > -76689 | Thüringen
> > (1 Zeile)
> >
> >
> > Can anybody tell me how to draw the three missing states?
> >
> > Is there an explanation why they are "missing"?
> >
>
> Since the entry is in the polygon table, the only obvious problem I
> can
> think of is the direction of the polygon, clockwise vs
> counter-clockwise. Mapnik & Postgis really want all polygons to be
> clockwise but the osm2pgsql code does not guarantee this. Try doing:
>
> $ psql gis
> gis=> update planet_osm_polygon set way=ST_Reverse(way) where
> osm_id=-76689;
>
> On older versions of postgis, ST_Reverse(way) might need to
> reverse(way).
>
This afternoon I committed a fix which should make osm2pgsql generate
all polygons with the rings in the correct direction. Try updating to
the latest SVN[1] code and importing the OSM data again.
Jon
1: The server hosting SVN and the talk mailing list is unavailable at
the moment.
_______________________________________________
talk mailing list
talk@openstreetmap.org
http://lists.openstreetmap.org/listinfo/talk
