Hi viewers, Welcome to coding freaks.
My name is Sudhir.
Today, in this video, we will see "how to plot location data from excel to google maps."
For this, we need data of locations i.e. latitude and longitude points in decimal form stored
in an excel file.
I have created a sample Excel sheet, which has data of universities of the USA with their
respective GPS locations and saved it on my Desktop.
Once you are ready with data, open any web browser and log on to website maps.google.com.
On the left of the web page, there is a three-bar icon for the menu, open the menu and select
your places.
From the YOUR PLACES menu move to tab MAPS, and in the bottom, there is an option Create
Map, click on it.
A new tab with Untitled Map will open.
Change the name of the map and add a description to it.
In this case, it is a map of universities of United States of America.
Now import the excel file having data of location for this map by clicking the import button.
You can use xlxs, CSV, kml or GPS file to generate a map on google maps.
It will automatically search the columns having location data for lats and longs.
It will ask you to select an item for the title of markers.
You may see the sample data of the file by clicking the question mark button in the right
of each of the radio button.
Once done, click on finish.
It will take some time in processing the file and display the markers on the map.
It has a bundle feature which we will see in this video.
You can view the data for this layer by clicking here.
It provides a feature for changing the color and marker icon for each of the marker individually,
or same setting for all.
Let's change the uniform design for these markers by changing the style to the uniform.
To modify the design, click on the icon next to the items.
Let's choose green color and marker symbol to educational places from more icons.
Google Maps also provides an option to change the base map layout as shown on your screen.
You can add more markers onto this layer just by selecting the marker icon and clicking
on the map.
It will show you lat-long of that point and ask you give it a name.
In this, you can add polygon which can be an open line polygon or a direction for driving
from one location to another.
You can also measure the Aerial distance between points by selecting the scale button.
After selecting the scale option, click on any two points to gauge the distance if you
want to end the measuring double click on a point.
Note that this feature does not get saved in the map, it just shows you the aerial distance.
There is dedicate option to add a layer for driving directions from one point to another.
If you need to create a polygon to highlight any area use the polygon tool.
Google map also has a printing feature to print the map you have created.
You can print this in pdf or image form.
To show pictures of the locations, you can add them from google images, your photos or
capture from the camera just by selecting the location marker and clicking the camera
icon.
You can either make it public or share it with the person you want to share.
One important point to remember is that it consumes storage from your google drive.
The public URL of this graph and excel file is in the description.
Practice on the same data or with own data to create a map on Google maps by importing
the excel file having GPS location and try to change the marker color and icon, add driving
direction and try to measure the aerial distance between points.
And share your creation, queries or feedback in the comment section.
Do subscribe to this YouTube channel for more.
This Sudhir from coding freaks signing for the day.
Thank you.








For more infomation >> 8 Ball Pool - NEW DEAL IS AVAILABLE CINCO DI MAYO CUE GET FREE CASH & COINS [NO ROOT] 2017 - Duration: 10:00.
For more infomation >> 8 Ball Pool - New Autowin 9 Ball Pool Easy Win Tricks {No Root} 100% Work 2017 - Duration: 10:12.
For more infomation >> 8 Ball Pool - NEW SIMPLE DOUBLE LONG LINE MOD 3.9.1 [NO ROOT] 2017 - Duration: 12:34. 

For more infomation >> O QUE FAZER EM CASOS DE INCÊNDIO RESIDENCIAL, E COMO SE PREVENIR - MANUAL DO SOBREVIVENTE #10 - Duration: 6:10. 

Không có nhận xét nào:
Đăng nhận xét