IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changes between Version 59 and Version 60 of ippToPsps_Detections


Ignore:
Timestamp:
Jan 6, 2012, 3:13:43 PM (15 years ago)
Author:
rhenders
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • ippToPsps_Detections

    v59 v60  
    2828|| 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 ||
    2929|| 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 || 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|| smf primary header || Single character filter (grizy) is used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/init/tables.vot here] ||
     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/IN/tables.vot here]||
     31|| filterID||unknown||TINYINT||0||filter identifier|| smf primary header || Single character filter (grizy) is used to get PSPS ID from Filter table [browser:trunk/ippToPsps/config/IN/tables.vot here] ||
    3232|| cameraID||unknown||SMALLINT||0||camera identifier|| NA || hardcoded to 1 ||
    3333|| cameraConfigID||unknown||SMALLINT||0||camera configuration identifier|| NA ||hardcoded to 1 ||