SENIOR TRAVEL DEMAND MODELER
The Tri-County Regional Planning Commission, located in Michigan=s state
capital, is seeking a technically oriented professional transportation
planner for the position of Senior Modeler. Requires strong skills,
experience and training related to travel demand modeling. The successful
candidate will have technical and analytical skills in many of the following
areas:
* Directly applying, updating and maintaining traffic forecasting models,
such as TRANPLAN, TRANSCAD or other packages.
* Developing and applying socioeconomic forecasting and/or land use models
to prepare population and employment forecasts.
* Air quality conformity/emissions analysis.
* Familiarity with GIS, census data, highway capacity analysis and other
traffic engineering studies, preparing long range transportation plans,
corridor and sub-regional studies.
* Working knowledge of spreadsheets, relational data bases and computer
graphics packages. Programming in at least one advanced language preferred.
Requirements: Bachelor=s in planning, engineering or related field. Four
years of progressively responsible experience in directly applying travel
demand models, preparing socioeconomic forecasts and air quality
conformity/emissions modeling. Masters preferred and may substitute for two
years of experience. Excellent writing and public communications skills
required.
Salary Range: $46,739 - $60,956 commensurate with skills and experience.
Excellent benefits include employer paid family coverage for health, dental
and eye care, plus pension, holidays, vacation and sick leave.
Resume To:
Tri-County Regional Planning Commission
913 W. Holmes Rd., Suite 201
Lansing, MI 48910
phamilton(a)mitcrpc.org
Position open until filled.
*An Equal Opportunity Employer*
Paul T. Hamilton, Chief Planner
Tri-County Regional Planning Commission
913 W. Holmes Road, Ste. 201
Lansing, MI 48910
517.393.0342 (phone)
517.393.4424 (fax)
tritrans(a)acd.net (email 1)
phamilton(a)mitcrpc.org (email 2)
www.mitcrpc.org (web)
What I did was to allocate uncoded in proportion to the observed
distribution. The bureau had a far more sophisticated approach than that. So
in the cook case a huge proportion of the Cook county unknowns would become
Cook to Cook.
Alan E. Pisarski
6501 Waterway Drive
Falls Church Va. 22044
703 941-4257
alanpisarski(a)alanpisarski.com
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of siim soot
Sent: Thursday, February 22, 2007 5:11 PM
To: Ed Christopher
Cc: ctpp-news maillist; siim soot
Subject: Re: [CTPP] New Website--Old Data
In the 1970 Chicago UTPP approximately 60% of the
work locations were geocoded to TAZs with 10%
assigned to ZIP code areas, 10% to city, 10% to
county with the remainder identified as not reported.
The Census provided the 'best' geography available.
We made a considerable effort to assign all the trips to
TAZs but these files are no longer available.
Regarding county-to-county flows it would be reasonable to
expect that the TAZ, ZIP and city destinations were assigned
to the appropriate county. One can only guess what was done
with the ca 10% not reported data.
Siim Sööt
On Thu, February 22, 2007 3:41 pm, Ed Christopher wrote:
> Chuck--If I understand you I could almost conclude that in the Chicago
> numbers that have been in play over 3 decades that we took the "place of
> work not reported" for our resident workers and counted them as internal
> flows. But that could not have happened. First the same pattern
> exists all the counties I checked. Cook to Cook, Dupage, Kane, Lake,
> Will and McHenry. The 1970 BEA numbers are low. It could be that our
> 1970 UTPP numbers were tweaked and if they were originally in the
> neighborhood of the BEA numbers I could see why. I need to check out
> that path as well.
>
> Chuck how do your 1970 numbers compare? Are they more in line with
> BEAs? Does anyone else have their 1970 CTPP numbers how do they
> compare?
>
> To give you an idea of magnitude here is what I am looking at for 1970.
>
> BEA----------UTPP
> 1,931,034----2,105,178 Cook to Cook
> 27,104---32624 Cook to Dupage
> 5,403---9,056 Cook to Kane
> 8,888---18,624 Cook to Lake
> 698---951 Cook to McHenry
> 3,853---4,299 Cook to Will
>
> I also have 43,076 Cook to elsewhere but I didn't add up all the BEA
> elsewheres.
>
> I also looked at DuPage to all the other counties and the same pattern
> prevailed.
>
> -------- Original Message --------
> Subject: Re: [CTPP] New Website--Old Data
> Date: Thu, 22 Feb 2007 08:33:57 -0800
> From: "Chuck Purvis" <CPurvis(a)mtc.ca.gov>
> To: "Ed Christopher" <edc(a)berwyned.com>,"ctpp-news maillist"
> <ctpp-news(a)chrispy.net>
>
> Hi Ed:
>
> The 1970 Census data on the BEA website shows a separate row, at the
> very end of each county's table, for "place of work not reported". So,
> Cook County Illinois has 181,911 resident workers with place-of-work not
> reported, in 1970. Part of the mystery is solved.
>
> I believe all of the "standard" 1970 Census tabulations did NOTdo
> place-of-work allocation (imputation), so we would always see the "not
> reported" data for any county, place or tract.
>
> The 1970 Urban Transportation Package (UTP) probably had some
> allocation (imputation) procedure to allocate the "not reported"
> area-of-work to whatever geographies were used after the 1970 Census.
> This is a guess. I don't have extensive records of the 1970 process. [I
> do have the "Urban Transportation Factbook" published by the American
> Institute of Planners and the Motor Vehicles Manufacturers Assocation,
> in 1974, but it appears to be based on standard census tabulations, not
> the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
> Phil can find the info before he retires next Friday? Or perhaps the
> answers are in the archives - - JJ McDonnell's papers, or Alan
> Pisarski's office....Perhaps some information is in the TRB Special
> Report #145 (the 1973 Albuquerque Census conference.)
>
> Happy hunting,
>
> Chuck
> **************************************************************
> Charles L. Purvis, AICP
> Principal Transportation Planner/Analyst
> Metropolitan Transportation Commission
> 101 Eighth Street
> Oakland, CA 94607-4700
> (510) 817-5755 (office) [new, 8/1/05]
> (510) 817-7848 (fax) [new, 8/1/05]
> www: http://www.mtc.ca.gov/
> Census WWW: http://www.bayareacensus.ca.gov/
> **************************************************************
>
>>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
> Our friends (who I do not know) at the Bureau of Economic Analysis who
> do the Regional Economic Accounts revamped their historic (1970, 1980,
> 1990 and 2000) Journey to Work (JTW) data base and put a nice search
> engine to it. For years I have sent people to the BEA sight for JTW
> flows but with the new search engine and the 2000 data it is so easy to
> use. For 2000 they have added flows by major industry at the county
> level and by minor industry at the state level. You really need to
> check it out. http://www.bea.gov/bea/regional/reis/jtw/
>
> But then there is the nagging issue. Why do my historic CTPP/UTPP
> numbers and BEA not match. In 1970 and 1980 the two sources look to be
> off in different directions, but for 1990 they match and for 2000 it
> looks like a small rounding difference. Getting into the detail,
> attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
> IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K higher
> out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
> this keeps coming up, but why? Is the pattern the same around the
> country, BEA is high in 1980 and low in 1970? At some point we may need
> to reconcile all this and pick one series or the other. Since I have
> been tracking the Chicago region numbers
> (http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time this
> has always been a nagging headache.
>
> How do all the numbers compare in your counties? Does anyone remember
> why the 70s and 80s might not match?
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 19900 Governors Dr
> Olympia Fields, IL 60461
>
--
Siim Sööt
Urban Transportation Center
University of Illinois at Chicago
312-996-2666
Homepage: www.uic.edu/~siim
Home: 678 Foxdale, Winnetka IL 60093-1950
847-446-7560 home
847-372-7560 cell
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
What I did was to allocate uncoded in proportion to the observed
distribution. The bureau had a far more sophisticated approach than that. So
in the cook case a huge proportion of the Cook county unknowns would become
Cook to Cook.
Alan E. Pisarski
6501 Waterway Drive
Falls Church Va. 22044
703 941-4257
alanpisarski(a)alanpisarski.com
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of siim soot
Sent: Thursday, February 22, 2007 5:11 PM
To: Ed Christopher
Cc: ctpp-news maillist; siim soot
Subject: Re: [CTPP] New Website--Old Data
In the 1970 Chicago UTPP approximately 60% of the
work locations were geocoded to TAZs with 10%
assigned to ZIP code areas, 10% to city, 10% to
county with the remainder identified as not reported.
The Census provided the 'best' geography available.
We made a considerable effort to assign all the trips to
TAZs but these files are no longer available.
Regarding county-to-county flows it would be reasonable to
expect that the TAZ, ZIP and city destinations were assigned
to the appropriate county. One can only guess what was done
with the ca 10% not reported data.
Siim Sööt
On Thu, February 22, 2007 3:41 pm, Ed Christopher wrote:
> Chuck--If I understand you I could almost conclude that in the Chicago
> numbers that have been in play over 3 decades that we took the "place of
> work not reported" for our resident workers and counted them as internal
> flows. But that could not have happened. First the same pattern
> exists all the counties I checked. Cook to Cook, Dupage, Kane, Lake,
> Will and McHenry. The 1970 BEA numbers are low. It could be that our
> 1970 UTPP numbers were tweaked and if they were originally in the
> neighborhood of the BEA numbers I could see why. I need to check out
> that path as well.
>
> Chuck how do your 1970 numbers compare? Are they more in line with
> BEAs? Does anyone else have their 1970 CTPP numbers how do they
> compare?
>
> To give you an idea of magnitude here is what I am looking at for 1970.
>
> BEA----------UTPP
> 1,931,034----2,105,178 Cook to Cook
> 27,104---32624 Cook to Dupage
> 5,403---9,056 Cook to Kane
> 8,888---18,624 Cook to Lake
> 698---951 Cook to McHenry
> 3,853---4,299 Cook to Will
>
> I also have 43,076 Cook to elsewhere but I didn't add up all the BEA
> elsewheres.
>
> I also looked at DuPage to all the other counties and the same pattern
> prevailed.
>
> -------- Original Message --------
> Subject: Re: [CTPP] New Website--Old Data
> Date: Thu, 22 Feb 2007 08:33:57 -0800
> From: "Chuck Purvis" <CPurvis(a)mtc.ca.gov>
> To: "Ed Christopher" <edc(a)berwyned.com>,"ctpp-news maillist"
> <ctpp-news(a)chrispy.net>
>
> Hi Ed:
>
> The 1970 Census data on the BEA website shows a separate row, at the
> very end of each county's table, for "place of work not reported". So,
> Cook County Illinois has 181,911 resident workers with place-of-work not
> reported, in 1970. Part of the mystery is solved.
>
> I believe all of the "standard" 1970 Census tabulations did NOTdo
> place-of-work allocation (imputation), so we would always see the "not
> reported" data for any county, place or tract.
>
> The 1970 Urban Transportation Package (UTP) probably had some
> allocation (imputation) procedure to allocate the "not reported"
> area-of-work to whatever geographies were used after the 1970 Census.
> This is a guess. I don't have extensive records of the 1970 process. [I
> do have the "Urban Transportation Factbook" published by the American
> Institute of Planners and the Motor Vehicles Manufacturers Assocation,
> in 1974, but it appears to be based on standard census tabulations, not
> the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
> Phil can find the info before he retires next Friday? Or perhaps the
> answers are in the archives - - JJ McDonnell's papers, or Alan
> Pisarski's office....Perhaps some information is in the TRB Special
> Report #145 (the 1973 Albuquerque Census conference.)
>
> Happy hunting,
>
> Chuck
> **************************************************************
> Charles L. Purvis, AICP
> Principal Transportation Planner/Analyst
> Metropolitan Transportation Commission
> 101 Eighth Street
> Oakland, CA 94607-4700
> (510) 817-5755 (office) [new, 8/1/05]
> (510) 817-7848 (fax) [new, 8/1/05]
> www: http://www.mtc.ca.gov/
> Census WWW: http://www.bayareacensus.ca.gov/
> **************************************************************
>
>>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
> Our friends (who I do not know) at the Bureau of Economic Analysis who
> do the Regional Economic Accounts revamped their historic (1970, 1980,
> 1990 and 2000) Journey to Work (JTW) data base and put a nice search
> engine to it. For years I have sent people to the BEA sight for JTW
> flows but with the new search engine and the 2000 data it is so easy to
> use. For 2000 they have added flows by major industry at the county
> level and by minor industry at the state level. You really need to
> check it out. http://www.bea.gov/bea/regional/reis/jtw/
>
> But then there is the nagging issue. Why do my historic CTPP/UTPP
> numbers and BEA not match. In 1970 and 1980 the two sources look to be
> off in different directions, but for 1990 they match and for 2000 it
> looks like a small rounding difference. Getting into the detail,
> attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
> IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K higher
> out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
> this keeps coming up, but why? Is the pattern the same around the
> country, BEA is high in 1980 and low in 1970? At some point we may need
> to reconcile all this and pick one series or the other. Since I have
> been tracking the Chicago region numbers
> (http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time this
> has always been a nagging headache.
>
> How do all the numbers compare in your counties? Does anyone remember
> why the 70s and 80s might not match?
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 19900 Governors Dr
> Olympia Fields, IL 60461
>
--
Siim Sööt
Urban Transportation Center
University of Illinois at Chicago
312-996-2666
Homepage: www.uic.edu/~siim
Home: 678 Foxdale, Winnetka IL 60093-1950
847-446-7560 home
847-372-7560 cell
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
What I did was to allocate uncoded in proportion to the observed
distribution. The bureau had a far more sophisticated approach than that. So
in the cook case a huge proportion of the Cook county unknowns would become
Cook to Cook.
Alan E. Pisarski
6501 Waterway Drive
Falls Church Va. 22044
703 941-4257
alanpisarski(a)alanpisarski.com
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces@chrispy.net]
On Behalf Of siim soot
Sent: Thursday, February 22, 2007 5:11 PM
To: Ed Christopher
Cc: ctpp-news maillist; siim soot
Subject: Re: [CTPP] New Website--Old Data
In the 1970 Chicago UTPP approximately 60% of the
work locations were geocoded to TAZs with 10%
assigned to ZIP code areas, 10% to city, 10% to
county with the remainder identified as not reported.
The Census provided the 'best' geography available.
We made a considerable effort to assign all the trips to
TAZs but these files are no longer available.
Regarding county-to-county flows it would be reasonable to
expect that the TAZ, ZIP and city destinations were assigned
to the appropriate county. One can only guess what was done
with the ca 10% not reported data.
Siim Sööt
On Thu, February 22, 2007 3:41 pm, Ed Christopher wrote:
> Chuck--If I understand you I could almost conclude that in the Chicago
> numbers that have been in play over 3 decades that we took the "place of
> work not reported" for our resident workers and counted them as internal
> flows. But that could not have happened. First the same pattern
> exists all the counties I checked. Cook to Cook, Dupage, Kane, Lake,
> Will and McHenry. The 1970 BEA numbers are low. It could be that our
> 1970 UTPP numbers were tweaked and if they were originally in the
> neighborhood of the BEA numbers I could see why. I need to check out
> that path as well.
>
> Chuck how do your 1970 numbers compare? Are they more in line with
> BEAs? Does anyone else have their 1970 CTPP numbers how do they
> compare?
>
> To give you an idea of magnitude here is what I am looking at for 1970.
>
> BEA----------UTPP
> 1,931,034----2,105,178 Cook to Cook
> 27,104---32624 Cook to Dupage
> 5,403---9,056 Cook to Kane
> 8,888---18,624 Cook to Lake
> 698---951 Cook to McHenry
> 3,853---4,299 Cook to Will
>
> I also have 43,076 Cook to elsewhere but I didn't add up all the BEA
> elsewheres.
>
> I also looked at DuPage to all the other counties and the same pattern
> prevailed.
>
> -------- Original Message --------
> Subject: Re: [CTPP] New Website--Old Data
> Date: Thu, 22 Feb 2007 08:33:57 -0800
> From: "Chuck Purvis" <CPurvis(a)mtc.ca.gov>
> To: "Ed Christopher" <edc(a)berwyned.com>,"ctpp-news maillist"
> <ctpp-news(a)chrispy.net>
>
> Hi Ed:
>
> The 1970 Census data on the BEA website shows a separate row, at the
> very end of each county's table, for "place of work not reported". So,
> Cook County Illinois has 181,911 resident workers with place-of-work not
> reported, in 1970. Part of the mystery is solved.
>
> I believe all of the "standard" 1970 Census tabulations did NOTdo
> place-of-work allocation (imputation), so we would always see the "not
> reported" data for any county, place or tract.
>
> The 1970 Urban Transportation Package (UTP) probably had some
> allocation (imputation) procedure to allocate the "not reported"
> area-of-work to whatever geographies were used after the 1970 Census.
> This is a guess. I don't have extensive records of the 1970 process. [I
> do have the "Urban Transportation Factbook" published by the American
> Institute of Planners and the Motor Vehicles Manufacturers Assocation,
> in 1974, but it appears to be based on standard census tabulations, not
> the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
> Phil can find the info before he retires next Friday? Or perhaps the
> answers are in the archives - - JJ McDonnell's papers, or Alan
> Pisarski's office....Perhaps some information is in the TRB Special
> Report #145 (the 1973 Albuquerque Census conference.)
>
> Happy hunting,
>
> Chuck
> **************************************************************
> Charles L. Purvis, AICP
> Principal Transportation Planner/Analyst
> Metropolitan Transportation Commission
> 101 Eighth Street
> Oakland, CA 94607-4700
> (510) 817-5755 (office) [new, 8/1/05]
> (510) 817-7848 (fax) [new, 8/1/05]
> www: http://www.mtc.ca.gov/
> Census WWW: http://www.bayareacensus.ca.gov/
> **************************************************************
>
>>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
> Our friends (who I do not know) at the Bureau of Economic Analysis who
> do the Regional Economic Accounts revamped their historic (1970, 1980,
> 1990 and 2000) Journey to Work (JTW) data base and put a nice search
> engine to it. For years I have sent people to the BEA sight for JTW
> flows but with the new search engine and the 2000 data it is so easy to
> use. For 2000 they have added flows by major industry at the county
> level and by minor industry at the state level. You really need to
> check it out. http://www.bea.gov/bea/regional/reis/jtw/
>
> But then there is the nagging issue. Why do my historic CTPP/UTPP
> numbers and BEA not match. In 1970 and 1980 the two sources look to be
> off in different directions, but for 1990 they match and for 2000 it
> looks like a small rounding difference. Getting into the detail,
> attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
> IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K higher
> out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
> this keeps coming up, but why? Is the pattern the same around the
> country, BEA is high in 1980 and low in 1970? At some point we may need
> to reconcile all this and pick one series or the other. Since I have
> been tracking the Chicago region numbers
> (http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time this
> has always been a nagging headache.
>
> How do all the numbers compare in your counties? Does anyone remember
> why the 70s and 80s might not match?
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 19900 Governors Dr
> Olympia Fields, IL 60461
>
--
Siim Sööt
Urban Transportation Center
University of Illinois at Chicago
312-996-2666
Homepage: www.uic.edu/~siim
Home: 678 Foxdale, Winnetka IL 60093-1950
847-446-7560 home
847-372-7560 cell
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
Chuck--If I understand you I could almost conclude that in the Chicago
numbers that have been in play over 3 decades that we took the "place of
work not reported" for our resident workers and counted them as internal
flows. But that could not have happened. First the same pattern
exists all the counties I checked. Cook to Cook, Dupage, Kane, Lake,
Will and McHenry. The 1970 BEA numbers are low. It could be that our
1970 UTPP numbers were tweaked and if they were originally in the
neighborhood of the BEA numbers I could see why. I need to check out
that path as well.
Chuck how do your 1970 numbers compare? Are they more in line with
BEAs? Does anyone else have their 1970 CTPP numbers how do they
compare?
To give you an idea of magnitude here is what I am looking at for 1970.
BEA----------UTPP
1,931,034----2,105,178 Cook to Cook
27,104---32624 Cook to Dupage
5,403---9,056 Cook to Kane
8,888---18,624 Cook to Lake
698---951 Cook to McHenry
3,853---4,299 Cook to Will
I also have 43,076 Cook to elsewhere but I didn't add up all the BEA
elsewheres.
I also looked at DuPage to all the other counties and the same pattern
prevailed.
-------- Original Message --------
Subject: Re: [CTPP] New Website--Old Data
Date: Thu, 22 Feb 2007 08:33:57 -0800
From: "Chuck Purvis" <CPurvis(a)mtc.ca.gov>
To: "Ed Christopher" <edc(a)berwyned.com>,"ctpp-news maillist"
<ctpp-news(a)chrispy.net>
Hi Ed:
The 1970 Census data on the BEA website shows a separate row, at the
very end of each county's table, for "place of work not reported". So,
Cook County Illinois has 181,911 resident workers with place-of-work not
reported, in 1970. Part of the mystery is solved.
I believe all of the "standard" 1970 Census tabulations did NOTdo
place-of-work allocation (imputation), so we would always see the "not
reported" data for any county, place or tract.
The 1970 Urban Transportation Package (UTP) probably had some
allocation (imputation) procedure to allocate the "not reported"
area-of-work to whatever geographies were used after the 1970 Census.
This is a guess. I don't have extensive records of the 1970 process. [I
do have the "Urban Transportation Factbook" published by the American
Institute of Planners and the Motor Vehicles Manufacturers Assocation,
in 1974, but it appears to be based on standard census tabulations, not
the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
Phil can find the info before he retires next Friday? Or perhaps the
answers are in the archives - - JJ McDonnell's papers, or Alan
Pisarski's office....Perhaps some information is in the TRB Special
Report #145 (the 1973 Albuquerque Census conference.)
Happy hunting,
Chuck
**************************************************************
Charles L. Purvis, AICP
Principal Transportation Planner/Analyst
Metropolitan Transportation Commission
101 Eighth Street
Oakland, CA 94607-4700
(510) 817-5755 (office) [new, 8/1/05]
(510) 817-7848 (fax) [new, 8/1/05]
www: http://www.mtc.ca.gov/
Census WWW: http://www.bayareacensus.ca.gov/
**************************************************************
>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
Our friends (who I do not know) at the Bureau of Economic Analysis who
do the Regional Economic Accounts revamped their historic (1970, 1980,
1990 and 2000) Journey to Work (JTW) data base and put a nice search
engine to it. For years I have sent people to the BEA sight for JTW
flows but with the new search engine and the 2000 data it is so easy to
use. For 2000 they have added flows by major industry at the county
level and by minor industry at the state level. You really need to
check it out. http://www.bea.gov/bea/regional/reis/jtw/
But then there is the nagging issue. Why do my historic CTPP/UTPP
numbers and BEA not match. In 1970 and 1980 the two sources look to be
off in different directions, but for 1990 they match and for 2000 it
looks like a small rounding difference. Getting into the detail,
attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K higher
out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
this keeps coming up, but why? Is the pattern the same around the
country, BEA is high in 1980 and low in 1970? At some point we may need
to reconcile all this and pick one series or the other. Since I have
been tracking the Chicago region numbers
(http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time this
has always been a nagging headache.
How do all the numbers compare in your counties? Does anyone remember
why the 70s and 80s might not match?
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
19900 Governors Dr
Olympia Fields, IL 60461
Hi Ed:
The 1970 Census data on the BEA website shows a separate row, at the
very end of each county's table, for "place of work not reported". So,
Cook County Illinois has 181,911 resident workers with place-of-work not
reported, in 1970. Part of the mystery is solved.
I believe all of the "standard" 1970 Census tabulations did NOTdo
place-of-work allocation (imputation), so we would always see the "not
reported" data for any county, place or tract.
The 1970 Urban Transportation Package (UTP) probably had some
allocation (imputation) procedure to allocate the "not reported"
area-of-work to whatever geographies were used after the 1970 Census.
This is a guess. I don't have extensive records of the 1970 process. [I
do have the "Urban Transportation Factbook" published by the American
Institute of Planners and the Motor Vehicles Manufacturers Assocation,
in 1974, but it appears to be based on standard census tabulations, not
the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
Phil can find the info before he retires next Friday? Or perhaps the
answers are in the archives - - JJ McDonnell's papers, or Alan
Pisarski's office....Perhaps some information is in the TRB Special
Report #145 (the 1973 Albuquerque Census conference.)
Happy hunting,
Chuck
**************************************************************
Charles L. Purvis, AICP
Principal Transportation Planner/Analyst
Metropolitan Transportation Commission
101 Eighth Street
Oakland, CA 94607-4700
(510) 817-5755 (office) [new, 8/1/05]
(510) 817-7848 (fax) [new, 8/1/05]
www: http://www.mtc.ca.gov/
Census WWW: http://www.bayareacensus.ca.gov/
**************************************************************
>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
Our friends (who I do not know) at the Bureau of Economic Analysis who
do the Regional Economic Accounts revamped their historic (1970, 1980,
1990 and 2000) Journey to Work (JTW) data base and put a nice search
engine to it. For years I have sent people to the BEA sight for JTW
flows but with the new search engine and the 2000 data it is so easy
to
use. For 2000 they have added flows by major industry at the county
level and by minor industry at the state level. You really need to
check it out. http://www.bea.gov/bea/regional/reis/jtw/
But then there is the nagging issue. Why do my historic CTPP/UTPP
numbers and BEA not match. In 1970 and 1980 the two sources look to
be
off in different directions, but for 1990 they match and for 2000 it
looks like a small rounding difference. Getting into the detail,
attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K
higher
out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
this keeps coming up, but why? Is the pattern the same around the
country, BEA is high in 1980 and low in 1970? At some point we may
need
to reconcile all this and pick one series or the other. Since I have
been tracking the Chicago region numbers
(http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time
this
has always been a nagging headache.
How do all the numbers compare in your counties? Does anyone remember
why the 70s and 80s might not match? (please reply to all)
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
19900 Governors Dr
Olympia Fields, IL 60461
_______________________________________________
ctpp-news mailing list
ctpp-news(a)chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news
Hi Ed:
The 1970 Census data on the BEA website shows a separate row, at the
very end of each county's table, for "place of work not reported". So,
Cook County Illinois has 181,911 resident workers with place-of-work not
reported, in 1970. Part of the mystery is solved.
I believe all of the "standard" 1970 Census tabulations did NOTdo
place-of-work allocation (imputation), so we would always see the "not
reported" data for any county, place or tract.
The 1970 Urban Transportation Package (UTP) probably had some
allocation (imputation) procedure to allocate the "not reported"
area-of-work to whatever geographies were used after the 1970 Census.
This is a guess. I don't have extensive records of the 1970 process. [I
do have the "Urban Transportation Factbook" published by the American
Institute of Planners and the Motor Vehicles Manufacturers Assocation,
in 1974, but it appears to be based on standard census tabulations, not
the UTP....?] Perhaps the answers are hidden in the Census Bureau (maybe
Phil can find the info before he retires next Friday? Or perhaps the
answers are in the archives - - JJ McDonnell's papers, or Alan
Pisarski's office....Perhaps some information is in the TRB Special
Report #145 (the 1973 Albuquerque Census conference.)
Happy hunting,
Chuck
**************************************************************
Charles L. Purvis, AICP
Principal Transportation Planner/Analyst
Metropolitan Transportation Commission
101 Eighth Street
Oakland, CA 94607-4700
(510) 817-5755 (office) [new, 8/1/05]
(510) 817-7848 (fax) [new, 8/1/05]
www: http://www.mtc.ca.gov/
Census WWW: http://www.bayareacensus.ca.gov/
**************************************************************
>>> Ed Christopher <edc(a)berwyned.com> 02/21/07 8:40 PM >>>
Our friends (who I do not know) at the Bureau of Economic Analysis who
do the Regional Economic Accounts revamped their historic (1970, 1980,
1990 and 2000) Journey to Work (JTW) data base and put a nice search
engine to it. For years I have sent people to the BEA sight for JTW
flows but with the new search engine and the 2000 data it is so easy
to
use. For 2000 they have added flows by major industry at the county
level and by minor industry at the state level. You really need to
check it out. http://www.bea.gov/bea/regional/reis/jtw/
But then there is the nagging issue. Why do my historic CTPP/UTPP
numbers and BEA not match. In 1970 and 1980 the two sources look to
be
off in different directions, but for 1990 they match and for 2000 it
looks like a small rounding difference. Getting into the detail,
attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K
higher
out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
this keeps coming up, but why? Is the pattern the same around the
country, BEA is high in 1980 and low in 1970? At some point we may
need
to reconcile all this and pick one series or the other. Since I have
been tracking the Chicago region numbers
(http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time
this
has always been a nagging headache.
How do all the numbers compare in your counties? Does anyone remember
why the 70s and 80s might not match? (please reply to all)
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
19900 Governors Dr
Olympia Fields, IL 60461
Our friends (who I do not know) at the Bureau of Economic Analysis who
do the Regional Economic Accounts revamped their historic (1970, 1980,
1990 and 2000) Journey to Work (JTW) data base and put a nice search
engine to it. For years I have sent people to the BEA sight for JTW
flows but with the new search engine and the 2000 data it is so easy to
use. For 2000 they have added flows by major industry at the county
level and by minor industry at the state level. You really need to
check it out. http://www.bea.gov/bea/regional/reis/jtw/
But then there is the nagging issue. Why do my historic CTPP/UTPP
numbers and BEA not match. In 1970 and 1980 the two sources look to be
off in different directions, but for 1990 they match and for 2000 it
looks like a small rounding difference. Getting into the detail,
attached is a comparison of the BEA/CTPP-UTPP numbers for Cook county
IL, specifically the Cook to Cook flows. In 1980 BEA is about 2K higher
out of 2M, but in 1970 BEA is in the neighborhood of 200K low. I know
this keeps coming up, but why? Is the pattern the same around the
country, BEA is high in 1980 and low in 1970? At some point we may need
to reconcile all this and pick one series or the other. Since I have
been tracking the Chicago region numbers
(http://www.berwyned.com/papers/co2cochgo.pdf) for quite some time this
has always been a nagging headache.
How do all the numbers compare in your counties? Does anyone remember
why the 70s and 80s might not match? (please reply to all)
--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)
FHWA RC-TST-PLN
19900 Governors Dr
Olympia Fields, IL 60461
Sorry! I hit the "send" button instead of "save." I guess I am having
a BAD DAY with email and the CTPP listserv.
The IPUMS site http://usa.ipums.org/usa/sda/ provides an on-line table
generator using the 2005 ACS public use microdata sample, that also
allows for other statistical tests such as correlation, multiple
regression, logit/probit regression. It provides a way to create new
variables. And it is FREE! So, if the Census Bureau is not including
the table YOU want in their standard set, you can create your own table
with this tool.
For example, in CTPP, we have a variable called "Means of Transportation
to Work." However, in the microdata, this is two questions:
How did this person usually get to work LAST WEEK? List of methods.
How many people, including this person, usually rode to work in the car,
truck or van, LAST WEEK? __ persons
To separate "drive alone" from "carpool" you will need to use both
variables: TRANWORK and CARPOOL
The Public Use Microdata Sample is a SAMPLE of the ACS sample records,
so this is going to be useful mostly for large geographic units, or
national analysis.
So, going back to my earlier email about "year of entry", I could use
the IPUMS to analyze the Census 2000 and the 2005 ACS data, and use the
values to create a new variable.
Hope this is of interest to at least some of you! Have a GREAT WEEKEND!
Elaine
