Search

Latest News

Volcanic Activity Report

Random Picture

Hydrologic

  Hydrologic parameters      
Attribute Attribute Name Description Format Units
Hydrologic data        
hd_id hydrologic data ID An identifier for linking with other tables autonumber  
hs_id Station id An identifier for linking with the water station table mediumint  
hi_id Instrument A link to the instrument mediumint  
hd_time Measurement time The measurement time (date and time) datetime  
hd_temp Temperature The temperature of the water xxx.xx deg C
hd_welev Water elevation Elevation of water level, if available sxxxx.xxx m above sea level
hd_depth Water depth Water depth below ground surface, if this is only measurement xxxx.xxx m below ground
hd_dlev Change in water level Enter data here if only a change is reported. Otherwise, calculate this field. xxx.xxx m
hd_bp Barometric Pressure Atmospheric pressure at the time of measurement xxxx.x millibars
hd_sdisc Spring discharge rate Measured spring discharge rate xxxx.xx liters/sec
hd_dprec Daily precipitation Precipitation, preceding day xxx.x mm
hd_mprec Monthly precipitation Precipitation, preceding month xxxx.x mm
hd_tprec Type of precipitation The precipitation type (r-rain, s-snow) text r,s
hd_ph pH pH of water xx.x pH units
hd_cond conductivity measured conductivity xxx.x micromhos/cm
hd_so4 SO4= content The measured SO4= content xxxx ppm
hd_so3 SO3- content (reduced S) The measured SO3- content xxxx ppm
hd_cl Cl- content The measured Cl- content xxxxx ppm
hd_f F- content The measured F- content xxxx ppm
hd_hco3 HCO3- content The measured HCO3- content xxxx ppm
hd_mg Mg The measured Mg content xxxx ppm
hd_fe Fe The measured Fe content xxxx ppm
hd_ca Ca The measured Ca content xxxx ppm
hd_na Na The measured Na content xxxxx ppm
hd_k K The measured K content xxxx ppm
hd_3he4he 3He/4He The measured 3He/4He ratio xx.x (ratio)
hd_d13c delta 13C The measured delta 13C sxx.xx per mil
hd_d34s delta 34S The measured delta 34S sxx.xx per mil
hd_dd delta D The measured delta D sxxx.xx per mil
hd_d18o delta 18O The measured delta 18O sxx.xx per mil
hd_comm Comments Any comments about the measurement. text  
cc_id2 Collector ID An identifier for linking to data collector information. mediumint  
hd_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  
         
Hydrologic Station        
hs_id hydrologic station ID An identifier for linking with other tables autonumber  
cn_id network id An identifier for linking with other tables autonumber  
hs_name Well name or code The name of the station. text  
hs_type Type of water body The type of water body (well, lake, spring, etc.) text  
hs_lat latitude The latitude of the station sxx.xxxxxxx deg lat
hs_lon longitude The longitude of the station sxxx.xxxxxxx deg long
hs_elev elevation The elevation of the land surface sxxxx m
hs_datum Datum The datum used for the longitude and latitude. varchar(30)  
hs_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  
hs_tscr Top of screen Top of interval open to inflow xxx.xx m below surface
hs_bscr Bottom of screen Bottom of interval open to inflow xxx.xx m below surface
hs_tdepth Total depth of well Total depth of well xxxx.xx m below surface
hs_est start date The date the station was set up in UTC stored as datetime (YYYY-MM-DD hh:mm:ss). datetime  
hs_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  
hs_desc Station description A description of the station, and notes if any pumping, ocean tide nearby text  
cc_id Contact ID An identifier for linking to contact information. mediumint  
hs_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  
         
Hydrologic instrument table        
hi_id hydrologic instrument ID An identifier for linking with other tables autonumber  
hi_name name The name of the instrument text  
hi_type type The type of instrument (float, pressure transducer, bubbler, raingage, barometer, flow meter, pH or conductivity meter) text  
hs_meas Absolute (A) or Vented (V) Whether pressure transducer measurement is absolute (non-vented) or vented (gauge). text  
hi_pres Precision The measurement precision    
hi_est installation date The date the instrument was set up and activated. datetime  
hi_dest stop date The date the instrument was permanently decommissioned. datetime  
hi_desc instrument description Description of or comments on the instrument text  
cc_id Contact ID An identifier for linking to contact information. mediumint  
hi_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/12/2004
By chris newhall