2. Published Data¶
The data described below represents aerial surveys data openly available on the LINZ Data Service:
- NZ Imagery Survey Index, https://data.linz.govt.nz/layer/95677
- NZ Elevation Survey Index, https://data.linz.govt.nz/layer/104252
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.