Difference between revisions of "E-Ecology GPS Bird Track Generator"

From ecology
Jump to: navigation, search
m
Line 2: Line 2:
  
 
!!!Under Construction (04-05-09)!!!
 
!!!Under Construction (04-05-09)!!!
 +
 
One of the data types available in the FlySafe database is GPS tracks. These are produced by attaching small GPS tracking sensors to birds, which track the bird movements throughout the year.
 
One of the data types available in the FlySafe database is GPS tracks. These are produced by attaching small GPS tracking sensors to birds, which track the bird movements throughout the year.
 
The data is subsequently collected by the Argos satellite system, and made available in the FlySafe Database. The data itself is geo-referenced, and as such it makes sense to provide a service that allows you to look at the data in a GIS-system. The GIS system of choice is Google Earth, and therefor the output of the service is a KML file. This KML file can be loaded into Google Earth, but many other GIS-systems also provide KML reading capabilities.
 
The data is subsequently collected by the Argos satellite system, and made available in the FlySafe Database. The data itself is geo-referenced, and as such it makes sense to provide a service that allows you to look at the data in a GIS-system. The GIS system of choice is Google Earth, and therefor the output of the service is a KML file. This KML file can be loaded into Google Earth, but many other GIS-systems also provide KML reading capabilities.
  
The service itself can be found at the [https://services.flysafe.sara.nl/ Flysafe website], or with a direct link to the [https://services.flysafe.sara.nl:/gpstrackingext.html GPS service]. Both do require special access: You need to have credentials and your IP address should be in the allowed list.
+
The service itself can be found at the [https://services.flysafe.sara.nl/ Flysafe website], or with a direct link to the [https://services.flysafe.sara.nl:/gpstrackingext.html GPS service]. Both do require special access: You need to have credentials and your IP address should be registered.
 +
 
 
=== The Interface ===
 
=== The Interface ===
 
-Insert screenshot here (cannot upload currently)
 
-Insert screenshot here (cannot upload currently)
 +
 +
The data
  
  
Line 16: Line 20:
  
  
=== Output ===
+
=== Underlying Query and Data ===
  
The output comes in form of a KMZ file that contains all selected birds, each in a seperated folder.
+
{|border="1" cellspacing="0" cellpadding="5" align="center"
 
+
'SELECT g.ptt_id, i.species, g.date_time, g.latitude, g.longitude, '
=== Underlying Query and Data ===
+
'g.speed, g.course, g.altitude, g.alt_status, g.quality, g.user_qc, '
 +
'g.parser_qc, g."location", elevation.srtm_getvalue(g."location") AS '
 +
'elevation, case when g.altitude = 0 then NULL else '
 +
'(g.altitude - elevation.srtm_getvalue(g."location")) end AS agl '
 +
'FROM gps.gps_tracking_data g, gps.individual i, gps.track_session t '
 +
'WHERE g.ptt_id = t.ptt_id AND g.date_time >= t.start_date AND '
 +
'i.ring_number = t.ring_number AND g.parser_qc = 1 AND g.ptt_id = '+ptt_id+
 +
'AND g.date_time >= \''+startTime+'\' AND g.date_time <= \''+endTime+'\' '
 +
'AND g.latitude <> 0 ORDER BY g.date_time '|}

Revision as of 12:06, 4 May 2009

The FlySafe GPS bird tracks service

!!!Under Construction (04-05-09)!!!

One of the data types available in the FlySafe database is GPS tracks. These are produced by attaching small GPS tracking sensors to birds, which track the bird movements throughout the year. The data is subsequently collected by the Argos satellite system, and made available in the FlySafe Database. The data itself is geo-referenced, and as such it makes sense to provide a service that allows you to look at the data in a GIS-system. The GIS system of choice is Google Earth, and therefor the output of the service is a KML file. This KML file can be loaded into Google Earth, but many other GIS-systems also provide KML reading capabilities.

The service itself can be found at the Flysafe website, or with a direct link to the GPS service. Both do require special access: You need to have credentials and your IP address should be registered.

The Interface

-Insert screenshot here (cannot upload currently)

The data


Visualization

There are several option for the visualization of the bird measurements:

  • Color


Underlying Query and Data

'SELECT g.ptt_id, i.species, g.date_time, g.latitude, g.longitude, ' 'g.speed, g.course, g.altitude, g.alt_status, g.quality, g.user_qc, ' 'g.parser_qc, g."location", elevation.srtm_getvalue(g."location") AS ' 'elevation, case when g.altitude = 0 then NULL else ' '(g.altitude - elevation.srtm_getvalue(g."location")) end AS agl ' 'FROM gps.gps_tracking_data g, gps.individual i, gps.track_session t ' 'WHERE g.ptt_id = t.ptt_id AND g.date_time >= t.start_date AND ' 'i.ring_number = t.ring_number AND g.parser_qc = 1 AND g.ptt_id = '+ptt_id+ 'AND g.date_time >= \+startTime+'\' AND g.date_time <= \+endTime+'\' ' 'AND g.latitude <> 0 ORDER BY g.date_time '|}