Reports

Part 1:  View Data as a Table

  1. After you have collected data on a handheld computer, you can view it in Reports.  Open CyberTracker under Start - Programs - CyberTracker Software - CyberTracker 3.0 - CyberTracker Standard.  Click on Open Database and select your database, or on Open Sample Database to view an example.

  2. Reports:  If the pull-down menu says Sequences, click on it and change to Reports.  To create a new report or rename your report, click on the Manage Reports button and follow the instructions.

  3. View Individual Sightings (Records):  The Query Editor window will be open.  A query is a subset of all the data collected, shown as a table.   Open the Inspector tab by clicking on the “+” to view individual sightings (records).  Each sighting (record) consists of an individual entry, including all the information entered when the user captured the data point.  Scroll through the records to view each one.

  4. Date Range:  You may not want to work with all the data in your database for a report, only the data for a limited date range.  Select the date range by clicking on “All” in the space next to “Date Range” to view the drop-down menu of options. Selecting “Custom” allows you to select “Date from:” and “Date to:”.

  5. Table:  To add columns to the Query Editor Table, double-click on a field within a record, like “Name,” or drag and drop it into the large blank space to the right.  You can also click on the View Properties button, then click Add.  You can create a column that shows all the records that contain one of the Elements within a Screen by selecting the Screen or create a column that shows only one Element by selecting that Element . To re-arrange the order of the columns, click on the name of the column, then drag it left or right until the green arrows appear where you want to move the column. To delete a column, click on the name of the column and drag it up or down until a large cross appears.

  6. Filter You can filter the data by clicking on the black arrow beside the column name.  Selecting [Non Blanks] will show only those records that have an entry for the Screen or Element designated by the column.  Selecting [Custom] allows you to specify a range of values to show.  When a column has been filtered, the black arrow will turn blue. Advanced Table Filter: In CyberTracker Professional, the Advanced button on the upper-right hand corner of a Table is a shortcut, the advanced query editor allows queries involving more complex logic and bracketing.

  7. Sort:   You can sort the data alphabetically (or numerically) by clicking on the name of the column.  Click on the column again to reverse the order.

Part 2:  Viewing Data as a Map

  1. Map File:  You can use any bitmap, JPEG, or TIFF image files for maps.  You must know the latitude and longitude coordinates of the four corners of the map image.  Additional file types such as ArcView Shapefile maps can be used in CyberTracker Professional.

  2. Create Map:   Click on the New View button, and select Map.  With the map open, click on the View Properties button, which opens the Map Settings window.  Click on the ellipsis [...] to locate the image you want to use and select it. 

  3. Latitude and Longitude:    Enter the leftmost longitude, topmost latitude, rightmost longitude, and bottommost latitude of the map image as decimal degrees.  Enter South latitudes and West longitudes as negative numbers, for example, 32.3263 degrees South is entered as -32.3263.

  4. Show Queries:   If you have already created queries in the current Report, they will be displayed under the Legend, and the records from the table will appear as colored dots on the map.  By default, Query 1 appears and shows all records.  The same Query Editor used for viewing data as a table is used for creating the points to display on a map. 

  5. Example:   For example, if you wanted to have one color dot represent all sightings of Foxes, you would click on Query Editor, then the New Query button.  Under Properties, name the query Fox.  Click on the View Properties button, then Add, and select the Element named Fox.  Click OK to exit the Active Query Table Settings window.  Under the Fox column in the table, click on the black arrow by the name and choose [NonBlanks] to show only those records that contain Fox.

  6. Overlapping Points:  If two data points were recorded at the same location, the points will overlap.  The query that is at the leftmost tab in the Query Editor will show on the map as the bottommost dots.  You can drag the query tabs left or right to re-order them.

Advanced Map Settings

In the Professional Version, there are advanced settings for mapping your data.  These settings are found under the Reports view.  Click the New View button, choose Map, and then with your map open click the View Properties button.  Note that CyberTracker can’t be closed while the View Properties window is still open.  The properties are explained below:

General Tab

Name: The name of the Map View
Description: An arbitrary description of the Map View
Background color: The background colour will show in areas not covered by Shapefile polygons added in the Layers tab, or will show through if the Layers Pattern is not Solid. The background colour will also show through when a transparency setting is selected in the Image tab.
Show timer tracks:  CyberTracker automatically takes a GPS Timer reading, depending on the Timer Interval selected on the GPS Timer Setup Screen while running.  Check this box if you would like the map to show the path created by these points.
Timer track accuracy threshold: The GPS gives us a number indicating how accurate it thinks its reading is. This number ranges from 1 to 50 – 1 being the most accurate, 50 being the least accurate. The reading depends on both satellite geometry and obstruction. A clear view of the skies yields a lower reading. If you want to eliminate very inaccurate readings, then you should set this threshold value to eliminate low accuracy readings from path drawing.
Scale units: Scale units shown on a Map view, in Meter, Kilometer, Foot or Nautical Mile.

