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 Addresses > Property Features
Product
Property Attributes Assessment
Version
Latest
Language
English
Product name
Property Attributes Assessment
Title
Property Attributes Assessment Getting Started Guide
Copyright
2024
First publish date
2020
Last updated
2024-04-29
Published on
2024-04-29T04:26:07.269000
  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 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 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'
The following syntax should be used to load nationwide data:
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;
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;