Difference between revisions of "Guam Rhino Beetle Eradication Project Database"
From Kbwiki
Aubrey Moore (Talk | contribs) |
Aubrey Moore (Talk | contribs) (→These scripts intended for public access to the database) |
||
(22 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
+ | ===These scripts intended for public access to the database=== | ||
+ | *[http://www.GuamInsects.net/oryctes/gev.php View animated Google Earth display of all trap data] | ||
+ | **Requires that the free [http://earth.google.com/ Google Earth] client is installed on your computer. This script downloads all trap catch data as a Google Earth data file (*.kml) file. | ||
+ | *[http://guaminsects.net/oryctes/guamcrb.kml Google Earth network link to project data] <font color=red>EXPERIMENTAL</font> | ||
+ | *[http://guaminsects.net/oryctes/trap_catch_all.php Monthly trap catch graph and table - all traps] | ||
+ | *[http://guaminsects.net/oryctes/trap_catch_pic.php Monthly trap catch graph and table - 28 PIC traps only - checked daily] | ||
+ | *[http://guaminsects.net/oryctes/obs_catch.php Monthly collection of CRB from sanitation/scouting] | ||
+ | *[http://guaminsects.net/oryctes/napis_export_form.php Export trap data in NAPIS CSV format] | ||
+ | |||
+ | ===These scripts are intended for trappers=== | ||
*[http://mysql.GuamInsects.net Access the project database, '''oryctes''', using phpMyAdmin.] Requires a user name and password. | *[http://mysql.GuamInsects.net Access the project database, '''oryctes''', using phpMyAdmin.] Requires a user name and password. | ||
− | *[http://www.GuamInsects.net/oryctes/ge_view.php View trap data using Google Earth.] Requires that Google Earth is installed on your computer. | + | *[http://www.GuamInsects.net/oryctes/ge_view.php View trap data using Google Earth (by trap route)] Requires that Google Earth is installed on your computer. |
+ | *[http://www.GuamInsects.net/oryctes/ge_view_2.php View trap data using Google Earth (by date)] Requires that Google Earth is installed on your computer. | ||
*[http://www.GuamInsects.net/oryctes/ge_view_hits.php View traps which have caught one or more beetles using Google Earth.] Requires that Google Earth is installed on your computer. | *[http://www.GuamInsects.net/oryctes/ge_view_hits.php View traps which have caught one or more beetles using Google Earth.] Requires that Google Earth is installed on your computer. | ||
*[http://www.guaminsects.net/oryctes/crb_observations_form.pdf CRB observations form (PDF)] | *[http://www.guaminsects.net/oryctes/crb_observations_form.pdf CRB observations form (PDF)] | ||
+ | *[http://www.guaminsects.net/oryctes/Dallas_data.pdf Additional trap data form (PDF)] | ||
*'''[http://www.guaminsects.net/oryctes/trap_routes.php Trap route control panel]''' | *'''[http://www.guaminsects.net/oryctes/trap_routes.php Trap route control panel]''' | ||
+ | **[http://guaminsects.net/oryctes/update_last_visit_field.php Update last_visit_field] | ||
**[http://guaminsects.net/oryctes/upload_site_visit_gpx_2.php Upload trap visit GPX file to database] | **[http://guaminsects.net/oryctes/upload_site_visit_gpx_2.php Upload trap visit GPX file to database] | ||
**[http://www.guaminsects.net/oryctes/last_trap_check.php Traps which have not been checked in the past 14 days] | **[http://www.guaminsects.net/oryctes/last_trap_check.php Traps which have not been checked in the past 14 days] |
Latest revision as of 04:05, 16 May 2009
These scripts intended for public access to the database
- View animated Google Earth display of all trap data
- Requires that the free Google Earth client is installed on your computer. This script downloads all trap catch data as a Google Earth data file (*.kml) file.
- Google Earth network link to project data EXPERIMENTAL
- Monthly trap catch graph and table - all traps
- Monthly trap catch graph and table - 28 PIC traps only - checked daily
- Monthly collection of CRB from sanitation/scouting
- Export trap data in NAPIS CSV format
These scripts are intended for trappers
- Access the project database, oryctes, using phpMyAdmin. Requires a user name and password.
- View trap data using Google Earth (by trap route) Requires that Google Earth is installed on your computer.
- View trap data using Google Earth (by date) Requires that Google Earth is installed on your computer.
- View traps which have caught one or more beetles using Google Earth. Requires that Google Earth is installed on your computer.
- CRB observations form (PDF)
- Additional trap data form (PDF)
- Trap route control panel
- Print a data form for trap deployment
- Open a spreadsheet for entering trap deployment data
- Check for errors in oryctes database
- Monthly trap catch
- Technical Notes