[OSM-newbies] Export Question

Jack Stringer jack.ixion at googlemail.com
Wed Jul 1 09:05:19 BST 2009


I manged to extract the data for all fastfood places in the uk.

I am just thinking what info needs to be added. Operator. Postcode. Street
name. City etc. I assume there is a tag for telephone number but I have yet
to find it.

I think we also need to work on naming of places as there are several
spellings for McD. There is also quite a few fast food places with no name.

I loaded all the data into josm and had a edit of one place. But if I was to
upload the data will it just update that node and any nodes I have not
edited won't be touched, is that correct. I don't want to messup osm.

Jack

On Jul 1, 2009 8:46 AM, "Peter Childs" <pchilds at bcs.org> wrote:

2009/6/30 Dirk-Lüder Kreie <osm-list at deelkar.net>:

> Jack Stringer schrieb: >> If I wanted to export an XML file of all Food
places with the name KFC >...

> _______________________________________________ > newbies mailing list >
newbies at openstreetmap.org...
This does not answer the question but never mind.

If you use osmisis to load the planet (or part there of) into a
database, you can search for all the KFC with the following SQL

select * from node_tags a, node_tags b, nodes where
a.node_id=b.node_id and a.k='name' and a.v='KFC' and b.k='amenity' and
b.v='fast_food' and nodes.id=a.node_id;

I keep meaning to write a cheat sheet and put it on the wiki for doing
this.  The seam to be 72 in the Uk which seams like quite a lot.

Other Fast Food, Fried Chicken outlets are available.

Peter.

_______________________________________________ newbies mailing list
newbies at openstreetmap.org http...
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/newbies/attachments/20090701/d542b169/attachment.html>


More information about the newbies mailing list