VIEW  gpsFrameSets

View of all frame sets defined for the UKIDSS GPS

This view is simply a union of all frame set / multiframe combinations
from the GPS merge log. This provides a direct link between a given frame
set and it's constituent multiframes and detector frames in a single
queryable object. View allFrameSets provides a view of all archived sets.


SELECT frameSetID,jmfID AS multiframeID,jeNum AS extNum
FROM gpsMergeLog
WHERE deprecated=0
UNION ALL
SELECT frameSetID,hmfID AS multiframeID,heNum AS extNum
FROM gpsMergeLog
WHERE deprecated=0
UNION ALL
SELECT frameSetID,k_1mfID AS multiframeID,k_1eNum AS extNum
FROM gpsMergeLog
WHERE deprecated=0
UNION ALL
SELECT frameSetID,k_2mfID AS multiframeID,k_2eNum AS extNum
FROM gpsMergeLog
WHERE deprecated=0
UNION ALL
SELECT frameSetID,h2mfID AS multiframeID,h2eNum AS extNum
FROM gpsMergeLog
WHERE deprecated=0

The details of the table defined by this view are available here.