2. Published Data

The data described below represents aerial surveys data openly available on the LINZ Data Service:

2.1. Schema: aerial_lds

Description: This schema contains datasets related to aerial surveys to be published on the LINZ Data Service.

2.1.1. Table: nz_imagery_survey_index

Description: This table holds the standardised attributes of aerial imagery surveys. These attributes were previously only contained within individual index tile layers with differing column names and data types.

Column Name Data Type Length Precision Scale Allows Nulls Description
imagery_survey_id integer 32     Yes Unique identifier for the aerial_lds.nz_imagery_survey_index table.
name varchar 100     No The corresponding aerial imagery layer name in the LINZ Data Service.
imagery_id integer 32     Yes Foreign key to the aerial imagery layer identifier in the LINZ Data Service.
index_id integer 32     Yes Foreign key to the index tile layer identifier in the LINZ Data Service.
set_order integer 32     Yes The order that an aerial photograph displays within the NZ Aerial Imageryset. A null value indicates that the aerial photograph is not part of the set.
ground_sample_distance numeric   6 4 Yes Ground sample distance in metres.
accuracy varchar 100     Yes The overall accuracy of the imagery survey. This may contain aggregated accuracy values if accuracy varied throughout the survey. Refer to the related index tile layer for specific accuracies.
supplier varchar 80     Yes The organisation that supplied the aerial imagery.
licensor varchar 250     Yes The organisation that licenses the aerial imagery.
flown_from date       Yes The earliest date on which aerial photographs were taken as part of this imagery survey.
flown_to date       Yes The latest date on which aerial photographs were taken as part of this imagery survey.
shape geometry       Yes A dissolved multipart boundary of the coverage of the imagery survey.

2.1.2. Table: nz_elevation_survey_index

Description: This table holds the standardised attributes of aerial elevation surveys.

Column Name Data Type Length Precision Scale Allows Nulls Description
elevation_survey_id integer 32     Yes Unique identifier for the aerial_lds.nz_elevation_survey_index table.
name varchar 100     No The corresponding aerial elevation layer name in the LINZ Data Service.
index_id integer 32     Yes Foreign key to the index tile layer identifier in the LINZ Data Service.
dem_id integer 32     Yes Foreign key to the DEM layer identifier in the LINZ Data Service.
dsm_id integer 32     Yes Foreign key to the DSM layer identifier in the LINZ Data Service.
point_cloud_doi varchar 50     Yes Foreign key to the point cloud data identifier in Digital Object Identifyer https://doi.org
point_density varchar 50     Yes The point density of the elevation survey.
vertical_datum varchar 20     No The vertical datum of the elevation survey.
horizontal_datum varchar 20     No The horizontal datum of the elevation survey.
supplier varchar 200     No The organisation that supplied the aerial elevation.
licensor varchar 200     No The organisation that licenses the aerial elevation.
flown_from date       Yes The earliest date on which aerial elevations were taken as part of this elevation survey.
flown_to date       Yes The latest date on which aerial elevations were taken as part of this elevation survey.
shape geometry       Yes A dissolved multipart boundary of the coverage of the elevation survey.