|
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 |
|
|
|
|
|
|