Search

Latest News

Volcanic Activity Report

Random Picture

Geodetic

  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  
         

Last Updated on 1/13/2004
By chris newhall