Hello, thank you Kai for your "@>" hint.
It works now also fine on huge areas with rare objects (pipelines): http://toolserver.org/~kolossos/qtm2/queryinmap.php?name=*&key=man_made&...
Amazing. ----
Kai Krueger schrieb:
Can you not use the the osm_id to link to objects?
No, a street with a bridge in the middle have more than one osm_id and this IDs are changing with each new segment. My plan for the future is to link from Wikipedia-articles to complex OSM-Objects and this links should be human-readable, powerfull and long-time stable so I decide to use BBOX, key=value, name and/or ref.
---- One hint from my side: OSM key-values can contain whitespaces so we need doubleqoute: (tags @> '"ref"=>"A 4"') works fine.
---- For the indexes on name and ref I will test next week if I could live also with the index of hstore.
Greetings Kolossos