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
2025-12-24
ft:lastPublication
2025-12-24T08:35:24.668000
  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