SCF 669 Proposed

randymajors.org Map Tools ©2021 randymajors.org

SCF 669 Proposed

current pin location

Type an address into the "Search places" box above the map OR click the map to explore.

Created with: randymajors.org mapBuilder tool below

HAVE A BUSINESS? Create your own custom Delivery Area Map, Sales Territory Map or Service Area Map using the free mapBuilder form below!

mapBuilder

Create Custom Areas from ZIP Codes or Counties

Create Custom Areas from ZIP Codes or Counties

Create a custom area from a list of ZIP Codes

Define a delivery area, service area or sales territory using a list of 5-digit or 3-digit ZIP Codes

Show Me How

sample map

Color-code ZIP Codes from a spreadsheet

Create a custom color-coded map using a live link to a Google Sheet containing ZIP Codes

Show Me How

sample map

Color-code Counties from a spreadsheet

Create a custom color-coded map using a live link to a Google Sheet containing Counties

Show Me How

sample map

- Type a comma-separated list of ZIP Codes into the box below
OR
- Select ZIP Codes by drawing on the map above:
- 1. Click the Drawing Tools button on the left side of the map, then draw an area (any ZIP Code you touch will be included).
- 2. Double-click to finish drawing, and the ZIP Codes will automatically appear in the box below.

1. In Google Sheets, create a spreadsheet with the first 3 columns in this order: ZIPCode, Data*, and Color
- TIP: You can use either 5-digit ZIP Codes or 3-digit ZIP Codes (but not a combination of the two)
- TIP: If you don't have a Google Sheet, create one by importing from Excel or a .csv file
2. Publish your spreadsheet using the default values in the File > Publish to the Web box. Click Publish, then close the Publish box.
3. Copy the URL from your web browser address bar while viewing the Google Sheet (see example URL below)
- TIP: DO NOT copy the link from the Publish to the Web box
4. Paste the URL into the box below:

Color-code ZIP Codes from spreadsheet example
* Example spreadsheet showing Data column as Territory

1. In Google Sheets, create a spreadsheet with 4 columns in this order: County, StateAbbrev, Data* and Color
- TIP: If you don't have a Google Sheet, create one by importing from Excel or a .csv file
2. Publish your spreadsheet using the default values in the File > Publish to the Web box. Click Publish, then close the Publish box.
3. Copy the URL from your web browser address bar while viewing the Google Sheet (see example URL below)
- TIP: DO NOT copy the link from the Publish to the Web box
4. Paste the URL into the box below:

Color-code counties from spreadsheet example
* Example spreadsheet showing Data column as Salesperson

Add Custom Points to the Map

Add Custom Points to the Map

Add your own custom points to any map!

Add points to the map from a live-linked spreadsheet! Or add points from Google My Maps, Google Earth, or GIS software.

Add Custom Points in mapBuilderPro

Set Map Title & Display Options

Set Map Title & Display Options

Set a title for your map, set the main color and choose other map layers to display

Set color

Map type

Show labels

Center map on user location

Show county lines

Show city limits

Show ZIP Code boundaries

Also show these outside my custom area

Ready! Click link at left to view your map.
You can bookmark the link or embed the link on another website!

Ready! Click link above to view your map.
You can bookmark the link or embed the link on another website!

Note: If you include a map screenshot from this tool on your website, please include a small source attribution link pointing to this page.

Custom Color-Coded Maps

Custom Map on Google Maps: Use the mapBuilder form just above to create your own custom Google Map, color-coded by Counties, ZIP Codes, or 3-digit ZIP Codes in a Google Sheet

Quickly create a free live-linked interactive color-coded map on Google Maps based on Counties, ZIP Codes, or 3-digit ZIP Codes stored in a spreadsheet. Use custom data fields to assign different colors to each value, customize colors, add titles and more. And the map is live-linked to the spreadsheet: change the spreadsheet, and the next time you visit the map, your updates will be automatically shown on the map!

NOTE: The old custom map form has been replaced by the new mapBuilder tool above, which has much greater functionality!



Create your custom color-coded map using this form:

For greater functionality, please try the new mapBuilder tool above!

Map title
Google Sheet URL
     
