RADAR - Revision history

Stacy shinneman: /* Introduction */

2018-02-22T10:23:58Z

‎Introduction

Stacy shinneman: /* Description of tables in RADAR schema in FlySafe database */

2018-02-20T14:39:01Z

‎Description of tables in RADAR schema in FlySafe database

Stacy shinneman: /* Introduction */

2018-02-20T14:38:37Z

‎Introduction

Stacy shinneman: /* Description of tables in RADAR schema in Flysafe database */

2018-02-20T14:38:25Z

‎Description of tables in RADAR schema in Flysafe database

Bart: /* Quality parameters */

2008-05-09T14:26:16Z

‎Quality parameters

Bart: /* SUBWINDOW_RESULT */

2008-05-09T12:26:18Z

‎SUBWINDOW_RESULT

Bart: /* SUBWINDOW_RESULT */

2008-05-09T12:22:43Z

‎SUBWINDOW_RESULT

Bart: /* Description of tables in RADAR scheme in Flysafe database */

2008-05-09T12:01:54Z

‎Description of tables in RADAR scheme in Flysafe database

Bart: /* SUBWINDOW_RESULT */

2008-05-09T09:52:46Z

‎SUBWINDOW_RESULT

Bart: /* SUBWINDOW_RESULT */

2008-05-09T09:52:05Z

‎SUBWINDOW_RESULT

@@ Line 8: / Line 8: @@
 Radar data are one of the most important measurements in Bird Avoidance System (BAS) and FlySafe project. Until now data are archived in structured files instead of in a database. In this document data model for Motion Analysis images of the ROBIN4 system is designed, based on file structure of ROBIN4-MA images as defined in High Level Design Document of ROBIN4 (HLDD, TNO 2006).
 MA (Motion Analysis) images are summated images of ten radar antenna rotations and are recorded twice per hour, two radar beams per radar, 3 radars in total (equalling 12 images per hour).
-The data comprise all recorded radar echoes with summated intensities, plus rain clutter masks, land clutter masks and all separate objects of all recognised tracks. The huge amount of data per image (360°, 150km range, 10Mb) require a flexible database. Numbers of tracks can be as high as 15.000 tracks per image, with a mean about 1000 tracks. Per day we collect 48 images * 2 beams * 10Mb * 3 radars equipped with Robin  3Gb data.
+The data comprise all recorded radar echoes with summated intensities, plus rain clutter masks, land clutter masks and all separate objects of all recognised tracks. The huge amount of data per image (360°, 150km range, 10Mb) require a flexible database. Numbers of tracks can be as high as 15.000 tracks per image, with a mean about 1000 tracks. Per day we collect 48 images * 2 beams * 10Mb * 3 radars equipped with Robin 3Gb data.
-Because the database must be readily and speedily accessible, only aggregated data can be recorded in the database. Original data will have to be recorded in a file system. The level of aggregation is still under debate, as the database should also allow a certain level of reanalysis. It is not desirable to store all original recorded echoes and raw radar data, which are the bulk of the data, in the database. Because the number of tracks is rather low ( 1000) for most of the images, it may be sufficient to store summaries of each track. This will lead to an estimated data reduction of 90%.
+Because the database must be readily and speedily accessible, only aggregated data can be recorded in the database. Original data will have to be recorded in a file system. The level of aggregation is still under debate, as the database should also allow a certain level of reanalysis. It is not desirable to store all original recorded echoes and raw radar data, which are the bulk of the data, in the database. Because the number of tracks is rather low (1000) for most of the images, it may be sufficient to store summaries of each track. This will lead to an estimated data reduction of 90%.
 In the near future, already during precursor phase of FlySafe project, bird echo tracks will be recorded continuously. This means that if we want to store individual tracks, also positions of each antenna rotation is stored and database could be increasing much faster than it does now.

← Older revision		Revision as of 14:39, 20 February 2018
Line 1:		Line 1:
−	=== Description of tables in RADAR schema in ~~FlySafe~~ database ===	+	=== Description of tables in RADAR schema in e-Ecology database ===

	Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar		Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar

@@ Line 6: / Line 6: @@
 =Introduction=
