|
POTENTIAL FIELD DATA |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
Magnetic field strength |
|
|
|
|
fd_mag_id |
magnetic field strength ID |
An identifier for linking with other tables |
mediumint |
|
fs_id |
fields station ID |
The identifier for linking to station information |
mediumint |
|
fd_mag_time |
Measurement time |
Measurement time in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
fd_mag_f |
F |
Total field strength |
xxxxx.xx |
nT |
fd_mag_compx |
X |
X Component |
xxxxx.xx |
nT |
fd_mag_compy |
Y |
Y Component |
xxxxx.xx |
nT |
fd_mag_compz |
Z |
Z Component |
xxxxx.xx |
nT |
fd_mag_ferr |
Tot field strength uncertainty (F) |
Tot field strength uncertainty |
xx.xx |
nT |
fd_mag_errx |
Component X uncertainty |
The uncertainty in the x component measurement |
xx.xx |
nT |
fd_mag_erry |
Component Y uncertainty |
The uncertainty in the y component measurement |
xx.xx |
nT |
fd_mag_errz |
Component Z uncertainty |
The uncertainty in the z component measurement |
xx.xx |
|
fd_mag_ref_stnid |
Reference stn code |
A link to information about the reference station |
mediumint |
|
fd_mag_highpass |
Highpass |
If there is a highpass, please enter the value in Hz above which you are measuring all frequencies. |
xx.x |
Hz |
fd_mag_lowpass |
Lowpass |
If there is a lowpass, please enter the value in Hz below which you are measuring all frequencies. |
xx.x |
Hz |
fd_mag_hbandpass |
High bandpass value |
If you are measuring bandpass, please enter the high value in Hz for the range you are measuring. |
xx.x |
Hz |
fd_mag_lbandpass |
Low bandpass value |
If you are measuring bandpass, please enter the low value in Hz for the range you are measuring. |
xx.x |
Hz |
fd_mag_comm |
Comments |
Comments on the magnetic measurements. |
varchar(255) |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
ci_id |
Instrument ID |
An identifier for linking to instrument information. |
mediumint |
|
fd_mag_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
|
|
|
|
|
Magnetic Vector Data |
|
|
|
|
fd_mgv_id |
magnetic vector ID |
An identifier for linking with other tables |
mediumint |
|
fs_id |
fields station ID |
The identifier for linking to station information |
mediumint |
|
fd_mgv_time |
Measurement time |
Measurement time in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
fd_mgv_dec |
Declination |
Declination |
xxx |
deg 0-360 |
fd_mgv_incl |
Inclination |
Inclination |
sxx |
deg 0-90 |
fd_mgv_comm |
Comments |
Comments |
varchar(255) |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
ci_id |
Instrument ID |
An identifier for linking to instrument information. |
mediumint |
|
fd_mgv_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Electric |
|
|
|
|
fd_ele_id |
electric data ID |
An identifier for linking with other tables |
mediumint |
|
fs_id1 |
Ref station 1 ID |
The identifier for linking to the station information from which the electrode is subtracted (station A in the equation A - B). |
mediumint |
|
fs_id2 |
Ref station 2 ID |
The identifier for linking to the station information for the electrode that's being subtracted (station B in the equation A - B). |
mediumint |
|
fd_ele_time |
Measurement time |
Measurement time in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
fd_ele_ef |
Electric field |
Electric field (difference/distance). |
sxxxx |
mV |
fd_ele_ef_err |
Electric field uncertainty |
Electric field uncertainty |
xxx |
mV |
fd_ele_dir |
Direction |
Direction from station 1 to station 2 (angle with respect to North) |
xxx |
deg 0-360 |
fd_ele_highpass |
Highpass |
If there is a highpass, please enter the value in Hz above which you are measuring all frequencies. |
xx.x |
Hz |
fd_ele_lowpass |
Lowpass |
If there is a lowpass, please enter the value in Hz below which you are measuring all frequencies. |
xx.x |
Hz |
fd_ele_hbandpass |
High bandpass value |
If you are measuring bandpass, please enter the high value in Hz for the range you are measuring. |
xx.x |
Hz |
fd_ele_lbandpass |
Low bandpass value |
If you are measuring bandpass, please enter the low value in Hz for the range you are measuring. |
xx.x |
Hz |
fd_ele_spot |
Self Potential |
Self potential |
sxxxx |
mV |
fd_ele_spot_err |
Self potential uncertainty |
Self potential uncertainty |
xxx |
mV |
fd_ele_appres |
Apparent Resistivity |
Apparent Resistivity |
xxxx |
ohm-m |
fd_ele_appres_err |
Apparent Resistivity uncertainty |
Uncertainty in apparent resistivity |
xxx |
ohm-m |
fd_ele_dirres |
Direct Resistivity |
Direct Resistivity |
xxxx |
ohm-m |
fd_ele_dirres_err |
Direct Resistivity uncertainty |
Uncertainty in direct resistivity |
xxx |
ohm-m |
fd_ele_comm |
Comments |
Comments about the measurements |
text |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
ci_id |
Instrument ID |
An identifier for linking to instrument information. |
mediumint |
|
fd_ele_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Gravity |
|
|
|
|
fd_gra_id |
gravity data ID |
An identifier for linking with other tables |
mediumint |
|
fs_id |
fields station ID |
The identifier for linking to station information |
mediumint |
|
fd_gra_time |
Measurement time |
Measurement time in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
fd_gra_fstr |
Field strength (g) |
Field strength (g) |
xxxx.xxx |
Gal |
fd_gra_fstr_err |
Field strength (g) uncertainty |
Field strength (g) uncertainty |
xxxx.x |
MicroGal |
fd_gra_vdisp |
Assoc vertical displ |
Comment on associated vertical displacement, if applicable (leave blank if unknown, please use 'none' if the value is known as none). |
text |
|
fd_gra_gwater |
Assoc gwater level |
Comment on associated groundwater level, if applicable (leave blank if unknown, please use 'none' if the value is known as none). |
text |
|
fd_gra_ref_stnid |
Ref station |
Link to reference station information. This station is measured in the beginning and end of each set of measurements. |
mediumint |
|
fd_gra_comm |
Comments |
Comments about the measurements |
varchar(255) |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
ci_id |
Instrument ID |
An identifier for linking to instrument information. |
mediumint |
|
fd_gra_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|
Fields Station Table |
|
|
|
|
fs_id |
Fields station table ID |
An identifier for linking with other tables |
mediumint |
|
cn_id |
network id |
For linking to a network if applicable |
mediumint |
|
fs_code |
station code |
The code name given by the observatory |
text |
|
fs_nam |
station name |
The name of the benchmark or station |
text |
|
fs_nlat |
latitude |
The latitude of the station |
sxx.xxxxxxx |
deg lat |
fs_nlon |
longitude |
The longitude of the station |
sxxx.xxxxxxx |
deg long |
fs_nelev |
elevation |
The nominal elevation of the station |
sxxxx |
m |
fs_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
fs_utc |
difference from UTC |
Time zone relative to UTC - "s" = sign; read as GMT +- xx h. Will be used to convert data to local time where needed. |
sxx.x |
|
fs_est |
date established |
The date the station was set up |
datetime |
|
fs_dest |
stop date |
The date the station was permanently decommissioned. See observatory for station operation history. |
datetime |
|
fs_desc |
Station description |
A description of the station or any comments |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information concerning this data from the contact table. |
mediumint |
|
fs_loaddate |
Load date |
The date this row was entered |
datetime |
|
cc_id_load |
Data loader ID |
The id linking to the person who entered this row of data |
mediumint |
|
|
|
|
|
|