I want to make a database to make the search for rooms easier.
The idea is to take raw data that students could use: square footage, number of closets, kitchens, common room, laundry rooms, floor, gender, is it a single or a double, is it renovated (this would require checking the place in person), and etc. The floor plans indirectly list most of them and they have a separate binder that list room capacity and gender.
Ideally, a user can enter what amenities they want (ie a student wants to know what dorms have a kitchen) and they can get a list of dorms with rooms that have it. The ability to find out the square-footage of a room or if a dorm have a kitchen in an easy and fast way can be useful.
Okay, so the exact data points seems to go under two areas: Room amenities and Dorm amenities.
Number of closets
Personal Bathroom (yes, I found that a few rooms, have a personal bathroom without the charge, one even had a personal kitchen but was not categorized as apartment)
Number of Common Rooms
Common Kitchen (The French House have 2, at least on paper)?
Other Special Amenities?
I have gathered some data, but I'll need more. BU housing open 9-5, but I work 9-5, so progress could be a little slow. Towers RHA does have some of the data and open 7-11 (or something like that), but a good portion are not very legible and they only have floor plans. If someone want to help me on this front, it would defeat one of the biggest bottlenecks of this work.
Basically, there's three main types of work.
1. Data Gathering (going through floor plans and documents and put it on the computer, let me tell you, it is slow work)
2. Front End work
3. Back End work
Anyways, if anyone want to help in any way, sign up!