Connecting Google Sheets to your map (and geocoding addresses!)

[@nemesis851_]

No where ready to begin on this, but it IS what I am thinking. Thanks

[@nemesis851_]

4:00 could we not publish to our our website (with folder permissions) ?

[@ianlocations]

Thank you for the videos. Due to security, I don't think I can use google sheets. Do you have a recommendation for a database or process? I'm building my map with Mapbox gl js.

[@learnwithmapster]

Hi there Ian! It really depends on the size of the dataset you're working with, how often it will be getting updated, and what tech you're already familiar with. Options include using PostgresQL with a custom backend API (such as Node/Express or PHP), leveraging a Wordpress plugin like Mapster WP Maps, or just serving a generated geoJSON file directly or having it uploaded on a regular basis to Mapbox. Let me know if any of these sound right and maybe I'll make a video about it :)

[@ianlocations]

@@learnwithmapster Very much appreciate the quick response! My goal is to have a site where users can add/subtract from their own private datasets that are displayed on a map. Similar to how a real estate site might work (or giggster) if it was private for each user. I am assuming that most, if not all, of the users will not want to upload their own geojsons. I had seen your plugin before but had not looked into the 'pro' features and I am very intrigued. I will spend some time working with the plugin and get back to you if I have any questions. Thank you!

[@nemesis851_]

LSD in Alberta Canada, may be globally unique, maybe not. I haven't researched it yet But if you know of a "convertor", you're welcome to reply with its name. Thanks