hello dear all
`
the db or the excel-sheet has got the following categories -....
"version": 0.6,
"generator": "Overpass API",
"osm3s": {
"timestamp_osm_base": "2015-09-12T20:05:02Z",
"timestamp_areas_base": "2015-09-11T13:16:03Z",
"copyright": "The data included in this document is from www.openstreetmap.org. The data is made available under ODbL."
},
"elements": [
{
"type": "node",
"id": 248528643,
"lat": 41.9216283,
"lon": 12.5403769,
"tags": {
"amenity": "hospital",
"emergency": "yes",
"name": "Pronto Soccorso"
}
},
{
"type": "node",
"id": 262114028,
"lat": 41.8282625,
"lon": 12.4184520,
"tags": {
"addr:city": "Roma",
"addr:housenumber": "13",
"addr:postcode": "00148",
"addr:street": "Via Luigi Ercole Morselli",
"amenity": "hospital",
"name": "Ospedale San Giovanni Battista",
"operator": "Associazione dei Cavalieri Italiani del Sovrano Ordine di Malta",
"ref:vatin": "IT00995661006",
"website": "http://www.ordinedimaltaitalia.org/acismom-attivita-sanitaria"
}
},
{
"type": "node",
"id": 301593099,
"lat": 41.8747002,
"lon": 12.4562978,
"tags": {
"amenity": "hospital",
"name": "Clinica Città di Roma",
"source": "PCN"
}
},
{
"type": "node",
"id": 365299638,
"lat": 41.8357070,
"lon": 12.4284693,
"tags": {
"amenity": "hospital",
"created_by": "Potlatch 0.10f",
"name": "Ospedale Israelitico"
}
},
{
"type": "node",
"id": 428571538,
"lat": 41.8503399,
"lon": 12.4208258,
"tags": {
"amenity": "hospital",
"name": "Villa Sandra",
"wheelchair": "yes"
}
},
{
"type": "node",
"id": 434692525,
"lat": 41.8870757,
"lon": 12.3983943,
"tags": {
"amenity": "hospital",
"emergency": "yes",
"name": "Aurelia Hospital",
"url": "http://www.aureliahospital.com/",
"wheelchair": "yes"
}
},
{
"type": "node",
"id": 677112577,
"lat": 41.8663812,
"lon": 12.4573888,
"tags": {
"addr:city": "Roma",
"addr:housenumber": "292",
"addr:street": "Via Portuense",
"amenity": "hospital",
"name": "I.N.M.I. L. Spallanzani",
"website": "http://www.inmi.it/"
}
},
{
"type": "node",
"id": 677114577,
"lat": 41.8689538,
"lon": 12.4560799,
"tags": {
"amenity": "hospital",
"name": "San Camillo",
"website": "www.scamilloforlanini.rm.it/"
}
},
{
i want to store all the results in a
a. excel-sheet or
b. mysql-db
note: the db or the excel-sheet has got the following categories -....
"addr:city": "Madrid", "addr:housename": "Centro de Salud Cceres", "addr:housenumber": "4", "addrostcode": "28045", "addr:street": "Calle de Cceres", "amenity": "hospital", "name": "Centro de Salud Cceres"
how to achieve that