Table | Name | Field Alias | Data Type | Description |
Primary Table | TENEMENT_TYPE | | VARCHAR2 | TENEMENT_TYPE
TENEMENT_TYPE contains an acronym defining the class or type of tenement as issued under the Mining Act 1971 or Roxby Downs (Indenture Ratification) Act 1982.
Although there are numerous tenement types issued under the Mining Act, this dataset will contain only records where TENEMENT_TYPE equals ¿EML¿ (Extractive Mineral Lease), ¿MC¿ (Mineral Claim), ¿ML¿ (Mineral Lease), ¿MPL¿ (Miscellaneous Purpose Licence), ¿PM¿ (Private Mine) and ¿RL¿ (Retention Lease). The tenement type ¿SML¿ (Special Mining Lease) relates to the Olympic Dam mine, which is administered under the Roxby Downs (Indenture Ratification) Act, 1982. |
Primary Table | TENEMENT_NUMBER | | Number | TENEMENT_NUMBER
TENEMENT_NUMBER is a unique integer representing the tenement number for this type of tenement. Sequential integers have been issued since 1 July 1972 from number 1.
|
Primary Table | TENEMENT_LABEL | | VARCHAR2 | TENEMENT_LABEL
TENEMENT_LABEL is a concatenated string comprising the tenement type (TENEMENT_TYPE) and tenement number (TENEMENT_NUMBER) of the tenement
|
Primary Table | TENEMENT_STATUS | | VARCHAR2 | TENEMENT_STATUS
TENEMENT_STATUS contains the status of the tenement. Valid entries are:
This dataset will only contain records where TENEMENT_STATUS equals ¿Active¿ |
Primary Table | TENEMENT_HOLDERS | | VARCHAR2 | TENEMENT_HOLDERS
TENEMENT_HOLDERS is a concatenated string containing a list of all of the companies, entities and individuals who are recorded in the Mining Register as holders of this tenement, along with their percentage of interest. Individual holders are separated by semicolons.
|
Primary Table | TENEMENT_OPERATORS | | VARCHAR2 | TENEMENT_OPERATORS
TENEMENT_OPERATORS is a concatenated string containing a list of all of the companies, entities and individuals who are the current operators involved in the working of the tenement. In many cases, this may not be the same as TENEMENT_HOLDERS. Individual operators are separated by semicolons.
|
Primary Table | LEGAL_AREA | | Number | LEGAL_AREA
LEGAL_AREA contains the approximate area of the application. This is the legal area upon which the annual rental is calculated and is not necessarily the calculated geometric area. The units of measure are indicated in the AREA_UNIT field.
|
Primary Table | AREA_UNIT | | VARCHAR2 | AREA_UNIT
AREA_UNIT is the unit of measure (generally hectares) for the area indicated in LEGAL_AREA.
|
Primary Table | LOCATION | | VARCHAR2 | LOCATION
LOCATION contains a reference to the nearest significant locality (town, district, mountain etc.). It is used to assist industry and the general public to identify the approximate location of the tenement within SA.
|
Primary Table | REGISTRATION_GRANT_D | | Date | REGISTRATION_GRANT_DATE
REGISTRATION_GRANT_DATE contains the date on which this tenement was originally granted and came INTO effect
|
Primary Table | SURRENDER_DATE | | Date | SURRENDER_DATE
SURRENDER_DATE contains the date on which this tenement was surrendered by the holder(s).
|
Primary Table | EXPIRY_DATE | | Date | EXPIRY_DATE
EXPIRY_DATE contains the date on which this tenement is due to expire.
|
Primary Table | RENEWAL_RECEIVED_DAT | | Date | RENEWAL_RECEIVED_DATE
RENEWAL_RECEIVED_DATE contains the date on which an application was received to renew (extend the term of) this tenement.
|
Primary Table | TRANSFER_RECEIVED_DA | | Date | TRANSFER_RECEIVED_DATE
TRANSFER_RECEIVED_DATE contains the date on which an application was received to transfer this tenement to new holder(s).
|
Primary Table | SURRENDER_RECEIVED_D | | Date | SURRENDER_RECEIVED_DATE
SURRENDER_RECEIVED_DATE contains the date on which this tenement was surrendered by the holder(s).
|
Primary Table | COMMODITY_CATEGORIES | | VARCHAR2 | COMMODITY_CATEGORIES
COMMODITY_CATEGORIES contains the categories of commodities sought from the tenement.
|
Primary Table | COMMODITIES | | VARCHAR2 | COMMODITIES
COMMODITIES is a concatenated string containing a list of all commodities sought under this tenement. Individual commodities are separated by semicolons.
|
Primary Table | COURT_ACTION_PENDING | | VARCHAR2 | COURT_ACTION_PENDING
COURT_ACTION_PENDING contains a flag (¿Yes¿ or ¿No¿) to indicate whether this tenement is the subject of any pending action in the Wardens Court.
|
Primary Table | MPL_PURPOSE | | VARCHAR2 | MPL_PURPOSE
MPL_PURPOSE contains the purpose for a Miscellaneous Purpose Licence. This field is only applicable for a Miscellaneous Purpose Licence.
|
Primary Table | OPERATION_NAME | | VARCHAR2 | OPERATION_NAME
OPERATION_NAME contains the name of the mining operation.
|
Primary Table | OPERATION_STATUS | | VARCHAR2 | OPERATION_STATUS
OPERATION_STATUS contains the status of the mining operations. Valid entries are
|
Primary Table | OPERATION_METHOD | | VARCHAR2 | OPERATION_METHOD
OPERATION_METHOD contains the method of the mining operations. Valid entries include:
|
Primary Table | TENEMENT_TYPE_TITLE | | VARCHAR2 | TENEMENT_TYPE_TITLE
TENEMENT_TYPE_TITLE contains the full title of the tenement as issued under the Mining Act. Although there are numerous tenement types issued under the Mining Act, this dataset will contain the following records where TENEMENT_TYPE_TITLE equals ¿Extractive Mineral Lease¿, ¿Mineral Claim¿, ¿Mineral Lease¿, ¿Miscellaneous Purposes Licence¿, ¿Private Mine¿, ¿Retention Lease¿ or ¿Special Mining Lease¿.
|
Primary Table | ACT_TITLE | | VARCHAR2 | ACT_TITLE
ACT_TITLE is the title of the Act under which the application is issued. This dataset will only contain records where ACT_TITLE equals ¿Mining Act 1971¿ or Roxby Downs (Indenture Ratification) Act 1982.
|