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
<[email protected]
<mailto:[email protected]>>:
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
[email protected]
<mailto:[email protected]>
https://lists.openstreetmap.__org/listinfo/newbies
<https://lists.openstreetmap.org/listinfo/newbies>
_______________________________________________
newbies mailing list
[email protected]
https://lists.openstreetmap.org/listinfo/newbies
