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&value=pipeline&types=lines&BBOX=11.740278,50.862222,14.140278,52.062222
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 _______________________________________________ Maps-l mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/maps-l
