[OSM-newbies] making a csv file of a data set

[wouter van der plas]

thank you both for your answers.
i have a nice csv file full of cites.
the only problem is finding the population.
but i will figure that out on my own.

best regards,

wouter van der plas


2014-03-22 17:46 GMT+01:00 Hermann Peifer <peifer at gmx.eu>:

> On 2014-03-22 1:34, wouter van der plas wrote:
>
>>
>> and therefor i'd like a csv file with all the tags so i can import them
>> to programs and find the data i need.
>>
>> so what i'm asking: is there a way to make a csv file with all the tags.
>> i am already familiar with with the csv function in osmconvert but this
>> tool needs you to know the tags before you run the program.
>>
>>
> $ ogr2ogr -f csv /dev/stdout liechtenstein-latest.osm.pbf points | head
>
> osm_id,place,all_tags
> 26860698,,"""name""=>""Mittagspitze"",""tourism""=>""camp_site"""
> 26863444,,"""name""=>""Kuhgrat"",""natural""=>""peak"""
> 32011241,suburb,"""name""=>""Oberplanken"",""place""=>""suburb"""
> 32020993,,"""railway""=>""level_crossing"""
> 49872384,,"""highway""=>""crossing"""
> 49872651,,"""information""=>""guidepost"",""name""=>""Schloss
> Vaduz"",""tourism""=>""information"""
> 49939577,,"""highway""=>""crossing"""
> 49939622,,"""highway""=>""crossing"""
> 50049362,,"""highway""=>""crossing"""
> 50069907,,"""amenity""=>""parking"""
> (...)
>
> ogr2ogr is a command line tool that converts between various vector file
> formats, see [0]. For the field definitions of the above example: see [1].
>
> I am not quite sure in how far ogr2ogr can attack the whole planet.
>
> Hermann
>
>
> [0] http://www.gdal.org/ogr_utilities.html
>
> [1]
>
> [points]
> # common attributes
> osm_id=yes
>
> # keys to report as OGR fields
> attributes=place
>
> # keys that, alone, are not significant enough to report a node as a OGR
> point
> unsignificant=created_by,converted_by,source,time,ele,attribution
>
> # keys that should NOT be reported in the "other_tags" field
> ignore=created_by,converted_by,source,time,ele,note,openGeoDB:,fixme,FIXME
>
> # uncomment to avoid creation of "other_tags" field
> #other_tags=no
>
> # uncomment to create "all_tags" field. "all_tags" and "other_tags" are
> exclusive
> all_tags=yes
>
>
>
> _______________________________________________
> newbies mailing list
> newbies at openstreetmap.org
> https://lists.openstreetmap.org/listinfo/newbies
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/newbies/attachments/20140323/dc4b0a73/attachment.html>