i am pretty new to openstreetmap update see below! we can run Perl for text-mangling XML-Simple-2.20/lib/XML/Simple.pm here's an example of a little script to parse our XML:
which, if passed our XML file goes very well on http://overpass-turbo.eu/ i have runned the following code i run the following code in opverpass-api - see here http://overpass-turbo.eu/
Export of the data to the following formats
get the data from see the Overpass API-explanations: i have the options to loat them to JOSM laden (only for requests, that give back valid OSM-XML with Metadata) GeoJSON to save it as gist note - i did not install the overpass-api on my opensuse 13.1 yet. but i am willing to do so. as for now - running the above mentioned code in the oerpass-api - here. http://overpass-turbo.eu/ how to treat it to get it exported as csv-formated hope i was able to provide all the necessary things for a clear and concise question. all i want is to transforme the xml-data to csv - in order to get a excel or calc based output.
look forward to hear from you update found this interesting thing: http://stackoverflow.com/questions/5491056/how-to-import-xml-file-into-mysql-database-table-using-xml-load-function have an XML file which looks like this :
I am trying to import it in MySQL using SQL statement :
The table my_tablename has the following fields :
I get error : Error Code: 1136 Column count doesn't match value count at row 1 I am using MySQL 5.1.56 I assume this error occurs because the database table has field id, which is not present in the XML file. How is it possible to import this XML file using MySQL queries of built in functions such that it skips id column during the import and relies on the auto increment function for the id column? Is there some smarter way of handling XML file imports im MySQL? Maybe there is better statement which allows to specify column mapping? we can specify fields like this:
since ID is auto increment, you can also specify ID=NULL as,
asked 28 Apr '14, 21:09 say_hello_to... |
Please type CSV in the text searchbox of this FAQ site, and you will get some hints how you can convert raw OSM data to CSV data. And please avoid to do crosspostings in OSM forum and here at the same time. Thanks. answered 29 Apr '14, 16:21 stephan75 |
Possibly the simplest way to convert OSM data to CSV is using osmconvert: http://wiki.openstreetmap.org/wiki/Osmconvert answered 30 Apr '14, 11:39 Richard ♦ |
Overpass API v0.7.51 now comes with native CSV support, so you don't need to download an extract from Geofabrik and post-process that extract using Here's an example for Overpass turbo which returns all pharmacies in Lüneburg along with their OSM id, lat, lon, name, operator, etc.
Example: http://overpass-turbo.eu/s/5Qc If you click on "Export" -> "raw data directly from Overpass API" you can even directly load OSM data into LibreOffice/Excel. Data is separated by a "tab" character by default and comes with a header line (can be adjusted). answered 08 Nov '14, 11:50 mmd |
Please edit your question to make it easier to read for everybody and that supporters don't need to walk trough dozens of lines. 1. What is your problem? 2. What did you tried? 3. Where do you fail?