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

[wouter van der plas]

i know how to get the population of everyting. what i would like to have is
a way so i can add the population to cities were it is missing.

for example in china there are a lot of cities but none have a population
or a wiki tag were i could find the population




2014-03-23 12:47 GMT+01:00 Hermann Peifer <peifer at gmx.eu>:

> Wouter,
>
> Maybe I wasn't clear enough, but what I indicated was a csv extraction of
> nodes (in OGR kown as: points) plus all the key/value pairs of the tags, as
> you indicated that you wanted "all the tags".
>
> But actually the only meaningful tag for population values is the ...
> (surprise!) ...  population tag, see http://taginfo.osm.org/keys/
> population#overview
>
> So you'd just have to filter the input file in order to get all nodes and
> relations with a population tag, and the result for the planet should be
> some 278000 nodes and 34000 relations with a population value, as indicated
> on the taginfo website.
>
> I'd do something like this (taking Brazil as an example OSM data file):
>
> osmosis -q --rb brazil-latest.osm.pbf \
>     --tf accept-nodes population=* \
>     --tf reject-ways \
>     --tf accept-relations population=* \
>     --used-node \
>     --buffer bufferCapacity=6000
>     --wx - |
> xmlstarlet sel -T -t -m "/osm/node|/osm/relation" \
>   -v "tag[@k='name']/@v" -o ";" \
>   -v "tag[@k='population']/@v" -n
>
> Sample output below, sorted by descending population value.
>
> Hope this helps, Hermann
>
> Argentina;40677348
> São Paulo;11821876
> Rio de Janeiro;6429923
> Uruguay;3286314
> Salvador;2883672
> Brasília;2789761
> Fortaleza;2551805
> Belo Horizonte;2479175
> Manaus;1982179
> Curitiba;1848943
> Recife;1599514
> Porto Alegre;1467823
> Belém;1425923
> Goiânia;1393579
> Guarulhos;1299249
> Campinas;1144862
> São Luís;1053919
> São Gonçalo;1025507
> Maceió;996736
> Loreto;891732
> Duque de Caxias;873921
> Natal;853929
> Teresina;836474
> Campo Grande;832350
> Londrina;800566
> João Pessoa;769604
> Jaboatão dos Guararapes;675599
> Uberlândia;646673
> Contagem;637961
> Aracaju;614577
>
>
>
> On 2014-03-23 11:48, wouter van der plas wrote:
>
>> 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
>> <mailto: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
>>
>>     <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
>>     <mailto:newbies at openstreetmap.org>
>>     https://lists.openstreetmap.__org/listinfo/newbies
>>     <https://lists.openstreetmap.org/listinfo/newbies>
>>
>>
>>
>>
>>
>
>
> _______________________________________________
> 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/f7cdf621/attachment.html>