Changes between Version 35 and Version 36 of ippToPsps_Detections

Timestamp:

Jun 23, 2011, 9:52:22 AM (15 years ago)

Author:

rhenders

Comment:

--

ippToPsps_Detections

@@ -22 +22 @@
 = Current IPP to PSPS mappings =
 
-The following table details the current mapping between IPP and PSPS.
+The following table details the current mapping between IPP and PSPS. The source of smf files queued by ippToPsps is a list of  cam_ids that are loaded into the relevant DVO database. These cam_ids are then used to obtain metadata from the IPP GPC1 database, as well as the location of the smf itself.
 
 || '''!FrameMeta''' ||||||||||||||
 || '''ODM attribute''' || '''units''' || '''Data type''' || '''Default''' || '''Description''' || '''IPP source''' || '''IPP variable/notes''' ||
-|| frameID||unknown||INT||0||unique exposure/frame identifier.|| || ||
+|| frameID||unknown||INT||0||unique exposure/frame identifier.|| GPC1 database || SELECT exp_id, exp_name, camRun.dist_group 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|| || ||
 || surveyID||unknown||TINYINT||0||survey flag identifier|| || ||