Select & Summarize Points in a Boundary or Region - ZeeMaps Blog

Zip Code Look up & Other Region Search Tools

Start by adding pins and highlighted area(s) on your map.

There are many useful applications for looking up points that fall within a zip code or region.

For instance, you could look up all your customers within a zip code or other boundary outline. Alternatively, you could look up how many service stations are in your state or zip code. In the end, it comes down selecting and summarizing map points inside of a boundary. Essentially, any point feature and any boundary will work. You can even draw your own!

In an earlier post, we had detailed the ZeeMaps search feature that allows you to perform extensive searches for the pins on your map.

The detailed search dialog allows you to search for points based on field values. As well as, combine them with distance or geographical search. The geographical search includes searching within a highlighted region.

We’ve now added the ability to quickly do a look up search within a region by simply right-clicking on the region.

To start the search, just right-click on any highlighted region (boundary) and the display will limit itself to the points that fall within regions of the same color. To reset the search, right-click on the region again.

Once you have started the search, you can get a list of points that match your search by doing a Map -> Save as CSV.

For example, we are going to work with look up for a sales territory map that shows the sales territory zip code for three salespersons of a company. Each sales person covers roughly 2-3 zip codes. Each sales persons territory highlighted in different color.

As an example, we are going to work with a look up sales territory map that shows sales zip codes for three salespersons of a company. Each sales person covers roughly 2-3 zip codes.

We’ve added a list of potential customers to this map, with different customer types in different colors. For example, customers not contacted are red, while those contacted are green.

To get an overview of all the customers that have already signed-up, we can use the legend at the bottom of the map to view just the customers who are shown with green pins. But, how do we see all the green customers for Sales Person A?

Of course, that is where the new feature comes in handy. Now, simply right click on a colored territory area (zip code) for Sales Person A (pink). Notice the look up view of pins is limited to customers that fall within that sales person’s territory. Now, right click again to undo.

Simply right click on a colored zip code for Sales Person A and the look up view of pins is now limited to the customers that fall within that sales person's territory

Moreover, we can also get a list of the customers by exporting a CSV file from Map -> Save As CSV.

we can also get a list of the customers by exporting a CSV file from Map -> Save As CSV for zip code look up

If you have any issues opening the .csv in excel try following these steps.

Map Location Search & Export List

The map location search capability in ZeeMaps allows you to search your map based on marker field values and geography, e.g., you can search for all “Gold” customers in California in a customer map on ZeeMaps.

First, use the View -> Search menu item on your map to bring up a search dialog as shown below:

Search Dialog Map Location
Search Dialog

How to Search the Map Locations

Section A of the search dialog is for limiting the search results to values in your marker fields. First, this input in this section allows you to select the field to search. Next, this drop-down is for selecting the predicate (e.g. contains, equals, etc.). Third, this input box is for the value to search. You can click on the AND or OR buttons to add up to four clauses for searching marker fields. Example: Name equals Jill

Section B allows you to combine your field search by distance or geography. Therefore, you can specify an address and a distance to limit the search results within a certain distance of your address or map location. Now, if you have highlighted regions in your map, e.g., the state of California, then you can limit the search results by clicking on the highlighted region. Normally search results are limited to 200 entries.

You can increase or decrease this number in Section C.

Then, to search the map locations, hit the Search button. You should see the status line at the bottom right of the map change. Now, it will reflect the number of entries that matched your search.

Export Matched Map Locations

Lastly, if you want to get a list of entries that matched your map location search and put them in a spreadsheet, you can hit the “Export CSV” button instead of the “Search” button. Normally, only map Admins are allowed to export the search results as CSV.

If you have any issues opening the .csv in excel try following these steps.

In case you want your members or viewers to also be able to export search results, use the Map -> Settings menu item and then the Map Security tab to change the default settings.

Geocoded Latitude, Longitude in exported map data CSV file

ZeeMaps supports exporting of map data of markers (pins) using the View -> Export CSV, or Map -> Save As CSV menu options.
We used to output the latitude, longitude of each location so that you can use that to re-upload your data, with possible changes, quickly. Starting today, we are no longer exporting the latitude, longitude data, to comply with some of our geocoding service providers requirements.
Instead of the latitude, longitude columns, you will see a “Location Code” column in the exported CSV file. If you want to re-upload this data to ZeeMaps at anytime, do not modify or remove data from this column. If you do not need to upload your data to ZeeMaps, you can safely remove this column from your spreadsheet.
When you upload data to a ZeeMap, rows that have a Location Code column, (or a combination of latitude, longitude), will not be counted towards your upload credits.