Import ECEF WGS84 BLH in Arcmap?

Bjornten_Broeke1

Hi,

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?

Bjorn

JayantaPoddar

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.