The CB just released what I will call the closest thing to a CTPP
product on FactFinder--The EEO Tables. Below is the press release. In
it it says that there are not only workplace tables but flows. If
anyone finds the flows could they please let the list (at least me) know
a table number. I have been looking and have not found them yet.
-----------------------------------------------------------------
U.S. Census Bureau Releases EEO Tabulation 2006-2010
We are pleased to announce the release of the Equal Employment
Opportunity (EEO) Tabulation 2006-2010, using the 2006-2010 American
Community Survey (ACS) 5-year estimates. This tabulation is a collection
of detailed tables that provide extensive detail about the workforce
composition and work characteristics of people across the country.
The EEO Tabulation presents a variety of tables featuring the following
variables: detailed occupation (488 categories), EEO occupational groups
(14 categories), EEO-1 job categories (9 categories), state and local
job groups (8 categories), federal sector job categories (9 categories),
industry (90 categories), race and ethnicity, citizenship, sex,
educational attainment, older age groups, younger age groups, earnings,
unemployment and when last worked.
Though not all tables are available for all geographies, tables are
available by residence geography (where people live), worksite geography
(where people work), and commuting flows (tables showing a central
worksite and the flow to that worksite of workers from up to nine
sources). In general, statistics will be available for the nation,
states, CBSAs, counties, EEO county sets (single counties or
combinations of counties with small populations), and places.
To access these statistics, please visit the Census Bureau's American
FactFinder.
For more information, please visit the EEO Tabulation page.
The ACS provides reliable statistics that are indispensable to anyone
who has to make informed decisions about the future. These statistics
are required by all levels of government to manage or evaluate a wide
range of programs, but are also useful for research, education,
journalism, business and advocacy. If you have questions about this
survey, please call our Customer Services Center on 1 (800) 923-8282.
Thank you,
American Community Survey Office
U.S. Census Bureau
-----
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
Where can I find the TAZ gis files from this most recent submission in 2011?
Thank you,
Natasha L. Longpine, AICP
Principal Planner
Ozarks Transportation Organization
205 Park Central East, Suite 205
Springfield, MO 65806
Phone (417) 865-3042
Fax (417) 862-6013
nlongpine(a)ozarkstransportation.org
www.OzarksTransportation.orgwww.OzarksCommute.com
http://www.fhwa.dot.gov/planning/census_issues/ctpp/status_report/sr0512.cfm
Hi Everyone -
Liang Long, our CTPP Technical support said that the Spring Issue of the CTPP Status report would answer your questions. Here is the link.
Please see the ftp links!
Elaine Murakami
FHWA Office of Planning
206-220-4460 (in Seattle)
Good Morning,
Before I unsubscribe to this mailing list, I would like for your to add Matt Hermen to your list. He takes care of the transportation census information for our MPO.
Thanks.
Rosemary
Rosemary Brinson Siipola
Transportation Planner/Manager
Cowlitz-Wahkiakum Council of Govts.
Southwest Washington RTPO
207 4th Ave. North - Annex
Kelso, WA 98626
360.577.3041 office
360.425.7760 fax
360.431.1363 cell
rsiipola(a)cwcog.org<mailto:rsiipola@cwcog.org>
"Growth for the sake of growth is the ideology of the cancer cell."
edward abbey
http://www.bls.gov/opub/btn/volume-1/a-comparison-of-25-years-of-consumer-e…
This report finds that the share of household expenditures for transportation has dropped by 5 percent for homeowners, and 4 percent for renters, and the share of expenditures for housing has increased by 3 percent for homeowners, and 5 percent for renters. Despite the drop in the share for transportation overall, the share spent on GASOLINE has increased. People keep vehicles for many more years (as reflected in the National Household Transportation Survey results http://nhts.ornl.gov/2001/pub/STT.pdf
, so the costs of ownership are amortized over a longer period of time.
Hi Everyone - I posted this link to the CTPP Facebook page, but since there are MORE of you on the CTPP listserv, I decided I should share it here. Also, please note that previously you had to PAY for CES microdata, but it is NOW FREE. http://www.bls.gov/cex/pumdhome.htm
Elaine Murakami
FHWA Office of Planning
206-220-4460 (in Seattle)
Mike Greenwald / Liang Long / everyone else:
I have no experience with ACS Alchemist, but will certainly take a close look at it. Much of my research involves analyzing demographic/population at small geographies over large areas (county, state, national). I have used the ACS Summary File Retrieval tool for several years and really find it useful--probably have downloaded 40+ 2006-10 block grp level statewide datasets this year alone.
Yes, there is definitely some cleanup and organization to get the data into GIS. But I really appreciate that the tool is reliable and creates easy-to-interpret tables with MOE. On the one hand the data cleanup prior to GIS takes time, but on the other hand the clear descriptions/headings reduces mistakes and ambiguity. Also, I can tell you from experience that the excellent column and row descriptions make tracing previous work much easier.
I use Excel primarily, but Access occasionally (Census summary files etc). If my opinion or experience is of any help to you Mike don't hesitate to try me. I cannot promise much as far as time, but I may be of some assistance in some way.
Jonathan P. Brooks.
Assistant Transportation Researcher
Transit Mobility Program
Texas A&M Transportation Institute
701 N Post Oak Rd, Suite 430
Houston, TX 77063
Tel 713.686.2971 | Cell 806.440.2462
http://tti.tamu.edu/group/transit-mobility
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of ctpp-news-request(a)chrispy.net
Sent: Wednesday, October 24, 2012 12:00 PM
To: ctpp-news(a)ryoko.chrispy.net
Subject: ctpp-news Digest, Vol 104, Issue 10
Send ctpp-news mailing list submissions to
ctpp-news(a)ryoko.chrispy.net
To subscribe or unsubscribe via the World Wide Web, visit
http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
or, via email, send a message with subject or body 'help' to
ctpp-news-request(a)ryoko.chrispy.net
You can reach the person managing the list at
ctpp-news-owner(a)ryoko.chrispy.net
When replying, please edit your Subject line so it is more specific than "Re: Contents of ctpp-news digest..."
Hi, all
If you are frustrated by getting the ACS 5-year block group level data via
Census Bureau ftpsite or DataFerrett, ACS Alchemist may be a good
alternative.
I just tested ACS Achemist that was developed by Azavea & Temple
University and I think it's easy to use. But keep in mind that only ACS
2005-2009 and ACS 2006-2010 data are available in the ACS Alchemist. If
you are looking for 1-year or 3-year data, you still need Census Bureau
data access tools including American Fact finder and DataFerrett.
ACS Achemist is an open source tool that enables the extraction of ACS
2005-2009 and ACS 2006-2010 data on different level of geographic
aggregation, i.e., counties, county sub-division, tracts, blockgroups,
etc. . The user interface is very straightforward and is a simple
step-by-step process. The thing I like most is that output is saved as
the shapefile and you can process your data in the GIS. The think I like
least is that uses will have to create a variable file to define which
data they want to get. The sample of a variable file can be find in the
readme document which is included in the software installation package,
but I attached one here for your convenience.
Here is the link to the ACS Alchemist home page:
http://www.azavea.com/news/archive/2012/7/31/azavea-and-temple-universitys-…
Here is the link to download the software package:
https://github.com/azavea/acs-alchemist/downloads
Enjoy!
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
Hello everyone,
I recently finished a summer internship at the City of Cambridge MA
Community Development Department doing web development and demographic data
gathering. Much of of my job during July and August consisted of mining
data from the Census Summary File 1 and American Community Survey 5-year
estimates for use in a public profile of the city's neighborhood
characteristics.
To make this process easier, I wrote a simple utility to gather data using
the census API. While much of its functionality overlaps with American
FactFinder, it is also able to retrieve data from the block and block group
level, making it useful for areas like Cambridge where neighborhood
boundaries do not exactly align with census tracts. I'd like to release it
open source to anyone who'll find it useful.
Basic features:
- .EXE file that runs out of the Windows or Linux
terminal. Unfortunately won't run on Macintosh (but will work in parallels
or boot camp)
- Simple text-based interface
- Search any available geography anywhere in the United States, down to the
block/block group level (where available)
- Retrieve up to 5 variables at a time for unlimited geographies at a time.
The 5 variable limit is on the end of the census API, not this utility.
- Automatically saves retrieved variables into a .csv file that can be
opened by excel.
- Can only search ACS 5-year for the time being. Adding SF1 functionality
is fairly straightforward.
The national use section of the utility is fairly narrow, but has potential
for expansion. The most robust functionality is specific to the City of
Cambridge, and I added national searches as an afterthought.
The interface is divided into two modes, National and Cambridge specific
search, and both work similarly. When you choose to conduct a national
search of the ACS 5-year, you will be prompted with the following menu:
[image: Inline image 1]
Typing 10 will prompt you to enter the variable IDs (up to 5) and the
geographies. Note that you can search as many geographies as you like, but
they must be of the same type (the lowest in the hierarchy, so for *10:
state-county-tract-block group *you can search up to 5 variables for any
number of block groups in the chosen census tract.
The format for entering a search for query type 10 would be:
*tableID1,tableID2,tableID3 stateFIPScode countyFIPScode tractFIPScode
blockGroup1,blockGroup2*
For example to search ACS estimates B02001_002E and B02001_003E, (off the
top of my head I think _002E is race: white and _003E is race: black /
african american) in the state of Massachusetts (code 017) in Middlesex
county (code 025) census tract 353500 block groups 1 and 2, you would enter:
*B02001_002E,B002001_003E 025 017 353500 1,2*
*
*
This isn't the most friendly format but it's nice for grabbing large
amounts of information on several geographies at a time. For general ease
of use I'd suggest using an external notepad program to assemble your
queries and then paste them in so you don't have to retype it all in case
of a typo. All queries follow this format of the table/variable IDs
separated by commas followed by the geographies in the order they appear
separated by spaces.
The main functionality that I'd like to add in the future is the ability to
create custom geographies. Since Cambridge has 13 neighborhoods that do not
exactly line up with census tracts, I hard coded in each neighborhood's
component tracts and/or block groups so the neighborhoods could be searched
as a whole. This can be easily written to work dynamically for the entire
country, allowing you to save custom geographies of multiple census tracts,
counties, or any combination of counties, subcounties, block groups, etc.
There is a half-written geoGroup class that is intended to do this.
The program is written in C++ which is not the most user-friendly language,
but the code is commented and fairly repetitive, so shouldn't be too
arcane. I'll continually make changes and I'd invite anyone who's
interested in this utility's use / potential uses to give me feedback or
suggestions or make changes of your own. If there is interest in improving
it, I would also like to, at some point, rewrite the utility in Java with a
graphical interface and the ability to use custom geographies. I am in no
way a professional programmer (I'm a 4th year sociology undergrad with a
computer science minor) so I'm sure there are plenty of things in the code
that could be cleaned up or improved.
It was written in a Cygwin environment using a Cygwin version of LibCurl so
C could read data from http, and is released this under the general public
license (which is compatible with Cygwin's GPL and Curl's openBSD).
The current source code can be found in a GitHub repository
here<https://github.com/UpQuark/CensusRetrieverSource>.
The compiled executable of the current version and its dependent libraries
can be downloaded here <http://www.fileswap.com/dl/01ZiyjiDlY/>.
Regards,
Samuel Ennis
Apparently, the ACS staff heard our concerns about the need for employment status by block group but forgot to tell us they did something about it..
In the 2011 ACS, there is a new Table B23025, which has simplified labor for data without the age/gender breakouts. This table will be available in the 2007-2011 ACS (5-year) file and will be available for block groups.
But, I just stumbled across this table for block groups from the 2006-2010 ACS (5-year) file!!!!! Since I don't know if anyone else knows about this special file, I'm sharing. It is at http://www.census.gov/hhes/www/laborfor/acs_employ.html.
Nancy Gemignani
California State Census Data Center
Demographic Research Unit
Department of Finance
915 L Street, 8th Floor
Sacramento, CA 95814
(916) 327-0103 ext 2550
nancy.gemignani(a)dof.ca.gov<mailto:nancy.gemignani@dof.ca.gov>
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
