Zoning

If you know how to work with this tool, scroll down to the map.


This simple app gets 1) a csv file of names and addresses, and 2) a number between 1 to 13, and distribute addresses to the determinied number of zones based on proximity. Once the zoning is complete, you can still manually change zones assigned to addresses on the map by clicking on markers and moving it to the new zone. Finally you can generate a new csv file, which is the same as the input csv file, with zone numbers added in the last column.

If you do not know what is a CSV file, consider a table that consists of rows and column. Every line in a CSV file is basically a row in a table. Moreover, in every line (row), columns are separated by comma (,). You can export Microsoft Excel sheets or Google spread sheet to CSV files. There are also lots of online tools that allow you to create CSV files.

Why do I need this?

There are many usecases for using a zoning tool. For example, imagine you are organizing a bottle drive to go to different addresses and collect their bottles. You also have a few drivers who are going to help you with collecting the bottles. In order to assign addresses to the drivers, you need a zoning tool that could group your addresses into several groups in a way that addresses in every group are not too far from one another. Then you can assign each group to a driver. With the help of the zoning tool, you can rest assured that your drivers do not drive throughout city to collect bottles.

How to use it

The input file (containing addresses) must be a csv file. The first row is considered as the header and will be ignored. Two columns must appear in the header: "title" and "address". Title column is used to create caption for markers that will be added to the map.

Next, go to the below panel and take the following steps:

  1. Select the file,
  2. Enter the total number of zones you want the addresses to be distributed to. The maximum number of zones is 13,
  3. Press run and wait for the addresses to appear in the map,
  4. If you want to move an address to another zone, click on its marker, enter the new zone, and press "move to zone",
  5. Once you are ok with the displayed zoning, press "create download link" and then press "download". In the generated file for download, zone number appears under column "zone".

Click here to see a sample file.

What if I have already done the zoning

Imagine you have already done the zoning using this tool, or manually added the zone numbers to every line in your CSV file, and now want to just view the addresses and their zones on the map. You can still use this tool for that purpose. The input file still must be a CSV file. The first row is considered as the header and will be ignored. Three columns must appear in the header: "title", "address", and "zone". Title column is used to create caption for markers that will be added to the map. The last attribute should be the zone number attribute.

Next, go to the below panel and take the following steps:

  1. Select the file,
  2. Press run and wait for the addresses to appear in the map,
  3. If you want to move an address to another zone, click on its marker, enter the new zone, and press "move to zone",
  4. Once you are ok with the displayed zoning, press "create download link" and then press "download",

Click here to see a sample file.

Help!
Number of zones: Zoning needed
Select csv file: