130 likes | 300 Views
Reorganization of SOAGEOR and the Geo Club/Dual Club Structure. LaVerne Williams Software Support Administrator Lehigh University. Timetable. Started the project in Oct. 2003 Involved six staff members Utilized USPS.com, ESRI’s BusinessMap 3.5, and Yahoo Yellow pages to ensure accuracy
E N D
Reorganization of SOAGEORand the Geo Club/Dual Club Structure LaVerne WilliamsSoftware Support AdministratorLehigh University
Timetable • Started the project in Oct. 2003 • Involved six staff members • Utilized USPS.com, ESRI’s BusinessMap 3.5, and Yahoo Yellow pages to ensure accuracy • Completed the project in April 2004 • Continuing error report review to keep data integrity
Step by Step • Identified regions that did not have a club assigned (i.e. Alaska, Guam) • Created 48 new “clubs” (24 geo clubs with matching dual clubs) based on state to change the “unknown” group to a known status
Step by Step continued • Located zip codes which were coded in more than one geo clubs • Reassigned the zips to the proper club • Gathered zip code ranges from USPS zip code books for those clubs that are statewide • Downloaded constituent data to verify addresses and zip codes, corrected as needed • Recoded SOAGEOR based on constituent addresses and zip ranges
Step by Step continued • Coordinated with the Alumni Association to reorganize the nine states that have multiple geo clubs • NJ became three clubs instead of the original seven • Reassigned clubs in PA based on county, and later combined three clubs into one because of regional overlap • Met with the major gift officer for FL to properly distribute clubs around major cities, added two clubs
ALSK Slide 5 NYNY NONY LGIS CENY WENY GOCO SONY ROCH WECH MONT NDAK PACN TWIN IDAH SDAK WISC WYOM MICH IOWA NEVA Slide 3 NEBR NOCA SFBY SOCA SAND ORCY NOOH OHVA Slide 4 NJ NWIN INDY CHIC UTAH ROCK WVIR KASA STLU VIRG KENT CHAR RDNC Slide 6 Mid Atlantic ARIZ SOAZ TENN OKLA WCAR NMEX ARKS COLA COSC MISS BAMA ATLA TEXS DAFW AUST INTL MILT PRCO VRIS SVHH NOLA Slide 2 HAWI GUAM Geo Club Codes
Florida Geo Clubs PAFL NOFL CEFL TBFL TCFL SARA MIFL SWFL SFLA
NWPA NEPA HOME PBGH SEPA SUSQ PHIL Pennsylvania Geo Clubs
NONJ GOCO (also part of NY group) CENJ (southern Hunterdon county) SONJ New Jersey Geo Clubs
NEWH VERT MAIN BOST CCMA (NY) RHIS (NJ) (PA) CTVA FFCT New England Geo Clubs
(PA) (NJ) BALT DELA WADC BALT (VA) Midatlantic Geo Clubs
Did You Know that... • In SOAGEOR, duplicate zips can be entered if entered within a range? • Error reports run once a month can ensure everyone is assigned a club • Utilize dual club codes! (we enter ours in APAMAIL)
Questions? Thank you for joining us, and enjoy the conference!