topic Re: Import ECEF WGS84 BLH in Arcmap? in Data Management Questions

Import ECEF WGS84 BLH in Arcmap?

Bjornten_Broeke1 — Wed, 05 Jul 2017 21:22:34 GMT

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

Re: Import ECEF WGS84 BLH in Arcmap?

JayantaPoddar — Wed, 05 Jul 2017 21:39:09 GMT

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

Re: Import ECEF WGS84 BLH in Arcmap?

Bjornten_Broeke1 — Wed, 05 Jul 2017 21:41:40 GMT

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 –

Re: Import ECEF WGS84 BLH in Arcmap?

JayantaPoddar — Wed, 05 Jul 2017 21:47:12 GMT

Could you attach a sample CSV for review?

Re: Import ECEF WGS84 BLH in Arcmap?

Bjornten_Broeke1 — Wed, 05 Jul 2017 21:51:34 GMT

just emailed a example

Re: Import ECEF WGS84 BLH in Arcmap?

JayantaPoddar — Wed, 05 Jul 2017 21:56:16 GMT

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

Re: Import ECEF WGS84 BLH in Arcmap?

JayantaPoddar — Wed, 05 Jul 2017 22:20:34 GMT

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.