TABLE MapApertureIDsvikingZY_selJ

Contains apertureID information for MAP vikingZY_selJ.

VIKING J-band selected data for SJW where there are Z and Y frames.
The query used to select the data is:

SELECT s.sourceID,s.ra,s.dec FROM vikingSource as s,vikingMergeLog as l WHERE l.frameSetID=s.frameSetID AND l.zmfID>0 AND l.ymfID>0 AND s.jAperMag3>0. AND (s.priOrSec=0 OR s.priOrSec=s.frameSetID)

Required constraints:
Primary key is (apertureID)
(mapID,mapTableID) references MapSurveyTables(mapID,mapTableID)

Name Type Length Unit Description Default Value Unified Content Descriptor

apertureID bigint 8 UID of aperture unique over the MAP meta.id;meta.main

cuEventID int 4 UID of curation event giving rise to this record meta.bib

ra float 8 degrees Right Ascension of field centre pos.eq.ra;meta.main

dec float 8 degrees Declination of field centre pos.eq.dec;meta.main

mapID int 4 UID of matched-aperture product meta_id

mapTableID int 4 The UID of the survey, table information in MapSurveyTables

objectID bigint 8 The UID of the object within this survey programme table

Total length 44

Name	Type	Length	Unit	Description	Unified Content Descriptor
apertureID	bigint	8		UID of aperture unique over the MAP	meta.id;meta.main
cuEventID	int	4		UID of curation event giving rise to this record	meta.bib
ra	float	8	degrees	Right Ascension of field centre	pos.eq.ra;meta.main
dec	float	8	degrees	Declination of field centre	pos.eq.dec;meta.main
mapID	int	4		UID of matched-aperture product	meta_id
mapTableID	int	4		The UID of the survey, table information in MapSurveyTables
objectID	bigint	8		The UID of the object within this survey programme table
Total length		44