Filter Visio External Data to Drop Shapes

I have recently been demonstrating how to automatically drop data point shapes into the correct latitude \ longitude position over a map image in Visio, and in this instalment I show how to automatically filter the dropped data points by a rectangular area. This will only work after calibrating the map image as in my previous article https://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ and then using the Data Point shape (or similar) from https://blog.bvisual.net/2015/05/27/distributing-data-points-automatically-on-maps-in-visio/

The principles of reading the Shape Data value from a selected shape to automatically drop rows from the active External Data window using the selected master shape could be applied to many scenarios.

image

Read the rest of this entry »

Distributing Data Points Automatically on Maps in Visio

In my last article, I described how to calibrate a map in Visio ( see https://blog.bvisual.net/2015/05/26/calibrating-a-map-in-visio/ ), and in this article I use a calibrated map to distribute data points from a linked data source automatically.

For this example, I drew a simple shape at the size that I want, but you could add this smartness to any shape. All you need is an external data recordset that contains the Latitude and Longitude values that need to be linked to each data point.

image

Read the rest of this entry »

Calibrating a Map in Visio

Many years ago, I wrote a blog article about calibrating a map in Visio ( see https://blog.bvisual.net/2008/09/30/moving-between-visio-and-kml/ ), but I used VBA and a shape from my friend Chris Roth / VisGuy. Well, I have now worked out how to calibrate a map without code!

This could be especially useful now that MapPoint has been deprecated Smile

image

Read the rest of this entry »

Review of Learning Bing Maps API

It is a pleasure to see this title appear because I have been developing with MapPoint and Bing Maps (nee Virtual Earth) for many years, but as an author too, I am aware how sensitive reviews are, so I am keen that any criticism should be constructive. My first impression is that it is slim at about 100 pages, but it does cover some very useful areas. The downloadable code is very useful but seems to be the draft version in parts, even being titled as such, and I did add my own Bing Maps developer credentials rather than use the ones left in the text.

First, here is the book link http://www.packtpub.com/learning-bing-maps-api/book, and the chapter titles. I used Visual Studio 2013 to test the code and ran it in Internet Explorer, Chrome and Firefox on Windows 8.1.

Learning Bing Maps API Chapter 1: Introduction to Bing Maps AJAX Control Version 7
Chapter 2: Diving into Bing Maps AJAX Control Version 7
Chapter 3: Introduction to Bing Maps REST Services
Chapter 4: Diving into Bing Maps REST Services
Chapter 5: Spatial Data Services
Chapter 6: Diving into Spatial Data Services
Chapter 7: Enriching Bing Maps with Overlaying User Data
   

Read the rest of this entry »

Chris Webb's BI Blog

Microsoft Analysis Services, MDX, DAX, Power Pivot, Power Query and Power BI

davecra.wordpress.com/

Microsoft Office 365 Development, and more...

PowerShell.Amsterdam

Automate, Accelerate, Accurate

johnvisiomvp

Life with Visio and other Microsoft Toys!

Title (Required)

Windows Server Essentials Tips & Tricks

Nilsandrey's Weblog

Just another WordPress.com weblog

Things that Should be Easy

Every so often (too often in the IT industry) I encounter things that should have been very easy to do but turned out to be far too complicated. My favorite topics include SharePoint, .Net development, and software architecture, especially distributed systems.

Visio Guy

Shapes, Stencils, Drawings Templates, Tutorials, Tips & Developer Info for Microsoft Visio

Hannes's Virtual Earth

Tips & Tricks around Mapping and Cloud Computing

Pluralsight blog

be smart, be clear, be visual ...