The Workshop‎ > ‎

The CRevol2 Collaborative Geospatial Database

Please Share your Data!


The success of the workshop outcome will depend in part on the willingness of contributors to share data. To facilitate this, we are compiling published and unpublished geochronological data in a spreadsheet that will support a point dataset viewable in Google Earth. We are also developing datasets that relate to places and outcrops of interest and can also add geologic map overlays. The geochronologic data compilation effort was initiated as part of the 2000 Workshop and our goal is to update and expand it with relevant data generated in the intervening 10 years. All of the data with a geospatial component will be viewable in Google Earth because it allows for an efficient and visually appealing means of exploring geological information.

If you are the creator of any new data, we are asking for you to seriously consider sharing it with the workshop group. We are also asking that you help us with data entry if your schedule allows. 

Below are examples of the presentation of tabulated geochronological data in Google Earth and Google Maps. This format was created quite simply from an Excel spreadsheet and some novel Google tools (Fusion Tables in this case). 







Using this format, all of the relevant data regarding each data point is shown by clicking on the balloon (note: does not have to be a balloon, can easily change to other type of point symbol). This is a nice way to quickly peruse all of the data in one place. It can also be symbolized to reflect geochron method, age-range, etc. This version is the output of a very basic kml file. 

What is kml? 


It stands for 'keyhole markup language', and it is the coding that is used to display content in Google Earth. 

Really want to know? Then follow this link: http://code.google.com/apis/kml/documentation/kml_tut.html

Kinda want to know? Follow this one: http://en.wikipedia.org/wiki/Keyhole_Markup_Language


How You Can Share Your Data


Method 1.

Create spreadsheet identical to the one below in the program of your preference, add your data, and email it to Sue Priest (spriest@usgs.gov).



(click the image above to enlarge)


If you feel strongly that a new column with a specific attribute is required, please send a request to Sue Priest. If your contribution is unpublished, please indicate so in the Reference column.


Method 2.

Bring your data (in WGS84 Decimal degree format) to the workshop and ask for help. 



Getting your data in the proper format


*Geospatial (location) data need to be in Decimal Degrees based on WGS84 or NAD83 Datum*


In order to include new data, the coordinates of the site (if the data can be encapsulated at a single site) must be in Decimal Degrees relative to the WGS84 datum (NAD83 is okay too). 

This is essential. Below is a link to the National Geodetic Surveys coordinate conversion program:

http://www.ngs.noaa.gov/cgi-bin/nadcon.prl

Link to UTM/Lat-Long Conversion tool:


If you are an ArcGIS user and have data in *.shp format or in a geodatabase feature class, it is possible to export the data (once selected) and save in a specified coordinate and datum format. Once this is done, the *.dbf file created in the export process will contain a table with the new values. 

There is also a handy spreadsheet (excel) conversion program that can be downloaded here: 


Before you download, however, you may want to read the background information here:


Note that I (Kyle) have used the spreadsheet recently with great success.

Other Types of Data


Key Places / Locations / Placemarker

You are probably familiar with placemarks in Google Earth, right? If not, investigate this link: Marking and Saving Places in Google Earth

Because we plan to use kml files in Google Earth (GE) as the primary means of basic data visualization, it is possible to accomodate a variety of data types. For example, if you have names of specific places (e.g. outcrops, river km / miles) that you are sure are of value to the larger group, it is simple to add  placemarkers, then create a kml file of your own in GE and send it to us for display (or editing) at the workshop. To retain 'authorship' of these data types, enter your initials in the description box while creating the point. Also, use your last name in naming the folder.

It is simple to make and save placemarks. Once you have made them, right-click on the layer and save them in a kml file. Send that file to pkhouse@gmail.com


Outcrop photographs or Strat Columns

It is possible to include geotagged photographs or diagrams in GE. If you have any of these that you think are particularly important and they are available online, it is possible to add them to a kml file that is viewable in GE. Check, for example, this link:

Also, you can live the dream by downloading the kmz file here: Link to Photo kml




The key to making this work is to geotag your photographs / images. Geotagging is a process of encoding the image's exif header with geographic coordinates. Most online photo storage and display sites (e.g. Flickr; Picasa; SmugMug) recognize and map photos with geotags. It is possible to manually geotag photos in Picasa after a tiny bit of research.

Bottom line, if you are in possession of some key outcrop or sample photos that are geotagged or can be easily affixed to a location using Google Earth, let us know if you want it added to the collaborative geospatial dataset. If those photos are geotagged and available online already, please send the url to pkhouse@gmail.com.


Comments