Export of DTM data

Export of DTM data

Description

With the functions in the tab Export you have the option of exporting various DTM objects in other formats.
For the Export of DTM data can be switched between Export to Excel, as ASCII- or. CSV file, Export according to REB selection and after different GAEB / REB process descriptions to be chosen.

Application

The Export of DTM objects is object-dependent. To do this, select in the window Info (please refer Quick DGM) the tab Export. If, for example, a triangulation is exported to a REB data set, the assigned point and edge sets are generated in addition to the triangles.

Features

Export to Excel

In the Export after Excel, the data is immediately entered in an Excel table and formatted correctly.

Point set

Direct output of the point set, with the point number, the coordinates X, Y, Z and the description being output in columns. Creation of the column headings: point number, X value, Y value, Z value, description.

For example:

Point number	X	Y	Z	Description
1	100.00	100.00	100.00
2	103.00	90.00	99.86	Tree
3	103.00	110.00	100.13
4	106.49	97.78	101.55
5	110.00	83.00	99.7

triangulation

Direct output of the triangles of the triangulation, whereby the triangle number and the three associated coordinates X, Y and Z are output in columns. Areas are also documented.

Creation of the column headings: Triangle, X value, Y value, Z value, projected area, developed area, mean height.

Example: Prism documentation for triangulation Terrain1.dat

triangle	X	Y	Z	proj. area	turned away area	average height
1	100.00	100.00	100.00
	103.00	90.00	99.86
	106.49	97.78	101.55	29.12	30.30	0.96
2	106.49	97.78	101.55
	103.00	110.00	100.13
	100.00	100.00	100.00	35.78	36.69	1.05

After calling the function, the triangles can also be labeled with the triangle numbers used. These are important for an overview plan and the verifiability of the documentation.

Grid

Direct output of the grid cells of the surface, whereby the cell number and the three associated coordinates X, Y and Z are output in columns. In addition, the areas are documented. The mean height and volume are not calculated.

Creation of the column headings: grid cell, X value, Y value, Z value, projected area, developed area.

Example: Documentation for grid network Terrain1.dat

Grid cell	X	Y	Z	proj. area	turned away area	average height	Volume
1	100.00	79.00	99.51
	100.74	79.00	99.51
	100.00	79.74	99.51
	100.74	79.74	99.51	0.54	0.54	0.00	0.00
2	100.74	79.00	99.51
	101.47	79.00	99.51
	100.74	79.74	99.51
	101.47	79.74	99.51	0.54	0.54	0.00	0.00

Difference body

For the differential body there are two options for the Export to Excel:

Standard
Direct output of the prisms of the differential body, whereby the prism number and the three associated coordinates X, Y and Z are output in columns. Areas and volumes are also documented.

Creation of the column headings: prism, X value, Y value, Z1 value, Z2 value, projected area, average height, volume (reference Z1 to Z2).

Example: Prism documentation for differential body Terrain1.dat

Prisma	X	Y	Z1	Z2	proj. area	average height	Volume
1	116.87	99.77	100.00	103.20
	116.87	106.04	100.00	102.16
	112.52	106.02	102.01	102.01	13.65	-1.78	-24.36
2	112.52	106.02	102.01	102.01
	116.51	99.01	103.31	103.31
	116.87	99.77	100.00	103.20	2.80	-1.07	-2.99

After calling the function, the prisms can also be labeled with the prism numbers used. These are important for an overview plan and the verifiability of the documentation.

similar to REB 22.013
Direct output of the points, the prisms of the reference surface, the prisms of the target surface and the result. The point list with the point number, the associated coordinates X, Y, Z1 and Z2 and the prism lists with the prism number, the three associated point numbers and the average height are output in columns. Areas and volumes are also documented.

Creation of the column headings:
Point list: point, X value, Y value, Z1 value, Z2 value
Prism lists: prism, point 1, point 2, point 3, mean. Height, proj. Area, surface, volume

Example: Documentation for differential body volume 1 / tria 1

Punkt	X	Y	Z1	Z2
1	116.87	99.77	100.00	101.00
2	116.87	106.04	100.00	101.00
3	112.52	106.02	102.01	101.00
4	112.52	106.02	102.01	101.00
5	116.51	99.01	103.31	101.00
6	116.87	99.77	100.00	101.00

Z1 corresponds to the height on triangulation Tria 1 (unmodeled)
Z2 corresponds to the height on horizon 101

Prisma	Point 1	Point 2	Point 3	average height	proj. area	Surface	Volume
1	1	2	3	101.37	22.60	23.08	42.12
2	1	4	3	101.11	7.63	7.79	12.21
3	5	4	3	100.54	32.14	32.81	33.00
4	6	7	8	99.70	11.72	12.07	2.19
5	9	10	11	100.38	23.08	23.67	20.01
6	9	12	11	100.71	7.78	7.98	9.33

Prisma	Point 1	Point 2	Point 3	average height	proj. area	Surface	Volume
1	1	2	3	101.00	22.60	22.60	33.68
2	1	4	3	101.00	7.63	7.63	11.37
3	5	4	3	101.00	32.14	32.14	47.89
4	6	7	8	101.00	11.72	11.72	17.46
5	9	10	11	101.00	23.08	23.08	34.39
6	9	12	11	101.00	7.78	7.78	11.59

	Footprint	Surface	Volume
Reference surface	1986.00	2022.59	2743.23	Triangulation Tria 1 (unmodeled)
Target surface	1986.00	1986.00	2959.14	Horizont 101
difference	0.00	-36.59	215.91

After calling the function, the prisms can also be labeled with the prism numbers used. These are important for an overview plan and the verifiability of the documentation.