Data Fields |
|
Form of field description Source
Metadata SRC Survey
Metadata SVY Seafloor
Sample Sites SFS |
Seafloor
Type SFT Seafloor
Biota BIO Sediment
Thickness SDT Lithology
LTH Coastal
Geomorphology CST Colour
(Color) COL Petrology
PET |
Texture
TXT Grainsize
Analysis GRZ Sediment
Composition CMP Geochemistry
GCM Acoustic
Properties ACU Geotechnics
GTC Sediment
Hydrodynamics HYD |
Polygon
Description MIF Polyline
Vertices PYL Grid
Points GRD |
ColumnCode |
ORACLE_Code *** |
Data Type (CHAR,
NUMBER) |
Total Number of
Digits ** |
Number of Decimal
Places |
Unit of Measurement |
Upper Bound |
Lower Bound |
Null Default |
*** No
special characters allowed
SRC,
SOURCE_METADATA, 14, free, meta, , , ,
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
DataSetCode |
DATA_SET_CODE |
CHAR |
56 |
|
text |
|
|
|
DataOwnrCode |
DATA_OWNER_CODE |
CHAR |
56 |
|
text |
|
|
|
PersonName ** |
DATA_PERSON_NAME |
CHAR |
56 |
|
text |
|
|
|
SrceSecurCode |
SOURCE_SECURITY_CODE |
CHAR |
56 |
|
text |
|
|
|
RelsSecurCode |
RELEASE_SECURITY_CODE |
CHAR |
56 |
|
text |
|
|
|
AttrEntryMeth |
ATTRIBUTE_DATA_ENTRY_METHOD |
CHAR |
16 |
|
text |
|
|
|
PosnEntryMeth |
POSITION_ENTRY_METHOD |
CHAR |
16 |
|
text |
|
|
|
SrceTypCode |
SOURCE_TYPE_CODE |
CHAR |
56 |
|
text |
|
|
|
Region |
REGION |
CHAR |
16 |
|
text |
|
|
|
SAMPLING_DATE |
CHAR |
16 |
|
textcode |
|
|
|
|
REPORT_DATE |
CHAR |
16 |
|
textcode |
|
|
|
|
NavMethod |
NAVIGATION_METHOD |
CHAR |
16 |
|
text |
|
|
|
** Usually an email address
Template |
0,SRC, DataSetCode, DataOwnerCode, DataPerson, SourceSecurCode, ReleaseSecurCode, AttrEntryMeth, LocnEntryMeth, SourceTypCode, Region, SurveyDate, ReportDate, NavMethod |
SVY,
SURVEY_METADATA, 11, free, locn, , , ,
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
SurveyDate |
SURVEY_DATE |
CHAR |
16 |
|
textcode |
|
|
|
NavTechnology |
NAV_TECHNOLOGY |
CHAR |
16 |
|
text |
|
|
|
SrcNavAccuracy |
SOURCE_NAV_ACCURACY |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
LocnRegion |
SAMPLE_REGION |
CHAR |
16 |
|
text |
|
|
|
LWR_LFT_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
|
LWR_LFT_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
|
UPP_RHT_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
|
UPP_RHT_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
|
AttribMeasMethdCode |
ATTRIB_MEAS_METHD_CODE |
CHAR |
32 |
|
text |
|
|
|
Template |
0,SVY,SurvyDate,NavTechnol,NavAccuracy,SampleRegion,LLlat,LLlon,URlat,URlon,DataMeasMethd |
SFS,
SEAFLOOR SAMPLE SITES, 19, free, locn, , , ,
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
SiteName |
SITE_NAME |
CHAR |
30 |
|
text |
|
|
|
DECIMAL_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
|
DECIMAL_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
|
WATER_DEPTH |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
|
SampleRepos |
SAMPLE_REPOSITORY |
CHAR |
12 |
|
text |
|
|
|
DEPTH_MAXIMUM |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
|
DEPTH_MINIMUM |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
|
Sampler |
SAMPLING_DEVICE |
CHAR |
9 |
|
text |
|
|
|
CorePenetrn |
SAMPLER_PENETRATION |
NUMBER |
5 |
2 |
metres |
100 |
0 |
-99 |
CoreRecovy |
SAMPLER_RECOVERY |
CHAR |
16 |
|
text |
|
|
|
NavMethd |
NAVIGATION_METHOD |
CHAR |
16 |
|
text |
|
|
|
SITE_DATE |
CHAR |
16 |
|
textcode |
|
|
|
|
SiteTime |
SITE_TIME_(WITH_TIME_ZONE) |
CHAR |
16 |
|
text |
|
|
|
SiteTime |
PROVINCE |
CHAR |
16 |
|
text |
|
|
|
Operator |
OPERATOR |
CHAR |
16 |
|
text |
|
|
|
AODCQual |
AODC_QUALITY_INDEX |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
|
SiteNavAcc |
SITE_NAVIGATION_ACCURACY |
NUMBER |
6 |
3 |
kilometres |
0 |
120 |
-999 |
Template |
0,SFS, SampleType, DataType,.SiteName,.Latitude,.Longitude,.WaterDepth,.SampleRepos,.WDMax,.WDMin, Sampler, CorePenetrn, CoreRecovy, NavMethd, SiteDate, SiteTime, SiteTime, Operator, AODCQual, SiteNavAcc |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
SeaflrDescn |
SEAFLOOR_DESCRIPTION |
CHAR |
30 |
|
text |
|
|
|
SeaflrFeatrTyp |
FEATURE_TYPE |
CHAR |
30 |
|
text |
|
|
|
SeaflrFeatrWaveL |
FEATURE_WAVELENGTH |
NUMBER |
6 |
3 |
metres |
9999 |
0 |
-99 |
SeaflrFeatrHeight |
FEATURE_HEIGHT |
NUMBER |
6 |
3 |
metres |
999 |
0 |
-99 |
SeaflrFeatrSlope |
FEATURE_SLOPE |
NUMBER |
6 |
3 |
degrees |
360 |
0 |
-999 |
Template |
0,SFT, SampleType, DataType, SeaflrDescn, SeaflrFeatrTyp, SeaflrFeatrWaveL, SeaflrFeatrHeight, SeaflrFeatrSlope |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
BiotaType ** |
BIOTA_TYPE |
CHAR |
30 |
|
text |
|
|
|
BiotaAbund ** |
BIOTA_TYPE_ABUNDANCE |
CHAR |
30 |
|
text |
|
|
|
BiotaSize ** |
BIOTA_TYPE_SIZE |
NUMBER |
6 |
3 |
metres |
999 |
0 |
-99 |
BiotaForm ** |
BIOTA_TYPE_FORM |
CHAR |
30 |
|
text |
|
|
|
Biomass/Smpl |
BIOMASS_PER_SAMPLE |
NUMBER |
6 |
3 |
gm/sample |
9999 |
0 |
-99 |
PcntEpifauna |
EPIFAUNA_PERCENT |
NUMBER |
6 |
3 |
percent |
100 |
0 |
-99 |
BioDiversity |
BIODIVERSITY |
CHAR |
30 |
|
text |
|
|
|
BioticDescription |
BIOTIC_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
**
Occur also in SFT lines
Template |
0,BIO, SampleType, DataType, BiotaType, BiotaAbund, BiotaSize, BiotaForm, Biomass/Smpl, PcntEpifauna, BioDiversity, BioticDescription |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
SiteName |
SITE_NAME |
CHAR |
30 |
|
text |
|
|
|
DECIMAL_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
|
DECIMAL_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
|
WATER_DEPTH |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
|
SedThickness |
SEDIMENT_THICKNESS |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
Horizon |
BASAL_STRATIGRAPHIC_HORIZON |
CHAR |
20 |
|
|
|
|
|
ThknMeasTechn |
THICKNESS_MEASUREMENT_TECHNIQUE |
CHAR |
30 |
|
|
|
|
|
Template |
0,SDT, SampleType, DataType, SiteName, Latitude, Longitude, WaterDepth, SedThickness, Horizon, ThknMeasTechn |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
FieldLith |
FIELD_LITHOLOGY_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
FieldConsol |
FIELD_COMPACTION_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
FieldTexr |
FIELD_TEXTURE_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
LayrStruct |
LAYER_OR_STRUCTURE_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
GeolAge |
GEOLOGICAL_AGE_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
SedEnvir |
SEDIMENTARY_ENVIRONMENT |
CHAR |
256 |
|
text |
|
|
|
Colour ** |
COLOUR_DESCRIPTION |
CHAR |
20 |
|
text |
|
|
|
Sorting |
GRAINSIZE_SORTING_DESCRIPTION |
CHAR |
20 |
|
text |
|
|
|
HydroBotCode |
HYDROGRAPHIC_BOTTOM_CODE |
CHAR |
20 |
|
text |
|
|
|
GrainChar |
GRAIN_CHARACTER_DESCRIPTION |
CHAR |
20 |
|
text |
|
|
|
FreeFormLith |
FREE_FORM_LITHOLOGY_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
FreeFormLith |
ALTERATION
WEATHERING |
CHAR |
256 |
|
text |
|
|
|
MUNSELL_COLOUR_CODE |
CHAR |
20 |
|
text |
|
|
|
|
FolkSedClass |
FOLK_SEDIMENT_CLASS |
CHAR |
20 |
|
text |
|
|
|
**
Also found in COLOUR theme
Template |
0,LTH, SampleType, DataType, Top, Bot, FieldLith, FieldConsol, FieldTexr, LayrStruct, GeolAge, SedEnvir, Colour, Sorting, HydroBotCode, GrainChar, FreeFormLith, FreeFormLith, MunsellColour, FolkSedClass |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
RockCoastDominc |
ROCKY_COAST_DOMINANCE |
NUMBER |
5 |
1 |
fraction |
1 |
0 |
-99 |
SndyCoastDominc |
SANDY_COAST_DOMINANCE |
NUMBER |
5 |
1 |
fraction |
1 |
0 |
-99 |
MudyCoastDominc |
MUDDY_COAST_DOMINANCE |
NUMBER |
5 |
1 |
fraction |
1 |
0 |
-99 |
CoastGeologyFeat
** |
GEOLOGIC_FEATURES_DESCRIPTION |
CHAR |
256 |
|
text |
|
|
|
CoastLandscpFeat
** |
LANDSCAPE_FEATURES |
CHAR |
256 |
|
text |
|
|
|
**
Free-form - no front/ back/ weighting
Template |
0,CST, SampleType, DataType, RockCoastDominc, SndyCoastDominc, MudyCoastDominc, CoastGeologyFeat, CoastLandscpFeat |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
Colour ** |
COLOUR_DESCRIPTION |
CHAR |
20 |
|
text |
|
|
|
MUNSELL_COLOUR_CODE |
CHAR |
20 |
|
text |
|
|
|
**
These also found in LITHOLOGY theme
Template |
0,COL, SampleType, DataType, Top, Bot, Colour, MunsellColour |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
GrainTyp |
GRAIN_TYPE_DESCRIPTION |
CHAR |
9 |
|
text |
|
|
|
PcntGrainTyp |
PERCENT_OF_GRAIN_TYPE |
NUMBER |
3 |
0 |
percent |
100 |
0 |
-99 |
GrainTypSize |
GRAINTYPE_SIZE |
NUMBER |
6 |
1 |
mm |
|
|
-99 |
PcntMaxGrainTyp |
MAXIMUM_GRAINTYPE_ABUND |
NUMBER |
6 |
1 |
percent |
100 |
0 |
-99 |
PcntMinGraintyp |
MINIMUM_GRAINTYPE_ABUND |
NUMBER |
6 |
1 |
percent |
100 |
0 |
-99 |
GrainShape |
GRAIN_SHAPE_DESCRIPTION |
CHAR |
9 |
|
text |
|
|
|
GrainSorting |
GRAIN_SORTING_DESCRIPTION |
CHAR |
9 |
|
text |
|
|
|
GrainChar |
GRAIN_CHARACTER_DESCRIPTION |
CHAR |
9 |
|
text |
|
|
|
FrctnAvGrz |
FRACTN_AV_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
FractnStDevnGrz |
FRACTN_STDEVN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
FractnSkewn |
FRACTN_SKEWNESS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
FractnKurtos |
FRACTN_KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
FractnModes |
FRACTN_MODE_GRAINSIZES |
CHAR |
|
|
textcode |
|
|
|
PetEndFlag |
PET_END_FLAG |
CHAR |
6 |
|
textcode |
"PETend" |
|
|
Template |
0,PET, SampleType, DataType, Top, Bot, GrainTyp, PcntGrainTyp, GrainTypSize, PcntMaxGrainTyp, PcntMinGraintyp, GrainShape, GrainSorting, GrainChar, FrctnAvGrz, FractnStDevnGrz, FractnSkewn, FractnKurtos, FractnModes, PetEndFlag |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
PcntGvl |
PERCENT_GRAVEL |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
PcntSnd |
PERCENT_SAND |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
PcntSlt |
PERCENT_SILT |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
PcntCly |
PERCENT_CLAY |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
PcntMud |
PERCENT_MUD |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
MEDIAN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
AV_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
STDEVN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
LabTextr |
LAB_TEXTURE_DESCRIPTION |
CHAR |
32 |
|
text |
|
|
|
umGrz |
UM_GRAINSIZE |
NUMBER |
5 |
0 |
micrometers |
10000 |
0 |
-99 |
PcntGvlSnd |
PERCENT_GRAVEL_SAND |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
SndMednGrz **** |
SAND_MEDIAN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
AvSettlVeloc
*** |
AVERAGE_SETTLING_VELOCITY |
NUMBER |
5 |
2 |
cm/sec |
100 |
-10 |
-99 |
InclusGraphSkewn |
INCLSV_GRAPHIC_SKEWNESS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
GraphKurtos |
GRAPHIC_KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
NormGraphKurt |
NORMALIZED_GRPHC_KURT |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
UM_MUD_MEDIAN_GRAINSIZE |
NUMBER |
5 |
0 |
umeters |
10000 |
0 |
-99 |
|
ModeGrz ** |
MODE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndMode(s) |
SAND_MODE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
1ST_QUARTILE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
3RD_QUARTILE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
QUARTILE_SORTING |
NUMBER |
5 |
2 |
non_dim |
-6 |
12 |
-99 |
|
QUARTILE_SKEWN |
NUMBER |
5 |
2 |
non_dim |
-6 |
12 |
-99 |
|
1ST_DECILE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
9TH_DECILE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
SndGrphAv |
SAND_GRAPHIC_AVERAGE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndMdn |
SAND_MEDIAN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndInclGrphSD |
SAND_INCL_GRAPHIC_STDEVN |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndGrphSkewns |
SAND_GRAPHIC_SKEWNESS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndInclGrphKurtos |
SAND_INCLSV_GRAPHIC_KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndMean |
SAND_MEAN |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndSD |
SAND_SD |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndSkewn |
SAND_SKEWNESS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndKurtos |
SAND_KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
MudAv |
MUD_MEAN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
MUD_MEDIAN_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
MudSD |
MUDSD |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
TrrigSndMean |
TERRIG_SAND_MEAN |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
TrrigSndSD |
TERRIG_SAND_SD |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
InclGrSD |
INCLSV_GRAPHIC_STDEVN |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
INMAN_AVG |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
INMAN_SD |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
INMAN_SK1 |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
INMAN_SK2 |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
INMAN_K |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
SKEWNESS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
|
PcntSndMud |
PERCENT_SAND_MUD |
NUMBER |
5 |
1 |
percent |
101 |
0 |
-99 |
FolkGrphcMean |
FOLK_GRAPHIC_MEAN |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
SndMudRatio |
SAND_MUD_RATIO |
NUMBER |
8 |
3 |
ratio |
1000 |
0 |
-99 |
COEFF_UNIFORMITY |
|
|
|
|
|
|
|
**
Modes are separated by slashes - "4.3/-2/3.5"
***
Field duplicated in HYD
****
Field duplicated further below
See
the definition of phi
grainsize.
Template |
0,TXR, SampleType, DataType, Top, Bot, PcntGvl, PcntSnd, PcntSlt, PcntCly, PcntMud, MednGrz, AvGrz, StDevnGrz, LabTextr, umGrz, PcntGvlSnd, SndMednGrz, AvSettlVeloc, InclusGraphSkewn, GraphKurtos, NormGraphKurt, umMudGrz, ModeGrz, SndMode(s), FirstQuart, ThirdQuart, QuartSort, QuartSkewn, D10, D90, SndGrphAv, SndMdn, SndInclGrphSD, SndGrphSkewns, SndInclGrphKurtos, SndMean, SndSD, SndSkewn, SndKurtos, MudAv, MudMedn, MudSD, TrrigSndMean, TrrigSndSD, InclGrSD, InmAvg, InmSD, InmSk1, InmSk2, InmK, Skewn, Kurtos, PcntSndMud, FolkGrphcMean, SndMudRatio, CoefUniformity |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
CseGrszLim |
GRAINSIZE_COARSE_LIMIT |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
FneGrszLim |
GRAINSIZE_FINE_LIMIT |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
PcntInFrac |
PERCENT_IN_FRAC |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
MaxPcntFrac |
MAX/MIN_PERCENT_IN_FRAC |
CHAR |
16 |
|
textcode |
<100 |
>0 |
|
GrainTypeFrctn |
GRAIN_TYPE_FRAC |
CHAR |
16 |
|
textcode |
|
|
|
GrszFractn |
GRNSZ_FRAC |
CHAR |
16 |
|
textcode |
|
|
|
EndFlag |
RUN_END_FLAG |
CHAR |
6 |
|
textcode |
GRZend |
|
|
Template |
0,GRZ, SampleType, DataType, Top, Bot, CseGrszLim, FneGrszLim, PcntInFrac, MaxPcntFrac, GrainTypeFrctn, GrszFractn, EndFlag |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
PcntCaCO3 |
PERCENT_CACO3 |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntP2O5 |
PERCENT_P2O5 |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
CaCO3PcntInMud |
PERCENT_CACO3_IN_MUD |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
CaCO3PcntInSnd |
PERCENT_CACO3_IN_SAND |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
OrgCarbon |
PERCENT_ORGANIC_CARBON |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntFe2O3 |
PERCENT_FE2O3 |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntTiO2 |
PERCENT_TIO2 |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntAl2O3 |
PERCENT_Al2O3 |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntN |
PERCENT_N |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
PcntCaO |
PERCENT_CaO |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
CaCO3PcntInGvl |
PERCENT_CACO3_IN_GRAVEL |
NUMBER |
5 |
1 |
percent |
100 |
0 |
-99 |
Template |
0,CMP, SampleType, DataType, Top, Bot, PcntCaCO3, PcntP2O5, CaCO3PcntInMud, CaCO3PcntInSnd, OrgCarbon, PcntFe2O3, PcntTiO2, PcntAl2O3, PcntN, PcntCaO, CaCO3PcntInGvl |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
CmpntTyp |
CHEMICAL_COMPONENT_TYPE |
CHAR |
30 |
|
text |
|
|
|
CmpntPPM |
COMPONENT_ABUNDANCE |
NUMBER |
6 |
1 |
ppm |
10000 |
0 |
-99 |
CmpntPPMMax |
MAX_COMPONENT_ABUNDANCE |
NUMBER |
6 |
1 |
ppm |
10000 |
0 |
-99 |
CmpntPPMMin |
MIN_COMPONENT_ABUNDANCE |
NUMBER |
6 |
1 |
ppm |
10000 |
0 |
-99 |
Template |
0,GCM, SampleType, DataType, Top, Bot, CmpntTyp, CmpntPPM, CmpntPPMMax, CmpntPPMMin |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
|
Vp |
P_WAVE_VELOCITY |
NUMBER |
4 |
0 |
m/sec |
10000 |
0 |
-99 |
LabDens |
LAB_DENSITY |
NUMBER |
5 |
2 |
gm/cm^3 |
5 |
0 |
-99 |
GRAPEDens |
GRAPE_DENSITY |
NUMBER |
5 |
2 |
gm/cm^3 |
5 |
0 |
-99 |
%WaterWetWt |
PERCENT_WATER_WET_WEIGHT |
NUMBER |
3 |
0 |
percent |
100 |
0 |
-99 |
Porosity |
POROSITY |
NUMBER |
3 |
0 |
percent |
100 |
0 |
-99 |
Vs |
S_WAVE_VELOCITY |
NUMBER |
4 |
0 |
m/sec |
1000 |
0 |
-99 |
DryDens |
DRY_DENSITY |
NUMBER |
5 |
2 |
gm/cm^3 |
5 |
0 |
-99 |
VoidRatio |
VOID_RATIO |
NUMBER |
5 |
2 |
ratio |
10 |
0 |
-99 |
%MoistDryWt |
PERCENT_MOISTURE_DRY_WEIGHT |
NUMBER |
3 |
0 |
percent |
300 |
0 |
-99 |
GrainDens |
GRAIN_DENSITY |
NUMBER |
5 |
2 |
gm/cm^3 |
5 |
0 |
-99 |
VelocRatioVs/Vo |
VELOCITY_RATIO_VS_V0 |
|
|
|
ratio |
|
|
|
MeasFreq |
MEAS_FREQ |
|
|
|
kHz |
|
|
|
PWaveAtten |
P_WAVE_ATTEN |
|
|
|
dB/m |
|
|
|
ShearModulus |
|
|
|
|
|
|
|
|
k (10-12)' |
|
|
|
|
|
|
|
|
Archie |
|
|
|
|
|
|
|
|
IntragrPor |
|
|
|
|
percent |
|
|
|
VpVert |
|
|
|
|
m/sec |
|
|
|
VpHoriz |
|
|
|
|
m/sec |
|
|
|
VpGradient |
|
|
|
|
/s |
|
|
|
Impedance |
|
|
|
|
kg m/s |
|
|
|
RelaxnTime |
|
|
|
|
usec |
|
|
|
Attenuation |
|
|
|
|
|
|
|
|
QualityFactor |
|
|
|
|
|
|
|
|
PoissonsRatio |
|
|
|
|
|
|
|
|
ShearMod |
|
|
|
|
|
|
|
|
FrameBulkMod |
|
|
|
|
|
|
|
|
Saturation |
|
|
|
|
|
|
|
|
SatdVoidRat |
|
|
|
|
|
|
|
|
MeasTemp |
|
|
|
|
degC |
|
|
|
Template |
0,ACU, SampleType, DataType, Top, Bot, Vp, LabDens, GRAPEDens, %WaterWetWt, Porosity, Vs, DryDens, VoidRatio, %MoistDryWt, GrainDens, VelocRatioVs/Vo, MeasFreq, PWaveAttenkp, ShearModulus, k (10-12)', Archie, IntragrPor, VpVert, VpHoriz, VpGradient, Impedance, RelaxnTime, Attenuation, QualityFactor, PoissonsRatio, ShearMod, FrameBulkMod, Saturation, SatdVoidRat, MeasTemp |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
|
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
|
TOP_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
||
BASE_SUBBOTTOM_DEPTH |
NUMBER |
6 |
2 |
metres |
10000 |
0 |
-99 |
||
HandPenetrStr |
HAND_PENETR_STRENGTH |
NUMBER |
6 |
2 |
kPascal |
1000 |
0 |
-99 |
|
ThermConduct |
THERMAL_CONDUCTIVITY |
NUMBER |
4 |
3 |
Watts/m/K |
10 |
0 |
-99 |
|
LiquidLim |
LIQUID_LIMIT |
NUMBER |
4 |
1 |
percent |
300 |
0 |
-99 |
|
PlasticLim |
PLASTIC_LIMIT |
NUMBER |
4 |
1 |
percent |
300 |
0 |
-99 |
|
PlasticIndx |
PLASTICITY_INDEX |
NUMBER |
4 |
1 |
percent |
300 |
0 |
-99 |
|
ComprShrStr |
COMPRESSIONAL_SHEAR_STRENGTH |
NUMBER |
5 |
1 |
kPa |
5000 |
0 |
-99 |
|
UnifiedSoilClassn |
UNIFIED_SOIL_CLASSIFICATION |
CHAR |
20 |
|
text |
|
|
|
|
VaneShearStr |
VANE_SHEAR_STRENGTH |
NUMBER |
5 |
1 |
kPascal |
1000 |
0 |
-99 |
|
TriaxFrictAngle |
TRIAXIAL_FRICT_ANGLE |
NUMBER |
3 |
1 |
degrees |
60 |
0 |
-99 |
|
BulkDensity |
BULK_DENSITY |
NUMBER |
3 |
2 |
gm/cm^3 |
5 |
0 |
-99 |
|
Permeability |
PERMEABILITY |
NUMBER |
8 |
3 |
mDarcy |
99999 |
0 |
-99 |
|
TriaxCohesion |
TRIAXIAL_COHESION |
NUMBER |
6 |
2 |
kPascal |
1000 |
0 |
-99 |
|
ConeResistance |
CONE_RESISTANCE |
NUMBER |
6 |
2 |
Newton/m^2 |
1000 |
0 |
-99 |
|
BlowPenetrn ** |
BLOW_PENETRATION |
NUMBER |
6 |
2 |
blows/m or
m/blow |
10 |
0 |
-99 |
|
ShearBoxCohes |
SHEAR_BOX_COHESION |
NUMBER |
6 |
2 |
kPascal |
1000 |
0 |
-99 |
|
ShearBoxFrictAngle |
SHEAR_BOX_FRICTION_ANGLE |
NUMBER |
3 |
1 |
degrees |
60 |
0 |
-99 |
|
ProbePenMin |
PROBE_PENTRN_MIN |
NUMBER |
6 |
2 |
m |
1000 |
0 |
-99 |
|
ProbePenMin |
PROBE_PENTRN_MAX |
NUMBER |
6 |
2 |
m |
1000 |
0 |
-99 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
**
Ambiguous in units
Template |
0,GTC, SampleType, DataType, Top, Bot, HandPenetrStr, ThermConduct, LiquidLim, PlasticLim, PlasticIndx, ComprShrStr, UnifiedSoilClassn, VaneShearStr, TriaxFrictAngle, BulkDensity, Permeability, TriaxCohesion, ConeResistance, BlowPenetrn, ShearBoxCohes, ShearBoxFrictAngle, ProbePenMin, ProbePenMin, Vane Shear Strength at Failure (kPa), Over Consolidation Ratio (OCR), Init Void Ratio (or max), Final Void Ratio (or min), Special Measurement Conditions, Liquidity Index (LI), Remolded Vane Shear Strength (kPa), Compression INDX, Coefficient of Consolidation, Pre-consolidation Stress, Effective Overburden Stress, Natural Compressive Stress, Remolded Compressive Stress, Cohesion Remolded, Shear Strength Method, Modulus of Elasticity, Activity, Angle of Internal Friction (deg) |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
ExpNme |
EXPERIMENT_NAME |
CHAR |
30 |
|
text |
|
|
|
AvSettlVeloc
** |
AVERAGE_SETTLING_VELOCITY |
NUMBER |
6 |
2 |
cm/sec |
100 |
-10 |
-99 |
InitD50mm |
INITIAL_MEDIAN_GRAINSIZE_MM |
NUMBER |
4 |
2 |
mm |
1000 |
0 |
-99 |
CritErosVeloc |
CRITICAL_EROSION_VELOCITY |
NUMBER |
4 |
2 |
cm/sec |
1000 |
0 |
-99 |
ExpVeloc |
EXPR_VELOCITY |
NUMBER |
4 |
2 |
cm/sec |
1000 |
0 |
-99 |
ExpSedTranspRate |
EXPR_SEDIMENT_TRANSPORT_RATE |
NUMBER |
4 |
2 |
ugm/cm/sec |
100 |
0 |
-99 |
ExpBdLoadAvGrz |
EXPR_BEDLOAD_AVERAGE_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
ExpBdLoadSDGrz |
EXPR_STANDARD_DEVIATION_GRAINSIZE |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
ExpBdLoadInclGraphSkewn |
EXPR_INCLUSIVE_GRAPHIC_SKEW |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
ExpBdLoadGraphKurtos |
EXPR_GRAPHIC_KURTOSIS |
NUMBER |
5 |
2 |
phi |
-6 |
12 |
-99 |
**
Field is duplicated in TXR
Template |
0,HYD, SampleType, DataType, ExpNme, AvSettlVeloc, InitD50mm, CritErosVeloc, ExpVeloc, ExpSedTranspRate, ExpBdLoadAvGrz, ExpBdLoadSDGrz, ExpBdLoadInclGraphSkewn, ExpBdLoadGraphKurtos |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
PolyLineName |
VERTX_POLYLN_NAME |
CHAR |
30 |
|
text |
|
|
|
Latitude |
DECIMAL_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
Longitude |
DECIMAL_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
WaterDepth |
WATER_DEPTH |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
PolyLineClosure |
POLYLN_CLOSED_FLAG |
CHAR |
1 |
|
text |
y |
n |
|
PolyLineEnd |
POLYLN_END_FLAG |
CHAR |
1 |
|
text |
y |
n |
|
Template |
0,PYL, SampleType, DataType, PolyLineName, Latitude, Longitude, WaterDepth, PolyLineClosure, PolyLineEnd |
SampleType |
SAMPLE_TYPE_CODE |
NUMBER |
6 |
3 |
numcode |
9 |
0 |
-99 |
DataType |
DATA_TYPE_CODE |
CHAR |
30 |
|
textcode |
|
|
|
GridPointName |
GRID_POINT_NAME |
CHAR |
30 |
|
text |
|
|
|
Latitude |
DECIMAL_LATITUDE |
NUMBER |
6 |
3 |
degrees |
90 |
-90 |
-999 |
Longitude |
DECIMAL_LONGITUDE |
NUMBER |
6 |
3 |
degrees |
180 |
-180 |
-999 |
WaterDepth |
WATER_DEPTH |
NUMBER |
5 |
0 |
metres |
13000 |
0 |
-99 |
GridEnd |
GRID_END_FLAG |
CHAR |
1 |
|
text |
GRIDend |
|
|
Template |
0,GRD, SampleType, DataType, GridPointName, Latitude, Longitude, WaterDepth, GridEnd |
CJ
Jenkins
The
University of Sydney University
17
Aprl 2001