TABLE MapApertureIDshzqCompMap

Contains apertureID information for MAP hzqCompMap.

Variability via matched apertures for comparison
SELECTSTR v.uvistaID,v.ra,v.dec FROMSTR ultraVistaCatalogue as v,finalQsoCatalogue as f WHERESTR f.qsoID=162 and dbo.fGreatCircleDist(v.ra,v.dec,f.ra,f.dec)<1.5

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