Output table fields & values

To serve OCTOPUS database collections as geospatial layers via an interactive map Web interface and to allow for data manipulation via the Web Feature Service protocol, data sub-collections are served to GeoServer as a flat data tables, which are described in detail below 1.

When downloading data from OCTOPUS, users are presented with point or polygon geospatial data files with associated attribute tables. Direct connections to the PostgreSQL/PostGIS database are possible upon request. Munack and Codilean (2022) provide a complete documentation of the relational database, including a detailed database model diagram and searchable HTML documentation generated using SchemaSpy (https://schemaspy.org, last access: 21 Aug 2023).

Note

The above section is a modified version of Section 3 from Codilean et al. 2022

CRN output

OCTOPUS CRN Be-10 and Al-26 data have been recalculated 2 so that nuclide concentrations and denudation rates are internally consistent and comparable. These and related data, including concentrations and denudation rates as published, are served as geospatial vector layers (see CRN vector spatial data).

In addition, OCTOPUS CRN collections also provide CRN ancillary data comprising raster layers, including a digital elevation model, gradient raster, flow direction and flow accumulation rasters, atmospheric pressure raster, and CRN production scaling and topographic shielding factor rasters, as well as a set of structured input data files (see ‘CSV’ folder subsection) for the purpose of data recalculation integrity. The idea behind the above is that, since the CAIRN algorithm is automated (see LSDTopoTools documentation), users can simply publish a DEM of their study area, CRN data files, and CAIRN input files, and denudation rates should be reproducible.

CRN vector spatial data

The vector spatial data uses the WGS84 / Pseudo-Mercator (EPSG: 3857) projected coordinate reference system.

Field Name	Unit	Example	Origin (Alias)
OBSID1		S208WTS001	crn_be_DataCore table (cbdc)
OBSID2		PIO	crn_be_DataCore table (cbdc)
STUDYID		S208	crn_v3_basins_EPSG3857 table (cvbe)
CRN_SUBCMP		AUS	crn_v3_basins_EPSG3857 table (cvbe)
IGSNID		NA	crn_be_DataCore table (cbdc)
DBDOI		10.25900/mpr9-yn15	global_dbDOI table (gdd)
DBVERNO		2.2(3)	global_dbDOI table (gdd)
SMPID		CRNSM03787	crn_Sample table (cs)
SITEID		CRNST03410a	global_SiteMaster table (gsm)
METASITEID		NA	global_SiteMaster table (gsm)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		Lake Eyre Basin	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-NT	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Finke Riv.	global_SiteMaster table (gsm)
AHGFL1		LEB	global_rivID table (grid)
AHGFL2		LEB_02	global_rivID table (grid)
RIVNAME		Diamantina-Georgina Rivers	global_rivID table (grid)
RIVDIV		Lake Eyre Basin	global_rivID table (grid)
IBRACODE		MAC	global_ibraID table (giid)
IBRAREGION		MacDonnell Ranges	global_ibraID table (giid)
X_WGS84	decimal deg	132.71	global_SiteMaster table (gsm)
Y_WGS84	decimal deg	-23.68	global_SiteMaster table (gsm)
CORDS_ELEV		INTP_ND	global_SiteMaster table (gsm)
ELEVATION	m	-9999.99	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID		Struck:2018australia	global_RefCore table (grc)
OAID		OAID-000158	global_RefCore table (grc)
AUTHOR		Struck	global_Author table (ga)
PUBYEAR		2018	global_RefCore table (grc)
REFID		Earth_Surf_Dynamics_6	global_RefCore table (grc)
REFDOI		10.5194/esurf-6-329-2018	global_RefCore table (grc)
MATERIAL		Sa	global_GrainSize table (ggs)
SIZEMIN	µm	250	crn_Sample table (cs)
SIZEMAX	µm	500	crn_Sample table (cs)
PROJEPSGID		32753	crn_projepsgID table (cpi)
PROJECTION		WGS84_UTM_53S	crn_projepsgID table (cpi)
AREA	km^2	98.13	crn_Sample table (cs)
ELEV_AVE	m	776.81	crn_Sample table (cs)
ELEV_STD	m	81.23	crn_Sample table (cs)
SLP_AVE	m.km^-1	118.62	crn_Sample table (cs)
SLP_STD	m.km^-1	119.92	crn_Sample table (cs)
CENTR_LAT	decimal deg	132.71	crn_v3_basins_EPSG3857 table (cvbe)
ATM_PRESS	hPa	901	crn_v3_basins_EPSG3857 table (cvbe)
QTZ_PCNT	%		crn_v3_basins_EPSG3857 table (cvbe)
GLA_KM2	km^2		crn_v3_basins_EPSG3857 table (cvbe)
GLA_PCNT	%		crn_v3_basins_EPSG3857 table (cvbe)
SMP_DAY		-9999	crn_Sample table (cs)
SMP_MONTH		-9999	crn_Sample table (cs)
SMP_YEAR		-9999	crn_Sample table (cs)
SMP_COMMT		NA	crn_Sample table (cs)
BE10NP	atoms.g^-1	495437	crn_be_DataCore table (cbdc)
BE10NP_ERR	atoms.g^-1	15151	crn_be_DataCore table (cbdc)
BE10EP	atoms.g^-1	7.46	crn_be_DataCore table (cbdc)
BE10EP_ERR	atoms.g^-1	0.25	crn_be_DataCore table (cbdc)
BESTND		07KNSTD	crn_bestndID table (cbi)
BECORR		1	crn_bestndID table (cbi)
BEAMS		ANSTO	crn_amsID table (cai2)
BE10NC	atoms.g^-1	495437	crn_be_DataCore table (cbdc)
BE10NC_ERR	atoms.g^-1	15151	crn_be_DataCore table (cbdc)
BEPROD	dimless	1.295	crn_be_DataCore table (cbdc)
BETOPO	dimless	0.996	crn_be_DataCore table (cbdc)
BESELF	dimless	1	crn_be_DataCore table (cbdc)
BESNOW	dimless	1	crn_be_DataCore table (cbdc)
BETOTS	dimless	1.289	crn_be_DataCore table (cbdc)
EBE_GCMYR	g.cm^-2.yr^-1	0.00188	crn_be_DataCore table (cbdc)
ERRBE_AMS	g.cm^-2.yr^-1	0.00006	crn_be_DataCore table (cbdc)
ERRBE_MUON	g.cm^-2.yr^-1	0.00015	crn_be_DataCore table (cbdc)
ERRBE_PROD	g.cm^-2.yr^-1	0.00039	crn_be_DataCore table (cbdc)
ERRBE_TOT	g.cm^-2.yr^-1	0.00042	crn_be_DataCore table (cbdc)
EBE_MMKYR	mm.kyr^-1	7.09	crn_be_DataCore table (cbdc)
EBE_ERR	mm.kyr^-1	1.6	crn_be_DataCore table (cbdc)
EBEGLA	mm.kyr^-1	14.18	crn_be_DataCore table (cbdc)
EBEGLA_ERR	mm.kyr^-1	3.2	crn_be_DataCore table (cbdc)
EBE_DIFF	%	100	crn_be_DataCore table (cbdc)
AL26NP	atoms.g^-1	2785751	crn_al_DataCore table (cadc)
AL26NP_ERR	atoms.g^-1	139733	crn_al_DataCore table (cadc)
AL26EP	atoms.g^-1	-9999.99	crn_al_DataCore table (cadc)
AL26EP_ERR	atoms.g^-1	-9999.99	crn_al_DataCore table (cadc)
ALSTND		KNSTD	crn_alstndID table (cai)
ALCORR		1	crn_alstndID table (cai)
ALAMS		ANSTO	crn_amsID table (cai2)
AL26NC	atoms.g^-1	2785751	crn_al_DataCore table (cadc)
AL26NC_ERR	atoms.g^-1	139733	crn_al_DataCore table (cadc)
ALPROD	dimless	1.295	crn_al_DataCore table (cadc)
ALTOPO	dimless	0.996	crn_al_DataCore table (cadc)
ALSELF	dimless	1	crn_al_DataCore table (cadc)
ALSNOW	dimless	1	crn_al_DataCore table (cadc)
ALTOTS	dimless	1.289	crn_al_DataCore table (cadc)
EAL_GCMYR	g.cm^-2.yr^-1	0.00246	crn_al_DataCore table (cadc)
ERRAL_AMS	g.cm^-2.yr^-1	0.00014	crn_al_DataCore table (cadc)
ERRAL_MUON	g.cm^-2.yr^-1	0.00008	crn_al_DataCore table (cadc)
ERRAL_PROD	g.cm^-2.yr^-1	0.00051	crn_al_DataCore table (cadc)
ERRAL_TOT	g.cm^-2.yr^-1	0.00053	crn_al_DataCore table (cadc)
EAL_MMKYR	mm.kyr^-1	9.27	crn_al_DataCore table (cadc)
EAL_ERR	mm.kyr^-1	2.01	crn_al_DataCore table (cadc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

CRN ancillary data

‘CSV’ folder

• s…_CRNData.csv – CAIRN CRN concentrations input file (see LSDTopoTools documentation)

• s…_CRNRasters.csv – Path to raster files (see LSDTopoTools documentation)

• s…_CRNResults.csv – Original CAIRN output (= results)

• s…_CRONUSInput.txt – CAIRN-derived CRONUS copy-and-paste input

• s…._CRNParam – CAIRN input parameter file (see LSDTopoTools documentation)

‘Raster’ folder

The raster data uses the WGS84/UTM projected coordinate reference system, UTM zones depending on the extent and location of each data package.

• s…_atmospres.bil – An atmospheric pressure raster, showing local atmospheric pressure in hPa calculated based on the NCEP2 climate reanalysis data (Compo et al., 2011)

• s…_atmospres.hdr – s…_atmospres.bil header file

• s…_d8flowdir.bil – A flow-direction raster calculated using the D8 flow-routing method (Jenson and Domingue, 1988)

• s…_d8flowdir.hdr – s…_d8flowdir.bil header file

• s…_demhydro.bil – A hydrologically corrected DEM with elevation values in metres (raster)

• s…_demhydro.hdr – s…_demhydro.bil header file

• s…_flowacc.bil – A flow-accumulation raster calculated with the same D8 method as used for d8flowdir

• s…_flowacc.hdr – s…_flowacc.bil header file

• s…_gradmkm.bil – A slope gradient raster calculated using the method described in Horn (1981) with units in m km-1

• s…_gradmkm.hdr – s…_gradmkm.bil header file

• s…_prodscale.bil – A cosmogenic nuclide production scaling raster calculated using the method described in Stone (Stone, 2000)

• s…_prodscale.hdr – s…_prodscale.bil header file

• s…_toposhield.bil – A cosmogenic nuclide production topographic shielding raster calculated using the method described in Codilean (2006)

• s…_toposhield.hdr – s…_toposhield.bil header file

Note

Raster files are provided in .bil (Band Interleaved by Line) image encoding format, which cannot be considered an image format itself, but is depended on the accompanying header (.hdr) file meaning that users will always need the pair of files with one and the same filename.

SahulArch output

SahulArch C14 output

Field Name	Unit	Example	Origin (Alias)
OBSID1		ARCH0008TL011	arch_c14_DataCore table (acdc)
OBSID2		PJ2S/50	arch_c14_DataCore table (acdc)
LABID		AdTL89002	arch_c14_DataCore table (acdc)
LAB_FACLTY		Prescott Env. Lum. Lab. Adelaide	cabah_LabCodes table (clc)
IGSNID		NA	arch_c14_DataCore table (acdc)
DBDOI		10.25900/af67-kh16	global_dbDOI table (gdd)
DBVERNO		2.2(2)	global_dbDOI table (gdd)
SMPID		ARCH0008SMP030b	arch_Sample table (ars)
SITEID		ARCH0008b	global_SiteMaster table (gsm)
METASITEID		META_ARCH0008	global_MetaSite table (gms)
METANAME		Puritjarra	global_MetaSite table (gms)
METHODABBR		TL	c_mtdID table (cmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-NT	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Victoria River-wiso	global_SiteMaster table (gsm)
AHGFL1		TTS	global_rivID table (grid)
AHGFL2		TTS_10	global_rivID table (grid)
RIVNAME		Victoria River-wiso	global_rivID table (grid)
RIVDIV		Tanami-Timor Sea Coast	global_rivID table (grid)
IBRACODE		GSD	global_ibraID table (giid)
IBRAREGION		Great Sandy Desert	global_ibraID table (giid)
CORDS_ELEV		ORIG_INTP	global_SiteMaster table (gsm)
ELEVATION	m	738.6	global_SiteMaster table (gsm)
SITENAME		Puritjarra	global_SiteMaster table (gsm)
SITE_SPEC		NA	global_SiteMaster table (gsm)
ALTNAME1		Cleland Hills	global_SiteMaster table (gsm)
ALTNAME2		NA	global_SiteMaster table (gsm)
ALTNAME3		NA	global_SiteMaster table (gsm)
SITECODE		Other	global_SiteMaster table (gsm)
OPENCLOSED		Open	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Smith:1997puritjarra	arch_c14_DataCore table (acdc)
OAID1		OAID-000387	global_RefCore table (grc1)
AUTHOR1		Smith	global_Author table (ga1)
PUBYEAR1		1997	global_RefCore table (grc1)
REFID1		Quaternary_Sci_Rev_16	global_RefCore table (grc1)
REFDOI1		10.1016/S0277-3791(96)00085-6	global_RefCore table (grc1)
REFDBID2		Smith:1987pleistocene	arch_c14_DataCore table (acdc)
…	…		…
REFDOI4			global_RefCore table (grc1)
FEATDATED		not related to a feature	arch_featdatedID table (afd)
SQUARE		dune field	arch_Sample table (ars)
XU		NA	arch_Sample table (ars)
SMPDEPTH	m	0.5	arch_Sample table (ars)
OCCUPATION		No	arch_Sample table (ars)
CONTEXT		Sterile	arch_Sample table (ars)
SMP_COMMT		NA	arch_Sample table (ars)
COL_MTD		Tube	cabah_col_mtdID table (ccmi)
MATERIAL1		Plant	c_mtdID table (cmi2)
MATERIAL2		Wood	c_mtdID table (cmi3)
BURNT		No	arch_c14_DataCore table (acdc)
ARCHSPECIS		Grevillea sp. or Hakea sp.	arch_c14_DataCore table (acdc)
ORGPART		ND	arch_c14_DataCore table (acdc)
HUM_MOD		Boomerang	arch_c14_DataCore table (acdc)
SINGULAR		ND	arch_c14_DataCore table (acdc)
CONSERV		No	arch_c14_DataCore table (acdc)
AGEMTD		AMS	arch_c14_DataCore table (acdc)
PHYSCLEAN		Yes	arch_c14_DataCore table (acdc)
CONTAM		Sediment	arch_c14_DataCore table (acdc)
CHEMPREPAB		Other	arch_c14_DataCore table (acdc)
SOLVENT1		No	arch_c14_DataCore table (acdc)
SOLVENT2AB		ND	arch_c14_DataCore table (acdc)
YIELD_MG	mg	-9999.99	arch_c14_DataCore table (acdc)
YIELD_PCT	%	-9999.99	arch_c14_DataCore table (acdc)
C	mg	-9999.99	arch_c14_DataCore table (acdc)
C_ERR	mg	-9999.99	arch_c14_DataCore table (acdc)
C_MTD		ND	c_mtdID table (cmi4)
PCT_C	%	42	arch_c14_DataCore table (acdc)
PCT_C_ERR	%	-9999.99	arch_c14_DataCore table (acdc)
PCT_C_MTD		ND	c_mtdID table (cmi6)
PCT_N	%	-9999.99	arch_c14_DataCore table (acdc)
PCT_N_ERR	%	-9999.99	arch_c14_DataCore table (acdc)
PCT_N_MTD		ND	c_mtdID table (cmi5)
CN_RATIO		-9999.99	arch_c14_DataCore table (acdc)
CN_ERR		-9999.99	arch_c14_DataCore table (acdc)
CN_MTD		ND	c_mtdID table (cmi7)
C13	‰	-9999.99	arch_c14_DataCore table (acdc)
C13_ERR	‰	-9999.99	arch_c14_DataCore table (acdc)
C13_MTD		ND	c_mtdID table (cmi8)
O18	‰	-9999.99	arch_c14_DataCore table (acdc)
O18_ERR	‰	-9999.99	arch_c14_DataCore table (acdc)
O18_MTD		ND	c_mtdID table (cmi9)
N15	‰	-9999.99	arch_c14_DataCore table (acdc)
N15_ERR	‰	-9999.99	arch_c14_DataCore table (acdc)
N15_MTD		ND	c_mtdID table (cmi10)
S34	‰	-9999.99	arch_c14_DataCore table (acdc)
S34_ERR	‰	-9999.99	arch_c14_DataCore table (acdc)
S34_MTD		ND	c_mtdID table (cmi11)
RECRYST		ND	arch_c14_DataCore table (acdc)
PCT_RE_VAL	%	-9999.99	arch_c14_DataCore table (acdc)
PCT_RE_ERR	%	-9999.99	arch_c14_DataCore table (acdc)
PCT_RE_MTD		ND	arch_c14_DataCore table (acdc)
C14_AGE	BP	670	arch_c14_DataCore table (acdc)
C14_ERRPOS	BP	20	arch_c14_DataCore table (acdc)
C14_ERRNEG	BP	20	arch_c14_DataCore table (acdc)
C14_INF		No	arch_c14_DataCore table (acdc)
F14C		-9999.99	arch_c14_DataCore table (acdc)
F14C_ERR		-9999.99	arch_c14_DataCore table (acdc)
C13_VAL		Measured by AMS	c13_valID table (cvi)
AGE_COMMT		**	arch_c14_DataCore table (acdc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

SahulArch OSL output

Field Name	Unit	Example	Origin (Alias)
OBSID1		ARCH0005OSL009	arch_osl_DataCore table (aodc)
OBSID2		L008/15-1	arch_osl_DataCore table (aodc)
LABID		L008/15-1	arch_osl_DataCore table (aodc)
LAB_FACLTY		ND	cabah_LabCodes table (clc)
IGSNID		NA	arch_osl_DataCore table (aodc)
DBDOI		10.25900/9y07-4j77	global_dbDOI table (gdd)
DBVERNO		2.2(2)	global_dbDOI table (gdd)
SMPID		ARCH0005SMP024a	arch_Sample table (ars)
SITEID		ARCH0005a	global_SiteMaster table (gsm)
METASITEID		META_ARCH0005	global_MetaSite table (gsm)
METANAME		Boodie Cave	global_MetaSite table (gms)
METHODABBR		OSL	c_mtdID table (cmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-WA	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		Barrow Island	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Onslow Coast	global_SiteMaster table (gsm)
AHGFL1		PG	global_rivID table (grid)
AHGFL2		PG_07	global_rivID table (grid)
RIVNAME		Onslow Coast	global_rivID table (grid)
RIVDIV		Pilbara-Gascoyne	global_rivID table (grid)
IBRACODE		CAR	global_ibraID table (giid)
IBRAREGION		Carnarvon	global_ibraID table (giid)
CORDS_ELEV		INTP_INTP	global_SiteMaster table (gsm)
ELEVATION	m	27.4	global_SiteMaster table (gsm)
SITENAME		Boodie Cave	global_SiteMaster table (gsm)
SITE_SPEC		NA	global_SiteMaster table (gsm)
ALTNAME1		NA	global_SiteMaster table (gsm)
ALTNAME2		NA	global_SiteMaster table (gsm)
ALTNAME3		NA	global_SiteMaster table (gsm)
SITECODE		Rockshelter or cave	global_SiteCode table (gsc)
OPENCLOSED		Closed	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Veth:2017barrow	arch_osl_DataCore table (aodc)
OAID1		OAID-000403	global_RefCore table (grc1)
AUTHOR1		Veth	global_Author table (ga1)
PUBYEAR1		2017	global_RefCore table (grc1)
REFID1		Quaternary_Sci_Rev_168	global_RefCore table (grc1)
REFDOI1		10.1016/j.quascirev.2017.05.002	global_RefCore table (grc1)
REFDBID2		Veth:2014maritime	arch_osl_DataCore table (aodc)
…	…	…	…
REFDOI4			global_RefCore table (grc1)
FEATDATED		not related to a feature	arch_Sample table (ars)
SQUARE		A102/A103	arch_Sample table (ars)
XU		7	arch_Sample table (ars)
SMPDEPTH	m	1.12	arch_Sample table (ars)
OCCUPATION		Yes	arch_Sample table (ars)
CONTEXT		Occupation	arch_Sample table (ars)
SMP_COMMT		NA	arch_Sample table (ars)
COL_MTD		Tube	cabah_col_mtdID table (ccmi)
LUM_MAT		Sediment	osl-tl_lum_matID table (otlmi)
MINERAL		Quartz	osl-tl_mineralID table (otmi)
SIZE_MIN	µm	180	arch_osl_DataCore table (aodc)
SIZE_MAX	µm	250	arch_osl_DataCore table (aodc)
H2O_MEAS	%	-9999.99	arch_osl_DataCore table (aodc)
H2O_USED	%	12.5	arch_osl_DataCore table (aodc)
H2O_ERR	%	3.1	arch_osl_DataCore table (aodc)
OSL_TYPEAB		OSL	osl_typeID table (oti)
ALIQ_TYPE		SG	arch_osl_DataCore table (aodc)
ALIQ_SIZE	m	-9999.99	arch_osl_DataCore table (aodc)
ED_PROCABR		SAR	osl-tl_ed_procID table (otepi)
RESCOR		No	arch_osl_DataCore table (aodc)
DOSERECOV		No	arch_osl_DataCore table (aodc)
AGEMODELAB		CAM	osl-tl_agemodelID table (otai)
PH1_TEMP	°C	260	arch_osl_DataCore table (aodc)
PH2_TEMP	°C	160	arch_osl_DataCore table (aodc)
NUM_MEAS		200	arch_osl_DataCore table (aodc)
NUM_ACC		93	arch_osl_DataCore table (aodc)
EQUIVDOSE	Gy	87.4	arch_osl_DataCore table (aodc)
ED_ERR	Gy	5.2	arch_osl_DataCore table (aodc)
ED_INF		No	arch_osl_DataCore table (aodc)
OD		55	arch_osl_DataCore table (aodc)
OD_ERR		5	arch_osl_DataCore table (aodc)
OD_TYPE		%	arch_osl_DataCore table (aodc)
U	ppm / μg/g	2	arch_osl_DataCore table (aodc)
U_ERR	ppm / μg/g	0.2	arch_osl_DataCore table (aodc)
U_MTDAB		ICP-MS	osl-tl_mtdID table (otmi2)
TH	ppm / μg/g	11.3	arch_osl_DataCore table (aodc)
TH_ERR	ppm / μg/g	1.1	arch_osl_DataCore table (aodc)
TH_MTDAB		ICP-MS	osl-tl_mtdID table (otmi3)
K	ppm / μg/g	0.6	arch_osl_DataCore table (aodc)
K_ERR	ppm / μg/g	0.1	arch_osl_DataCore table (aodc)
K_MTDAB		ICP-A/OES	osl-tl_mtdID table (otmi4)
U238	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
U238_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
RA226	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
RA226_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
PB210	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
PB210_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
RA228	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
RA228_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
TH228	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
TH228_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
TH232	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
TH232_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
K40	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
K40_ERR	Bq/kg	-9999.99	arch_osl_DataCore table (aodc)
ALPH	Gy/ka	-9999.99	arch_osl_DataCore table (aodc)
ALPH_ERR	Gy/ka	-9999.99	arch_osl_DataCore table (aodc)
ALPH_MTDAB		NA	osl-tl_mtdID table (otmi5)
BETA	Gy/ka	0.82	arch_osl_DataCore table (aodc)
BETA_ERR	Gy/ka	0.06	arch_osl_DataCore table (aodc)
BETA_MTDAB		ICP-MS	osl-tl_mtdID table (otmi6)
GAMMA	Gy/ka	0.8	arch_osl_DataCore table (aodc)
GAMMA_ERR	Gy/ka	0.05	arch_osl_DataCore table (aodc)
GAMMA_MTDA		ICP-MS	osl-tl_mtdID table (otmi7)
COSMIC	Gy/ka	0.06	arch_osl_DataCore table (aodc)
COSMIC_ERR	Gy/ka	0.01	arch_osl_DataCore table (aodc)
ALPH_I	Gy/ka	0.03	arch_osl_DataCore table (aodc)
ALPH_I_ERR	Gy/ka	0.01	arch_osl_DataCore table (aodc)
ALPH_I_MTD		Assumed	arch_osl_DataCore table (aodc)
BETA_I	Gy/ka	-9999.99	arch_osl_DataCore table (aodc)
BETA_I_ERR	Gy/ka	-9999.99	arch_osl_DataCore table (aodc)
BETA_I_MTD		ND	arch_osl_DataCore table (aodc)
DIFF_DOSE		No	arch_osl_DataCore table (aodc)
DOSERATE	Gy/ka	1.71	arch_osl_DataCore table (aodc)
DOSE_ERR	Gy/ka	0.12	arch_osl_DataCore table (aodc)
OSL_AGE	ka	51.1	arch_osl_DataCore table (aodc)
OSL_RNDERR	ka	-9999.99	arch_osl_DataCore table (aodc)
OSL_ERR	ka	4.9	arch_osl_DataCore table (aodc)
AGE_CI		1s	arch_osl_DataCore table (aodc)
FADCOR		ND	arch_osl_DataCore table (aodc)
G_VAL	%/10a	-9999.99	arch_osl_DataCore table (aodc)
G_VAL_ERR	%/10a	-9999.99	arch_osl_DataCore table (aodc)
AGE_COMMT			arch_osl_DataCore table (aodc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

SahulArch TL output

Field Name	Unit	Example	Origin (Alias)
OBSID1		ARCH0008TL011	arch_tl_DataCore table (atdc)
OBSID2		PJ2S/50	arch_tl_DataCore table (atdc)
LABID		AdTL89002	arch_tl_DataCore table (atdc)
LAB_FACLTY		Prescott Env. Lum. Lab. Adelaide	cabah_LabCodes table (clc)
IGSNID		NA	arch_tl_DataCore table (atdc)
DBDOI		10.25900/af67-kh16	global_dbDOI table (gdd)
DBVERNO		2.2(2)	global_dbDOI table (gdd)
SMPID		ARCH0008SMP030b	arch_Sample table (ars)
SITEID		ARCH0008b	global_SiteMaster table (gsm)
METASITEID		META_ARCH0008	global_MetaSite table (gms)
METANAME		Puritjarra	global_MetaSite table (gms)
METHODABBR		TL	c_mtdID table (cmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-NT	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Victoria River-wiso	global_SiteMaster table (gsm)
AHGFL1		TTS	global_rivID table (grid)
AHGFL2		TTS_10	global_rivID table (grid)
RIVNAME		Victoria River-wiso	global_rivID table (grid)
RIVDIV		Tanami-Timor Sea Coast	global_rivID table (grid)
IBRACODE		GSD	global_ibraID table (giid)
IBRAREGION		Great Sandy Desert	global_ibraID table (giid)
CORDS_ELEV		ORIG_INTP	global_SiteMaster table (gsm)
ELEVATION	m	738.6	global_SiteMaster table (gsm)
SITENAME		Puritjarra	global_SiteMaster table (gsm)
SITE_SPEC		NA	global_SiteMaster table (gsm)
ALTNAME1		Cleland Hills	global_SiteMaster table (gsm)
ALTNAME2		NA	global_SiteMaster table (gsm)
ALTNAME3		NA	global_SiteMaster table (gsm)
SITECODE		Other
OPENCLOSED		Open
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Smith:1997puritjarra	arch_tl_DataCore table (atdc)
OAID1		OAID-000387	global_RefCore table (grc1)
AUTHOR1		Smith	global_Author table (ga1)
PUBYEAR1		1997	global_RefCore table (grc1)
REFID1		Quaternary_Sci_Rev_16	global_RefCore table (grc1)
REFDOI1		10.1016/S0277-3791(96)00085-6	global_RefCore table (grc1)
REFDBID2		Smith:1987pleistocene	arch_tl_DataCore table (atdc)
…	…		…
REFDOI4			global_RefCore table (grc1)
FEATDATED		not related to a feature	arch_Sample table (ars)
SQUARE		dune field	arch_Sample table (ars)
XU		NA	arch_Sample table (ars)
SMPDEPTH		0.5	arch_Sample table (ars)
OCCUPATION		No	arch_Sample table (ars)
CONTEXT		Sterile	arch_Sample table (ars)
SMP_COMMT		NA	arch_Sample table (ars)
COL_MTD		Tube	cabah_col_mtdID table (ccmi)
LUM_MAT		Sediment	osl-tl_lum_matID table (otlmi)
MINERAL		Quartz	osl-tl_mineralID table (otmi)
SIZE_MIN	µm	90	arch_tl_DataCore table (atdc)
SIZE_MAX	µm	125	arch_tl_DataCore table (atdc)
H2O_MEAS	%	3	arch_tl_DataCore table (atdc)
H2O_USED	%	3	arch_tl_DataCore table (atdc)
H2O_ERR	%	-9999.99	arch_tl_DataCore table (atdc)
ALIQ_SIZE	mm	-9999.99	arch_tl_DataCore table (atdc)
ED_PROCABR		AS	osl-tl_ed_procID table (otepi)
RESCOR		ND	arch_tl_DataCore table (atdc)
AGEMODELAB		AVG	osl-tl_agemodelID table (otai)
PLAT_REG	°C	310-400	arch_tl_DataCore table (atdc)
AN_TEMP	°C	310	arch_tl_DataCore table (atdc)
NUM_MEAS		-9999	arch_tl_DataCore table (atdc)
EQUIVDOSE	Gy	0.53	arch_tl_DataCore table (atdc)
ED_ERR	Gy	0.09	arch_tl_DataCore table (atdc)
ED_SAT	Gy	-9999.99	arch_tl_DataCore table (atdc)
ED_SATERR	Gy	-9999.99	arch_tl_DataCore table (atdc)
U	ppm / μg/g	0.34	arch_tl_DataCore table (atdc)
U_ERR	ppm / μg/g	0.06	arch_tl_DataCore table (atdc)
U_MTDAB		NAA	osl-tl_mineralID table (otmi2)
TH	ppm / μg/g	2.04	arch_tl_DataCore table (atdc)
TH_ERR	ppm / μg/g	0.2	arch_tl_DataCore table (atdc)
TH_MTDAB		NAA	osl-tl_mineralID table (otmi3)
U_TH	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
U_TH_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
U_TH_MTDAB		NA	osl-tl_mineralID table (otmi8)
K	ppm / μg/g	0.12	arch_tl_DataCore table (atdc)
K_ERR	ppm / μg/g	0.01	arch_tl_DataCore table (atdc)
K_MTDAB		XRF	osl-tl_mineralID table (otmi4)
RB	ppm / μg/g	-9999.99	arch_tl_DataCore table (atdc)
U238	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
U238_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
RA226	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
RA226_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
PB210	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
PB210_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
RA228	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
RA228_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
TH228	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
TH228_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
TH232	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
TH232_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
K40	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
K40_ERR	Bq/kg	-9999.99	arch_tl_DataCore table (atdc)
ALPH	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
ALPH_ERR	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
ALPH_MTDAB		NA	osl-tl_mineralID table (otmi5)
BETA	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
BETA_ERR	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
BETA_MTDAB		ND	osl-tl_mineralID table (otmi6)
GAMMA	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
GAMMA_ERR	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
GAMMA_MTDA		ND	osl-tl_mineralID table (otmi7)
COSMIC	Gy/ka	0.22	arch_tl_DataCore table (atdc)
COSMIC_ERR	Gy/ka	0.02	arch_tl_DataCore table (atdc)
ALPH_I	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
ALPH_I_ERR	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
ALPH_I_MTD		ND	arch_tl_DataCore table (atdc)
BETA_I	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
BETA_I_ERR	Gy/ka	-9999.99	arch_tl_DataCore table (atdc)
BETA_I_MTD		ND	arch_tl_DataCore table (atdc)
DIFF_DOSE		Yes	arch_tl_DataCore table (atdc)
DOSERATE	Gy/ka	0.593	arch_tl_DataCore table (atdc)
DOSE_ERR	Gy/ka	0.021	arch_tl_DataCore table (atdc)
TL_AGE	ka	0.9	arch_tl_DataCore table (atdc)
TL_RNDERR	ka	-9999.99	arch_tl_DataCore table (atdc)
TL_ERR	ka	0.19	arch_tl_DataCore table (atdc)
AGE_CI		1s	arch_tl_DataCore table (atdc)
FADCOR		ND	arch_tl_DataCore table (atdc)
G_VAL	%/10a	-9999.99	arch_tl_DataCore table (atdc)
G_VAL_ERR	%/10a	-9999.99	arch_tl_DataCore table (atdc)
AGE_COMMT		Age based on total bleach method	arch_tl_DataCore table (atdc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

SahulChar_output

SahulChar output will be made available upon collection release.

IPPD_output

IPPD output will be made available upon collection release.

SahulSed output

Attention

👻 The below SahulSed collections 🍰 attribute / field tables should be considered the best case in terms of data / information completeness, respectively. For the output, however, we do not map fields with zero information content, i.e., where every single value is NULL, or ‘no data’.

SahulSed OSL output

Field Name	Unit	Example	Origin (Alias)
OBSID1		SED_FLV_OSL0001	sed-osl_DataCore table (sodc)
OBSID2		EF-03	sed-osl_DataCore table (sodc)
LABID		ND	sed-osl_DataCore table (sodc)
LAB_FACLTY		ND	cabah_LabCodes table (clc)
IGSNID		NA	sed-osl_DataCore table (sodc)
DBDOI		10.25900/p5ye-rn35	global_dbDOI table (gdd)
DBVERNO		2.2(1)	global_dbDOI table (gdd)
SMPID		SEDSM00605	sed_Sample table (ss)
SITEID		SEDST0319o.a	global_SiteMaster table (gsm)
METASITEID		NA	global_MetaSite table (gms)
METANAME		NA	global_MetaSite table (gms)
METHODABBR		OSL	c_mtdID table (cmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-TAS	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Huon River	global_SiteMaster table (gsm)
AHGFL1		TAS	global_rivID table (grid)
AHGFL2		TAS_06	global_rivID table (grid)
RIVNAME		Huon River	global_rivID table (grid)
RIVDIV		Tasmania	global_rivID table (grid)
IBRACODE		TWE	global_ibraID table (giid)
IBRAREGION		Tasmanian West	global_ibraID table (giid)
X_WGS84	decimal deg	146.35	global_SiteMaster table (gsm)
Y_WGS84	decimal deg	-43.04	global_SiteMaster table (gsm)
CORDS_ELEV		ORIG_INTP	global_SiteMaster table (gsm)
ELEVATION	m	309	global_SiteMaster table (gsm)
SITENAME		Lake Edgar	global_SiteMaster table (gsm)
SITE_SPEC		NA	global_SiteMaster table (gsm)
ALTNAME1		Terrace 1	global_SiteMaster table (gsm)
ALTNAME2		Footwall Block	global_SiteMaster table (gsm)
ALTNAME3		NA	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Clark:2011edgar	sed-osl_DataCore table (sodc)
OAID1		OAID-000950	global_RefCore table (grc1)
AUTHOR1		Clark	global_Author table (ga1)
PUBYEAR1		2011	global_RefCore table (grc1)
REFID1		Geol_Soc_Am_S_479	global_RefCore table (grc1)
REFDOI1		10.1130/2011.2479(05)	global_RefCore table (grc1)
REFDBID2		McCue:2003edgar	sed-osl_DataCore table (sodc)
…	…	…	…
REFDOI4			global_RefCore table (grc1)
SEDTYPE		FLV	sed_Sample table (ss)
GEOTYPE		Terrace	sed_geotypeID table (sg)
DEPCON			sed_depconID table (sdi)
DUNEFIELD			sed_Sample table (ss)
GEOMMOD			sed_geommodID table (sgi)
MORPH			sed_morphID table (smi)
DUNTRND	° (deg)		sed_Sample table (ss)
SITETYPE		Artificial excavation (trench)	sed_sitetypeID table (ssi)
DEPTHICK	m	-9999.99	sed_Sample table (ss)
SMPDEPTH	m	0.3	sed_Sample table (ss)
SED_MAT		Sa	global_GrainSize table (gss)
FACIES		ND	sed_faciesID table (sfi)
LAKETYPE			sed_laketypeID table (sli)
BEACHEI	m		sed_Sample table (ss)
BEACHAHD	m		sed_Sample table (ss)
SMP_COMMT		ND	sed_Sample table (ss)
COL_MTD		Tube	cabah_col_mtdID table (ccmi)
LUM_MAT		Sediment	osl-tl_lum_matID table (otlmi)
MINERAL		Quartz	osl-tl_mineralID table (otmi)
SIZE_MIN	µm	90	sed-osl_DataCore table (sodc)
SIZE_MAX	µm	125	sed-osl_DataCore table (sodc)
H2O_MEAS	%	15	sed-osl_DataCore table (sodc)
H2O_USED	%	15	sed-osl_DataCore table (sodc)
H2O_ERR	%	2.5	sed-osl_DataCore table (sodc)
OSL_TYPEAB		OSL	osl_typeID table (oti)
ALIQ_TYPE		SA	sed-osl_DataCore table (sodc)
ALIQ_SIZE	m	-9999.99	sed-osl_DataCore table (sodc)
ED_PROCABR		SAR	osl-tl_ed_procID table (otepi)
RESCOR		No	sed-osl_DataCore table (sodc)
DOSERECOV		No	sed-osl_DataCore table (sodc)
AGEMODELAB		CAM	osl-tl_agemodelID table (otai)
PH1_TEMP	°C	240	sed-osl_DataCore table (sodc)
PH2_TEMP	°C	-9999	sed-osl_DataCore table (sodc)
NUM_MEAS		-9999	sed-osl_DataCore table (sodc)
NUM_ACC		-9999	sed-osl_DataCore table (sodc)
EQUIVDOSE	Gy	14.8	sed-osl_DataCore table (sodc)
ED_ERR	Gy	0.8	sed-osl_DataCore table (sodc)
ED_INF		No	sed-osl_DataCore table (sodc)
OD		-9999.99	sed-osl_DataCore table (sodc)
OD_ERR		-9999.99	sed-osl_DataCore table (sodc)
OD_TYPE		ND	sed-osl_DataCore table (sodc)
U	ppm / μg/g	0.73	sed-osl_DataCore table (sodc)
U_ERR	ppm / μg/g	0.02	sed-osl_DataCore table (sodc)
U_MTDAB		NAA	osl-tl_mtdID table (otmi2)
TH	ppm / μg/g	2.13	sed-osl_DataCore table (sodc)
TH_ERR	ppm / μg/g	0.02	sed-osl_DataCore table (sodc)
TH_MTDAB		NAA	osl-tl_mtdID table (otmi3)
K	ppm / μg/g	0.36	sed-osl_DataCore table (sodc)
K_ERR	ppm / μg/g	0.01	sed-osl_DataCore table (sodc)
K_MTDAB		NAA	osl-tl_mtdID table (otmi4)
U238	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
U238_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
RA226	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
RA226_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
PB210	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
PB210_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
RA228	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
RA228_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
TH228	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
TH228_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
TH232	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
TH232_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
K40	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
K40_ERR	Bq/kg	-9999.99	sed-osl_DataCore table (sodc)
ALPH	Gy/ka	-9999.99	sed-osl_DataCore table (sodc)
ALPH_ERR	Gy/ka	-9999.99	sed-osl_DataCore table (sodc)
ALPH_MTDAB		ND	osl-tl_mtdID table (otmi5)
BETA	Gy/ka	0.35	sed-osl_DataCore table (sodc)
BETA_ERR	Gy/ka	0.02	sed-osl_DataCore table (sodc)
BETA_MTDAB		NAA	osl-tl_mtdID table (otmi6)
GAMMA	Gy/ka	0.19	sed-osl_DataCore table (sodc)
GAMMA_ERR	Gy/ka	0.01	sed-osl_DataCore table (sodc)
GAMMA_MTDA		FGS	osl-tl_mtdID table (otmi7)
COSMIC	Gy/ka	0.22	sed-osl_DataCore table (sodc)
COSMIC_ERR	Gy/ka	0.02	sed-osl_DataCore table (sodc)
ALPH_I	Gy/ka	0.03	sed-osl_DataCore table (sodc)
ALPH_I_ERR	Gy/ka	0.01	sed-osl_DataCore table (sodc)
ALPH_I_MTD		Assumed	sed-osl_DataCore table (sodc)
BETA_I	Gy/ka	-9999.99	sed-osl_DataCore table (sodc)
BETA_I_ERR	Gy/ka	-9999.99	sed-osl_DataCore table (sodc)
BETA_I_MTD		ND	sed-osl_DataCore table (sodc)
DIFF_DOSE		No	sed-osl_DataCore table (sodc)
DOSERATE	Gy/ka	0.79	sed-osl_DataCore table (sodc)
DOSE_ERR	Gy/ka	0.04	sed-osl_DataCore table (sodc)
OSL_AGE	ka	18.7	sed-osl_DataCore table (sodc)
OSL_RNDERR	ka	-9999.99	sed-osl_DataCore table (sodc)
OSL_ERR	ka	1.3	sed-osl_DataCore table (sodc)
AGE_CI		1s	sed-osl_DataCore table (sodc)
FADCOR		ND	sed-osl_DataCore table (sodc)
G_VAL	%/10a	-9999.99	sed-osl_DataCore table (sodc)
G_VAL_ERR	%/10a	-9999.99	sed-osl_DataCore table (sodc)
AGE_COMMT			sed-osl_DataCore table (sodc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

SahulSed TL output

Field Name	Unit	Example	Origin (Alias)
OBSID1		SED_FLV_TL0001	sed-tl_DataCore table (stdc)
OBSID2		W2409	sed-tl_DataCore table (stdc)
LABID		W2409	sed-tl_DataCore table (stdc)
LAB_FACLTY		UOW TL Dating Lab. Wollongong	cabah_LabCodes table (clc)
IGSNID		NA	sed-tl_DataCore table (stdc)
DBDOI		10.25900/2a76-vw55	global_dbDOI table (gdd)
DBVERNO		v2.2(1)	global_dbDOI table (gdd)
SMPID		SEDSM02174	sed_Sample table (ss)
SITEID		SEDST0464t.a	global_SiteMaster table (gsm)
METASITEID		NA	global_MetaSite table (gms)
METANAME		NA	global_MetaSite table (gms)
METHODABBR		TL	c_mtdID table (cmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-QLD	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Mulgrave-Russell Rivers	global_SiteMaster table (gsm)
AHGFL1		NEC	global_rivID table (grid)
AHGFL2		NEC_11	global_rivID table (grid)
RIVNAME		Mulgrave-Russell Rivers	global_rivID table (grid)
RIVDIV		North East Coast	global_rivID table (grid)
IBRACODE		WET	global_ibraID table (giid)
IBRAREGION		Wet Tropics	global_ibraID table (giid)
X_WGS84	decimal deg	145.8	global_SiteMaster table (gsm)
Y_WGS84	decimal deg	-17.1	global_SiteMaster table (gsm)
CORDS_ELEV		INTP_INTP	global_SiteMaster table (gsm)
ELEVATION	m	14	global_SiteMaster table (gsm)
SITENAME		Mulgrave River	global_SiteMaster table (gsm)
SITE_SPEC		NA	global_SiteMaster table (gsm)
ALTNAME1		Gordonvale	global_SiteMaster table (gsm)
ALTNAME2		Mulgrave Terrace	global_SiteMaster table (gsm)
ALTNAME3		NA	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Nott:2001wet	sed-tl_DataCore table (stdc)
OAID1		OAID-000347	global_RefCore table (grc1)
AUTHOR1		Nott	global_Author table (ga1)
PUBYEAR1		2001	global_RefCore table (grc1)
REFID1		Aust_J_Earth_Sci_48	global_RefCore table (grc1)
REFDOI1		10.1046/j.1440-0952.2001.00906.x	global_RefCore table (grc1)
REFDBID2			sed-osl_DataCore table (sodc)
…	…	…	…
REFDOI4			global_RefCore table (grc1)
SEDTYPE		FLV	sed_Sample table (ss)
GEOTYPE		Terrace	sed_geotypeID table (sg)
DEPCON			sed_depconID table (sdi)
DUNEFIELD			sed_Sample table (ss)
GEOMMOD			sed_geommodID table (sgi)
MORPH			sed_morphID table (smi)
DUNTRND	° (deg)		sed_Sample table (ss)
SITETYPE		Outcrop	sed_sitetypeID table (ssi)
DEPTHICK	m	11.3	sed_Sample table (ss)
SMPDEPTH	m	2	sed_Sample table (ss)
SED_MAT		Sa	global_GrainSize table (gss)
FACIES		Overbank	sed_faciesID table (sfi)
LAKETYPE			sed_laketypeID table (sli)
BEACHEI	m		sed_Sample table (ss)
BEACHAHD	m		sed_Sample table (ss)
SMP_COMMT		ND	sed_Sample table (ss)
COL_MTD		ND	cabah_col_mtdID table (ccmi)
LUM_MAT		Sediment	osl-tl_lum_matID table (otlmi)
MINERAL		Quartz	osl-tl_mineralID table (otmi)
SIZE_MIN	µm	90	sed-tl_DataCore table (stdc)
SIZE_MAX	µm	125	sed-tl_DataCore table (stdc)
H2O_MEAS	%	0.6	sed-tl_DataCore table (stdc)
H2O_USED	%	0.6	sed-tl_DataCore table (stdc)
H2O_ERR	%	-9999.99	sed-tl_DataCore table (stdc)
ALIQ_SIZE	mm	-9999	sed-tl_DataCore table (stdc)
ED_PROCABR		MAR	osl-tl_ed_procID table (otepi)
RESCOR		ND	sed-tl_DataCore table (stdc)
AGEMODELAB		AVG	osl-tl_agemodelID table (otai)
PLAT_REG	°C	300-500	sed-tl_DataCore table (stdc)
AN_TEMP	°C	375	sed-tl_DataCore table (stdc)
NUM_MEAS		-9999	sed-tl_DataCore table (stdc)
EQUIVDOSE	Gy	54	sed-tl_DataCore table (stdc)
ED_ERR	Gy	4.5	sed-tl_DataCore table (stdc)
ED_SAT	Gy	-9999.99	sed-tl_DataCore table (stdc)
ED_SATERR	Gy	-9999.99	sed-tl_DataCore table (stdc)
U	ppm / μg/g	-9999.99	sed-tl_DataCore table (stdc)
U_ERR	ppm / μg/g	-9999.99	sed-tl_DataCore table (stdc)
U_MTDAB		ND	osl-tl_mineralID table (otmi2)
TH	ppm / μg/g	-9999.99	sed-tl_DataCore table (stdc)
TH_ERR	ppm / μg/g	-9999.99	sed-tl_DataCore table (stdc)
TH_MTDAB		ND	osl-tl_mineralID table (otmi3)
U_TH	Bq/kg	71.5	sed-tl_DataCore table (stdc)
U_TH_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
U_TH_MTDAB		ND	osl-tl_mineralID table (otmi8)
K	ppm / μg/g	1.3	sed-tl_DataCore table (stdc)
K_ERR	ppm / μg/g	-9999.99	sed-tl_DataCore table (stdc)
K_MTDAB		ND	osl-tl_mineralID table (otmi4)
RB	ppm / μg/g	100	sed-tl_DataCore table (stdc)
U238	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
U238_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
RA226	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
RA226_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
PB210	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
PB210_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
RA228	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
RA228_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
TH228	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
TH228_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
TH232	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
TH232_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
K40	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
K40_ERR	Bq/kg	-9999.99	sed-tl_DataCore table (stdc)
ALPH	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
ALPH_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
ALPH_MTDAB		ND	osl-tl_mineralID table (otmi5)
BETA	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
BETA_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
BETA_MTDAB		ND	osl-tl_mineralID table (otmi6)
GAMMA	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
GAMMA_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
GAMMA_MTDA		ND	osl-tl_mineralID table (otmi7)
COSMIC	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
COSMIC_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
ALPH_I	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
ALPH_I_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
ALPH_I_MTD		ND	sed-tl_DataCore table (stdc)
BETA_I	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
BETA_I_ERR	Gy/ka	-9999.99	sed-tl_DataCore table (stdc)
BETA_I_MTD		ND	sed-tl_DataCore table (stdc)
DIFF_DOSE		No	sed-tl_DataCore table (stdc)
DOSERATE	Gy/ka	3.015	sed-tl_DataCore table (stdc)
DOSE_ERR	Gy/ka	0.059	sed-tl_DataCore table (stdc)
TL_AGE	ka	17.9	sed-tl_DataCore table (stdc)
TL_RNDERR	ka	-9999.99	sed-tl_DataCore table (stdc)
TL_ERR	ka	1.5	sed-tl_DataCore table (stdc)
AGE_CI		ND	sed-tl_DataCore table (stdc)
FADCOR		ND	sed-tl_DataCore table (stdc)
G_VAL	%/10a	-9999.99	sed-tl_DataCore table (stdc)
G_VAL_ERR	%/10a	-9999.99	sed-tl_DataCore table (stdc)
AGE_COMMT			sed-tl_DataCore table (stdc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

FosSahul output

Field Name	Unit	Example	Origin (Alias)
OBSID1		FOS00009	fos_polygons_EPSG3857 table (fpe)
OBSID2		NC4	fos_polygons_EPSG3857 table (fpe)
LABID		ND	fos_DataCore table (fdc)
LAB_FACLTY		ND	cabah_LabCodes table (clc)
IGSNID		NA	fos_DataCore table (fdc)
DBDOI		FosSahul_Odbv.2_no_DOI_minted	fos_DataCore table (fdc)
DBVERNO		2.2(1)	global_dbDOI table (gdd)
SMPID		FOSMP00008a	fos_DataCore table (fdc)
SITEID		FOSTE0003a	global_SiteMaster table (gsm)
METASITEID		META_FOS0057	global_MetaSite table (gms)
METANAME		Naracoorte Caves	global_MetaSite table (gms)
METHODABBR		OSL	c_mtdID table (cmi)
FOS_MTDSUB		ND	fos_mtdsID table (fmi)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		ND	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-SA	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		NA	global_SiteMaster table (gsm)
LAKE		NA	global_SiteMaster table (gsm)
BASIN		Millicent Coast	global_SiteMaster table (gsm)
AHGFL1		SEV	global_rivID table (grid)
AHGFL2		SEV_14	global_rivID table (grid)
RIVNAME		Millicent Coast	global_rivID table (grid)
RIVDIV		South East Coast (Victoria)	global_rivID table (grid)
IBRACODE		MDD	global_ibraID table (giid)
IBRAREGION		Murray Darling Depression	global_ibraID table (giid)
CORDS_ELEV		ND_ND	global_SiteMaster table (gsm)
ELEVATION	m	-9999.99	global_SiteMaster table (gsm)
SITENAME		Cathedral Cave	global_SiteMaster table (gsm)
SITE_SPEC		ND	global_SiteMaster table (gsm)
ALTNAME1		ND	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Prideaux:2007responses	fos_DataCore table (fdc)
OAID1		OAID-000365	global_RefCore table (grc1)
AUTHOR1		Prideaux	global_Author table (ga1)
PUBYEAR1		2007	global_RefCore table (grc1)
REFID1		Geology_35	global_RefCore table (grc1)
REFDOI1		10.1130/G23070A.1	global_RefCore table (grc1)
REFDBID2			fos_DataCore table (fdc)
…	…	…	…
REFDOI4			global_RefCore table (grc1)
FOSMAT1		Speleo	fos_fosmat1ID table (ffi)
FOSMAT2		Quartz	fos_fosmat2ID table (ffi2)
STRAT_TAPH		Strat, REFDBID3	fos_Sample table (fos)
SPEC_ABUND		Yes	fos_Sample table (fos)
SQUARE_XU		U. 3, 165 cm bel. dat.	fos_Sample table (fos)
SMP_COMMT		NA	fos_Sample table (fos)
SPECIES		pygmaeus	fos_TaxRank6_speciesID table (ftrsi)
GENUS		Acrobates	fos_TaxRank5_genusID table (ftrgi)
FAMILY		Acrobatidae	fos_TaxRank4_familyID table (ftrfi)
ORDR		Diprotodontia	fos_TaxRank3_ordrID table (ftroi)
INFRACLASS		Marsupialia	fos_TaxRank2_infraclaID table (ftrii)
CLASS		Mammalia	fos_TaxRank1_classID table (ftrci)
STATUS		Extant	fos_DataCore table (fdc)
MEGAFAUNA		No	fos_DataCore table (fdc)
C14_CALIB		NA	fos_DataCore table (fdc)
PHYSCLEAN		NA	fos_DataCore table (fdc)
CONTAM		NA	fos_DataCore table (fdc)
CHEMTYPEAB		NA	fos_DataCore table (fdc)
CHEMPREPAB		NA	cabah_chemprepID table (cci)
XTR_PROBLE		NA	fos_DataCore table (fdc)
CN_RATIO		-9999.99	fos_DataCore table (fdc)
PCT_N	%	-9999.99	fos_DataCore table (fdc)
C14_XRDIFF		NA	fos_DataCore table (fdc)
AAR_T_HIST		NA	fos_DataCore table (fdc)
AAR_CLOSD		NA	fos_DataCore table (fdc)
AAR_UNCERT		NA	fos_DataCore table (fdc)
AAR_INCAL		NA	fos_DataCore table (fdc)
U_TH_PRE		NA	fos_DataCore table (fdc)
U_TH_CLOSD		NA	fos_DataCore table (fdc)
U_TH_DCORR		NA	fos_DataCore table (fdc)
ESR_I_DR10		NA	fos_DataCore table (fdc)
ESR_GAMMA		NA	fos_DataCore table (fdc)
ALIQ_TYPE		SA	fos_DataCore table (fdc)
BLEACH_STS		Adequately	fos_DataCore table (fdc)
AGEMD_TRUE		NA	fos_DataCore table (fdc)
AGE	ka	292	fos_DataCore table (fdc)
AGE_ERR	ka	19	fos_DataCore table (fdc)
AGE_TYPE		Exact	fos_DataCore table (fdc)
AGE_CI		2SD	fos_DataCore table (fdc)
AGE_PREQ		m	fos_DataCore table (fdc)
AGE_Q		A	fos_DataCore table (fdc)
AGE_SUBQ		Within	fos_DataCore table (fdc)
AGE_ASSOC1		Indirect	fos_DataCore table (fdc)
AGE_ASSOC2		Yes	fos_DataCore table (fdc)
AGE_PREQ_R		All requirements met	fos_DataCore table (fdc)
AGE_Q_R		Indirect age	fos_DataCore table (fdc)
AGE_COMMT		NA	fos_DataCore table (fdc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

ExpAge output

Field Name	Unit	Example	Origin (Alias)
OBSID1		Kier2014-3a	expage_DataCore table (edc)
OBSID2		DR-2A	expage_DataCore table (edc)
IGSNID		NA	expage_DataCore table (edc)
DBDOI		expage_Odbv.2_no_DOI_minted	global_dbDOI table (gdd)
DBVERNO		2.2(1)	global_dbDOI table (gdd)
SMPID		Kier2014-3.den	expage_Sample table (es)
SITEID		Kier2014-A.z	global_SiteMaster table (gsm)
METASITEID		Kier2014-A	global_SiteMaster table (gsm)
CNTRY		AUS	global_SiteMaster table (gsm)
REGION_INT		Lake Rhona	global_SiteMaster table (gsm)
REGION_REG		AUS	global_SiteMaster table (gsm)
DIV_ADMIN		AU-TAS	global_SiteMaster table (gsm)
DIV_OTHER		NA	global_SiteMaster table (gsm)
ISL_NAME		Tasmania	global_SiteMaster table (gsm)
BASIN		Gordon River	global_SiteMaster table (gsm)
AHGFL1		TAS	global_rivID table (grid)
AHGFL2		TAS_08	global_rivID table (grid)
RIVNAME		Gordon River	global_rivID table (grid)
RIVDIV		Tasmania	global_rivID table (grid)
IBRACODE		TWE	global_ibraID table (giid)
IBRAREGION		Tasmanian West	global_ibraID table (giid)
X_WGS84	decimal deg	146.29	global_SiteMaster table (gsm)
Y_WGS84	decimal deg	-42.55	global_SiteMaster table (gsm)
CORDS_ELEV		INTP_ND	global_SiteMaster table (gsm)
ELEVATION	m	908	global_SiteMaster table (gsm)
SITE_COMMT		NA	global_SiteMaster table (gsm)
REFDBID1		Kiernan:2014denison	expage_DataCore table (edc)
OAID1		OAID-000303	global_RefCore table (grc1)
AUTHOR1		Kiernan	global_Author table (ga1)
PUBYEAR1		2014	global_RefCore table (grc1)
REFID1		Quaternary_Sci_Rev_97	global_RefCore table (grc1)
REFDOI1		10.1016/j.quascirev.2014.05.008	global_RefCore table (grc1)
REFDBID2			expage_DataCore table (edc)
…		…	…
REFDOI4			global_RefCore table (grc4)
MATERIAL		Boulder	expage_Sample table (es)
THICKNESS	cm	3.5	expage_Sample table (es)
DENSITY	g.cm^-3	2.7	expage_Sample table (es)
SHIELDING		0.978	expage_Sample table (es)
SMP_YR		2012	expage_Sample table (es)
SMP_COMMT		Latitudes and …	expage_Sample table (es)
BE10NP	atoms.g^-1	141000	expage_DataCore table (edc)
BE10NP_ERR	atoms.g^-1	7000	expage_DataCore table (edc)
BESTND		07KNSTD	expage_DataCore table (edc)
BECORR		1	expage_DataCore table (edc)
BE10AP	kyr	18.3	expage_DataCore table (edc)
BE10AP_ERR	kyr	1	expage_DataCore table (edc)
AL26NP	atoms.g^-1	930000	expage_DataCore table (edc)
AL26NP_ERR	atoms.g^-1	118000	expage_DataCore table (edc)
ALSTND		KNSTD	expage_DataCore table (edc)
ALCORR		1	expage_DataCore table (edc)
AL26AP	kyr	18	expage_DataCore table (edc)
AL26AP_ERR	kyr	2.7	expage_DataCore table (edc)
ABE_YR	kyr	17.719	expage_DataCore table (edc)
ABE_ERREXT	kyr	1.322	expage_DataCore table (edc)
ABE_ERRINT	kyr	0.884	expage_DataCore table (edc)
AAL_YR	kyr	16.607	expage_DataCore table (edc)
AAL_ERREXT	kyr	2.401	expage_DataCore table (edc)
AAL_ERRINT	kyr	2.124	expage_DataCore table (edc)

Tip

For detailed field / variable descriptions follow the links given under “Origin (Alias)”.

Footnotes

1

The deployed version of GeoServer does not accept dynamically generated PostgreSQL virtual tables (knows as “views”); therefore, the generation of static flat data tables was required to serve the purpose of a view. Newer versions of GeoServer, however, accept materialised views, and an upgrade would present a possible improvement in the database by eliminating the need to store duplicate data.

2

Be-10 and Al-26 concentrations (atoms g-1) were renormalised to the Nishiizumi 2007 Be-10 AMS standard (Nishiizumi et al., 2007) and to the Nishiizumi 2004 Al-26 AMS standard (Nishiizumi, 2004) respectively. Basin-wide denudation rates were recalculated with the open-source program CAIRN (Mudd et al., 2016) with the following parameter settings: (i) nuclide production from neutrons and muons was calculated with the approximation of Braucher et al. (2011) using a sea-level and high-latitude total production rate of 4.3 atoms g-1 yr-1 for Be-10 and of 31.1 atoms g-1 yr-1 for Al-26; (ii) latitude and altitude scaling factors were calculated using the time-independent Lal–Stone scaling scheme (Stone, 2000) with atmospheric pressure calculated via interpolation from the National Centers for Environmental Prediction NCEP2 reanalysis data (Compo et al., 2011); and (iii) topographic shielding was calculated from the same digital elevation model (DEM) using the method of Codilean (2006).