LINZ LDS BDE Schemas

Provides the schemas and functions to generate the layers and tables that are available on the LDS:

• Simplified Property Ownership and Boundaries (lds.*): https://data.linz.govt.nz/data/category/property-ownership-boundaries/
• Simplified Geodetic (lds.geodetic_*): https://data.linz.govt.nz/data/category/geodetic/
• Full Landonline Dataset (aka bde_ext): https://data.linz.govt.nz/data/category/full-landonline-dataset/

Installation

First install the project into the OS data share directory:

sudo make install

Then in each target database you need to install the linz-bde-schema project.

Then you can load the schema into a target database

linz-lds-bde-schema-load $DB_NAME

NOTE: the loader script will expect to find SQL scripts under /usr/share/linz-lds-bde-schema/sql, if you want them found in a different directory you can set the LDSBDESCHEMA_SQLDIR environment variable.

Upgrade

You can upgrade the schema in an existing database by following the install procedure. The linz-lds-bde-schema-load script is able to both install or upgrade databases.

Testing

Testing is done using pg_regress and PgTap. To run the tests run the following command:

make check

Building Documentation

PDF documentation can be built using:

make docs

NOTE: if you get an error about connecting to X it is due to wkhtmltopdf having a dependency on a running X server. You can work around that by installing xvfb and using:

xvfb-run make docs

Dependencies

Usage requires:

• linz-bde-schema
• table_version
• dbpatch
• linz_bde_uploader

Documentation building requires:

• GNU Sed
• python
• pandoc
• wkhtmltopdf

Testing requires:

• pgtap
• ability to create a PostgreSQL databases

License

This project is under 3-clause BSD License, except where otherwise specified. See the LICENSE file for more details.