Search the Community
Showing results for tags 'tool map'.
Hey all, I wanted to throw out a new link to the SMD tool map I have been updating since April 23, 2020 to get some more exposure to this map and gather more data. Likewise, I will link the raw data in .csv format for any future map mods to have access to. Along side this I will show the process to update the data into google maps. If you would like to update your information or be added to this map please do the following: PM @Joshdashef or Respond to this post with a location, tools available, and any additional comments you want to add. Example: AZ Phoenix. DD-1, Term Lab. Will help with setting gains, etc. Contact me _____________________________________________________________________________________________________________________ Map Link _____________________________________________________________________________________________________________________ The rest of this post will be like a tutorial so you can disregard unless your curious what is behind the curtain (one-time setup to create your own map with data) Sign into google account and create a custom "My Maps" Then download .csv file titled, "SMD Tool Map 20XX - RAW CLEAN DATA," from link above Follow next steps below for updating data for first time imports I use google drive to make this process a little easier but essentially you will be manually importing the data (sadly no way to automate or have live data changes show without scripting) My google sheet looks like this All cells that are highlighted are what I enter in from any request. Date/Username/County/State/City/Zip Code/Tools/A.I. (leaving anything blank that isn't mentioned). The Agg. Location is a formula using some if and concatenate formulas, so that will normalize it all for google maps api to show the markers. Updating Data You will have a blank map at the beginning or a layer already created if you are updating data. You will want to add another layer regardless then click import If you use a file type like .csv you can upload it here or use Google Drive to import (easier) Once you have your file imported, it will ask you two questions. Follow the pictures below using Agg. Location and Username respectively. 1. Choose columns to position your placemarks (what does google maps need to place a dot = address/location/gps cords./etc.) 2. Choose a column to title your markers (name of each dot placed) This will create a new layer titled the same as the file you import. We want to change to a different style than Uniform. Click Uniform Style Select Group places by: Seq. of numbers | Set labels: Username (or something else if you want) Done