Hello: there are three files in the release of data in Louisiana.
I parsed the file you are having trouble with the newest version of XL. But here is a tip that you might have not known.
I had trouble unzipping the data files (PL1, PL2) and (PL3, PL4) and the geo code file. Pl files were comma delimited files. The geocode file was space deliminted. I had to unzip the files on a linux machine because when I unzipped them on a windows machine, the end of record code was not seen. The instructions I received in Louisiana said that they were complied on a linux machine and I had to add a character to unjumble the data if I unzipped on a Window machine.
I quote the readme file:
Once the package is unzipped, the files are in flat ASCII format. The geographic header file contains fixed fields while the data files are in comma-delimited format. Both the geographic header and the data files contain geographic linking fields. These files have been constructed in a LINUX environment. They use an ASCII linefeed, chr(10), to indicate a new record.
For successful use with many programs running in a Windows environment, these files need to be modified to use the ASCII carriage return/linefeed sequence, chr(13) + chr(10) as a record terminator. This is an easy step in the UnZIP process using any UnZIP software which offers the conversion option. Winzip for Windows, version 14.5 has been tested.
The resulting file will meet the ANSI MS-DOS/Windows standard used by Access 2000 and Access 2007 and other MS Windows-based programs. If the data are being processed in a LINUX environment, they can be unzipped using any standard Linux ZIP/UnZIP package.
Mike LeBlanc, 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
From: ctpp-news-bounces@chrispy.net [mailto:ctpp-news-bounces@chrispy.net] On Behalf Of Anais Schenk
Sent: Tuesday, March 08, 2011 5:54 PM
To: ctpp-news@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
