IISSS608 2016-17 T3 Assign ASMIT ADGAONKAR preparation

From Visual Analytics and Applications
Revision as of 19:48, 16 July 2017 by Asmita.2016 (talk | contribs) (dataprep)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search
  1. Sensor Data was joined(on Date/Time) with the Meteorological data followed by a join(Sensor#/Point Name) with the Latitude/Longitude data of the sensor/factory points provided by the challenge setters.
  2. A few calculated fields were created in the tableau workbook to aid in the analysis.


Hour FLOAT((DATEPART('hour', [Date Time])))

Day/Night Time: IF [Hour] < 6 THEN 'Night Time' ELSEIF [Hour] > 18 THEN 'Night Time' ELSE 'Day Time' END

Dir Groups If [Wind Dir] > 0 AND [Wind Dir] <= 22.5 THEN 11.25 ELSEIF [Wind Dir] > 22.5 AND [Wind Dir] <= 45 THEN 33.75 ELSEIF [Wind Dir] > 45 AND [Wind Dir] <= 67.5 THEN 56.25 ELSEIF [Wind Dir] > 67.5 AND [Wind Dir] <= 90 THEN 78.75 ELSEIF [Wind Dir] > 90 AND [Wind Dir] <= 112.5 THEN 101.25 ELSEIF [Wind Dir] > 112.5 AND [Wind Dir] <= 135 THEN 123.75 ELSEIF [Wind Dir] > 135 AND [Wind Dir] <= 157.5 THEN 146.25 ELSEIF [Wind Dir] > 157.5 AND [Wind Dir] <= 180 THEN 168.75 ELSEIF [Wind Dir] > 180 AND [Wind Dir] <= 202.5 THEN 191.25 ELSEIF [Wind Dir] > 202.5 AND [Wind Dir] <= 225 THEN 213.75 ELSEIF [Wind Dir] > 225 AND [Wind Dir] <= 247.5 THEN 236.25 ELSEIF [Wind Dir] > 247.5 AND [Wind Dir] <= 270 THEN 258.75 ELSEIF [Wind Dir] > 270 AND [Wind Dir] <= 292.5 THEN 281.25 ELSEIF [Wind Dir] > 292.5 AND [Wind Dir] <= 315 THEN 303.75 ELSEIF [Wind Dir] > 315 AND [Wind Dir] <= 337.5 THEN 326.25 ELSEIF [Wind Dir] > 337.5 AND [Wind Dir] <= 360 THEN 348.75 END

DIRECTION_CTG IF [Wind Direction] < 11.25 OR [Wind Direction] > 348.75 THEN 'N' ELSEIF [Wind Direction] >= 11.25 AND [Wind Direction] < 33.75 THEN 'NNE' ELSEIF [Wind Direction] >= 33.75 AND [Wind Direction] < 56.25 THEN 'NE' ELSEIF [Wind Direction] >= 56.25 AND [Wind Direction] < 78.75 THEN 'ENE' ELSEIF [Wind Direction] >= 78.75 AND [Wind Direction] < 101.25 THEN 'E' ELSEIF [Wind Direction] >= 101.25 AND [Wind Direction] < 123.75 THEN 'ESE' ELSEIF [Wind Direction] >= 123.75 AND [Wind Direction] < 146.25 THEN 'SE' ELSEIF [Wind Direction] >= 146.25 AND [Wind Direction] < 168.75 THEN 'SSE' ELSEIF [Wind Direction] >= 168.75 AND [Wind Direction] < 191.25 THEN 'S' ELSEIF [Wind Direction] >= 191.25 AND [Wind Direction] < 213.75 THEN 'SSW' ELSEIF [Wind Direction] >= 213.75 AND [Wind Direction] < 236.25 THEN 'SW' ELSEIF [Wind Direction] >= 236.25 AND [Wind Direction] < 258.75 THEN 'WSW' ELSEIF [Wind Direction] >= 258.75 AND [Wind Direction] < 281.25 THEN 'W' ELSEIF [Wind Direction] >= 281.25 AND [Wind Direction] < 303.75 THEN 'WNW' ELSEIF [Wind Direction] >= 303.75 AND [Wind Direction] < 326.25 THEN 'NW' ELSEIF ISNULL([Wind Direction]) THEN 'NA' ELSE 'NNW' END

Weekday/Weekend CASE [Day] WHEN 'Saturday' THEN 'Weekend' WHEN 'Sunday' THEN 'Weekend' ELSE 'Weekday' END

Wind Dir ROUND([Wind Direction],0)

WIND_CTG IF [Wind Speed (m/s)] < 0.3 THEN 'CALM' ELSEIF [Wind Speed (m/s)] < 1.6 THEN 'LIGHT AIR' ELSEIF [Wind Speed (m/s)] < 3.4 THEN 'LIGHT BREEZE' ELSEIF [Wind Speed (m/s)] < 5.5 THEN 'GENTLE BREEZE' ELSEIF [Wind Speed (m/s)] < 8.0 THEN 'MODERATE BREEZE' ELSEIF ISNULL([Wind Speed (m/s)]) THEN 'NA' ELSE 'WINDY' END

RADIUS WINDOW_SUM(COUNT([Wind Speed (m/s)]))

X_rev IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0, WINDOW_MAX([RADIUS])

  • SIN(RADIANS(avg([Wind Dir]))))


Y_rev IIF([Index]=1 OR [Index]=WINDOW_MAX([Index]),0, WINDOW_MAX([RADIUS])

  • COS(RADIANS(AVG([Wind Dir]))))

Horizon +1 IF [Difference_2] < -5*[Horizon Band Size] AND [Difference_2] <= -6*[Horizon Band Size] THEN (ABS([Difference_2])-(5*[Horizon Band Size]))/[Horizon Band Size] ELSEIF [Difference_2] > -6*[Horizon Band Size] THEN 10 END

Horizon +2 IF [Difference_2] < -4*[Horizon Band Size] AND [Difference_2] <= -5*[Horizon Band Size] THEN (ABS([Difference_2])-(4*[Horizon Band Size]))/[Horizon Band Size] ELSEIF [Difference_2] > -5*[Horizon Band Size] THEN 10 END

…. and so on ... ….


  1. For the Air Plumes, a new workbook/dataset was prepared considering the air plume polygon requires a PATH ID (corresponding to vertices of the polygon, in this case: 3 vertices (PATH ID 1, 2, 3) to be associated for each reading given in the meteorological data.

The readings were basically replicated thrice (assigning Path ID from 1 to 3) and adding a few extra columns as below to compute the necessary angle of the plume, the length of the plume that was to be projected on the map.

Angle IF [Path ID]=1 THEN [Wind.Direction]- 15 ELSEIF [Path ID]=2 THEN [Wind.Direction] ELSE [Wind.Direction]+ 15 END

Wind mph [Wind.Speed..m.s.]*2.23

Wind_Converted [Wind mph]*(200/12)

X_rad IF [Path ID]=1 THEN [X] ELSE [X]+ [Wind_Converted]*SIN(RADIANS([Angle])) END

Y_rad IF [Path ID]=1 THEN [Y] ELSE [Y]+[Wind_Converted]*COS(RADIANS([Angle])) END