Premium
A Microsoft Excel Application for Automatically Building Historical Geography GIS Maps
Author(s) -
Polczynski Michael,
Polczynski Mark
Publication year - 2013
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.12002
Subject(s) - microsoft excel , computer science , computer graphics (images) , geographic information system , geography , cartography , world wide web , operating system
The ability to visualize location and time information on satellite‐generated maps using geographic information systems ( GIS ) such as G oogle Earth has enabled researchers with limited mapping expertise to use GIS for a wide range of applications. GIS holds special benefits for research in historical geography involving visualization of events and time‐based changes in geographical information. This article describes a Microsoft Excel VBA application which automatically converts information contained in a Microsoft Excel workbook into a.kml (Keyhole Markup Language) file suitable for display by mapping systems such as G oogle Earth. The application requires no knowledge of KML or Excel VBA . An example illustrates how the application can be used to trace the Mongol invasion of Eastern Europe.