Jump to content

Recommended Posts

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

bcd8ef72c59c37c0c7b6628c6bb638333494e53c

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

f970e2eb7dec5e98c06f20f1692788e4604acf74

 

If you use a file type like .csv you can upload it here or use Google Drive to import (easier)

4960b075dc9a0254899d1eda26954933019c9f52

 

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)

8512f1f15b5a9dd76871924020bd069930553d97cdee56b2905ed7d7ab3eac171e3c737ff575d184

 

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

3924514116f614860bbdcebf652eca39bba9b20e

 

Select Group places by: Seq. of numbers | Set labels: Username (or something else if you want)

6c57ca8dc1dccddfa62c2af6562a1f7d3d38e2eb

 

Done 😅 

2db8d7ef74aa417b4f89ed0eb45c0df2a8ac70ce

  • Like (+1 Rep) 2
Link to comment
Share on other sites

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

bcd8ef72c59c37c0c7b6628c6bb638333494e53c

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

f970e2eb7dec5e98c06f20f1692788e4604acf74

 

If you use a file type like .csv you can upload it here or use Google Drive to import (easier)

4960b075dc9a0254899d1eda26954933019c9f52

 

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)

8512f1f15b5a9dd76871924020bd069930553d97cdee56b2905ed7d7ab3eac171e3c737ff575d184

 

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

3924514116f614860bbdcebf652eca39bba9b20e

 

Select Group places by: Seq. of numbers | Set labels: Username (or something else if you want)

6c57ca8dc1dccddfa62c2af6562a1f7d3d38e2eb

 

Done 😅 

2db8d7ef74aa417b4f89ed0eb45c0df2a8ac70ce

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

  • Like (+1 Rep) 1

06 Charger

Pioneer double din

Pioneer 6.5 and 6×9's

Knukoncept Krystal kable rca's

0 ga knukoncept kolossus wire 

Big 3 same wire ^ 1 run 

8g karma ss speaker wire

Sundown sia 3500d at 1ohm

2 Sundown U series 12's

Duralast platinum agm H7 (Main)

Xs power d3400

Trying to find a ho alt

 

 

Link to comment
Share on other sites

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!

  • Like (+1 Rep) 1
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...