From SDE view on SJRWMD Oracle database, Active Groundwater Monitoring Network - Discharge Event Type, current on 03/30/2015

Feature Class

Description

Spatial

Attributes

 

Keywords

Theme: geoscientificInformation, Groundwater, Hydrogeology, Groundwater, Model

Place: Florida, St. Johns River Water Management District, Counties, Alachua County, Baker County, Bradford County, Brevard County, Clay County, Duval County, Flagler County, Indian River County, Lake County, Marion County, Nassau County, Okeechobee County, Orange County, Osceola County, Putnam County, Seminole County, St. Johns County, Volusia County, Citrus, Columbia, Glades, Highlands, Levy, Martin, Polk, St. Lucie, Sumter, Union

 

Description

Abstract

NOTE: EXPORT FROM ORIGINAL SDE FEATURE CLASS, 03/30/2015, BY JSTOKES@SJRWMD.COM
 
Stations from Station Header which have an Active/Physical status in the SDMS data model (hydro_stn_evnt table), and which have an event type of "Discharge".
 
Groundwater is the source for over 97% of the public and domestic drinking water supplies in SJRWMD. In addition, over 73% of industrial/commercial and 66% of agricultural water needs are supplied by groundwater sources. The 2000 District Water Supply Plan indicates that the population within SJRWMD is projected to increase by about 50%, to nearly 5.2 million, by the year 2020. Total water demand is projected to increase about 35% by 2020, to nearly 1.85 billion gallons per day (Vergara 2000).
 
As the demands on water resources increase, it is important to have an ongoing program to provide the data and information needed to assess groundwater level and quality conditions and understand what information can be obtained from groundwater monitoring. Existing and anticipated sources of groundwater may not be adequate to supply water for all existing and future needs through 2020 without causing unacceptable impacts to water resources and related natural systems. Potential impacts include declines in groundwater levels and quality, reduction in spring discharge, increases in seawater intrusion, harm to native vegetation and wetlands, and interference with existing legal users.
 
Projections of future water resource conditions were developed with modeling techniques that used the best information available. The accuracy of the model projections can be improved in areas where there is currently a lack of data. As a result, improved groundwater monitoring well networks were devised, addressing both regional and subregional data needed for long-term water supply planning and water resource protection. Data obtained from the well networks increase our understanding of the hydrogeologic, climatic, and human factors that affect water resources, and this information is used to assess the effectiveness of water management programs.
 
Groundwater monitoring is administered in the Bureau of Engineering and Hydro Science through the Water Resources Assessment section, a Field Services (well construction) section, and a Geophysical Logging section. The Bureau of Water Resource Information is responsible for data collection from the network wells.
 
The objectives of the Water Resources Assessment section are to:
Design, construct, and maintain water level and water quality monitoring well networks
Evaluate and refine the networks to optimize the spatial and temporal data collection
Evaluate and analyze the data collected from the networks using statistical, geostatistical, graphical, and mapping methods to produce useful information
Assess the effectiveness of the information derived from the networks to meet current and future water management needs
Distribute and publish the network data, information, and interpretations as required by users for water supply planning, minimum flows and levels, consumptive use permitting, and other District programs.


Purpose

Original request from Groundwater staff (Jill Stokes, 2008) - to create one SDE feature view which would contain point and attribute data from the following three PROD data models:
 
          1.  Station Header
          2.  WCL (Well Construction & Logging)
          3.  SDMS (Sindex Data Management System)
 
The attributes included from each of the above models would be those shown in the respective web applications, i.e. Station Header, Well Construction & Logging and SDMS.


Supplementary Information

Internal SJRWMD NOTE:
 
Process involves setting up views and materialized views of the three data models on PROD, followed by creating attribute and a final SDE feature view on the SDE database (GISLIB account) point in to these PROD views and the SDE feature class GISLIB.STN_ET_GEOM.
 
Any specific questions about the data in this view should be directed to the person who originally created the station in Station Header, listed with the "Created By:" field when doing a station search in the Station Header web app:
 
          http://dasprod/station/
 
Steps used to develop this SDE feature view - see Process Steps section.
 
..


_________________

 

Status of the data

Complete
Data update frequency: As needed

 

Time period for which the data is relevant

Date and time: 09/2010

Description:

publication date


 

Publication Information

Who created the data: St. Johns River Water Management District

Date and time: 09/2010

Publisher and place: St. Johns River Water Management District, Palatka, FL

_________________

 

Data storage and access information

File name: GISLIB_STN_ET_GW_Q
Type of data: vector digital data

Location of the data:

·  \\palfile\sjrx\GWP\Users\jstokes\MetadataTemplate\web\gw_monitoring_network_q\SJRWMDdata20100914q.mdb

Data processing environment: Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.1.1850

Constraints on accessing and using the data

Access constraints: None, The St. Johns River Water Management District, Department of Resource Management, Groundwater Programs Division, asks to be credited in derived products.

Use constraints:

The St. Johns River Water Management District prepares and uses information for its own purposes and this information may not be suitable for other purposes.  This information is provided "as is". Further documentation of this data can be obtained by contacting: St. Johns River Water Management District, Department of Resource Management, Groundwater Programs Division.  See Metadata Reference Section of this document for additional contact information.


 

Details about this document

Contents last updated: 20100920 at time 17582900

Who completed this document

Jill A. Stokes
St. Johns River Water Management District
mailing address:

PO Box 1429

Palatka, Florida 32178-1429

USA

 

physical address:

4049 Reid St

Palatka, Florida 32177

USA


386.329.4336 (voice)
gwpsupport@sjrwmd.com

Hours of service: 0800-1700 EST

Contact Instructions:

If Contacts not available; Contact: St Johns River Water Management District, Dept of Resource Management, Groundwater Programs Division (GWP) 386.329.4500 - main District phone

 

Standards used to create this document

Standard name: FGDC Content Standards for Digital Geospatial Metadata
Standard version: FGDC-STD-001-1998
Time convention used in this document: local time
Metadata profiles defining additonal information

·  ESRI Metadata Profile: http://www.esri.com/metadata/esriprof80.html

·  ESRI Metadata Profile: http://www.esri.com/metadata/esriprof80.html

 

 

Horizontal coordinate system

Projected coordinate system name: NAD_1983_HARN_UTM_Zone_17N

Geographic coordinate system name: GCS_North_American_1983_HARN

Details

Map Projection Name: Transverse Mercator

Scale Factor at Central Meridian: 0.999600
Longitude of Central Meridian: -81.000000
Latitude of Projection Origin: 0.000000
False Easting: 500000.000000
False Northing: 0.000000

 

Planar Coordinate Information

Planar Distance Units: meters

Coordinate Encoding Method: coordinate pair

Coordinate Representation

Abscissa Resolution: 0.000145

Ordinate Resolution: 0.000145

 

Geodetic Model

Horizontal Datum Name: D_North_American_1983_HARN

Ellipsoid Name: Geodetic Reference System 80

Semi-major Axis: 6378137.000000

Denominator of Flattening Ratio: 298.257222

 

Altitude System Definition

Resolution: 1.000000

Encoding Method: Explicit elevation coordinate included with horizontal coordinates

_________________

 

Bounding coordinates

Horizontal

In decimal degrees

West: -82.761111

East: -81.246785

North: 30.341341

South: 28.557273

In projected or local coordinates

Left: 330696.062922

Right: 475863.876632

Top: 3356636.351679

Bottom: 3160159.558620

_________________

 

Lineage

FGDC lineage

Process step 1

Process description: First step is to create views and materialized views on PROD for each of the three data models (Station Header, WCL and SDMS). Background notes on elevation attributes from STN_VERT_HIST table, as described by Aldo Herrera and Brahma Pulakam - developers most familiar with the web applications for these data models. Most (all?) of the following filtering done on the STN_VERT_HIST table (other than the stn_id join to the stn_et table) is due to the current situation of additional/duplicate data in this table resulting from the loading of SINDEX data into the SDMS data model on PROD. This according to Aldo & Brahma - and will eventually be cleaned up, but in the meantime conditions such as where elevation values < 500 and <>-1 are put in to filter this data out. --> Notes from Aldo (how the current web applications retrieve this same data): Elevations from STN_VERT_HIST MP (Measuring Point Elevation): * CUR_USE_CD = 1 * MP_DTM_TP_CD = 3243 * DATA_SRCE = 'SINDEX' * Precendence of REF_ID: * REF_ID = 'FLOWING' * REF_ID = 'NOTFLOWING' * Any other REF_ID * Valid MEAS_PNT_ELEV_VAL: * MEAS_PNT_ELEV_VAL < 500 * MEAS_PNT_ELEV_VAL <> -1 LSE (Land Surface Elevation): * CUR_USE_CD = 1 * USE_STRT_DT = MAX(USE_STRT_DT) for that STN_ID with an active valid LND_SRFC_ELEV_VAL: * LND_SRFC_ELEV_VAL < 500 * LND_SRFC_ELEV_VAL <> -1

Process step 2

