We used SAS to generate a bunch of nested html pages (full credit for SAS coding goes to
our Senior Modeler, Himanshu Joshi); the last page in each chain is a deep link to the aff
website. That link has several components
fips (of the entity)
A separate step involves understanding the syntax of the the deep links, but that's
not really difficult.
Because we downloaded the raw ACS data, we know all possible tables names/codes and their
So, in order to replicate this setup for a different region, all is needed is a list of
fips codes for counties, places, tracts (the table id are all the same, obviously). Then
all is left to do is to copy the entire directory to a server.
We could share the code or, if provided with a list of fips codes, we could generate the
html files ourselves.
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] On Behalf Of Frank
Sent: Friday, May 11, 2012 2:14 PM
Subject: Re: [CTPP] AFF2 Deep Linking application
Dmitry - do you have an outline of the major steps you took to build the
list-based gateway that you could share with the list?
Director of Research Services
Mid-America Regional Council
Kansas City, MO
On 5/11/12 1:03 PM, "Messen, Dmitry" <Dmitry.Messen(a)h-gac.com> wrote:
Speaking of Deep Links,
here's an example of a list-based gateway to regional data
And this is a map-based gateway
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
Subject: [CTPP] AFF2 Deep Linking application
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
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
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.
Eric W. Kramer, Ph.D., AICP
Senior Land-Use Modeler
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
ctpp-news mailing list
ctpp-news mailing list