ÿþ<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <!-- saved from url=(0077)file://X:\GWP\Users\jstokes\MetadataTemplate\web\gw_monitoring_network_q.html --> <HTML><HEAD> <META http-equiv=Content-Type content="text/html; charset=unicode"> <STYLE>BODY { FONT-SIZE: 10pt; MARGIN: 0.25in; FONT-FAMILY: Arial,sans-serif; BACKGROUND-COLOR: #fbffff } H1 { FONT-WEIGHT: bold; FONT-SIZE: 18px; MARGIN-LEFT: 0.05in; COLOR: #006400; FONT-FAMILY: Verdana,sans-serif; POSITION: relative; TOP: -6px; TEXT-ALIGN: center } H2 { FONT-SIZE: 13px; MARGIN-LEFT: 0.25in; COLOR: #006400; FONT-FAMILY: Verdana,sans-serif; POSITION: relative; TOP: -16px; TEXT-ALIGN: center } TABLE { TABLE-LAYOUT: fixed; POSITION: relative; TOP: -10px; BORDER-COLLAPSE: collapse; valign: top } TD { TEXT-ALIGN: center } TD { FONT-WEIGHT: bold; FONT-SIZE: 11pt; BORDER-LEFT-COLOR: #6495ed; BORDER-BOTTOM-COLOR: #6495ed; BORDER-TOP-COLOR: #6495ed; BORDER-RIGHT-COLOR: #6495ed } .tsel { COLOR: #ffffff; BACKGROUND-COLOR: #6495ed } .tun { COLOR: #00008b; BACKGROUND-COLOR: #b8defa } .tover { CURSOR: hand; COLOR: #0000cd; BACKGROUND-COLOR: #b8e6ff } .f { BORDER-RIGHT: #6495ed 1.5pt solid; BORDER-TOP: #6495ed 1.5pt solid; BORDER-LEFT: #6495ed 1.5pt solid; BORDER-BOTTOM: #6495ed 1.5pt solid; POSITION: relative; TOP: -10px; BACKGROUND-COLOR: #ffffff } .ph1 { FONT-WEIGHT: bold; COLOR: #2e8b57 } .ph2 { FONT-WEIGHT: bold; MARGIN-LEFT: 0.2in; COLOR: #2e8b57 } .pover1 { FONT-WEIGHT: bold; CURSOR: hand; COLOR: #006000 } .pover2 { FONT-WEIGHT: bold; MARGIN-LEFT: 0.2in; CURSOR: hand; COLOR: #006000 } .pn { FONT-WEIGHT: bold; COLOR: #00008b } .pv { MARGIN: 0in 0.15in 0.75in; COLOR: #191970; LINE-HEIGHT: 135%; FONT-FAMILY: Verdana,sans-serif } .pe1 { MARGIN-LEFT: 0.2in } .pe2 { FONT-WEIGHT: normal; MARGIN-LEFT: 0.25in; COLOR: #191970 } .lt { LINE-HEIGHT: 115% } .lt2 { MARGIN-BOTTOM: 1mm; LINE-HEIGHT: 115% } .sr1 { MARGIN-LEFT: 0in } .sr2 { MARGIN-LEFT: 0.2in } .sr3 { MARGIN-LEFT: 0.4in } .srh1 { FONT-WEIGHT: bold; MARGIN-LEFT: 0in; COLOR: #00008b } .srh2 { FONT-WEIGHT: bold; MARGIN-LEFT: 0.2in; COLOR: #00008b } .name { FONT-WEIGHT: bold; FONT-SIZE: 18px; MARGIN-LEFT: 0.05in; COLOR: #006400; FONT-FAMILY: Verdana,sans-serif; POSITION: relative; TOP: -6px; TEXT-ALIGN: center } .sub { FONT-WEIGHT: bold; FONT-SIZE: 13px; MARGIN-LEFT: 0.25in; COLOR: #006400; FONT-FAMILY: Verdana,sans-serif; POSITION: relative; TOP: 3px; TEXT-ALIGN: center } .search { FONT-SIZE: 13px; MARGIN: 0in 0.15in 0.75in; COLOR: #191970; FONT-FAMILY: Verdana,sans-serif } .head { COLOR: #006400 } </STYLE> <SCRIPT language=JScript><!-- //changes the color of the tabs or headings that you can click //when the mouse hovers over them function doHilite() { var e = window.event.srcElement; if (e.className == "tun") { e.className = "tover"; } else if (e.className == "tover") { e.className = "tun"; } else if (e.className == "ph1") { e.className = "pover1"; } else if (e.className == "ph2") { e.className = "pover2"; } else if (e.className == "pover1") { e.className = "ph1"; } else if (e.className == "pover2") { e.className = "ph2"; } window.event.cancelBubble = true; } //changes the style of the selected tab to unselected and hide its text, then //set the style of the tab that was clicked on to selected and show its text function changeTab(eRow) { var tabs = eRow.cells; for (var i = 0; i < tabs.length; i++) { var oldTab = tabs[i]; if (oldTab.className == "tsel") { break; } } oldTab.className = "tun"; var oldContent = getAssociated(oldTab); oldContent.style.display = "none"; var newTab = window.event.srcElement; newTab.className ="tsel"; var newContent = getAssociated(newTab); newContent.style.display = "block"; window.event.cancelBubble = true; } //hide or show the text assoicated with the heading that was clicked function hideShowGroup(e) { var theGroup = e.children[0]; if (theGroup.style.display == "none") { theGroup.style.display="block"; } else { theGroup.style.display="none"; } window.event.cancelBubble = true; } //returns the name of the element containing the text associated with each tab function getAssociated(e) { if (e.tagName == "TD") { switch (e.id) { case "DescTab": return (Description); case "SpatialTab": return (Spatial); case "AttribTab": return (Attributes); } } } //centers the thumbnail function position() { var e; e = document.all("thumbnail"); if (e != null) { b = document.body; w1 = b.clientWidth - 80; w2 = w1 - thumbnail.width; var margin = Math.floor(w2 * .5); thumbnail.style.visibility = "hidden"; thumbnail.style.marginLeft = margin; thumbnail.style.visibility = "visible"; } } //parse text to respect line breaks added - increases readability. //lines beginning with a ">" character are presented with a monospace //(fixed-width) font - e.g., so equations will appear correctly function fix(e) { var par = e.parentNode; e.id = ""; var pos = e.innerText.indexOf("\n"); if (pos > 0) { while (pos > 0) { var t = e.childNodes(0); var n = document.createElement("PRE"); var s = t.splitText(pos); e.insertAdjacentElement("afterEnd", n); n.appendChild(s); e = n; pos = e.innerText.indexOf("\n"); } var count = (par.children.length); for (var i = 0; i < count; i++) { e = par.children(i); if (e.tagName == "PRE") { pos = e.innerText.indexOf(">"); if (pos != 0) { n = document.createElement("DIV"); e.insertAdjacentElement("afterEnd", n); n.innerText = e.innerText; e.removeNode(true); } } } if (par.children.tags("PRE").length > 0) { count = (par.childNodes.length); for (i = 0; i < count; i++) { e = par.children(i); if (e.tagName == "PRE") { e.id = ""; if (i < (count-1)) { var e2 = par.children(i + 1); if (e2.tagName == "PRE") { e.insertAdjacentText("beforeEnd", e2.innerText+"\n"); e2.removeNode(true); count = count-1; i = i-1; } } } } } } else { n = document.createElement("DIV"); par.appendChild(n); n.innerText = e.innerText; e.removeNode(true); } } --></SCRIPT> <META content="MSHTML 6.00.6000.16981" name=GENERATOR></HEAD> <BODY oncontextmenu="return true" onresize=position(); onload=position();> <H1>From SDE view on SJRWMD Oracle database, Active Groundwater Monitoring Network - Discharge Event Type, current on 09/14/2010</H1> <H2>Personal GeoDatabase Feature Class </H2> <TABLE height=28 cols=3 rules=cols width=315 frame=void> <COLGROUP> <COL width=105> <COL width=105> <COL width=105> <TBODY> <TR onmouseover=doHilite() onclick=changeTab(this) onmouseout=doHilite() height=28> <TD class=tsel id=DescTab title="Click to see a description of the data">Description</TD> <TD class=tun id=SpatialTab title="Click for details about the spatial data">Spatial</TD> <TD class=tun id=AttribTab title="Click for details about the attribute data">Attributes</TD></TR></TBODY></TABLE> <DIV class=f id=Group> <DIV class=pv id=Description style="DISPLAY: block"><BR> <DIV class=pn>Keywords</DIV> <DIV class=lt2 style="MARGIN-LEFT: 0.2in"><SPAN class=pn>Theme: </SPAN>geoscientificInformation, Groundwater, Hydrogeology, Groundwater, Model</DIV> <DIV class=lt2 style="MARGIN-LEFT: 0.2in"><SPAN class=pn>Place: </SPAN>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</DIV><BR> <DIV class=pn>Description</DIV> <DIV class=ph2 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Abstract <DIV class=pe2><SPAN class=lt><PRE id=original>NOTE: EXPORT FROM ORIGINAL SDE FEATURE CLASS, 09/14/2010, 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 Division of Groundwater Programs (GWP) through the Water Resources Assessment section, a Field Services (well construction) section, and a Geophysical Logging section. The Division of Hydrologic Data Services 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.</PRE></SPAN><BR> <SCRIPT>fix(original)</SCRIPT> </DIV></DIV> <DIV class=ph2 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Purpose <DIV class=pe2 id=Purpose><SPAN class=lt><PRE id=original>Request from Groundwater Programs Division (Jill Stokes) - 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 &amp; 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 &amp; Logging and SDMS.</PRE></SPAN><BR> <SCRIPT>fix(original)</SCRIPT> </DIV></DIV> <DIV class=ph2 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Supplementary Information <DIV class=pe2><SPAN class=lt><PRE id=original>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) pointint 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. ..</PRE></SPAN><BR> <SCRIPT>fix(original)</SCRIPT> </DIV></DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Status of the data <DIV class=pe2 style="DISPLAY: none">Complete<BR><I>Data update frequency: </I>As needed<BR></DIV></DIV><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Time period for which the data is relevant <DIV class=pe2 style="DISPLAY: none"> <DIV><I>Date and time: </I>09/2010</DIV> <DIV><I>Description: </I><SPAN class=lt><PRE id=original>publication date</PRE></SPAN><BR> <SCRIPT>fix(original)</SCRIPT> </DIV></DIV></DIV><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Publication Information <DIV class=pe2 style="DISPLAY: none"><SPAN class=lt2><I>Who created the data: </I>St. Johns River Water Management District<BR></SPAN> <DIV><I>Date and time: </I>09/2010</DIV> <DIV><I>Publisher and place: </I>St. Johns River Water Management District, Palatka, FL </DIV></DIV></DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Data storage and access information <DIV class=pe2 style="DISPLAY: none"><I>File name: </I>GISLIB_STN_ET_GW_Q<BR><I>Type of data: </I>vector digital data<BR> <DIV><I>Location of the data: </I></DIV> <DIV> <LI style="MARGIN-LEFT: 0.2in">\\palfile\sjrx\GWP\Users\jstokes\MetadataTemplate\web\gw_monitoring_network_q\SJRWMDdata20100914q.mdb</LI></DIV><I>Data processing environment: </I><SPAN class=lt>Microsoft Windows XP Version 5.1 (Build 2600) Service Pack 3; ESRI ArcCatalog 9.3.1.1850</SPAN><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Constraints on accessing and using the data <DIV class=pe2 style="DISPLAY: none"><I>Access constraints: </I><SPAN class=lt>None, The St. Johns River Water Management District, Department of Resource Management, Groundwater Programs Division, asks to be credited in derived products.<BR></SPAN> <DIV><I>Use constraints: </I><SPAN class=lt><PRE id=original>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.</PRE></SPAN><BR> <SCRIPT>fix(original)</SCRIPT> </DIV></DIV></DIV></DIV></DIV><BR> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Details about this document <DIV class=pe2 style="DISPLAY: none">Contents last updated: 20100920 at time 17582900 <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Who completed this document <DIV class=pe2 style="DISPLAY: none">Jill A. Stokes<BR>St. Johns River Water Management District<BR><I>mailing address:</I><BR> <DIV style="MARGIN-LEFT: 0.3in"> <DIV class=lt><PRE id=original>PO Box 1429</PRE> <SCRIPT>fix(original)</SCRIPT> </DIV> <DIV>Palatka, Florida 32178-1429</DIV> <DIV>USA</DIV><BR></DIV><I>physical address:</I><BR> <DIV style="MARGIN-LEFT: 0.3in"> <DIV class=lt><PRE id=original>4049 Reid St</PRE> <SCRIPT>fix(original)</SCRIPT> </DIV> <DIV>Palatka, Florida 32177</DIV> <DIV>USA</DIV></DIV><BR>386.329.4336 (voice)<BR>gwpsupport@sjrwmd.com<BR><BR> <DIV><I>Hours of service:</I> 0800-1700 EST</DIV> <DIV><I>Contact Instructions:</I></DIV> <DIV style="MARGIN-LEFT: 0.3in"><PRE id=original>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</PRE> <SCRIPT>fix(original)</SCRIPT> </DIV><BR></DIV></DIV> <DIV class=ph1 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Standards used to create this document <DIV class=pe2 style="DISPLAY: none"><I>Standard name: </I>FGDC Content Standards for Digital Geospatial Metadata<BR><I>Standard version: </I>FGDC-STD-001-1998<BR><I>Time convention used in this document: </I>local time<BR>Metadata profiles defining additonal information <LI style="MARGIN-LEFT: 0.2in">ESRI Metadata Profile: <A href="http://www.esri.com/metadata/esriprof80.html" target=viewer>http://www.esri.com/metadata/esriprof80.html</A> <LI style="MARGIN-LEFT: 0.2in">ESRI Metadata Profile: <A href="http://www.esri.com/metadata/esriprof80.html" target=viewer>http://www.esri.com/metadata/esriprof80.html</A></LI></DIV></DIV></DIV></DIV><BR></DIV> <DIV class=pv id=Spatial style="DISPLAY: none"><BR> <DIV class=pn>Horizontal coordinate system</DIV> <DIV style="MARGIN-LEFT: 0.2in"><I>Projected coordinate system name: </I>NAD_1983_HARN_UTM_Zone_17N</DIV> <DIV style="MARGIN-LEFT: 0.2in"><I>Geographic coordinate system name: </I>GCS_North_American_1983_HARN</DIV> <DIV class=ph2 onmouseover=doHilite() onclick=hideShowGroup(this) onmouseout=doHilite()>Details <DIV class=pe2 style="DISPLAY: none"> <DIV class=sr1><SPAN class=pn>Map Projection Name: </SPAN>Transverse Mercator</DIV> <DIV class=sr2><I>Scale Factor at Central Meridian: </I>0.999600<BR><I>Longitude of Central Meridian: </I>-81.000000<BR><I>Latitude of Projection Origin: </I>0.000000<BR><I>False Easting: </I>500000.000000<BR><I>False Northing: </I>0.000000<BR></DIV><BR> <DIV class=sr1><SPAN class=pn>Planar Coordinate Information</SPAN></DIV> <DIV class=sr2><I>Planar Distance Units: </I>meters</DIV> <DIV class=sr2><I>Coordinate Encoding Method: </I>coordinate pair</DIV> <DIV class=srh2>Coordinate Representation</DIV> <DIV class=sr3><I>Abscissa Resolution: </I>0.000145</DIV> <DIV class=sr3><I>Ordinate Resolution: </I>0.000145</DIV><BR> <DIV class=srh1>Geodetic Model</DIV> <DIV class=sr2><I>Horizontal Datum Name: </I>D_North_American_1983_HARN</DIV> <DIV class=sr2><I>Ellipsoid Name: </I>Geodetic Reference System 80</DIV> <DIV class=sr2><I>Semi-major Axis: </I>6378137.000000</DIV> <DIV class=sr2><I>Denominator of Flattening Ratio: </I>298.257222</DIV></DIV></DIV><BR> <DIV class=srh1>Altitude System Definition</DIV> <DIV class=sr2><I>Resolution: </I>1.000000</DIV> <DIV class=sr2><I>Encoding Method: </I>Explicit elevation coordinate included with horizontal coordinates</DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=pn>Bounding coordinates</DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in">Horizontal</DIV> <DIV class=pn style="MARGIN-LEFT: 0.4in">In decimal degrees</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>West: </I>-82.761111</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>East: </I>-81.246785</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>North: </I>30.341341</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>South: </I>28.557273</DIV> <DIV class=pn style="MARGIN-LEFT: 0.4in">In projected or local coordinates</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>Left: </I>330696.062922</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>Right: </I>475863.876632</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>Top: </I>3356636.351679</DIV> <DIV style="MARGIN-LEFT: 0.6in"><I>Bottom: </I>3160159.558620</DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=pn>Lineage</DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in">FGDC lineage</DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 1 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>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 &amp; Brahma - and will eventually be cleaned up, but in the meantime conditions such as where elevation values &lt; 500 and &lt;&gt;-1 are put in to filter this data out. --&gt; 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 &lt; 500 * MEAS_PNT_ELEV_VAL &lt;&gt; -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 &lt; 500 * LND_SRFC_ELEV_VAL &lt;&gt; -1<BR><BR></DIV></DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 2 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>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 &lt; 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 &lt; 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 &lt; 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 &lt; 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 &lt; 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 &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 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 -- &gt; "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)' -- &gt; "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; ...<BR><BR></DIV></DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 3 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>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 -- &gt; "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)' -- &gt; "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; ...<BR><BR></DIV></DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 4 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>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 -- &gt; "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)') -- &gt; "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; ..<BR><BR></DIV></DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 5 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>Process step to create final view containing all Station Header, WCL &amp; 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; ...<BR><BR></DIV></DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>Process step 6 <DIV class=pe2 style="DISPLAY: none; MARGIN-LEFT: 0.2in"><I>Process description: </I>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 ; --&gt; 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 *******<BR></DIV></DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=pn>Spatial data description</DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in">Vector data information</DIV> <DIV class=pn style="MARGIN-LEFT: 0.4in">ESRI description</DIV> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.6in" onclick=hideShowGroup(this) onmouseout=doHilite()>GISLIB_STN_ET_GW_Q <DIV class=pe2 style="DISPLAY: none"><I>ESRI feature type: </I>Simple<BR><I>Geometry type: </I>Point<BR><I>Topology: </I>FALSE<BR><I>Feature count: </I>33<BR><I>Spatial Index: </I>TRUE<BR><I>Linear referencing: </I>FALSE<BR></DIV></DIV><BR> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.4in" onclick=hideShowGroup(this) onmouseout=doHilite()>SDTS description <DIV class=pe2 style="DISPLAY: none"> <DIV>Feature class: SDTS feature type, feature count</DIV> <DIV style="MARGIN-LEFT: 0.2in"> <LI>GISLIB_STN_ET_GW_Q: Entity point, 33 </LI></DIV></DIV></DIV><BR></DIV> <DIV class=pv id=Attributes style="DISPLAY: none"><BR> <DIV class=pn>Details for GISLIB_STN_ET_GW_Q</DIV> <DIV style="MARGIN-LEFT: 0.2in"><I>Type of object: </I>Feature Class</DIV> <DIV style="MARGIN-LEFT: 0.2in"><I>Number of records: </I>33</DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in">Attributes <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>OBJECTID <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>OBJECTID<BR><I>Data type: </I>OID<BR><I>Width: </I>4<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>Internal feature number.</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>ESRI</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>STN_ID <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>STN_ID<BR><I>Data type: </I>Double<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Station ID - unique station identifier in master Station Header table on PROD database</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; stn_et.stn_id . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>STN_NM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>STN_NM<BR><I>Data type: </I>String<BR><I>Width: </I>50<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Station Name</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; stn_et.stn_nm . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223)</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>STN_TYPE <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>STN_TYPE<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Station Type</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>STN_CTGRY <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>STN_CTGRY<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Station Category</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>SRCE_OFFCL_NM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>SRCE_OFFCL_NM<BR><I>Data type: </I>String<BR><I>Width: </I>40<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Source Official Name</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LAT_NO_DD <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LAT_NO_DD<BR><I>Data type: </I>Double<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Latitude in Decimal Degrees</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header (PROD) ==&gt; 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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LONG_NO_DD <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LONG_NO_DD<BR><I>Data type: </I>Double<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Longitude in Decimal Degrees</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header (PROD) ==&gt; 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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>COUNTY <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>COUNTY<BR><I>Data type: </I>String<BR><I>Width: </I>20<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. County</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (select cty.cnty_nm from cnty_et cty, stn_et s where cty_cnty_id = s.cnty_id) county . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>DIV_NM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>DIV_NM<BR><I>Data type: </I>String<BR><I>Width: </I>100<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Division Name</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; 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 ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LND_SRFC_ELEV_VAL <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LND_SRFC_ELEV_VAL<BR><I>Data type: </I>Double<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Land Surface Elevation Value</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 &lt; 500 and svh_x.lnd_srfc_elev_val != -1) ) lnd_srfc_elev_val . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>HORZ_DET_MTHD <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>HORZ_DET_MTHD<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>HORZ_CTL_DTM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>HORZ_CTL_DTM<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>HORZ_USE_STRT_DT <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>HORZ_USE_STRT_DT<BR><I>Data type: </I>Date<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>MP_MEAS_PNT_ELEV_VAL <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>MP_MEAS_PNT_ELEV_VAL<BR><I>Data type: </I>Double<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Measuring Point Elevation Value</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_meas_pnt_elev_val . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LSE_USE_STRT_DT <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LSE_USE_STRT_DT<BR><I>Data type: </I>Date<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LSE_VERT_DET_MTHD_DESC <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LSE_VERT_DET_MTHD_DESC<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>LSE_VERT_CTL_DTM_DESC <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>LSE_VERT_CTL_DTM_DESC<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>MP_VERT_CTRL_DTM_DESC <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>MP_VERT_CTRL_DTM_DESC<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Measuring Point Vertical Control Datum</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. Station Header Web App (PROD) ==&gt; (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 &lt; 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 &lt; 500 and svh_x.meas_pnt_elev_val != -1) ) and svh_mp.meas_pnt_elev_val &lt; 500 and svh_mp.meas_pnt_elev_val != -1 ) mp_vert_ctrl_dtm_desc . . . . overall filter ==&gt; from stn_et s . where s.stn_id in (select hse.stn_id from hydro_stn_evnt hse where hse.stts_cd=1 and -- &gt; "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') -- &gt; "Water Level" ) and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>MP_USE_STRT_DT <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>MP_USE_STRT_DT<BR><I>Data type: </I>Date<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>MP_VERT_DET_MTHD_DESC <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>MP_VERT_DET_MTHD_DESC<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>SDMS_MON_STTS <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>SDMS_MON_STTS<BR><I>Data type: </I>String<BR><I>Width: </I>1<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>SITE_NM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>SITE_NM<BR><I>Data type: </I>String<BR><I>Width: </I>100<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Monitoring Site Name</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. SDMS Web App (PROD) ==&gt; (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 ==&gt; from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id) . where hse.stts_cd=1 -- &gt; "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') -- &gt; "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>HYDRON_ID <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>HYDRON_ID<BR><I>Data type: </I>String<BR><I>Width: </I>10<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Hydron ID</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. SDMS Web App (PROD) ==&gt; (select hse.hydron_id from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id=s.stn_id) ) . . . . overall filter ==&gt; from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id) . where hse.stts_cd=1 -- &gt; "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') -- &gt; "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>SHRT_NM <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>SHRT_NM<BR><I>Data type: </I>String<BR><I>Width: </I>100<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>FREQ <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>FREQ<BR><I>Data type: </I>String<BR><I>Width: </I>60<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Frequency</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. SDMS Web App (PROD) ==&gt; (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 ==&gt; from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id) . where hse.stts_cd=1 -- &gt; "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') -- &gt; "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>COLL_AGNCY <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>COLL_AGNCY<BR><I>Data type: </I>String<BR><I>Width: </I>100<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>. Collection Agency</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>. SDMS Web App (PROD) ==&gt; (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 ==&gt; from hydro_stn_evnt hse INNER JOIN stn_et s ON (hse.stn_id = s.stn_id) . where hse.stts_cd=1 -- &gt; "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') -- &gt; "Water Level" and s.stn_ctgry_cd in (905,1513,1539,3223) --&gt; "Groundwater, Springs, Man-made Spring, Seep"</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>SHAPE <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>SHAPE<BR><I>Data type: </I>Geometry<BR><I>Width: </I>0<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><SPAN class=lt><I>Definition: </I><PRE id=original>Feature geometry.</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <SPAN class=lt><I>Definition Source: </I><PRE id=original>ESRI</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV></DIV></DIV> <DIV class=pn style="MARGIN-LEFT: 0.2in"> <DIV class=ph2 onmouseover=doHilite() style="MARGIN-LEFT: 0.25in" onclick=hideShowGroup(this) onmouseout=doHilite()>VIEW_REFRESH_DATE <DIV class=pe2 style="DISPLAY: none"><I>Alias: </I>VIEW_REFRESH_DATE<BR><I>Data type: </I>Date<BR><I>Width: </I>8<BR><I>Precision: </I>0<BR><I>Scale: </I>0<BR><BR></DIV></DIV></DIV> <DIV style="COLOR: #6495ed; TEXT-ALIGN: center">_________________</DIV><BR> <DIV class=srh1>Overview</DIV> <DIV style="MARGIN-LEFT: 0.2in"><SPAN class=lt><PRE id=original>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.</PRE></SPAN> <SCRIPT>fix(original)</SCRIPT> <BR></DIV><BR></DIV></DIV></BODY></HTML>