[OSM-dev] osm2pgsql hstore support

Sven Geggus lists at fuchsschwanzdomain.de
Sun Mar 14 16:22:17 GMT 2010


Martijn van Oosterhout schrieb am Sonntag, den 14. März um 17:06 Uhr:

> Very cool. Now we just need to find a way to use it. I thought about
> it earlier but I didn't see a way to make mapnik use it so left it.

This won't work?!

I didn't bother with this yet, but I just thougt that all I would
need to do is replacing SQL statements.

Currently we have something like this:

select way,man_made FROM planet_osm_point;

Now we would just need something like this:

select way,(tags->'man_made') as man_made FROM planet_osm_point where ((tags->'man_made') is not NULL);

What am I getting wrong here?

Regards

Sven

-- 
Kernel panic: I have no root and I want to scream
(Linux Kernel Error Message)

/me is giggls at ircnet, http://sven.gegg.us/ on the Web




More information about the dev mailing list