Import ECEF WGS84 BLH in Arcmap?

852
6
07-05-2017 02:22 PM
Bjornten_Broeke1
New Contributor

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

Tags (3)
Reply
0 Kudos
6 Replies
Jayanta_Poddar
Honored Contributor

Which area do the points belong to? Could you attach the KMZ file here so that we can review it?

Reply
0 Kudos
Bjornten_Broeke1
New Contributor

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),at‌titude(x)=roll,attit‌ude(y)=pitch,attitud‌e(z)=pan,frame_id F:/DG_Paderborn-Borchen - Etteln_170620_Run1/2017-06-20_10-35-25/ladybug_panoramic_000‌000.jpg,JPG,0,285833‌39722,1181983021.108‌2721,3922148.9627709‌221,604199.614461860‌27,4976781.334698205‌8,-177.5736892226599‌7,7.1055832760669553‌,-79.315623440207304‌,1068

this is the header with one row with data, i am interested in mapping the ECEF(x) and ECEF(y) to a fitting EPSG code, or in some way getting it in. It should be in Germany, in the area Paderborn-Borchen area 

Reply
0 Kudos
Jayanta_Poddar
Honored Contributor

Could you attach a sample CSV for review?

Reply
0 Kudos
Bjornten_Broeke1
New Contributor

just emailed a example

Reply
0 Kudos
Jayanta_Poddar
Honored Contributor

my email-id is joypoddar.87@gmail.com

Reply
0 Kudos
Jayanta_Poddar
Honored Contributor

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.

Reply
0 Kudos