how to store this - a request that is gained at http://overpass-turbo.eu/
Results 1 to 1 of 1

Thread: how to store this - a request that is gained at http://overpass-turbo.eu/

  1. #1
    Member
    Join Date
    Sep 2010
    Posts
    40

    how to store this - a request that is gained at http://overpass-turbo.eu/

    how to store this - a request that is gained at http://overpass-turbo.eu/


    Code:
    [out:csv(::id,::type,"name","addr:postcode","addr:city",
    "addr:street","addr:housenumber","website"," contact:email=*")][timeout:300];
     area["ISO3166-1"="AR"]->.a;
    ( node(area.a)[amenity=hospital];
      way(area.a)[amenity=hospital];
      rel(area.a)[amenity=hospital];);
    out;

    in a dictionary?
    in a list?
    or can i transfer it from CSV to DB directly?

    or should i get the data as GEOJson

    see the dataset:
    Code:
    8516832	way	Hospital Doctor Ramón Carrillo						
    28603025	way	Hospital de Oftalmología y Odontología Cjal. N. Di Próspero						
    28631185	way	Sanatorio de la Trinidad	1425	Ciudad Autónoma de Buenos Aires	Avenida Cerviño	4720	http://www.trinidadpalermo.com.ar/	
    28641286	way	"Hospital Interzonal General de Agudos ""Luisa C. Gandulfo"""	1832	Lomas de Zamora	Balcarce	351	http://higagandulfo.com.ar	
    28815133	way	Hospital Interzonal General de Agudos “Dr. José Penna”			Láinez	2401	http://www.hospitalpenna.com.ar	
    28815167	way	Municipal de Agudos Dr. Leónidas Lucero			Estomba	968		
    28815214	way	Privado del Sur			Las Heras	164		
    28815269	way	Español			Estomba	571		
    29030071	way	"Hospital Zonal General de Agudos ""Dr Carlos A. Bocalandro"""	1657	Loma Hermosa	Avenida Eva Duarte de Perón	9100		
    31234209	way	Instituto de Oncología Ángel H. Roffo	1419	Ciudad Autónoma de Buenos Aires	Avenida San Martín	5481		
    35925544	way	Hospital San Juan Bautista	4700	San Fernando del Valle de Catamarca				
    51229315	way	Hospital Italiano de La Plata			Avenida 51	1725	http://www.italianolaplata.com.ar	
    52134817	way	Instituto de Hemoterapia de La Plata			15		http://www.ms.gba.gov.ar/sitios/hemoterapia/	
    521348
    note> it is far better to store it into a db than to a calc sheet / with a db i can performe more and better search and data manipulation...

    love to hear from you
    dilbert 2010 :: overwhelming wordpress-toolkits http://wpgear.org/

  2. #2
    Pedantic Curmudgeon Weedpacket's Avatar
    Join Date
    Aug 2002
    Location
    General Systems Vehicle "Running Gear"
    Posts
    22,572
    Store it however it makes sense for you. If you want to keep it then a database is a good choice storing data.

    Quote Originally Posted by dilbert2010
    or can i transfer it from CSV to DB directly?
    Depending on your DBMS (consult its documentation) it probably does have a mechanism for import CSV directly. If it doesn't, PHP does (fgetcsv and str_getcsv) and then you can put it into the database.
    THERE IS AS YET INSUFFICIENT DATA FOR A MEANINGFUL ANSWER
    FAQs! FAQs! FAQs! Most forums have them!
    Search - Debugging 101 - Collected Solutions - General Guidelines - Getting help at all

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •