PCPA_FTP_DATA_HELP

General Use Instructions

Delimited Files

The appraisal data files are comma quote delimited files.  Comma quote delimited files are data files, in which a program separates the data items (or fields) by commas and qualifies the text of each data item with quotes. Delimited files are used to facilitate the transfer of data to another program.   

       1. The first row of data is usually read as column headings or field names.  

       2. The delimiters are not considered part of the field data.  The are used by the import program to determine where a field begins and ends.  

       3. Text qualifiers are used when the delimiter (comma) could appear within the field data.  

       4. A line character (crlf) indicates a new row.


You can import these files into many different types of applications, such as Microsoft Excel 2007 or newer (older versions only import the first 65,000 rows), Microsoft Access, Microsoft SQL Server, ArcMap, etc.  Providing import instructions for all of the various applications is beyond the scope of this help file.  Please consult the documentation of your application for import instructions.


NOTE:  If you import the text file into excel, change the Parcel_ID column from General to Text.  IF this column data format change is not made the Parcel_ID column will not import correctly.


Excel Text Import Wizard

Excel Wizard Image


Software

Delimited files are very versatile and can be imported into many different applications, such as Microsoft Excel 2007 or newer (older versions only import the first 65,000 rows), Microsoft Access, Microsoft SQL Server, ArcCatalog, ArcMap, etc.  Microsoft Excel offers a free viewer application that can be used to view/import the appraisal data files.  


Download

The Appraisal Data is located: ftp://ftp.polkpa.org/AppraisalData/


Right click on the file you want to download, Choose Save Target As to save the file to your computer's hard drive. Keep the original file name. You will have to choose the directory where you want to save the file. 


Unzip

You will need a zip program to extract the zip files. You can find the software at the web links below. 

www.winzip.com or www.stuffit.com