Is it posible to extract data from OpenStreetMap that only contains the name of a city and the name of the state from these city?
I want to build a CSV file, where each row contains "city;state". For example:
San Francisco;California Annapolis;Marryland ....
At the moment I'm using osmfilter and osmconvert to create a file from all cities.
osmfilter file.o5m --keep="place=city or ( place=town and population>=1000 )" --drop-relations --drop-ways > cities.osm osmconvert cities.osm --all-to-nodes --csv="name" --csv-headline > cities.csv
But how can I add the information about the state / country?