Joshdashef Posted May 26, 2022 Report Share Posted May 26, 2022 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 😅 SMD Tool Map (2022): https://www.stevemeadedesigns.com/board/topic/220267-smd-tool-map-2022/ My Port Size Calculator (in progress): https://www.stevemeadedesigns.com/board/topic/217087-port-size-calculator-in-progress/ Common Port Walls for a Slot Port: https://www.stevemeadedesigns.com/board/topic/217076-common-port-walls-why-it-matters-to-your-box/?tab=comments#comment-3240313 Link to comment Share on other sites More sharing options... 303 906 10
Never Enough Bass Posted May 29, 2022 Report Share Posted May 29, 2022 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 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 More sharing options... 179 675 11
Joshdashef Posted June 1, 2022 Author Report Share Posted June 1, 2022 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! SMD Tool Map (2022): https://www.stevemeadedesigns.com/board/topic/220267-smd-tool-map-2022/ My Port Size Calculator (in progress): https://www.stevemeadedesigns.com/board/topic/217087-port-size-calculator-in-progress/ Common Port Walls for a Slot Port: https://www.stevemeadedesigns.com/board/topic/217076-common-port-walls-why-it-matters-to-your-box/?tab=comments#comment-3240313 Link to comment Share on other sites More sharing options... 303 906 10
Recommended Posts
Archived
This topic is now archived and is closed to further replies.