I have a file in ECEF WGS84 BLH in meters with dd:mm:ssfor Angle Units.
I want these point to import in Arcmap 10.5 as point layer.
The file to import is a KML, with these points.
I can import them with KML to layer, I can see all the points, but I cant get them on the map in the right position.
Does somebody now a way how to get there?
Its so far out of the world that it's lost. It is by the way a mistake from me, it should be CSV in my text, so Excel to layer I did, my mistake.
file_name,file_type,sequence_id,timestamp,GPS_time(s),ecef(x),ecef(y),ecef(z),attitude(x)=roll,attitude(y)=pitch,attitude(z)=pan,frame_id F:/DG_Paderborn-Borchen - Etteln_170620_Run1/2017-06-20_10-35-25/ladybug_panoramic_000000.jpg,JPG,0,28583339722,1181983021.1082721,3922148.9627709221,604199.61446186027,4976781.3346982058,-177.57368922265997,7.1055832760669553,-79.315623440207304,1068
Thank you for sharing the sample data. The method I am seeing is a bit tedious, but the task can be done.
I can do the conversion of ECEF (X,Y,Z) to LLA (Latitude, Longitude, Altitude) using Latitude/Longitude/Height ECEF via J-Script . I can perform one row at a time.
If I input the ECEF (X,Y,Z) in km, I get the result in Lat./Lon./Height.
Add the resulting of Lat./Lon./Height in the Excel sheet, and use Add XY Data to add points from the XY Table.
Note: Just use the values (e.g. 51.61909 / 8.75747 / 231.3) for Lat./Lon. and Height fields.