Use this “Search places” box OR click the map
randymajors.org Map Tools ©2021 randymajors.org
Custom Color-Coded Maps
current pin location
Custom map Google Maps: Create custom Google Maps, 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!
Create your custom color-coded map using this form:
| 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: 
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:
|
Example Maps created using this Custom Color-Coded Maps tool (Counties on left, ZIP Codes in middle, and 3-digit ZIP Codes on right)
FAQs for ‘Custom Color-Coded Maps’
Feel free to share this with others who may find this functionality useful!
QUICK TIPS TO CREATE CUSTOM COLOR-CODED MAPS USING COUNTIES OR ZIP CODES:
- Follow the instructions above this box to create a link to your own custom color-coded map.
- 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 - 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
- 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)
- Click the “⊕ Locate” button in the upper right corner of the map to use your current location † and quickly answer “what county am I in?”
- Subscribe in the top header 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.
Subscribe to RSS/Atom Feed