-Radar data are one of the most important measurements in Bird Avoidance System (BAS) and Fly Safe project. Until now data are archived in structured files instead of in a database. In this document data model for Motion Analysis images of the ROBIN4 system is designed, based on file structure of ROBIN4-MA images as defined in High Level Design Document of ROBIN4 (HLDD, TNO 2006).
+Radar data are one of the most important measurements in Bird Avoidance System (BAS) and FlySafe project. Until now data are archived in structured files instead of in a database. In this document data model for Motion Analysis images of the ROBIN4 system is designed, based on file structure of ROBIN4-MA images as defined in High Level Design Document of ROBIN4 (HLDD, TNO 2006).
 MA (Motion Analysis) images are summated images of ten radar antenna rotations and are recorded twice per hour, two radar beams per radar, 3 radars in total (equalling 12 images per hour).
 The data comprise all recorded radar echoes with summated intensities, plus rain clutter masks, land clutter masks and all separate objects of all recognised tracks. The huge amount of data per image (360°, 150km range, 10Mb) require a flexible database. Numbers of tracks can be as high as 15.000 tracks per image, with a mean about 1000 tracks. Per day we collect 48 images * 2 beams * 10Mb * 3 radars equipped with Robin  3Gb data.
 Because the database must be readily and speedily accessible, only aggregated data can be recorded in the database. Original data will have to be recorded in a file system. The level of aggregation is still under debate, as the database should also allow a certain level of reanalysis. It is not desirable to store all original recorded echoes and raw radar data, which are the bulk of the data, in the database. Because the number of tracks is rather low ( 1000) for most of the images, it may be sufficient to store summaries of each track. This will lead to an estimated data reduction of 90%.
 In the near future, already during precursor phase of FlySafe project, bird echo tracks will be recorded continuously. This means that if we want to store individual tracks, also positions of each antenna rotation is stored and database could be increasing much faster than it does now.
 =Data model for MA images collected by ROBIN4 system .=

← Older revision		Revision as of 14:38, 20 February 2018
Line 1:		Line 1:
−	=== Description of tables in RADAR schema in ~~Flysafe~~ database ===	+	=== Description of tables in RADAR schema in FlySafe database ===

	Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar		Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar

@@ Line 319: / Line 319: @@
 |OBJECT_PHI||Array of phi coordinate of object
 |}
 [[ Image : Radar_datamodel.png ]]

@@ Line 217: / Line 217: @@
 |'''IMAGE_REQUEST_ID'''||Reference to IMAGE_REQUEST_ID of table IMAGE_REQUEST
 |-
-|''IMAGE_RESULT_ID'''||Reference to IMAGE_RESULT_ID of table IMAGE_RESULT
+|'''IMAGE_RESULT_ID'''||Reference to IMAGE_RESULT_ID of table IMAGE_RESULT
 |-
 |'''SUBWINDOW_ID'''||Reference to SUBWINDOW_ID of table SUBWINDOW
@@ Line 272: / Line 272: @@
 In addition the mean speed is also calculated as vector with the results in rho and phi in
 MEAN_SPEED_VECTOR_RHO and MEAN_SPEED_VECTOR_PHI.
 ==TRACK_RESULT==

@@ Line 259: / Line 259: @@
 |ROBIN_CORRECTED_QUALITY||Quality parameter associated with the ROBIN_CORRECTED_DENSITY
 |}
 ==TRACK_RESULT==

← Older revision		Revision as of 12:01, 9 May 2008
Line 1:		Line 1:
−	=== Description of tables in RADAR ~~scheme~~ in Flysafe database ===	+	=== Description of tables in RADAR schema in Flysafe database ===

	Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar		Data model for Motion Analyses images collected with ROBIN-system for the Medium Power Radar

@@ Line 208: / Line 208: @@
 ==SUBWINDOW_RESULT==
-The SUBWINDOW_RESULT table contains values for all the subwindows and for each image_result and contains some computed values where the most notable is the ROBIN_CORRECTED_DENSITY which is a measure of the bird density that can be used for warnings such as the [[birdtam.html BirdTam]]
+The SUBWINDOW_RESULT table contains values for all the subwindows and for each image_result and contains some computed values where the most notable is the ROBIN_CORRECTED_DENSITY which is a measure of the bird density that can be used for warnings such as the [https://flysafe-pps.grid.sara.nl/birdtam.html BirdTam]
 {|border=1