Hi Linh,


Since table B303200 is not a crossed tabulation, and you got the LINENO figured out, I’m guessing that your question is about how to interpret the GEOID attribute?  If so, I’d suggest using the flow GEOID lookup table (acs_2006thru2010_ctpp_flow_geo.txt), it is available in the lookup zip folder from CTPP FTP site.


Hope it helps. Please feel free to shoot me an email if you have any other questions.






Jingjing (JJ) Zang
Cambridge Systematics, Inc.
t +1 301 347 9130 (ext. 53130)



From: ctpp-news [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Nguyen, Linh
Sent: Tuesday, November 21, 2017 1:24 PM
To: ctpp-news@chrispy.net
Subject: [CTPP] Tabulating Means of Transportation to Median Household Income


Good afternoon-


I am working with table B303200 and even though I have successfully joined LINENO ID with its description of means of transportation, I'm wondering how to figure out the Median Household Income of each flows. I'd really appreciate it if you could give me some of your insights on this matter and I'm sorry about any inconvenience.

Many Thanks.

This message, including any attachments hereto, may contain privileged and/or confidential information and is intended solely for the attention and use of the intended addressee(s). If you are not the intended addressee, you may neither use, copy, nor deliver to anyone this message or any of its attachments. In such case, you should immediately destroy this message and its attachments and kindly notify the sender by reply mail. Unless made by a person with actual authority conferred by Louis Berger, the information and statements herein do not constitute a binding commitment or warranty by Louis Berger. Louis Berger assumes no responsibility for any misperceptions, errors or misunderstandings. You are urged to verify any information that is confusing and report any errors/concerns to us in writing.