AddressBase and AddressBase Plus data

Open Cadcorp SIS Address Loader; this will be your welcome screen.

1. Select the folder containing the AddressBase or AddressBase Plus zipped (or unzipped) csv files.
2. Select the folder to hold the log file and any unzipped data.
3. Click Next.

Opt to load all address files or just a select few.

Data Model shows AddressBase or AddressBase Plus as appropriate.

The term Non geographic chunks or Geographic chunks (Tiles) will be displayed according to the type of data to be loaded.

• Non-geographically chunked data does not have any reference to the geographic position of records.
• For geographically chunked data the data files contain records in a 5km square. This is likely to result in there being a larger number of files than non-geographically chunked data. With geographically chunked data, the tables have to also store the tile name in every record to allow for tile replacement.

Click Next to select a database.

Note: The following screens relate to a PostGIS database.

Click Next and enter the relevant connection details.

Transaction Size: This is the number of records which are written to the database at a time. In the above example, 10,000 records are read by the loader before writing them to the database. You wouldn’t normally need to change this except for poor networks or where the database server is low on memory.

TIP: When connecting to a Microsoft SQL Server database, you can also opt for a SQL Bulk Copy (initial supply only)

Click Next to select the relevant database tables.

Either select an existing table or enter the name of a new table to be created.

Check tickboxes for the required options as shown:

• Drop and rebuild indexes
• Create a gazetteer view (if this option is enabled, the text box becomes active and allows you to enter the gazetteer name).
• Truncate the table before loading commences.

Click Next. You will see a Load the data window:

Click Start to begin loading data. You will see a progress bar during load.

---