Maze Posted September 15, 2015 Share Posted September 15, 2015 hello dear community, i run a request against overpass-turbo.eu seehttp://overpass-turbo.eu/s/bsU [out:csv(::id,::type,"name","website"," contact:email=*")]; area[name="Thüringen"]->.a; ( node(area.a)[amenity=kindergarten]; way(area.a)[amenity=kindergarten]; rel(area.a)[amenity=kindergarten]; out; as a result i get the following 301384479 way Kinderhaus Löwenzahn 301466179 way Kindergarten Krempenbrunnen 301498317 way Kindergarten Maria Goretti 301630076 way Kinderhaus Sandrain 301690644 way Sankt Johannes 301690645 way Sankt Josef http://www.katholische-kirche-gaggenau.de/kindergarten-st-josef 301815303 way Kindergarten Langenbrand 301896401 way Kinderhaus Oberer Ried 302147059 way Kindergarten Bottenau 302493927 way Lindorfer-Kindergarten 302706979 way 302727243 way 303209015 way Hand in Hand 303310905 way Kinderkrippe Postwiese 303504363 way Kindergarten Regenbogen 303533115 way Flößerkindergarten 303585736 way Kindergarten Pusteblume 303672313 way Katholischer Kindergarten 303750818 way Villa Kunterbunt 303754108 way Kindergarten Sternschnuppe 303879932 way Waldkindergarten Waldkitz http://waldkitz.de 304112166 way St. Franziskus Kindergarten 304270710 way Evangelischer Kindergarten Huchenfeld 304380671 way 304514958 way Paul-Gerhardt-Kindergarten http://kindergarten.paulgerhardtkirche.de/ 304582027 way 304946234 way Evangelisches Kinderhaus Habakuk http://www.bonhoefferhaus-fn.de/einrichtungen/evangelisches-kinderhaus-habakuk/ 305198680 way 305327109 way Tageseinrichtung für Kinder Vaihinger Straße 94 305341780 w i want to store this into db - or at least into calc doable - i guess yes: calc seems to be pretty easy. but mysql? Quote Link to comment https://forums.phpfreaks.com/topic/298182-store-this-dataset-into-mysql-or-at-least-in-to-calc/ Share on other sites More sharing options...
Barand Posted September 15, 2015 Share Posted September 15, 2015 You would do it in very much the same way that I showed you in your other post http://forums.phpfreaks.com/topic/298142-how-to-extract-this-dataset-xml-to-db/?do=findComment&comment=1520744 Quote Link to comment https://forums.phpfreaks.com/topic/298182-store-this-dataset-into-mysql-or-at-least-in-to-calc/#findComment-1520904 Share on other sites More sharing options...
Maze Posted September 16, 2015 Author Share Posted September 16, 2015 many many thanks have a great day!! Quote Link to comment https://forums.phpfreaks.com/topic/298182-store-this-dataset-into-mysql-or-at-least-in-to-calc/#findComment-1520941 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.