Data Utilization and Preparation

Description of

Description of final data files used in SafeCampus

There are four main source and reference files used in the SafeCampus app:

1. building_info.R: This R script contains lists of building names and abbreviations for each of the five building types: academic, housing, greek, other on campus, and other off campus. These are compiled into one main list called alltype so this information can be easily accessed within the app. The custom color palette used for the leaflet bubble map visualization is also included in this script.

2. rpi_wap_raw.rds: This is an rds file of the prepared WAP data used in the majority of the app. This rds file is created in Test_WiFi_overview_source.R.

3. combined_wap_data.rds: This is an rds file similar to rpi_wap_raw.rds but is grouped differently to be used to plot the leaflet bubble map in the Campus WiFi Overview tab. It contains the sums of user counts and mac counts for each 30 minute interval. This file is also created in Test_WiFi_overview_source.R.

4. buildinginfo.rds: This is an rds file of the csv file allBuildingInfo.csv which contains the following information for every building: full building name, longitude, latitude, building type, and building abbreviation. This file is also created in Test_WiFi_overview_source.R and is used to create rpi_wap_raw.rds and combined_wap_data.rds with the correct information for all buildings on campus.

Creation of rpi_wap_raw.rds and combined_wap_data.rds

These two files are the main data frames used in the SafeCampus app. They are created in Test_WiFi_overview_source.R and then converted into Rds files to improve the speed and flow of the app. They are both created from rpi_wifi_last_seven_days.Rds which contains raw WAP data for several months and is collected every 30 minutes and updated every two hours. To create rpi_wap_raw.rds and combined_wap_data.rds, we formatted the time and date data and merged with apinfo.csv and allBuildingInfo.csv to add specific building information to the data frame. apinfo.csv contains the information of each WAP device and allBuildingInfo.csv contains information on each building. Min_25_24_time.csv is used to add the 30 minute intervals to the data frame. The combined_wap_data data frame stems from rpi_wap_raw and takes the sum of user count and mac count for every 30 minute interval. Finally Rds files are created of the rpi_wap_raw and combined_wap_data data frames used in the SafeCampus app.