I had a similar problem. 

When you rename the files make sure that you can see the pl extension, otherwise Windows will name it scgeo2010.csv.pl.  Access also seems to prefer .txt to .csv. 

Dan Estersohn
Arbitron Inc.


-----Original Message-----
From: ctpp-news-bounces@chrispy.net on behalf of Harun Rashid
Sent: Mon 3/21/2011 3:33 PM
To: ctpp-news@chrispy.net
Subject: [CTPP] RE: how to use Census Redistricting Summary Files in Access
 
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@chrispy.net [ mailto:ctpp-news-bounces@chrispy.net] On Behalf Of ctpp-news-request@chrispy.net
Sent: Friday, February 18, 2011 10:02 AM
To: ctpp-news@chrispy.net
Subject: ctpp-news Digest, Vol 84, Issue 24

Send ctpp-news mailing list submissions to
        ctpp-news@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@chrispy.net

You can reach the person managing the list at
        ctpp-news-owner@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" <mkaminowitz@baltometro.org>
Subject: [CTPP] How to use the Census Redistricting Summary File in
        Access
To: <ctpp-news@chrispy.net>
Message-ID: <E7C1057941BA4C6AB416BCA0737364B2@bmc.net>
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@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.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ryoko.chrispy.net/pipermail/ctpp-news/attachments/20110218/cfd3c26d/attachment-0001.html

------------------------------

Message: 2
Date: Fri, 18 Feb 2011 08:50:50 -0600
From: Ed Christopher <edc@berwyned.com>
Subject: Re: [CTPP] How to use the Census Redistricting Summary File
        in Access
To: ctpp-news@chrispy.net
Message-ID: <4D5E874A.7030902@berwyned.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed

Mara--Thanks for taking the time and putting this post together.

Mara Kaminowitz wrote:
> 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@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.
>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news@chrispy.net
> http://www.chrispy.net/mailman/listinfo/ctpp-news

--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)

FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL  60443



------------------------------

Message: 3
Date: Fri, 18 Feb 2011 08:54:19 -0600
From: Ed Christopher <edc@berwyned.com>
Subject: Re: [CTPP] 2010 Population Data Release
To: ctpp-news@chrispy.net
Message-ID: <4D5E881B.5020507@berwyned.com>
Content-Type: text/plain; charset=windows-1252; format=flowed

Wendell et al,  I wrote to the CB public information people and this is
what I got back on the timing of the states.  I guess we will just have
to watch on a week by week basis unless someone knows something about
all the states redistricting laws and timelines.

-------------------
The P.L. data (redistricting data) will be released between Feb. and
Mar. 31, 2011 on a state flow basis. We don?t have a schedule of when
each state will be finalized and released, but it?s prioritized based on
how quickly state laws require the redistricting to be completed.

Public Information Office
U.S. Census Bureau
--------------------
wendell cox wrote:
> Ed... Do we have any idea when my favorites come out (Calif and NY). Thank
> you.
>
> Best,
> Wendell
>
> On Fri, Feb 18, 2011 at 11:48 AM, Ed Christopher <edc@berwyned.com> wrote:
>
>> Next week the Census Bureau will release local 2010 Census Data
>> for Alabama, Colorado, Hawaii, Missouri, Nevada, Oregon,
>> Utah and Washington.
>>
>> To see a list of states of that are out and to follow future releases go to
>> http://2010.census.gov/news/press-kits/redistricting.html
>> --
>> Ed Christopher
>> 708-283-3534 (V)
>> 708-574-8131 (cell)
>>
>> FHWA RC-TST-PLN
>> 4749 Lincoln Mall Drive, Suite 600
>> Matteson, IL  60443
>>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news@chrispy.net
>> http://www.chrispy.net/mailman/listinfo/ctpp-news
>>
>
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news@chrispy.net
> http://www.chrispy.net/mailman/listinfo/ctpp-news

--
Ed Christopher
708-283-3534 (V)
708-574-8131 (cell)

FHWA RC-TST-PLN
4749 Lincoln Mall Drive, Suite 600
Matteson, IL  60443



------------------------------

