Spreadsheet Programming for Remote Sensing Image Analysis
3. DFG FOR REMOTE SENSING IMAGE ANALYSIS
A general purpose DFG for the raster image operation of spreadsheet is shown in Figure 2. The
DFG form is multiple neighborhood image operation. Various DFG’s form for raster image
operation can derive by the general purpose DFG form.
Figure 2. General purpose DFG for remote sensing image analysis using spreadsheet
Figure 3 shows various DFG’s generation and image input control panel using VBA. The control
panel generate typical operation sub-control panel for remote sensing imagery analysis, that are
point, neighborhood, multiple and statistical operation. All of the DFG’s which generated by the
control panel operate to a constant size image data set which developed for spreadsheet image
analysis.
Figure 3. DFG’s generation panel and sub-panel for remote sensing image analysis using VBA
4. DATA SET FOR DFG PROGRAMMING
Figure 4 shows remote sensing image data set for DFG programming (Sato, 2000). The No.3,
CSV (Comma- Separated Values) icons are link to 72x62 size image data for operation of
spreadsheet. These CSV images data made from original images that location is Iwate prefecture
of Japan. These images are precision geometrical corrected, projected to UTM and 30m resolution
(Iikura, 1998). The Image data are as follows.
1) Landsat TM images:
Band 1, 2, 3, 4, 5 and 7
2) Topographical maps:
Digital elevation model (DEM) with 0.1m height precision, Slope angle map derived from
DEM with 0.1 degree precision, Aspect angle map derived from DEM with 0.1 degree
precision, Sunlight incidence angle map derived from above data and incidence and zenith
angle
3) Vegetation maps:
Actual vegetation map (1978-1985) edited by Japan Environmental Agency, Land cover map
generated from above vegetation map, Automatic classification land cover map made from
TM images and land cover map (Sato, 1999).
Figure 4. Image data set for DFG operation
