Applications:Using
How To Use
Data Mapping
Displaying geographical data pictorially in conjunction with database information used to
be confined to powerful mapping systems. However, the Data Map module in Microsoft Office
used in conjunction with Excel can provide a solid introduction to the potential of using
geographical information systems.
By Mike Lewis
G
eographical Information Sys
of customers and plotting them on a
Setup will proceed to install Data Map,
tems (GIS) is one of the fastest
map. Or it might take the same list of
along with some sample data.
growing categories of desktop
customers, combine it with a list of
You can now go ahead and create
software. If your data has any kind of
dealers, and print a report highlighting
your first map. To do so, you will need
geographical dimension, a GIS pack
the cities where new dealers need to be
a worksheet containing some sort of
age can help you manipulate and vis
recruited.
geographical data. A list of addresses
ualise it in ways you might not have
GIS is especially good at analysing
will be fine, provided it includes a col
thought possible. Not surprisingly, the
data according to its spatial relation
umn for country name, Australian
technology is becoming very popular,
ships with other data. For example,
state name, US state abbreviation, UK
especially in fields such as marketing,
you might use it to identify all house
postcode, or something similar. If you
distribution, demographics, planning
holds within a certain distance of a
have nothing else suitable, use the
and government.
river at risk from flooding, or to count
sample mapstats.xls file, which by de
Unfortunately, casual users are
the number of people living within so
fault is installed in \Program Files\
often discouraged from getting started
many kilometres of a new shopping
Common Files\Microsoft Shared\
in GIS, mainly because of the high costs
centre. If you have a digital base map
DataMap\Data.
and large amounts of learning time in
of the area in question, you can display
Start by selecting a worksheet range
volved. Most GIS packages are compli
the results in map form for easy visu
that contains the data you want to
cated, expensive and demand high
alisation.
map. Be sure to include the column
spec hardware. The required digital
The Data Map module is not really
containing the geographical element
maps add substantially to the cost.
capable of performing the more so
(country name or whatever) and, if
In this article, I will show you an
phisticated GIS functions, but it is very
possible, at least one numeric value.
easier way of getting started in GIS,
good at plotting data and creating the
Next, click on the Map button, and use
using easy to learn software that you
matic maps. A selection of base maps
the mouse to draw a rectangle any
probably already own. The software in
is supplied with the product (see Fig
where on the worksheet.
question is the Data Map module,
ure 1); others can be purchased sepa
As soon as you release the mouse,
which is part of Microsoft Office 95. In
rately. The module is accessed from
Data Map will start analysing the data.
Office 97, the module is called Mi
inside Excel, and works directly with
After a few seconds, your map should
crosoft Map, but is identical to Data
data in the Excel worksheet.
appear within the rectangle.
Map; for convenience, both modules
Figure 2 shows a map generated
will be referred to as Data Map.
Getting Started
Data Map is a cut down version of
MapInfo, which is one of the best
The first step in using Data Map is
Australia
Canada
known GIS products. Although it has
to check that it has been installed. To
only a fraction of the features of the full
Europe
do so, click on the Map button near the
version, Data Map is still an excellent
right hand end of the main Excel tool
Mexico
tool for entry level applications.
bar. If the mouse pointer changes to a
North America
cross hair, all is well (you can press
UK standard regions
United States with Alaska and
Background To GIS
ESC now to cancel the operation). If
not, you will need to run Office Setup.
Hawaii inserts
A GIS is essentially a program that
From
within
Setup,
click
on
World countries
analyses and displays data according
Add/Remove. Select Microsoft Excel
to the geographical elements within it.
and click Change Options. Select Data
Figure 1 Base maps supplied
That might be as simple as taking a list
Map, click OK, then click Continue.
with Data Map.
Update 104 (June 1997) page 17
File: A0913.1
PC Support Advisor
Next page >
New! The best sites for quality inkjet printer cartridges and the best sites for cheap inkjet cartridges