Westchester-Rockland-Putnam Optometric Society

Search places (e.g. address, city)

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 a custom Delivery Area Map, Sales Territory Map or Service Area Map using this free mapBuilder form:

RESULTS FROM MAP

Copy
Contents of box copied to clipboard
X

Customize this map

mapBuilder

Draw & measure on the map

Draw & measure on the map

NEW! Draw & measure on any map!

Add points, lines and shapes to any map, and save Drawings to your My Account page! Add multiple drawings to any of your maps!

Also, measures and displays length and area automatically when you draw or edit any of your lines and shapes!

Draw and Measure on the Map

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 U.S. 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 U.S. 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 U.S. Counties

Show Me How

sample map

Type or paste a comma-separated list of 5-digit and/or 3-digit ZIP Codes into the box below, OR

Click here to select ZIP Codes by drawing on the map

Then, set map title & display options, then click the Apply button below

1. In Google Sheets, create a spreadsheet with the first 3 columns in this order: ZIPCode, Data*, and Color • Free version has a limit of 1,000 rows
• NEW! You can use any combination of 5-digit ZIP Codes and 3-digit ZIP Codes
• Map data will be read from the first sheet tab in your Google Sheet
• If you don't have a Google Sheet, create one by importing from Excel or a .csv file
• The header of the second column will be used as the map legend heading
• The second column can contain links beginning with https:// that will appear when the user clicks the map on that ZIP Code
• In the color column, you can use any browser-supported color name or any 6-digit hex color code

2. Share your spreadsheet using these steps: (1) Click the Share button in the upper right corner, (2) click the Get link section in the box that appears, (3) change the sharing setting to Anyone with the link (keep the drop-down to the right set as Viewer), (4) click the Copy link button, and (5) click Done. (see screenshot of these 5 steps )

3. Paste the link you just copied into the box below:

4. Set map title & display options, then click the Apply button below

Click here to select ZIP Codes for your spreadsheet by drawing on the map
Color-code ZIP Codes from spreadsheet example
* The Data column (second column) can be named anything, such as Territory in this example

1. In Google Sheets, create a spreadsheet with 4 columns in this order: County, StateAbbrev, Data* and Color • Free version has a limit of 1,000 rows
• Map data will be read from the first sheet tab in your Google Sheet
• If you don't have a Google Sheet, create one by importing from Excel or a .csv file
• The header of the third column will be used as the map legend heading
• The third column can contain links beginning with https:// that will appear when the user clicks the map on that county
• In the color column, you can use any browser-supported color name or any 6-digit hex color code

2. Share your spreadsheet using these steps: (1) Click the Share button in the upper right corner, (2) click the Get link section in the box that appears, (3) change the sharing setting to Anyone with the link (keep the drop-down to the right set as Viewer), (4) click the Copy link button, and (5) click Done. (see screenshot of these 5 steps )

3. Paste the link you just copied into the box below:

4. Set map title & display options, then click the Apply button below

Click here to select Counties for your spreadsheet by drawing on the map
Color-code counties from spreadsheet example
* The Data column (third column) can be named anything, such as Salesperson in this example

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

Set map title & display options

Set map title & display options

Set an embedded title for your map, set the main color and choose other map layers to display (all optional)

Set color

Map type

Center map on user location


Use current map center & zoom-level

Show county lines


Show city limits

Show labels


Show ZIP Code boundaries

Hide map legend

Also show these outside my custom area

Click Apply to view your finished map

Apply

If desired, add additional mapBuilder modules to your map and make any other adjustments, then click Apply to see the updated map.

When you are happy with your map, you can:

Copy the map link for use on another website*:

Copy link

Link copied to clipboard!

Save the finished map to your My Account page:

Save Map

Map saved!

* If you include a map screenshot from this tool on your website, please include a small source attribution link pointing to this page
randymajors.org Map Tools ©2022 randymajors.org

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!

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 “Show US city limits” checkbox in the lower left corner of the map to see City Limits overlaid on the map
  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
    “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.





Get access to Ad-Free Fullscreen Map & Search tools

NEW! Draw points, lines and shapes on any map, and save maps and drawings to your account!

Also, measures and displays length and area automatically when you draw or edit any of your lines or shapes.

PLUS: New flexible sign up options. Also, add points to the map from a live-linked spreadsheet or import points from Google My Maps, Google Earth, or GIS software.

Draw and Measure on the Map
x

Get access to Ad-Free Fullscreen Map & Search tools

NEW! Draw points, lines and shapes on any map, and save maps and drawings to your account!

Also, measures and displays length and area automatically when you draw or edit any of your lines or shapes.

PLUS: New flexible sign up options. Also, add points to the map from a live-linked spreadsheet or import points from Google My Maps, Google Earth, or GIS software.

Draw and Measure on the Map