Changes between Version 38 and Version 39 of ippToPsps_Detections
- Timestamp:
- Jun 23, 2011, 10:02:57 AM (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
ippToPsps_Detections
v38 v39 29 29 || 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 || 30 30 || 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]|| 31 || filterID||unknown||TINYINT||0||filter identifier|| ||||31 || filterID||unknown||TINYINT||0||filter identifier|| smf primary header || Single character filter (grizy) is then used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] || 32 32 || cameraID||unknown||SMALLINT||0||camera identifier|| || || 33 33 || cameraConfigID||unknown||SMALLINT||0||camera configuration identifier|| || ||
