Las Vegas Zip Codes Spreadsheet Uploaded to a Map

ZeeMaps now allows you to highlight US Zip Code areas on a map by uploading a spreadsheet with address and color information. Previously we supported highlighting regions only few at a time. As an example, in this blog post, we’ll show you how to highlight all the Las Vegas zip codes on a map.

Las Vegas Zip Codes Spreadsheet

We collected all the the las vegas zip codes and put them in a spreadsheet. A small sample of the spreadsheet is shown below:

City, State, Zip Code, Color

Las Vegas, NV, 89101, red
Las Vegas, NV, 89111, blue
Las Vegas, NV, 89102, green
Las Vegas, NV, 89103, red
Las Vegas, NV, 89106, blue
Las Vegas, NV, 89107, green
Las Vegas, NV, 89109, red
Las Vegas, NV, 89128, blue

The complete spreadsheet of the Las Vegas zip codes can be downloaded from: Las Vegas Zip Codes.

We’ve added the “color” column to our table to indicate which color we’d like to use to highlight a specific zip code. You can modify the color later once the map has been created. ZeeMaps supports 31 different colors that can be used for spreadsheet uploads. For a complete list of supported colors, see the menu item Map -> Legend on your map.

Upload Las Vegas Zip Codes Spreadsheet to a Map

Create a map and then use the menu item Additions -> Add (Upload) Multiple Markers. This will result in a dialog that asks for the spreadsheet file:

Upload Spreadsheet to Map for Las Vegas Zip Codes
Upload Spreadsheet to Map for Las Vegas Zip Codes

In this dialog, as shown in the figure above, you can select the option to upload the data as pins or as highlighted areas for the zip codes. Since we want to create a map with zip codes highlighted, we’ll chose the option of “US Zip Code Regions”.

The spreadsheet can be in Excel file format or a CSV file. You can also copy-and-paste data from a table, or attach a spreadsheet maintained on a Google Drive. The advantage of using a spreadsheet on a Google Drive is that you can have the map be automatically updated based on changes to the spreadsheet.

Once you submit the data, a dialog will ask for confirmation of the column mappings to the field values. Make sure your columns are assigned to the appropriate fields, otherwise the data may not be mapped correctly.

Confirm column mappings for Las Vegas zip codes upload
Confirm column mappings for Las Vegas zip codes upload

Las Vegas Zip Codes Map

After you confirm the column mappings, the highlighting of zip code areas will start. It may take a few minutes for large files. You’ll get an email report when the upload is finished. Refresh your map and it should show you the highlighted areas. Our interactive map of Las Vegas zip codes is embedded below.

Click on a highlighted zip code to see more information determined from the additional columns of your spreadsheet. In the information bubble, you can click on the title or name to get an edit dialog to make changes to that specific entry, including the ability to change the color.

When highlighting regions through spreadsheet uploads, the normal region limits apply: 5 for Basic (free) plan, 10 for Professional, 25 for Professional Publisher. In addition, the Enterprise plan is restricted to 5,000 highlighted regions through spreadsheet uploads. If you need more, please contact us for special provisioning.

 

 

Change all markers in California to Yellow in a US Map

Bulk edits of map information has a “Copy Changes” feature. Select multiple rows, make a change to one row, and then click on “Copy Changes” to make the same change to all the selected rows.

For example, suppose we have a US map of locations in different states and we want to color all the markers in California to Yellow.

On your map, click on the Bulk Edits -> Markers menu item (this requires a paid subscription).

Bulk Edit menu item
Bulk Edit of Markers

This opens up a new tab in the¬†browser with an edit grid for all the locations on the map. Sort this grid using the “State” column, and select all rows from California. Change the “Marker” cell of one row to “Yellow” and hit “Copy Changes”. The change is propagated to all the selected rows. Pressing “Save Changes” will commit these changes.

Change multiple rows at once with CopyChanges
Change multiple rows at once with CopyChanges

Re-Color Map Markers

To change the color of a set of markers from one color to another, use the Bulk Edits -> Re-color Markers menu item. You must be a paid subscriber to use this function.

Menu item for Re-Color Markers
Menu item for Re-Color Markers

This will bring up a small dialog, that asks you to pick the original color and the new color. At this time, you can also change the map legend from the old color to the new color, by checking the box for “Also, change map legend”.

Change all markers from one color to another
Change all markers from one color to another

Add Markers with SmartPhones

When you visit a map through your SmartPhone, you should see an “Add” button on the header bar for your map:

Add marker in SmartPhone
Add button on maps in SmartPhones

Press the Add button and you’ll get a form to enter your marker information, i.e., name, location, description and color.

To use the current location, press the button titled “Use Current Location”.

If you do not have the location address, and do not wish to use the current location, ZeeMaps allows you to search for locations. Just fill the name field and hit submit. For example, to search for McDonalds I entered “McDonalds” in the name field, entered my description, picked a marker color, and hit Submit.

Search for local McDonalds
Search for McDonalds to Add location

ZeeMaps lists a few McDonalds, but none of them are close to our location (Sunnyvale, CA):

First Search attempt for McDonalds
First Search attempt for McDonalds

So, change the search from “McDonalds” to “McDonalds, Sunnyvale, CA”. Now it lists McDonalds in Sunnyvale, CA, and you can select one to add to the map.

Improved Search with name and city
Improved Search with name and city

 

Later, if you want to delete that marker, click on it to get its details, including a “Delete” button.

Delete button for deleting marker in SmartPhone
Delete button for deleting marker in SmartPhone