Category: mapping

Map Your Optimal Route to Custom Locations

Maps in these modern times have become more than just the thing you keep in your glovebox for emergencies. They’re part of daily life on our phones, in our cars, and embedded in websites. Routes between places is a common use case for Google Maps and similar directional tools. However, it’s not possible to load all your customers, for example, into a single Google Map without a bunch of code. Nor can you easily import today’s deliveries and jump in the car—not without a lot of manual address typing.

BatchGeo’s custom maps take your spreadsheet data and transform them into visual representations that can be filtered and browsed in multiple ways. In this post, we’ll show how BatchGeo Pro enables route optimization with up to 25 locations. This all starts with gathering the data for your map.

Determine the Stops for Your Route

Before you can optimally map your route… you’ll need to figure out where you need to go. You likely already have these locations in a spreadsheet, such as Excel, Google Sheets, or a similar system. For example, perhaps you have a sales CRM or other customer database. Simply export into a CSV or other spreadsheet format:

Be sure to separate each piece of data into individual columns and include headers. For example, for a sales trip, you might have:

  • Business
  • Business contact
  • Total sales
  • Address
  • City
  • State

Each business location represents a stop on your route. It’s fine if your map has more than the stops you want to route—you’ll have a chance to select the locations before routing. But first, let’s map your data.

Make a Map of Your Stops

View Sales Route in a full screen map

There are a bunch of ways to make a map: ArcGIS and other desktop GIS software, Google Maps API, along with web-based mapping tools. Our Excel mapping tool can copy-paste directly from your spreadsheets.

  1. In your spreadsheet, select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
  2. Open your web browser and navigate to batchgeo.com
  3. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
  4. Check to make sure you have the proper location data columns available by clicking “Set Options”
  5. Click “Map Your Data” and watch as the geocoder turns your location data into coordinates

The resulting map is customizable, allowing you to adjust your map marker color, shape, map style, and more.

Create a map of a single day’s visits or go ahead and put all your customers on a single map. It’s possible through our map data visualization you’ll see new stories within your customer base. But first, let’s plan your customer or prospect visits and optimally map the route between two or more markers.

Optimally Map Your Route Between Points

Depending on your data, there may be times when you have two (or more!) points near each other. You might then wonder about the best way to navigate between them. So let’s take a look at the best way to get from Point A to Point B.

Upon right-clicking your map, BatchGeo Pro users will see both a “Data View” option and that of “Advanced Mode.”

If you turn on “Data View”, press the ⇧ Shift key and select the locations you wish to map a route between from the table below your map.

