How to store openstreetmap-requests in a mysql database?
Posted: Sun 22 Jun 2014, 15:06
hello dear linux-experts,
i do some openstreetmap-requests . with quite alot of files.
note: i do them on a regular base: so the question is : how to store the results in a mysql database;
see this is an excel-file; i tis formated in csv-file:
question: how to store the results - and to update the database on a regular base ?
note: i run mysql on opensuse - and i am a bit familiar with mysql, perl and php no problem here....
i do some openstreetmap-requests . with quite alot of files.
note: i do them on a regular base: so the question is : how to store the results in a mysql database;
wget http://download.geofabrik.de/europe/bel ... st.osm.pbf
./osmconvert belgium-latest.osm.pbf -o=belgium.o5m
./osmfilter belgium.o5m --keep="amenity=school" -o=belgium-schools.o5m
./osmconvert belgium-schools.o5m --all-to-nodes -o=belgium-schools_nodes.o5m
./osmfilter belgium-schools_nodes.o5m --keep="amenity=school" -o=belgium-schools-results.o5m
./osmconvert belgium-schools-results.o5m --csv="@id @lon @lat name addr:street addr:housenumber addr:city website email" --csv-headline -o=belgium-schools-results.csv
see this is an excel-file; i tis formated in csv-file:
question: how to store the results - and to update the database on a regular base ?
note: i run mysql on opensuse - and i am a bit familiar with mysql, perl and php no problem here....