Hi Everyone,
My name is Elizabeth He and I am DBA at DVRPC (Delaware Valley Regional Planning Commission). Recently, I have developed a Java Program that import ACS data files into Oracle database. You can watch the demo video from http://www.youtube.com/watch?v=vWvtr5sLGkQ
I am willing to share the program with anyone who needs it. Just send me an email at ehe(a)dvrpc.org<mailto:ehe@dvrpc.org>.
Elizabeth He, Database Administrator
Delaware Valley Regional Planning Commission
190 N. Independence Mall West, 8th Floor
Philadelphia, PA 19106
Phone: 215-238-2889
The 2006-2008 CTPP data are available on the AASHTO CTPP website.
Similar to other ACS 3-year tabulations, these data are restricted to
geographic units with Counties and Places with 20,000 population and
over. This means that the results are like "swiss cheese," that is,
very holey. For example, if you have 6 counties in your planning area,
but only 4 counties have population over 20,000, then the results will
not include the other 2 counties. The same thing happens when looking
at Place (City and Census Designated Place) values.
For residence tabulations, you might consider using Census 2000 PUMAs
since they have a complete geographic coverage. But, workplace PUMAs
are not really PUMAs for this round of CTPP, as the small area workplace
allocation is not yet completed.
Nonetheless, we hope these data will provide some utility! As a
starting point, you may want to examine some residence tables (Part 1)
for tables such as means of transportation to work by household income.
To use the data, you may want to first look at the on-line tutorials:
http://ctpp.transportation.org/Pages/3yrdas.aspx
There is a small tutorial on the CTPP, but you may also want to look at
the tutorials on the overall Web Data Server, especially the one on
"dimensions". The CTPP software built by Beyond 2020 is a customized
version of their Web Data Server.
You may want to watch and listen to the session from yesterday (March 3)
http://fhwa.adobeconnect.com/p15478140/
<http://fhwa.adobeconnect.com/p15478140/>
This was the first attempt at a training session on using the software.
Penelope Weinberger at AASHTO plans to schedule additional sessions.
For additional assistance, please contact Ms. Liang Long, CTPP Technical
Support liang.long(a)dot.gov 202-366-6971
Next week Arizona, California, Connecticut, Idaho, Ohio, Pennsylvania and
Wisconsin will be shipped. To see what is out so far go to
http://2010.census.gov/2010census/data/
--
Ed Christopher
FHWA Resource Center Planning Team
4749 Lincoln Mall Drive, Suite 600
Matteson, IL 60443
708-283-3534 (V)
708-574-8131 (C)
Hi All,
The CTPP team is pleased to bring you online training on the new Census
Transportation Planning Products (CTPP) based on 3 year ACS and data
access software.
The next webinar session is at 3:00 pm eastern on Thursday, March 3.
(Yes, that's tomorrow.)
Drop in with your Voice Over IP (VOIP) connection and learn how the
software works, what functionality the data has, and other topics of
interest. Chat your questions and comments. No registration required.
Login at: http://fhwa.adobeconnect.com/ctpp1 If you do not have a
headset a call-in number will be provided. See you there!
On Thursday from 3:00 pm - 4:00 pm Eastern:
March 3
March 17
March 31
April 14
Questions about this notice, contact:
Penelope Weinberger
CTPP Program Manager
AASHTO
202-624-3556
http://ctpp.transportation.org/Pages/default.aspx
<http://ctpp.transportation.org/Pages/default.aspx>
It's just as bad to not make a plan as to blindly follow the one you
already have.
Hi All:
I am confused as to whether the 2010 Redistricting data for localities/municipalities is based on 2000 US Census boundaries/limits or new boundaries/limits (i.e. 2010 boundaries/limits). My confusion is partly due to the USAtoday.com census tool. If you look up localities/municipalities on USAtoday.com and at the bottom is a hot link "about this data." In this pop-up, it says the following about population.....
Comparisons between 2000 and 2010: For states, counties and localities, boundary changes were not considered. If a city annexed land, for instance, the comparison matches the population in the 2000 boundary with the population in the 2010 boundary. No comparison is made for areas that are substantially new or the product of a merger or consolidation.
I understood this to be saying that the 2000 vs. 2010 percent comparison and the 2010 population count is based on the 2000 US Census locality/municipality boundary. Now I am exploring AF2 and I want to ensure I understand what boundary, 2000 or 2010, the population count refers to before doing additional analysis. Can anyone confirm that the Redistricting data just released for 2010 population counts for municipalities/localities is based on 2000 or 2010 municipal/local boundaries? Because of annexations and other issues/changes some boundary changes are now different in multiple municipalities in Montgomery MPO. Thank you for your help.
April Delchamps
Transportation Planner
Planning and Development Department
Transportation Planning Division
City of Montgomery/MPO
495 Molton St
Montgomery, AL 36104
Phone (334) 241-2734
Fax (334) 241-2326
adelchamps(a)montgomeryal.gov
MPO website: www.montgomerympo.org
City of Montgomery website: http://www.montgomeryal.gov/depts/planning/transportation.aspx
-----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: Friday, February 25, 2011 11:57 AM
To: ctpp-news(a)chrispy.net
Subject: ctpp-news Digest, Vol 84, Issue 27
Send ctpp-news mailing list submissions to
ctpp-news(a)chrispy.net
To subscribe or unsubscribe via the World Wide Web, visit
http://www.chrispy.net/mailman/listinfo/ctpp-news
or, via email, send a message with subject or body 'help' to
ctpp-news-request(a)chrispy.net
You can reach the person managing the list at
ctpp-news-owner(a)chrispy.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of ctpp-news digest..."
Today's Topics:
1. CTPP Mid Program Report (Weinberger, Penelope)
2. Public Transportation and GIS Conference (Catala, Martin)
----------------------------------------------------------------------
Message: 1
Date: Fri, 25 Feb 2011 12:30:18 -0500
From: "Weinberger, Penelope" <pweinberger(a)aashto.org>
Subject: [CTPP] CTPP Mid Program Report
To: <ctpp-news(a)chrispy.net>
Message-ID:
<94A99461953E3341B89642B00D5C0B7D0721D562(a)AASHTO-MAIL.aashto.local>
Content-Type: text/plain; charset="us-ascii"
Hi All,
The CTPP is proud to direct you to our Mid-Program report. Please take
a look at this snapshot of the CTPP Program from our Mid-point in late
2010. The report is a downloadable PDF and available at:
http://ctpp.transportation.org/Documents/CTPPMid-ProgReportFinal.pdf
Penelope Weinberger
CTPP Program Manager
AASHTO
202-624-3556
http://ctpp.transportation.org/Pages/default.aspx
<http://ctpp.transportation.org/Pages/default.aspx>
It's just as bad to not make a plan as to blindly follow the one you
already have.