Draw map from Google spreadsheet

  • sneike

    (@sneike)


    10 years, 3 months ago

    Hello! I have a Google drive spreadsheet containing coordinates in each row (with eventually other fields like title and description). The file is updated every day by adding new rows. Is it possible to draw a flexible map starting from this spreadsheet file?

    I was thinking to import it first in the Google my maps service, and then export the map to a kml file with a network link to use in the flexible maps plugin. Do you think it’s a reliable solution? Is there any easier solution?

    Thanks
    Daniele
    BeCycling.net

    https://ww.wp.xz.cn/plugins/wp-flexible-map/

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author webaware

    (@webaware)

    10 years, 3 months ago

    G’day Daniele,

    I’ll have to think about that one. Normally, for such applications I build something custom that pulls a JSON package from a database to build the map (e.g. this weather map). I haven’t tried incorporating that into this plugin.

    I’ve heard that you can do something similar to what you want with Google Fusion Tables. Haven’t looked into it myself, maybe there’s something you can look at there.

    I don’t have time right now to investigate this, but will check back in a while.

    cheers,
    Ross

    Thread Starter sneike

    (@sneike)

    10 years, 3 months ago

    Hi Ross, thanks for replying!

    Next week I’ll run some tests setting up a temporary spreadsheet, importing it on my maps and giving to your plugin the kml network address from Google. I will let you know if this workflow is reliable!

    Daniele
    BeCycling.net

    Thread Starter sneike

    (@sneike)

    10 years, 3 months ago

    Hi Ross, I started to work on my workflow to draw a map with flexible map starting from a google spreadsheet.

    One question: can Flexible Map draw a csv file instead of a kml?

    Thanks
    Daniele

    Thread Starter sneike

    (@sneike)

    10 years, 2 months ago

    Hi Ross, did you read the last message here?

    I’m still wondering how to draw a map on my website starting from a Google spreadsheet containing the coordinates. Is it possible to use flexible maps with a CSV URL file? Any better idea?

    Thanks
    Daniele

    Plugin Author webaware

    (@webaware)

    10 years, 2 months ago

    G’day Daniele,

    Sorry, been up against it lately.

    Quite frankly, I’d write this as a custom viewer. It’s not hard to load a CSV file into a database table, and then generate JSON from it to drive a little JavaScript that adds locations to a map.

    Alternatively, you could use a CSV to KML converter to generate your KML file and load that onto your website. There’s actually quite a few services that do that — here’s a simple search with quite a few offerings:

    https://encrypted.google.com/search?hl=en&q=convert%20csv%20to%20kml

    I’m flat out with other projects right now, so I won’t be adding CSV support to this plugin any day soon.

    cheers,
    Ross

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Draw map from Google spreadsheet’ is closed to new replies.