Re: [CTPP] AFF2 Deep Linking application

Speaking of Deep Links, here's an example of a list-based gateway to regional data http://videos.h-gac.com/CE/socioeconomic/Census/main.html And this is a map-based gateway http://www.h-gac.com/go/censusacs ________________________________________ From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] On Behalf Of Eric Kramer [ekramer(a)pagnet.org] Sent: Friday, May 11, 2012 11:06 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] AFF2 Deep Linking application Hi all, Here is a database application for those interested in creating ³Deep Links² to tables on AFF2. The attached MS Access database features a form programmed in VBA to assemble Deep Links to the American Factfinder 2. You will have to allow VBA macros or else MS Access will disable the program. The application is a work in progress so if you are handy with VBA feel free to improve it. Use the dropdown menus to select the program, dataset, table and geography of interest. The ³Category² menu is optional and serves to filter tables in the ³Table² menu. After the menu selections are ready, click the ³Add Components² button. The hyperlink will appear in the textbox below. Caveat: AFF2 may not have some of the menu items and some are only be available for specific summary levels. As data is released in the future (annual ACS, SF2, etcŠ), new records will have to be added the database tables that reference the proper bookmarking codes and aliases (for menu items). Multiple geographies (same summary level) for a single table may be added to the hyperlink (e.g. a second county) by clicking the ³Add Components² button without resetting the link. Individual census tracts may be added using the 6 digit FIPS number (use a comma delimiter for multiple tracts). Currently the database can create links to decennial census and ACS tables at the State, County, and Tract summary levels. The database has places for Arizona only. To add more places to the menu, go to the ³Places² table in the ³Data² group and append your place records following the table template. The AFF deep linking guide was helpful in designing this program, but I also resorted to AFF2 bookmarks to determine correct coding and syntax for some tables and datasets. Have fun! ____________________________ Eric W. Kramer, Ph.D., AICP Senior Land-Use Modeler [cid:image001.jpg@01CD287B.1A744B90] 177 N. Church Ave, Suite 405 Tucson, AZ 85701 (520) 792-1093 x506 (tel) (520) 620-6981 (fax) www.pagnet.org ekramer@pagnet.org<mailto:ekramer@pagnet.org> _______________________________________________ ctpp-news mailing list ctpp-news(a)ryoko.chrispy.net http://ryoko.chrispy.net/mailman/listinfo/ctpp-news