Premium
A Microsoft VBA Application for Generating Heat Maps
Author(s) -
Polczynski Mark,
Polczynski Michael
Publication year - 2014
Publication title -
transactions in gis
Language(s) - English
Resource type - Journals
SCImago Journal Rank - 0.721
H-Index - 63
eISSN - 1467-9671
pISSN - 1361-1682
DOI - 10.1111/tgis.12082
Subject(s) - visual basic for applications , thematic map , computer graphics (images) , grid , computer science , map projection , feature (linguistics) , segmentation , data mining , cartography , geography , database , artificial intelligence , programming language , linguistics , philosophy , geodesy
A choropleth map is a form of thematic map used to portray the structural characteristics of some particular geographical distribution not apparent in data presented in tabular form. Preparation of a choropleth map starts with the assignment of map features to classes based on the value of a specific feature attribute followed by the association of classes of features with appropriate map colors or symbols. Map features are often geographical regions with naturally or artificially defined boundaries, but choropleth maps can also be prepared by segmenting the area to be mapped into a regular grid of regions. Maps prepared with each grid shaded in an intuitive manner such as blue for grids with the lowest attribute values to red for the highest values can be termed “heat maps”. This technical note describes the HeatMap Microsoft Excel application which converts information contained in a worksheet into a heat map, and then converts the heat map into a file suitable for display using mapping systems such as Google Earth. An example illustrates how the application can be used to visualize the seventeenth century frontier between the Polish/Lithuanian Commonwealth and the Ottoman Empire.