Difference between revisions of "Shuozhang DataPreparation"

From Visual Analytics and Applications
Jump to navigation Jump to search
 
(7 intermediate revisions by the same user not shown)
Line 25: Line 25:
  
 
=Opting out the data files=
 
=Opting out the data files=
 +
 
The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds.
 
The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds.
  
Line 38: Line 39:
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
<br/>
 +
  
 
=Choosing the data files to compare=
 
=Choosing the data files to compare=
Line 56: Line 59:
 
</tr>
 
</tr>
 
</table>
 
</table>
 +
  
 
However, when comparing the NDVI values, the images are too blur to drive any conclusions.
 
However, when comparing the NDVI values, the images are too blur to drive any conclusions.
Line 61: Line 65:
 
[[File:Shuozhang03 cannot compare.jpg|800px]]
 
[[File:Shuozhang03 cannot compare.jpg|800px]]
  
=Combine the Data Sets=
+
Thus, only the images in June and September of 2015 and 2016 are compared respectively.
 +
 +
<br/>
 +
 
 +
 
 +
=Combining the Data Sets=
 +
 
 +
After deciding which data tables are chosen to compare, a combination of two CSV files is performed in R:<br/>
 +
 
 
[[File:ShuozhangData manipulation.JPG|350px]]
 
[[File:ShuozhangData manipulation.JPG|350px]]
 +
 +
<br/>
 +
 +
NDVI is calculated in Tableau:<br/>
 +
 +
[[File:ShuozhangCalculation.JPG|350px]]

Latest revision as of 22:19, 15 July 2017

ShuozhangRosebreastedgrosbeak.jpg
Vast Mini-Challenge 3

Introduction

Data Preparation

Insights

Deliverables

 


Opting out the data files

The data from 2014-11-28 and 2015-11-15 has been removed from the analytics process because the weather on that two days are extremely cloudy and the sensor can not detect anything due to that all the band waves cannot penetrate the clouds.

The images for those days are as the follows:

2014-11-28: 2015-11-15:
Shuozhang2014-11.JPG Shuozhang2015-11.JPG



Choosing the data files to compare

Since the apparent differences in brightness can occur between dates due to changes in sun angle and atmospheric conditions and the values of specific pixels can change due to a number of factors including Clouds, Atmospheric conditions and etc.

Therefore, the data of the dates that are relatively close in different years are chosen to be analyzed and compared.

At first, a comparison between the images in March is attempted.

Although it was a little bit cloudy that day, the other areas are quite clear.

2016-03-06
Shuozhang2016-03-06.JPG


However, when comparing the NDVI values, the images are too blur to drive any conclusions.

Shuozhang03 cannot compare.jpg

Thus, only the images in June and September of 2015 and 2016 are compared respectively.



Combining the Data Sets

After deciding which data tables are chosen to compare, a combination of two CSV files is performed in R:

ShuozhangData manipulation.JPG


NDVI is calculated in Tableau:

ShuozhangCalculation.JPG