We are looking for a pre-configured 2010 Census Geodatabase with both linework and data attached for at least the state of Indiana, if not also including the surrounding states. Although all of the data can be downloaded from the Census Bureau on an as needed basis, we would like a more permanent copy in-house for our GIS needs and publication to our regional GIS website.
We are hoping to find something pre-built, rather then downloading and compiling everything ourselves. Any assistance in the endeavor is appreciated.
John-Paul Hopman
Michiana Area Council of Gov'ts
HERE IS a REPLY from the Census Bureau regarding the API forum and about the API itself. I am posting her response as I believe CB staff are not allowed to post to listservs.
Elaine Murakami
------------------
Hi,
API members are approved usually daily. There are no unapproved members currently in the membership queue. (If you are still having a problem getting approved, please contact Lisa Wolfisch Lisa.Wolfisch(a)census.gov<mailto:Lisa.Wolfisch@census.gov> directly).
To answer some of the questions there - the API currently includes all of ACS 5 year 2010 and a portion of SF1 variables. These are listed at http://www.census.gov/developers/data/sf1.xml
The API only allows a few variables per call at a time because we need to limit the work on the back end that the server does for each API call, but there is no limit on the calls an application can do.
Note that the API pulls individual table cells and not tables. For example because Total Population exists as a cell in several tables, you can get to it with different variables as noted below, like
<variable name="B02001_001E" concept="B02001. Race">Total:</variable>
<variable name="B03001_001E" concept="B03001. Hispanic or Latino by Specific Origin">Total:</variable>
Please send anyone my way for further help.
Lisa Wolfisch
Chief, Web and Social Media Branch
Center for New Media & Promotions
U.S. Census Bureau
v: 301.763.5716
I've noticed that the table codes used in the API requests don't seem to match the table codes used in the table master lists or in American Fact Finder. For example the ACS 5-year table number for "Total Population" is B01003, but in the examples of API requests here<http://www.census.gov/developers/> the table number used to fetch population statistics for California and New York is B02001_001E, which the master list would have me believe is the table code for race (plus the "_001E" which I'm mystified by).
Is there a separate list of table IDs that the API recognizes / am I using the wrong lists?
Sam Ennis
https://connectdot.connectsolutions.com/p22twaxszhi/
If you were unable to join us last Friday, here is the link to the recording. In this version (using Adobe Connect software), you can download the files in the "share pod". The webinar was less than one hour and we got a lot of useful tips and materials to copy and modify from Mara Kaminowitz and Eric Kramer.
Elaine Murakami
FHWA Office of Planning
206-220-4460 (in Seattle)
Anyone know of link to GIS data/boundaries for new TMAs? Or possibly
just maps. The new TMA list was released in today's Federal Register:
https://www.federalregister.gov/articles/2012/07/18/2012-17514/designati
on-of-transportation-management-areas
Kevin Shipman
GIS Analyst
Spokane Regional Transportation Council
221 W First Ave, Suite 310
Spokane, WA 99201
509/343-6385
This just came out from the Census Bureau PR shop. It looks like the
API will be out in July. I know this is causing a lot of excitement in
our community and Elaine Murakami has talked about putting a webinar
together on APIs. If anyone in our community has some API experience
and would like to help with a webinar feel free to let me, or Elaine
(Elaine.Murakami(a)dot.gov) know.
-----------------
Census Application Programming Interface (API) — The Census Bureau is
releasing its first-ever API. This online service provides the building
blocks for developers to design online and mobile apps, such as
interactive maps, charts and databases, using a variety of Census Bureau
statistics. The API provides statistics down to the neighborhood level
(tracts and block groups) from the 2010 Census Summary File 1 and the
2006-2010 American Community Survey. With these two datasets available
in the form of an API, database editors and other developers have easier
access to a wide variety of timely, localized information, including
population totals, age, sex, race, Hispanic origin, home ownership,
education, income, employment, commuting and occupation. The API is
currently undergoing beta testing and is scheduled for public release in
July. More information about the API can be found at
<http://www.census.gov/developers/>.
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Hi, all
Eric Kramer from Pima Association of Governments developed a database
application for those interested in creating "Deep Links" to tables on
AFF2. Eric just did a presentation to introduce his access based
application in this afternoon's " Deep Linking with Census AFF" Webinar.
For those of you who are interested to download and use this application,
you can download it from Cambridge Systematics website:
Here is the link:
ftp://ftp.camsys.com/clientsupport/CTPPdata/AFF2DeepLinking/
Username: 8305CTPP
Password: 1900NJA
Enjoy!
Have a nice weekend!
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 9141
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com
www.camsys.com
This is a friendly reminder that we will host a webinar "Deep Linking with
Census AFF" tomorrow, July 13 at 1:00 - 2:30 p.m. Eastern.
We will have 2 presentations:
Mara Kaminowitz, Baltimore Metropolitan Council: Introduction to Deep
Links
Eric Kramer, Pima Association of Governments: Overview of the AFF2
Deep Linking Database Tool
We will have plenty of time for questions and answers.
We will use our regular CTPP room, without requiring reservations.
https://connectdot.connectsolutions.com/ctpp1
This room hold 100 people. Please enter as a "guest" and type in
your name.
1-888-675-2535 pc = 5860415#
This webinar will be recorded and the link will be posted to CTPP
listserv.
Let's have a good learning experience on Friday the 13th of July.
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 9141
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.com
www.camsys.com
Attention Chicago CTPP folks. Registration is now available for the
below-mentioned training.
Penelope Weinberger
CTPP Program Manager
AASHTO
202-624-3556
http://ctpp.transportation.org/Pages/default.aspx
<http://ctpp.transportation.org/Pages/default.aspx>
It's just as bad to not make a plan as to blindly follow the one you
already have.
From: Jon Hallas [mailto:jhallas@cmap.illinois.gov]
Subject: Census Transportation Planning Package (CTPP) Instruction
CMAP is hosting an AASHTO/FHWA training course on using Census
Transportation data. Would you send this promotional message to your
Illinois mailing list? Thanks. -Jon
August 6-7 at the Chicago Metropolitan Agency for Planning (CMAP) -
TRAINING on the CENSUS TRANSPORTATION PLANNING PACKAGE (CTPP). CTPP
training is for anyone who wants to drill down into Census data and
study travel behavior. This training is useful for anyone who works in
comprehensive planning, congestion management, travel forecasting or air
quality analysis. The training is 1.5 days long, hands on and computer
based. The program is free of charge. Participants will receive
instruction, practice analytical skills through exercises and learn to
navigate the CTPP software. Registration is limited. Contact Jon
Hallas <mailto:Jon%20Hallas%20%3cjhallas@cmap.illinois.gov%3e> at CMAP
with questions or for details on registering for the program.