Process description: Process step to create Station Header attributes: -- Station Header --- create or replace view v_gw_stn_wl as select distinct cast(rownum as number(38)) objectid ,s.stn_id ,s.stn_nm ,s.stn_tp_cd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=s.stn_tp_cd) stn_type ,s.stn_ctgry_cd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=s.stn_ctgry_cd) stn_ctgry ,wt.srce_offcl_nm ,s.pnt_loc_dsc ,(select cty.cnty_nm from cnty_et cty where cty.cnty_id = s.cnty_id) county ,s.twnshp_id ,s.rng_id ,s.sect_id ,s.hydro_unit_cd ,uhuc.hydro_unit_nm ,s.quad_bsn_id ,q.quad_bsn_nm ,mb.mjr_bsn_nm ,pu.plan_unit_id ,pu.plan_unit_nm ,s.topo_quad_id ,t.topo_quad_nm ,(select pdiv.physgrph_div_nm from physgrph_div_et pdiv where s.physgrph_div_id=pdiv.physgrph_div_id) physgrph_div_nm ,(select div.ORG_UNIT_NM from sjr.sjr_div_et div where div.div_id=s.div_id) div_nm ,(select v.lat_no_dd from v_stn_et_geom v where v.stn_id=s.stn_id) lat_no_dd ,(select v.long_no_dd from v_stn_et_geom v where v.STN_ID=s.stn_id) long_no_dd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=s.mthd_dtrmn_cd) horz_det_mthd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=s.ctrl_dtm_cd) horz_ctl_dtm ,(select max(slh.use_strt_dt) from stn_loc_hist slh where slh.stn_id=s.stn_id) horz_use_strt_dt ,(select svh_lse.lnd_srfc_elev_val from stn_vert_hist svh_lse where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lnd_srfc_elev_val ,(select svh_lse.use_strt_dt from stn_vert_hist svh_lse where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lse_use_strt_dt ,(select svh_lse.mthd_dtrmn_cd from stn_vert_hist svh_lse where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lse_vert_det_mthd ,(select def.tp_dsc from sjr_abbr_def_et def INNER JOIN stn_vert_hist svh_lse ON (def.tp_id=svh_lse.mthd_dtrmn_cd) where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lse_vert_det_mthd_desc ,(select svh_lse.ctrl_dtm_cd from stn_vert_hist svh_lse where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lse_vert_ctl_dtm ,(select def.tp_dsc from sjr_abbr_def_et def INNER JOIN stn_vert_hist svh_lse ON (def.tp_id=svh_lse.ctrl_dtm_cd) where s.stn_id=svh_lse.stn_id and svh_lse.cur_use_cd=1 and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_lse.stn_id and svh_x.cur_use_cd = 1 and svh_x.lnd_srfc_elev_val < 500 and svh_x.lnd_srfc_elev_val != -1) ) lse_vert_ctl_dtm_desc ,(select svh_mp.meas_pnt_elev_val from stn_vert_hist svh_mp where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_meas_pnt_elev_val ,(select svh_mp.use_strt_dt from stn_vert_hist svh_mp where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_use_strt_dt ,(select svh_mp.mthd_dtrmn_cd from stn_vert_hist svh_mp where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_vert_det_mthd ,(select def.tp_dsc from sjr_abbr_def_et def INNER JOIN stn_vert_hist svh_mp ON (def.tp_id=svh_mp.mthd_dtrmn_cd) where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_vert_det_mthd_desc ,(select svh_mp.ctrl_dtm_cd from stn_vert_hist svh_mp where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_vert_ctrl_dtm ,(select def.tp_dsc from sjr_abbr_def_et def INNER JOIN stn_vert_hist svh_mp ON (def.tp_id=svh_mp.ctrl_dtm_cd) where s.stn_id=svh_mp.stn_id and svh_mp.cur_use_cd=1 and svh_mp.mp_dtm_tp_cd=3253 and svh_mp.data_srce='SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x where svh_x.stn_id= svh_mp.stn_id and svh_x.cur_use_cd = 1 and svh_x.mp_dtm_tp_cd = 3253 and svh_x.data_srce = 'SINDEX' and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1, 'NOTFLOWING',2,3)) from stn_vert_hist svh_x where svh_x.stn_id=svh_mp.stn_id and svh_x.cur_use_cd=1 and svh_x.mp_dtm_tp_cd=3253 and svh_X.data_srce='SINDEX' and svh_x.meas_pnt_elev_val < 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val < 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_vert_ctrl_dtm_desc from stn_et s LEFT OUTER JOIN wtr_srce_et wt ON (s.srce_id = wt.srce_id) LEFT OUTER JOIN usgs_hydro_unit_cd uhuc ON (s.hydro_unit_cd = uhuc.hydro_unit_cd) LEFT OUTER JOIN quad_bsn_et q ON (s.quad_bsn_id = q.quad_bsn_id) LEFT OUTER JOIN mjr_bsn_et mb ON (s.mjr_bsn_id = mb.mjr_bsn_id) LEFT OUTER JOIN plan_unit_et pu ON (q.plan_unit_id = pu.plan_unit_id) LEFT OUTER JOIN topo_quad_et t ON (s.topo_quad_id = t.topo_quad_id) where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- > "Active/Physical Station Status hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt where sevt.evnt_tp_nm='Water Level (WL)' -- > "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) ) ) order by s.stn_id / drop materialized view mv_gw_stn_wl / create materialized view mv_gw_stn_wl refresh complete start with sysdate next sysdate + 1 as select cast(objectid as number(38)) objectid ,v.stn_id ,v.stn_nm ,v.stn_tp_cd ,v.stn_type ,v.stn_ctgry_cd ,v.stn_ctgry ,v.srce_offcl_nm ,v.pnt_loc_dsc ,v.county ,v.twnshp_id ,v.rng_id ,v.sect_id ,v.hydro_unit_cd ,v.hydro_unit_nm -- ,v.quad_bsn_id ,v.quad_bsn_nm ,v.mjr_bsn_nm -- ,v.plan_unit_id ,v.plan_unit_nm -- ,v.topo_quad_id ,v.topo_quad_nm ,v.physgrph_div_nm ,v.div_nm ,v.lat_no_dd ,v.long_no_dd ,v.horz_det_mthd ,v.horz_ctl_dtm ,v.horz_use_strt_dt ,v.lnd_srfc_elev_val ,v.lse_use_strt_dt -- ,v.lse_vert_det_mthd ,v.lse_vert_det_mthd_desc -- ,v.lse_vert_ctl_dtm ,v.lse_vert_ctl_dtm_desc ,v.mp_meas_pnt_elev_val ,v.mp_use_strt_dt ,v.mp_vert_det_mthd ,v.mp_vert_det_mthd_desc ,v.mp_vert_ctrl_dtm ,v.mp_vert_ctrl_dtm_desc ,sysdate view_refresh_date from v_gw_stn_wl v where (v.stn_id,v.objectid) in (select v2.stn_id,min(v2.objectid) from v_gw_stn_wl v2 group by v2.stn_id) / create index idx_mv_gw_stn_wl_stnid on mv_gw_stn_wl(stn_id); create index idx_mv_gw_stn_wl_objid on mv_gw_stn_wl(objectid); grant select on mv_gw_stn_wl to public; ...

Process step 3

Process description: Process step to create WCL attributes: -- WCL Data Model --- create or replace view v_gw_wcl_wl1 as select distinct -- Note: not doing a cast of rownum yet, as need distinct set of records 1st s.stn_id ,s.stn_nm ,s.stn_ctgry_cd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=s.stn_ctgry_cd) stn_ctgry ,w.totl_well_csng_dpth_qty ,w.cur_well_dpth_qty ,w.well_drl_dpth_qty ,w.nomnl_csng_dmtr_qty ---- ,(select def.tp_dsc from sjr_abbr_def_et def where w.well_use_cd = def.tp_id) well_use ,(select def.ctlg_nm from well_constr_log_ctlg def where w.well_use_cd = def.ctlg_cd) well_use ,(select svh_nonsindex.stick_up_val from stn_vert_hist svh_nonsindex where s.stn_id=svh_nonsindex.stn_id and svh_nonsindex.cur_use_cd=1 and NVL(svh_nonsindex.data_srce,' ')!='SINDEX') stick_up_val ,l.log_evnt_id ,l.log_dt ,l.log_dpth_val ,l.prsn_data_src_id ,(select semp.sjr_emp_nm from sjr_emp_et semp where semp.sjr_emp_id = l.prsn_data_src_id) emp_nm ,s.srce_id ,wt.srce_offcl_nm ,w.well_stts_cd ,wcl.ctlg_nm well_stts ,w.cmplt_dt ,w.stts_dt -- added 6/19/2009 from stn_et s INNER JOIN well_et w ON (s.stn_id = w.stn_id) INNER JOIN well_constr_log_stn_et wc ON (w.stn_id = wc.stn_id) INNER JOIN well_constr_log_ctlg wcl ON (w.well_stts_cd = wcl.ctlg_cd) -- LEFT OUTER JOIN stn_vert_hist svh ON (s.stn_id = svh.stn_id) LEFT OUTER JOIN log_evnt_et l ON (s.stn_id=l.stn_id) LEFT OUTER JOIN wtr_srce_et wt ON (s.srce_id = wt.srce_id) where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- > "Active/Physical Station Status hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt where sevt.evnt_tp_nm='Water Level (WL)' -- > "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) ) ) order by s.stn_id / create or replace view v_gw_wcl_wl as select cast(rownum as number(38)) objectid ,stn_id ,stn_nm ,stn_ctgry_cd ,stn_ctgry ,totl_well_csng_dpth_qty ,cur_well_dpth_qty ,well_drl_dpth_qty ,nomnl_csng_dmtr_qty ,well_use ,stick_up_val ,log_evnt_id ,log_dt ,log_dpth_val ,prsn_data_src_id ,emp_nm ,srce_id ,srce_offcl_nm ,well_stts_cd ,well_stts ,cmplt_dt ,stts_dt from v_gw_wcl_wl1 / drop materialized view mv_gw_wcl_wl / create materialized view mv_gw_wcl_wl refresh complete start with sysdate next sysdate + 1 as select cast(objectid as number(38)) objectid ,stn_id ,stn_nm ,stn_ctgry_cd ,stn_ctgry ,totl_well_csng_dpth_qty ,cur_well_dpth_qty ,well_drl_dpth_qty ,nomnl_csng_dmtr_qty ,well_use ,stick_up_val ,log_evnt_id ,log_dt ,log_dpth_val ,prsn_data_src_id ,emp_nm ,srce_id ,srce_offcl_nm ,well_stts_cd ,well_stts ,cmplt_dt ,stts_dt from v_gw_wcl_wl / create index idx_mv_gw_wcl_wl_stnid on mv_gw_wcl_wl(stn_id); create index idx_mv_gw_wcl_wl_objid on mv_gw_wcl_wl(objectid); grant select on mv_gw_wcl_wl to public; ...

Process step 4

Process description: Process step to create SDMS attributes: -- SDMS Data Model --- create or replace view v_gw_sdms_wl as select cast(rownum as number(38)) objectid ,hse.stn_evnt_id ,hse.stn_id ,hse.proj_id hse_proj_id ,hse.shrt_nm ,hse.long_nm ,hse.site_id ,(select ses.site_nm from stn_evnt_site ses where ses.site_id=hse.site_id) site_nm -- added 6/9/09 ,hse.hydron_id ,hse.evnt_tp_cd ,(select sev.evnt_tp_nm from stn_evnt_tp sev where sev.evnt_tp_cd = hse.evnt_tp_cd) evnt_tp ,decode(hse.stts_cd,'1','Y','0','N','N') status ,hse.freq_cd ,(select def.tp_dsc from sjr_abbr_def_et def where def.tp_id=hse.freq_cd) freq ,hse.coll_agncy_cd ,(select sc.coll_agncy_nm from stn_evnt_coll_agncy sc where sc.coll_agncy_cd = hse.coll_agncy_cd) coll_agncy ,spr.div_id sdms_div_id ,(select RTRIM(sde.org_unit_pre_nm) || ' ' || RTRIM(sde.org_unit_nm) from sjr_div_et sde where spr.div_id=sde.div_id) sdms_div_nm -- added 6/19/2009 ,spr.sftwr_id ,(select sfe.sftwr_nm from sftwr_et sfe where sfe.sftwr_id=spr.sftwr_id) sftwr_nm -- added 6/19/2009 ,spr.proj_nm stn_project_nm ,sem.sjr_emp_nm stn_project_mgr ,(select spr0.proj_nm from stn_proj_et spr0 where hse.proj_id = spr0.proj_id) sdms_project_nm ,(select sem0.sjr_emp_nm from sjr_emp_et sem0 where hse.proj_mgr_id=sem0.sjr_emp_id) sdms_project_mgr ,hse.telem_tp_cd ,hse.observ_stts_cd ,hse.record_stts_cd ,hse.hydro_rpt_stts_cd from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id) LEFT OUTER JOIN stn_proj sp ON (hse.stn_id = sp.stn_id and hse.proj_id = sp.proj_id) LEFT OUTER JOIN stn_proj_et spr ON (sp.proj_id = spr.proj_id) LEFT OUTER JOIN sjr_emp_et sem ON (s.sjr_emp_id = sem.sjr_emp_id) where hse.stts_cd=1 and -- > "Active/Physical Station Status hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt where sevt.evnt_tp_nm='Water Level (WL)') -- > "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) order by hse.stn_id, hse.stn_evnt_id / drop materialized view mv_gw_sdms_wl / create materialized view mv_gw_sdms_wl refresh complete start with sysdate next sysdate + 1 as select cast(objectid as number(38)) objectid ,stn_evnt_id ,stn_id ,hse_proj_id ,shrt_nm ,site_id ,site_nm ,long_nm ,hydron_id ,evnt_tp_cd ,evnt_tp ,status ,freq_cd ,freq ,coll_agncy_cd ,coll_agncy ,sdms_div_id ,sdms_div_nm ,sftwr_id ,sftwr_nm ,stn_project_nm ,stn_project_mgr ,sdms_project_nm ,sdms_project_mgr ,telem_tp_cd ,observ_stts_cd ,record_stts_cd ,hydro_rpt_stts_cd from v_gw_sdms_wl / create index idx_mv_gw_sdms_wl_stnid on mv_gw_sdms_wl(stn_id); create index idx_mv_gw_sdms_wl_objid on mv_gw_sdms_wl(objectid); grant select on mv_gw_sdms_wl to public; ..

Process step 5

Process description: Process step to create final view containing all Station Header, WCL & SDMS attributes: create or replace view v_gw_wl_1 as select distinct mst.stn_id, mst.stn_nm, -- mst.stn_tp_cd, mst.stn_type, mst.stn_ctgry, mst.srce_offcl_nm, mst.lat_no_dd, mst.long_no_dd, mst.pnt_loc_dsc, mst.county, mst.twnshp_id, mst.rng_id, mst.sect_id, mst.hydro_unit_nm, mst.quad_bsn_nm, mst.mjr_bsn_nm, mst.plan_unit_nm, mst.topo_quad_nm, mst.physgrph_div_nm, mst.div_nm, mst.horz_det_mthd, mst.horz_ctl_dtm, mst.horz_use_strt_dt, mst.lnd_srfc_elev_val, mst.lse_use_strt_dt, -- mst.lse_vert_det_mthd, mst.lse_vert_det_mthd_desc, -- mst.lse_vert_ctl_dtm, mst.lse_vert_ctl_dtm_desc, mst.mp_meas_pnt_elev_val, mst.mp_use_strt_dt, -- mst.mp_vert_det_mthd, mst.mp_vert_det_mthd_desc, -- mst.mp_vert_ctrl_dtm, mst.mp_vert_ctrl_dtm_desc, mw.stick_up_val, -- adding 6/9/09 mw.totl_well_csng_dpth_qty, mw.cur_well_dpth_qty, mw.well_drl_dpth_qty, mw.nomnl_csng_dmtr_qty, mw.well_use, -- mw.well_stts_cd, mw.well_stts, mw.cmplt_dt, mw.stts_dt, msd.site_nm, msd.shrt_nm, msd.long_nm, msd.hydron_id, msd.freq, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.coll_agncy, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.stn_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.stn_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.sdms_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.sdms_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 msd.sdms_div_id, msd.sdms_div_nm, msd.sftwr_id, msd.sftwr_nm, -- mst.view_refresh_date from mv_gw_stn_wl mst LEFT OUTER JOIN mv_gw_wcl_wl mw ON (mst.stn_id = mw.stn_id) LEFT OUTER JOIN mv_gw_sdms_wl msd ON (mst.stn_id = msd.stn_id) / create or replace view v_gw_wl as select cast(rownum as number(38)) objectid, stn_id, stn_nm, stn_type, stn_ctgry, srce_offcl_nm, lat_no_dd, long_no_dd, pnt_loc_dsc, county, twnshp_id, rng_id, sect_id, hydro_unit_nm, quad_bsn_nm, mjr_bsn_nm, plan_unit_nm, topo_quad_nm, physgrph_div_nm, div_nm, horz_det_mthd, horz_ctl_dtm, horz_use_strt_dt, lnd_srfc_elev_val, lse_use_strt_dt, lse_vert_det_mthd_desc, lse_vert_ctl_dtm_desc, mp_meas_pnt_elev_val, mp_use_strt_dt, mp_vert_det_mthd_desc, mp_vert_ctrl_dtm_desc, stick_up_val, totl_well_csng_dpth_qty, cur_well_dpth_qty, well_drl_dpth_qty, nomnl_csng_dmtr_qty, well_use, well_stts, cmplt_dt, stts_dt, site_nm, shrt_nm, long_nm, hydron_id, freq, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 coll_agncy, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 stn_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 stn_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_div_id, sdms_div_nm, sftwr_id, sftwr_nm, view_refresh_date from v_gw_wl_1 / drop materialized view mv_gw_wl / create materialized view mv_gw_wl refresh complete start with sysdate next sysdate + 1 as select cast(v.objectid as number(38)) objectid, v.stn_id, v.stn_nm, v.stn_type, v.stn_ctgry, v.srce_offcl_nm, v.lat_no_dd, v.long_no_dd, v.pnt_loc_dsc, v.county, v.twnshp_id, v.rng_id, v.sect_id, v.hydro_unit_nm, v.quad_bsn_nm, v.mjr_bsn_nm, v.plan_unit_nm, v.topo_quad_nm, v.physgrph_div_nm, v.div_nm, v.horz_det_mthd, v.horz_ctl_dtm, v.horz_use_strt_dt, v.lnd_srfc_elev_val, v.lse_use_strt_dt, v.lse_vert_det_mthd_desc, v.lse_vert_ctl_dtm_desc, v.mp_meas_pnt_elev_val, v.mp_use_strt_dt, v.mp_vert_det_mthd_desc, v.mp_vert_ctrl_dtm_desc, v.stick_up_val, v.totl_well_csng_dpth_qty, v.cur_well_dpth_qty, v.well_drl_dpth_qty, v.nomnl_csng_dmtr_qty, v.well_use, v.well_stts, v.cmplt_dt, v.stts_dt, v.site_nm, v.shrt_nm, v.long_nm, v.hydron_id, v.freq, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.coll_agncy, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.stn_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.stn_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.sdms_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.sdms_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 v.sdms_div_id, v.sdms_div_nm, v.sftwr_id, v.sftwr_nm, v.view_refresh_date from v_gw_wl v where NOT EXISTS (select 'X' from v_gw_wl v2 where v.stn_id=v2.stn_id and v.coll_agncy=v2.coll_agncy and v2.stn_id=73629 and v2.coll_agncy!='SJRWMD') / create index idx_mv_gw_wl_stnid on mv_gw_wl(stn_id); create index idx_mv_gw_wl_objid on mv_gw_wl(objectid); grant select on mv_gw_wl to public; ...

Process step 6

Process description: Process step on SDE database to create final SDE feature view (GISLIB.STN_ET_GW_DISCH) from the above materialized view on PROD: -- On sde dbs in gislib account, create a point feature classes (ST_GEOMETRY) based on the above materialized views. -- (GISLIB.STN_ET_GW_WL) connect gislib@sde create or replace view v_mv_gw_wl as select cast(objectid as number(38)) objectid, stn_id, stn_nm, stn_type, stn_ctgry, srce_offcl_nm, lat_no_dd, long_no_dd, pnt_loc_dsc, county, twnshp_id, rng_id, sect_id, hydro_unit_nm, quad_bsn_nm, mjr_bsn_nm, plan_unit_nm, topo_quad_nm, physgrph_div_nm, div_nm, horz_det_mthd, horz_ctl_dtm, horz_use_strt_dt, lnd_srfc_elev_val, lse_use_strt_dt, lse_vert_det_mthd_desc, lse_vert_ctl_dtm_desc, mp_meas_pnt_elev_val, mp_use_strt_dt, mp_vert_det_mthd_desc, mp_vert_ctrl_dtm_desc, stick_up_val, totl_well_csng_dpth_qty, cur_well_dpth_qty, well_drl_dpth_qty, nomnl_csng_dmtr_qty, well_use, well_stts, cmplt_dt, stts_dt, site_nm, shrt_nm, long_nm, hydron_id, freq, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 coll_agncy, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 stn_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 stn_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_project_nm, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_project_mgr, -- moved from v_gw_sdms_wl_addl view: request by Jill Stokes 7/7/2009 sdms_div_id, sdms_div_nm, sftwr_id, sftwr_nm, view_refresh_date from gislib.mv_gw_wl@prod ; --> new view name sdetable -o create_view -T STN_ET_GW_WL -t "stn_et_geom,v_mv_gw_wl" -c "v_mv_gw_wl.objectid, v_mv_gw_wl.stn_id, v_mv_gw_wl.stn_nm, v_mv_gw_wl.stn_type, v_mv_gw_wl.stn_ctgry, v_mv_gw_wl.srce_offcl_nm, v_mv_gw_wl.lat_no_dd, v_mv_gw_wl.long_no_dd, v_mv_gw_wl.pnt_loc_dsc, v_mv_gw_wl.county, v_mv_gw_wl.twnshp_id, v_mv_gw_wl.rng_id, v_mv_gw_wl.sect_id, v_mv_gw_wl.hydro_unit_nm, v_mv_gw_wl.quad_bsn_nm, v_mv_gw_wl.mjr_bsn_nm, v_mv_gw_wl.plan_unit_nm, v_mv_gw_wl.topo_quad_nm, v_mv_gw_wl.physgrph_div_nm, v_mv_gw_wl.div_nm, v_mv_gw_wl.horz_det_mthd, v_mv_gw_wl.horz_ctl_dtm, v_mv_gw_wl.horz_use_strt_dt, v_mv_gw_wl.lnd_srfc_elev_val, v_mv_gw_wl.lse_use_strt_dt, v_mv_gw_wl.lse_vert_det_mthd_desc, v_mv_gw_wl.lse_vert_ctl_dtm_desc, v_mv_gw_wl.mp_meas_pnt_elev_val, v_mv_gw_wl.mp_use_strt_dt, v_mv_gw_wl.mp_vert_det_mthd_desc, v_mv_gw_wl.mp_vert_ctrl_dtm_desc, v_mv_gw_wl.stick_up_val, v_mv_gw_wl.totl_well_csng_dpth_qty, v_mv_gw_wl.cur_well_dpth_qty, v_mv_gw_wl.well_drl_dpth_qty, v_mv_gw_wl.nomnl_csng_dmtr_qty, v_mv_gw_wl.well_use, v_mv_gw_wl.well_stts, v_mv_gw_wl.cmplt_dt, v_mv_gw_wl.stts_dt, v_mv_gw_wl.site_nm, v_mv_gw_wl.shrt_nm, v_mv_gw_wl.long_nm, v_mv_gw_wl.hydron_id, v_mv_gw_wl.freq, v_mv_gw_wl.coll_agncy, v_mv_gw_wl.stn_project_nm, v_mv_gw_wl.stn_project_mgr, v_mv_gw_wl.sdms_project_nm, v_mv_gw_wl.sdms_project_mgr, v_mv_gw_wl.sdms_div_id, v_mv_gw_wl.sdms_div_nm, v_mv_gw_wl.sftwr_id, v_mv_gw_wl.sftwr_nm, v_mv_gw_wl.view_refresh_date, stn_et_geom.shape" -w "stn_et_geom.stn_id=v_mv_gw_wl.stn_id" -i esri_sde -s earth -u gislib -p *******

_________________

 

Spatial data description

Vector data information

ESRI description

GISLIB_STN_ET_GW_Q

ESRI feature type: Simple
Geometry type: Point
Topology: FALSE
Feature count: 33
Spatial Index: TRUE
Linear referencing: FALSE

 

SDTS description

Feature class: SDTS feature type, feature count

·  GISLIB_STN_ET_GW_Q: Entity point, 33

 

 

Details for GISLIB_STN_ET_GW_Q

Type of object: Feature Class

Number of records: 33

Attributes

OBJECTID

Alias: OBJECTID
Data type: OID
Width: 4
Precision: 0
Scale: 0
Definition:

Internal feature number.

Definition Source:

ESRI

 

STN_ID

Alias: STN_ID
Data type: Double
Width: 8
Precision: 0
Scale: 0
Definition:

.          Station ID - unique station identifier in master Station Header table on PROD database

Definition Source:

.          Station Header Web App (PROD)  ==>  stn_et.stn_id
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

STN_NM

Alias: STN_NM
Data type: String
Width: 50
Precision: 0
Scale: 0
Definition:

.          Station Name

Definition Source:

.          Station Header Web App (PROD)   ==>  stn_et.stn_nm
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)

 

STN_TYPE

Alias: STN_TYPE
Data type: String
Width: 60
Precision: 0
Scale: 0
Definition:

.          Station Type

Definition Source:

.          Station Header Web App (PROD)   ==>  (select def.tp_dsc from sjr_abbr_def_et def,stn_et s where def.tp_id = s.stn_tp_cd) stn_type
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

STN_CTGRY

Alias: STN_CTGRY
Data type: String
Width: 60
Precision: 0
Scale: 0
Definition:

.          Station Category

Definition Source:

.          Station Header Web App (PROD)   ==>  (select def.tp_dsc from sjr_abbr_def_et def,stn_et s where def.tp_id = s.stn_ctgry_cd) stn_ctgry
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

SRCE_OFFCL_NM

Alias: SRCE_OFFCL_NM
Data type: String
Width: 40
Precision: 0
Scale: 0
Definition:

.          Source Official Name

Definition Source:

.          Station Header Web App (PROD) ==> (select wt.srce_offcl_nm from stn_et s LEFT OUTER JOIN wtr_srce_et wt ON (s.srce_id = wt.srce_id)  )
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

LAT_NO_DD

Alias: LAT_NO_DD
Data type: Double
Width: 8
Precision: 0
Scale: 0
Definition:

.          Latitude in Decimal Degrees

Definition Source:

.          Station Header  (PROD) ==> stn_et.lat_no converted to Decimal Degrees:  
.
 ((stn_et.lat_no - mod(stn_et.lat_no,10000)) / 10000) +  (((mod(stn_et.lat_no,10000) - mod(stn_et.lat_no,100)) / 100 ) / 60) + (mod(stn_et.lat_no,100)  / 3600) lat_no_dd
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

LONG_NO_DD

Alias: LONG_NO_DD
Data type: Double
Width: 8
Precision: 0
Scale: 0
Definition:

.          Longitude in Decimal Degrees

Definition Source:

.          Station Header  (PROD) ==> stn_et.long_no converted to Decimal Degrees:  
.
(((stn_et.long_no - mod(stn_et.long_no,10000)) / 10000) + (((mod(stn_et.long_no,10000) - mod(stn_et.long_no,100)) / 100 ) / 60) + (mod(stn_et.long_no,100) / 3600) ) * -1.0 long_no_dd
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

COUNTY

Alias: COUNTY
Data type: String
Width: 20
Precision: 0
Scale: 0
Definition:

.          County

Definition Source:

.          Station Header Web App (PROD) ==> (select cty.cnty_nm from cnty_et cty, stn_et s where cty_cnty_id = s.cnty_id) county
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

DIV_NM

Alias: DIV_NM
Data type: String
Width: 100
Precision: 0
Scale: 0
Definition:

.          Division Name

Definition Source:

.          Station Header Web App (PROD) ==> select div.org_unit_nm from stn_et s LEFT OUTER JOIN sjr.sjr_div_et div ON (s.div_id = div.div_id)
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

LND_SRFC_ELEV_VAL

Alias: LND_SRFC_ELEV_VAL
Data type: Double
Width: 8
Precision: 0
Scale: 0
Definition:

.          Land Surface Elevation Value

Definition Source:

.          Station Header Web App (PROD) ==> (select svh_lse.lnd_srfc_elev_val from stn_vert_hist svh_lse INNER JOIN stn_et s ON (svh_lse.stn_id=s.stn_id) 
                                                                   where  
                                                                         svh_lse.cur_use_cd=1
                                                                      and svh_lse.use_strt_dt = (select max(svh_x.use_strt_dt) from stn_vert_hist svh_x
                                                                                                              where svh_x.stn_id= svh_lse.stn_id
                                                                                                                and svh_x.cur_use_cd = 1
                                                                                                                and svh_x.lnd_srfc_elev_val < 500
                                                                                                                and svh_x.lnd_srfc_elev_val != -1)
                                                                     ) lnd_srfc_elev_val
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

HORZ_DET_MTHD

Alias: HORZ_DET_MTHD
Data type: String
Width: 60
Precision: 0
Scale: 0

HORZ_CTL_DTM

Alias: HORZ_CTL_DTM
Data type: String
Width: 60
Precision: 0
Scale: 0

HORZ_USE_STRT_DT

Alias: HORZ_USE_STRT_DT
Data type: Date
Width: 8
Precision: 0
Scale: 0

MP_MEAS_PNT_ELEV_VAL

Alias: MP_MEAS_PNT_ELEV_VAL
Data type: Double
Width: 8
Precision: 0
Scale: 0
Definition:

.          Measuring Point Elevation Value

Definition Source:

.          Station Header Web App (PROD) ==> (select svh_mp.meas_pnt_elev_val from stn_vert_hist svh_mp INNER JOIN stn_et s ON (svh_mp.stn_id=s.stn_id)
                                                                   where 
                                                                         svh_mp.cur_use_cd=1
                                                                     and svh_mp.mp_dtm_tp_cd=3253
                                                                     and svh_mp.data_srce='SINDEX'
                                                                     and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1,
                                                                                                                                                              'NOTFLOWING',2,3))
                                                                                                                                                       from 
                                                                                                                                                            stn_vert_hist svh_x
                                                                                                                                                       where 
                                                                                                                                                            svh_x.stn_id=svh_mp.stn_id
                                                                                                                                                        and svh_x.cur_use_cd=1
                                                                                                                                                        and svh_x.mp_dtm_tp_cd=3253
                                                                                                                                                        and svh_X.data_srce='SINDEX'
                                                                                                                                                        and svh_x.meas_pnt_elev_val < 500
                                                                                                                                                        and svh_x.meas_pnt_elev_val != -1)
                                                                     and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) 
                                                                                               from 
                                                                                                    stn_vert_hist svh_x
                                                                                               where 
                                                                                                    svh_x.stn_id= svh_mp.stn_id
                                                                                                and svh_x.cur_use_cd = 1
                                                                                                and svh_x.mp_dtm_tp_cd = 3253
                                                                                                and svh_x.data_srce = 'SINDEX'
                                                                                                and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = 
                                                                                                                                   (select min(decode(svh_x.ref_id,'FLOWING',1,
                                                                                                                                                                   'NOTFLOWING',2,3))
                                                                                                                                    from stn_vert_hist svh_x
                                                                                                                                   where svh_x.stn_id=svh_mp.stn_id
                                                                                                                                   and svh_x.cur_use_cd=1
                                                                                                                                   and svh_x.mp_dtm_tp_cd=3253
                                                                                                                                   and svh_X.data_srce='SINDEX'
                                                                                                                                   and svh_x.meas_pnt_elev_val < 500
                                                                                                                                   and svh_x.meas_pnt_elev_val != -1)
                                                                                               )
                                                                     and svh_mp.meas_pnt_elev_val < 500
                                                                     and svh_mp.meas_pnt_elev_val != -1
                                           ) mp_meas_pnt_elev_val
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

