Loading Property Historical Sales Data - property_historical_sales - Latest

Property Historical Sales Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Property Historical Sales
Version
Latest
ft:locale
en-US
Product name
Property Historical Sales
ft:title
Property Historical Sales Getting Started Guide
Copyright
2023
First publish date
2020
ft:lastEdition
2025-09-29
ft:lastPublication
2025-09-29T14:56:42.605000
  1. Download the product delivery file.
  2. Extract the delivery file to find the data text file.
  3. Open the Property Historical Sales Create Table script in a text editor and confirm that the table name is set to prop_hist_sales.
  4. Run the Create Table script.
  5. After the table structure has been created, copy data using the PostgreSQL Copy command: 
    copy <table_name> from '<path_to_text_file>\<text_file_name.txt>' delimiter '|' csv quote e'\b';
    Syntax:

    <table_name>: Name of table created using Create Table script

    <path_to_text_file>: Path to extracted data text file

    <text_file_name.txt>: Extracted data text file name, including file extension

    delimiter: Defines the text delimiter (in this case, the pipe character)

    csv quote e'/b': Specifies quoting

    Example – Linux: 
    copy prop_hist_sales from '/mnr/nationwide/Property_Historical_Sales/
Historical_Sales_Product_Data/property_historical_sales_usa.txt' delimiter '|' csv quote e'\b';
    Example – Windows: 
    copy prop_hist_sales from 'F:\Property_Historical_Sales_202006\
Historical_Sales_Product_Data\property_historical_sales_usa.txt' delimiter '|' csv quote e'\b';
    The following syntax should be used to load nationwide data:

    Linux:

    copy asmt from'/mnr/Property_Historical_Sales/
Property_Historical_Sales_Data/property_historical_sales_usa.txt
' delimiter '|' csv quote e'\b'header;
    Windows:
    copy asmt from 'F:\
Property_Historical_Sales\Property_Historical_Sales_Data\
property_historical_sales_usa.txt' delimiter '|' csv quote e'\b'
header