Development of data set for analysis of landsat tm images
Using www browser and spreadsheet
There are 17 Layer2 images in the data set. The image size of the Layer2 is 720x620 pixel. The size and location coincide with 1:50000 geographical map issued by the Geographical Survey Institute of Japan. Each of Layer2 images is divided into 10x10 grid for assignment Layer3 image using WWW browser. The size of Layer3 images is 72x62 pixel. The images are icons for WWW browser. A selection of the image will start of loading the corresponding CVS data.
The Layer2 and Layer3 images have statistics data, minimum, maximum, mean and standard deviation. The Layer3 statistics data are displayed besides the images as Figure.2.
Fig.2 Layer3 images using WWW browser
3. CSV Data And Its Calculation
3.1 Numerical value of the data set
There are two
types of the CSV data. Those are
- 1 byte length integer
- TM band 1,2,3,4,5 and 7
- Vegetation map,7-merged
vegetation map and Automatic classification land
cover map
- 2 bytes length integer (multiplied by 10)
- DEM with 0.1m resolution
- Slope angle map, Aspect angle map, Sunlight incidence angle map with 0.1degree resolution
- These CSV data will be
read by Microsoft EXCEL automatically, and
displayed the numerical values on the
spreadsheet if the WWW browser setup so.
3.2 VBA macros
The CVS data on the spreadsheet will display or calculate using Microsoft EXCEL. The result of the calculation can be displayed as a thematic map using VBA macros. Table1 shows the VBA macro names and their operations.
Table 1 VBA macro operation
for image display
| Macro Name |
Operation Name
|
| Shift right |
Insert two columns at left side
of Layer3 data |
| Legend Set |
Setup two values and paint
color for conditional formatting
|
