contrib:databasequery

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
contrib:databasequery [2014/06/30 10:39]
brucemutton link to Cheddar sql
contrib:databasequery [2014/08/28 22:35] (current)
daveclucas Details of new version by Dave Clucas added
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. An example can be found [[http://wotcc.org.uk/Cheddar/|here]]. The web files should be transferable to different Web servers or local machines, to allow different project to use them. See [[[[contrib:DatabaseQuery;Install|Installation Instructions]] for further detail.+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://wotcc.org.uk/Cheddar/|here]] and a new, more comprehensive version [[http://sarawak-caves.com/php/websearch.php]|here]]. The web files should be transferable to different Web servers or local machines, to allow different project to use them. See [[[[contrib:DatabaseQuery;Install|Installation Instructions]] for further detail.
  
 ===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
  
  
  • contrib/databasequery.txt
  • Last modified: 6 years ago
  • by daveclucas