|
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 networksEvaluate and refine the networks to optimize the spatial and temporal data collectionEvaluate and analyze the data collected from the networks using statistical, geostatistical, graphical, and mapping methods to produce useful informationAssess the effectiveness of the information derived from the networks to meet current and future water management needsDistribute 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, SeepSRCE_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.