| Print |
Conditional formatting of cell
colors |
| Minimum Size |
Reduction image size to minimum
of cells |
| Recover Size |
Normal cell size recover
|
| Half Size |
Reduction image size to half of
normal |
| Shift Left |
Delete setup values and colors
area |
In order to display of thematic map, macros sequence as follows.
- The CVS data on the spreadsheet will be right shifted by execution of "Shift right" macro.
- "Legend set" macro will setup legend colors and initial values, minimum, average and maximum value of the CVS data. These initial values and legend colors can change.
- "Paint" macro will color paint to the CVS data area according to the setup values. The macro will be colored quickly by conditional formatting operation. If setup values are outside of the CVS data, the cell color will be white.
- "Minimum size" macro will show a reduction size image. Fig.3 shows an example of the minimum size image display.
- "Recover size" macro
will recover cell size at the loading CSV data,
and "Half size" macro will display at half size
of the image.
Fig.3 Image display by VBA macro function
The data set is created automatically using a UNIX shell command. The command readout data from the geometrical corrected 4350 x 6800 pixel image of TM, topographical maps and vegetation maps. All of the images are converted to JPEG format, all of the texts are written by HTML format. All of the Layer2 images are drawn grid line. Then make a hundred subdirectories to save of Layer3 data. Each of the Layer3 subdirectory includes 16 images, 13 CSV data, and some text files. All of a Layer2 data set will creates less then 25 minutes using the HP 9000/C240.
5. Conclusion
We developed data sets of useful for remote sensing education. The data set has been using at a college and others. However, the data set does not assist a guide of elementary knowledge for remote sensing. An explanation of this guide is necessary for practical use of the data set. Internet WWW browser and Microsoft EXCEL have been utilized by many people. In order to promote of remote sensing education, the tools can not ignore. This paper showed useful data set using the tools.
References
Iikura, Y., Yokoyama, Y., 1998, Ortho-rectification of Landsat TM imagery and its evaluation. Journal of the Japan Society of Photogrammetry and Remote Sensing, Vol.37, No.4, pp. 12-22
Sato, K., Iikura, Y. and Yokoyama, R., 1999,Automatic category assignment of satellite images using vegetation map. Journal of Remote Sensing Society of Japan, Vol.19 No.4,pp. 40-48
