Supported file formats

<< Click to Display Table of Contents >>

dpPower > Appendix >

Supported file formats

 

 

File format

Version support

Usage/Comments

DGN
(Design)

Microstation v7

Import, export and reference data.

DXF
(Drawing Exchange Format)

dpSpatial follows the development of the format and handles the latest versions in best effort.

Import, export and reference data.

DWG

(Drawing)

dpSpatial follows the development of the format and handles the latest versions in best effort.

 

Reference data.

 

DPS

 

A vector format developed by Digpro. Used among other things for exchanging data between  dpPower and the dpFieldmap client (offline).

Geo data with attributes

 

Import and export of coordinate data.

Geodos

 

Import and export of coordinate data.

GPX

(GPS Exchange Format)

 

Reference data, export of coordinate reports in the query tool.
An XML based standard format for exchangning GPS data in terms of dots and slot between different applications.

GSI

 

Import and export. GSI is a measurement data format from total stations of Leica brand.

JPEG

 

Reference data and export of graphical view. Suitable for export of raster data.

KRF

 

Reference data. KRF is Kartago raster format.

KML

(Keyhole Markup Language)

2.1

Reference data. The system supports point data, lines and some types of polygons.
 

Marit

 

Import and export of coordinate data.

PNG

(Portable Network Graphics )

 

Reference data and export of graphical view. Suitable for export of raster data.

PDF

 

Export of reports, pictures etc.

PXY

 

Import of coordinate data.

RDW

 

Reference data.

Shape

 

Reference data, export and import.

SVG

 

Export of data in the graphical view. SVG is an XML-based vector format.

SQL

 

Import and export of map product and product classes.

TAB

 

Reference data, MapInfo.

Trimble

 

Import and export of coordinate data.

TXY

 

Reference data. See TXY Specification

XLM

 

Import and export of product specifications, codelists etc.

XLS

(Microsoft Excel)

 

Export of tables, search results, etc.

TXY Specification

The TXY-format is a vector based coordinate format using a semicolon separated values of 3 or 10 columns. TXY files may be opened as reference files in the application and are handled in much same way as other available reference files of the vector type. When a TXY-file is opened in the application, its coordinate point data is shown as symbols, whose color, size and shape may (optionally) be defined in the file. The TXY reader used in the application also supports comma-delimited files with the "*.csv" file extension that conform to the txy format specification as outlined below.

TXY format specification

1

Free text (identifier);

 

2

X (N);

Columns 1 through 3 (mandatory). Describe the geographic position of point data.

3

Y (E);

 

 

 

 

4

Primary color;

 

5

Secondary color;

 

6

Symbol font;

Columns 4 through 10 (optional) describe the symbols (color, type, size) used to visualize point data.

7

Symbol-ID;

If the columns are left out, point data will be given a common, default symbol.

8

Height,

 

9

Width;

 

10

Style

 

 

 

Example of data row in the TXY file

"Gas boiler;10099.123;97875.245;00FF00;00EB00;FV107;DEC132;4.2;4.2;0"

 

Support for cvs-files

The TXY reader can be used to open comma-delimited files (*.csv) created in e.g. Excel. The csv file must conform to the format specification given above. Additionally, the following applies to csv-files:

 

* If columns are separated with ';' the decimal separator can be '.' or ','

* If columns are separated with ',' the decimal separator can only be '.'

 

Specifications for measurement data file format

Geo data with attribute

The file extension is ”.dpt”.

Every row in the file corresponds to a point or vertex, and is designed as below:

 

pbet;X;Y;Z;objkod;linjenr;radie;attr1;attr2;attr3;attr4;attr5;attr6;attr7;attr8;attr9;attr10

 

A vertex in a line object should have a value on the field "line number". Points with the same line number belong to the same line. If the line number is missing, the row is handled as a point object.

 

The radius is only used for circular arcs.

 

PXY

This is a text file format.

The file extension is “*.pxy”.

All lines end with a comma at character position 75 in the standard PXY file.

Data starts on line 3.

The import program in dpSpatial reads 6 columns of data where the first 5 are taken care of. You do not need to write the fields in special positions, one or more blanks between the columns is sufficient. There must be 6 columns. Either free text or a comma (or both) must end the line.

 

Specification PXY

Fält

Beskrivning

Line number, Point number

May contain both letters and numbers. Character position in source file: 1.

If point exists, for example 4.1, it is interpreted as if there were line numbers to the left of the point and breakpoint numbers on the line to the right.

Northing

x-coordinate, column 2 (defaults to position 22 for decimal point).

Easting

y-coordinate, column 3 (defaults to position 34 for decimal point).

Z

z coordinate, column 4 (defaults to position 46 for decimal point).

Code

External code for the measured object, column 5 (default first character in position 52, max. 11 characters).

Free text

Comment in column 6 (default in character position 63). Can be omitted.

Comma

Column 7 (or column 6 if no free text) A comma should end the line (default in position 75).

 

Example 1:

First two lines of comments, then 2 points and then a line with 3 points and finally a point. Any text in the free text field is not saved.

XYZ-COORD-FILE ,V1.00.2015-08-10,                                         ,

                                         ,                                ,

2             6652893.067  643229.570     199.962 TERR_AHP    -1          ,

