Difference between revisions of "Assign NGO SIEW HUI Data"
(12 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <!-- | + | <div style=background:#2B3856 border:#A3BFB1> |
− | {|style="background-color: | + | [[Image:vaa1.jpg|250px]] |
− | | style="font-family:Century Gothic; font-size:100%; solid # | + | <font size = 5; color="#FFFFFF">ISSS608 Visual Analytics and Applications - Individual Assignment Report</font> |
+ | </div> | ||
+ | |||
+ | <!--MAIN HEADER --> | ||
+ | {|style="background-color:2B3856;" width="100%" cellspacing="0" cellpadding="0" valign="top" border="0" | | ||
+ | |||
+ | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width=20%" | | ||
; | ; | ||
[[ISSS608_2016-17_T3_Assign_NGO_SIEW_HUI| <font color="#FFFFFF">Background</font>]] | [[ISSS608_2016-17_T3_Assign_NGO_SIEW_HUI| <font color="#FFFFFF">Background</font>]] | ||
Line 7: | Line 13: | ||
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#72777d; text-align:center;" width="15%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#72777d; text-align:center;" width="15%" | | ||
; | ; | ||
− | [[ | + | [[Assign_NGO_SIEW_HUI_Data| <font color="#FFFFFF">Data Preparation</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | ||
; | ; | ||
− | [[ | + | [[Assign_NGO_SIEW_HUI_Q1| <font color="#FFFFFF">Question 1</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | ||
; | ; | ||
− | [[ | + | [[Assign_NGO_SIEW_HUI_Q2| <font color="#FFFFFF">Question 2</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="15%" | | ||
; | ; | ||
− | [[ | + | [[Assign_NGO_SIEW_HUI_Q3| <font color="#FFFFFF">Question 3</font>]] |
| style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | | style="font-family:Century Gothic; font-size:100%; solid #1B338F; background:#2B3856; text-align:center;" width="20%" | | ||
; | ; | ||
− | [[ | + | [[Assign_NGO_SIEW_HUI_Feedback| <font color="#FFFFFF">Feedback</font>]] |
| | | | ||
Line 38: | Line 44: | ||
<br/> <br/> | <br/> <br/> | ||
− | |||
− | |||
− | |||
+ | <div class="center"> | ||
+ | '''Plot of X,Y-Coordinates with Map Overlay:''' | ||
+ | [[Image:ngo_locsmap2.png|600px|center|border|Plot of X,Y-Coordinates with Map Overlay]] | ||
<br/> <br/> | <br/> <br/> | ||
− | '''Close-up View of Factories & Sensors Locations: ''' | + | '''Close-up View of Factories & Sensors (S1-S9) Locations:''' |
− | + | [[Image:ngo_locsmap.png|600px|center|border|Close-up View of Factories & Sensors Locations]] | |
− | [[Image:ngo_locsmap.png|600px]] | + | </div> |
<br/> <br/> | <br/> <br/> | ||
Line 56: | Line 62: | ||
[[Image:ngo_sensorformat.png|400px]] | [[Image:ngo_sensorformat.png|400px]] | ||
<br/> <br/> | <br/> <br/> | ||
− | * '''Chemical''': Which one of the four chemicals detected by the sensors | + | * '''Chemical''': Which one of the four chemicals detected by the sensors. |
− | * '''Monitor''': Which one of the nine sensors picking up the reading | + | * '''Monitor''': Which one of the nine sensors picking up the reading. |
− | * '''Reading''': The air sensor detected amount in parts per million | + | * '''Reading''': The air sensor detected amount in parts per million. |
− | * '''Date Time''': The date and time | + | * '''Date Time''': The date and time of the reading, local time with no change for Daylight Savings. |
<br/> | <br/> | ||
'''Note''': From the dataset, it is observed that the sensor readings are being taken at <u>one-hour interval</u>. | '''Note''': From the dataset, it is observed that the sensor readings are being taken at <u>one-hour interval</u>. | ||
Line 65: | Line 71: | ||
<br/> <br/> | <br/> <br/> | ||
===Meteorological Data=== | ===Meteorological Data=== | ||
− | + | The meteorological data contains 3 months of readings (i.e. '''April''', '''August''' and '''December''') in the following format: | |
− | * | + | <br/> <br/> |
+ | [[Image:ngo_windformat.png|400px]] | ||
+ | <br/> <br/> | ||
+ | * '''Date''': The date and time of the readings, local time with no change for Daylight Savings. | ||
+ | * '''Wind Direction''': The compass directions where the wind is originating from, using a north-referenced azimuth bearing where 360/000 is true north. | ||
+ | * '''Wind Speed''': The speed of the wind in meters per second. | ||
+ | <br/> | ||
+ | '''Note''': From the dataset, it is observed that the meteorological readings are being taken at <u>three-hour interval</u>. | ||
+ | |||
+ | <br/> <br/> | ||
+ | ==Data Preparation== | ||
+ | |||
+ | For meteorological data, the readings for Wind Direction have been rounded up to the nearest 10 degrees. | ||
− | + | To calculate the length of wind sticks (refer to Question 3), which is a form of vector representation of the wind records, the following formulas are applied to calculate the readings on scaled axes (Y and X): | |
− | |||
− | * [ | + | * Y = COSINE(RADIANS([WIND DIRECTION]))*[WIND SPEED]) |
+ | * X = SINE(RADIANS([WIND DIRECTION]))*([WIND SPEED]+X)) | ||
− | + | Reference: https://community.tableau.com/thread/177425 | |
− | |||
− | + | <br/> <br/> |
Latest revision as of 02:27, 17 July 2017
|
|
|
|
|
|
Contents
Datasets Provided
The datasets consist of sensor readings from a set of air-sampling sensors and meteorological data from a weather station in proximity to the factories and sensors.
Location Data
The factories and sensors locations are provided in terms of x,y coordinates on a 200x200 grid, with (0,0) at the lower left hand corner (southwest). The sensors map shows the locations of the sensors and factories by number for the sensors and by name for the factories. Some of the other features of the map (such as entrances and gates in that area) have been removed for readability.
Sensor Data
When Mistford began growing its manufacturing industry, both the town and the companies wished to ensure an environmentally sound and economically supportive partnership. With these aims in mind, air sampling sensors have been placed near the town and in the Preserve to monitor air quality. These sensors collect information on several substances of potential concern, including: Appluimonia, Chlorodinine, Methylosmolene and AGOC-3A.
The sensor data contains 3 months of readings (i.e. April, August and December) in the following format:
- Chemical: Which one of the four chemicals detected by the sensors.
- Monitor: Which one of the nine sensors picking up the reading.
- Reading: The air sensor detected amount in parts per million.
- Date Time: The date and time of the reading, local time with no change for Daylight Savings.
Note: From the dataset, it is observed that the sensor readings are being taken at one-hour interval.
Meteorological Data
The meteorological data contains 3 months of readings (i.e. April, August and December) in the following format:
- Date: The date and time of the readings, local time with no change for Daylight Savings.
- Wind Direction: The compass directions where the wind is originating from, using a north-referenced azimuth bearing where 360/000 is true north.
- Wind Speed: The speed of the wind in meters per second.
Note: From the dataset, it is observed that the meteorological readings are being taken at three-hour interval.
Data Preparation
For meteorological data, the readings for Wind Direction have been rounded up to the nearest 10 degrees.
To calculate the length of wind sticks (refer to Question 3), which is a form of vector representation of the wind records, the following formulas are applied to calculate the readings on scaled axes (Y and X):
- Y = COSINE(RADIANS([WIND DIRECTION]))*[WIND SPEED])
- X = SINE(RADIANS([WIND DIRECTION]))*([WIND SPEED]+X))
Reference: https://community.tableau.com/thread/177425