100 likes | 219 Views
UCLA Luskin School of Public Affairs Alumni Data. Prepared by Kristen Figueira UP 206A Midterm Project. Data. Luskin Alumni Data (~3000 Alumni) Obtained from Sherry Dodge and VC Powe Public Policy = 235 Alumni Responses Social Work = 1375 Alumni Responses
E N D
UCLA Luskin School of Public AffairsAlumni Data Prepared by Kristen Figueira UP 206A Midterm Project
Data Luskin Alumni Data (~3000 Alumni) • Obtained from Sherry Dodge and VC Powe • Public Policy = 235 Alumni Responses • Social Work = 1375 Alumni Responses • Urban Planning = 1086 Alumni Responses 2010 Urban Planning Alumni Survey • Obtained from Robin Liggett • Sample Size= 588 Alumni Responses • 466 valid responses • Majority live in California (~400 Alumni)
UCLA Luskin School of Public Affairs Alumni Luskin Alumni Data, Sample Size= 2696 Skills Used: Geoprocessing, Geocoding
Urban Planning Alumni 2010 Urban Planning Alumni Survey, Sample Size= 466 Skills Used: Geoprocessing, Geocoding
Urban Planning Alumni 2010 Urban Planning Alumni Survey, Sample Size= 466 Skills Used: Geoprocessing, Geocoding, Graduated Symbols
Urban Planning Alumni in California California = ~400 Alumni Average Commute is ~16 miles (SCAG Report, 2001) Sacramento San Francisco Los Angeles San Diego Skills Used: Geoprocessing, Geocoding, Buffering
California Comparison ABAG (82 Alumni) • Alameda • Contra Costa • Marin • Napa • San Francisco • San Mateo • Santa Clara • Solano • Sonoma SCAG(269 Alumni) • Imperial • Los Angeles • Orange • Riverside • San Bernardino • Ventura Note: Councils of Governments were derived by querying County_Clip for each county and exporting to a new shapefile layer Skills Used: Inset, Geoprocessing, Geocoding, Buffering, Attribute Sub-Sets Selections
Type of Organization Alumni Living in ABAG Region Alumni Living in SCAG Region 2010 Urban Planning Alumni Survey, Sample Size= 46 Skills Used: Geoprocessing, Geocoding, Graduated Symbols
Conclusion Immediate Application: • Luskin Public Affairs Welcome Days in April Looking Ahead: • Need more complete data for Alumni Networking, Recruitment, Career Center, etc. Future Mapping: • Luskin Alumni by Industry, 5-10-15-year Incomes, Residential Patterns
Skills Used Inset map Graduated symbols Attribute sub-sets selections • Councils of Governments were derived by querying California counties for each county (For example: CA_County_Clipped, “Name” = ‘Los Angeles’ OR “Name” = ‘’Riverside’ OR “Name” = ‘San Bernardino’ OR “Name” = ‘Ventura’ OR “Name” = ‘Orange’ OR “Name” = ‘Imperial’ Buffering Geoprocessing Geocoding