Trimble Business Center — Produce final deliverables in one workspace. Start free trial.

AI Assistant
Notifications
Clear all

Extract .jpg Location info from Cellphone to Import into Google Earth Pro

8 Posts
5 Users
2 Reactions
2,438 Views
field-dog
(@field-dog)
Posts: 1582
Member
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I want to plot storm structures from a drainage improvement project into Google Earth Pro in order to better visualize the project. I used the Extract GPS Coordinates from Photos (Latitude, Longitude, Altitude) to CSV, Excel, KML, GPX, GeoJSON | Coordinates Tools to extract latitudes and longitudes from my cellphone pictures. After cleaning up the information in Notepad I tried to import the file into Google Earth Pro without success, however individual lines were acceptable. What am I doing wrong? Is there an easier way to do this? Please see the attached file.

 

 


 
Posted : October 26, 2025 10:03 am
GaryG
(@gary_g)
Posts: 976
Member
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Whats the character after the degree ? Might need to strip those out.

28°27'31.35",-81°34'54.58


 
Posted : October 26, 2025 3:00 pm
Landbutcher464MHz
(@landbutcher464mhz)
Posts: 263
Member P&R
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

1.) Load the txt file into Excel and make 2 columns, Lat in A, Long in B. Save As CSV.

2.) Open Google Earth and  File > Import > Find the CSV file > Open.

3.) Select Lat and Long fields

4.) You are done.

EDIT: Added #3 and no need to strip out the A from the degrees. 


 
Posted : October 26, 2025 3:06 pm
1
jhframe
(@jim-frame)
Posts: 7477
Member Founder, Sustainer
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I use Xnview for this.  It's free for non-commercial use, a license is required for commercial use.  (If you figure out how to obtain a commercial license, let me know -- I haven't been able to figure that out.) Open the image file, then from the ribbon menu Metadata|Open GPS location in|Google Earth app and there's your placemark in Google Earth.  (Even though the menu item refers to "Google Earth app," it works on my desktop install of Google Earth Pro.)

 


 
Posted : October 26, 2025 4:05 pm
1
field-dog
(@field-dog)
Posts: 1582
Member
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

Posted by: @gary_g
↑

Whats the character after the degree ?

Don't know what happened on your end. The two-column file is:

28°27'31.35",-81°34'54.58"
28°27'31.67",-81°34'50.55"
28°27'17.08",-81°34'50.42"
28°27'31.50",-81°34'51.00"
28°27'31.44",-81°34'54.59"
28°27'31.57",-81°34'51.00"
28°27'14.32",-81°34'50.49"
28°27'29.94",-81°34'50.30"
28°27'14.36",-81°34'50.43"
28°27'14.50",-81°34'50.99"
28°27'31.21",-81°34'54.59"
28°27'31.43",-81°34'54.93"
28°27'29.85",-81°34'50.69"
28°27'16.73",-81°34'52.31"
28°27'17.29",-81°34'50.24"
28°27'16.94",-81°34'47.19"
28°27'17.24",-81°34'47.07"
28°27'14.27",-81°34'50.26"
28°27'13.61",-81°34'50.40"
28°27'13.94",-81°34'50.87"
28°27'17.05",-81°34'45.18"
28°27'31.36",-81°34'50.76"

 


 
Posted : October 26, 2025 5:28 pm

field-dog
(@field-dog)
Posts: 1582
Member
Topic starter
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

@jim-frame 

I downloaded Xnview, executed the program, and it immediately began to download all of my pictures from Microsoft OneDrive. I cancelled the download and deleted Xnview from my computer. I have to visit the Xnview forums and learn how to prevent Xnview from downloading all of my pictures without my permission.


 
Posted : October 26, 2025 5:46 pm
jhframe
(@jim-frame)
Posts: 7477
Member Founder, Sustainer
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I've been using Xnview for many years and have never had a problem of any kind, let alone a problem with OneDrive interaction.  I appear to have OneDrive installed -- there's an icon for it in the system tray -- but I've never used it, so that may be the reason Xnview hasn't tried to download anything from it.


 
Posted : October 26, 2025 9:13 pm
horseshoes-handgrenades
(@horseshoes-handgrenades)
Posts: 44
Free
Translate ▼
English
Spanish
French
German
Italian
Portuguese
Russian
Chinese
Japanese
Korean
Arabic
Hindi
Dutch
Polish
Turkish
Vietnamese
Thai
Swedish
Danish
Finnish
Norwegian
Czech
Hungarian
Romanian
Greek
Hebrew
Indonesian
Malay
Ukrainian
Bulgarian
Croatian
Slovak
Slovenian
Serbian
Lithuanian
Latvian
Estonian
 

I’ve used Geosetter to combine photos with location info into a KMZ. To get your desired results (just points?) I think you’d need to create those by hand with this method, but the photos in the KMZ could be your “connect the dots.” Being a Trimble user, I’d probably use TBC to import Lat/Longs and then export the KMZ to reach the desired result. 


 
Posted : October 27, 2025 2:00 pm