Message: 4
Date: Fri, 18 Feb 2011 15:01:12 +0000
From: wendell cox <demographia@gmail.com>
Subject: Re: [CTPP] 2010 Population Data Release
To: ctpp-news@chrispy.net
Message-ID:
        <AANLkTintKiXjWMBuGP+SkA-C7dNpaAGtAN+s=m8Gub=V@mail.gmail.com>
Content-Type: text/plain; charset="windows-1252"

Possible to get the list of state law deadlines they are working with? That
would at least give us an idea of the priority.

On Fri, Feb 18, 2011 at 2:54 PM, Ed Christopher <edc@berwyned.com> wrote:

> Wendell et al,  I wrote to the CB public information people and this is
> what I got back on the timing of the states.  I guess we will just have to
> watch on a week by week basis unless someone knows something about all the
> states redistricting laws and timelines.
>
> -------------------
> The P.L. data (redistricting data) will be released between Feb. and Mar.
> 31, 2011 on a state flow basis. We don?t have a schedule of when each state
> will be finalized and released, but it?s prioritized based on how quickly
> state laws require the redistricting to be completed.
>
> Public Information Office
> U.S. Census Bureau
> --------------------
> wendell cox wrote:
>
>> Ed... Do we have any idea when my favorites come out (Calif and NY). Thank
>> you.
>>
>> Best,
>> Wendell
>>
>> On Fri, Feb 18, 2011 at 11:48 AM, Ed Christopher <edc@berwyned.com>
>> wrote:
>>
>>  Next week the Census Bureau will release local 2010 Census Data
>>> for Alabama, Colorado, Hawaii, Missouri, Nevada, Oregon,
>>> Utah and Washington.
>>>
>>> To see a list of states of that are out and to follow future releases go
>>> to
>>> http://2010.census.gov/news/press-kits/redistricting.html
>>> --
>>> Ed Christopher
>>> 708-283-3534 (V)
>>> 708-574-8131 (cell)
>>>
>>> FHWA RC-TST-PLN
>>> 4749 Lincoln Mall Drive, Suite 600
>>> Matteson, IL  60443
>>>
>>> _______________________________________________
>>> ctpp-news mailing list
>>> ctpp-news@chrispy.net
>>> http://www.chrispy.net/mailman/listinfo/ctpp-news
>>>
>>>
>>
>>
>>
>> ------------------------------------------------------------------------
>>
>>
>> _______________________________________________
>> ctpp-news mailing list
>> ctpp-news@chrispy.net
>> http://www.chrispy.net/mailman/listinfo/ctpp-news
>>
>
> --
> Ed Christopher
> 708-283-3534 (V)
> 708-574-8131 (cell)
>
> FHWA RC-TST-PLN
> 4749 Lincoln Mall Drive, Suite 600
> Matteson, IL  60443
>
> _______________________________________________
> ctpp-news mailing list
> ctpp-news@chrispy.net
> http://www.chrispy.net/mailman/listinfo/ctpp-news
>



--
--
Wendell Cox
Demographia | Wendell Cox Consultancy - St. Louis Missouri-Illinois
metropolitan region

Visiting Professor, Conservatoire National des Arts et Metiers, Paris
+1.618 632 8507

www.demographia.com | www.publicpurpose.com | www.rentalcartours.net

Books & Publications
WAR ON THE DREAM: How Anti-Sprawl Policy Threatens the Quality of Life
http://www.demographia.com/wod1.pdf


7th ANNUAL DEMOGRAPHIA INTERNATIONAL HOUSING AFFORDABILITY SURVEY (
http://www.demographia.com/dhi.pdf)

THE WAL-MART REVOLUTION: How Big-Box Stores Benefit Consumers, Workers, and
the Economy
By Richard Vedder & Wendell Cox
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://ryoko.chrispy.net/pipermail/ctpp-news/attachments/20110218/0ea738ee/attachment.html

------------------------------

_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news


End of ctpp-news Digest, Vol 84, Issue 24
*****************************************

_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news

______________________________________________________________________
This e-mail has been scanned by Arbitron's Email Content Service.
______________________________________________________________________



_______________________________________________
ctpp-news mailing list
ctpp-news@chrispy.net
http://www.chrispy.net/mailman/listinfo/ctpp-news