Laserfiche WebLink
<br />6.0 The Query Menu <br /> <br />remove a struClure from the list of Currently Selected Structures, <br />single-click on the item to be removed, or if all structures are to be <br />cleared, click on the Deselect All button below Ihe Iisl of structures. <br />Next select the display method. Diversion dala can be displayed in <br />various ways. If multiple structures are selecled, the user has the <br />option of displaying all diversion data in a single window or sepa- <br />rated out in multiple windows (one diversion record per window). <br />The diversion data may be displayed as tabular OUtpUl or as a <br />hydrograph. Unlike streamflow data, only daily displays of diversion <br />data are available, since no more than one value is submitted each <br />day by Waler Commissioners. Afterchoosing the appropriate display <br />method, click on the Display button 10 view Ihe dala."" <br /> <br />6.4 . Water Rights Tabulation <br /> <br />The Water Righls Query dialog can be reached via the Query I Water <br />Rights Tabulation menu ilem. <br /> <br />This dialog provides the user with the abilily to browse the Division I Waler <br />Righls Tabulation. Water righls within the tabulation can be selected based <br />on particular structures, specific administration numbers, decreed amoums <br />(acre-feel or cfs), as well as use and adjudication types. Any combination of <br />these selection criteria may be combined 10 form a tabulation query. <br /> <br />6.4.1 Formulating a Query <br /> <br />In order to view data from the Water RighlS Tabulation, the user must <br />formulate a logical request to be submitted 10 the database. Tabulaled <br />water righlS which meet the selection criteria of the formulaled <br />requesl will be selected for display. The requesl muSl follow a spe- <br />cific syntax known as SQL. SQL Stalements for the Water Rights <br />Query dialog all begin with "SELECT all water rights WHERE:", <br />followed by selection crileria specified by the user. The user may add <br />selection criteria by using the many imerface items in the dialog. The <br />SQL query may be lyped direclly into the text box althe lOp of the <br />dialog, or formulated using the imerface items in the lower portion of <br />the dialog. <br /> <br />The request can consist of a single condition, or of several conditions <br />joined by logical operalors such as AND, OR, =, elC. It is importanl <br />to use the correcl operator, and easy to use the wrong one, creating an <br />illogical statement For example, it would be incorrecl to formulate a <br />query such as "SELECT all water rights Where: (WD = 23 AND <br />10 = 3904) AND (WD = 23 AND 10 = 908)" because there are no <br /> <br />7131194 36 <br />