I downloaded the Maryland state raw data (the whole enchilada) that
Penelope was good enough to provide me. It came with documentation that
clearly explains what needs to be done but I am being hampered by the sheer
size of the dataset. It's 10 GB and that's without going into joining
tables, transposing them to meet my needs, etc. Even breaking the parts
into different databases it can't be handled in Access. I can fit Part 1
into an ESRI geodatabase but I don't have the flexibility in linking tables
that Access has.
Does anyone have any suggestions for dealing with large databases? SQL
server is one option. Are there others?
*Mara Kaminowitz, GISP*GIS Coordinator
.........................................................................
*Baltimore Metropolitan Council*
Offices @ McHenry Row
1500 Whetstone Way
Suite 300
Baltimore, MD 21230
410-732-0500 ext. 1030
mkaminowitz(a)baltometro.orgwww.baltometro.org
Having an ACS or Census Long Form takes a lot of hits in media and on
Capital Hill. However, it is always instructive to hear from another
side. I snagged this from another list I am on and thought a few here
would enjoy it.
-------------------------------------
Posted: 13 Nov 2013 10:59 AM PST
by Terri Ann Lowenthal
Let me start with a timely salute to our nation’s veterans. All 21
million of them, including 2.4 million African American and 1.2 million
Hispanic former service members. Shout-outs to Killeen, Texas, and
Clarksville, Tennessee, where veterans comprise a quarter or more of
local residents. Hats off to the more than nine in ten veterans with a
high school diploma — a greater proportion than the general population.
And is it any wonder that these patriotic fellow citizens are twice as
likely as non-veterans to hold a job in public administration?
Oh, sorry, I digress from the focus of this blog. But really, people,
it’s important that we know this stuff — and more — about those who
defend our freedoms. About three-quarters of our living military
veterans served worldwide while the country was at war. More than a
quarter of both Gulf War and post-9/11 era vets live with a
service-connected disability. Nearly 30 percent of veterans reside in
rural areas, but rural vets represent 41 percent of those enrolled in
the VA health care system. Veterans in rural communities are more likely
to have at least one disability compared to non-veteran rural dwellers.
Raise your hand if you know where I’m going with this. That’s right: a
lot of what we know about our veterans comes from the Census Bureau’s
American Community Survey (ACS). Businesses, nonprofits, and federal,
state and local leaders use ACS data to understand and address the needs
of veterans — from job training and employment assistance, to health
care, to housing, and more. Who among us wouldn’t want that for our
former soldiers?
So why, oh why, in the words of Rep. Jeff Duncan (R-SC), sponsor of a
bill to cancel the ACS (and just about every other Census Bureau
program), are Americans “fed up with these mandatory census surveys and
[they’re] asking us to stop the harassment”?
Ummm, no, they’re not. Okay, maybe a few are grumbling. According to the
Census Bureau’s new cheerleader for harassed Americans (officially
called the Respondent Advocate), roughly 60 percent of households answer
the ACS without any prodding at all. With a little encouragement and
explanation, by phone or in person, the response rate jumps to 97+
percent (weighted). Of the 3.54 million households in the 2012 ACS
sample, less than 8,000 refused to participate (and no one, I can assure
you, was hauled off to jail). Let’s see: that’s a refusal rate of
(drumroll) two-tenths of a percent. The 535 members of Congress were so
deluged with anti-ACS complaints that they sent the bureau (another
drumroll, please) 187 letters on behalf of distraught constituents over
the past 18 months.
Sure, the ACS questions could use a systematic review and some
fine-tuning; thorough training will help ensure positive interaction
between survey takers and responding householders. I suspect the Census
Bureau has been a little behind the eight ball in acknowledging
thoughtful concerns about parts of the survey; it’s finally on the right
track, I think. More on these efforts in my next blog.
But let’s stop pretending: ACS critics aren’t falling on their data
swords for countless (no pun intended, census fans!) Americans abiding
stoically in the shadow of government overreach. Ideology — namely, a
belief that government can require little of the governed, coupled with
an aversion to the sort of federal assistance dispensed on the basis of
ACS data — is driving the campaign to weaken (with voluntary response)
or eliminate the survey.
And that’s okay. (Yes, you read that correctly.) If you don’t believe
that government has a fundamental interest in producing objective,
comprehensive data to inform and guide decision-making, go ahead and
make your case. Explain and defend the consequences or propose a
practical alternative. Just please drop the cover of phantom citizens
cowering behind mailboxes, dreading a nosy questionnaire and the
prospect of devoting an hour of time to help the world’s greatest
democracy function smartly. Most Americans, it seems, are wiser than you
think. And they all love our veterans.
--
Ed Christopher
Dear CTPP Users:
Please find attached the CTPP 2006-2010 software cheat sheets that we have
developed. For example, if you are trying to get tract to tract or TAZ to
TAZ flows for multiple counties, you may find the cheat sheet for part 3
useful. Feel free to contact me if you have any questions.
Liang Long
Cambridge Systematics, Inc.
4800 Hampden Lane
Suite 800
Bethesda, MD 20814
tel 301 347 0100
fax 301 347 0101
FHWA 202-366-6971
e-mail llong(a)camsys.comwww.camsys.com
Hi All,
Based on your experiences with the 20/20 software so far, what would be the best (meaning fastest) way to obtain a TAZ-TAZ O/D matrix for all TAZ's in Weber, Davis, Salt Lake and Utah Counties. I want all trips originating and ending in those 4 counties.
Anyone care to put forward the fastest way of doing a query such as this?
Ultimately, I will be processing the data for all metro regions in matlab or python, so it would be great if the data came in a 4 column table: origin, destination, flow, MOE.
For the 2000 data, I used to just download the flat files state by state. Is this option no longer available for the 5-year ACS data?
Many thanks,
Steve
Steven Farber, Ph.D
Assistant Professor
Department of Geography
University or Utah
http://stevenfarber.wordpress.com
Hi All,
I specified residence geography as 8 counties in our region (Texas) and selected a CTPP data table. It seems the geography selection doesn't work. The data table always shows all counties in the US. Did I miss any steps? Any help?
Sharon Ju
HGAC
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Weinberger Penelope
Sent: Tuesday, November 05, 2013 4:35 PM
To: ctpp-news(a)chrispy.net
Subject: [CTPP] Breaking News: CTPP Software Download limit raised!
Hi All,
We have made an adjustment on the new CTPP 5-year data access software so that un-customized (no special groups or percentages applied) tables now have a 500,000 cell download limit (up from 100,000) this should make it much easier to get your bigger area or more flow tables!
The new software and tutorials are available at: http://ctpp.transportation.org/Pages/5-Year-Data.aspx
And please read the info and caveats at: http://ctpp.transportation.org/Pages/5-Year-Info.aspx
Penelope Z. Weinberger
CTPP Program Manager
AASHTO
202-624-3556
ctpp.transportation.org
Hi All,
We have made an adjustment on the new CTPP 5-year data access software so that un-customized (no special groups or percentages applied) tables now have a 500,000 cell download limit (up from 100,000) this should make it much easier to get your bigger area or more flow tables!
The new software and tutorials are available at: http://ctpp.transportation.org/Pages/5-Year-Data.aspx
And please read the info and caveats at: http://ctpp.transportation.org/Pages/5-Year-Info.aspx
Penelope Z. Weinberger
CTPP Program Manager
AASHTO
202-624-3556
ctpp.transportation.org
Liang: Thank you for census TAZ boundary link. First time I tried this
morning, exporting tool was not working (window error showed up), but
tried again it was ok. Now, I have ctpp shape file of our taz area
with proper field name that ready to be linked with other data I have
downloaded. The problem with ctpp shapefile is variable field name is
not clear, I just discard this, I only need "name" field for linking
to data.
Penelope: TAZ ctpp and our model TAZ are absolutely different and it
is normal. Now I can do the analysis for aggregating/disaggregating
to/from tract-mcd or block level data (from LEHD or other sources) and
comparing with our model data set.
Thank you,
Hary
On Fri, Nov 1, 2013 at 11:12 AM, <Liang.Long.CTR(a)dot.gov> wrote:
> Hi, Hary
>
> The software allows exporting maps to pdf or other picture format including Jpeg etc. If you go back to the table view, you can also download the table in shape file and then importing them to ArcGIS for whatever comparison you are trying to do.
>
> I’m not quite sure what data and map you are looking for. But if you are simply looking for Census TAZ boundaries shapefiles and you don’t need any of the CTPP data, the TAZ boundary files can be downloaded from here:
>
> ftp://ftp2.census.gov/geo/tiger/TIGER2010/TAZ/
>
> Please let us know if you have any more questions.
>
> Liang
>
>
>
> ________________________________________
> From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of hprawiranata mitcrpc.org [hprawiranata(a)mitcrpc.org]
> Sent: Friday, November 01, 2013 9:36 AM
> To: ctpp-news(a)chrispy.net
> Subject: Re: [CTPP] It's Alive! CTPP 5-year data
>
> Congratulations ! Domain change/server change still keep my login with
> my searches (I have many search criteria made/saved in the last 3
> weeks). However, map export is still not working. I have to screenshot
> and rectified on ArcGIS for the TAZ level to compare it with our TAZ.
> When I checked CTPP TAZ delineation project file made in 2011 all TAZ
> numbers are different. Can anyone help me to link data and map ? (I
> have not started numbering my rectified TAZ map from screenshot, our
> area has 393 TAZ in CTPP data set and our model has ~1000 TAZ )
>
> Hary
>
>
>
> On Thu, Oct 31, 2013 at 4:40 PM, Weinberger Penelope
> <pweinberger(a)aashto.org> wrote:
>> At long last the CTPP 5 year small area data is (a)live and can be accessed
>> by clicking take me to the data at the following URL:
>> http://ctpp.transportation.org/Pages/5-Year-Data.aspx
>>
>>
>>
>> A tutorial that shows the software’s functionality is available at:
>> http://ctpp.transportation.org/Documents/CTPP_tutorial_v02.pdf
>>
>>
>>
>> Web tutorials are available at: http://www.youtube.com/user/CTPPProgram
>>
>>
>>
>> Please see the message below for more information and known issues.
>>
>>
>>
>> From: Weinberger Penelope
>> Sent: Wednesday, October 30, 2013 5:27 PM
>> To: ctpp-news(a)chrispy.net
>> Subject: CTPP 5-year data
>>
>>
>>
>> The CTPP 5-year data, based on ACS 2006 – 2010 Census Data, will be released
>> tomorrow Thursday, October 31, 2013, the URL to access the data will be
>> published here.
>>
>>
>>
>> The CTPP Data Access Software is a powerful tool to access the nearly 350
>> gigs of data provided by the Census Bureau. The Data set consists of almost
>> 200 residence based tables, 115 workplace based tables and 39 flow tables
>> (Home to work) for over 325,000 geographies. The data are derived from two
>> American Community Survey microdata record sets based on the 2006 – 2010
>> ACS. One set is the original microdata; all tables derived from this set are
>> designated A, the other set is a disclosure proofed microdata set; all
>> tables derived from this set are designated B. That is to say, the first
>> letter in the table name indicates the set from which the table was derived.
>> For more information on disclosure proofing, please access the CTPP
>> e-Learning module “Disclosure Proofing” at:
>> http://ctpp.training.transportation.org/
>>
>>
>>
>> The software contains a robust map tool, for both selecting geography and
>> rendering results. Results can also be presented as various style charts
>> and tables that can be rearranged to suit your analysis and display needs.
>> Data from the tool can be downloaded as comma or semi colon delimited .csv,
>> .xml, .shp, .tab.
>>
>>
>>
>> Some things to be aware of:
>>
>>
>>
>> This is a new software release and it is possible you may find some errors
>> and bugs as you use it. Please use the CTPP Feedback form available in the
>> Help menu to report any problems encountered. (Version 1.1 release, already
>> planned for the near future, reflects corrections to issues discovered after
>> Beta testing.) Please consider this a Gamma version.
>>
>>
>>
>> A PDF tutorial is available in the Help menu and covers much of the software
>> functionality teaching a sample application. The context sensitive
>> (on-line) help has some bugs that are currently being addressed. A series
>> of short film tutorials is available on the CTPP YouTube channel at:
>> http://www.youtube.com/user/CTPPProgram. The YouTube tutorials include a
>> software tour, how to register/logon, opening and rearranging a
>> table/accessing basic data; Geography selection by list and map; Calculating
>> percentages; and Display maps and thematic analyses. If, after you have
>> exhausted all resources you are still having trouble please contact
>> pweinberger(a)aashto.org for a walk through, but please try to find your
>> solution from available resources first. Training is rolling out both in
>> person and online, we will keep you posted.
>>
>>
>>
>> Downloads are limited to 100,000 cells. If you need to download large
>> tables they will need to be split up and stitched back together in excel (or
>> another program). We are developing a background downloader for large
>> files. In the meantime, if you simply want all the data for your entire
>> area, send a message to pweinberger(a)aashto.org and a set with appropriate
>> documentation will be made available for FTP download. Any very large data
>> set is unsupported and for power users, comfortable manipulating large data
>> sets in statistical software packages that they are already licensed to use.
>>
>>
>>
>> Geographies can be aggregated and margins of error will be correctly
>> re-calculated, but non-standard (user created) saved geographies cannot be
>> mapped – we are working on this.
>>
>>
>>
>> Until approximately January 2014, the data set available does not include
>> workplace data for TAZs with zero (0) populations. This means that any TAZ
>> which consists solely of a special generator (i.e., an airport, a shopping
>> mall, a business park, the pentagon, etc.) does not have its associated
>> workplace data or flow to it available. This is being rectified and a new
>> dataset will be released around January, 2014 that corrects that problem.
>> Fortunately, the data is available at tract even for zero pop tracts, so you
>> can get the data at smallish, just not smallest, level and you can do TAZ
>> to Tract flows
>>
>>
>>
>> Penelope Z. Weinberger
>>
>> CTPP Program Manager
>>
>> AASHTO
>>
>> 202-624-3556
>>
>> ctpp.transportation.org
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news(a)ryoko.chrispy.net
>> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>>
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Hary,
Caliper will soon be providing the ctpp data in TransCAD formats which should make your life easier.
Howard
-----Original Message-----
From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of hprawiranata mitcrpc.org
Sent: Friday, November 01, 2013 9:37 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] It's Alive! CTPP 5-year data
Congratulations ! Domain change/server change still keep my login with my searches (I have many search criteria made/saved in the last 3 weeks). However, map export is still not working. I have to screenshot and rectified on ArcGIS for the TAZ level to compare it with our TAZ.
When I checked CTPP TAZ delineation project file made in 2011 all TAZ numbers are different. Can anyone help me to link data and map ? (I have not started numbering my rectified TAZ map from screenshot, our area has 393 TAZ in CTPP data set and our model has ~1000 TAZ )
Hary
On Thu, Oct 31, 2013 at 4:40 PM, Weinberger Penelope <pweinberger(a)aashto.org> wrote:
> At long last the CTPP 5 year small area data is (a)live and can be
> accessed by clicking take me to the data at the following URL:
> http://ctpp.transportation.org/Pages/5-Year-Data.aspx
>
>
>
> A tutorial that shows the software's functionality is available at:
> http://ctpp.transportation.org/Documents/CTPP_tutorial_v02.pdf
>
>
>
> Web tutorials are available at:
> http://www.youtube.com/user/CTPPProgram
>
>
>
> Please see the message below for more information and known issues.
>
>
>
> From: Weinberger Penelope
> Sent: Wednesday, October 30, 2013 5:27 PM
> To: ctpp-news(a)chrispy.net
> Subject: CTPP 5-year data
>
>
>
> The CTPP 5-year data, based on ACS 2006 - 2010 Census Data, will be
> released tomorrow Thursday, October 31, 2013, the URL to access the
> data will be published here.
>
>
>
> The CTPP Data Access Software is a powerful tool to access the nearly
> 350 gigs of data provided by the Census Bureau. The Data set consists
> of almost
> 200 residence based tables, 115 workplace based tables and 39 flow
> tables (Home to work) for over 325,000 geographies. The data are
> derived from two American Community Survey microdata record sets based
> on the 2006 - 2010 ACS. One set is the original microdata; all tables
> derived from this set are designated A, the other set is a disclosure
> proofed microdata set; all tables derived from this set are designated
> B. That is to say, the first letter in the table name indicates the set from which the table was derived.
> For more information on disclosure proofing, please access the CTPP
> e-Learning module "Disclosure Proofing" at:
> http://ctpp.training.transportation.org/
>
>
>
> The software contains a robust map tool, for both selecting geography
> and rendering results. Results can also be presented as various style
> charts and tables that can be rearranged to suit your analysis and display needs.
> Data from the tool can be downloaded as comma or semi colon delimited
> .csv, .xml, .shp, .tab.
>
>
>
> Some things to be aware of:
>
>
>
> This is a new software release and it is possible you may find some
> errors and bugs as you use it. Please use the CTPP Feedback form
> available in the Help menu to report any problems encountered.
> (Version 1.1 release, already planned for the near future, reflects
> corrections to issues discovered after Beta testing.) Please consider this a Gamma version.
>
>
>
> A PDF tutorial is available in the Help menu and covers much of the
> software functionality teaching a sample application. The context
> sensitive
> (on-line) help has some bugs that are currently being addressed. A
> series of short film tutorials is available on the CTPP YouTube channel at:
> http://www.youtube.com/user/CTPPProgram. The YouTube tutorials
> include a software tour, how to register/logon, opening and
> rearranging a table/accessing basic data; Geography selection by list
> and map; Calculating percentages; and Display maps and thematic
> analyses. If, after you have exhausted all resources you are still
> having trouble please contact pweinberger(a)aashto.org for a walk
> through, but please try to find your solution from available resources
> first. Training is rolling out both in person and online, we will keep you posted.
>
>
>
> Downloads are limited to 100,000 cells. If you need to download large
> tables they will need to be split up and stitched back together in
> excel (or another program). We are developing a background downloader
> for large files. In the meantime, if you simply want all the data for
> your entire area, send a message to pweinberger(a)aashto.org and a set
> with appropriate documentation will be made available for FTP
> download. Any very large data set is unsupported and for power users,
> comfortable manipulating large data sets in statistical software packages that they are already licensed to use.
>
>
>
> Geographies can be aggregated and margins of error will be correctly
> re-calculated, but non-standard (user created) saved geographies
> cannot be mapped - we are working on this.
>
>
>
> Until approximately January 2014, the data set available does not
> include workplace data for TAZs with zero (0) populations. This means
> that any TAZ which consists solely of a special generator (i.e., an
> airport, a shopping mall, a business park, the pentagon, etc.) does
> not have its associated workplace data or flow to it available. This
> is being rectified and a new dataset will be released around January, 2014 that corrects that problem.
> Fortunately, the data is available at tract even for zero pop tracts,
> so you can get the data at smallish, just not smallest, level and you
> can do TAZ to Tract flows
>
>
>
> Penelope Z. Weinberger
>
> CTPP Program Manager
>
> AASHTO
>
> 202-624-3556
>
> ctpp.transportation.org
>
>
>
>
>
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
Hi, Hary
The software allows exporting maps to pdf or other picture format including Jpeg etc. If you go back to the table view, you can also download the table in shape file and then importing them to ArcGIS for whatever comparison you are trying to do.
I’m not quite sure what data and map you are looking for. But if you are simply looking for Census TAZ boundaries shapefiles and you don’t need any of the CTPP data, the TAZ boundary files can be downloaded from here:
ftp://ftp2.census.gov/geo/tiger/TIGER2010/TAZ/
Please let us know if you have any more questions.
Liang
________________________________________
From: ctpp-news-bounces(a)chrispy.net [ctpp-news-bounces(a)chrispy.net] on behalf of hprawiranata mitcrpc.org [hprawiranata(a)mitcrpc.org]
Sent: Friday, November 01, 2013 9:36 AM
To: ctpp-news(a)chrispy.net
Subject: Re: [CTPP] It's Alive! CTPP 5-year data
Congratulations ! Domain change/server change still keep my login with
my searches (I have many search criteria made/saved in the last 3
weeks). However, map export is still not working. I have to screenshot
and rectified on ArcGIS for the TAZ level to compare it with our TAZ.
When I checked CTPP TAZ delineation project file made in 2011 all TAZ
numbers are different. Can anyone help me to link data and map ? (I
have not started numbering my rectified TAZ map from screenshot, our
area has 393 TAZ in CTPP data set and our model has ~1000 TAZ )
Hary
On Thu, Oct 31, 2013 at 4:40 PM, Weinberger Penelope
<pweinberger(a)aashto.org> wrote:
> At long last the CTPP 5 year small area data is (a)live and can be accessed
> by clicking take me to the data at the following URL:
> http://ctpp.transportation.org/Pages/5-Year-Data.aspx
>
>
>
> A tutorial that shows the software’s functionality is available at:
> http://ctpp.transportation.org/Documents/CTPP_tutorial_v02.pdf
>
>
>
> Web tutorials are available at: http://www.youtube.com/user/CTPPProgram
>
>
>
> Please see the message below for more information and known issues.
>
>
>
> From: Weinberger Penelope
> Sent: Wednesday, October 30, 2013 5:27 PM
> To: ctpp-news(a)chrispy.net
> Subject: CTPP 5-year data
>
>
>
> The CTPP 5-year data, based on ACS 2006 – 2010 Census Data, will be released
> tomorrow Thursday, October 31, 2013, the URL to access the data will be
> published here.
>
>
>
> The CTPP Data Access Software is a powerful tool to access the nearly 350
> gigs of data provided by the Census Bureau. The Data set consists of almost
> 200 residence based tables, 115 workplace based tables and 39 flow tables
> (Home to work) for over 325,000 geographies. The data are derived from two
> American Community Survey microdata record sets based on the 2006 – 2010
> ACS. One set is the original microdata; all tables derived from this set are
> designated A, the other set is a disclosure proofed microdata set; all
> tables derived from this set are designated B. That is to say, the first
> letter in the table name indicates the set from which the table was derived.
> For more information on disclosure proofing, please access the CTPP
> e-Learning module “Disclosure Proofing” at:
> http://ctpp.training.transportation.org/
>
>
>
> The software contains a robust map tool, for both selecting geography and
> rendering results. Results can also be presented as various style charts
> and tables that can be rearranged to suit your analysis and display needs.
> Data from the tool can be downloaded as comma or semi colon delimited .csv,
> .xml, .shp, .tab.
>
>
>
> Some things to be aware of:
>
>
>
> This is a new software release and it is possible you may find some errors
> and bugs as you use it. Please use the CTPP Feedback form available in the
> Help menu to report any problems encountered. (Version 1.1 release, already
> planned for the near future, reflects corrections to issues discovered after
> Beta testing.) Please consider this a Gamma version.
>
>
>
> A PDF tutorial is available in the Help menu and covers much of the software
> functionality teaching a sample application. The context sensitive
> (on-line) help has some bugs that are currently being addressed. A series
> of short film tutorials is available on the CTPP YouTube channel at:
> http://www.youtube.com/user/CTPPProgram. The YouTube tutorials include a
> software tour, how to register/logon, opening and rearranging a
> table/accessing basic data; Geography selection by list and map; Calculating
> percentages; and Display maps and thematic analyses. If, after you have
> exhausted all resources you are still having trouble please contact
> pweinberger(a)aashto.org for a walk through, but please try to find your
> solution from available resources first. Training is rolling out both in
> person and online, we will keep you posted.
>
>
>
> Downloads are limited to 100,000 cells. If you need to download large
> tables they will need to be split up and stitched back together in excel (or
> another program). We are developing a background downloader for large
> files. In the meantime, if you simply want all the data for your entire
> area, send a message to pweinberger(a)aashto.org and a set with appropriate
> documentation will be made available for FTP download. Any very large data
> set is unsupported and for power users, comfortable manipulating large data
> sets in statistical software packages that they are already licensed to use.
>
>
>
> Geographies can be aggregated and margins of error will be correctly
> re-calculated, but non-standard (user created) saved geographies cannot be
> mapped – we are working on this.
>
>
>
> Until approximately January 2014, the data set available does not include
> workplace data for TAZs with zero (0) populations. This means that any TAZ
> which consists solely of a special generator (i.e., an airport, a shopping
> mall, a business park, the pentagon, etc.) does not have its associated
> workplace data or flow to it available. This is being rectified and a new
> dataset will be released around January, 2014 that corrects that problem.
> Fortunately, the data is available at tract even for zero pop tracts, so you
> can get the data at smallish, just not smallest, level and you can do TAZ
> to Tract flows
>
>
>
> Penelope Z. Weinberger
>
> CTPP Program Manager
>
> AASHTO
>
> 202-624-3556
>
> ctpp.transportation.org
>
>
>
>
>
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news(a)ryoko.chrispy.net
> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>
_______________________________________________
ctpp-news mailing list
ctpp-news(a)ryoko.chrispy.nethttp://ryoko.chrispy.net/mailman/listinfo/ctpp-news
I tried again and map exporter is working !! Cool !
Thanks,
Hary
On Fri, Nov 1, 2013 at 9:36 AM, hprawiranata mitcrpc.org
<hprawiranata(a)mitcrpc.org> wrote:
> Congratulations ! Domain change/server change still keep my login with
> my searches (I have many search criteria made/saved in the last 3
> weeks). However, map export is still not working. I have to screenshot
> and rectified on ArcGIS for the TAZ level to compare it with our TAZ.
> When I checked CTPP TAZ delineation project file made in 2011 all TAZ
> numbers are different. Can anyone help me to link data and map ? (I
> have not started numbering my rectified TAZ map from screenshot, our
> area has 393 TAZ in CTPP data set and our model has ~1000 TAZ )
>
> Hary
>
>
>
> On Thu, Oct 31, 2013 at 4:40 PM, Weinberger Penelope
> <pweinberger(a)aashto.org> wrote:
>> At long last the CTPP 5 year small area data is (a)live and can be accessed
>> by clicking take me to the data at the following URL:
>> http://ctpp.transportation.org/Pages/5-Year-Data.aspx
>>
>>
>>
>> A tutorial that shows the software’s functionality is available at:
>> http://ctpp.transportation.org/Documents/CTPP_tutorial_v02.pdf
>>
>>
>>
>> Web tutorials are available at: http://www.youtube.com/user/CTPPProgram
>>
>>
>>
>> Please see the message below for more information and known issues.
>>
>>
>>
>> From: Weinberger Penelope
>> Sent: Wednesday, October 30, 2013 5:27 PM
>> To: ctpp-news(a)chrispy.net
>> Subject: CTPP 5-year data
>>
>>
>>
>> The CTPP 5-year data, based on ACS 2006 – 2010 Census Data, will be released
>> tomorrow Thursday, October 31, 2013, the URL to access the data will be
>> published here.
>>
>>
>>
>> The CTPP Data Access Software is a powerful tool to access the nearly 350
>> gigs of data provided by the Census Bureau. The Data set consists of almost
>> 200 residence based tables, 115 workplace based tables and 39 flow tables
>> (Home to work) for over 325,000 geographies. The data are derived from two
>> American Community Survey microdata record sets based on the 2006 – 2010
>> ACS. One set is the original microdata; all tables derived from this set are
>> designated A, the other set is a disclosure proofed microdata set; all
>> tables derived from this set are designated B. That is to say, the first
>> letter in the table name indicates the set from which the table was derived.
>> For more information on disclosure proofing, please access the CTPP
>> e-Learning module “Disclosure Proofing” at:
>> http://ctpp.training.transportation.org/
>>
>>
>>
>> The software contains a robust map tool, for both selecting geography and
>> rendering results. Results can also be presented as various style charts
>> and tables that can be rearranged to suit your analysis and display needs.
>> Data from the tool can be downloaded as comma or semi colon delimited .csv,
>> .xml, .shp, .tab.
>>
>>
>>
>> Some things to be aware of:
>>
>>
>>
>> This is a new software release and it is possible you may find some errors
>> and bugs as you use it. Please use the CTPP Feedback form available in the
>> Help menu to report any problems encountered. (Version 1.1 release, already
>> planned for the near future, reflects corrections to issues discovered after
>> Beta testing.) Please consider this a Gamma version.
>>
>>
>>
>> A PDF tutorial is available in the Help menu and covers much of the software
>> functionality teaching a sample application. The context sensitive
>> (on-line) help has some bugs that are currently being addressed. A series
>> of short film tutorials is available on the CTPP YouTube channel at:
>> http://www.youtube.com/user/CTPPProgram. The YouTube tutorials include a
>> software tour, how to register/logon, opening and rearranging a
>> table/accessing basic data; Geography selection by list and map; Calculating
>> percentages; and Display maps and thematic analyses. If, after you have
>> exhausted all resources you are still having trouble please contact
>> pweinberger(a)aashto.org for a walk through, but please try to find your
>> solution from available resources first. Training is rolling out both in
>> person and online, we will keep you posted.
>>
>>
>>
>> Downloads are limited to 100,000 cells. If you need to download large
>> tables they will need to be split up and stitched back together in excel (or
>> another program). We are developing a background downloader for large
>> files. In the meantime, if you simply want all the data for your entire
>> area, send a message to pweinberger(a)aashto.org and a set with appropriate
>> documentation will be made available for FTP download. Any very large data
>> set is unsupported and for power users, comfortable manipulating large data
>> sets in statistical software packages that they are already licensed to use.
>>
>>
>>
>> Geographies can be aggregated and margins of error will be correctly
>> re-calculated, but non-standard (user created) saved geographies cannot be
>> mapped – we are working on this.
>>
>>
>>
>> Until approximately January 2014, the data set available does not include
>> workplace data for TAZs with zero (0) populations. This means that any TAZ
>> which consists solely of a special generator (i.e., an airport, a shopping
>> mall, a business park, the pentagon, etc.) does not have its associated
>> workplace data or flow to it available. This is being rectified and a new
>> dataset will be released around January, 2014 that corrects that problem.
>> Fortunately, the data is available at tract even for zero pop tracts, so you
>> can get the data at smallish, just not smallest, level and you can do TAZ
>> to Tract flows
>>
>>
>>
>> Penelope Z. Weinberger
>>
>> CTPP Program Manager
>>
>> AASHTO
>>
>> 202-624-3556
>>
>> ctpp.transportation.org
>>
>>
>>
>>
>>
>>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news(a)ryoko.chrispy.net
>> http://ryoko.chrispy.net/mailman/listinfo/ctpp-news
>>