Database fields, all categories

Sample identification
idUnique record identifier
fieldnoField number assigned by the submitter designated in the SUBNAME field.
Geographic location
latdmsLatitude of sample site reported in degrees, minutes, and seconds (ddmmss).
latdirDirection north (N) or south (S) of the equator.
londmsLongitude of the sample site reported in degrees, minutes, and seconds (ddmmss).
longdirDirection east (E) or west (W) of the 0 meridian (Greenwich).
latitudeLatitude of sample site reported in Decimal Degress.
longitudeLongitude of sample site reported in Decimal Degress.
Processing information
subnameSubmitter's name, name of the individual who submitted the samples to the laboratory for analysis.
jobnumberLaboratory job number assigned by the analytical laboratory. One job number may contain from one to a few hundred samples.
tagnumberUnique identification number assigned by the laboratory.
Sample characteristics
smpltypeSample type, nature of material collected for sample.
methcollSample collection method, character of sample
smplsrcSource of sample
Chemical analysis
s_fe_qQuality indicator for semi-quantitative emission spectrometric measure of Fe
s_fe_Iron concentration (percent) as determined by semi-quantitative emission spectrometry.
s_mg_qQuality indicator for semi-quantitative emission spectrometric measure of Mg
s_mg_Magnesium concentration (percent) as determined by semi-quantitative emission spectrometry.
s_ca_qQuality indicator for semi-quantitative emission spectrometric measure of Ca
s_ca_Calcium concentration (percent) as determined by semi-quantitative emission spectrometry.
s_ti_qQuality indicator for semi-quantitative emission spectrometric measure of Ti
s_ti_Titanium concentration (percent) as determined by semi-quantitative emission spectrometry.
s_mnqQuality indicator for semi-quantitative emission spectrometric measure of Mn
s_mnManganese concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_agqQuality indicator for semi-quantitative emission spectrometric measure of Ag
s_agSilver concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_asqQuality indicator for semi-quantitative emission spectrometric measure of As
s_asArsenic concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_auqQuality indicator for semi-quantitative emission spectrometric measure of Au
s_auGold concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_bqQuality indicator for semi-quantitative emission spectrometric measure of B
s_bBoron concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_baqQuality indicator for semi-quantitative emission spectrometric measure of Ba
s_baBarium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_beqQuality indicator for semi-quantitative emission spectrometric measure of Be
s_beBeryllium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_biqQuality indicator for semi-quantitative emission spectrometric measure of Bi
s_biBismuth concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_cdqQuality indicator for semi-quantitative emission spectrometric measure of Cd
s_cdCadmium concenration (parts per million) as determined by semi-quantitative emission spectrometry.
s_coqQuality indicator for semi-quantitative emission spectrometric measure of Co
s_coCobalt concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_crqQuality indicator for semi-quantitative emission spectrometric measure of Cr
s_crChromium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_cuqQuality indicator for semi-quantitative emission spectrometric measure of Cu
s_cuCopper concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_laqQuality indicator for semi-quantitative emission spectrometric measure of La
s_laLanthanum concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_moqQuality indicator for semi-quantitative emission spectrometric measure of Mo
s_moMolybdenum concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_nbqQuality indicator for semi-quantitative emission spectrometric measure of Nb
s_nbNiobium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_niqQuality indicator for semi-quantitative emission spectrometric measure of Ni
s_niNickel concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_pbqQuality indicator for semi-quantitative emission spectrometric measure of Pb
s_pbLead concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_sbqQuality indicator for semi-quantitative emission spectrometric measure of Sb
s_sbAntimony concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_scqQuality indicator for semi-quantitative emission spectrometric measure of Sc
s_scScandium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_snqQuality indicator for semi-quantitative emission spectrometric measure of Sn
s_snTin concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_srqQuality indicator for semi-quantitative emission spectrometric measure of Sr
s_srStrontium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_vqQuality indicator for semi-quantitative emission spectrometric measure of V
s_vVanadium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_wqQuality indicator for semi-quantitative emission spectrometric measure of W
s_wTungsten concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_yqQuality indicator for semi-quantitative emission spectrometric measure of Y
s_yYttrium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_znqQuality indicator for semi-quantitative emission spectrometric measure of Zn
s_znZinc concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_zrqQuality indicator for semi-quantitative emission spectrometric measure of Zr
s_zrZirconium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
s_thqQuality indicator for semi-quantitative emission spectrometric measure of Th
s_thThorium concentration (parts per million) as determined by semi-quantitative emission spectrometry.
aa_au_pqQuality indicator for AA measure of Au
aa_au_pGold concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
inst_hgqQuality indicator for INST_HG value
inst_hgMercury concentration (parts per million) as determined by an instrumental technique such as cold vapor atomic absorption spectrometry.
aa_as_pqQuality indicator for AA measure of As
aa_as_pArsenic concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
aa_cd_pqQuality indicator for AA measure of Cd
aa_cd_pCadmium concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
aa_sb_pqQuality indicator for AA measure of Sb
aa_sb_pAntimony concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
aa_zn_pqQuality indicator for AA measure of Zn
aa_zn_pZinc concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
aa_cu_pqQuality indicator for AA measure of Cu
aa_cu_pCopper concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
aa_pb_pqQuality indicator for AA measure of Pb
aa_pb_pLead concentration (parts per million) as determined by partial extraction of the sampled followed by atomic absorption spectrometry.
aa_ag_pqQuality indicator for AA measure of Ag
aa_ag_pSilver concentration (parts per million) as determined by partial extraction of the sample followed by atomic absorption spectrometry.
si_fqQuality indicator for SI_F
si_fFluorine concentration (parts per million) as determined by specific ion electrode.
u_instqQuality indicator for U_INST value
u_instUranium concentration (parts per million) as determined by an instrumental technique such as fluorimetry.
as_ptqQuality indicator for AS_PT
as_ptPlatinum concentration (parts per million) as determined by fire assay emission spectrometry.
as_pdqQuality indicator for AS_PD
as_pdPaladium concentration (parts per million) as determined by fire assay emission spectrometry.
cm_asqQuality indicator for CM_AS
cm_asArsenic concentration (parts per million) as determined by colorimetry.
cm_moqQuality indicator for CM_MO
cm_moMolybdenum concentration (parts per million) as determined by colorimetry.
cm_wqQuality indicator for CM_W
cm_wTungsten concentration (parts per million) as determined by colorimetry.