Thanks for the response ed! On Mon, Mar 21, 2011 at 7:40 PM, Ed Christopher &lt;edc(a)berwyned.com&gt; wrote: > the census bureau does not publish data by TAZ.  You can only get it from > the CTPP and that will not be out until sometime in 2013. Until then only > 2000 data is available by TAZ. > >> Hello All, >> How can I get TZA level data from the new Census Website? Any help >> would be much appreciated. Thanks! >> >> >> >> On Mon, Mar 21, 2011 at 3:33 PM, Harun Rashid &lt;hrashid(a)bcdcog.com&gt; wrote: >>> In following Mara Kaminowitz's work steps, I'm stuck with instructions >>> in the Census document - '0FILE_STRUCTURE'. I am referring to page 2, >>> instructions under 'For Access Users' - >>> a. using Access 2007 in Windows XP >>> b. Step 3 of Part 1 says 'Unzip the PL files you wish to load into >>> Access and rename the file extension to csv' - after extracting with >>> WinZip, I simply renamed these files to add .csv at end. File types >>> remain 'PL file', as shown in Windows explorer >>> c. Instructions in Part 2 seem to prepared for 2003 versions. When I try >>> to follow similar steps in 2007, the files renamed in previous step are >>> not recognized >>> >>> Any help will be appreciated. >>> >>> Harun >>> >>> Harun Rashid, AICP >>> Senior GIS Planner >>> BCD Council of Governments >>> 1362 McMillan Avenue, Suite 100 >>> North Charleston, SC 29405 >>> >>> T: 843.529.0400 >>> F: 843.529.0305 >>> >>> www.bcdcog.org >>> >>> -----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 18, 2011 10:02 AM >>> To: ctpp-news(a)chrispy.net >>> Subject: ctpp-news Digest, Vol 84, Issue 24 >>> >>> 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. How to use the Census Redistricting Summary File in Access >>>      (Mara Kaminowitz) >>>   2. Re: How to use the Census Redistricting Summary File in >>>      Access (Ed Christopher) >>>   3. Re: 2010 Population Data Release (Ed Christopher) >>>   4. Re: 2010 Population Data Release (wendell cox) >>> >>> >>> ---------------------------------------------------------------------- >>> >>> Message: 1 >>> Date: Fri, 18 Feb 2011 09:06:31 -0500 >>> From: "Mara Kaminowitz" &lt;mkaminowitz(a)baltometro.org&gt; >>> Subject: [CTPP] How to use the Census Redistricting Summary File in >>>        Access >>> To: &lt;ctpp-news(a)chrispy.net&gt; >>> Message-ID: &lt;E7C1057941BA4C6AB416BCA0737364B2(a)bmc.net&gt; >>> Content-Type: text/plain; charset="us-ascii" >>> >>> Since I have seen a lot questions about this I thought I would post my >>> personal notes. If your state hasn't come out yet I strongly suggest >>> downloading a different state and practicing. Once you get the method >>> down, >>> it will be easy to repeat. >>> >>> These instructions are for Access 2003 but I think they are similar for >>> Access 2007. >>> >>> You will need the following documents. Download them to your computer >>> and >>> keep them close at all times. >>> >>> 0FILE_STRUCTURE.pdf  found at >>> http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0FILE_ST >>> RUCTURE.pdf >>> >>> 0GEOID_Construction_for_Matching.pdf  found at >>> http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/0GEOID_C >>> onstruction_for_Matching.pdf >>> >>> pl94-171_tech_doc.pdf found at >>> http://www.census.gov/prod/cen2010/doc/pl94-171.pdf >>> >>> 1. Go to >>> http://www2.census.gov/census_2010/01-Redistricting_File--PL_94-171/ and >>> download the access document that matches your MS Access version, either >>> PL2010_Access.accdb or PL2010_Access2003.mdb. >>> >>> 2. In the same directory, go to the folder your state is in and download >>> everything in the folder. >>> >>> 3. Unzip the files. >>> >>> 4. Open the PDF called 0FILE_STRUCTURE.pdf. Read the first page, it has >>> useful information. The go to the section marked "For Access Users" on >>> page >>> 2. FOLLOW THESE INSTRUCTIONS EXACTLY. >>> >>> 5. After the tables are imported into Access, you should have the two >>> data >>> tables and the geography table automatically joined by the LOGRECNO >>> field. >>> >From here, you can use queries to extract tables on a single geography >>> and >>> on the topics of your choice. Start a new query in design view. I >>> recommend >>> starting all queries by adding the entire geography table until you get >>> a >>> feel for which fields you don't need. >>> >>> 6. SUMLEV is the field that will let you extract a particular geography, >>> such as tracts or counties. You can find a full listing of SUMLEVs under >>> Chapter 4 of pl94-171_tech_doc.pdf. So if you want a table that has all >>> the >>> census tracts in your state, type "140" under the Criteria field of the >>> SUMLEV column in your query design. >>> >>> 7. The other two tables list your data fields. The table names are given >>> in >>> the back of 0FILE_STRUCTURE.pdf. >>> >>> 8. Export the query to the format of your choice - Excel, dbf, txt, ect. >>> Note that only the newest Excel program will handle more than 65,000 >>> columns. >>> >>> 9. If you are using the data in GIS, you will need to construct a GEOID >>> field to match the one in the shapefile. The file >>> 0GEOID_Construction_for_Matching.pdf provides formulas for doing this. >>> Concatenate the fields found in the geography half of your exported >>> table >>> into a GEOID field. >>> >>> 10. Analyze! Analyze! Analyze! >>> >>> TIP: Compare the number of records in your shapefile with the numbers of >>> records in your exported table to make sure the table was extracted >>> correctly. >>> >>> Hopefully these steps make things less confusing, not more. Good luck! >>> >>> Mara >>> >>> >>> >>> >>> Mara Kaminowitz >>> GIS Analyst >>> ......................................................................... >>> Baltimore Metropolitan Council >>> Offices at McHenry Row >>> 1500 Whetstone Way >>> Suite 300 >>> Baltimore, MD  21230 >>> 410-732-0500 ext. 1030 >>>  <mailto:mkaminowitz@baltometro.org> mkaminowitz(a)baltometro.org >>>  <http://www.baltometro.org/> www.baltometro.org >>> >>> >>>  _____ >>> >>> Confidentiality Statement >>> >>> This message may contain legally privileged and confidential information >>> that is intended only for the use of the recipient(s) named above. If >>> you >>> are not an intended recipient, taking any action based on the contents >>> of >>> this message is strictly prohibited. Please immediately notify the >>> sender if >>> you have received this message in error. >>> >>> >>>