1. Create or open a Google Sheet here
2. While viewing the Google Sheet, copy the entire Google Sheet URL shown in your browser’s address bar and paste it into the Google Sheet URL box above
3. The first 4 columns of your spreadsheet must be County, StateAbbrev, Data, and Color (all other columns will be ignored)
   – Column names do not matter, but they must be the first columns and must be in this order
   – The Data column is what gets color-coded; it can be anything (e.g. Name, Zone, Status, etc.)
   – The Color column can contain color names or hex values (e.g. red, #FF0000)
   Example showing a few rows of a County-based spreadsheet setup:
     Example County Sheet for Custom Color-Coded Map tool
4. Your Google Sheet must be published using File > Publish to the web. Use the default values in that box and click Publish and OK.
   – DO NOT paste the link shown in the “Publish to the web” box into the “Google Sheet URL” box above. Instead, copy/paste the link as shown in Step 2.
   – DO NOT PUT CONFIDENTIAL INFORMATION IN THE GOOGLE SHEET; someone with the link could view it. This tool cannot edit your Sheet.
Display options
                       


     
Finished Map Link    (click the link at left to preview your map, then bookmark it)
Copy the web address below into a link on your website that you want to link to this map:
Note: If you include a map screenshot from this tool on your website, please include a small source attribution link pointing to this page.

Example Maps created using this Custom Color-Coded Maps tool (Counties on left, ZIP Codes in middle, and 3-digit ZIP Codes on right)

Example County map created with Custom Color-Coded Map tool Example ZIP Code map created with Custom Color-Coded Map tool Example 3-digit ZIP Code map created with Custom Color-Coded Map tool

Feel free to share this with others who may find this functionality useful!

Quick Tips for using this Color-Coded Maps Tool

  1. Follow the instructions above this box to create a link to your own custom color-coded map.
  2. Once your customer or end user uses this map, they can then zoom in, search for their address and so on. To go to another location, type any place or address in the “Search places” box above the map*
    OR: Zoom into your place of interest on the map
  3. Optionally, check the “Show ZIP Code boundaries” and “Show ZIP Code labels” checkboxes in the lower left corner of the map to see the ZIP Codes on the map
  4. Optionally, check the “Also show US city limits” checkbox in the lower left corner of the map to see City Limits overlaid on the map (available in the U.S. only)
  5. Click the button in the upper right corner of the map to use your current location. Click the button again to automatically update your location every 1, 5 or 10 minutes (Monthly Contributors also get an option to update every several seconds). † and quickly answer “what county am I in?”
  6. Subscribe to receive notification of tool updates and usage tips

* You can also type in GPS coordinates in decimal degrees into the Search places box. For example, type -105.25, 40 for Boulder, Colorado.
** or equivalent province, district, etc.
*** All information is reported based on the location of the blue dot on the map; to move the blue dot, click the map
The “Locate” button will be more accurate on smartphones and other devices containing a GPS; desktop browsers typically show an approximate location

Coverage Notes

  • US coverage includes Counties in all 50 states plus Puerto Rico, US Virgin Islands, Guam, Northern Mariana Islands and American Samoa
    “Also show US city limits” draws all incorporated cities and towns in the United States and its territories and possessions
  • Within the UK, England displays Counties and Unitary Authorities, Scotland displays Council Areas, Wales displays Principal Areas, and Northern Ireland displays Districts. Explanation of Unitary Authorities, Council Areas, Principal Areas and Districts.
  • Australia displays Local Government Areas (LGAs)
  • New Zealand displays Territorial Authorities
  • Canada displays Census Divisions, which are Counties in some provinces but may include other geographies
  • Mexico displays Municipalities, which are the next level administrative divisions below State
  • Switzerland displays Districts

Other Notes

  • The Search places box uses a standard Google Maps geocoding engine, therefore you can type street addresses, road names, points of interest, and GPS coordinates (see * above) to see what county that location is part of
  • Many of the map layers from which this information is extracted are very large, so it may take several seconds for all of the map layers to finish drawing
  • Because the map layers are large, boundaries will not be shown if you are zoomed out too far
  • Note that typing an address will zoom in the map very close, whereas typing a city or county by itself will show you a map with a wider view
  • Disclaimer: While the number of decimals in the latitude and longitude displayed for the map marker imply a positional accuracy of within a few feet, note that Google Maps is not inherently that accurate, and therefore this tool should not be used for legal purposes or anything beyond entertainment value.

Sources

– US: Census Bureau
– UK: Open Government License – Contains Office of National Statistics data, Ordnance Survey data ©Crown copyright and database right 2017. Open Data Lincese – Ordnance Survey of Northern Ireland.
– Ireland: Open Data and Creative Commons License – Ordnance Survey Ireland
– Australia: Incorporates Administrative Boundaries ©PSMA Australia Limited licensed by the Commonwealth of Australia under Creative Commons Attribution 4.0 International licence
– New Zealand: Creative Commons Attribution 3.0 – Stats NZ
– Canada: Open License – Boundary Files, 2016 Census; Statistics Canada Catalogue no. 92-160-X
– Mexico: Instituto Nacional de Estadística y Geografía (INEGI)
– Switzerland: Swiss Federal Office of Topography

Help improve this tool. Please comment.





Add your own custom points to any map!

Add points to the map from a live-linked spreadsheet! Or add points from Google My Maps, Google Earth, or GIS software.

Add Custom Points in mapBuilderPro
x

Add your own custom points to any map!

Add points to the map from a live-linked spreadsheet! Or add points from Google My Maps, Google Earth, or GIS software.

Add Custom Points in mapBuilderPro