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 you can choose between the export as DXF file, to Excel, as ASCII- or. CSV file, Export according to REB selection, XML, CountryXML 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 as a DXF file

When exporting as a DXF file, point sets, triangulations, modeling and axes can optionally be transferred, for example in a Machine control to use.

The exportable content is available on the left-hand side of the window and can be selected by ticking the box. Enter the file name and path of the file to be created by clicking the […] button.

Activate the option if the polygons of the modeling are to be divided into individual lines Dissolve polygons into single lines.

The export as a DXF file is only available on the top node terrain available in the tree of the Quick-DGM.

Export to Excel

When exporting to 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 numberXYZDescription
1100.00100.00100.00
2103.0090.0099.86Tree
3103.00110.00100.13
4106.4997.78101.55
5110.0083.0099.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

triangleXYZproj. areaturned away areaaverage height
1100.00100.00100.00
103.0090.0099.86
106.4997.78101.5529.1230.300.96
2106.4997.78101.55
103.00110.00100.13
100.00100.00100.0035.7836.691.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 cellXYZproj. areaturned away areaaverage heightVolume
1100.0079.0099.51
100.7479.0099.51
100.0079.7499.51
100.7479.7499.510.540.540.000.00
2100.7479.0099.51
101.4779.0099.51
100.7479.7499.51
101.4779.7499.510.540.540.000.00

Difference body

There are two options for exporting the difference body 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

PrismaXYZ1Z2proj. area average heightVolume
1116.8799.77100.00103.20
116.87106.04100.00102.16
112.52106.02102.01102.0113.65-1.78-24.36
2112.52106.02102.01102.01
116.5199.01103.31103.31
116.8799.77100.00103.202.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

PunktXYZ1Z2
1116.8799.77100.00101.00
2116.87106.04100.00101.00
3112.52106.02102.01101.00
4112.52106.02102.01101.00
5116.5199.01103.31101.00
6116.8799.77100.00101.00

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

PrismaPoint 1Point 2Point 3average heightproj. areaSurfaceVolume
1123101.3722.6023.0842.12
2143101.117.637.7912.21
3543100.5432.1432.8133.00
467899.7011.7212.072.19
591011100.3823.0823.6720.01
691211100.717.787.989.33
PrismaPoint 1Point 2Point 3average heightproj. areaSurfaceVolume
1123101.0022.6022.6033.68
2143101.007.637.6311.37
3543101.0032.1432.1447.89
4678101.0011.7211.7217.46
591011101.0023.0823.0834.39
691211101.007.787.7811.59
FootprintSurfaceVolume
Reference surface1986.002022.592743.23Triangulation Tria 1 (unmodeled)
Target surface1986.001986.002959.14Horizont 101
difference0.00-36.59215.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.


Export as an ASCII file

When exporting as ASCII-File, a file format is generated that can be opened and viewed with any editor.

Enter the file name of the file to be created by clicking the button [...] . click
You can optionally post the data X Y Z or after YXZ export sorted. You can also use the Point number and the Description with export.

Point set

Direct output of the point set, whereby the X coordinate, Y coordinate, Z coordinate and the description are listed for each line.

For example:

100.0000000000100.0000000000100.0000000000
103.000000000090.000000000099.8600000000
103.0000000000110.0000000000100.1300000000
106.490000000097.7800000000101.5500000000
110.000000000083.000000000099.700000000

triangulation

Direct output of all coordinate points of the triangles, whereby the X-coordinate, Y-coordinate and Z-coordinate are listed per line.

For example:

100.0000000000100.0000000000100.0000000000
103.000000000090.000000000099.8600000000
103.0000000000110.0000000000100.1300000000
106.490000000097.7800000000101.5500000000
110.000000000083.000000000099.700000000

Grid

Direct output of all coordinate points of the grid, with the X-coordinate, Y-coordinate and Z-coordinate listed per line.

For example:

100.000000000079.000000000099.5100000000
100.737373737479.000000000099.5100000000
101.474747474779.000000000099.5100000000
102.212121212179.000000000099.5100000000

Export as CSV file

When exporting as a CSV file, the same content is generated as when exporting to Excel. The columns are separated by a comma or semicolon and can therefore be opened by all common table editing programs.

Enter the file name of the file to be created by clicking the button [...] . click

Point set

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

Example: Documentation for point set Terrain1.dat

Point ID; 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

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, angled Area, mean height
1,100.000,100.000,100.000
,103.000,90.000,99.860
,106.490,97.780,101.550,29.120,30.302,0.960,27.955
2,106.490,97.780,101.550
,103.000,110.000,100.130
,100.000,100.000,100.000,35.780,36.690,1.050,37.569
3,103.000,110.000,100.130
,106.490,97.780,101.550
,112.520,106.020,102.010,51.222,52.066,1.720,88.102

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

