By Kalynn Kosyka, Computer Science & Data Science ’19
Currently, Smith College is going through major renovations which resulted in many staff members being relocated. The Campus Directory Map will allow the user to query on name, department, and/or person type (faculty, staff, student) from the college directory. After querying, the user will be directed to a page that contains a visualization of the location of members throughout Smith (e.g. mapping people’s campus addresses that satisfy the query). Underneath the map, there is a list of people that satisfy the query along with their information: name, address, department, and person type.
[advanced_iframe securitykey=”5bc49ba0db168937774fd40d43b1f0f57eecc76d” src=”https://www.science.smith.edu/sal/devel/directory/CampusDirectoryMap.html?name=&dept=”]
Launch the full application here.
This application is not only good for the renovation period, but also day-to-day use: It allows users, such as new students, to learn and easily navigate to locations of their professors and gain insight on Smith College (e.g. general idea where the Computer Science department is located).
With this experience, I definitely faced some challenges. My largest challenge, also a tad tedious, was the data cleaning. There were a lot of typos and inconsistencies that aren’t easy to catch at first glance. For example, there were some people who had the same Building location, but one had an additional space which both the queries and I did not catch. Another challenge, is figuring out what would be the most efficient way to store the data. Originally, the person’s campus address was connected with their room number (e.g. “Ford 305”), but I decided to split the values since I need the building for the coordinates. However, it is also easier to concatenate the information than split. Of course it is not hard to fix entries, but it gets tedious when there are hundreds of errors, and some of them are unique to itself. There are of course more errors and challenges, but those were the bulk of it. Fortunately, through this experience, I learned more about database systems and learning to use Geoserver data on front end pages.
We hope in the near future to get this project embedded in Smith College’s actual Campus Directory as an extension to visualize people’s location on Smith.