Excel Power Map 1

(this was originally published in the old MapPoint section of the Mapping-Tools.com HowTo pages) The Microsoft Excel Power Map is a new mapping extension for Excel 2013 and Office 365, and is a part of the Excel PowerBI (“Power Business Intelligence”) extensions. These have now been released as a part of the Excel 2013 Service ...

Converting a COM IPicture into a .NET Image 3

This article was originally published on the Mapping-Tools Howto pages for programming MapPoint. Although it was originally written with MapPoint in mind, it is useful in a wider context where a .NET application is trying to use a COM image (IPicture). Hence it has been retained and moved here. A program can create MapPoint images ...

The Windows 7 Location API

This article was originally included in the MapPoint Programming section of the Mapping-Tools.com HowTo pages. The MapPoint programming pages are being removed, but this page does not directly refer to MapPoint and remains relevant. The Location & Sensors API remains available, but Windows 10 also introduced a new Windows.Devices.GeoLocation API. Probably one of the most ...

Beware of Choropleth Maps!

Beware of Choropleth Maps!
I was recently experimenting with the new Maptitude data of 2018 Zip Code Business Counts. Free for existing customers, this data lists the total number of businesses by type (NAICS code) for every zip code in the USA. This data represents a huge number of data fields, and it is recommended that users read Caliper’s ...

Drawing SVG Superellipses with Python

Drawing SVG Superellipses with Python
Superellipses are a little bit of a mathematical oddity, resembling rounded squares or square-ish circles. They are, however, becoming popular for icon outlines. iOS currently uses them, as do recent versions of Android. This article shows you how to use Python to create an arbitrary superellipse in SVG. This can then be used as an ...

Using Rasbian Stretch and pygame with the AdaFruit 2.8″ Touchscreen 2

I am currently putting together a lawn sprinkler control system based around a Raspberry PI 3 Model B+ and the OpenSprinkler system. I will post a much more complete post when it is working, but here are a couple of useful tips that I’ve found. Although it will be programmed using a web interface over ...

How to easily improve the quality of OpenStreetMaps

There are many ways that you can help to improve the quality of OpenStreetMap data. After familiarizing yourself with OpenStreetMap features and tags, you can use a tool such as JOSM or iD to verify and if necessary correct the features in an area which you are intimately familiar with. For example, you might initially ...

Extracting OpenStreetMap Data for Ultra Mileage

Although we supply a number of PBF extract files from the OpenStreetMap global ‘planet’ file, it is possible to create your own extracts for use with the Ultra Pre-Processor to create custom road packs. Our own extracts are created using the Osmosis command line tool. There are other feature extraction tools such as the Overpass API, ...

How to Edit OpenStreetMap Data

One of the advantages of the OpenStreetMap data used by our Ultra Mileage system, is that you can add your own corrections. Other commercial data providers typically take over a year for their changes to be taken into account. OpenStreetMap changes appear in their master database immediately, and we regenerate our road packs every 1-2 ...

Accessing a COM Server from R

Microsoft have recently added support for R to their Visual Studio 2015 development environment. R is a programming language for statistical and graphical programming that is widely used by statisticians and data miners. To use R with Visual Studio, you need to download and install R Tools for Visual Studio and Microsoft R Open. These ...