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(a)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
2013.
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Kevin Byrnes
Sent: Tuesday, July 17, 2012 3:22 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Post 2010 Metropolitan Area Definitions
Does anyone in the group know when post 2010 metropolitan & micropolitan definitions (with new component counties) will be released?
Thanks
Kevin F. Byrnes, AICP
Director of Regional Planning & Regional Demographer
George Washington Regional Commission (GWRC)
406 Princess Anne St
Fredericksburg VA 22401
Ph (540) 373-2890 (ext 18)
Fax (540) 899-4808
From: ctpp-news-bounces(a)chrispy.net<mailto:ctpp-news-bounces(a)chrispy.net> [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Andrew Rohne
Sent: Tuesday, July 17, 2012 3:42 PM
To: ctpp-news(a)chrispy.net<mailto:ctpp-news(a)chrispy.net>; Main discussion list for the Travel Model Improvement Program.
Subject: [CTPP] RFQ for Travel Model Data Assistance
I apologize for cross-posting. Feel free to forward this.
The Ohio-Kentucky-Indiana Regional Council of Governments (OKI) is now accepting Statements of Qualifications (SOQs) from firms interested in engaging professional services for the processing of travel survey data files that can be used for trip rate estimation, trip distribution calibration, mode choice calibration, auto ownership model estimation and daily activity patterns. OKI will accept proposals until 4:00 p.m. EDT, August 28, 2012. Please visit OKI's website at http://www.oki.org/announcements/pdf/Model_Data_Assistance_RFQ.pdf for a copy of the Request for Qualifications.
--
Andrew S. Rohne
Transportation Modeling Manager
Ohio-Kentucky-Indiana Regional Council of Governments
P: 513.621.6300 x115 * arohne(a)oki.org<mailto:arohne(a)oki.org>
[cid:image001.png(a)01CD6434.AB5713A0] <http://www.linkedin.com/in/andrewrohne> [cid:image002.png(a)01CD6434.AB5713A0] <http://twitter.com/okiandrew>
Join OKI's Social Media
[cid:image003.jpg(a)01CD6434.AB5713A0]<http://www.facebook.com/pages/Cincinnati-OH/Ohio-Kentucky-Indiana-Regional-…> [cid:image004.jpg(a)01CD6434.AB5713A0] <http://twitter.com/okircog> [cid:image005.jpg(a)01CD6434.AB5713A0] <http://www.youtube.com/okircog>
[cid:image006.jpg(a)01CD6434.AB5713A0]<http://www.cvgairport.com/1st/rewards.html?utm_source=cvg1st.com&utm_medium…>
________________________________
This email is intended to be read only by the intended recipient. This email may be legally privileged or protected from disclosure by law. If you are not the intended recipient, any dissemination of this email or any attachments is strictly prohibited, and you should refrain from reading this email or examining any attachments. If you received this email in error, please notify the sender immediately and delete this email and any attachments.
This is pretty cool, but it seems there is a limit to pulling 5 fields at a time. I got a key and was just playing around a little, and thought I'd pull the race variables (P006) for a few counties. Using:
http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060…
Yields a few results. However, using:
http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060…
Yields an error screen with "error: error: unknown variable 'P0060005,P0060006'"
I can do another query with:
http://thedataweb.rm.census.gov/data/2010/sf1?key={YOUR_KEY_HERE}&get=P0060…
And get the last few results. This appears to be a limitation we'd have to program around (although if I am incorrect and I'm doing something incorrectly, please let me know!).
Andrew Rohne
OKI Regional Council
www.oki.org
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Krishnan Viswanathan
Sent: Friday, July 13, 2012 5:56 PM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] Census API watch
I have been using it and found it easier to use than AFF2. There is an XML file that shows the available tables (I have been using the 5 year ACS) and I have been doing it the dumb way - enter the required table and geog that i want in my browser address bar (along with my API key) and it spits out the table as a CSV file. I have not written any front end UI or anything, but for me knowing what table I want and at what geog, i found it far easier to use than AFF2.
Krishnan
On Fri, Jul 13, 2012 at 5:28 PM, Ed Christopher <edc(a)berwyned.com<mailto:edc(a)berwyned.com>> wrote:
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<mailto: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<tel:708-283-3534> (V)
708-574-8131<tel:708-574-8131> (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.net<mailto:ctpp-news(a)ryoko.chrispy.net>
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
--
Krishnan Viswanathan
1101 High Meadow Dr
Tallahassee FL 32311
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