2. Published Data

The information below describes the data model for NZ River Name Lines & Polygons (pilot) for distribution to the public.

2.1. Data Model

To assist you in understanding these datasets, the structure and details of the data fields is described in tables below.

Primary keys in tables are shown by a field name with bold font.

2.2. Schema: rivers_lds

Description: Schema that holds rivers data to publish on the LDS.

2.2.1. Table: nz_river_name_lines

Description: The nz_river_name_lines table holds geometries copied from Topo50 canal_cl drain_cl and river_cl. It includes name attributes based on Topo50 maps.

Column Name	Data Type	Length	Precision	Scale	Allows Nulls	Description
river_section_id	integer	32			No	Unique identifier for each geometry.
feat_type	varchar	30			No	Topo50 feature type where the geometry originates from: canal_cl drain_cl or river_cl.
name_ascii	varchar	80			No	The non-macronated version of the name.
macronated	varchar	1			No	Whether the name contains a macronated letter.
name	varchar	80			No	The name based on Topo50 maps.
shape	geometry				Yes	The geometry of the feature.

2.2.2. Table: nz_river_name_polygons

Description: The nz_river_name_polygons table holds geometries copied from Topo50 canal_poly and river_poly. It includes name attributes based on Topo50 maps.

Column Name	Data Type	Length	Precision	Scale	Allows Nulls	Description
river_section_id	integer	32			No	Unique identifier for each geometry.
feat_type	varchar	30			No	Topo50 feature type where the geometry originates from: canal_poly or river_poly.
name_ascii	varchar	80			No	The non-macronated version of the name.
macronated	varchar	1			No	Whether the name contains a macronated letter.
name	varchar	80			No	The name based on Topo50 maps.
shape	geometry				Yes	The geometry of the feature.