Apologies to all.
Meant to forward to folks in-house.
Hit "send" before changing the "recipients" field.
From: Chuck Imbrogno
Sent: Monday, March 04, 2013 4:11 PM
Subject: RE: [CTPP] Census Bureau News -- Census Bureau Media Advisory
Commuting Products to be Embargoed
FYI - See bottom of this e-mail chain for the "Media Advisory" from the
Census Bureau regarding the Commuter Flow data that Tom Fontaine asked
about earlier today. Data was "embargoed" by the Census Bureau.
Available to the media at noon today, but not released publicly to
everyone else (including us) until midnight tonight.
Bob Schwartz should be downloading the file sometime in the morning.
[mailto:email@example.com] On Behalf Of Graham, Todd
Sent: Friday, March 01, 2013 7:32 PM
Subject: Re: [CTPP] Census Bureau News -- Census Bureau Media Advisory
Commuting Products to be Embargoed
Census Bureau wil be releasing data and reports on commuting patterns
If you have Census PIO embargo access, you'll be able to dig into it as
early as Monday afternoon.
This is a new product -- so I'm not sure how the data will be structured
-- anyone know?
Metropolitan Council Research
From: U.S. Census Bureau [census(a)subscriptions.census.gov]
Sent: Friday, March 01, 2013 9:54 AM
Subject: Census Bureau News -- **Census Bureau Media Advisory**
Commuting Products to be Embargoed
FOR IMMEDIATE RELEASE: FRIDAY, MARCH 1, 2013
Public Information Office
***CENSUS BUREAU MEDIA ADVISORY***
Commuting Products to be Embargoed
The U.S. Census Bureau's Public Information Office will offer an embargo
period next week for members of the media to view a series of commuting
products. Statistics will be available for every county in the U.S.
showing the number of workers that commute in or out and which counties
those commuters travel to and from. Additional reports and tables, based
on statistics from the American Community Survey, examine U.S. residents
traveling across county and state lines to work. Specifically, the
products present U.S. workers who have commutes of 60 minutes or longer
and workers who have "mega commutes" of at least 90 minutes and 50
miles. Statistics will also be available for every county in the U.S.
that show the number of workers that commute into or out of the county
and which counties those commuters travel to and from.
The reports and tables will be posted to the Census Bureau's embargo
site at noon EST Monday, March 4. The public release will be at 12:01
a.m. EST Tuesday, March 5. Wire and distribution services are prohibited
from distributing embargoed news releases and data files to subscribers
before the public release date and time.
If you are interested in scheduling a radio interview on Tuesday, March
5, please contact the U.S. Census Bureau Public Information Office at
ctpp-news mailing list
Below is the link to a 1 hour webinar that the ACS Data User Group held
on the "new" Content Review that the Census Bureau is undergoing. Under
the review process ALL of the questions on the ACS questionnaire will be
carefully reviewed with what many believe could lead to a smaller
questionnaire with less content. With that said users with an interest
in the ACS will want to listen to the webinar.
When you go to the link you will be asked to provide your email address
and a couple of other pieces of information.
This may be of interest to those on this list. Even if you can not make
the conference it may be worthwhile to check out the ACS Data Users
webpage and participate in the online community.
Register now for the inaugural American Community Survey (ACS) Data
Users Conference, to be held May 29-30, 2014, at the Holiday Inn
Capitol, in Washington, D.C. A limited number of hotel rooms have been
reserved at a special conference rate of $224 so please *book by April
14* to ensure your reservation. The ACS Data Users Conference is being
organized by Sabre Systems and the Population Reference Bureau in
partnership with the U.S. Census Bureau. Space at the conference is
limited and registration is on a first come/first served basis. The
final deadline for registration is Thursday, May 22, 2014. For more
information and to register for the conference, visit:
I would like to offer two additional "checks" that could be done, but with the caveat that while the following is not perfect by any means (and in some cases could be potentially misleading, if the subsequent analysis is faulty), they could lead to a better understanding of the Big Picture accuracy/usefulness of CTPP flows in specific situations.
The first is to prepare dot density maps. Here is an example:
-- Identify all tracts (or all TAZs) that compose the CBD for a moderate-to-large city.
-- Create a database that identifies the total number of workers living in a tract (or TAZ) who have their place of work recorded as being in the CBD (i.e., in one of the tracts or TAZs that compose the CBD).
-- Prepare a dot density map and visually examine the results to see if they make sense.
I would think such a visual analysis could help identify Big Picture situations where the ACS geocoding effort may have consistently identified the wrong workplace location for a large number of records.
But what if nothing stands out as particularly odd to those with considerable familiarity about the region? It doesn't seem to be done very often, but for those with access to an employer database for a specific work location (i.e., a database with lots of location-specific workers), in which each worker's home location is known (at least their zip code, or maybe even just their place of residence), it could be interesting to prepare and compare two different dot density maps: one based on the employer database, the other based on the CTPP. There will most likely be LOTs and LOTs of small differences in the spatial distribution of home locations (plus for that matter, limitations associated with use of a five-year accumulation of ACS records that are compared against a "current" database of employee's homes), but that is expected from any analysis based on small samples. The comparative visual checks of interest would be to see if there are any big differences that result in a "say what?" kind of reaction, e.g., if the employer database shows that 25% of all workers have residences located in the quadrant northeast of the workplace, but the CTPP flows indicate a distribution of 10% or 40%, that is worth some additional exploration. It would also be interesting to prepare a dot density map based on LEHD flows, to see how that compares.
This email is already getting into too many nuances that makes this appear a lot more complicated than it really needs to be, but other sources that might be interesting to explore include the flow data available for purchase from private vendors and use of license plate surveys to identify the "home zip code locations" for cars parked in downtown lots/garages.
Another check is perhaps a bit too much on the "exploratory research" side for most people's tastes, but it would be interesting to use a traffic assignment model to "assign" the TAZ-to-TAZ CTPP flows (for auto trips) to a metropolitan area road network, and compare the assigned volumes to AM peak period TOD counts. The reason to compare to AM peak counts, rather than daily counts, is that most home to work trips take place in the AM peak period, plus most trips in the AM peak period trips are commute trips. Certainly not a perfect test, but if the assigned CTPP link volumes are wayyy off from the AM peak counts, that could raise some eyebrows.
FTA Office of Planning and Environment
From: ctpp-news-bounces(a)chrispy.net [mailto:firstname.lastname@example.org] On Behalf Of Murakami, Elaine (FHWA)
Sent: Monday, March 31, 2014 4:52 PM
Subject: Re: [CTPP] tract level data
Great timing! Glad to hear that you are looking at the CTPP Part 3 data at the tract level.
Recently, Liang Long and I have been looking at some flow pairs at the tract level, but you all (out there in the real world) have local knowledge to best evaluate the results.
Wendall Cox of Demographia recently identified a problem in Los Angeles, which is the Port of Los Angeles, next to the Port of Long Beach, showing very large worker flows using transit for a pair that is about 25 miles distance. We have asked Yong Ping Zhang at SCAG to help us figure out what might be going on.
Also, we have heard from the Baltimore Metropolitan Council that there appear to be miscoded workplaces between Baltimore City and Baltimore County, for which they have initiated discussions with the Census Bureau on some training for ACS field interviewers. Also, it may be that more responses using the Internet for ACS will ameliorate some of these errors.
As a first step, pull the Part 2 (workplace data) at the tract level and find all your tracts with very high worker counts. For some regions, this might be census tracts with more than 10,000 workers. In other metro areas, this might be tracts with more than 5000 workers.
Look at the means of transportation for these tracts and see if they are reasonable using your own professional judgement. You can compare the results to the CTPP 2000, which will be easier in areas where the tract boundaries have been stable.
After you have determined that the Part 2 data appear reasonable, THEN look at the Part 3 flows. Yes, the Margins of Error at the tract level will be high as the sample size of the ACS is small, about 50% the sample size of the Census 2000 long form, even after 5 years of accumulated ACS records. You will notice that often the MOE is a value between 110 - 130, no matter what the estimate is. This is probably because the estimate is based on 1,2 or 3 unweighted records. While the CTPP does not include the unweighted number of workers at workplace location, there is a residence-based table A101106 of the unweighted sample count of PERSONS, which will give you a sense of how small the sample of WORKERS might be when workers are distributed to all the workplace locations.
You should also look at TAD to TAD flows. We asked the local transportation agencies to define TADs (about the size of 4 or 5 census tracts) because this is reduce the MOEs.
If you see a big problem in your Part 2 data, please contact us-either Penelope Weinberger at AASHTO pweinberger(a)aashto.org<mailto:email@example.com> ,
Liang Long at Cambridge Systematics llong(a)camsys.com<mailto:firstname.lastname@example.org> , or me.
Currently, Cambridge Systematics is conducting a CTPP Usability study for AASHTO's CTPP program, so everyone's feedback is welcome.
FHWA Office of Planning
206-220-4460 (in Seattle)
From: ctpp-news-bounces(a)chrispy.net<mailto:email@example.com> [mailto:firstname.lastname@example.org] On Behalf Of Harun Rashid
Sent: Monday, March 31, 2014 11:09 AM
Subject: [CTPP] tract level data
CTPPers, have any of you done flow analyses at tract level? With each CTPP release, we conduct that for small planning areas. For this, we need tract-tract flows with numbers from A302100 table. In identifying commuter flows to downtown urban core of the region (Charleston MSA, South Carolina), we found very large MOEs for each tract-tract pair. Of a total of 940 tract-tract pairs identified to have flows to the study area, 622 have MOEs larger than estimates!
I am checking to see if anyone else experienced the same issue, and how this is being handled. I was thinking of using some sort of filters, e.g. considering only the pairs that have estimates larger than MOEs. Any suggestions will be appreciated. TIA.
Harun Rashid, AICP
Senior GIS Planner
BCD Council of Governments
1362 McMillan Avenue, Suite 100
North Charleston, SC 29405