[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