Google Earth and gINT....what can I actually do?

Hi everyone,

We've got gINT Pro. We're interested in using gINT to start a Google Earth file of all our borehole coordinates....EVER. Naturally, this should be easy because all the data already exists in a database, right?

Right?

We survey our boreholes in UTM north/eastings, so the first thing that needs to happen (I think?) is that we need to convert to lat/longitude for Google Earth to import properly. Am I reading it right that we need gINT Pro Plus to do this conversion? And that it will only convert from lat/longitude to UTM and not the other way around? Which is useless anyways? 

So assuming that I can somehow easily import existing north/easting data into GEarth, I was told once upon a time that it's not a good idea to use gINT to create a master kml file of all your boreholes, ever. Why not? We've done this with our projects (manually...groan) and there are certainly massive kml files out there. The Government of Ontario has a kml file showing all its borehole locations available online. So...can we still not go it from gINT?

Confused,

Mike

Parents
  • The posts I was talking about to provided detailed instructions on creating kml files from gINT that contained links to PDF files of the logs (also generated out of gINT) and some of the settings in Goggle earth necessary to make this work.  I sent an e-mail to Pat C. asking him to bring them forward into this forum.  It is very pertinent to what Mike is trying to do.

    Using cut and paste to move things back and forth from excel to gINT is quick and dirty (and I emphasis dirty since there is a high potential for data offset errors or unintentional overwrite).  I have also used export and import to accomplish the same coordinate conversion as Dave suggests.  With this you can use an export correspondence file to directly create the exact file format needed by your batch coordinate conversion software and you can create an import correspondence file that directly reads the output file from the batch converter.  This eliminates some of the manual manipulation steps.  If you are going to do a lot of these this is probably the way to go.  Do whatever you are most comfortable with.

    No need to combine the projects in gINT.  Just generate a kml file for each project and then merge them into one folder using Google earth.  To do this use the following procedure.

    1. Once you have your WGS84 lat and long and all the appropriate google earth settings done in gINT, create a kml file by selecting view boreholes in Google earth.  It will ask you for a file name to store the kml file and and folder name to name the folder.  Type in a unique short name that identifies the project for the folder name.

    2. Once Goggle Earth comes up and displays your borings select your temporary places folder and select Add, Folder from the Google Earth menu and create a new folder called "composite" or something.  See the picture below.

    3. Drag the folder created by gINT into this new composite folder.  See the picture above

    4. Highlight the composite folder and select File, Save, Save place as from the google earth menu.  Select the file type to save as kml and provide a file name. See picture below

    5. As you generate more project kml files in gINT, simply open the composite kml file after gINT displays the project kml and drag the project kml folder into the composite and resave.  When you are done you will have a single kml file that contains one composite folder and manysub-folders representing each project.  You can toggle on and off the display of individual borings, each project, or the entire folder in the left menu.  See picture above.

    6. If you have included links to PDF files of the boring logs as described in the old posts referenced above, clicking on a boring will pop up a balloon with the link.  Clicking on the link will retrieve and display the log. See picture below.  the only issue with this is that the PDF files need unique names so if you name each pdf file using the boring number you are likely to have many "B-1.pdf" files from the numerous projects.  Thus with the composite file you will need to come up with a unique file naming convention for your pdf files and links to avoid problems.

    Hope this gives you some ideas.

Reply
  • The posts I was talking about to provided detailed instructions on creating kml files from gINT that contained links to PDF files of the logs (also generated out of gINT) and some of the settings in Goggle earth necessary to make this work.  I sent an e-mail to Pat C. asking him to bring them forward into this forum.  It is very pertinent to what Mike is trying to do.

    Using cut and paste to move things back and forth from excel to gINT is quick and dirty (and I emphasis dirty since there is a high potential for data offset errors or unintentional overwrite).  I have also used export and import to accomplish the same coordinate conversion as Dave suggests.  With this you can use an export correspondence file to directly create the exact file format needed by your batch coordinate conversion software and you can create an import correspondence file that directly reads the output file from the batch converter.  This eliminates some of the manual manipulation steps.  If you are going to do a lot of these this is probably the way to go.  Do whatever you are most comfortable with.

    No need to combine the projects in gINT.  Just generate a kml file for each project and then merge them into one folder using Google earth.  To do this use the following procedure.

    1. Once you have your WGS84 lat and long and all the appropriate google earth settings done in gINT, create a kml file by selecting view boreholes in Google earth.  It will ask you for a file name to store the kml file and and folder name to name the folder.  Type in a unique short name that identifies the project for the folder name.

    2. Once Goggle Earth comes up and displays your borings select your temporary places folder and select Add, Folder from the Google Earth menu and create a new folder called "composite" or something.  See the picture below.

    3. Drag the folder created by gINT into this new composite folder.  See the picture above

    4. Highlight the composite folder and select File, Save, Save place as from the google earth menu.  Select the file type to save as kml and provide a file name. See picture below

    5. As you generate more project kml files in gINT, simply open the composite kml file after gINT displays the project kml and drag the project kml folder into the composite and resave.  When you are done you will have a single kml file that contains one composite folder and manysub-folders representing each project.  You can toggle on and off the display of individual borings, each project, or the entire folder in the left menu.  See picture above.

    6. If you have included links to PDF files of the boring logs as described in the old posts referenced above, clicking on a boring will pop up a balloon with the link.  Clicking on the link will retrieve and display the log. See picture below.  the only issue with this is that the PDF files need unique names so if you name each pdf file using the boring number you are likely to have many "B-1.pdf" files from the numerous projects.  Thus with the composite file you will need to come up with a unique file naming convention for your pdf files and links to avoid problems.

    Hope this gives you some ideas.

Children
  • Szang,

    Good point about not needing to combine gINT project files in order to create a combined kml file. I have only needed to create kml files from one gINT project at a time and they were not related to each other so there was no need to combine.

    I think I recall the postings that you are referring to, they would be helpful. I believe the gINT Rule Add-In that I mention below covers some of the information that was in the old forum postings.

    Mike,

    The gINT Help file has a number of topics for using Google Earth from gINT. Enter "Google Earth" as the keyword when using the Index tab in the Help file. The "Google Earth Setup" topic has a lot of information.

    There is also a gINT Rule Add-In for creating kml files from gINT that provides a starting point for writing your own gINT Rule Add-In and it includes some camera icons and borehole icons to display on the Google Earth map. I strongly recommend checking out the example gINT Rule Add-In, even if you are not going to modify it to work with your own projects the example project helps illustrate what you can do with Google Earth and gINT.

    As a side note, if you are really ambitious you could create a gINT Rule that does the coordinate conversions.

  • Mind = blown. Thanks for all the input so far, everyone!

    1) I've found the gINT sample code and will play with it next week.

    2) a coordinate conversion gINT Rule?? I've found my Eleanor. Yes, that would do nicely....

  • Coordinate conversion -- Lat/Long to a long list of other coordinate systems or vice versa -- is a feature built into the gINT Professional Plus product.



  • www.uwgb.edu/.../UTMFormulas.htm

    Here's a free international spreadsheet for batch UTM conversion. It does everything. This page is referred to on other software pages, i.e. people refer to this math when they write their own black-box programs.