1 Steans Center Project Site Maps Your GIS is as Good as Mine Mari’a Anderson Andrea Craft DJ Forbes Alex Frazier Matt Gridley Joe Menard2 Table of Contents Project Summery Introduction 1. Introduction………………………………………………………………………. 3 2. Needs Assessment 2.1 Background……………………………………………………………... 4 2.2 Project Goals……………………………………………………………. 4 2.3 Objectives………………………………………………………………. 5 2.4 Information Structure/Products……………..…………………………... 5 2.5 Information Category………….………………………………………... 5 3. System Requirements 3.1 Introduction……………………………………………………………... 6 3.2 Data Requirements as a Conceptual Database Design 3.2.1 Matrix of Need to Know Questions Cross-Referenced with entity classes……………………….……………………………… 6 3.2.2 Entity Relationship Modeling………………..……………….. 6 3.2.3 Entity Relationship Diagram.............................................….... 8 3.3 Software Requirements 3.3.1 Matrix of Need to Know Questions Cross Referenced with Software Functions…………………………………………………… 8 3.4 Personnel Requirements 3.5 Timing…………………………………………………………………. 10 3.6 Institutional Requirements……………………………………………... 10 4. Data Acquisition 4.1 Introduction…………………………………………………………….. 10 4.2 Data Dictionary 4.3 Data Source Steps…………………………………………………….... 13 4.4 Fitness for Use…………………………………………………………. 13 4.5 Data Acquisition Constraints…………………………………………... 13 5. Results…………………………………………………………………………… 14 5. Summary, Conclusions, and Recommendations………………………………... 23 6. References………………………………………………………………………. 24 Appendix A: Data Dictionary……………………………………………………...26 Appendix B: Entity Relationship Diagram…………………………………………273 Project Summary As a liason between DePaul University faculty/students and the community organizations, the Steans Center assists students/faculty in finding an organization suitable to their needs. It also assists affiliated organizations in locating students/faculty interested in the work of the site. The assistance in both respects is along the lines of work study, coursework, community service and project work. One of the Steans’ main objectives was to make it easier for students and faculty to locate an affiliated organization that was suitable to the needs of their interests, as well as provided added comfort in their selection. The Steans Center wanted all their affiliated organizations mapped using ArcGIS. The organizations would then be separated by neighborhood, services offered and according to demographic information (race, income, etc). In order to illustrate the ease of commuting to all of the organizations, spatial overlays of transportation routes (i.e., CTA rail maps, Chicago bike routes, and major Chicagoland streets were created. Although we were able to provide illustrations of these objectives, there were issues surrounding the progression and completion of the project. The first and largest issue was normalization. Some of the data available on the Steans website for all the affiliated organizations was incomplete. The same information (address, phone#, etc) was not available for every site. We had to do a little extra research on the separate sites in order to obtain all the information needed. Another problem was that the information available about the organizations in the attribute file sent to us from the Steans Center was inconsistent. For example, phone numbers were given as (773)374-3744, and 773.374.3744. The addresses had to be exactly the same for geocoding purposes in ArcMap. Another situation was getting the entire group to meet at the same place and time. We all have conflicting schedules with classes and jobs. As a result, we had to rely heavily on email and phone communication. We did however have great outcomes. We found out the nearly 75% of all the sites were within 0.4miles of a CTA rail station. Also, they are all easily accessible from the bike routes and major streets. Overall, Chicago has a great transportation system compared to other places. Our demographic maps provide information that will be great for future trend mapping. 1. Introduction The Steans Center is a community-based learning organization that works with DePaul University students and community organizations throughout Chicago. Its mission statement is as follows; “The Steans Center for Community-based Service Learning provides educational opportunities grounded in Vincentian community values to DePaul students. The Center seeks to develop mutually beneficial, reciprocal relationships with community organizations in order to develop a sense of social agency in our students through enrollment in CbSL courses, community internships and placements, and community-based student employment.” The stakeholders or the users of the work produced would be the Steans Center itself and also DePaul students working4 with community organizations. The work could also be utilized by the community organizations themselves. 2. Needs Assessment 2.1 Background During the meeting with our clients, Howard Rosing and Marisol Morales, we discussed the capabilities of what our GIS project could be for the Steans Center and how they could utilize the technology to display information about the facility more efficiently. The goal of the Steans Center is to have an interactive map displaying the location and information about their sites up and running on their website. After discussing goals and capabilities with Howard and Marisol we agreed that the community organization sites should be plotted on a map, separated by neighborhood and type of service the