TABLE MapApertureIDslasYselJ

Contains apertureID information for MAP lasYselJ.

Forced photometry on LAS where there is a J detection and Y measurement
SELECTSTR s.sourceID,s.ra,s.dec FROMSTR lasSource as s,lasMergeLog as l WHERESTR l.frameSetID=s.frameSetID 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