Development of data set for analysis of landsat tm images Using www browser and spreadsheet

Kiyotada Sato
*Ichinoseki National College of Technology
Takanashi,Hagisyo,Ichinoseki-shi,Iwate
021-8511,JAPAN
Tel:(81)-191-24-4738 Fax: (81) -191-24-2146
E-mail:satok@ichinoseki.ac.jp

Ryuzo Yokoyama
Ueda 4-3-5,Morioka,Iwate
020-8511,JAPAN
Tel:(81)-19-621-6478 Fax: (81) -19-621-1170
E-mail:Yokoyama@cis.iwate-u.ac.jp

Keywords: Remote sensing education, WWW browser, Spreadsheet, VBA macros

Abstract:
We have developed a data set for education of Landsat TM images using WWW browser and spreadsheet. The data set includes images for display and CSV numerical data for calculation. The CSV data are calculated using Microsoft EXCEL spreadsheet. The result can be displayed as a thematic map with VBA macros. All of the data set has created automatically using UNIX shell.

1. Introduction
Recently, variety satellite imageries and digital maps have been available. However, those data are not necessarily used actively for education purpose. One of the reasons, there is no adequate data set and calculation techniques using personal computer. Therefore we developed a data set for education of remote sensing image analysis. The data set includes image and numerical data of TM, topographical map and vegetation map. The images are displayed with WWW browser online or offline. Some of the images are converted to Comma-Separated Values (CSV) numerical format data. The CSV data are calculated with Microsoft EXCEL spreadsheet. The result of the calculation can be displayed as a thematic map using Microsoft EXCEL Visual Basic for Applications (VBA) macros developed by us.

The data set require preliminary operation skills of a WWW browser and a spreadsheet. In the near future, the skills will be taught at any school. The data set using WWW browser and spreadsheet will be appropriate style for remote sensing education.

2. Image Data And Its Display

2.1 Image data
All images in the data set are made in JPEG format for full color display by any WWW browser. The images are geometrically corrected and projected by UTM and 30m resolution (Iikura, 1998). There are 17 images, those are

1) Landsat TM images:
Band 1,2,3,4,5 and 7 images
Natural colored image (Band 3=Red, 2=Green, 1=Blue)
Pseudo colored image (Band 4= Red, 5=Green, 6=Blue)


2) Topographical maps:
Digital elevation model (DEM)
Slope angle map calculated by DEM
Aspect angle map calculated by DEM
Sunlight incidence angle map calculated by above data and incidence and zenith angle 1:50000 geographical map

3) Vegetation maps:
Vegetation map edited by Japan Environmental Agency
Land cover map made from above vegetation map
Automatic classification land cover map


In the vegetation maps, The land cover map (7-merged vegetation map) is made from the vegetation map which merge into grass, conifer leaf forest, broadleaf forest, paddy, town, water and unclassified. The automatic classification land cover map (ACAI) is made from cluster image by ISODATA unsupervised classification to get maximum value of a classification accuracy (Sato, 1999). We suppose the map shows detailed land covers.

2.2 Link structure of the images
There are three types of the image size for browsing. We call those images "Layer1", "Layer2" and "Layer3". Fig.1 shows link structure of the images.