LSE_USE_STRT_DT

Alias: LSE_USE_STRT_DT
Data type: Date
Width: 8
Precision: 0
Scale: 0

LSE_VERT_DET_MTHD_DESC

Alias: LSE_VERT_DET_MTHD_DESC
Data type: String
Width: 60
Precision: 0
Scale: 0

LSE_VERT_CTL_DTM_DESC

Alias: LSE_VERT_CTL_DTM_DESC
Data type: String
Width: 60
Precision: 0
Scale: 0

MP_VERT_CTRL_DTM_DESC

Alias: MP_VERT_CTRL_DTM_DESC
Data type: String
Width: 60
Precision: 0
Scale: 0
Definition:

.          Measuring Point Vertical Control Datum

Definition Source:

.          Station Header Web App (PROD) ==> (select def.tp_dsc from sjr_abbr_def_et def INNER JOIN stn_vert_hist svh_mp ON (def.tp_id=svh_mp.ctrl_dtm_cd) 
                                                                                                                            INNER JOIN stn_et s ON (svh_mp.stn_id=s.stn_id)
                                                                   where 
                                                                         svh_mp.cur_use_cd=1
                                                                     and svh_mp.mp_dtm_tp_cd=3253
                                                                     and svh_mp.data_srce='SINDEX'
                                                                     and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = (select min(decode(svh_x.ref_id,'FLOWING',1,
                                                                                                                                                              'NOTFLOWING',2,3))
                                                                                                                                                       from 
                                                                                                                                                            stn_vert_hist svh_x
                                                                                                                                                       where 
                                                                                                                                                            svh_x.stn_id=svh_mp.stn_id
                                                                                                                                                        and svh_x.cur_use_cd=1
                                                                                                                                                        and svh_x.mp_dtm_tp_cd=3253
                                                                                                                                                        and svh_X.data_srce='SINDEX'
                                                                                                                                                        and svh_x.meas_pnt_elev_val < 500
                                                                                                                                                        and svh_x.meas_pnt_elev_val != -1)
                                                                     and svh_mp.use_strt_dt = (select max(svh_x.use_strt_dt) 
                                                                                               from 
                                                                                                    stn_vert_hist svh_x
                                                                                               where 
                                                                                                    svh_x.stn_id= svh_mp.stn_id
                                                                                                and svh_x.cur_use_cd = 1
                                                                                                and svh_x.mp_dtm_tp_cd = 3253
                                                                                                and svh_x.data_srce = 'SINDEX'
                                                                                                and decode(svh_mp.ref_id,'FLOWING',1,'NOTFLOWING',2,3) = 
                                                                                                                                   (select min(decode(svh_x.ref_id,'FLOWING',1,
                                                                                                                                                                   'NOTFLOWING',2,3))
                                                                                                                                    from stn_vert_hist svh_x
                                                                                                                                   where svh_x.stn_id=svh_mp.stn_id
                                                                                                                                   and svh_x.cur_use_cd=1
                                                                                                                                   and svh_x.mp_dtm_tp_cd=3253
                                                                                                                                   and svh_X.data_srce='SINDEX'
                                                                                                                                   and svh_x.meas_pnt_elev_val < 500
                                                                                                                                   and svh_x.meas_pnt_elev_val != -1)
                                                                                               )
                                                                     and svh_mp.meas_pnt_elev_val < 500
                                                                     and svh_mp.meas_pnt_elev_val != -1
 
                                           ) mp_vert_ctrl_dtm_desc 
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           stn_et s 
.                                                    where
                                                            s.stn_id in 
                                                                  (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and                    -- > "Active/Physical Station Status
                                                                   hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                                  -- > "Water Level"
                                                                   )
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

