Re: [CTPP] RE: TAZ Level Data from 2010 Census

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. >> >> >>