Closed brmagnuson closed 9 years ago
In the following examples, these are called from the query page. Note, demand queries are most interesting, we currently don't pull out a lot of attributes for supply.
For shorthand, the form is specified as:
form | value |
---|---|
Table | Demand |
Watershed | EEL RIVER |
Date | 5-1-2014 |
With the Query changing.
Desire | Query |
---|---|
One Application | SELECT * WHERE application_number='A001719' |
Large Riparian Demands, Descending | SELECT * WHERE riparian = true and demand > 20 ORDER by demand desc |
Latest Appropriative rights | SELECT * WHERE water_right_type='Appropriative' and priority_date > '1990-01-01' order by priority_date desc |
For a specific HUC | SELECT * WHERE huc_12 = '180101050802' |
Examples are up.
This looks great; just one further request to clarify: I had trouble understanding this line: "With the form is specified as:". I had to go back to Quinn's example above to figure it out. I think this would be more clear: "With the above form specified as:" (dropping the is and adding the above). Also, I would change the period after "With the Query changing." to a colon so that it matches the other instructional line.
@brmagnuson push changes. Let me know if this is good to close.
Looks good to close, other than I'm not seeing any of the changes in Chrome--does that just take another push later on once all the issues are closed?
@brmagnuson The changes were pushed yesterday. Can you refresh your browser and let me know if you see the updates?
That finally worked; I had to clear the cache, apparently. Thanks!
@qjhart can you provide some nice examples and I will add them to the page?