Mandi Assignment Data Preparation

From Visual Analytics and Applications
Jump to navigation Jump to search
VAST Challenge 2017 MC 3

Introduction

Data Preparation

Data Exploration

Final Answer

Visualization Result

Comments


The data set has two forms of image data: TIF files and ASCII files. Both of them contains same information. I use QGIS to load the TIF files for visualization and JMP to load the ASCII files for stacking data.

Noise Data Filtering

There are totally 12 TIF files. I load them into QGIS and mapped B3, B2 and B1 to RGB and generate the "true-color" images as below.
Noise check.JPG
When looking at these "true-color" images, there are three images in which the preserve area cannot be seen clearly due to the clouds.
These three images are taken on 2014-11-28, 2015-11-15 and 2016-03-06.
As the clouds have covered more than 90% of the area in these images, I think they are meaningless to my further analysis.
Hence, I take the three images as noise data and they should be filtered out.

Besides, among the remaining nine images, I noticed that the image which was taken on 2016-09-06 is a little different from the others.
In the other eight images, there are many bad pixels in the right bottom corner due to sensor failure or electronic noise.
Compared to others, the image taken on 2016-09-06 is much more clear. It is a good choice to locate the position of the Boonsong Lake in the preserve.

Load Data into JMP

Concatenate Data

To compare the changes in different days, I concatenate the data in JMP as below. It will create one column as the "Source Table".
Concatenate.jpg

Add Date

Then I add a column "Date", which shows the date of the image.

Date.jpg

NVDI Calculation

According to the definition of NDVI (Normalized Difference Vegetation Index): NDVI = (B4 - B3) / (B4 + B3), I add the formula to calculate the NDVI value.
NDVIC.jpg

Create Bins in Tableau

The bands are continuous measures. Any discrete field in Tableau can be considered as a set of bins.
In the Data pane, right-click a measure and select Create > Bins. In the Create Bins dialog box, I entered 5 in the Size of bins field since the range of all the band values are between 0 and 255.
CreateBin.jpg BinSize.jpg
Then a new binned field appears in the Dimensions area of the Data pane.