Clicking on “Advanced Mode” will reveal more selection tools in the upper left-hand corner of your map (including a digital measuring tape. For route optimization, you’ll want to opt for the Rectangle selection tool (or one of the two other selection options: Circle selection tool or Polygon selection tool). Then, capture two or more points on the map using one of the selection tools.

For both methods, you’ll now want to click Optimal Route in the lower left-hand corner of your map.

Next, you’ll want to choose your starting and ending locations. You can either choose to “Use First Selected Waypoint” for the “Starting Location” or manually enter any other location, regardless of whether it’s already a marker on your map. The same goes for your “Ending Location.”

Finally, click Map Optimal Route.

The result is a visual depiction of the best route between two points, plus the ability to hit the Navigate button to be taken to Google Maps directions.

Discover the optimal routes between your own data at batchgeo.com.

BatchGeo Ranks #1 in Satisfaction and Popularity from G2’s GIS Software Awards

Thousands of other map-makers endorsed your choice of an easy, customized map tool. BatchGeo is highly-ranked in G2’s Annual Best Software Awards. The listing ranks the world’s best software companies and products based on reviews from real users. BatchGeo was a 2022 winner and customers have again provided the feedback to get us on the 2023 list of best Geographic Information System (GIS) software.

Not only did BatchGeo score in the top three of GIS software—we’re also the #1 highest performer in some of the most important categories, satisfaction and popularity.

Check out the best-ranked GIS software for yourself, or continue reading for an in-depth look at the rankings along with a demonstration of our winning software.

G2’s GIS Highest Performer in Satisfaction is BatchGeo

Many factors go into G2’s rankings. BatchGeo users helped it climb to the top of many of the categories. BatchGeo ranks #1 in popularity, but even more satisfying is also being #1 in satisfaction. That points to happy users who can quickly convert data into interactive maps.

You can see how BatchGeo ranks in this category or note its place to the far right in G2’s top GIS Software Grid.

Most gratifying is that the satisfaction rankings are based on reviews, in which real users reported that BatchGeo is:

Excellent for a quick graphical analysis, with the ability for more in-depth analysis.

Another user said:

I have been using this product for a few years now. I like that it’s easy to copy and paste data from an Excel sheet and I like the color coded map… It is very easy to use and intuitive.

With over 1,000 reviews that average 4.7 out of 5 stars, BatchGeo is the best-reviewed and most-reviewed of the bunch.

BatchGeo Scores Among G2’s Top GIS Software Overall

GIS is a broad category, which includes downloadable desktop software and tools that programmers use to create maps with code. BatchGeo achieves the highest satisfaction and popularity, and is listed among some huge players in the overall rankings, called the G2 Score.

Of the 261 GIS companies and products ranked, the G2 Score winners were:

  1. Esri ArcGIS
  2. Google Earth Pro
  3. BatchGeo
  4. Google Maps API
  5. ArcGIS Online

BatchGeo is the only product in the top five that creates maps from spreadsheets and allows grouping and filtering based on your own data. In addition, BatchGeo outranks GIS software giants like Google Maps API and ArcGIS Online, plus 256 other tools.

G2 Score is a proprietary ranking algorithm, which takes into account many factors within real user reviews. The site also provides other sorting methods and scores. To be listed so high overall, BatchGeo performs well in many of these areas:

If you haven’t already given BatchGeo a try yourself, read on to walk through an example of how quickly you can map your own spreadsheet data.

G2’s GIS Satisfaction Winner HQs: Mapped

It’s an honor that BatchGeo customers ranked our mapping tool highly in so many categories. As we mentioned earlier, the satisfaction list is especially laudable, because it means BatchGeo users are happy with their experience. So, let’s take the data behind the top 20 G2 Satisfaction winners and map their company headquarters to show what’s possible with BatchGeo:

View G2’s GIS Satisfaction Winner HQs in a full screen map

All you need to make a custom map like the one above is some data and knowledge of copy and paste—no code required.

Here’s how we made it:

Whether your preferred platform is Excel, Google Sheets, or another option, start with a spreadsheet. We added the GIS companies that G2 ranked in the top 20 for Satisfaction with separate columns for each piece of information. Most important are columns for city, state, and country—or other location data.

From there, simply:

  1. Select (Ctrl+A or Cmd+A) and copy (Ctrl+C or Cmd+C) your data
  2. Open your web browser and navigate to batchgeo.com
  3. Click on the location data box with the example data in it, then paste (Ctrl+V or Cmd+V) your own data
  4. Check to make sure you have the proper location data columns available by clicking “Validate and Set Options”
  5. Select the proper location column from each drop-down
  6. Click “Make Map” and watch as the geocoder performs its process

Once mapped, trends you may have otherwise missed in “spreadsheet mode” become clearer. For example, we can see that of the top 20 GIS companies in Satisfaction, 13 are based in the U.S., including nine based in California, and two in Massachusetts.

Outside of the U.S., brands headquartered in the United Kingdom, Canada, France, India, Singapore, and Sweden also made it in the top 20 GIS companies.

There are plenty of insights waiting inside your own spreadsheets. Use our award-winning software to map your own data for free.

The World’s Longest Prison Sentences, Mapped

You’ve likely committed a crime. From jaywalking to failure to pay traffic tickets, petty crimes are more common than we think. These usually just result in a fine—unlike those on the opposite end of the spectrum.

The most violent criminals have committed multiple heinous acts. So how does their punishment differ from the rest? Of course, there are different prisons with varying levels of security, and then there are the lengths of prison time they’re sentenced to.

The longest prison sentence in the world is over 160 life sentences—yet as you’ll find out on the map, there are far more incarcerated for many, many years.

View Longest prison sentences in a full screen map

Prisoners Serving More than 30 Life Sentences

As of December 2022, 269 prisoners around the world have been sentenced to one or more life sentences. Assuming a life sentence means a sentence that lasts until death… how are multiple life sentences possible? The actual definition of a life sentence isn’t so cut and dry.

Those convicted of the most heinous crimes can be sentenced to multiple life sentences, including the following 10 who are all serving more than 30 life sentences.

  • Terry Nichols – 161 life sentences
  • Michael J. Devlin – 74
  • Abdullah Barghouti – 67
  • Brenton Tarrant – 52
  • Gary Ridgway – 49
  • Loi Khac Nguyen – 49
  • Martin Bryant – 35
  • Billy Joe Godfrey – 35
  • Nikolas Cruz – 34
  • Warren Troy Knoop – 32

All 10 of the prisoners noted above are serving more than 30 life sentences, though Oklahoma City bomber Terry Nichols holds the record for the most consecutive life sentences ever given to a single individual.

In 1995, Nichols was convicted of 161 counts of first-degree murder, first-degree arson, and conspiracy at the state level along with terrorism and eight counts of involuntary manslaughter in federal court. He is imprisoned in Colorado’s ADX Florence.

Along with Nichols, five of the 10 prisoners with the longest life sentences are U.S.-based: Michael J. Devlin (kidnapper), Gary Ridgway (serial killer), Loi Khac Nguyen (surviving perpetrator of the 1991 Good Guys siege), Billy Joe Godfrey (child sexual abuser), and Nikolas Cruz (Parkland mass shooter).

Meanwhile, Abdullah Barghouti of Palestine, Brenton Tarrant of New Zealand, Martin Bryant of Australia, and Warren Troy Knoop of South Africa were also sentenced to multiple life imprisonments.

Check out the rest of the prisoners with multiple life sentences on the map before moving on to more about the prisons that hold these individuals.

The Most U.S. Prisoners in for Life Are Held Here

With 269 prisoners incarcerated for life around the world, many places are needed to hold them. Of these, 133 prisoners are held in the U.S. in around 80 different correctional facilities. The 12 U.S. prisons included in the following table house at least two prisoners in it for life:

Prison # of prisoners serving life sentences
ADX Florence 10
USP Terre Haute 3
WITSEC (Bureau of Prisons’ version of the Federal Witness Protection Program) 2
United States Penitentiary, Tucson 2
United States Medical Center for Federal Prisoners 2
Red Onion State Prison 2
Potosi Correctional Center 2
Oregon State Penitentiary 2
Mule Creek State Prison 2
Federal Medical Center, Butner 2
Dodge Correctional Institution 2
California State Prison, Corcoran 2

We briefly mentioned ADX Florence before, in regards to housing Oklahoma City bomber Terry Nichols who is serving the most life sentences (161). Seeing as it’s also the facility of so many of these prisoners, let’s learn more about this Colorado supermax prison.

Officially the United States Penitentiary, Florence Administrative Maximum Facility, ADX Florence opened in 1994. As a supermax prison, it’s more secure than even maximum security facilities. This is because it’s technically a prison within a prison—or at least a unit within a prison.

ADX Florence is just one part of the Federal Correctional Complex, Florence (FCC Florence), which is situated on 49 acres of land and houses different facilities with varying degrees of security, including the United States Penitentiary, Florence High, where Richard Lee McNair is serving 2 life sentences. Yet while ADX Florence seems to be common for prisoners sentenced to life, it’s far from the only facility that houses them, as you can see on the map.

And for more on this topic, see our maps depicting if Education’s Influence on Incarceration or World Homicide Data Visualizes “Hot Spots.”