Spreadsheet Programming for Remote Sensing Image Analysis
Kiyotada SATO
Dept. of Mechanical Engineering
Ichinoseki National College of Technology
Hagisho, Ichinoseki, Iwate, 021-8511
Tel:(81)-191-24-4738 Fax:(81)-191-24-2146
JAPAN
E-mail: satok@ichinoseki.ac.jp
Ryuzo YOKOYAMA
Professor, Dept. of Information & Computer Sciences
Faculty of Engineering
Iwate University
4-3-5, Ueda, Morioka, Iwate, 020-8551
Tel:(81)-19-621-6478 Fax:(81)-19-621-6478
JAPAN
E-mail: yokoyama@cis.iwate-u.ac.jp
ABSTRACT Spreadsheet program is written by the end-user using dataflow graphs and
mapping work. The programming paradigm is effective in the raster image processing. We
applied the spreadsheet programming to satellite remote sensing image processing and GIS
education and research. In order to achieve for the applications effectively, we have developed
image data set, basic dataflow graphs set, and typical template worksheet models for imagery
analysis.
1. INTRODUCTION
Programming paradigm of spreadsheet is a mapping by the dataflow
graphs(DFG’s,Navarro-Prieto, 2001). The DFG’s programming is an effective method for the
operation of the raster image data. We have applied the DFG’s programming to the remote sensing
imagery analysis using satellite, geographical and vegetation map images. This paper shows
DFG’s programming method and some application for remote sensing image analysis. In order to
achieve for the applications effectively, we have developed image data set, basic dataflow graphs
set, and typical template worksheet models for imagery analysis.
2. DFG PROGRAMMING OF SPREADSHEET
A Cell expression of spreadsheet shows a relationship of input-output data and contents of
operations. The relationship looks like a one-way graph of the dataflow computer programming.
For example, NDVI operation program using spreadsheet will be written as shown in Figure 1. In
this case, a and b are input images, y is operation output image. NDVI value of y image will be
calculated as follows.
Figure 1. NDVI operation using spreadsheet
Cell K2 expression of the worksheet will be written as follows.
= (F2-A2) / (F2+A2)
The cell expression shows DFG between specified location input tokens of a, b images and output
token of y image as shown in Figure 1. The cell K2 expression will be copied from K2 to N5 in
square shape. The copy work of the DFG shows mapping from domains a, b to range y.
In general, a DFG of spreadsheet is designed to copy in the wide range as shown in Figure 1. In
order to maintenance of the mapping work, a DFG is designed so that the structure may become
simple. Domain and range data fields of spreadsheet are designed so that the structure may
become simple, too. As a result, template model of spreadsheet for a specific problem is
developed. The template models of spreadsheet will have typical DFG set, typical data field forms
to reuse by specified end-user.
