Geodetic Mark Dataset Index of Tables

The geodetic data download includes information from 23 tables in Landonline. Most of these tables are used to hold information about both cadastral and geodetic marks - these extracts comprise only the rows relating to geodetic marks.

For the purposes of this extract a geodetic mark is defined as a mark which has a geodetic code.

Geodetic marks in Landonline are primarily represented in two tables. The crs_node table defines the logical location to which the mark refers, and the crs_mark tables defines the physical mark at that location. Several marks may refer to the same node, but only one will apply at one time. The mark currently associated with the node is identified by its status, which is 'COMM' (for commissioned).

Each mark may have several names associated with it. These names are stored in the crs_mark_name table and are distinguished by their type. For geodetic work the most important name is the geodetic code, which has type 'CODE'.

Similarly, each node may have many coordinates associated with it. These may include coordinates in different datums (for example NZGD200, NZGD49, and orthometric height datums), and coordinates that are either proposed new coordinates or decommissioned old coordinates. All these coordinates are stored in the crs_coordinate table, and are distinguished by coordinate system and status. The current authorised coordinate of a node for a datum is the coordinate with status 'AUTH'.

The crs_coordinate_sys table lists all the coordinate systems that are used in Landonline. Each coordinate system is defined in terms of a datum in the crs_datum table, and a coordinate type in the crs_coordinate_tpe table. The crs_cord_order table lists the coordinate orders that apply for each datum.

Each time a mark is surveyed or maintained is recorded in the crs_mrk_phys_state table.

The following list defines all the tables that are included in the geodetic data set.

Data fileTable nameDescription
adj1.csvcrs_adjustment_runDefines adjustment runs used to calculate coordinates and source information for coordinates converted from the old geodetic database.
aud1.csv, aud2.csvcrs_audit_detailLogs significant changes to records in the other tables.
coo1.csvcrs_coordinateHolds all coordinates of nodes (including orthometric height coordinates)
cos.csvcrs_coordinate_sysLists all coordinate systems used in Landonline
cot.csvcrs_coordinate_tpeDefines the representations of coordinates (lat/lon, projections)
cop.csvcrs_cor_precisionLists the number of decimal places used to display coordinates of different types and orders
cor.csvcrs_cord_orderLists the coordinate orders that may be assigned to coordinates.
dtm.csvcrs_datumLists the datums to which coordinates may be referenced
elp.csvcrs_ellipsoidLists the ellipsoid models used.
loc1.csvcrs_localityLists land districts and other areas of interest.
mnt1.csvcrs_maintenanceTracks maintenance required on marks
mrk1.csvcrs_markDefines the physical marks associated with nodes
mkn1.csvcrs_mark_nameLists the various names used to refer to a mark including the geodetic code
mps1.csvcrs_mrk_phys_stateLists maintenance done and the state of the mark, beacon, and protection structure.
nod1.csvcrs_nodeLists the nodes - the abstract points to which coordinates are referenced.
npo1.csvcrs_node_prp_orderLists the proposed order of nodes for which coordinates have not yet been calculated.
orj1.csvcrs_ordinate_adjRelates each coordinate to the adjustment that created it.
ort.csvcrs_ordinate_typeDefines the types of ordinate (lat, lon, height) used.
sit1.csvcrs_siteLists sites at which one or more survey marks are located.
slo.csvcrs_site_localityRelates sites to land districts
sco.csvcrs_sys_codeLists codes used in the database
scg.csvcrs_sys_code_groupDefines the various groups of codes used in the database.
uom.csvcrs_unit_of_measDefines the units (such as metres) used in the database.