Gebruikershulpmiddelen

Site-hulpmiddelen


Verschillen

Dit geeft de verschillen weer tussen de geselecteerde revisie en de huidige revisie van de pagina.

Link naar deze vergelijking

nl:produkte:cad_2016:export_von_dgm-daten [2013/10/22 10:43] (huidige)
Regel 1: Regel 1:
 +====== Export of DTM-data ======
 +===== Description =====
 +With the functions in the tab Export different DTM-objects can be exported to other formats.\\ For the export of DTM data there multiple options like an **Export to Excel**, as **Export as Ascii-file** or **Export as Csv-file**, an Export to **REB-selection** and export according to different **GAEB/​REB-process descriptions**.
 +===== Procedure =====
 +The export of DTM-objects is object-dependent. For this select in the window **Info** (see [[Quick-DGM]]) the tab **Export**. For example, if a triangulation is exported to a REB record set then the allocated point and edge sets will be generated as well.
 +===== Functions =====
 +==== Export to Excel ====
 +When exporting to Excel the data is transferred to an Excel Table and formatted.\\ {{:​produkte:​cad:​dgm:​dgm0161.png?​nolink|}}
 + 
 +=== Point set ===
 +The direct export of a point set with point number, coordinates X, Y, Z, and the description listed in columns. Setup of the columns titles: point number, X-value, Y-value, Z-value, description.
  
 +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 ===
 +The direct export of triangles in a triangulation with the triangle numbers and the three allocated coordinates X, Y, Z listed in columns. Additionally the areas are documented.
 +
 +Setup of column titles: triangle, X-value, Y-value, Z-value, projected area, developed area, average height.
 +
 +Example: Documentation of prisms for a triangulation **Terrain1.DAT**
 +|Triangle|X|Y|Z|projected area|development 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 starting the function the triangles can additionally be labelled with numbers. These are important for an overview plan and the verifiability of the documentation.\\ {{:​produkte:​cad:​dgm:​dgm0143.png?​nolink|}}
 +=== Grid ===
 +The direct export of surface grids with the cell number and the three allocated coordinates X, Y, Z listed in columns. Additionally the area is documented. The average height and the volume are not calculated.
 +
 +Setup of column titles: wire cell, X-value, Y-value, Z-value, projected area, developed area.
 +
 +Example: Documentation of a grid **Terrain1.DAT**
 +|Wire cell|X|Y|Z|projected area|developed area|averenge 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|
 +=== End area volume ===
 +There are two options to the export for the end area volume to excel:
 +
 +**Standard**\\ ​
 +Direct export of prisms of the end area volume where the number of prisms and the three related coordinates X,Y, and Z are exported in columns. Additionally,​ areas and volumes are documented.
 +
 +Setup of column titles: prism, X-value, Y-value, Z1-value, Z-2-value, projected area, average height, volume (ratio Z1 to Z2).
 +
 +Example: Documentation of a prisma for end area volumes **Terrain1.DAT**
 +|Prism|X|Y|Z1|Z2|projected 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 starting the function the prisms can additionally be labelled with numbers. These are important for an overview plan and the verifiability of the documentation.\\ ​
 +{{:​produkte:​cad:​dgm:​dgm0143.png?​nolink|}}
 +
 +**similar to REB 22.013**\\
 +Direct output of points, the prisms of the reference surface, the prisms of the target surface and the result. Where the point list with the point number, the corresponding coordinates X, Y, Z1 and Z2 and the lists of Prisms with Prism numbers, the three corresponding point numbers and the average level in columns can be issued. In addition, there will be a documentation of areas and volumes.
 +
 +Appendix of the column headings:​\\ ​
 +Point list: Point, X-value, Y-value, Z1-value, Z2-value\\ ​
 +Prism list: Prism, Point 1, Point 2, Point 3, Average height, Projected area, Surface, Volume
 +
 +Example: Documentation for  an end area volume 1 / Tria 1
 +|Point|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 of the horizon 101
 +|Prism|Point 1|Point 2|Point 3|Average height|Projected 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|
 +
 +|Prism|Point 1|Point 2|Point 3|Average height|Projected 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|
 +
 +| |Ground area|Surface|Volume| |
 +|Reference surface|1986.00|2022.59|2743.23|Triangulation Tria 1(unmodeled)|
 +|Target surface|1986.00|1986.00|2959.14|Horizon 101|
 +|Difference|0.00|-36.59|215.91| |
 +
 +After activating the function, in addition the prisms can also be labelled with Prism numbers. These are important for an overview and the verifiability of the documentation.\\ ​
 +{{:​produkte:​cad:​dgm:​dgm0143_2.png?​nolink|}}
 +
 +----
 +==== Export as ASCII-file ====
 +When exporting as Ascii-file a file format is created which can be opened and reviewed in any Editor.\\ {{:​produkte:​cad:​dgm:​dgm0162.png?​nolink|}}
 +
 +Specify the file name of the file to be created by clicking ​ **[...]**.
 +=== Point set ===
 +Direct export of point sets whereat the coordinates X,Y, and Z and the description are listed per row.
 +
 +Example:
 +|100.0000000000|100.0000000000|100.0000000000|
 +|103.0000000000|90.0000000000|99.8600000000|
 +|103.0000000000|110.0000000000|100.1300000000|
 +|106.4900000000|97.7800000000|101.5500000000|
 +|110.0000000000|83.0000000000|99.700000000|
 +=== Triangulation ===
 +Direct export of all coordinates of triangles whereat the coordinates X,Y, and Z are listed per row.
 +
 +Example:
 +|100.0000000000|100.0000000000|100.0000000000|
 +|103.0000000000|90.0000000000|99.8600000000|
 +|103.0000000000|110.0000000000|100.1300000000|
 +|106.4900000000|97.7800000000|101.5500000000|
 +|110.0000000000|83.0000000000|99.700000000|
 +=== Grid ===
 +Direct export of all coordinates of the grid whereat the coordinates X,Y, and Z are listed per row.
 +
 +Example: ​
 +|100.0000000000|79.0000000000|99.5100000000|
 +|100.7373737374|79.0000000000|99.5100000000|
 +|101.4747474747|79.0000000000|99.5100000000|
 +|102.2121212121|79.0000000000|99.5100000000|
 +
 +----
 +==== Export as CSV-file ====
 +When exporting as CSV-file identical contents are generated simliar to the export to Excel. The columns are separated by a comma or semicolon and thus can be opened by all common spreadsheet editing programs.\\ {{:​produkte:​cad:​dgm:​dgm0163.png?​nolink|}}
 +
 +Specify the file name of the file to be created by clicking **[...]**.
 +=== Point set ===
 +Direct export of a point set whereat the point number and the three related coordinates X, Y, and Z are listed in columns. Setup of column titles: point number, X-value, Y-value, Z1-value, Z-2-value, description.
 +
 +Example: Documentation of point set **Terrain1.DAT**
 +|Point number;​X;​Y;​Z;​Description|
 +|1;​100.00;​100.00;​100.00|
 +|2;​103.00;​90.00;​99.86;​Baum|
 +|3;​103.00;​110.00;​100.13|
 +=== Triangulation ===
 +Direct export of triangles of the triangulation where the number of triangles and the three related coordinates X,Y, and Z are exported in columns. Additionally,​ areas are documented.
 +
 +Setup of column titles: triangles, X-value, Y-value, Z-value, projected area, developed area, and average height.
 +
 +Example: Documentation of prisms triangulation **Terrain1.DAT**
 +|Triangle,​X,​Y,​Z,​projected area,​developed area,​average 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 starting the function the triangles can additionally be labelled with numbers. These are important for an overview plan and the verifiability of the documentation.\\ {{:​produkte:​cad:​dgm:​dgm0143.png?​nolink|}}
 +=== Grid ===
 +Direct export of grid cells of an area whereat the cell number and the three related coordinates X, Y, and Z are listed in columns. Additionally,​ areas are documented. The average height an the volume will not be considered.
 +
 +Setup of column titles: wire cell, X-value, Y-value, Z1-value, Z-2-value, projected area, and developed area. 
 +
 +Example: Documentation of a grid **Terrain1.DAT**
 +|Wire cell,​X,​Y,​Z,​projected area,​developed area,​average 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|
 +=== End area volume ===
 +Direct export of prims of the end area volume whereat the prism number and the three related coordinates X, Y, and Z are listed in columns. Additionally,​ areas and volume are documented.
 +
 +Setup of column titles: prism, X-value, Y-value, Z1-value, Z-2-value, projected area, average height, volume (ratio Z1 to Z2).
 +
 +Example: Documentation of a prims for end area volumes **Terrain1.DAT** ​
 +
 +|Prism,​X,​Y,​Z1,​Z2,​projected area,​averange 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 starting the function the prisms can additionally be labelled with numbers. These are important for an overview plan and the verifiability of the documentation.\\ {{:​produkte:​cad:​dgm:​dgm0143.png?​nolink|}}
 +
 +----
 +==== Export to REB-selection ====
 +With this function DTM data like **point sets** and triangulations can be imported as REB-file.
 +
 +<WRAP round important 90%>
 +If a triangulation cosists of multiple point or edge sets these are merged to a point or edge set when imported.
 +</​WRAP>​
 +
 +The type of data can either exist in form of single files (data types) or in a file as REB record set. This REB record set can then consist multiple data types.\\ {{:​produkte:​cad:​dgm:​dgm0164.png?​nolink|}}
 +
 +Specify the file name of the file to be created by clicking **[...]**. ​
 +
 +<WRAP round important 90%>
 +A DA49 or DA58 can not be imported without the associated DA45.
 +</​WRAP>​
 +
 +If the option **DATAflor Export** is activated multiple point or edge sets are generated in the case that the exported triangulation contains multiple point or edge sets. 
 +
 +With the option **Create control objects** the AutoCAD points (DA45), 3D-polylines (DA49), and 3D-areas (DA58) are generated which then can be used to check the created DTM data. The data is created on separate layers.
 +
 +----
 +==== Export according to GAEB/​REB-process description ====
 +With this function DTM data like **point sets**, **triangulations**,​ **models**, **end area volumes**, and **profile groups** can be exported in many different ways.
 +
 +<WRAP round important 90%>
 +If a triangulation cosists of multiple point or edge sets these are merged to a point or edge set when imported.
 +</​WRAP>​
 +
 +The type of data can either exist in form of single files (data types) or in a file as record set of process description. This record set can then consist multiple data types.\\ {{:​produkte:​cad:​dgm:​dgm0165.png?​nolink|}}
 +
 +Specify the file name of the file to be created by clicking ​ **[...]**.
 +
 +With the option **Create control data** the AutoCAD points, 3D-polylines,​ and 3D-areas are generated which then can be used to check the created DTM data. The data is created on separate layers.
 +
 +<WRAP round tip 90%>
 +Further information on the [[GAEB⁄REB-Verfahrensbeschreibungen]] descriptions used can be found by clicking the button **[Process descriptions]**.
 +</​WRAP>​
 +
 +<WRAP round important 90%>
 +According to the REB process description there are only four digits available for the consecutive row numbering of triangle meshes. if there are more than 9999 triangles the REB conform export will be incomplete.
 +
 +You can execute a non-REB-conform export. For this, an additional digit is used so that up to 99999 triangles can be exported.
 +
 +</​WRAP>​
 +
 +<WRAP round important 90%>
 +According to the REB process description **21.013** only three decimal places are allowed. Because of this, there can be inprecise values compared to the CAD mass.
 +</​WRAP>​