11 May
2012
11 May
'12
12:06 p.m.
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
PAG_logotype
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org
11 May
11 May
1:58 p.m.
Cool!
Mara
From: Eric Kramer [mailto:ekramer(a)pagnet.org]
Sent: Friday, May 11, 2012 12:07 PM
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
PAG_logotype
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org
2:03 p.m.
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(a)01CD287B.1A744B90]
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org<mailto:ekramer(a)pagnet.org>
3:14 p.m.
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?
Thanks.
-- Frank
Frank Lenk
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
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(a)01CD287B.1A744B90]
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org<mailto:ekramer(a)pagnet.org>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
5:34 p.m.
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
summary level
table name
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
grouping.
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
Lenk [FLENK(a)marc.org]
Sent: Friday, May 11, 2012 2:14 PM
To: ctpp-news(a)chrispy.net
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?
Thanks.
-- Frank
Frank Lenk
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
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(a)01CD287B.1A744B90]
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org<mailto:ekramer(a)pagnet.org>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
3:14 p.m.
AFF2 just got easier. Kudos to our user community!
Messen, Dmitry wrote:
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(a)01CD287B.1A744B90]
177 N. Church Ave, Suite 405
Tucson, AZ 85701
(520) 792-1093 x506 (tel)
(520) 620-6981 (fax)
www.pagnet.org
ekramer(a)pagnet.org<mailto:ekramer(a)pagnet.org>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
4831
days inactive
4831
days old
ctpp@listserv.transportation.org
5 comments
5 participants
participants (5)
-
Ed Christopher -
Eric Kramer -
Frank Lenk -
Messen -
mkaminowitz＠baltometro.org