Laserfiche WebLink
<br />6.0 The Query Menu <br /> <br />Conditions relating to diversion structures are formulated using the <br />Structure fields of the Water Rights Query dialog. This approach <br />allows the user to quicidy find water rights records AT, UPSTREAM <br />from, or DOWNSTREAM from a selected structure. To formulate <br />such a condition, select a diversion structure by single-clicking on the <br />structure from the map display or from the Key Diversion Struc- <br />tures list (available via the Palette / Show Lists menu item dis- <br />cussed below), then click on the desired spatial relationship -- AT, <br />UPSTREAM, or DOWNSTREAM. The condition will appear in the <br />text box above. <br /> <br />Selection criteria based on administration number or d~ amount <br />are formulated using the Admin# and Amount fields in the middle of <br />the dialog. To query by administration number, enter the desired <br />number and click on the Admin# button to enter the condition in the <br />text box above. An operator must then be entered into the middle of <br />the text that was just created. For example, if you enter 5000 and <br />click the Admin# button, the incomplete text "AOMINNO 5000" will <br />appear in the text box. To complete the text to formulate a meaningful <br />condition, you must SpeCify whether the admin number should be <br />greater than, less than, or equal to 5000. The simplest way to do this <br />is to place the cursor before the number, in this case 5000, and select <br />the appropriate operator from the buttons at the bottom of the dialog. <br />Use the same approach to formulate a condition based on decreed <br />amount. These two selection criteria are most useful using the ine- <br />quality operators> and <: to select water rights that are senior / junior <br />to a known administration number or less than / greater than a certain <br />flow amount. <br /> <br />Selection criterion based on Use Type or Adjudication Type are <br />formulated using the lists at the bottom of the Water Rights Query <br />dialog. To select water rights of a particular use or adjudication type, <br />single-click on that item in the list. Be sure to use logical operators to <br />join the new condition with others in the SQL statement. <br /> <br />To view the results of a formulated query, click on the List button at <br />the bottom of the dialog. A separate dialog will appear showing the <br />water rights which meet the SpeCified selection criteria. <br /> <br />Due to memory limitations, there is a limit to the number of water <br />rightreconls which may be retrieved with a single query. If more than <br />1000 reconls are retrieved as a result of a query, the oUlpUllist will be <br />truncated and the user notified. <br /> <br />Click on the Clear button to erase the contents of the SQL query text <br />box before formulating each query. <br /> <br />7/31/94 <br /> <br />38 <br />