Cell, X, Y, Z, proj. Area, developed area, avg. Height, volume
1,100.000,79.000,99.510
,100.737,79.000,99.510
,100.000,79.737,99.510
,100.737,79.737,99.510,0.544,0.544,0.000,0.000
2,100.737,79.000,99.510
,101.475,79.000,99.510
,100.737,79.737,99.510
,101.475,79.737,99.510,0.544,0.544,0.000,0.000
3,101.475,79.000,99.510
,102.212,79.000,99.510
,101.475,79.737,99.510
,102.212,79.737,99.510,0.544,0.544,0.000,0.000

Difference body

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

Prism, X, Y, Z1, Z2, proj. Area, mean Height, volume
1,116.874,99.775,100.000,103.196
,116.874,106.043,100.000,102.159
, 112.520,106.020,102.010,102.010,13.646, -1.785, -24.357
2,112.520,106.020,102.010,102.010
,116.510,99.010,103.310,103.310
, 116.874,99.775,100.000,103.196,2.802, -1.065, -2.985
3,116.510,99.010,103.310,103.310
,115.290,91.310,101.790,101.790
, 116.874,92.338,100.000,101.904,5.472, -0.635, -3.473

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.


Export as an XML file

For triangulations only

Direct output of the triangles of the triangulation, whereby the points and the three associated coordinates X, Y and Z are output first. This is followed by the output of the triangles with the associated point numbers.

Enter the file name of the file to be created by clicking the […] button.

If the triangulation also contains edges, these are also exported.

Example: XML file for Triangulation Terrain1.dat


Export as LandXML file

For triangulations only

Direct output of the triangles of the triangulation, whereby the points and the three associated coordinates X, Y and Z are output first. This is followed by the output of the triangles with the associated point numbers.

Enter the file name of the file to be created by clicking the […] button.

If the triangulation also contains edges, then these are also exported.

Example: LandXML file for Triangulation Terrain1.dat

Export axes

With this function you can axles export in LandXML format. These are sometimes required as additional information for the machine control.

2D or 3D polylines can be recorded as axes by dragging and dropping them onto the node axles pull.

3D axisIs written as an "alignment" in the LandXML file. The "alignment" consists of a 2D line (CoordGeom) and the associated height information (profiles).
2D axisIs written as an "alignment" in the LandXML file. The "Alignment" only consists of a 2D line (CoordGeom).
3D polylineIs written as a "PlanFeature" in the LandXML file. The "PlanFeature" consists of a 3D line (CoordGeom).
2D polylineIs written as a "PlanFeature" in the LandXML file. The "PlanFeature" consists of a 2D line (CoordGeom).

Export of REB selection

With this function, DTM data such as Point sentences and triangulations can be exported as REB files.

If a triangulation consists of several sets of points or edges, then these are combined to form a set of points or edges during the export.

The data types can either be created as individual files (data types) or in a file as a REB data record. This REB data record can then contain several types of data.

Enter the file name of the file to be created by clicking the button [...] . click

A DA49 or DA58 cannot be created without the associated DA45.

Is the option DATAflor Export activated, then several point or edge sets are created during the export if the exported triangulation contains several point or edge sets.

With the option Create control objects AutoCAD points (DA45), 3D polylines (DA49) and 3D surfaces (DA58) are created which can be used to check the created DTM data. The data is created on separate layers.


Export to GAEB / REB process description

With this function, DTM data such as Point sentences, Triangulations, Modeling, Difference body and Profile groups can be exported according to various process descriptions.

If a triangulation consists of several sets of points or edges, then these are combined to form a set of points or edges during the export.

The data types can either be available as individual files (data types) or in a file as a VB data record. This VB data record can then contain several types of data.

Enter the file name of the file to be created by clicking the button [...] . click

With the option Create control data AutoCAD points, 3D polylines and 3D surfaces are created that can be used to review the created DTM data. The data is created on separate layers.

More information about the used GAEB / REB process descriptions you can use the button [Process descriptions] . call

According to the REB process description, the current Line numbers the triangular mesh only 4 digits to disposal. As a result, if there are more than 9999 triangles, the REB-compliant export is only carried out incompletely.

You can have one not Perform REB-compliant export. In this case, another digit is used so that up to 99999 triangles can be exported.

According to the REB process description 21.013 make only 3 decimal places permissible. Because of this, inaccurate values ​​can arise compared to the CAD quantity.

Further steps