Home | Browser | Access | Login | FreeSQL     VULCAN logo

Glossary of VULCAN attributes

This Glossary alphabetically lists all attributes used in the VULCANv20260525 database(s) held in the ASNIR. If you would like to have more information about the schema tables please use the VULCANv20260525 Schema Browser (other Browser versions).
A B C D E F G H I J K L M
N O P Q R S T U V W X Y Z

I

NameSchema TableDatabaseDescriptionTypeLengthUnitDefault ValueUnified Content Descriptor
iApFillFac StackObjectAttributes PS1DR2 Aperture fill factor from i filter stack detection. real 4   -999  
iApFlux StackObjectAttributes PS1DR2 Aperture flux from i filter stack detection. real 4 Janskys -999  
iApFluxErr StackObjectAttributes PS1DR2 Error in aperture flux from i filter stack detection. real 4 Janskys -999  
iApMag StackObjectThin PS1DR2 Aperture magnitude from i filter stack detection. real 4 AB magnitudes -999  
iApMagErr StackObjectThin PS1DR2 Error in aperture magnitude from i filter stack detection. real 4 AB magnitudes -999  
iApRadius StackObjectAttributes PS1DR2 Aperture radius for i filter stack detection. real 4 arcsec -999  
id twomass_xsc TWOMASS source ID number (unique within scan, coadd). int 4     meta.number
id_cat twomass_xsc TWOMASS matched galaxy's catalog name. varchar 20     NAME
id_flg twomass_xsc TWOMASS type/galaxy ID flag (0=non-catalog, 1=catalog, 2=LCSB). smallint 2     meta.code
idec StackObjectThin PS1DR2 Declination from i filter stack detection. float 8 degrees -999  
idecErr StackObjectThin PS1DR2 Declination error from i filter stack detection. real 4 arcsec -999  
iEpoch StackObjectThin PS1DR2 Modified Julian Date of the mean epoch of images contributing to the the i-band stack (equinox J2000). float 8 days -999  
iexpTime StackObjectAttributes PS1DR2 Exposure time of the i filter stack. Necessary for converting listed fluxes and magnitudes back to measured ADU counts. real 4 seconds -999  
iExtNSigma StackObjectAttributes PS1DR2 An extendedness measure for the i filter stack detection based on the deviation between PSF and Kron (1980) magnitudes, normalized by the PSF magnitude uncertainty. real 4   -999  
iFlags MeanObject PS1DR2 Information flag bitmask for mean object from i filter detections. Values listed in ObjectFilterFlags. int 4   0  
iinfoFlag StackObjectThin PS1DR2 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags. bigint 8   0  
iinfoFlag2 StackObjectThin PS1DR2 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags2. int 4   0  
iinfoFlag3 StackObjectThin PS1DR2 Information flag bitmask indicating details of the i filter stack photometry. Values listed in DetectionFlags3. int 4   0  
iippDetectID StackObjectAttributes, StackObjectThin PS1DR2 IPP internal detection identifier. bigint 8      
iKronFlux StackObjectAttributes PS1DR2 Kron (1980) flux from i filter stack detection. real 4 Janskys -999  
iKronFluxErr StackObjectAttributes PS1DR2 Error in Kron (1980) flux from i filter stack detection. real 4 Janskys -999  
iKronMag StackObjectThin PS1DR2 Kron (1980) magnitude from i filter stack detection. real 4 AB magnitudes -999  
iKronMagErr StackObjectThin PS1DR2 Error in Kron (1980) magnitude from i filter stack detection. real 4 AB magnitudes -999  
iKronRad StackObjectAttributes PS1DR2 Kron (1980) radius from i filter stack detection. real 4 arcsec -999  
im_nx twomass_xsc TWOMASS size of postage stamp image in pixels. smallint 2     instr.fov;instr.pixel
imageID Detection PS1DR2 Unique image identifier. Constructed as (100 * frameID + ccdID). bigint 8      
imagesLocation ExternalSurvey VULCANiDR Pathname to the pixels (eg. for matched-aperture remeasurement) varchar 256     ??
imageType allSkyNIRFrameSetInfo VULCANiDR Image type, pawprint, tile, mosaic varchar 8      
iMeanApMag MeanObject PS1DR2 Mean aperture magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanApMagErr MeanObject PS1DR2 Error in mean aperture magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanApMagNpt MeanObject PS1DR2 Number of measurements included in mean aperture magnitude from i filter detections. smallint 2   -999  
iMeanApMagStd MeanObject PS1DR2 Standard deviation of aperture magnitudes from i filter detections. real 4 AB magnitudes -999  
iMeanKronMag MeanObject PS1DR2 Mean Kron (1980) magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanKronMagErr MeanObject PS1DR2 Error in mean Kron (1980) magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanKronMagNpt MeanObject PS1DR2 Number of measurements included in mean Kron (1980) magnitude from i filter detections. smallint 2   -999  
iMeanKronMagStd MeanObject PS1DR2 Standard deviation of Kron (1980) magnitudes from i filter detections. real 4 AB magnitudes -999  
iMeanPSFMag MeanObject PS1DR2 Mean PSF magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanPSFMagErr MeanObject PS1DR2 Error in mean PSF magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanPSFMagMax MeanObject PS1DR2 Maximum PSF magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanPSFMagMin MeanObject PS1DR2 Minimum PSF magnitude from i filter detections. real 4 AB magnitudes -999  
iMeanPSFMagNpt MeanObject PS1DR2 Number of measurements included in mean PSF magnitude from i filter detections. smallint 2   -999  
iMeanPSFMagStd MeanObject PS1DR2 Standard deviation of PSF magnitudes from i filter detections. real 4 AB magnitudes -999  
imomentR1 StackObjectAttributes PS1DR2 First radial moment for i filter stack detection. real 4 arcsec -999  
imomentRH StackObjectAttributes PS1DR2 Half radial moment (r^0.5 weighting) for i filter stack detection. real 4 arcsec^0.5 -999  
imomentXX StackObjectAttributes PS1DR2 Second moment M_xx for i filter stack detection. real 4 arcsec^2 -999  
imomentXY StackObjectAttributes PS1DR2 Second moment M_xy for i filter stack detection. real 4 arcsec^2 -999  
imomentYY StackObjectAttributes PS1DR2 Second moment M_yy for i filter stack detection. real 4 arcsec^2 -999  
in_andromeda_survey gaia_source GAIADR3 Flag indicating that the source is present in the Gaia Andromeda Photometric Survey (GAPS) tinyint 1     meta.code.status
infoFlag Detection PS1DR2 Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags. bigint 8   0  
infoFlag2 Detection PS1DR2 Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags2. int 4   0  
infoFlag3 Detection PS1DR2 Information flag bitmask indicating details of the photometry. Values listed in DetectionFlags3. int 4   0  
inFrames StackObjectThin PS1DR2 Number of input frames/exposures contributing to the i filter stack detection. int 4   -999  
ipd_frac_multi_peak gaia_source GAIADR3 Percentage of successful IPD windows with more than one peak tinyint 1     stat.value
ipd_frac_odd_win gaia_source GAIADR3 Percentage of transits with truncated windows or multiple gate tinyint 1     stat.value
ipd_gof_harmonic_amplitude gaia_source GAIADR3 Amplitude of the IPD GoF versus position angle of the scan real 4     stat.value
ipd_gof_harmonic_phase gaia_source GAIADR3 Phase of the IPD GoF versus position angle of the scan real 4 degrees   pos.posAng;stat.value
iPlateScale StackObjectAttributes PS1DR2 Local plate scale for the i filter stack. real 4 arcsec/pixel 0  
ippDetectID Detection PS1DR2 IPP internal detection identifier. bigint 8      
ippObjID Detection, StackObjectAttributes, StackObjectThin PS1DR2 IPP internal object identifier. bigint 8      
ippObjID ObjectThin PS1DR2 IPP internal object identifier. bigint 8     meta.id
ipsfChiSq StackObjectAttributes PS1DR2 Reduced chi squared value of the PSF model fit for i filter stack detection. real 4   -999  
ipsfCore StackObjectAttributes PS1DR2 PSF core parameter k from i filter stack detection, where F = F0 / (1 + k r^2 + r^3.33). real 4   -999  
iPSFFlux StackObjectAttributes PS1DR2 PSF flux from i filter stack detection. real 4 Janskys -999  
iPSFFluxErr StackObjectAttributes PS1DR2 Error in PSF flux from i filter stack detection. real 4 Janskys -999  
ipsfLikelihood StackObjectAttributes PS1DR2 Likelihood that this i filter stack detection is best fit by a PSF. real 4   -999  
iPSFMag StackObjectThin PS1DR2 PSF magnitude from i filter stack detection. real 4 AB magnitudes -999  
iPSFMagErr StackObjectThin PS1DR2 Error in PSF magnitude from i filter stack detection. real 4 AB magnitudes -999  
ipsfMajorFWHM StackObjectAttributes PS1DR2 PSF major axis FWHM from i filter stack detection. real 4 arcsec -999  
ipsfMinorFWHM StackObjectAttributes PS1DR2 PSF minor axis FWHM from i filter stack detection. real 4 arcsec -999  
ipsfQf StackObjectAttributes PS1DR2 PSF coverage factor for i filter stack detection. real 4   -999  
ipsfQfPerfect StackObjectAttributes PS1DR2 PSF-weighted fraction of pixels totally unmasked for i filter stack detection. real 4   -999  
ipsfTheta StackObjectAttributes PS1DR2 PSF major axis orientation from i filter stack detection. real 4 degrees -999  
iQfPerfect MeanObject PS1DR2 Maximum PSF weighted fraction of pixels totally unmasked from i filter detections. real 4   -999  
ira StackObjectThin PS1DR2 Right ascension from i filter stack detection. float 8 degrees -999  
iraErr StackObjectThin PS1DR2 Right ascension error from i filter stack detection. real 4 arcsec -999  
isComplete AstrometricInfo VULCANiDR Level of completeness: 0 not complete 1; halfspace calculation complete; tinyint 1   0 meta.code.qual
isky StackObjectAttributes PS1DR2 Residual background sky level at the i filter stack detection. real 4 Janskys/arcsec^2 -999  
iskyErr StackObjectAttributes PS1DR2 Error in residual background sky level at the i filter stack detection. real 4 Janskys/arcsec^2 -999  
isSectioned Filter VULCANiDR Is the focal plane sectioned into different filters, 0 No, 1 Yes. If so, data for each section in FilterSections and SectionDetectors tinyint 1   0  
isSynoptic RequiredFilters VULCANiDR is the band observed multiple times for variability measurements (0 FALSE, 1 TRUE) tinyint 1   0  
istackDetectID StackObjectAttributes, StackObjectThin PS1DR2 Unique stack detection identifier. bigint 8      
istackImageID StackObjectAttributes, StackObjectThin PS1DR2 Unique stack identifier for i filter detection. bigint 8      
isVar allSkyNIRSource VULCANiDR Is it classified as variable in a variability table smallint 2   -9999  
isVista allSkyNIRSource VULCANiDR Is source from VISTA (1) telescope or WFCAM (0) tinyint 1   0  
ixPos StackObjectAttributes PS1DR2 PSF x center location from i filter stack detection. real 4 sky pixels -999  
ixPosErr StackObjectAttributes PS1DR2 Error in PSF x center location from i filter stack detection. real 4 sky pixels -999  
iyPos StackObjectAttributes PS1DR2 PSF y center location from i filter stack detection. real 4 sky pixels -999  
iyPosErr StackObjectAttributes PS1DR2 Error in PSF y center location from i filter stack detection. real 4 sky pixels -999  
izp StackObjectAttributes PS1DR2 Photometric zeropoint for the i filter stack. Necessary for converting listed fluxes and magnitudes back to measured ADU counts. real 4 magnitudes 0  


Home | Overview | Browser | Access | Login |
FreeSQL
Links | Credits

WFAU, Institute for Astronomy,
Royal Observatory, Blackford Hill
Edinburgh, EH9 3HJ, UK

vsa-support@roe.ac.uk
25/05/2026