Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
contrib:databasequery [2012/08/16 22:23] – link external viewers brucemutton | contrib:databasequery [2014/08/28 22:35] (current) – Details of new version by Dave Clucas added daveclucas | ||
---|---|---|---|
Line 20: | Line 20: | ||
====Web Interface==== | ====Web Interface==== | ||
- | To most cavers querying a sql database by hand is outside their skill set, therefore a web interface offering the following has been produced. The web files should be transferable to different Web servers or local machines, to allow different project to use them. See [[[[contrib: | + | To most cavers querying a sql database by hand is outside their skill set, therefore a web interface offering the following has been produced. An example can be found [[http:// |
===Queries Available=== | ===Queries Available=== | ||
Line 29: | Line 29: | ||
* Passage Surveyed or Explored | * Passage Surveyed or Explored | ||
* Between different dates | * Between different dates | ||
+ | * Filter by surveys containing a search key | ||
* The lengths of surveys | * The lengths of surveys | ||
* Explored between different dates | * Explored between different dates | ||
* Surveyed between different dates | * Surveyed between different dates | ||
+ | * Filter by surveys containing a search key | ||
* Passage Direction Polar Diagrams | * Passage Direction Polar Diagrams | ||
Line 41: | Line 43: | ||
* The number of segment for the diagram | * The number of segment for the diagram | ||
* The size of the diagram, in pixels produced | * The size of the diagram, in pixels produced | ||
+ | * Filter by surveys containing a search key | ||
+ | * Passages surveyed between different dates | ||
+ | |||
After the diagram a table of results is also displayed. For the Gradient vertically up is added into the last group. | After the diagram a table of results is also displayed. For the Gradient vertically up is added into the last group. | ||
Line 51: | Line 56: | ||
Currently the histogram is produced from all the data, including the duplicates and the surface leg, otherwise the search takes too long. If one of the altitudes given is between the actual minimum and maximum, currently the output gets it wrong. | Currently the histogram is produced from all the data, including the duplicates and the surface leg, otherwise the search takes too long. If one of the altitudes given is between the actual minimum and maximum, currently the output gets it wrong. | ||
After the diagram a table of results is produced. | After the diagram a table of results is produced. | ||
+ | |||
+ | ---- | ||
+ | |||
+ | * List of surveys with no surveyors | ||
+ | * List of surveys with no associated maps | ||
+ | * List of shot and/or station flags | ||