Help on reading coordinate numbers

[nexaen]

Hello,

I've received following PDF map and text note consisting coordinate numbers to get dimensions of blue hachured areas (tunnels) on the map. Do you know what coordinate system is it? or if you can share some links with me regarding this format?

At first I thought numbers are based on UTM coordinate system, but the PDF map doesn't have any scale on top-&left sides or others sides. So, I cannot read numbers based on that.

Any help would be appreciated.

 

PDF+text note:

http://nimasa.net/my_disk/temp/map.rar

 

Thanks

nexaen

[jorrarro]

It seems to me that the answer is in your dataset. In the text file SRS: DKTM2_DVR90

That means Danish system with metric coordinates. Use this as reference: https://epsg.io/4098

When importing the coordinates, be sure to notice that they are not XYZ but YXZ (northings before eastings).

Edited July 4, 2017 by jorrarro
Clarification on XYZ and YXZ differences

[nexaen]

thx jorrarro for your reply.

I tried to import coordinate (in txt format) to ArcMap using the following tutorial, but I only get "Field 6", for X and Y directions. I can choose again Field 6 for Z direction, but I think the way I'm doing is wrong. Could you please elaborate more on how you imported and got the points on the map?

https://www.youtube.com/watch?v=cT1eFTu1unk

Thanks in advance

 

On 04/07/2017 at 9:51 PM, jorrarro said:

It seems to me that the answer is in your dataset. In the text file SRS: DKTM2_DVR90

That means Danish system with metric coordinates. Use this as reference: https://epsg.io/4098

When importing the coordinates, be sure to notice that they are not XYZ but YXZ (northings before eastings).

 

[jorrarro]

First I used Excel to transform data to table. Data -> Text to columns. As I could not use space as delimiter (last column has spaces), I used fixed width so that all numbers went to separate fields. And then rewrote the header. As CSV, the data came out as follows (semicolon as delimiter):

GID;Y;X;Z;text;
160501;1136981.309;427018.995;24.453;Tabtgået;
160502;1137117.536;426932.208;24.7;Spyd i jord m gul top;
160503;1137074.143;427167.529;25.276;Spyd i jord m gul top;
160504;1137270.694;427149.621;24.771;Spyd i jord m gul top;
160505;1137316.357;426982.35;24.863;Spyd i jord m gul top;
160506;1137372.847;427141.53;23.281;Spyd i jord m gul top;
160507;1137475.44;426979.949;22.596;Tabtgået;
160508;1137527.149;427215.072;21.179;Spyd i jord m gul top;
160509;1137611.641;427182.29;20.764;Spyd i jord m gul top;
160510;1137616.198;427041.391;20.413;Spyd i jord m gul top;
160511;1137740.069;427050.822;19.723;Spyd i jord m gul top;
160512;1137751.792;427132.87;19.216;Tabtgået;
161004;1137048.141;427149.171;25;Spyd i jord m gul top;
161003;1137126.893;427110.19;25.517;Tabtgået;
161002;1137182.808;427057.73;25.309;Tabtgået;
161001;1137220.373;427007.094;25.911;Spyd i jord m gul top;
170102;1137306.111;427120.132;24.574;Spyd i jord m gul top;
170103;1137301.109;427034.383;25.118;Spyd i jord m gul top;
170101;1137275.446;427044.6;25.784;Spyd i jord m gul top;
170104;1137393.761;427019.66;23.584;Spyd i jord m gul top;
170105;1137413.861;427022.837;23.365;Spyd i jord m gul top;
170106;1137419.946;427116.878;22.07;Spyd i jord m gul top;
170501;1137404.049;427054.017;21.139;Fast prisme i tunnel, prismekonstant;-17,5mm
170502;1137410.036;427080.694;21.107;Fast prisme i tunnel, prismekonstant;-17,5mm
170503;1137293.021;427063.412;20.908;Fast prisme i tunnel, prismekonstant;-17,5mm
170504;1137291.129;427086.338;20.879;Fast prisme i tunnel, prismekonstant;-17,5mm
170505;1137218.985;427024.099;20.888;Fast prisme i tunnel, prismekonstant;-17,5mm
170506;1137218.609;427019.445;20.795;Fast prisme i tunnel, prismekonstant;-17,5mm

For ArcMap, I added the saved CSV (you could save it as XLSX and use it same way) file to data frame and under right click chose Display XY data. Arcmap detects X and Y automatically, just had to set Z to field Z. Under projection, click Edit and choose DKTM2 (Projected - National grids - Europe, search works too).