Projection Tab

Datum: When GPS does its calculations, several factors in the equation relate to the shape of the earth. Since the earth is not a perfect sphere, we approximate its shape. There are several different approximations available… the most common being WGS ’84. However some areas benefit from different using a datum that is more locally accurate.
Projection: Since the earth is not flat, anytime we represent it on a map, it has undergone a projection. Since projection loses information, there is no projection that is appropriate for every part of the earth. Therefore different countries and regions have adopted different projection systems to best represent their local area.

CyberTracker supports all the most common datum and projection systems available. If you get a map from somewhere, you should also be able to get hold of its associated projection parameters. Fill these in on the Projection tab.

Image Tab

Transparency: The background colour will show through when a transparency setting is selected in the Image tab.
Latitude and Longitude:  Enter the leftmost longitude, topmost latitude, rightmost longitude, and bottommost latitude of the map image as Decimal Degrees.  Enter South latitudes and West longitudes as negative numbers, for example, 32.3263 degrees South is entered as -32.3263.

Layers Tab

Visible: Determines whether the layer is visible on the map or not.  You can also change this on the map itself by checking or un-checking the box next to the layer in the right hand column.
File: Shows the source path of the file.  Change the file by clicking on the space below file and clicking on the ellipsis.
Name: You can rename the layer by clicking on the space below Name and typing.
Symbol: After inserting a layer, click on the space below Symbol and then on the arrow to change the appearance of the layer.

Part 3:  Edit Data

  1. Edit Data in Query Editor: If you made a mistaken entry in the field, numerical values can be changed in the Query Editor Inspector or Table. In the Inspector, click on the value to edit it. In the Table, click on a cell twice to edit the number.   

  2. To Delete Data:  To delete data, select a single sighting in the Inspector or in the Table, or use the Shift key + up or down arrow to select several sightings. Use the Delete Sightings button in the Tool bar to delete the selected sightings. If you have accidentally deleted sightings, select Edit, Undo to retrieve the deleted sightings. As long as you have not Saved the database, you can use the Undo feature to retrieve all deleted data. However, once you have Saved the database, you can no longer retrieve deleted data.  More advanced editing can be done in CyberTracker Professional.

Part 4:  Add Photo to Sighting

  1. Open the Professional version of CyberTracker

  2. In Elements, create a New Category and name it “Photos”.

  3. Within this Photos category, create a New Element and name it “Photo”.

  4. Go to Reports and select the sighting to which you want to add a photo.

  5. Select the drop-down menu Edit, Edit Sighting

  6. In the Edit Sighting window, click on Add button

  7. Open the Photos folder and select the Photo Element

  8. In the Type column, click on the drop-down arrow and select Graphic

  9. In the Value column, click on the ellipsis button […] and find the photo you want to add.

  10. Click OK. The photo will appear in the Inspector of the Query Editor and the map view.

To view the photo, click on the photo and then click on the down arrow to enlarge the photo.

Part 5:  Export Data

Note:   Export as an ArcView Shapefile or other file formats using CyberTracker Professional.

  1. Export Data as a Table:  For further analysis and to print the table, it can be exported as an Excel Spreadsheet.  Make sure your table is selected by clicking on it, and click on the Export button.  Give your table a name and save as an Excel Spreadsheet.

  2. Export Map as an Image:  Maps can be exported as Bitmap or JPEG images. Make sure your map is selected by clicking on it, and click on the Export button.  Give your map a name and save as an Bitmap or JPEG.

  3. Export Databases, Data and Reports as CTX Files:  CyberTracker users can share data by exporting and importing data and reports as CTX files.  CTX stands for "CyberTracker Export" and it is the extension given to files that CyberTracker uses to share data.  A CTX file contains all the same information as a database, but is compressed and optimized for backups or sending to others via email.  Within your database, click on File, Export... You can specify the date range of data you wish to send, in case you don't want to send all data at once.  See note below on Element ID numbers before importing.

  4. Import Databases and Data as CTX Files:  To import a database, create a New Database, and within that database, click File, Import... and select your CTX file.  You can merge data from another database by opening up a database and clicking File, Import... and selecting the CTX file.  Note:  Each Element has an hidden ID number attached to it.  If two databases merge, and two Elements have the same ID, the name of the Element from the imported file overwrites the name from the original database.  If you exported to someone else a Screen Sequence that contained an Animals screen with the Element “Horse,” and that person changed Horse to Deer, gathered data, and then exported their database back to you, all your records containing Horse would be changed to Deer.  Very rarely, this can happen with two independently created Screen Sequences, because Element ID’s are randomly generated numbers.  If merging databases, it is safest to export both databases into a new third database, so that old data can be preserved.

TOP