| 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,k_3mfID as multiframeID,k_3eNum as extNum from gpsMergeLog where deprecated=0
union all
select frameSetID,h2_1mfID as multiframeID,h2_1eNum as extNum from gpsMergeLog where deprecated=0
union all
select frameSetID,h2_2mfID as multiframeID,h2_2eNum as extNum from gpsMergeLog where deprecated=0
union all
select frameSetID,h2_3mfID as multiframeID,h2_3eNum as extNum from gpsMergeLog where deprecated=0