Property Attributes Assessment data consists of a pipe-delimited text file (property_attributes_assessment.txt) and a header file (property_attributes_assessment_header.txt) to give users flexibility in managing tables and schemas in various database technologies.
Before Property Attributes Assessment can be loaded into MapInfo Pro (versions 15.0 and later), the data file must be associated with the header file):
- Open the MapBasic window in MapInfo Pro by clicking Home >
Tool Windows > MapBasic
- Download this script which will be used to create the table structure.
- Edit the script, changing the table name in the template to a recognizable name,
such as prop_asmt_data_with_header. Be sure to change all instances of
the output path for the TAB file and table name –
- Copy the complete template text and paste it into the MapBasic window.
- Select all text in the MapBasic window and press Enter. This will create a table containing only headers.
- In MapInfo Pro, click Home > Open > Table
- Set the value of Files of type: to Delimited ASCII (*.txt)
- Select the data text file (property_attributes_assessment.txt) and click Open
- Set the following parameters in the Delimited ASCII Information dialog –
- Select Other as the delimiter type and enter a pipe character ( | ) as the delimiter option
- Set the value of File Character Set: to Unicode UTF-8
- Leave the Use First Line for Column Titles option unchecked unless you are loading the nationwide file
- Click OK
- The table will open without headers
- Append the data table to the blank header row table –
- Click Table > Append Rows
- Select the name of the data table from the Append Table dropdown
- Select the name of the header table from the to Table: dropdown
- Click OK
- Save the file once the append operation finishes. Data is now ready for use.