CTPP

ctpp@listserv.transportation.org

5 participants
3069 discussions

[CTPP] 2010 Population Data Release

by Ed Christopher

Next week the Census Bureau plans to release the last group of states including Maine, Massachusetts, Michigan, New Hampshire, New York, Rhode Island,South Carolina, West Virginia, District of Columbia and Puerto Rico. -- Ed Christopher 708-283-3534 (V) 708-574-8131 (cell) FHWA RC-TST-PLN 4749 Lincoln Mall Drive, Suite 600 Matteson, IL 60443

14 years, 5 months

[CTPP] CTPP 5-year (2006-2010 ACS) schedule

by Elaine.Murakami＠dot.gov

Hi Diana - I thought I had responded to your query, but I was looking at the listserv archive and saw that it was not answered on the CTPP listserv. The current expectations are that the CB would deliver to AASHTO a CTPP 5-year file (with TAZ and TAD as tabulation geography) by December 31, 2012. But, then, AASHTO would need to work with someone for web-based data access. For the CTPP 2006-2008, Beyond 2020 is the main contractor. From the time the CB delivered the CTPP 3-year file, it took over 4 months to get the data on the AASHTO website, but there was a steep learning curve, and the CB did not supply any TEST data for the software developer to use, only empty table shells. Being an optimist, it would presumably take less than 4 months in the next iteration, however, the very large number of TAZs and census tracts are likely to give any software vendor a headache, especially with the flow tabulations (Part 3). Elaine

14 years, 5 months

RE: [CTPP] RE: TAZ delineation training session from February 25.

by Elaine.Murakami＠dot.gov

The TAZ delineations are due back to the Census Bureau Geography Division within 90 days AFTER you receive notification that the files for your area are ready. It is expected that MOST areas will get their files from mid-March (after March 16) through April. The User Guide will provide instructions on how to use the MTPS TAZ software, and how to submit the files (via FTP) back to the Census Bureau. Unfortunately, the User Guide has not yet been approved for release. Elaine From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Mike LeBlanc Sent: Wednesday, March 02, 2011 2:36 PM To: ctpp-news(a)chrispy.net Cc: Melanie Bordelon; Chris D. Cole; Mike Hollier Subject: [CTPP] RE: TAZ delineation training session from February 25. Hello: Does anyone know the date that the TAZ delineations are due? Does anyone know the agency that we are required to submit the TAZ delineations? Mike LeBlanc, AICP <http://www.planning.org/AICP/> Planning Manager, Special Projects Division Rosa Parks Transportation Center Lafayette Consolidated Government Department of Traffic and Transportation P.O. Box 4017-C 101 East Cypress Street Lafayette, LA 70502 Ph: 337-291-7179 Fx: 337-291-8458 Planning for the 21st Century <http://www.lafayettelinc.net/> From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Elaine.Murakami(a)dot.gov Sent: Wednesday, March 02, 2011 2:51 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] TAZ delineation training session from February 25. Hi Everyone - some of you are NOT involved in TAZ delineation, so you can just DELETE this email! But, in case you are involved, and were not able to attend the webinars that we held on 2/25 and 2/28, here is a link to the recorded session. http://fhwa.adobeconnect.com/p11971019/ <http://fhwa.adobeconnect.com/p11971019/> This session will be archived and posted on the AASHTO CTPP webpage TAZ area: http://ctpp.transportation.org/Pages/taz.aspx in the near future, as it will not live on the FHWA NHI site for very long. The Census Bureau Geography Division expects the TAZ software to be final by March 16, but the geographic files for all of the nation may not be available at that time, which is why the term "rolling" release has been used. Since the Census Bureau Geography Division says that the 90-day turn-around time is FIRM, you will need to start working on this ASAP! But please note, TAZ delineation is not mandatory for CTPP. You can use census tracts (default) or census block groups as your small tabulation geography for CTPP. We will update the FAQs for TAZ delineation (currently posted on both the AASHTO page and the FHWA page http://www.fhwa.dot.gov/ctpp/tazfaq.htm ) based on the questions and answers from the sessions held on 2/25 and 2/28. If you are interested in using 2010 Census Block Equivalency Files as a starting point, the instructions are posted on the FHWA page: http://www.fhwa.dot.gov/ctpp/tazmtps.htm Elaine Murakami FHWA Office of Planning 206-220-4460 Confidentiality Notice: This e-mail message, including any attachments is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any receipt and/or response to this email may be considered a PUBLIC RECORD. If you have received this email in error, please notify the sender immediately. Any unauthorized review, use, disclosure, or distribution is prohibited. Lafayette Parish Consolidated Government 705 W. University Avenue Lafayette, LA 70506 http://www.lafayettela.gov