3             6652905.688  643234.249     199.887 TERR_AHP    -1          ,

4.1           6653046.612  643125.259     197.461 VAG_VSR                 ,

4.2           6653046.116  643123.842     197.497 VAG_VSR                 ,

4.3           6653046.011  643121.268     197.601 VAG_VSR                 ,

5             6656082.582  646210.024     195.210 200         PVC160      ,

 

Example 2:

XYZ-COORD-FILE ,V1.0 ,2013-10-29, ,

Plantolkning ,

1 52728.209 43202.209 204.343 TERR_AHP ,

2 52893.067 43229.570 199.962 TERR_AHP ,

3.1 53046.612 43125.259 197.461 VAG_VSR ,

3.2 53046.116 43123.842 197.497 VAG_VSR ,

 

 

Make sure to show formatting marks in your text editor in order to see and count spaces.

 

Marit

This format is used originally by the Geograph ME application. The format supports point objects, lines and polygons.

The file extension is "*.xyz" or "*.pkt". The Marit-format has an extended format "*.ext" (extended) with an extra "Free text" column.

 

Specification Marit

Field

Description

Point number

Can contain both, letters and  numbers. Max 7 characters. Character position in the source file: 1.

X

X-coordinate (northing), max 11 characters. Position: 12.

Y

Y- coordinate (easting), max 11 characters. Position: 24.

Z

Z – coordinate (elevation), max 11 characters. Position: 42.

Object code

External code (field code) for the input object. Position: 50.

Line type

A single-digit number code denoting the geometric type of a coordinate point See table Line type codes Marit. Position: 56.

Free text

An extra field available only for extended Marit format with file extension    ”.ext”. Position: 60.

 

Line type codes Marit

Line type

Description

0

A point object, such as a manhole.

3

A point on a line or polygon (area) object. Forms a vertex on a line segment.

4

A point on an arc.

7

An end point in a polygon/area. Connect this point to the first point to create a polygon.

8

An end point on a line. A line consisting of three segments will have four coordinate points with line types 3 - 3 - 3 - 8, in that order.

 

 

Make sure to show formatting marks in your text editor in order to see and count spaces.

 

Geodos

Geodos is a computer system for measuring technology in surveying, building and construction activities. The system is primarily used to run on field computers.

The file extension is: "*.xyz".

 

Specification Geodos

Field

Description

Punct number

Can contain both: letters and figures

Object code

External code (field code) for the input object  

X

x-coordinate

Y

y- coordinate

Z

z – coordinate

 

The field is separated by at least one space.

 

Example:

6 dp 6167270.546 1323734.769 6.536

7 dp 6167270.191 1323728.182 6.562

8 cabinet 6167270.115 1323726.592 6.4

 

GSI

The GSI format may contain measurements of angles and distances, as well as coordinates. dpSpatial supports only coordinates. When importing GSI files, field objects are read as field data objects (object type 14005).

The file extension is  ".gsi"

 

Example of a point row in a GSI file

*110001+0000000000116420 81..10+0000000103307321 82..10+0000000074416531 83..10+0000000000000000

 

Parameters (in fat style in the example above):

* = beginning of a row, describing a point.

11 = point number.

81 = Northing

82 = Easting

83 = Height

 

Stp

Standard for the Exchange of Product Data (STEP).

The format is used only for point objects.

The file extension is ”*.stp”

 

Specification stp

Point number  X-coordinate  Y-coordinate  Z-coordinate

 

Example:

RL7_S2__STV 6934655.220 1493483.110 162.940!

RL7_S2_0001 6934613.370 1493515.490 161.400!

RL7_S2_0002 6934502.300 1493477.930 159.720!

RL7_S2_0003 6934256.430 1493394.630 157.430!

RL7_S2_0004 6934056.130 1493327.080 163.780!

 

When you use the function, the object code for the new object has to be added.

 

Trimble

The file extension is "*.m".

 

Specification Trimble

0 = line or point code. "0 = 10" refers to point, "0 = 11" refers to line.

1 and 4= OBJECT CODE (field code).

5 = Point number

37 = Northing (N)

38 = Easting (E)

39 = Z-value (omitted values are interpreted as "0".)

 

 

Example of a Trimble file (a line object)

5=9

4=KKE

0=11

1=129

37=111127.9

38=109742.09

39=9.891

5=10

4=KKE

37=111136.24

38=109737.29

39=9.942

5=11

4=KKE

37=111144.14

38=109732.56

39=9.951

5=12

4=KKE

37=111153.18

38=109731.16

39=10.021

 

 

HP-17

The file extension is ".17".

 

Specification HP-17

 

Type codes

L = Line

LE = Line end

T = Text

P = Point

 

Format

For the L type code

L,Object Code

X-coordinate 1,Y-coordinate 1

X-coordinate 2,Y-coordinate 2

X-coordinate n,Y-coordinate n

LE

 

For the T type code

T, Object Code, Rotation, X-coordinate, Y-coordinate, Text

 

For the P type code

P, Object Code, Rotation, X-coordinate, Y-coordinate

 

Example of an HP-17 file

P,DP1,0,6556280.806,1458602.458

P,POL,0,6556289.549,1458609.815

P,POL,0,6556265.879,1458636.684