tool map SMD Tool Map 2022+

[Joshdashef]

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 😅 

[Never Enough Bass]

On 5/26/2022 at 4:25 PM, Joshdashef said:

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 😅 

You can add me I'm in Kalamazoo MI I got a dd1+ and a cc1 and some extra knowledge 

[Joshdashef]

On 5/28/2022 at 10:45 PM, Never Enough Bass said:

You can add me I'm in Kalamazoo MI I got a dd1+ and a cc1 and some extra knowledge 

You have been added as #206

Cheers!