- Geoscience Australia
Contents
1. ez aAa 3 0 GERS Ss 5 Se z S Ch nOOM 8 ka EE ee amal ad o be B ad SE DODO 0 0 0 USERS GUIDE TO PETROG AGSO S PETROGRAPHY DATABASE Record 1994 36 R J Ryburn J Knutson M B Duggan L D Bond amp M S Hazell AUSTRALIAN GEOLOGICAL SURVEY ORGANISATION CANBERRA wu DEPARTMENT OF PRIMARY INDUSTRIES AND ENERGY Minister for Resources Hon David Beddall MP Secretary Greg Taylor AUSTRALIAN GEOLOGICAL SURVEY ORGANISATION Executive Director Harvey Jacka 0 0 0 0 0 Commonwealth of Australia ISSN 1039 0073 ISBN 0 642 21239 2 This work is copyright Apart from any fair dealings for the purposes of study research criticism or review as permitted under the Copyright Act no part may be reproduced by any process without written permission Copyright is the responsibility of the Executive Director Australian Geological Survey Organisation Inguiries should be directed to the Principal Information Officer Australian Geological Survey Organisation GPO Box 378 Canberra City ACT 2601 CONTENTS ABSTRACT 10 11 12 13 14 15 16 17 INTRODUCTION STRUCTURE OF THE OZROX FIELD DATABASE STRUCTURE OF PETROG SITE AND SAMPLE NUMBERING SECURITY AND ACCESS MENU SYSTEM THE SITES FORM THE ROCKS FORM THE PETROGRAPHY FORM THE PETROGRAPHY DATA TYPES FO2. 6 6 0 0 O 1 chemical sediment 12 metabasite 13 felsic 56 14 metasediment 15 metasomatite 16 ore 17 regolith Lithology Oualifier OUALIFIER A 20 character optional field for the gualifying term if any before the Lithology Name field that follows An abbreviation may be entered in the associated short field that automatically retrieves the full term The full term is what is stored in the ROCKS table The gualifying term must be in the NGMA LITHNAMES authority table and classified as Type O for qualifier An example of a Qualifier is pelitic abbreviation PEL as in pelitic schist Valid lithology qualifiers may be selected from a pop up list obtained by pressing LIST Lithology Name LITHNAME A 32 character optional field for a lithology name An abbreviation may be entered in the associated short field to fetch the full term but the full term is what is stored in the ROCKS table Only names already in the NGMA LITHNAMES authority table and classified as Type of IM or S igneous metamorphic sedimentary may be entered Valid lithology names may be selected from a pop up list obtained by pressing LIST Stratigraphic Unit STRATNO The name of the stratigraphic unit pointed to by the STRATNO number field in the ROCKS table This name comes from the Stratigraphic Lexicon STRATA STRATLEX Informal names from the INFORMAL field in ROCKS are not displayed in the Petrography Form THIN SECTI
3. Occurrence Mode MINOCCMODE An optional field for an abbreviation of up to 4 capital letters indicating a mode of occurrence of the stated mineral or other component The abbreviation entered is validated by the TSMINOCCMODES table the name corresponding to the abbreviation is automatically displayed in the next field A pop up list of available occurrence modes can be viewed by pressing LIST Occurrence mode is needed to distinguish between more than one possible type of occurrence guartz clasts guartz overgrowths and guartz cement for example or groundmass K feldspar versus K feldspar phenocrysts In sedimentary rocks where a mineral like guartz has been used to indicate a monomineralic clast type the occurrence mode should always be set to CL for clast Otherwise detrital kyanite could be mistaken for a metamorphic zone indicator when used for plotting in a GIS system Petrographic terms for occurrence modes are many and varied and the present list will be greatly expanded in time A selection of some occurrence modes is listed below Abbreviation Occurrence Mode AM amy gdaloidal AU authigenic BI biogenic CM cement CL clast CR cryptocrystalline GR granular GM groundmass IN inclusion MX matrix MG microgranular MC microlite OO oolitic OG overgrowth BL pellet PH phenocryst PB porphyroblast RP replacement XC xenocryst XL xenolith Comments COMMENTS An optional field of 64 characters for comm
4. a x 12 THE AGSO MINERALS FORM setup Help Count ig lt Replace gt Figure 11 The AGSO Minerals Form The AGSO Minerals Form gives access to the NGMA AGSOMINERALS table which currently contains an authoritative list of 776 mineral names likely to be encountered in the course of routine and some not so routine geoscience This list combined with that in TSCLASTYPES see next page is used to validate entries into the Minerals or Clasts field of the Petrography Form Although a part of OZROX this form is of egual or greater valne to PETROG and is appropriately described in this guide The custodian of the NGMA AGSOMINERALS table is Morrie Duggan Xtn 9284 Mineral ID MINABBREV A mandatory field of up to 4 capital letters for an abbreviation for a mineral name e g QZ for quartz The abbreviation must be unigue and should be as short as possible with the shorter IDs going to the more common minerals Note that this field is of potential benefit in providing abbreviations suitable for use on computer plotted graphs and diagrams such as phase diagrams Mineral Name MINNAME A mandatory field of up to 32 characters for the name of the mineral e g Glaucophane First letters of all names are in upper case Common COMMON An optional one character field with C for common minerals Ore ORE An optional one character field with O for ore minerals Australian Geological Surve
5. ROCK NAME Graphite schist COMMENTS Sefton Metamorphics Iron Range DATA TYPE SUBTYPE DESCRIPTION Metamorphic Tex crenulated Grain Size very fine Metamorphic Tex schistose Metamorphic Gra chlorite MINERAL NAME VOLS COMMENTS Quartz 30 fine grained sutured boundaries Muscovite 30 finely laminated Graphite 20 finely laminated Carbonate LO Opaque Mineral 2 SAMPLEID 92836410B ROCK NO 15 LITH NAME schist NAME L OUAL graphitic DESC fine grained crenulated banded graphitic schist STRAT UNIT Sefton Metamorphics TS NO 16 ROCK NAME Graphite Schist COMMENTS Drillhole sample from Iron Range area m O co i ne ie i emm DATA TYPE SUBTYPE DESCRIPTION Alteration sericitic pervasive in feldspar Alteration carbonate minor Grain Size very fine quartz up to 0 3 mm across in coarser lamellae Metamorphic Tex crenulated defined by mica and graphite Alteration hematitic associated with graphite and pyrite minor MINERAL NAME VOL COMMENTS Sericite 25 replacing feldspar Quartz 20 interlocking grains in guartz rich lamellae Graphite 20 crenulated and intergrown with muscovite and sericite Plagioclase 15 some alteration to sericite and carbonate Muscovite 10 crenulated Carbonate 3 replacing feldspar Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 37 Carbonate 2 infilling stringer veins Pyrite z minor page break AGSO Petrography Database 01 Jul 1
6. SITESIDS SITESUSERS SITESPROVS SITESSUBPROVS SITESHMAPS SITESOMAPS SITESDLATS SITESDLONGS SITESSTRUC SITESSC SITESRP SITEOZCHRON SITESOZMIN SITESRTMAP ON ON ON ON ON ON ON ON ON ON ON ON ON ON ON GRANIT SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES SITES OPTION ORIGNO SITEID SITEID ENTEREDBY GEOPROVNO SUBPROVNO HMAPNO OMAPID DLAT DLONG ST REM USITES IS THE INSERT UPDATE VIEW OF THE SITES TABLE CREATE VIEW USITES AS SELECT FROM SITES WHERE ENTEREDBY USER GRANT SELECT INSERT UPDATE DELETE ON USITES TO PUBLIC REM ROCKS IS FOR DATA ON LITHOLOGIES AND SAMPLES CREATE TABLE ROCKS ROCKNO ORIGNO SITEID SAMPLE ID ROCKTYPE QUALIF IER LITENAME GROUPING STRATNO INFORMAL AGE STRATHEIGHT EOLEDEPTH HOLEDEPTH2 DESCRIPTION OTHERINFO ENTERE DEY ENTRYDATE FOREIGN KEY ORIGNO SITEID REFERENCES SITES ORIGNO SITEID NUMBER NUMBER CHAR CHAR NUMBER CHAR CHAR NUMBER NUMBER NUMBER NUMBER CHAR CHAR CHAR DATE 6 NOT NULL PRIMARY KEY 5 0 NOT NULL REFERENCES ORIGINATORS 16 NOT NULL 16 2 0 20 32 50 5 0 64 54 8 3 8 8 64 64 8 NOT NULL NOT NULL REFERENCES ROCKTYPES REFERENCES LITHNAMES REFERENCES LITHNAMES REFERENCES STRATA STRATLEX GRANT SELECT ON ROCKS TO PUBLIC GRAN
7. To guery AGSO s Reference Database by Ref ID authors year etc press NEXT BLOCK to position the cursor in the Authors or Reference Block then press ENTER OUERY to obtain a pop up guery form Enter your guery information in this form then press EXECUTE OUERY to retrieve one or more reference to the underlying form Make your guery criteria as specific as possible to speed retrieval Single author gueries are slow if there are many references by that author Use NEXT RECORD to scroll through more than one reference and NEXT KEY to transfer the Reference ID of the currently displayed reference to the top block to which a Rockno must be added In this way pre existing references in the References Database may be attached to rock samples To prevent the entry of duplicate references the form insists that you guery the Reference Database before you can enter a new reference or update an existing one Having done so though you are free to enter or update more than one reference The onus is on the user to try to prevent the duplication of references in the shared database a percentage duplicated records is inevitable To obtain the Reference Insert Update Form press INSERT RECORD when the cursor is in the top block Enter and commit the required reference The same procedure may be used to update existing references but only those references belonging to you the entry form will only display references with your Oracle user name attache
8. O O emm A GM O O gn O wem A MA AA APNO MAO O O wm e wm NN O Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 38 G S 9 9 9 9 e
9. SQL Menu login screen After entering your Oracle username and password the first menu screen is displayed This currently looks like this ME Terminal to o AVION Application NEMA Figure 4 The Main Menu for AGSO s Geological Database System This menu gives access to nearly all areas of AGSO s Geological Field and Laboratory Database system Selecting item 20 in the menu or pressing the EXIT function key takes you back to the UNIX prompt Item 9 puts you into the SOL Plus command line environment without Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 9 having to log into Oracle again To engage the PETROG database menu just enter 5 or move the highlight bar down to item 5 then press ENTER The following screen appears 0 Terminal to AVION Bile Edit Transmit EE Ee E Figure 5 The Petrography Database Menu This menu allows you to engage all the forms and the report program relating to the Petrography Database as well as the menus for the OZROX Field Database To run the OZROX Sites or Rocks Forms for example first select item 1 in the menu Selecting item 10 returns you to the Main Menu All the screen forms and report relevant to the PETROG Database and accessible from the above menu are now described including the Sites Rocks References and AGSO Mineral Forms from the Field Database Refer to The Users Guide to the NGMA Field Database Ryb
10. LOCMETHODS NGMA ROCKTYPES NGMA LITHNAMES NGMA LITHDATATYPES NGMA AGSOMINERALS NGMA ROCKDATATYPES STRATA GEOPROVS STRATA STRATLEX STRATA GEOTIME CONTENTS CUSTODIAN contributors of data Murray Hazell list of valid countries Rod Ryburn list of valid Australian States Rod Ryburn Australian 1 250 000 map sheets Murray Hazell Australian 1 100 000 map sheets Murray Hazell spatial location methods Richard Blewett basic classification of rock types Lesley Wyborn lithological names Jan Knutson extendable lithological attributes P Stuart Smith mineral names Morrie Duggan view of lithdatatypes agsominerals union Australian geological provinces D Palfreyman Australian stratigraphic names Cathy Brown geological time scale John Laurie Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 3 As a general rule only the designated custodians are permitted to change the data in these tables Full definitions of all tables indexes and views used by the OZROX Field Database are given in the appendix to Ryburn 6 al 1993b 3 STRUCTURE OF PETROG As indicated in Figure 3 PETROG consists of three main data tables and three validation tables As its name implies the central data table is THINSECTIONS which holds one record for each thin section in the database In addition to the many to one link shown to NGMA ROCKS THINSECTIONS is also tied to NGMA SITES by the inclusion of a Site ID TSATTRIBS
11. R J in prep Users guide to the Stratigraphic Authority Database Australian Geological Survey Organisation Record Ryburn R J Blewett R S Stuart Smith P G and Williams P R 1993b Users guide to the NGMA Field Database Australian Geological Survey Organisation Record 1993 49 Ryburn R J Page R W amp Richards J R 1993a Users guide to the OZCHRON Database of Australian Geochronology Australian Geological Survey Organisation Record 1993 11 Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 29 APPENDIX A DATABASE DEFINITIONS REM THE PRIMARY AND FOREIGN KEY REFERENCES DEFINITIONS IN REM CREATE TABLE STATEMENTS ARE A FEATURE OF ORACLE VERSION 7 REM AND ARE IGNORED BY ORACLE VERSION 6 DOCUMENTATION ONLY REM ttkkkikkkkkkkkkkkkkkkikkkkkkkkkkkkkkkkkkkkkkkkkkkkakkkakikakkkkkkkokkkikik REM THE FOLLOWING TABLES VIEWS AND INDEXES BELONG TO NGMA OZROX 7 REM kktkkkkkkkkkkkkkkkkikkkkikkkkkikkkkkakkkikkkkkikkkkikkkkikkkki kkkkkkktkikika REM SITES IS FOR GROUND POINT LOCATIONS ACCURACY amp LINEAGE CREATE TABLE SITES ORIGNO NUMBER 5 NOT NULL REFERENCES ORIGINATORS SITEID CHAR 16 NOT NULL FIELDID CHAR 16 OBSDATE DATE OBSTIME NUMBER 4 2 COUNTRYID CHAR 3 NOT NULL REFERENCES AGSOCOUNTRIES STATE CHAR 3 REFERENCES AGSOSTATES GEOPROVNO NUMBER 3 REFERENCES STRATA GEOPROVS SUBPROVNO NUMBER 5 REFERENCES STRATA GEOPROV
12. abbreviation for a thin section component e g MX for matrix Component Name CLASTNAME A mandatory field of up to 32 characters for the name or description of the thin section component e g intermediate volcanic clasts Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 26 9 O 9 6 9 9 9 0 9 0 6 9 9 e 9 0 14 OCCURRENCE MODES FORM _ 1220 Terminal to AVION aphic intergrovth oundmass crogranular crolite metic litic ergrouth eene rr et O lt Replace gt DEZ Figure 13 The Mineral Occurrence Modes Form This form corresponds to the TSMINOCCMODES authority table housing occurrence modes of thin section minerals more correctly thin section components as occurrence modes of clasts and matrix are included Mineral species often occur in more than one form K feldspar may occur both as phenocrysts and in the groundmass or guartz can oceur as clasts and as cement In such cases different modes of mineral occurrence should be recorded and guantified in the Petrography Form as different components of the same thin section Similarly glaucophane can be a metamorphic indicator or a detrital mineral and it is important to distinguish between the two modes of occurrence in a manner that promotes reliable retrieval of information To illustrate we do not want occurrences of detrital glaucophane being used to map blues
13. be viewed by pressing LIST The TSDATATYPES view currently has the following attributes Abbreviation Attribute Name ALT Alteration CIX Carbonate Texture DIX Dolomitic Texture GS Grain Size ITX Igneous Texture MET Metamorphic Grade MTX Metarnorphic Texture REF Bibliographic Reference SOR Sorting STX Sedimentary Texture WEA Weathering Note that pointers to references are inserted by entering REF as an attribute and value and the Reference ID in the Description field Value SUBTYPE A mandatory field for an abbreviation of up to 4 capital letters referring to a value of an attribute in the TSDATATYPES view If the value exists its description is automatically displayed in the next field otherwise an error message appears at the bottom of the form A pop up list of available values for the attribute already entered in the current record may be displayed by pressing LIST For example the ALT or Alteration attribute presently has the following values Abbreviation Value Name PR propylitic AB albitic AL alunitic AR argillic CA carbonate CL chloritic EP epidotised GR greisen HM hematitic KA kaolinitic PO potassic PY pyritic SE sericitic SP serpentinised SI silicified SK skarn ZE zeolitic Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 17 This system allows new attributes and values to be added to the TSDATATYPES by the custodian as and when required Note ho
14. s Petrography Database 4 The validation or lookup tables shown in Figure 3 limit possible entries into the data tables to defined sets The TSDATATYPES table validates entries into the TSATTRIBS table only attributes and values listed in TSDATATYPES can be entered into TSATTRIBS Entries into the TSMINERALS table are controlled by a view called TSMINCLASTS which is a union of the validation table NGMA AGSOMINERALS with the TSCLAS TYPES table for detrital clast nomenclature This emulates a single table listing clast types first followed by mineral names Not shown in figure 3 is the NGMA ORIGINATORS table which validates originators entered in THINSECTIONS ORIGINATORS lists the names and numbers of all Originators of rock samples The Originator Number is an essential component to the identification of all sites and samples see section 4 and is present with the Site and Sample ID in the THINSECTIONS table The tables used by PETROG and their contents are listed below The Oracle owner of each table is indicated by the part of each table name before the decimal point TABLE OR VIEW CONTENTS PETROG THINSECTIONS thin section data including ID and rock name PETROG TSATTRIBS extendable attributes of a thin section as a whole PETROG TSMINERALS mineral or clast components of the thin section NGMA ORIGINATORS list of valid originators for THINSECTIONS PETROG TSDATATYPES list of valid attributes and values for TSATTRIBS PETROG TSMINOCCMODE
15. to views of the tables The insert update versions of the forms which correspond to the insert update vlews in the database only allow access to records in which the ENTEREDBY field has their personal Oracle username Owners Access Rights The Oracle user known as PETROG has complete privileges on all the tables it owns in the Petrography Database as does the user NGMA in the OZROX Field Database In other words these users are the owners of their respective databases However once a database has been locke in the production environment all changes affecting the structure of tables and views must first be submitted by the owner to the database administrator via the change control directory see Kucka 1994 Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 8 6 MENU SYSTEM Access to OZROX and PETROG is via a tree structured menu system This provides access to SQL Plus some reporting programs and nearly all screen forms associated with the AGSO Geological Database System Most ad hoc queries data inserts and updates are done via screen forms although you should also know that batch retrievals and updates are often done via SQL Plus see Lenz et al 1993 To run the menu type nema lt ENTER gt after logging into the AVION UNIX environment and specifying your terminal type This automatically puts you into the Oracle production environment and brings up the
16. 0 0 0 o 0 0 REM TSMINOCCMODES IS THE VALIDATION TABLE FOR MINERAL OCCURRENCE MODES CREATE TABLE TSMINOCCMODES OCCABEREV CHAR 4 NOT NULL OCCNAME CHAR 32 NOT NULL GRANT SELECT ON TSMINOCMODES TO PUBLIC REM ROCKMINSITES IS A VIEW COMBINING SITE ROCK THIN SECTION amp MINERAL DATA REM MAY BE USED FOR ARCINFO PLOTTING OF ROCK TYPES AND THIN SECTION MINERALS REM YEILDS ONE RECORD PER MINERAL OR ONE PER THIN SECTION IF NO MINERALS NOTED CREATE VIEW ROCKMINSITES AS SELECT SITES ORIGNO ORIGNO SITES SITEID SITEID SITES COUNTRYID SITES STATE SITES GEOPROVNO SITES SUBPROVNO SITES DOMAINNO SITES HMAPNO SITES QMAPID SITES EASTING SITES NORTHING SITES ACCURACY SITES DLAT SITES DLONG ROCKS SAMPLEID SAMPLEID ROCKS ROCKTYPE ROCKS QUALIFIER ROCKS LITHNAME ROCKS GROUPING ROCKS STRATNO ROCKS AGE THINSECTIONS THINSECTID THINSECTIONS ROCKNAME TSMINERALS MINERAL TSMINERALS PERCENT FROM NGMA SITES NGMA ROCKS PETROG THINSECTIONS PETROG TSMINERALS WHERE SITES ORIGNO ROCKS ORIGNO AND SITES SITEID ROCKS SITEID AND ROCKS ORIGNO TEINSECTIONS ORIGNO AND ROCKS SAMPLEID THINSECTIONS SAMPLEID AND THINSECTIONS TSNO TSMINERALS TSNO H GRANT SELECT ON ROCKMINSITES TO PUBLIC Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 35 APPENDIX B EXAMPLE REPORT The followi
17. 6000 9 THE PETROGRAPHY FORM KS Terminal to AVILON D 28261108 ot Crenulated banded ra PM ALERE P with graphite and pyrite Bir in feldspar Mi to 4 3 mm across in coarser amp S Figure 8 The Petrography Form The Petrography Form encompasses almost all the information that needs to be recorded about a thin section of a rock including pointers to any relevant references in AGSO s Shared Bibliographic Reference Database The form has four blocks corresponding to four tables the NGMA ROCKS table from the OZROX database and the THINSECTIONS TSATTRIBS and TSMINERALS tables from PETROG The master block is the ROCKS block as a rock sample can give rise to more than one thin section In other words the THINSECTIONS block is a detail of the ROCKS block The TSATTRIBS and TSMINERALS blocks are in turn both detail blocks of the THINSECTIONS block A thin section may have any number of attributes and any number of component minerals or clasts The ROCKS and THINSECTIONS blocks are joined by a combination of Originator Number ORIGNO and Sample ID SAMPLEID whereas the THINSECTIONS block is joined to TSATTRIBS and TSMINERALS by the Thin Section Number TSNO ROCKS BLOCK The Rocks Block is for query purposes only and is automatically in query mode when the form is first invoked You normally use the Petrography Form by first executing a guery in the Rocks Block as to the sample or samples reguired D
18. 994 09 19 AM Page SAMPLEID 92836410C ROCK NO 16 LITH NAME schist NAME L OVAL DESC graphitic schist minor iron staining STRAT UNIT Sefton Metamorphics TS NO 17 ROCK NAME Graphite Schist COMMENTS Sefton Range Metamorphics DATA TYPE SUBTIPE DESCRIPTION Alteration hematitic associated with graphite Alteration sericitic Grain Size fine Metamorphic Tex crenulated mmm emm ee OH UH SME AH A SAM AH MM SAM AH MM AH ZM eee MINERAL NAME VOL COMMENTS Hematite assoclated with graphite and pyrite Ouartz 30 Sericite 20 crenulated and interleaved with graphite Muscovite 20 orenulated and interleaved with graphite Graphite 15 Carbonate 10 secondary Pyrite 1 closely associated with graphite SAMPLEID 92836410D ROCK NO 17 LITH NAME schist NAME L OUAL DESC chlorite rich rock with abundant iron staining STRAT UNIT Sefton Metamorphics TS NO 19 ROCK NAME Chlorite Schist COMMENTS Sefton Metamorphics DATA TYPE SUBTYPE DESCRIPTION Metamorphic Tex foliated Metamorphic Tex boudinaged carbonate Grain Size medium fine grained quartz carbonate up to 1 2 mm Alteration hematitic minor iron staining Metamorphic Gra chlorite MINERAL NAME VOL COMMENTS Ouartz 30 fine grained grading into strongly deformed and sutured Chlorite 30 foliated wrapping around carbonate Carbonate 25 boudinaged Pyrite 5 foliated qk Ooo O m w dem ee tO em O OO op Y gg em mam emm ep O A
19. AR 8 GRANT SELECI ON ORIGINATORS TO PUBLIC CREATE UNIQUE INDEX ORIGNOS ON ORIGINATORS ORIGNO REM AGSO AUTHORITY TABLE OF MINERAL NAMES THEIR ABBREVIATIONS CREATE TABLE AGSOMINERALS MINABBREV CHAR 4 NOT NULL PRIMARY KEY MINNAME CHAR 32 NOT NULL COMMON CHAR 1 ORE CHAR 1 CREATE UNIQUE INDEX AGSOMINABBREVS ON AGSOMINERALS MINABBREV CREATE UNIQUE INDEX AGSOMINNAMES ON AGSOMINERALS MINNAME CREATE INDEX AGSOMINCOMMONS ON AGSOMINERALS COMMON CREATE INDEX AGSOMINORE ON AGSOMINERALS ORE GRANT SELECT ON AGSOMINERALS TO PUBLIC GRANT SELECT ON AGSOMINERALS TO PETROG WITH GRANT OPTION Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 32 09000 REM kk kakkikkakkkkkkkkkkkakkkkkkkkkkkkkkkkkkkkakkakkkkkkkkkkkkkahkkkkkhkhkk REM 7 THE FOLLOWING TABLES VIEWS AND INDEXES BELONG TO PETROG Ski REM kkkkakkkkkkkikkkkkikkaakkkkakkkkkkkkkakkkkkkikkkkkkkkkkikakakkkkikikiikkakih REM THINSECTIONS IS THE MASTER DATA TABLE FOR PETROG CREATE TABLE THINSECTIONS ORIGNO NUMBER 5 NOT NULL REFERENCES NGMA ORIGINATORS SITEID CHAR 16 NOT NULL REFERENCES NGMA SITES SITEID SAMPLEID CHAR 16 NOT NULL REFERENCES NGMA ROCKS SAMPLEID THINSECTID CHAR 16 TSNO NUMBER 6 NOT NULL PRIMARY KEY ROCKNAME CHAR 32 COMMENTS CHAR 64 ENTEREDBY CEAR 16 NOT NULL ENTRYDATE DATE NOT NULL GRANT SELECT ON THINSECT
20. IONS TO PUBLIC CREATE UNIQUE INDEX TSNOS ON THINSECTIONS THNO CREATE INDEX THINSECTIDS ON THINSECTIONS THINSECTID CREATE INDEX TSORIGSITES ON THINSECTIONS ORIGNO SITEID CREATE INDEX TSSITES ON THINSECTIONS SITEID CREATE VIEW UTHINSECTIONS AS SELECT FROM THINSECTIONS WHERE ENTEREBY USER GRANT SELECT INSERT UPDATE DELETE ON UTHINSECTIONS TO PUBLIC REM MAXTSNO IS A ONE ROW TABLE FOR KEEPING TRACK OF THE CURRENT HIGHEST TSNO CREATE TABLE MAXTSNO MAXNO NUMBER 6 GRANT SELECT UPDATE ON MAXTSNO TO PUBLIC REM TSATTRIBS IS THE EXTENDABLE ATTRIBUTES TABLE FOR THINSECTIONS CREATE TABLE TSATTRIBS TSNO NUMBER 6 NOT NULL REFERENCES THINSECTIONS DATATYPE CHAR 4 NOT NULL REFERENCES TSDATATYPES DATATYPE SUBTYPE CHAR 4 REFERENCES TSDATATYPES SUBTYPE DESCRIPTION CHAR 64 ENTEREDBY CHAR 16 ENTRYDATE DATE GRANT SELECT ON TSATTRIBS TO PUBLIC CREATE INDEX PATIRIBSNOS ON TSATTRIBS TSNO CREATE VIEW UTSATTRIBS AS SELECT FROM TSATTRIBS WHERE ENTEREBY lt USER GRANT SELECT INSERT UPDATE DELETE ON UTSATTRIBS TO PUBLIC Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 33 REM TSDATATYPE IS THE AUTHORITY TABLE FOR TSATTRIBS EXTENDABLE ATTRIBUTES TABLE CREATE TABLE TSDATATYPES DATATYPE CHAR 4 NOT NULL TYPEDESC CHAR 32 SUBTYPE CHAR 4 NOT NULL SUBDESC CHAR 32 GRANT SELECT ON TSDATATYPES TO PUBLIC CREATE U
21. NIQUE INDEX TSDATATYPES1 ON TSDATATYPES DATATYPE SUBTYPE CREATE UNIQUE INDEX TSDATATYPESZ ON TSDATATYPES DATATYPE REM TSMINERALS IS THE TABLE FOR A THIN SECTION S COMPONENT MINERALS OR CLASTS CREATE TABLE TSMINERALS TSNO NUMBER 6 NOT NULL REFERENCES THINSECTIONS TSNO MINERAL CHAR 4 NOT NULL REFERENCES TSMINCLASTS MINABBREV PERCENT NUMBER 3 1 OCCMODE CHAR 4 REFERENCES TSMINOCCMODES COMMENTS CHAR 64 ENTEREDBY CHAR 16 ENTRYDATE DATE GRANT SELECI ON TSMINERALS TO PUBLIC CREATE INDEX PETMINNOS ON TSMINERALS TSNO CREATE VIEW UTSMINERALS AS SELECT FROM TSMINERALS WHERE ENTEREDBY USER GRANI SELECT INSERT UPDATE DELETE ON UTSMINERALS TO PUBLIC REM TSCLASTYPES IS THE VALIDATION TABLE FOR CLAST TYPES AND MATRIX CREATE TABLE TSCLASTYPES CLASTABBREV CHAR 4 NOT NULL CLASTNAME CHAR 32 NOT NULL GRANT SELECT ON TSCLASTYPES TO PUBLIC REM TSMINCLASTS IS A VIEW OF A UNION BETWEEN NGMA AGSOMINERALS AND TSCLASTYPES REM THIS IS THE VALIDATION VIEW FOR ENTRIES IN THE TSMINERALS TABLE CREATE VIEW TSMINCLASTS AS SELECT MINABBREV MINNAME MIN MIN OR CLAST FROM NGMA AGSOMINERALS UNION SELECT CLASTABBREV CLASTNAME CLAST FROM PETROG TSCLASTYPES GRANT SELECT ON TSMINCLASTS TO PUBLIC Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 4 0 0 0 9 6 9 9 0 0 0 0 0 0 0 6
22. OG TSMINERALS PETROG UTSMINERALS From the menu special Insert Update versions of each form cover the above views The restrictions applying to the above views are the same in each case For example the view UTSATTRIBS of the TSATTRIBS table is defined as CREATE VIEW UTSATTRIBS AS SELECT FROM TSATTRIBS WHERE ENTEREDBY USER The word USER in the above statement is an Oracle function that returns the current Oracle username Each of the above tables has the mandatory field ENTEREDBY for the username of the person entering the data This scheme guarantees that the users see only Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 7 their own records in the insert update versions of the forms and only they or the data custodians can alter or delete them Users wishing to use SOL Plus to insert update or delete records in the above main tables or SQL Loader to load records from an ASCII file must use the above views Custodians Access Privileges All custodians have been given appropriate access privileges to the data or authority tables that they administer They may select insert update and delete all data in these tables via screen forms or from SOL Plus They cannot drop tables or alter the structure of tables Note that custodians use the Tead only forms to insert update and delete rows in the main data tables This is because their access privileges apply to the base tables not
23. ON BLOCK The Thin Section Block which corresponds to the THINSECTIONS table contains basic information about the thin section as a whole such as the ID of thin section and the lithological name of the rock The THINSECTIONS table is linked to the NGMA ROCKS table via the Originator Number and Sample ID displayed in the Rocks Block However the primary key for the THINSECTIONS table is the system supplied Thin Section Number TSNO which should not be confused with the user supplied Thin Section ID Thin Section ID THINSECTID An optional 16 character field for a user supplied number or other ID for the thin section This should correspond to whatever ID is written on the thin section The Thin Section ID is commonly the same as the Sample ID but it could be completely unrelated Where several thin sections are cut from one rock sample the Thin Section ID will change while the Sample ID remains unchanged Note that each thin section must occupy a separate record in the THINSECTIONS table Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 15 Thin Section Number TSNO A mandatory positive integer of up to 6 digits which is the primary key for the THINSECTIONS table and is what links the table to the TSATTRIBS and TSMINERALS tables The number is automatically inserted when a new THINSECTIONS record is committed This field may be entered by the user only in guery mode Entered ENTRYDA
24. RM THE BIBLIOGRAPHIC REFERENCES FORM THE AGSO MINERALS FORM THE THIN SECTION COMPONENTS FORM THE MINERAL OCCURRENCE MODES FORM THE PETROGRAPHY REPORT PROGRAM ACKNOWLEDGMENTS REFERENCES APPENDIX A DATABASE DEFINITJONS APPENDIX B EXAMPLE REPORT O Australian Geological Survey Organisation 1994 iil il 12 13 20 21 25 26 27 28 29 29 30 36 Users Guide to AGSO s Petrography Database li ABSTRACT PETROG AGSO s Petrography Database is a relational computer database of petrographic data obtained from microscopic examination of thin sections of rock samples The database is designed for petrographic descriptions of crystalline igneous and metamorphic rocks and also for sedimentary petrography A variety of attributes pertaining to thin sections can be recorded as can the volume proportions of component minerals clasts and matrix PETROG is one of a family of field and laboratory databases that include mineral deposits regolith rock chemistry geochronology stream sediment geochemistry geophysical rock properties and ground spectral properties for remote sensing All these databases rely on a central Field Database for information on geographic location outcrops and rock samples PETROG depends in particular on the Field Database s SITES and ROCKS tables as well as a number of lookup tables of standard terms ROCKMINSITES a flat view of PETROG s tables combined with the SITES
25. S DOMAINNO NUMBER 5 REFERENCES STRATA GEOPROVS GEOGAREA CHAR 64 LOCDESC CHAR 64 HMAPNO NUMBER 4 REFERENCES HMAPS OMAP ID CHAR 6 REFERENCES OMAPS EASTING NUMBER 8 2 NORTHING NUMBER 9 2 ACCURACY NUMBER 4 NOT NULL HEIGHT NUMBER 5 0 HEIGHTACC NUMBER 3 0 DLAT NUMBER 8 6 NS CHAR 1 DLONG NUMBER 9 6 EW CHAR EE METHOD NUMBER 3 NOT NULL REFERENCES LOCMETHODS BIBREF CHAR 3 REFERENCES GEOREF AGSOREFS AIRPHOTO CHAR 36 OC CHAR 1 OUTCROPS TABLE RO CHAR 1 ROCKS TABLE xf ST CHAR 4 STRUCTURE TABLE xf PE CHAR l PETROGRAPHY DATABASE RC CHAR 1 ROCKCHEM DATABASE OZ CHAR 1 k OZCHRON DATABASE 7 OM CHAR 1 ZE OZMIN DATABASE sc CHAR 1 STREAMCHEM DATABASE RT CHAR i REGOLITH DATABASE RE CHAR 1 Z ROCKPROPS DATABASE SP CHAR 1 ZE SPECPROPS DATABASE ENTEREDBY CHAR 8 NOT NULL ENTRYDATE DATE NOT NULL LASTUPDATE DATE PRIMARY KEY ORIGNO SITEID GRANT SELECT ON SITES TO PUBLIC Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 30 S 0 9 9 9 9 9 0900 00000 00e GRANT SELECT ON SITES TO PETROG WITE CREATE UNIQUE INDEX CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE CREATE INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX INDEX STTESUNIQUE
26. S list of valid occurrence modes for TSMINERALS PETROG TSCLASTYPES list of valid clast types for TSMINCLASTS NGMA AGSOMINERALS list of valid mineral names for TSMINCLASTS PETROG TSMINCLASTS union of AGSOMINERALS TSCLASTYPES a validation view for use with TSMINERALS PETROG ROCKMINSITES view joining SITES ROCKS THINSECTIONS and TSMINERALS for use by Arc Info PETROG MAXTSNO table for tracking TSNO in THINSECTIONS Full definitions of ali tables views grants and indexes belonging to PETROG are listed in the appendix to this guide The custodian for TSDATATYPES TSCLASTYPES and TSMINOCCMODES is Jan Knutson Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 5 4 SITE AND SAMPLE NUMBERING Tables m PETROG and the OZROX Field Database maintain original site and sample numbers with the help of an Originator Number Origno In most cases the sample number will be the same as the site number perhaps with one or two appended letters to distinguish several samples at the one site but sample numbers can be unrelated to site numbers If all sites and samples were from AGSO and had unigue registered numbers then the site and sample numbers would be suificient on their own However AGSO databases also contain data provided by universities State geological surveys companies and private individuals all of whom use their own numbering systems The Originator Number is needed to preserve uniguen
27. T SELECT ON ROCKS TO PETROG WITH GRANT OPTION CREATE UNIQUE INDEX ROCKROCKNOS ON ROCKS ROCKNO CREATE INDEX ROCKORIGSITES ON ROCKS ORIGNO SITEID CREATE INDEX ROCKSITES ON ROCKS SITEID CREATE INDEX ROCKORIGSAMPS ON ROCKS ORIGNO SAMPLEID CREATE INDEX ROCKUSERS ON ROCKS ENTEREDBY REM UROCKS IS THE INSERT UPDATE VIEW OF THE ROCKS TABLE Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 31 CREATE VIEW UROCKS AS SELECT FROM ROCKS WHERE ENTEREDBY USER GRANT SELECT INSERT UPDATE DELETE ON UROCKS TO PUBLIC REM LITEDATA IS THE EXTENDABLE ATTRIBUTES TABLE FOR ROCKS CREATE TABLE LITHDATA ROCKNO NUMBER 5 0 NOT NULL REFERENCES ROCKS DATATYPE CHAR 4 NOT NULL REFERENCES LITEDATATYPES DATATYPE SUBTYPE CHAR 4 REFERENCES LITHDATATYPES SUBTYPE DESCRIPTION CHAR 64 ENTEREDBY CEAR 8 NOT NULL ENTRYDATE DATE NOT NULL PRIMARY KEY ROCKNO DATATYPE SUBTYPE GRANT SELECT ON LITHDATA TO PUBLIC CREATE INDEX LDLITHNO ON LITHDATA ROCKNO CREATE INDEX LDUSERS ON LITHDATA USER REM ULITHDATA IS THE INSERT UPDATE VIEW OF THE LITHDATA TABLE CREATE VIEW ULITHDATA AS SELECT FROM LITEDATA WHERE ENTEREDBY USER GRANT SELECT INSERT UPDATE DELETE ON ULITEDATA TO PUBLIC REM ORIGINATORS IS THE AUTHORITY TABLE FOR ORIGINATORS CREATE TABLE ORIGINATORS ORIGNO NUMBER 5 0 NOT NULL PRIMARY KEY ORIGINATOR CHAR 22 NOT NULL OWNER CH
28. TE Mandatory date field for the date the current record was entered into the THINSECTIONS table The format is the default Oracle format of DD MMM YY e g 21 JUN 94 This field is automatically inserted by a trigger when a new record is committed The cursor can be moved into this field only when the form is in guery mode By ENTEREDBY Mandatory field of up to 8 capital letters for the Oracle Owner username of the current record This field 15 automatically inserted by a trigger when the record is first committed The cursor can be moved into this field only when the form is in query mode Rock Name ROCKNAME An optional uncontrolled 64 character field for a petrological name based on microscopic examination of the thin section The name entered here can be copied directly into the Lithological Description field DESCRIPTION of the ROCKS table by pressing the NEXT PRIMARY KEY function key Note however that this could result in a loss of information as the name originally entered in the ROCKS table is based on field observation and may include information not apparent in a single thin section e g basalt with sparse olivine nodules Use with caution Comments COMMENTS An optional 64 character field for any additional comments specifically about the thin section e g Section excludes all weathered rind material that are not covered by fields in the SITES or ROCKS tables or the two controlled blocks that fol
29. and ROCKS tables allows thin section and mineral data to be accessed from geographic information systems and plotted on maps This guide presents an overview of PETROG s infrastructure and describes in detail the menus and screen forms used to input and view the data In particular the definitions of most fields in the database are given in some depth under descriptions of the screen forms providing in effect a comprehensive data dictionary of the database The database schema with all definitions of tables views and indexes is contained in an appendix to the guide Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database ili 1 INTRODUCTION Petrography is the microscopic study of rocks usually in the form of thin transparent slices known as thin sections that are only 40 microns thick A geologist unable to classify a rock in the field will often conduct a later laboratory examination of a thin section of the rock under the microscope In this way the mineral composition microscopic structure and something of the history of the rock can generally be ascertained Although less amenable to numerical analysis petrographic information on rocks is often of egual or greater importance to the geologist than whole rock chemical analyses Over many years AGSO geologists have accumulated tens of thousands of petrographic descriptions mostly written on cards PETROG is intended
30. chist facies domains in a GIS system For this reason the clast mode of occurrence should always be added in the Petrography Form to mineral components that represent as a class of detrital grains The list contained in the TSMINOCCMODES table will undoubtedly need to extended at regular intervals The venerable art of petrography is peppered with esoteric terms applying to modes of mineral occurrence Contact the custodian Jan Knutson Xtn 9479 if you wish to add more terms Occurrence Abbreviation OCCABBREV A mandatory field of up to 4 capital letters for an abbreviation for an occurrence mode e g PH for phenocrystic Occurrence Name OCCNAME A mandatory field of up to 32 characters for the name or description of the mode of occurrence e g groundmass Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 27 15 THE PETROGRAPHY REPORT PROGRAM ES Edit Transmit NT T Funckeys VTSNIAFunoKeys SRP Ee e samples selected by previous query 5 Select by warn ne 7 Setect v Wi gr 0 vii mer NUMBER OR LETTER i PE ii LA i a taji O Figure 14 The Selection Menu from the SOR Petrography Report Program This comprehensive reporting program is engaged from item 9 in the Petrography Database Menu Written in the SOR reporting language the program is designed to print all PETROG information on a site by site basis An example of ihe progra
31. d to them You should not update a reference to the extent that it becomes another reference as other people may have set pointers to the reference from other databases Use updates only to correct errors in existing references All new references go into the GEOREF AUTHORS and GEOREF REFERENCES tables TOP BLOCK Not all the fields in the Top Block belong to the underlying NGMA ROCKREFS table As soon as a Rockno is entered the Originator Site ID and Sample ID fields are automatically populated by a trigger from the NGMA ROCKS table To enter new records into ROCKREFS just add them to the bottom of the displayed records with NEXT FIELD As already mentioned in this block the INSERT RECORD key takes you directly to the screen for entering new references Reference ID REFID A 9 character field for the ID of a bibliographic reference in AGSO s Reference Database The ID of GEODX references in the database are various e g 79 20055 1156 GOLD239 The IDs of non GEODX references are always a number starting with an asterisk e g 2156 Rockno ROCKNO As in the Rocks Form the primary key of the NGMA ROCKS table Only Rocknos already entered in that table may be entered here Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 22 e 6 6 6 O 6 9 V 0 6 o e Originator ORIGNO As in the Petrography Form Dis
32. data on lithologies rock samples and mesoscopic geological structures that occur at a site or outcrop It is a three block form covering the ROCKS LITHDATA and STRUCTURES tables The ROCKS table has a many to one relationship with the SITES The LITHDATA table has a many to one relationship with the ROCKS table and functions as an extendable attributes table for that table The STRUCTURES table also has a many to one relationship with the ROCKS table A system generated ROCKNO key ties all three blocks together If a sample exists a Sample Number must be supplied otherwise the record is regarded as a lithology observation without a sample having been taken The sample number can be the site number or can be different but it must be unique to the originator If the site number is used and several samples were taken then the site number is typically modified by adding letters to represent each sample This is the recommended system as the connection between samples and sites is made clear However the data comes from many sources and as far as possible the numbering system used by the originator should be preserved The definitions and purposes of the fields in this form are given by Ryburn et al 1993b Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 2 20000000000000 0 0 0 0 O 6 o 0 9 0 9 9 9 9 9 0 0 0 0 060606600
33. e corresponding to the abbreviation is automatically displayed in the next field Only abbreviations already in the TSMINCLASTS view can be entered but the same mineral or clast can be used more than once e g a thin section may have quartz clasts and a quartz matrix A pop up list of available mineral or clasts can be viewed by pressing LIST Note that clast types are displayed first in this list as there are much fewer of these than rock forming minerals The terms matrix groundmass cement and void are included as these are thin section components that are commonly quantified as to their volume percentage Volume Percent PERCENT An optional numeric field for the volume percentage of the thin section composed of the stated mineral clast matrix etc Values may be entered of up to 100 0 and with one digit after the decimal point Since numbers only can be entered into this field negative numbers are used in lieu of a less than symbol Thus 1 0 is taken to mean lt 1 0 less than one percent and is equivalent to the conventional accessory or trace annotation that often appears on cards This follows the convention used in the ROCKCHEM database Ryburn 1990 Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 18 0 0 0 o 999 e e 6 9 9 6 O 8 o 4 0 0 9 9 9 0 0 9 0 0 0 9 9 0000000
34. enance Le how they were obtained are important Although the form insists on an absolute accuracy estimate in metres on the ground this is often an order of magnitude estimate only Location data accurate to 100 metres are generally acceptable when plotted at 1 250 000 scale but may be too inaccurate for use at 1 50 000 scale Similarly the method used to obtain the location coordinates is essential If a map was used a pointer to a bibliographic reference in AGSO s Bibliographic Reference Database to the exact map may also be included Detailed information on all the fields in the SITES table is given by Ryburn er al 1993b Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 11 8 THE ROCKS FORM F T220 Terminal to smo Eile Edit Transmit VT FunekKeys Setup Help OZROX DATABASE ROCKS R STRUCTURES READ ONLY FORM Enter a o 1 re Rocknos 5 orig s astuavt Snith P G Site ID 91843195 Bu ee 8 Sample 1D PAENER E Unit R In rmi Hane Strat Htim Qualifier ia Beet Rock NL net asedinent mafic arenite pa Other Data oe Hone n 26181 dolerite lo iC UK e 1 1 T 24 S IT 3 U IC KS ae SL stem suppiied primar kev Field can oake be entered eth mode m Pick list available press S m Figure 7 The Field Database s Rocks and Structures Form The Rocks and Structures Form is for
35. ent or description relating to the stated mineral or component Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 19 10 THE PETROGRAPHY DATA TYPES FORM VT220 Terminal to AVION 1806 DATABASE PETRO pe Description ee Bpyritic gsericitic i8 A D EE ege EE RE KE 5 IH BEA hele cami Wanted mein Hee tats Miitta APERE tia eee Ee bie ical angelina THE ONO neh agente Gils POETRY OTA SETY VTT IPOD PVT TOT SEO Tia et eth uann Painii ENE Era RSR EEGENEN Figure 9 The Petrography Data Types Form The Petrography Data Types Form which covers the TSDATATYPES table gives access to a list of attributes and values used to validate entries in the TSATTRIBS table The two fold division of this list into data types and subtypes is similar to that used by the NGMA LITHDATATYPES table that lies behind the Rocks Form in the OZROX database The initial list is not regarded as complete Users requiring additions to this authority table should pass their requests to the custodian Jan Knutson Xtm 9479 Type DATATYPE A mandatory field of up to 4 capital letters for an abbreviation for a petrography data type or attribute e g ALT for Alteration Type Description TYPEDESC An optional field of up to 32 characters for a description of the data type e g Alteration As this is in effect an attribute name the first letters of all main
36. er and Site ID already exists in OZROX s NGMA SITES table otherwise a thin section cannot be entered Entered By ENTEREDBY Mandatory field for the Oracle Owner username of the current ROCKS record This need not be the same as the owner of the thin section record in the next block The date entered ENTRYDATE 1s also a mandatory field in the ROCKS table but is not shown in the Petrography form Sample ID SAMPLEID A mandatory field of 16 characters for the ID of the rock sample the thin section comes from The Sample ID is unique to the Originator but it need bear no relationship to the Site ID AGSO originators should use an AGSO registered number with one appended letter or two letters if more than 26 samples were taken from 4 site Rockno ROCKNO A system generated mandatory positive integer of up to 6 digits which is the primary key for the ROCKS table Rock Type ROCKTYPE A positive integer of up to two digits that identifies the basic rock type from a look up list of 17 possibilities This field is designed for a first pass coarse classification of rock types as follows Number Rock Type unknown felsic intrusive intermediate intrusive mafic intrusive felsic extrusive intermediate extrusive mafic extrusive ultramafite alkaline 1gneous 0 clastic sediment G U EU LA re KO DO Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 4
37. ess amongst diverse numbering systems Originator numbers are recorded against names in the NGMA ORIGINATORS authority table The originator of a site or sample is the person or organisation primarily responsible for the data This could be the person who observed the site or collected the sample a laboratory worker or an author of published results someone who might reasonably be expected to know about the sample and its collection point and perhaps be able to supply further information Note that the name of the Originator is recorded only once in the database All other references to the Originator use the Originator Number which is listed against the name in the NGMA ORIGINATORS table A site in the SITES table is fully identified by a unigue combination of Originator Number and Site ID Siteid the latter being any seguence of numbers and letters up to 16 characters long The uniqueness of an Originator Number and Site ID combination is enforced by a unigue index covering these fields Similarly a sample in the ROCKS table is fully identified by a unigue combination of Originator Number and Sample ID Sampleid which is protected by a trigger in the ROCKS form it is not possible to enter a combination already in the ROCKS table Although a sample number on its own is usually sufficient to fetch the reguired sample do not forget that sample numbers on their own are not necessarily unique The THINSECTIONS table in PETROG records the Origi
38. he reference in the AGSO Reference Database system Title TITLE A mandatory field of up to 255 characters for the title of the reference Use lower case except for the first letter of the first word and all proper names Use a full stop at the end of the title In symposium style references the title of the symposium or collected works should also be entered following the word In and the names and initials of the editors plus Ed or Eds Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 23 Source SOURCE A mandatory field of up to 255 characters for the journal name or publication of the reference Use mostly lower case as in the title field Do not include volume part or page numbers A pick list is available from GEODX Volume and Part VOLPART Up to 32 characters for the volume and or part number of the publication containing the reference A single number indicates a volume number lf a part or issue number is also included place it in round brackets e g 1 GY Special volumes may require text entry e g The Sam Carey Special Volume Page Numbers PAGENOS Up to 32 characters for the page numbers of the reference e g 234 257 Reference ID REFID Asin the Top Block of the form the primary reference key Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 24 O O 6 0 9 O 6 0 0 0 9 0 9 gt 0080600
39. is an extendable attributes table that allows a variable number of controlled attributes and values to be attached to each thin section This is for attributes such as alterations or texture that apply to the section as a whole rather than individual components Note that several values of the same attributes may be entered e g two different kinds of alteration The third table TSMINERALS is for the quantifiable components of a thin section in crystalline rocks this means rock forming minerals In sedimentary rocks though each record is for classes of detrital grains matrix cement etc poma ROCKS FIELD DATABASE ili d 08 i i call e gt d 1 E ith A d 1 1 a 3 Ve E 1 k t s SEENEN MNNM te tg VER Mu 1 1 1 MIN ER ALS 1 EES EXTENDABLE A LAS TS We KI ATTRIBUTES S Je n oz S T 7 i HH TAU VTT KE ul M ERIN 11 i 1 112 gl S CE Judd Da i lw en 1 o mond fni er eene n Ij RA Ae d i ZS dir i W Du 1 i D DA T ES i UI OI i 1 i i Figure 3 Structure of PETROG showing joins to OXROX tables and the Bibliographic Reference Database The validation tables are lightly stippled The many end of many to one joins are indicated by crows feet Australian Geological Survey Organisation 1994 Users Guide to AGSO
40. low EXTENDABLE ATTRIBUTES BLOCK The Extendable Attributes Block which corresponds to the TSATTRIBS table is designed to accommodate varying amounts of information about the thin section as a whole e g grainsize texture and metamorphic grade It can also accommodate pointers to references in AGSO s Shared Bibliographic Reference Database TSATTRIBS has the form of an inverted table similar to the table underlying the Extendable Attributes Block in the Rocks Form in which attributes with values occupy rows in the table rather than columns This has the advantages that any number of attributes with values may be entered and that new attributes with their associated value domains may be added to the database as the need arises The attributes and values that can be entered are controlled by the look up table TSDATATYPES Attribute DATATYPE A mandatory field for an abbreviation of up to 4 capital letters pointing to an attribute Datatype in the TSDATATYPES table The attribute s name is automatically displayed in the next field Only attributes Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 6 00 00 O0 already in the TSDATATYPES view may be entered but the same attribute can be used more than once e g a thin section may exhibit two types of alteration A pop up list of available attributes can
41. m s output resulting from the selection criteria shown in Figure 14 is given in Appendix B To post a selection criterion in the above Report Selection Menu enter the appropriate number indicated in the menu and type in the required value as prompted Enclosing guotes are not reguired Note that item 7 allows you to enter a variety of SOL selection criteria exactly as you do following the where keyword in a SQL select statement but without the terminating semicolon When all the selection criteria are in place enter G to proceed with the report to the UNIX file indicated at item 1 of the above menu Note that this file is written to your current UNIX directory the one you were in when you typed the word mgma and that any prior file with the same name in the same directory will be overwritten If you want to produce several output files you must change the output file name each time you generate a new report As soon as the report has finished the menu is redisplayed with the number of thin section retrieved indicated at the top of the menu If this is not according to expectations revise your selection criteria and try again Large reports take some time to generate When tinished enter X to exit the report program and return to the Petrography Database Menu The output files from this program can be printed with the UNIX Ip command ee ip PETROG LIS or transferred to your PC with File Express in LAN Workplace for DOS A
42. nator Number Site ID and Sample ID Site and sample data must be entered into OZROX before the thin section data can be entered into PETROG Australian Geological Survey Organisation 1994 USsers Guide to AGSO s Petrography Database 6 0 000 O0 5 SECURITY AND ACCESS Select Only Database Access The Oracle production environment allows all internal AGSO users select only access to the main data tables in both the OZROX and PETROG The menu system provides read only versions of the forms that allow users to select most of the data in the databases but not to insert update or delete data Users should also have select only access to all validation tables When in SOL Plus all users may select data from any of these tables provided they include the owner s name plus a full stop in the name of the table or view e g SELECT SAMPLEID FROM NGMA ROCKS WHERE ORIGNO 56 SELECT SITEID FROM PETROG THINSECTIONS WHERE ORIGNO 56 Insert Update and Delete Oracle Access In both OZROX and PETROG all internal Oracle users in the production environment can add change or delete their own data This is accomplished via special named views Those relevant to PETROG and their corresponding base tables are as follows BASE TABLE INSERT UPDATE VIEW NGMA SITES NGMA USITES NGMA ROCKS NGMA UROCKS PETROG THINSECTIONS PETROG UTHINSECTIONS PETROG TSATTRIBS PETROG UTSATTRIBS PETR
43. ng hard copy output was generated by the Petrography Database report program PETROG SOR accessed at item 9 in the Petrography Database Menu All thin section data from Site ID 92836410 were selected via the PETROG Report Selection Menu The report output does not yet include references just Reference IDs AGSO Petrography Database 01 Jul 1994 09 19 AM Page 1 kkkkkkkkkkkkkkkk kkkkkkkikkk kkikkkkikkkkkkkkkkikkikkaik PETROGRAPHY DATABASE Thin Section Descriptions O0 0 000 a e M0 8 0 9 0 9 0 O1 Jul 1994 09 19 AM kkkikkkkik kkkkkakkkikkkkikikkkkkkkikk kkkkkkkkkkikkkk Other where Sort clause ORDER BY SITES ORIGNO SITES SITEID 9 Selection criteria are as follows Origno 23 Lower siteid 92836410 Upper siteid 92836410 250K Map 100K Map 0 Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 36 o 6 O AGSO Petrography Database 01 Jul 1994 09 19 AM Page 2 ORIGNO 23 SITEID 92836410 DATE 18 MAY 9Z STATE QLD LOC DESC Northern Oueen NOD 2 Iron Range PROV 22 SPROV DOMAIN 100K MAP 7572 AMGEAST 749950 AMGNORTH 8594950 LOC METHOD 0 ABS ACC 100 ATRPHOTO ELEVATION SAMPLEID 92836410A ROCK NO 14 LITH NAME schist NAME L QUAL DESC graphitic schist STRAT UNIT Sefton Metamorphics TS NO 15
44. o not execute an open guery no select criteria unless you have plenty of time It is possible to query from any of the four blocks as the form is fully block coordinated Before a new thin section record can be Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 3 added to PETROG information on the relevant site and rock sample must exist in the OZROX database To enter or update data in the ROCKS table use the Rocks amp Structures Form from the OZROX database However with the help of a key trigger the Lithological Description in the ROCKS table can be updated from the Rock Name field in the THIN SECTIONS block see Rock Name field description Originator ORIGNO Mandatory integer of up to 5 digits that automatically displays the corresponding originator s name Only the number of an originator already in the NGMA ORIGINATORS table is enterable A pop up list of originators and their numbers may be viewed by pressing the LIST key from which an originator may be selected with the ACCEPT or ENTER key The originator is usually the geologist or sometimes the organisation that collected the rock sample at the site It is also an indication of where to go for more information Site ID SITEID Mandatory field of up to 16 characters for a user supplied number or ID for the site from which the thin section comes A validation trigger ensures that a record with the given Originator Numb
45. play field only Site ID SITEID As in the Petrography Form Display field only Sample ID SAMPLEID As in the Petrography Form Display field only Entered ENTRYDATE As in the Petrography Form By ENTEREDBY As in the Petrography Form AUTHORS BLOCK The Authors Block provides access to the GEOREF AGSOAUTHS view read only Authors AUTHNAME A mandatory character field of up to 32 characters for the surname of an author 18 lower case except for the first letter followed by a space and the author s initials with full stops and no spaces between the initials Capital letters can also occur inside a surname e g d Albertis McDonald Order Number ORDERNO A positive integer of up to two digits indicating the order of the author in the authors list of the reference This field must be entered must start with one and must increment by one Reference ID REFID As in the Top Block The pointer to the reference record REFERENCE BLOCK The References Block corresponds to the GEOREF AGSOREFS view read only Year YEAR A mandatory character field of up to 32 characters for the year of publication of the reference Other ID OTHERID An optional 32 character field for any alternative reference number or ID All references from GEODX have the value GEODX Reference displayed in this field Owner ENTEREDBY A mandatory 8 character field for the Oracle user name of the person or database owner who entered t
46. r in this guide see sections 7 and 8 Most of the other tables in Figure 2 are lookup tables used to validate the classifications and nomenclature used in the main tables The main data tables in OZROX are owned by the Oracle user NGMA OZROX was formerly known as the NGMA Field Database However the ownership of various tables by NGMA is too firmly embedded in numerous AGSO applications to contemplate changing The ownership of all tables is indicated in the full table names by the prefix occurring before the decimal point The contents of the main OZROX data tables are as follows TABLE NAME NGMA SITES NGMA OUTCROPS NGMA ROCKS NGMA LITHDATA CONTENTS ground sites location data accuracy amp lineage outcrop related data including drill holes rock samples and lithological data extendable attributes for the ROCKS table NGMA STRUCTURES mesoscopic structures at a site or outcrop NGMA ROCKREFS bibliographic reference versus rock samples In addition the following views of the above tables allow ordinary users as opposed to owners or custodians to add update and delete their own data NGMA USITES NGMA UOUTCROPS NGMA UROCKS NGMA ULITHDATA NGMA USTRUCTURES and NGMA UROCKREFS There are also a number of authority tables and one view not all of which belong to NGMA Those of possible interest to PETROG users include TABLE OR VIEW NGMA ORIGINATORS NGMA AGSOCOUNTRIES NGMA AGSOSTATES NGMA QMAPS NGMA HMAPS NGMA
47. samples and their locations also reside in OZROX which is described in detail in the user s guide to that database Ryburn et al 1993b However brief accounts of the parts of the Field Database that are critical to PETROG are also included here All databases currently run on the Oracle 6 0 relational database management system RDBMS under UNIX 5 4 on AGSO s DG AViiON 6240 computer and are accessible from all PCs terminals and workstations on the AGSO Ethernet network This guide describes the infrastructure of PETROG including all screen forms report programs and definitions of all fields views and tables For information on the AViiON server network AGSO s Oracle environments and the use of SOL Plus SOL Forms etc see the Users Guide to AGSO s Oracle Database System Lenz et al 1993 2 STRUCTURE OF THE OZROX FIELD DATABASE GE Figure 2 The structure of the OZROX Field Database showing relationships between tables with crows feet at the many end of many to one links The authority table labels emphasise function and are not necessarily actual table names see below Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 2 OZROX has five main data tables SITES OUTCROPS ROCKS LITHDATA and STRUCTURES of which SITES and ROCKS are of particular interest to PETROG These tables are accessed via the Sites and Rocks screen forms which are briefly described late
48. t used at all when specifically linking thin sections to references The References Form s top block corresponds to the NGMA ROCKREFS table It joins the NGMA ROCKS table to the Reference Database in a many to many relationship For any given rock sample there could be several references and any one reference may refer to many rock samples The top block shows all the Reference IDs for a particular Rockno or ali Rocknos for a particular Reference ID The bottom two blocks which display a reference at a time correspond to the GEOREF AGSOAUTHS and GEOREF AGSOREFS views of the Reference Database These encompass a union with the GEODX bibliography Lenz amp Modrak 1990 which has over 22 000 references on Australian geology As the cursor is moved from record to record in the top block the corresponding reference is displayed in the bottom two blocks For the purpose of accessing AGSO s Reference Database however the top block can be ignored Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 21 This form can also be used to inspect and insert the references pointed to by the Bibliographic Reference field in the NGMA SITES table A more complete description of AGSO s Bibliographic Reference Database will be published in the users guide to that database but the information presented here is adeguate for entering references reguired by PETROG or attaching sites and rock samples to references
49. to replace these time honoured cards with an on line information system that gives instant access to all petrographic descriptions within the Australian continent and some without It can be used egually well for results from mineragraphy the study of polished sections or rocks and ores in reflected light The database is designed to mesh with geographic information systems GIS and other graphical or analytical software Thus the distribution and abundance of rock forming minerals can be plotted with the help of a GIS such as Arc Info or graphed directly from the database with the help of Microsoft Excel or some other graphing package RTMAP REGOLITH OZROX FIELD DATABAS LABORATORY DATABASE 4X dh 4X 44 4X AN ZA ROCK SPEC STREAM Figure 1 Simplified Structure of AGSO s Geological Database System PETROG is one of a number of field and laboratory databases that make up AGSO s Geo logical Database System Figure 1 ROCKCHEM for example is a laboratory database of rock chemistry Ryburn 1990 that shares field and sample information with PETROG So Australian Geological Survey Organisation 1994 USsers Guide to AGSO s Petrography Database l does OZCHRON the database of Australian Geochronology Ryburn er al 19934 Other databases such as OZMIN AGSO database of Australian Mineral Deposits tap into the point location information SITES table in the OZROX Field Database Comprehensive information on the rock
50. urn et al 1993b for the full details of forms from the OZROX Field Database 000000000 Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 10 0 7 THE SITES FORM g Muca Terminal to AVION an Kal Biblio Ref M ROCKCHEM 0322 OK O NEXT BLOCK for Rocks or lt List gt lt Replace gt E Figure 6 The OZROX Field Database s Sites Form The Sites Form standardises the way geographic point location data are recorded The form attaches to the NGMA SITES table but also draws on standard terms from associated validation tables such as the STRATA GEOPROVS table The form is primarily for surface location data relating to field geological geochemical and geophysical observations or of more interest to PETROG for the locations of rock samples You may move direct ly from the Sites Form to the Rocks Form by pressing NEXT BLOCK The Originator Number and Site ID are transferred to the Rocks Form which is queried automatically Geographic coordinates either as decimal latitudes and longitudes or as AMG eastings and northings are mandatory but the form includes a key trigger press NEXT PRIMARY KEY that converts AMG coordinates to latitudes and longitudes and vice versa The direction of conversion is determined by which fields are full and which are empty Data relating to the accuracy of the coordinates and their prov
51. ustralian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 28 0 900 O0 000 O 16 ACKNOWLEDGMENTS The development of AGSO s Petrography Database has been a team effort and has benefited from the input of a number of AGSO staff members In particular we wish to mention Lynton Jagues for the initial concept of the geological field and laboratory database system and Phil O Brien John Sheraton Peter Southgate Peter Stuart Smith David Waliace and Lesiey Wyborn for various contributions during the planning prototyping of PETROG This Record has benefited greatly from peer reviews by Gladys Warren and John Sheraton 17 REFERENCES Ewers G R amp Ryburn R J 1993 User s guide to the OZMIN mineral deposits database Australian Geological Survey Organisation Record 1993 94 69pp Kucka M 1994 AGSO s Oracle Developers Guide Australian Geological Survey Organisation Record 1994 4 Lenz S L Ryburn R J amp Kucka M 1993 Users Guide to AGSO s Oracle Database System Australian Geological Survey Organisation Record 1993 81 Lenz S Modrak K 1990 The Stratigraphic Index Database GEODX User Manual Australian Geological Survey Organisation Record 1990 16 Ryburn R J 1990 Users Guide to the PetChem Database Bureau of Mineral Resources Australia Record 1990 19 53pp Ryburn
52. wever that the custodian is not free to delete or alter existing attributes and values without first attending to any potential referential integrity problems The TSDATATYPES table currently links to the TSATTRIBS table and there may also be other dependent tables in the future Description or Reference DESCRIPTION An optional field of 64 characters for any additional descriptive information relating to the Data Type Subtype record For example one may wish to comment on the mode of occurrence of a mineral in a sample An important exception to this is the use of the field for inserting a pointer to a reference In this case the ID of the reference in AGSO s Bibhographic Reference Database must be entered As indicated by the message line at the bottom of the screen when the cursor is in this field you can jump directly to the References Form by pressing NEXT KEY MINERALS amp CLASTS BLOCK This block is specifically for data on the quantifiable components of a thin section In thin sections of igneous or metamorphic rocks the components are principally the mineral species that go to make up the rock sometimes the groundmass In thin sections of sedimentary rocks the components are mainly classes of detrital grain or clasts as well as the matrix or cement between the clasts Mineral or Clast MINERAL A mandatory field for an abbreviation of up to 4 capital letters pointing to a mineral or clast in the TSMINCLASTS view The nam
53. words should be capitalised Subtype SUBTYPE A mandatory field of up to 4 capital letters for an abbreviation for a data subtype or attribute value e g AB for albitic Subtype Description SUBDESC An optional field of up to 32 characters for a description of the data subtype e g Albitic Australian Geological Survey Organisation 1994 Users Guide to AGSO s Petrography Database 20 O0 00 0 0 0 0 0009000 oo 0 00000 11 THE BIBLIOGRAPHIC REFERENCES FORM rene to AVIION Reference I i Title Rare earth geochemistry of Archaean orthognelsses and evolution of thi pako East Antarctic Shelid PEBHR Journal of Australian Geology Geaphysics Part 9 3 The reference database nust be t Figure 10 The Rock References Form Thin sections in PETROG may be linked to references in AGSO s Shared Bibliographic Reference Database via a REF attribute and Reference ID in the Extendable Attributes Block of the Petrography Form see pages 16 18 The AGSO Reference ID is entered in the Description field of the REF record and the above References Form can be invoked by pressing NEXT PRIMARY KEY when the cursor is in that field in the Petrography Form Note however that the References Form shown in Figure 10 is primarily for linking rock samples to references and the top block exists solely for that purpose The top block is no
54. y Organisation 1994 Users Guide to AGSO s Petrography Database 25 13 THE THIN SECTION COMPONENTS FORM a 1 er rminal to Avil ON carbonate clasts carbonate matrix chert clasts clay matrix fecal pellets felsic volcanic clasts gabbroic clasts glass shards granitle tiasts igneous rock fragments intermediate volcanic clasts limestone clasts lithic clasts mafic volcanic clasts matrix metamorphic rock fragments nicrefossils BEE oo lites Figure 12 The Thin Section Components Form The Thin Section Components Form which correponds to the TSCLASTYPES authority table contains a list of all thin section components that are not in the NGMA AGSO MINERALS table Typically these are classes of detrital clasts but they also include types of matrix or groundmass and microfossils The TSCLASTYPES list is united with the list of minerals in NGMA AGSOMINERALS via a view called TSMINCLASTS and presented to the Petrography Form as a single list for validating the Mineral or Clast field When displayed from that form with the LIST key the united list has the non mineral components at the top the list annotated by the word CLAST in the last column as opposed to the minerals lower down the list with MIN in the last column Users wishing to add new components to the TSCLASTYPES table should contact the custodian Jan Knutson Xtn 947 Component Abbreviation CLASTABBREV A mandatory field of up to 4 capital letters for an
Download Pdf Manuals
Related Search