|
GEODETIC DATA |
|
|
|
Attribute |
Attribute Name |
Description |
Format |
Units |
|
|
|
|
|
Electronic tilt data |
|
|
|
|
dd_tlt_id |
tilt data ID |
An identifier for linking with other tables |
autonumber |
|
ds_tlt_id |
tilt station ID |
An identifier for linking to station information |
mediumint |
|
gi_id |
Tilt/Strain Instrument ID |
An identifier for linking with the tilt/strain instrument table. This table gives conversion information for processing raw data. |
mediumint |
|
dd_tlt_time |
time |
The measurement time in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_tlt_srate |
sampling rate |
The sampling rate for this data in seconds. |
xxxxxxxx |
seconds |
dd_tlt1 |
Tilt 1 |
Tilt measurement 1 or x (positive is down to the north). |
sxxxxxx |
Volts |
dd_tlt2 |
Tilt 2 |
Tilt measurement 2 or y (positive is down to the east) |
sxxxxxx |
Volts |
dd_tlt_err1 |
Tilt 1 error |
Error from all sources (instrument, rain, diurnal heating, etc) for tilt 1. |
xxx |
Volts |
dd_tlt_err2 |
Tilt 2 error |
Error from all sources (instrument, rain, diurnal heating, etc) for tilt 2. |
xxx |
Volts |
dd_tlt_proc_flg |
Processed data flag |
A flag that this data has already been processed and does not require a link to the instrument table for conversions. |
tinyint |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_tlv_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 |
|
|
|
|
|
|
|
|
|
|
|
Tilt Vector Data |
|
|
|
|
dd_tlv_id |
tilt vector data id |
An identifier for linking with other tables |
autonumber |
|
ds_tlv_id |
tilt station ID |
An identifier for linking with the station table |
mediumint |
|
dd_tlv_sti |
Start time |
Start time of measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_tlv_fti |
Stop time |
End time of measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_tlv_mag |
Tilt magnitude |
Magnitude of the tilt vector (the length). |
xxxxx |
microradians |
dd_tlv_azi |
Tilt azimuth |
Azimuth of downward tilt |
xxx |
deg 0-360 |
dd_tlv_magerr |
magnitude error |
The magnitude error. |
xxx |
microradians |
dd_tlv_azierr |
azimuth error |
The azimuth error. |
xx |
deg angular |
dd_tlt_com |
Comments |
Comments about possible artifacts |
varchar(255) |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
ds_tlv_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 |
|
|
|
|
|
|
Strainmeter data |
|
|
|
|
dd_str_id |
Strain Data ID |
An identifier for linking with other tables |
autonumber |
|
ds_tlt_id |
Strainmeter station id |
An identifier for linking with the station table |
mediumint |
|
gi_id |
Tilt/Strain Instrument ID |
An identifier for linking with the tilt/strain instrument table. This table gives conversion information for processing raw data. |
mediumint |
|
dd_str_ti |
measurement time |
Time of measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_str_comp1 |
component 1 |
Strainmeter data for component 1. positive = contraction; negative = dilation |
xxx.xxxx |
microstrain |
dd_str_comp2 |
component 2 |
Strainmeter data for component 2. positive = contraction; negative = dilation |
xxx.xxxx |
microstrain |
dd_str_comp3 |
component 3 |
Strainmeter data for component 3. positive = contraction; negative = dilation |
xxx.xxxx |
microstrain |
dd_str_comp4 |
component 4 |
Strainmeter data for component 4. positive = contraction; negative = dilation |
xxx.xxxx |
microstrain |
dd_str_err1 |
error 1 |
The error associated with the strainmeter measurement using component 1. |
x.xxxx |
microstrain |
dd_str_err2 |
error 2 |
The error associated with the strainmeter measurement using component 2. |
x.xxxx |
microstrain |
dd_str_err3 |
error 3 |
The error associated with the strainmeter measurement using component 3. |
x.xxxx |
microstrain |
dd_str_err4 |
error 4 |
The error associated with the strainmeter measurement using component 4. |
x.xxxx |
microstrain |
dd_str_vdstr |
Volumetric Strain change |
The volumetric strain change including the sense. positive = contraction; negative = dilation |
sxxxx.xxx |
microstrain |
dd_str_vdstr_err |
volumetric strain change error |
The error associated with the volumetric strain change |
x.xxxx |
microstrain |
dd_str_sstr_ax1 |
Shear strain, axis 1 |
Shear strain, axis 1 (gamma 1). |
sxxxx.xxx |
microstrain |
dd_str_azi_ax1 |
Azimuth, axis 1 |
Azimuth, axis 1 (gamma 1) - Measuring with respect to North with clockwise rotation as positive. |
xxx |
deg 0-360 |
dd_str_sstr_ax2 |
Shear strain, axis 2 |
Shear strain, axis 2 (gamma 2). |
sxxxx.xxx |
microstrain |
dd_str_azi_ax2 |
Azimuth, axis 2 |
Azimuth, axis 2 (gamma 2) |
xxx |
deg 0-360 |
dd_str_sstr_ax3 |
Shear strain, axis 3 |
Shear strain, axis 3 (gamma 3), if you have a 3D strainmeter. |
sxxxx.xxx |
microstrain |
dd_str_azi_ax3 |
Azimuth, axis 3 |
Azimuth, axis 3 (gamma 3) |
xxx |
deg 0-360 |
dd_str_stderr1 |
Standard error 1 |
The uncertainty in the strain for axis 1. |
xxx.xxx |
microstrain |
dd_str_stderr2 |
Standard error 2 |
The uncertainty in the strain for axis 2. |
xxx.xxx |
microstrain |
dd_str_stderr3 |
Standard error 3 |
The uncertainty in the strain for axis 3. |
xxx.xxx |
microstrain |
dd_str_max_prin |
Max principal strain |
Maximum principal strain |
xxx.xxx |
microstrain |
dd_str_maxp_stderr |
Standard error |
The uncertainty in the maximum principle strain. |
xxx.xxx |
microstrain |
dd_str_min_prin |
Min principal strain |
Minimum principal strain |
xxx.xxx |
microstrain |
dd_str_minp_stderr |
Standard error |
The uncertainty in the minimum principle strain. |
xxx.xxx |
microstrain |
dd_str_max_prin_dir |
Max principal strain direction |
Direction of maximum principal strain |
xxx |
deg 0-360 |
dd_str_maxpd_stderr |
Standard error |
The uncertainty in the maximum principal strain direction. |
xx |
microstrain |
dd_str_min_prin |
Min principal strain direction |
Direction of minimum principal strain |
xxx |
deg 0-360 |
dd_str_minpd_stderr |
Standard error |
The uncertainty in the min principal strain direction. |
xx |
microstrain |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_str_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 |
|
|
|
|
|
|
EDM |
|
|
|
|
dd_edm_id |
EDM data ID |
Identifier for linking to other tables |
autonumber |
|
ds_def_id1 |
instrument station id |
An identifier for linking with the station table for the instrument station. |
mediumint |
|
ds_def_id2 |
reflector station id |
An identifier for linking with information about the reflector station. |
mediumint |
|
dd_edm_time |
datetime |
datetime of measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_edm_linl |
Line length |
Mark-to-mark line length |
xxxxx.xxx |
m |
dd_edm_cerr |
Constant error |
The constant error, an indication of the instrument and reflector error |
x.xxx |
m |
dd_edm_serr |
Scale error |
Error relating to line length, T, P |
xxxx |
ppm |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_edm_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 |
|
|
|
|
|
|
Angle Data |
|
|
|
|
dd_ang_id |
Angle data ID |
Identifier for linking to other tables |
autonumber |
|
ds_def_id1 |
instrument station id |
An identifier for linking with the station table for the instrument station. |
mediumint |
|
ds_def_id2 |
target station id |
An identifier for linking with information about the target station. |
mediumint |
|
dd_ang_time |
datetime |
datetime of measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_ang_hang |
horizontal angle |
horizontal angle for old style geodetic information |
xxx.xx |
0-360 |
dd_ang_vang |
vertical angle |
vertical angle for old style geodetic information |
xxx.xx |
|
dd_ang_hangerr |
horizontal error on angle |
horizontal error on the angle |
x.xx |
|
dd_ang_vangerr |
vertical error on angle |
vertical error on the angle |
x.xx |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_ang_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 |
|
|
|
|
|
|
GPS Position data |
|
|
|
|
dd_gps_id |
GPS data ID |
An identifier for linking with other tables |
autonumber |
|
ds_def_id |
GPS station id |
An identifier for linking with the station table |
mediumint |
|
dd_gps_time |
Time of measurement |
The time of the measurement in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_gps_lat |
Latitude |
The measured latitude |
sxx.xxxxxxxxx |
deg lat |
dd_gps_lon |
Longitude |
The measured longitude |
sxxx.xxxxxxxxx |
deg long |
dd_gps_elev |
Elevation |
The measured elevation |
sxxxx.xxx |
m |
dd_gps_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
dd_gps_ref1 |
Reference station 1 |
Reference (fixed) station 1 |
varchar(30) |
|
dd_gps_ref2 |
Reference station 2 |
Reference (fixed) station 2 |
varchar(30) |
|
dd_gps_nserr |
Error (north-south) |
Error (north-south) |
x.xxxxxxxxx |
deg |
dd_gps_ewerr |
Error (east-west) |
Error (east-west |
x.xxxxxxxxx |
deg |
dd_gps_verr |
Error (vertical) |
Error (vertical) |
x.xxx |
m |
dd_gps_software |
Position-determining software |
Software used to determine positions |
varchar(30) |
|
dd_gps_orbits |
Orbits used |
Which/whose orbits used? |
varchar(30) |
|
dd_gps_continuous |
Continuous flag |
Flag indicating if the data is continuous. |
|
|
dd_gps_duration |
duration of the solution |
Duration of the solution (daily, hourly, 10m, 30s, etc.) |
|
|
dd_gps_quality |
Quality marker |
An indicator of the quality for this measurement (use E for excellent, G for good, and B for bad). |
|
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_gps_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 |
|
|
|
|
|
|
GPS Covariance Data |
This table holds covariance data, if necessary. |
|
|
|
dd_gpc_id |
GPS Covariance ID |
An identifier for linking with other tables. |
mediumint |
|
dd_gps_id |
GPS data ID |
An identifier for linking with the GPS position data |
mediumint |
|
dd_gpc_xx |
Covariance between x1 and x2 |
Covariance between x1 and x2 |
float |
|
dd_gpc_xy |
Covariance between x1 and y2 |
Covariance between x1 and y2 |
float |
|
dd_gpc_xz |
Covariance between x1 and z2 |
Covariance between x1 and z2 |
float |
|
dd_gpc_yx |
Covariance between y1 and x2 |
Covariance between y1 and x2 |
float |
|
dd_gpc_yy |
Covariance between y1 and y2 |
Covariance between y1 and y2 |
float |
|
dd_gpc_yz |
Covariance between y1 and z2 |
Covariance between y1 and z2 |
float |
|
dd_gpc_zx |
Covariance between z1 and x2 |
Covariance between z1 and x2 |
float |
|
dd_gpc_zy |
Covariance between z1 and y2 |
Covariance between z1 and y2 |
float |
|
dd_gpc_zz |
Covariance between z1 and z2 |
Covariance between z1 and z2 |
float |
|
dd_gpc_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 |
|
|
|
|
|
|
GPS vectors (if positions are not available) |
|
|
|
|
dd_gpv_id |
GPS data ID |
Identifier for linking to other tables |
autonumber |
|
ds_def_id |
GPS BM ID |
An identifier for linking with the station table. |
mediumint |
|
dd_gpv_stime |
Start datetime |
Start time of measuring interval in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_gpv_ftime |
Stop datetime |
End time of measuring interval in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_gpv_dmag |
Displacement magnitude |
Magnitude of displacement. |
xxxxx |
mm |
dd_gpv_daz |
Displacement azimuth |
Displacement azimuth. |
xxx.x |
deg 0-360 |
dd_gpv_vincl |
Vector inclination |
Inclination of displacement vector |
xx.x |
deg 0-90 |
dd_gpv_N |
North displacement |
Displacement to the N |
xxxxx |
mm |
dd_gpv_E |
East displacement |
Displacement to the E |
xxxxx |
mm |
dd_gpv_vert |
Vertical displacement |
Vertical displacement |
xxxxx |
mm |
dd_gpv_derr |
Magnitude uncertainty |
Uncertainty in displacement magnitude |
xxx |
mm |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_gpv_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 |
|
|
|
|
|
|
|
|
|
|
|
Leveling data |
|
|
|
|
dd_lev_id |
Leveling ID |
An identifier for linking with other tables |
autonumber |
|
ds_def_id_ref |
Reference BM ID |
Reference benchmark - need to link to the flagged reference benchmark in the station table |
mediumint |
|
dd_lev_ord |
Order |
The order of the survey |
mediumint |
1,2,3 |
dd_lev_class |
Class |
The class of the survey |
Roman numeral |
I, II |
dd_lev_time |
Survey date |
Date of survey in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ds_def_id1 |
BM( n) ID |
ID code of benchmark (n) |
mediumint |
|
ds_def_id2 |
BM (n+1) ID |
ID code of benchmark (n+1) |
mediumint |
|
dd_lev_delev |
Elevation change |
Elevation change from (n) to (n+1) |
xxx.x |
mm |
dd_lev_herr |
Estimated error in delta h |
Estimated error from BM (n) to (n+1) |
xx.x |
mm |
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_lev_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 |
|
|
|
|
|
|
INSAR (radar interferometry) |
|
|
|
|
dd_sar_id |
INSAR ID |
An identifier for linking with other tables |
autonumber |
|
dd_sar_slat |
Starting latitude |
The latitude in the starting corner |
sxx.xxxxxxx |
deg lat |
dd_sar_slon |
Starting longitude |
The longitude in the starting corner |
sxxx.xxxxxxx |
deg long |
dd_sar_datum |
Datum |
The datum used for the latitude and longitude |
text |
|
dd_sar_spos |
Starting position |
The starting position (bottom left corner, top left corner) |
text |
|
dd_sar_rord |
Row order |
The order of the rows (left to right) |
text |
|
dd_sar_nrows |
Number of rows |
The number of rows in the image |
text |
|
dd_sar_ncols |
Number of columns |
The number of columns in the image |
text |
|
dd_sar_units |
Units |
The units used in the image (ex. mm) |
text |
|
dd_sar_ndata |
Null data value |
The number used for fields without data |
text |
|
dd_sar_loc |
Location |
The location of the image (ex. This is Yellowstone) |
text |
|
dd_sar_desc |
Description of image |
A description of the image (ex. Norris uplift anomaly) |
text |
|
dd_sar_dem |
DEM |
Which DEM is used (ex. 30m NED or SRTM)? |
text |
|
dd_sar_dord |
Data order |
The order in which the bytes are stored and which bytes are most significant in multi-byte data types (ex. big endian or little endian). |
text |
|
dd_sar_img1_time |
Date, image 1 |
Date, image 1 in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
dd_sar_img2_time |
Date, image 2 |
Date, image 2 in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
cs_id |
Source satellite id |
A link to information about the source satellite. |
text |
|
dd_sar_pixsiz |
Pixel size |
The pixel size |
xxxxx |
m |
dd_sar_lookang |
Look angle |
The look angle |
xx |
deg |
dd_sar_limb |
Limb |
The limb, ascending or descending (use Asc or Des). |
text |
|
dd_sar_jpg |
JPG of interferogram |
JPG of interferogram |
jpg |
|
dd_sar_geotiff |
Geotiff of Interferogram |
Geotiff of the interferogram (24 bit color and includes encoded coordinates of beginning and end of image). |
digital file |
|
dd_sar_prometh |
Processing method |
The processing method |
text |
|
dd_sar_softwr |
software |
The sofware used. |
text |
|
dd_sar_dem_qual |
DEM quality |
DEM quality, use good (G), fair (F), poor (P), or none (N) where good=1m pixel; fair=10m; poor=100m. |
text |
|
cc_id2 |
Collector ID |
An identifier for linking to data collector information. |
mediumint |
|
dd_sar_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 |
|
|
|
|
|
|
INSAR data |
|
|
|
|
dd_srd_ID |
INSAR data ID |
An identifier for linking with other tables |
autonumber |
|
dd_sar_id |
INSAR ID |
An identifier for linking with the INSAR table for the full image. |
autonumber |
|
dd_srd_dchange |
range of change |
The range of change for each pixel |
xx.x |
mm |
dd_srd_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 |
|
|
|
|
|
|
Tilt and Strainmeter Station Table |
|
|
|
|
ds_tlt_id |
tilt station ID |
An identifier for linking with other tables |
autonumber |
|
ds_tlt_name |
Station name |
The name of the station |
text |
|
ds_tlt_code |
Station Code |
Tilt station code, given by observatory |
text |
|
cn_id |
network id |
An identifier for linking with other tables |
autonumber |
|
gi_id |
Tilt/Strain Instrument ID |
An identifier for linking with the tilt/strain instrument table. |
mediumint |
|
ds_tlt_utc |
difference from UTC |
Time zone relative to UTC - "s" = sign; read as GMT +- xx h. |
sxx.x |
|
ds_tlt_type |
Type |
Type of instrument (tiltmeter, strainmeter) |
text |
|
ds_tlt_lat |
Latitude |
The latitude of the station in decimal degrees. |
sxx.xxxxxxx |
deg lat |
ds_tlt_lon |
Longitude |
The longitude of the station in decimal degrees. |
sxxx.xxxxxxx |
deg long |
ds_tlt_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
ds_tlt_elev |
Elevation |
The elevation of the station. |
sxxxx |
m |
ds_tlt_est |
start date |
The date the station was set up and activated in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ds_tlt_dest |
stop date |
The date the station was permanently decommissioned in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). See observatory for station operation history. |
datetime |
|
ds_tlt_desc |
Station description |
A description of the station or any comments |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ds_tlt_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 |
|
|
|
|
|
|
Tilt/Strain Instrument Table |
|
|
|
|
gi_id |
Tilt/Strain Instrument ID |
An identifier for linking with other tables |
mediumint |
|
gi_name |
name |
The name of the instrument |
text |
|
gi_type |
type |
The type of instrument |
text |
|
gi_man |
manufacturer |
The manufacturer of the instrument |
text |
|
gi_mod |
model |
The model of the instrument. |
text |
|
gi_units |
measured units |
The units the instrument measures. |
text |
|
gi_lcn |
least count noise |
The analog to digitizer resolution. |
xxx |
|
gi_dir1 |
Direction 1 |
Azimuth of direction 1 (or x for tiltmeters) using geographic north. |
xxx |
deg 0-360 |
gi_dir2 |
Direction 2 |
Azimuth of direction 2 (or y for tiltmeters) using geographic north. |
xxx |
deg 0-360 |
gi_dir3 |
Direction 3 |
Azimuth of direction 3 using geographic north. |
xxx |
deg 0-360 |
gi_dir4 |
Direction 4 |
Azimuth of direction 4 using geographic north. |
xxx |
deg 0-360 |
gi_econv1 |
Electronic conversion 1 |
Electronic conversion (scale factor) for component 1 - for tilt mV to microradian conversion, for strain mV to microstrain. |
xxx.xx |
microradian/ mV or mV/Microstrain |
gi_econv2 |
Electronic conversion 2 |
Electronic conversion (scale factor) for component 2 - for tilt mV to microradian conversion, for strain mV to microstrain. |
xxx.xx |
microradian/ mV or mV/Microstrain |
gi_econv3 |
Electronic conversion 3 |
Electronic conversion (scale factor) for component 3 - for tilt mV to microradian conversion, for strain mV to microstrain. |
xxx.xx |
microradian/ mV or mV/Microstrain |
gi_econv4 |
Electronic conversion 4 |
Electronic conversion (scale factor) for component 4 - for tilt mV to microradian conversion, for strain mV to microstrain. |
xxx.xx |
microradian/ mV or mV/Microstrain |
gi_stime |
Valid from time (start time) |
The time the instrument information in this table became valid in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
gi_etime |
Valid to time (end time) |
The time the instrument information in this table changed in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). This field will be null if the original information is still valid. |
datetime |
|
gi_desc |
description |
Description of instrument |
varchar(255) |
|
gi_comm |
comments |
Comments on the instrument |
varchar(255) |
|
cc_id |
Contact ID |
An identifier for linking with the person or group of people who use this instrument. |
mediumint |
|
gi_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 |
|
|
|
|
|
|
Station Table (for all other geodetic) |
|
|
|
|
ds_def_id |
station table ID |
An identifier for linking with other tables |
autonumber |
|
ds_def_nam |
station name |
The name of the benchmark or station |
text |
|
ds_def_code |
Station Code |
Station code, given by observatory, if applicable including leveling benchmark numbers |
text |
|
cn_id |
network id |
An identifier for linking with other tables |
mediumint |
|
ci_id |
Instrument ID |
An identifier for linking to instrument information. |
mediumint |
|
ds_def_type |
type of benchmark |
What the benchmark is primarily used for (GPS, leveling, EDM, etc.) |
text |
|
ds_def_nlat |
nominal latitude |
The latitude of the station |
sxx.xxxxxxx |
deg lat |
ds_def_nlon |
nominal longitude |
The longitude of the station |
sxxx.xxxxxxx |
deg long |
ds_def_nelev |
nominal elevation |
The nominal elevation of the station |
sxxxx |
m |
ds_def_datum |
Datum |
The datum used for the longitude and latitude. |
varchar(30) |
|
ds_def_herr_loc |
Horiz. Precision location |
Horizontal Precision of nominal location for GPS |
|
|
ds_def_est |
start date |
The date the station was set up and activated in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). |
datetime |
|
ds_def_dest |
stop date |
The date the station was permanently decommissioned in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). See observatory for station operation history. |
datetime |
|
ds_def_utc |
difference from UTC |
Time zone relative to UTC - "s" = sign; read as GMT +- xx h. |
sxx.x |
|
ds_def_refd |
reference datum |
The station id of the reference datum. |
|
|
ds_def_desc |
Station description |
A description of the station or any comments |
text |
|
cc_id |
Contact ID |
An identifier for linking to contact information. |
mediumint |
|
ds_def_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 |
|
|
|
|
|
|