MP_USE_STRT_DT

Alias: MP_USE_STRT_DT
Data type: Date
Width: 8
Precision: 0
Scale: 0

MP_VERT_DET_MTHD_DESC

Alias: MP_VERT_DET_MTHD_DESC
Data type: String
Width: 60
Precision: 0
Scale: 0

SDMS_MON_STTS

Alias: SDMS_MON_STTS
Data type: String
Width: 1
Precision: 0
Scale: 0

SITE_NM

Alias: SITE_NM
Data type: String
Width: 100
Precision: 0
Scale: 0
Definition:

.          Monitoring Site Name

Definition Source:

.          SDMS Web App (PROD) ==>  (select ses.site_nm from stn_evnt_site ses INNER JOIN hydro_stn_evnt hse ON (ses.site_id=hse.site_id) 
                                                                                                              INNER JOIN stn_et s ON (hse.stn_id=s.stn_id)
.                                                 ) site_nm
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id)
.                                                    where
                                                            hse.stts_cd=1                                                                       -- > "Active/Physical Station Status
                                                       and  
                                                            hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                   -- > "Water Level"
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

HYDRON_ID

Alias: HYDRON_ID
Data type: String
Width: 10
Precision: 0
Scale: 0
Definition:

.          Hydron ID

Definition Source:

