Extracting data from a business map shouldn’t be difficult. If it is, call and complain. In Map Business Online, downloadable data is generally viewed in the Data Window. The Data Window is a tabular view of data – your imported business data and our shared geographic map layers and demographic data. They all live happily together in the Data Window.

Open the Data Window by clicking the Spreadsheet icon on the master toolbar in Map Business Online.

Think of the Data Window as your map-based spreadsheet. Within the Data Window are many functions, including:

• The ability to sort data columns – Click the header of any column to shift the sort arrangement
• The ability to filter data – Click the Funnel icon on the Data Widow toolbar to filter data column records by modifiers. Filter sales records by dollar volume or customer addresses by sales rep. modifiers include >, <, =, contains – all that good query enhancement stuff
• The ability to select from a dropdown any map layer or data layer from the business map. View ZIP codes, imported data, or marketing lists
• The ability to add relevant demographic data or imported business data to your map analysis using the More Data tab
• The ability to manage, edit or delete territory alignment and territory analysis
• The ability to extract ZIP codes from an area of interest or a territory
• The ability to total data columns
• The ability to copy and paste data rows into third-party applications
• The ability to filter map and data views on by map view
• The ability to extract data out of Map Business Online as a . CSV file

It is the extraction of imported business data or included MBO data that I am interested in discussing in this blog.

Data Extraction

Map Business Online users extract data from the application in a variety of ways. These data results save as marketing lists or query results exported as a CSV file using the right-most button on the Data Window Toolbar. Sometimes the application is a search/filter tool for querying imported location-based data. Read more about filtering in Map Business Online.

A popular data extraction action in Map Business Online is a ZIP code list defined by an area of interest. That area could be a selected county, a group of counties, a territory, or simply a map object, like a circle or a polygon.

ZIP code extraction is impacted by the fact that ZIP codes come in two flavors:

• Boundary ZIP Codes – Geographic areas defined by a five-digit ZIP code. What most of us think of as ZIP codes
• Point ZIP Codes – Large facilities that are a single drop-off point for mail – Hospitals, Universities, etc.

Map Business Online users have two possible paths for ZIP code extraction. One exports all types of ZIP codes: point and boundary ZIPs. The other is more basic and extracts boundary ZIP codes. Any sales organization tracking sales will want to extract the Point & Boundary ZIP codes to capture all records

Extracting ZIP Codes by Map Object (Polygon or Circle)

To export just the Boundary ZIP Codes associated with a map object, follow these steps:

1. Draw a Map Object and note the Search Data pop-up menu.
2. Select the ZIP5 codes layer (visible or invisible).
3. Name the ZIP Code list and click Create. The Data Window Opens.
4. Export using the Data Window Toolbar’s Export button on the right.

Video: Extract Boundary ZIP Codes by Map Object (Polygon or Circle)

To export ALL point and boundary ZIP Codes within a map object, follow these steps:

1. Draw a Map Object and note the Search Data pop-up menu.
2. Select the ZIP5 codes layer (visible or invisible).
3. Name the ZIP Code list and click Create. The Data Window opens.
4. Click the Export button – far right on Data window Toolbar.
5. After you click the Export button, you’ll see options to a.) Export by territory, and b.) Include Point ZIPs.
6. Click Next, and then Save the exported file.

To Export All Territories with all ZIP Codes

1. In the Data Window, select the ZIP code layer.
2. Click the Export button – far right on Data window Toolbar.
3. After you click the Export button, you’ll see options to a.) Export by territory, and b.) Include Point ZIPs.
4. Click Next, and then Save the exported file.

Demographic Data Extraction

Another popular data extraction exercise among the Map Business Online user base is the demographic data pull. The easiest way to achieve a demographic data extraction is to select an area of interest or a map object (circle, polygon,  a blob) and click the sideways M on the mini-toolbar associated with the selected region.  That’s the summary button.

Clicking the summary button opens a dialogue that defaults to our Demographic Library of data layers. Select up to ten categories for your pull.  Move those layers to the right panel, click Next, and save your data.

The Data Window’s More Data button will allow more demographic layering and more filtering and query options when conducting territory analysis. Once you’ve derived your demographic results, export by clicking the right-hand button on the Data Window toolbar.

Data extraction in Map Business Online is easy.  And it beats tooth extraction, that’s for sure.

_______________________________________________

Find out why over 25,000 business users log into www.MapBusinessOnline.com for their business mapping software and advanced sales territory mapping solution. The best replacement for Microsoft MapPoint happens to be the most affordable.

To access MapBusinessOnline, please register and then download the Map App from the website – https://www.mapbusinessonline.com/App-Download.aspx.

After installing the Map App, the MapBusinessOnline launch button will be in the Windows Start Menu or Mac Application folder. Find the MapBusinessOnline folder in the Start Menu scrollbar. Click the folder’s dropdown arrow and choose the MapBusinessOnline option.

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

Please read customer reviews or review us at Capterra or g2crowd.

Contact: Geoffrey Ives geoffives@spatialteq.com or Jason Henderson jhenderson@spatialteq.com