14 years, 5 months

[CTPP] How small is small ? Thoughts on TAZs

by Elaine.Murakami＠dot.gov

Many of you will be working on TAZ and TAD delineations, starting on March 16. March 16 is the day the Census Bureau Geography office hopes to have the software and User Guide available, and for many states to have the geographic files for downloading. If you are part of the TAZ delineation program, you will get a email directly from the Census Bureau with the password information. I have been reading the NCHRP 08-79 Task 6 "validation phase" report. (The August 2010 CTPP Status Report includes an article about this project http://www.fhwa.dot.gov/ctpp/sr1008.htm ) You will recall that this project is developing a method to create partially synthetic microdata ACS records to use in the CTPP 5-year (2006-2010) tabulation. This is necessary otherwise, most of the tables with the variable "means of transportation to work" would be suppressed. That is, for this round of the CTPP, "partially synthetic data" was determined to be preferred to data suppression for small geography. Only SOME of the CTPP tables are deemed to be risky for individual disclosure, so only SOME of the CTPP tables will have to use the synthetic microdata records. The other CTPP tables will use the actual ACS microdata records. If you attended the TAZ training webinars (2/25 and 2/28), and if you reviewed the TAZ software specifications, you know that the software WILL allow for very small TAZs, but the software will warn you if the resident or estimated worker counts are below 600. In the NCHRP 08-79 validation phase, the actual ACS data was compared to the synthetic ACS in the protected environment at the Census Bureau. For a medium sized MPO in the test, the MPO's new TAZ system for their regional model has very small TAZs (on average only 300 residents per TAZ), and in CTPP2000, the average was 1000 per TAZ. Although the synthetic data performed as well as the actual ACS in model output runs, Westat found that the "ACS cell sample size will create data usability issues for transportation planners at fine levels of geography, e.g. TAZs, for cross-tabulations of key variables with means of transportation." So, you have a choice. For defining TAZs for CTPP, you can make larger TAZs than for your model and have less data perturbation, or you can make very small TAZs and have a lot of data perturbation. Elaine Murakami FHWA Office of Planning 206-220-4460

14 years, 5 months

RE: [CTPP] 2010 Data Release Watch

by David Reinke

Be careful applying IPF. Although it produces maximum-likelihood estimates of cell values, it can overestimate or underestimate when the intersecting row and column changes for a cell vary a lot from the mean change. I've observed this behavior when developing population synthesizers for sample-enumeration models. David Reinke Senior Transportation Engineer/Economist Dowling Associates, Inc. 180 Grand Avenue, Suite 250 Oakland, California 94612-3774 510.839.1742 x104 (voice) 510.839.0871 (fax) www.dowlinginc.com  Please consider the environment before printing this e-mail. Confidentiality Notice: This e-mail message, including any attachments, is for the sole use of the intended recipient(s), and may contain confidential and privileged information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message. -----Original Message----- From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan (DOT) Sent: Friday, March 11, 2011 11:42 AM To: ctpp-news(a)chrispy.net Subject: RE: [CTPP] 2010 Data Release Watch Noted below is a question and a response that appeared on the list serve earlier today and that suggests a solution method to creating data that almost exists but is needed. I am reposting this to the list serve, because I believe that this might be a worthwhile effort for someone who is adept and familiar with IPF to provide a valuable resources to the CTPP community in much the same way the ACS MOE spreadsheets have evolved to explain how to deal with this statistical concept in an easy to use way for the practitioner. Recently there was a post to the listserve by Jonnette Kreideweis about the Census Conference in California and the call for papers. There was also a recent post about the Planning Methods Conference. A spreadsheet that would answer the question posed is potentially a good basis for a paper. Further it helps share skills with the larger practitioner community based upon solutions and techniques that others have implemented. When presented and discussed on a listserve then many more people perhaps those who might never consider this as an option may now have a solution to the very same problem or may move on to adapt the method to other analysis areas. I want to encourage anyone who has the time to give it a try, maybe a student can use this to apply what they have learned, or a modeler can cannibalize something he/she has already used, many may benefit from you efforts. ---------------------------------------------------------- Nathan Erlbaum Associate Transportation Analyst Office of Policy, Planning & Performance New York State Department of Transportation 50 Wolf Road, 6th Floor Albany, New York 12232 (Tel) 518.457.2967 (Fax) 518.457.4944 (E-mail) nerlbaum(a)dot.state.ny.us (Web) www.nysdot.gov >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Marcus Wigan wrote: > ed > > a terribly simple question > > How best to do age group by gender by travel on the CTTP! > best > marc >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> Ed Christopher's response: Unfortunately, there is no clean way to get Age by Gender by Mode (Means of travel), that I know about, directly out of the current 3-year CTPP data product nor the Standard Census ACS products for that matter. However, there are some options that will get you close but they will take a little work. Option 1. In CTPP take table 12201 ( Age by Mode to work) and table 11203 (Age by Sex/gender)and run an IPF (Iterative Proportional Fitting-fratar) routine between the two tables to get what you want. At least I think it will work. Option 2. Do the same with standard ACS product tables B08006 (Sex by Mode) and B08101 (Mode by Age). If you go this route I think these tables may even exist in the 5-year ACS so you could do it at smaller than Places over 20K population geography. Option 3. Just make your table using the PUMS data but you would be limited to geographical areas of over 100K people. Over the years we has suggested that people use an IPF routine to make tables that might not exist in the various data products. I would be interested in hearing if anyone has actually done it. Have you?

14 years, 5 months

[CTPP] TAZ Delineation Webinar recording

by Weinberger

Hi All, In case you could not attend the TAZ Delineation Webinar, a recording of it, and all its supporting materials, has been posted to the CTPP TAZ page, along with an updated TAZ FAQ sheet. Please feel free to watch the webinar - it is likely of interest only to those users directly involved in TAZ delineation. The link to the page is: http://ctpp.transportation.org/Pages/taz.aspx 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.

14 years, 5 months

[CTPP] CENSUS DATA FOR TRANSPORTATION APPLICATIONS CONFERENCE -- CALL FOR PRESENTATIONS DUE MARCH 29

by Kreideweis

Planning is underway for the Using Census Data for Transportation Applications Conference, scheduled for October 25-27, 2011 at the Arnold and Mabel Beckman Center of the National Academies in Irvine, California. The conference is supported by the TRB, AASHTO, FHWA and FTA. The conference planning team is soliciting presentations for the conference, with abstracts (400 word max) due by March 29, 2011. Information on conference objectives and the process for submitting presentation proposals can be found at: http://onlinepubs.trb.org/onlinepubs/Conferences/2011/Census/Call_for_Prese… Key questions to be addressed at the conference include: * How are census data being used to support transportation planning, policy, and modeling activities and decision? * What are the challenges of using data from the ACS, CTPP and other census products for transportation planning? * How are transportation decision-making data needs changing for residence, workplace and journey-to-work flow data, and how do available public and private data sources best meet these needs? PRIORITY WILL BE GIVEN TO PUBLIC AGENCY AND STUDENT PRESENTATIONS. COMPLIMENTARY REGISTRATION AND LIMITED TRAVEL SUPPORT MAY BE AVAILABLE FOR PUBLIC AGENCY AND STUDENT PRESENTATIONS THAT ALIGN WITH CONFERENCE OBJECTIVES. Please feel free to share the call for presentations with others who may be interested in participating. We look forward to hearing from you on your experiences in using census data for transportation planning applications and on your current and future needs for these data. Thank you. Jonette Kreideweis Minnesota DOT Chair, TRB Conference Planning Task Force

14 years, 5 months

RE: [CTPP] Rules for 2010 Count Question Resolution Program

by Patty Becker

Paul -- well, at least they got counted somewhere! But yes, the geographic misassignments of GQ in 2000 were legion. Patty Becker At 12:26 PM 3/9/2011, you wrote: >Robert-- > >Sounds familiar, we discovered thousands of apparently homeless Michigan >State University students were actually residing in steam tunnels >underground beneath Spartan Stadium-- instead of their student housing >complexes, and probably for similar reasons. > >Admittedly, there have been reports of few drunken escapades in University >lore about those tunnels allegedly under the stadium-- but those events (if >true) typically weren't the kinds of things that would get reported to any >federal Bureau on Census day....... > >Paul T. Hamilton, >Chief Planner >Tri-County Regional Planning Commission >913. W. Holmes Rd. Ste. 201 >Lansing MI 48910 >phamilton(a)mitcrpc.org >Phone: 517.393.0342 >Fax: 517.393.4424 >web: www.mitcrpc.org >-----Original Message----- >From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] >On Behalf Of Allen, Robert. >Sent: Tuesday, March 08, 2011 3:01 PM >To: 'ctpp-news(a)chrispy.net' >Subject: RE: [CTPP] Rules for 2010 Count Question Resolution Program > > >This appears to be similar to the 2000 program. We had some significant >misassignments of data that affected census tracts and smaller units, in one >case in a monster fashion. (Someone at the Bureau made a manual change that >resulted in geocoding an entire prison population of over 4,000 into a tiny >empty block across the highway from the prison instead of the special tract >that had been created for it. One of the results was that we were reported >to have one of the ten highest population density blocks in the nation.) The >Census Bureau said that it would only make revisions if the misgeocoded >counts changed the totals for political jurisdictions and even those >revisions would not be included in any products that were produced in the >Census year, 2000, nor would those products be later revised. We have spent >the last ten years repeatedly explaining why some of our local data differed >from the official census counts and why our counts are actually correct. > >Robert R. Allen, AICP >Abilene MPO >400 Oak St. #102, Abilene, TX 79602 > >Phone 325-676-6243 >Fax 325-676-6398 > > > > >-----Original Message----- >From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] >On Behalf Of Ed Christopher >Sent: Tuesday, March 08, 2011 10:31 AM >To: ctpp-news(a)chrispy.net >Subject: Re: [CTPP] Rules for 2010 Count Question Resolution Program > >Wendell, here is what the rule says... It's sorta clear as mud. Maybe >someone can clarify. >----------------- >Challenges That Result in Corrections >The Census Bureau will issue corrected CQR counts based on the housing >unit and population counts as of April 1, 2010. The governmental units may >use new official census counts for all programs requiring official 2010 >Census data. The Census Bureau will not make corrections to the 2010 >population counts for individual housing units or GQs, or corrections to >the characteristics of the population and housing inventory. The Census >Bureau will modify the decennial file with the CQR corrections for use in >generating the 2012 postcensal estimates. The American FactFinder will >provide the inventory of corrections as errata to the original data. The >Census Bureau will not revise 2010 Census base files, 2010 Census >apportionment counts, redistricting data, or 2010 Census data products. >The Census Bureau will send a letter with a certification of the >population, housing and group quarters counts for all jurisdictions >affected by the results of a CQR challenge. >--------------------- >tinfo/ctpp-news > >_______________________________________________ >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 ------------------------------------------------------------------------------------------------- Patricia C. (Patty) Becker 248/354-6520 APB Associates/SEMCC FAX 248/354-6645 28300 Franklin Road Home 248/355-2428 Southfield, MI 48034 pbecker(a)umich.edu

14 years, 5 months

RE: [CTPP] RE: Problem Importing CA PL data

by Guy Rousseau

I agree with Nathan on the technical side of things. For this type of use and data applications, while directly connecting to the database can or cannot be done with the "Get External Data" functions in Excel or Access, via ODBC or similar database connection technology in a data analysis package such as Stata or R, it might be preferable to use a database management tool such as Microsoft SQL Server Management Studio. Indeed it is preferable and better to directly connect to the database through either a database management tool such as SQL Server Management Studio (Express), as compared to a data analysis package such as Excel, Access, Stata or R. If connecting through a data analysis package, the database is usually accessed by either setting up an ODBC Data Source (under Administrative tools under Control Panel) or on-the-fly via a connection string. For example, the ODBC connection string for the ARC database on our ARCTESTDATABASE server is: Driver={SQL Server}; Server= ARCTESTDATABASE; Database=ARC; Integrated Security=SSPI If using a .Net client to connect to the database, the connection string is slightly different: Data Source= ARCTESTDATABASE; Initial Catalog=ARC; Integrated Security=SSPI Once connected to the database, you can execute SQL statements against the database to perform custom analysis. Here are some Database Back-end references we use here for this type of work: * Microsoft SQL Server, http://www.microsoft.com/sqlserver * SQL Server Management Studio Express, http://msdn.microsoft.com/en-us/library/ms365247.aspx free as Nathan stated * T-SQL, http://msdn.microsoft.com/en-us/library/ms189826(v=sql.90).aspx * WebORB, http://www.themidnightcoders.com Thanks, Guy Guy Rousseau Surveys & Transportation Model Development Manager Atlanta Regional Commission 40 Courtland Street, NE Atlanta, GA 30303 404-463-3274 (work) 678-986-4344 (cell) grousseau(a)atlantaregional.com www.atlantaregional.com <http://www.atlantaregional.com> CONFIDENTIALITY NOTICE: This email message, including any attachments, is for the sole use of the intended recipient(s) and may contain confidential and privileged information. Any unauthorized review, use or disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender immediately and destroy all copies of the original message. From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan (DOT) Sent: Wednesday, March 09, 2011 12:29 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Problem Importing CA PL data >From a database size issue on solution might be for you to try SQL server express ( http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBwQFjAA&url=http%3A %2F%2Fwww.microsoft.com%2Fexpress%2FDatabase%2F&ei=KLd3Tc36HoKE0QHxtf3fB g&usg=AFQjCNHjeaYABXz3Vpzmoqyz_kqbTWCfuA ) it may be a chore, but it is free and you can spend endless hours loving Microsoft. It will let you get the files in, since the size limit is MS Access is not the issue and then you can access them by MS access. It may be a steep learning curve for you but it is another option and it works because its free. Your other option is SAS or SPSS or maybe R or simply wait until someone else does it for you. In any event what we have here a situation where the total lack of serious though leadership on the part of the Census Bureau would have resolved hundreds of hours of efforts on the part of many to do what the CB could have provided for in advance. But then what can we expect, they're from the government and they're here to help you, I believe that is how the expression goes....... From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Anais Schenk Sent: Wednesday, March 09, 2011 12:06 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Problem Importing CA PL data Thank you Robert. It turns out the files are massive and that appears to be the problem. No matter which order I import in, Access can't import the third file. I've adopted your method and I've created two Access databases, one for the first PL data table and another for the second table. I was able to import the geo table into both and can query the data for our region's counties for use in GIS. Thank you for saving me from a lot more frustration. Anais Schenk | Planner | AMBAG Direct 831.264.5088 | Fax 831.883.3755 ________________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Allen, Robert. Sent: Wednesday, March 09, 2011 7:00 AM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] RE: Problem Importing CA PL data What size files are getting in Access when you try to import the files? In Texas, the files were too big to import all three at once into Access. Access has a code limited total data file size of 2 GB. I could import two of the files in any sequence and Access would always choke on the third, saying that the file was unrecognized or corrupt, but the actual problem was that the 2 GB limitation was being exceeded. Using a 64-bit version did not help as the 2 GB is a Microsoft Access program code limit, not a computing power limit. I finally had to hook the geoheaders up to the two data files in two steps, then cut down the resulting databases into substate areas that could be handled within the coding limitations of Access and Excel before hooking the data up to the census geography files in our GIS system. Robert R. Allen, AICP Abilene MPO 400 Oak St. #102, Abilene, TX 79602 Phone 325-676-6243 Fax 325-676-6398 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Anais Schenk Sent: Tuesday, March 08, 2011 5:54 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Problem Importing CA PL data Has anyone else had a problem importing the "cageo2010" file into Access 2003? I keep getting an error message saying that access doesn't recognize or find the database. I followed the instructions in the "0File_Structure" pdf exactly. I got the other two tables imported just fine, but can't seem to get the geo table. Anais Schenk | Planner Direct 831.264.5088 | Fax 831.883.3755

14 years, 5 months

[CTPP] RE: Problem Importing CA PL data

by Anais Schenk

Thanks for the tip. I'll check it out next time I have an issue. For the moment my problem has been resolved by creating the two separate databases. Free is good. We are a small agency and can not justify the expense of SAS software at the moment. Anais Schenk | Planner | AMBAG Direct 831.264.5088 | Fax 831.883.3755 <http://www.commutealternatives.info> ________________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Erlbaum, Nathan (DOT) Sent: Wednesday, March 09, 2011 9:29 AM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Problem Importing CA PL data >From a database size issue on solution might be for you to try SQL server express ( http://www.google.com/url?sa=t&source=web&cd=1&ved=0CBwQFjAA&url=http%3A%2F… ) it may be a chore, but it is free and you can spend endless hours loving Microsoft. It will let you get the files in, since the size limit is MS Access is not the issue and then you can access them by MS access. It may be a steep learning curve for you but it is another option and it works because its free. Your other option is SAS or SPSS or maybe R or simply wait until someone else does it for you. In any event what we have here a situation where the total lack of serious though leadership on the part of the Census Bureau would have resolved hundreds of hours of efforts on the part of many to do what the CB could have provided for in advance. But then what can we expect, they're from the government and they're here to help you, I believe that is how the expression goes....... From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Anais Schenk Sent: Wednesday, March 09, 2011 12:06 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] RE: Problem Importing CA PL data Thank you Robert. It turns out the files are massive and that appears to be the problem. No matter which order I import in, Access can't import the third file. I've adopted your method and I've created two Access databases, one for the first PL data table and another for the second table. I was able to import the geo table into both and can query the data for our region's counties for use in GIS. Thank you for saving me from a lot more frustration. Anais Schenk | Planner | AMBAG Direct 831.264.5088 | Fax 831.883.3755 ________________________________ From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Allen, Robert. Sent: Wednesday, March 09, 2011 7:00 AM To: 'ctpp-news(a)chrispy.net' Subject: [CTPP] RE: Problem Importing CA PL data What size files are getting in Access when you try to import the files? In Texas, the files were too big to import all three at once into Access. Access has a code limited total data file size of 2 GB. I could import two of the files in any sequence and Access would always choke on the third, saying that the file was unrecognized or corrupt, but the actual problem was that the 2 GB limitation was being exceeded. Using a 64-bit version did not help as the 2 GB is a Microsoft Access program code limit, not a computing power limit. I finally had to hook the geoheaders up to the two data files in two steps, then cut down the resulting databases into substate areas that could be handled within the coding limitations of Access and Excel before hooking the data up to the census geography files in our GIS system. Robert R. Allen, AICP Abilene MPO 400 Oak St. #102, Abilene, TX 79602 Phone 325-676-6243 Fax 325-676-6398 From: ctpp-news-bounces(a)chrispy.net [mailto:ctpp-news-bounces(a)chrispy.net] On Behalf Of Anais Schenk Sent: Tuesday, March 08, 2011 5:54 PM To: ctpp-news(a)chrispy.net Subject: [CTPP] Problem Importing CA PL data Has anyone else had a problem importing the "cageo2010" file into Access 2003? I keep getting an error message saying that access doesn't recognize or find the database. I followed the instructions in the "0File_Structure" pdf exactly. I got the other two tables imported just fine, but can't seem to get the geo table. Anais Schenk | Planner Direct 831.264.5088 | Fax 831.883.3755 [cid:image001.jpg(a)01CBDE41.59B33B70]

14 years, 5 months

Jump to page:

2025

2024

2023

2022

2021

2020

2019

2018

2017

2016

2015

2014

2013

2012

2011

2010

2009

2008

2007

2006

2005

2004

2003

2002

2001

2000

1999

1998

CTPP