.          SDMS Web App (PROD) ==>  (select hse.hydron_id from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id=s.stn_id) )
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id)
.                                                    where
                                                            hse.stts_cd=1                                                                       -- > "Active/Physical Station Status
                                                       and  
                                                            hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                   -- > "Water Level"
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

SHRT_NM

Alias: SHRT_NM
Data type: String
Width: 100
Precision: 0
Scale: 0

FREQ

Alias: FREQ
Data type: String
Width: 60
Precision: 0
Scale: 0
Definition:

.          Frequency

Definition Source:

.          SDMS Web App (PROD) ==>  (select def.tp_dsc from sjr_abbr_def_et def INNER JOIN hydro_stn_evnt hse ON (def.tp_id=hse.freq_cd) 
                                                                                                              INNER JOIN stn_et s ON (hse.stn_id=s.stn_id)
.                                                 ) freq
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id)
.                                                    where
                                                            hse.stts_cd=1                                                                       -- > "Active/Physical Station Status
                                                       and  
                                                            hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                   -- > "Water Level"
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

COLL_AGNCY

Alias: COLL_AGNCY
Data type: String
Width: 100
Precision: 0
Scale: 0
Definition:

.          Collection Agency

Definition Source:

.          SDMS Web App (PROD) ==>  (select sc.coll_agncy_nm from stn_evnt_coll_agncy sc INNER JOIN hydro_stn_evnt hse ON (sc.coll_agncy_cd=hse.coll_agncy_cd_cd) 
                                                                                                                            INNER JOIN stn_et s ON (hse.stn_id=s.stn_id)
.                                                 ) coll_agncy
.          
.          
.          
.                         overall filter ==>  
                                                    from
                                                           hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id)
