first of all, please forgive me for being a complete novice. I hope I will be asking the right questions
Firstly, the aim of my project:
I am trying to create a map similar to the one at the link below. This map is to display the Upper Airways routes used in Aviation over the UK for use in an app that I am trying to create using Thunkable. I created the map at the link below using Google's My Maps
Google My Map Link:
https://www.google.com/maps/d/edit?mid=10e75Ey7XR53NeoTPSra_PYlqAWAuJGdJ&usp=sharing
The GSheet I used for the data waypoints is at this link in my Google Drive: https://docs.google.com/spreadsheets/d/1O5RU64TL4aQqhimaq0sHhetbf67gK6V214vu6NJSQLQ/edit?usp=sharing
I have a Google Map API but I am not sure how to use it.
My intentions and goals with this project:
Because Google My Maps does not support the little blue dot that denotes the User's location on a Map. I have decided to try and recreate Upper Airways Route (UAR) Maps using Google Maps instead to get the blue dot onto the map by using the User's device's location sensor. But to do this, I am led to understand that I have to create a JSON file containing the My GSheet data (Tab "Sheet 3") and the data in (Tab "Sheet 1").
The problem I am having is that I cannot find anywhere on the internet which shows me the correct layout of my GSheet to prepare it to be converted into a JSON format which will display the routes as polylines as per my My Map
Also, I am trying to get the Google Map to display the Waypoints and their names along each route as shown at the My Map link above.
There are currently about 200+ waypoints listed in my GSheet (Tab "Sheet 1") with more to be added over time along with more Upper Airways routes (polylines) Please note that the Routes displayed are in different colours. These are so the user can tell which direction the route is commonly used by aircraft.
I wish to be able to add waypoints and polylines live to My GSheet and they would be instantly displayed on the Google Map as I do so.
My tabs are all linked by formulae for the sole purpose of auto-populating other tabs with their relevant data and therefore a timesaver for me.
Now for the questions:
1) Using one of the "Sample Tabs, could some kind soul please show me the correct layout that I should be using to prepare my GSheet for converting into JSON format?
2) Could someone please help me to be able to create a GSheet tab that, when data is altered within the tab (eg. coordinates changed, new polyline added/ removed, polyline colour change etc....). the change would be instantly displayed on the Google Map?
3) Is there a way to also use the same GSheet tab to display Waypoint names on the Google Map? If not, then how would I go about achieving this?
4) Is there a way to put small direction arrows on polylines? If so, how?
5) Is there a way to add labels to polylines? If so, how?
6) If the User were to click on a polyline, or tab could more information be displayed for them from the GSheet?
7) Is there a way to allocate individual colours to individual routes from the GSheet? If so, how?
8) Is there a way to add my own icons to the waypoints that, like Google's blue dot, will not change size when the User pinch/zooms the Google Map?
9) What is the best way to code this? From researching various forums I am inclined to believe that it might be Javascript. Which is the easiest? I do not fully understand coding though little bits seem to make some sort of sense.
10) Once the JSON is created, how do I get it to put my GSheet data onto the Google Map?
I really am a novice at this sort of stuff but I am ambitious.
Any help would be greatly appreciated.
Many thanks,
Andos.