A Longitude Latitude Work Flow for Map Business Online

Sometimes your business requires latitude and longitude points to get some work done. I know this happens because customers call and ask for lat/lon support.

Our top mapping software development expert, who designs our online business mapping, recently suggested this work flow which I thought would be nice to share with users.

There are two aspects to this latitude longitude generation work flow. The first involves importing a list of addresses and converting them to lat/lon coordinates. The second is building your own data from scratch in MapBusinessOnline. I’m going to show you how to conduct both processes on one imported address spreadsheet when using our business mapping software.

Append Your Imported Address Spreadsheet with Lat/Lons

  1. First, create and import a spreadsheet of addresses. Make sure your address spreadsheet includes a column for latitude and a column longitude.
  2. To convert your addresses to lat/lon coordinates open the Map Business Online Data Window view and select your imported data. Find a target record in your data. On the far-left side, hover your cursor over the colored dot (Green or Yellow) of the first record with an address. A Pencil icon pops up. Choose Edit Address and Location.
  3. In the Map dialogue that opens you’ll see your address location represented by a Red MapPoint. Place your cursor at the base of the Red MapPoint. In the left Address Box you should now see a Lat/Lon listed. Check the box to Update address data. Click Save New Location.
  4. Your data should now show a Latitude and Longitude record instead of an address record in the Data Window view of your imported data.

Add Additional Lat/Lon to Your Imported Address Spreadsheet

Another way to derive lat/lon coordinates in Map Business Online is to “drop a point on the map.” For this approach, we use the Draw Tools, under Drawing Tools on the Master Toolbar. Draw tools are currently located at 7 buttons in from the far right. Usually the Text Button (ABC) is displaying, until you choose another button in the dropdown.

  1. In the Draw Tool Drop Down choose the bottom option called Location to place a Map Point. Click anywhere on the map where you want the Map Point to be located.  Just click.  If you want to move it, click it again. Wicked easy. A select dataset dialogue will popup.
  2. In the Select Dataset dialogue choose your address spreadsheet. (Here you also have the option to start a new dataset. That’s the way  to create a Lat/lon dataset from scratch.)
  3. Click Add Location to add your data to the imported address spreadsheet. Be sure to name your location.
  4. Save and exit.

As always you can export your data using the Export button on the far right of the Data Window toolbar.

Applications for Lat/Lon Collection

Users want latitude and longitude coordinates for a variety of reasons. For one, those coordinates never change postal addresses change sometimes. I’ve seen many organizations label their assets and facilities with lat/lon coordinates. This is common in public safety and government work flows.

Coordinate location maps are perfect for planning or documenting a hiking expedition. So that’s a fun application. Remember Walter White (Breaking Bad) buried all his cash in the desert and took coordinates to share where the secret hiding place was. He was having so much fun.

Marketing groups use lat/lons to define billboard locations. Banks locate ATMs based on exact coordinates. Field assets are often located based on tracked Latitude and Longitude coordinates.

Latitude and Longitude has multiple formats, which Map Business Online should support.  We recently added degrees, minute, seconds support. Examples might be:


Lat/Long Labels

You will noted that the Call Out tag on the picture above references Lat/Lon coordinates. An imported Lat/Lon address will be referenced in the callout where an Address might typically be referenced.  For dropped points using the draw tools click the Plus option on the callout to see the associated latitude and longitude coordinate.

Working with latitude and longitude coordinates may be intimidating at first. Relax and try it. Soon, with the help of Map Business Online you’ll feel a little like Columbus or Magellan navigating your way across the seas. At least you’ll know exactly where you buried your cash.

We recommend users access MapBusinessOnline via the downloadable Map App.

The Map App install is fast and easy. The Map App is a cloud-based service, once you’ve logged in you’ll have access to all of your previously saved maps and data. The Map App is a better user experience and provides access to more features than the Web App. The Flash-based Web App link will remain available until December 15, 2020.

The Map App includes the new Map Viewer app for free non-subscriber map sharing.

Find out why over 25,000 business users log into www.MapBusinessOnline.com for their business mapping software and advanced sales territory mapping solution.

Contact: Geoffrey Ives geoffives@spatialteq.com or Jason Henderson jhenderson@spatialteq.com (800) 425-9035

MapPoint users please consider www.MapBusinessOnline.com as your MapPoint Replacement.

Please read customer reviews or review us at Capterra, G2Crowd (LinkedIn connected), or at the Salesforce.com AppExchange.


About Geoffrey Ives

Geoffrey Ives lives and works in southwestern Maine. He grew up in Rockport, MA and graduated from Colby College. Located in Maine since 1986, Geoff joined DeLorme Publishing in the late 1990's and has since logged twenty-five years in the geospatial software industry. In addition to business mapping, he enjoys playing classical & jazz piano, gardening, and taking walks in the Maine mountains with his Yorkshire Terrier named Skye.
This entry was posted in Uncategorized and tagged , , , . Bookmark the permalink.

Leave a Reply