[Tile-serving] [osm2pgsql] Adding new tags to stylesheets (#88)

[AndrewBuck]

I would advocate for option 4 as well.  OSM basically has only 2 or 3 really common tags with, I think, building=* and highway=* being the really common ones, with maybe landuse, or source being the next most common.

After these few tags, the number will drop off quite quickly.  So I would suggest having an actual column in the style file for the 5 or so most common tags (discounting discardable ones like tiger tags, etc) and then create an hstore column with everything else in it.   I would then create indexes on the next 10 or so most common tags for the hstore column.  I think that should give reasonable performance for a typical stylesheet, but for ones which use a lot of features not covered by these indices, they can then add their own indices on hstore as necessary.

-AndrewBuck

---
Reply to this email directly or view it on GitHub:
https://github.com/openstreetmap/osm2pgsql/issues/88#issuecomment-25336493
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/tile-serving/attachments/20130929/f26b49f4/attachment.html>