Using ArcView GIS to Locate Potential Donors to Cal Poly Pomona

Author: Donna Tillman
Organization: California State Polytechnic University, Pomona

3801 West Temple Avenue
Pomona, CA 91768
USA

Phone: 909-869-2437
Fax: 909-869-4322
ditillman@csupomona.edu

The College of Business has faculty scattered in six different buildings. To construct a business building that would house the COB will require millions of donor dollars. To reach these potential donors requires a systematic effort. A database of all businesses in the Southern California region was searched using the geographical location of within 25 miles of Cal Poly Pomona. This generated a list of nearly 5,000 names. This database was again searched using the criteria of annual sales of at least $5 million. This generated 152 businesses within the targeted geographical area. The Excel database was first converted to DB 4. Using ArcView GIS with the ArcView StreetMap extension resulted in plotting 72 of these businesses with the sizes of dots representing their annual sales. All of the information contained in the database is linked to the map location. This includes the chief executive officers; their phone, fax, and e-mail addresses; and products manufactured. The faculty of the College of Business now have ready access to all of the public information about these potential donors. The next step is to start a relationship between Cal Poly Pomona and the potential donors by offering our students as interns in their companies.