Geofumed – GIS – CAD – BIM resources

Importing coordinates into Google Earth

This time we will see how to import coordinates to Google Earth, this is a plantation of African Palm, raised in the rustic (rural) cadastre.

image

The file format

If what I have is a file raised with GPS, the important thing is to understand that Google Earth requires that the data be converted to .txt or .cvs format. For this, if I have the coordinates in Excel, I can save them in this format.

The coordinate format

Google Earth only supports Geographical coordinates (latitude longitude) and of course those must be in WGS84 which is the datum that Google Earth supports, it can also carry a description. If I open the text file with the notebook, I have the following information:

77,-87.1941,15.6440
78,-87.1941,15.6444
79,-87.1938,15.6457
80,-87.1929,15.6459
81,-87.1926,15.6409
82,-87.1923,15.6460
83,-87.1917,15.6460
84,-87.1912,15.6438
85,-87.1909,15.6458
86,-87.1908,15.6446
87,-87.1907,15.6447
88,-87.1905,15.6406
89,-87.1905,15.6423
90,-87.1904,15.6437
91,-87.1947,15.6455
92,-87.1946,15.6456

The first column is the point number (I have assumed it but it is not real or consecutive), the second is the length (coordinate x) and the third is the latitude (coordinate Y), all are separated by commas. Be careful, you have to be clear that the more decimals you assign, the more accurate it will be because in geographical coordinates the truncation is quite significant.

How to import it into Google Earth

To do this is required Google Earth Plus, (costs $ 20 per year) or a parrot in the back.

to import them select "file / open" and then use the option "txt / cvs" and find the file where it is stored

image

From the screen you have to indicate that the text is delimited, that this delimitation is commas, then you click on the "next" button

imageNow you have to indicate which is the latitude and which is the longitude. There is an option to assign postal addresses, but we will see that later.

Then you have to press the "next" button, then "back", then "back" and "end"

And Ready, to change the color and size of the icon, right-click on the folder and then choose properties.

image

For other options, we previously saw a macro they do this same thing with UTM coordinates and also like Convert coordinates UTM to Geographic with Excel

15 comments

  • Rodolfo Martinez March, 2014 at

    I tried to create my own coordinates, but so far I have not been able to, I want to import these points:

    La Angostura 106 19'55 ″ N 23 25'54 ″ W
    El Bajío 106 13'03 ″ N 23 18'24 ″ W

    But I have not found the form, thank you.

  • g! October, 2012 at

    Use any program that converts from kml to dwg, there are several flying around. If not, use a GIS opensource program like gvSIG or QGis

  • Imer Villarrubia BATALLANOS October, 2012 at

    VERY GOOD

  • But I September, 2012 at

    Good day. Please tell me how to export the coordinates of google earth to autocad 2010.

  • g! July, 2012 at

    What do you mean elkin? To the article or to a comment?

  • elkin April, 2010 at

    by fabor are more flexible and make it easier for us novices

  • g! February, 2010 at

    I do not know if you still occupy it, but here I made a table similar to what you want

    http://geofumadas.com/convertir-a-decimales-grados-minutos-y-segundos/

  • SOBRETOWN February, 2010 at

    my esteem g! excuse my lack of knowledge you will have a program to be able to convert my coordinates to decimals quickly I am about time and that to convert adecimales one by one makes me complicated since I have a great series of coordinates I will thank you for your contribution.

  • g! February, 2010 at

    To upload them to Google Earth as txt, you must convert them to decimals

  • g! February, 2010 at

    And to which program you want to enter

  • SOBRETOWN February, 2010 at

    HEY URGENT ADVICE TO IMPORT COORDINATES FROM TXT FILE, HAVING AS INFORMATION THE COORDINATED MONITORS:
    24 59 48 N, 97 53 43 W
    24 59 45 N, 97 53 44 W
    24 59 42 N, 97 53 48 W
    24 59 41 N, 97 53 34 W
    24 59 36 N, 97 53 29 W
    24 59 30 N, 97 53 33 W
    24 59 24 N, 97 53 37 W
    24 59 15 N, 97 53 33 W
    24 59 04 N, 97 53 30 W
    24 59 02 N, 97 53 15 W
    24 58 59 N, 97 53 16 W
    24 58 58 N, 97 53 33 W
    24 58 57 N, 97 53 18 W
    24 58 54 N, 97 53 17 W
    24 58 51 N, 97 53 17 W
    24 58 50 N, 97 53 28 W
    24 58 46 N, 97 53 18 W
    24 58 39 N, 97 37 16 W
    24 58 38 N, 97 37 24 W
    24 58 38 N, 97 37 20 W
    24 58 38 N, 97 37 18 W
    24 58 37 N, 97 37 26 W
    24 58 35 N, 97 37 31 W
    24 58 35 N, 97 37 29 W
    24 58 34 N, 97 37 53 W
    24 58 34 N, 97 37 33 W
    24 58 27 N, 97 37 31 W
    24 58 25 N, 97 37 28 W

  • g! January, 2009 at

    I understand this is in the free version, download the latest version, and it should have those capabilities

  • chrisiam January, 2009 at

    But they do not sell the google earth plus version I do?

  • g! September, 2008 at

    To update it, within Google Earth you select:

    “help / update to Google Earth plus” then enter the username and password… if you don't have one, choose “buy google earth plus account”, it costs 20 dollars a year

  • Pedro Cea C September, 2008 at

    Excellent information but I currently have google earth basics, I do not know how to get the license for google earth plus, I would be grateful to be guided as this process is done

    very thankful

    Pedro, Osorno Chile

Leave a comment