
GRA008.TXT



gINT Rules Code Add-In menus Samples - 008



Requires gINT version 8.2.003 or later. gINT Logs cannot run gINT Rules but can access the code or the Add-Ins manager. gINT Logs Plus and gINT Professional have full access to both.



NOTE:  Code samples are provided free of charge and as-is.  gINT Software makes no claim or warranty as to the accuracy of the samples.  It is the responsibility of the user to ensure that the code performs as it should.  Comments, suggestions, and error reports are appreciated.



Description

===========

This Add-In reads latitude and longitude for each borehole and plots them in Google Earth. The icon and its color used to represent borehole are based on criteria in the code. Various attributes of each borehole are displayed when the user clicks on the icon in Google Earth. This project can accept latitude and longitude in decimal degrees, as text (e.g., 38°26'50.84"), or as components (one field each for degrees, minutes, and seconds). In your database you will probably only have one of three formats. Change the code in the sample project to only use the format in your database.



One of the attributes added shown in the Google Earth properties dialog for each PointID is a Web link to a PDF with the associated borehole log. You can do this with your own files by modified the code appropriately.



The Add-In also superposes project photos. These are displayed as camera icons facing in the direction of the photo.



If run from an Enterprise database, the data in the current project will be used.



Revision History

================

15Oct2010:

1. Code was put in to support Enterprise databases.

*************************************************



18Mar2009:

1. A slight modification of Google Earth's coordinates moved the points off of their proper locations. They were adjusted accordingly.

*************************************************



03Oct2008:

1. A typo in the previous revision caused the camera icons to be misnamed. This is fixed with this version.

*************************************************



30Sep2008:

1. Changed borehole icons from standard Google Earth icons to custom icons. These are included with the download.



2. Included placement of a logo at the lower right corner of the Google Earth screen.



3. Restructured code for better legibility and ease of modification.

*************************************************



10Sep2008:

Initial public upload

*************************************************



INCLUDED FILES:

GRA008.GLB:

  Add-Ins:   GRA008 - Runs the creation of the Google Earth file.



  gINT Rules code modules:

    GRA008:  Main

             GoogleEarthCoordinatesGetFailedFnB

             GoogleEarthPlotPhotosErrorFnB

             GoogleEarthPlotPointIDsErrorFnB

             ViewPointIDsInGoogleEarth



    GRA008 COMMON PROCEDURES:  RecordsetClose

                               TrueDepthFnD



36 camera icons facing different angles at 10 degree increments (0 to 350 degrees azimuth) are included for your own use.



The following icons are used for PointIDs of different types:

  cored_hole.png

  cpt.png

  dynamic_probe.png

  soil_borehole.png

  test_pit.png

  unknown.png

  window_sampler_hole.png

*************************************************



INSTALLATION PROCEDURE:

Copy the files wherever you wish.  To see the gINT Rules Add-In and code module you must either merge the GLB into your library (Utilities:Lib Merge/Copy) or change to the included library (File:Change Library).

*************************************************



SPECIAL NOTES:

See the DESCRIPTION section above for detailed usage instructions.

*************************************************