How to download data for use in Excel and Google Earth

  1. How to obtain deposit information
  2. How to link to Google Maps and Google Earth
  3. How to make a PDF map
  4. How to download data for use in Excel and Google Earth
  5. How to Download JORC Data

These instructions detail the steps to produce an Excel spreadsheet or Google Earth file of mineral occurrences for a particular commodity.

  1. Click on the 'Quick Search' link as shown below in Figure 1.
  2. Figure 1 Image

  3. Click the 'Mineral Occurrences' tab shown in Figure 2, then click 'Commodity Type'. Type the name of the commodity you wish to search for, for example 'copper', and then click the 'Search' button. This process may take a minute or two.
  4. Figure 2 image

  5. The returned results will look similar to Figure 3. Click the check box in the top-left corner to select all records and a confirmation note will pop up. Select OK.
  6. Figure 3 Image

  7. Your screen should now look like Figure 4, with all boxes checked and the Download button now available. Click the Download button.
  8. Figure 4 Image

  9. In the following screen, Figure 5, check which file formats you would like and then click Download. (CSV is a spreadsheet file that can be opened in Excel and KML can be opened in Google Earth).
  10. Figure 5 Image

  11. A File Download window will pop up Figure 6. Click Save.
  12. Figure 6 Image

  13. Select an appropriate filename and location, Figure 7. Click Save.
  14. Figure 7 Image

  15. The files are automatically saved in zip format, which you will need to unzip to access. To unzip, right-click on the file and select 'Extract Here' as shown in Figure 8. This will unzip the files into your current folder.

    Alternatively, depending on your computer set-up, you may be able to simply double click the zip file and then double click the CSV or KML file to open them in Excel or Google Earth.
  16. [Note - this example is extracting mineral occurrences for which there are over 100 000 in Australia. Mineral occurrences are recorded instances of a mineral commodity having been observed. By comparison, mineral deposits represent that subset of mineral occurrences for which mineral resources for major commodities have been delineated at some stage. There are around 3 000 such mineral deposits in Australia and data for these, including the various classes of the current mineral resources are downloaded via the Advanced Query tab. These mineral deposits are stored in Geoscience Australia's OZMIN database and also include operating and historical mines.]

    Figure 8 Image

  17. The extracted file list will look similar to Figure 9. The csv file can be opened in Excel as a spreadsheet as shown in Figure 10. The kml file can be opened in Google Earth, as shown in Figure 11 and a fly around from occurrence to occurrence can be commenced.
  18. Figure 9 Image

    Figure 10 Image
    Figure 10 Large Image

    Figure 11 Image
    Figure 11 Large Image

Mapping Quick Search Australia's Identified Mineral Resources Education Downloads History Links User Guide