.                                                    where
                                                            hse.stts_cd=1                                                                       -- > "Active/Physical Station Status
                                                       and  
                                                            hse.evnt_tp_cd = (select sevt.evnt_tp_cd from stn_evnt_tp sevt 
                                                                                                 where sevt.evnt_tp_nm='Water Level')                   -- > "Water Level"
                                                     and
                                                            s.stn_ctgry_cd in (905,1513,1539,3223)              --> "Groundwater, Springs, Man-made Spring, Seep"

 

SHAPE

Alias: SHAPE
Data type: Geometry
Width: 0
Precision: 0
Scale: 0
Definition:

Feature geometry.

Definition Source:

ESRI

 

VIEW_REFRESH_DATE

Alias: VIEW_REFRESH_DATE
Data type: Date
Width: 8
Precision: 0
Scale: 0

_________________

 

Overview

Attribute Descriptions:
OBJECTID- ESRI software unique object id for record. 
STN_ID - A Unique Feature Identifier (numeric) in the SJRWMD's Oracle table, Station Header.
STN_NM- Unique Official name (text) of the spring.
STN_TYPE- Station Feature Type, i.e., Well or Point.
STN_CTGRY- Station Category, i.e., Groundwater, Springs, Man-made Spring, Seep
SRCE_OFFCL_NM- Source Official Name of the Aquifer that is the source of the feature. 
LAT_NO_DD- Decimal Degree Location of Latitude.
LONG_NO_DD- Decimal Degree Location of Longitude.
COUNTY- Name of County where feature is located. 
DIV_NM - SJRWMD Division Name; Division ownership for record editing.
LND_SRFC_ELEV_VAL- Land Surface Elevation Value (feet). 
HORZ_DET_MTHD- Horizontal Determination Method, i.e., GPS, GPS2, Control Survey, etc. 
HORZ_CTL_DTM- Horizontal Control Datum, i.e., NAD-27, NAD-83, WGS-84. 
HORZ_USE_STRT_DT- Horizontal Elevation Use Start Date. 
LSE_USE_STRT_DT- Land Surface Elevation Use Start Date. 
LSE_VERT_DET_MTHD_DESC- Land Surface Elevation Vertical.  
LSE_VERT_CTL_DTM_DESC- Land Surface Elevation Vertical Control, i.e., NGVD-29 or NAVD-88. 
MP_MEAS_PNT_ELEV_VAL- Measuring Point Elevation Value. 
MP_VERT_CTRL_DTM_DESC- Measuring Point vertical determination method description, i.e., Control Survey, Resource Survey. 
MP_USE_STRT_DT- Measuring Point Use Start Date. 
MP_VERT_DET_MTHD_DESC- Measuring Point vertical control datum description, i.e., NGVD-29 or NAVD-88.
STICK_UP_VAL- Stick Up Value.  
TOTL_WELL_CSNG_DPTH_QTY- Total Well Casing Depth (feet). 
CUR_WELL_DPTH_QTY- Current Well Depth (feet). 
WELL_DRL_DPTH_QTY- Well Drill Depth (feet). 
NOMNL_CSNG_DMTR_QTY- Nominal Casing Diameter (inches).  
SDMS_MON_STTS- Sindex Data Management System monitoring status, i.e., Y, for yes = Active monitoring. 
WELL_USE- Well Use Type, i.e., Observation|Unused, Withdrawal|Public supply, etc.
CMPLT_DT- Well Completion Date.  
STTS_DT- Status Date.  
SITE_NM- HDS's Site Name.  
SHRT_NM- HDS's Short Name, may match Station Header's STN_NM.  
HYDRON_ID- HDS's Sindex Id. 
FREQ- Monitoring Frequency of data collection, i.e., Quarterly, Annually, etc.  
COLL_AGNCY- Collection agency of data. 
SHAPE- ESRI software Feature Geometry.  
VIEW_REFRESH_DATE- SDE View Refresh Date, for the last time the data view was generated.