Hi all
The parking styles partially fail with the newly imported database.
Am 25.11.2011 09:56, schrieb Kai Krueger:
[...] progress on updating the software stack (The
re-import will occur into a postgresql 9.1 database with the latest
osm2pgsql) [...]
Maybe it is due to the latest osm2pgsql.
The import is intended to occur with the default set
of db columns
together with the hstore extensions.
The problem is that not all tags are present in the hstore any
more, unlike in the old database. The tags available in other
columns are left out in the hstore.
Here is an example for the "amenity" tag missing:
osm_mapnik=> select amenity,tags->'amenity' as "hstore-amenity"
from
planet_polygon where osm_id=32550266;
amenity | hstore-amenity
---------+----------------
parking |
(1 row)
here is how it looked before the new import:
osm_mapnik=> select amenity,tags->'amenity' as "hstore-amenity"
from
planet_polygon where osm_id=32550266;
amenity | hstore-amenity
---------+----------------
parking | parking
(1 row)
(If you happen to be a subscriber of mapnik-de there has been the
same issue with osm2pgsql, but it has been changed back to the old
behaviour. See thread here:
https://lists.openstreetmap.de/mailman/private/mapnik-de/2011-July/000067.h…
login needed.)
Of course it is a space advantage not to repeat each tag existing
in a regular column in the "tags" hstore again, but on the other
side, stylesheets have to be always adapted if the osm2pgsql config
file is changed. Plus they will no longer be portable across servers
with different osm2pgsql configurations.
Would it be possible to re-import the hstore?
Kind regards,
Kay