Changes between Version 37 and Version 38 of ippToPsps_Detections

Timestamp:

Jun 23, 2011, 9:59:57 AM (15 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Detections

@@ -28 +28 @@
 || frameID||unknown||INT||0||unique exposure/frame identifier.|| GPC1 database || SELECT exp_id FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id ||
 || frameName||unknown||VARCHAR(32)|| ||frame name provided by camera software|| GPC1 database || SELECT exp_name FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id ||
-|| surveyID||unknown||TINYINT||0||survey flag identifier|| || ||
+|| surveyID||unknown||TINYINT||0||survey flag identifier|| GPC1 database || SELECT camRun.dist_group FROM camRun JOIN chipRun USING(chip_id) JOIN rawExp USING(exp_id) WHERE camRun.cam_id = cam_id. The IPP dist_group is then used to get the surveyID from the PSPS 'Survey' table [browser:trunk/ippToPsps/config/init/tables.vot here]||
 || filterID||unknown||TINYINT||0||filter identifier|| || ||
 || cameraID||unknown||SMALLINT||0||camera identifier|| || ||