Loading Property Attributes Assessment change log data - property_attributes_assessment - Latest

Property Attributes Assessment Getting Started Guide
Product type
Data
Portfolio
Enrich
Product family
Enrich Properties > Property Features
Product
Property Attributes Assessment
Version
Latest
ft:locale
en-US
Product name
Property Attributes Assessment
ft:title
Property Attributes Assessment Getting Started Guide
Copyright
2025
First publish date
2020
ft:lastEdition
2026-07-07
ft:lastPublication
2026-07-07T07:25:55.136000
L1_Product_Gateway
Enrich
L2_Product_Segment
Data
L3_Product_Brand
Precisely Properties
L4_Investment_Segment
Precisely Addresses
L5_Product_Group
Property Features
L6_Product_Name
Property Attributes
  1. Download the product delivery file.
  2. Extract the delivery file to find the text data file.
  3. Create the table structure in the database using the Create Table script. Be sure to change the table name in the template to asmt_change_log.
  4. Once the table structure has been created, copy the following command to:

    1. Load the sample and state datafiles:

      copy <table_name> from '<path_to_text_file>\<text_file_name.txt>'delimiter'|'csv quote e'\b';
      Example – Linux: 
      copy asmt from
'F:\Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
property_attributes_assessment_changelog_usa.txt' delimiter '|' csv quote e'\b
      Example – Windows: 
      copy asmt_change_log from 'F:\Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
property_attributes_assessment_changelog_usa.txt' delimiter '|' csv quote e'\b'
    2. Load nationwide datafiles (to skip first record as it is a header/column record): 
      copy <table_name> from '<path_to_text_file>\<text_file_name.txt>'delimiter'|'csv quote e'\b' header;
      Example – Linux:
      copy asmt_change_log from
'/mnr/Property_Attributes_Assessment/Property_Attributes_Assessment_Data/
property_attributes_assessment_changelog_usa.txt' delimiter '|' csv quote e'\b' header;
      Example – Windows: 
      copy asmt_change_log from 'F:\
Property_Attributes_Assessment\Property_Attributes_Assessment_Data\
property_attributes_assessment_changelog_usa.txt' delimiter '|' csv quote e'\b' header;
      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