MACHO TAP ivo://nci.org.au/macho/tap National Computational Infrastructure NCI ASVO NCI ASVO asvo@nci.org.au MACHO MACHO TAP service http://macho.anu.edu.au http://machotap.asvo.nci.org.au/ncitap//tap/capabilities GET application/xml http://machotap.asvo.nci.org.au/ncitap//tap/availability GET application/xml http://machotap.asvo.nci.org.au/ncitap//tap/tables GET application/xml http://machotap.asvo.nci.org.au/ncitap//tap GET application/xml ObsCore 1.0 ADQL 2.0 ADQL 2.0 text/xml votable 86400 86400 86400 86400 1000000 public public.fieldtile_view fieldid Field ID of field which overlaps given tile meta.id:meta.main integer tileid Tile ID of tile overlapped by given field meta.id:meta.main integer public.field_view fieldid Field ID number meta.id:meta.main integer rarad Field centre ra coord (radians) rad pos.eq.ra;meta.main double precision decrad Field centre dec coord (radians) rad pos.eq.dec;meta.main double precision templateobs Observation number of template image for this field integer fieldregion Sky region covered by this field (box, radians) rad box public.observation_view obsid Observation ID number meta.id:meta.main integer rarad Telescope Pointing Right Acension coordinate, J2000 (radians) rad pos.eq.ra;meta.main double precision decrad Telescope Pointing Declination coordinate, J2000 (radians) rad pos.eq.dec;meta.main double precision timeobs Observation time (hh:mm:ss) gmt time.epoch time without time zone dateobs Observation date (GMT) GMT time.epoch date expstart Observation exposure start time (MJD) mjd time.epoch double precision expend Observation exposure end time (MJD) mjd time.epoch double precision field MACHO field number of which this is an observation obs.field integer tnofield Field number where this is a TNO observation integer domain Macho project Domain Identification code, one of: LMC (Large Magellanic Cloud), SMC(Small Magellanic Cloud), Bulge-1, Bulge-2, Bulge-3 (Galactic Bulge regions 1 to 3) obs.field character varying(10) pointra Telescope Pointing Right Acension coordinate, J2000 (Hours:Minutes:Seconds) hms pos.eq.ra character(20) pointdec Telescope Pointing Declination coordinate, J2000 (Degrees:Minutes:Seconds) hms pos.eq.dec character(20) fov Telescope full Field-of-View bounded region, coordinates of opposite corners, J2000 (radians) rad pos.eq box pier Position of telescope camera relative to supporting pier, East(E) or West(W) instr.setup character(1) exposure Observation exposure duration (seconds) sec time.expo double precision airmass Mass column of atmosphere along sightline relative to mass of air column at zenith obs.air.mass double precision parallac Angle between hour circle and vertical, measured North through East (radians) rad pos.parallax double precision tnoseered TNO project Red filter seeing measurement(pixels) pix instr.obsty.site.seeing double precision tnoseeblue TNO project Blue filter seeing measurement(pixels) pix instr.obsty.site.seeing double precision tnoskyred TNO project Red filter sky measurement (ADU) ct phot.sb double precision tnoskyblue TNO project Blue filter sky measurement (ADU) ct phot.sb double precision templateid Observation Id of image used as template for photomtery reduction meta.id;obs integer public.photometry_radec_view fieldid integer tileid integer seqn integer obsid integer rarad double precision decrad double precision dateobs double precision sideofpier character(1) exposure double precision airmass double precision rmag double precision rerr double precision rnormsky double precision rtype double precision rcrowd double precision rchi2 double precision rmpix double precision rcosmicrf double precision ramp double precision rxpix double precision rypix double precision ravesky double precision rfwhm double precision rtobs integer rcut integer bmag double precision berr double precision bnormsky double precision btype double precision bcrowd double precision bchi2 double precision bmpix double precision bcosmicrf double precision bamp double precision bxpix double precision bypix double precision bavesky double precision bfwhm double precision btobs integer bcut integer public.photometry_view fieldid Star field number meta.id:meta.main integer tileid Star tile number meta.id:meta.main integer seqn Star sequence number meta.id:meta.main integer obsid Star observation id meta.id:meta.main integer dateobs Photometry observation date (Modified Julian Date: MJD = JD - 2400000.5) MJD double precision sideofpier Position of telescope camera relative to supporting pier, East(E) or West(W) instr.setup character(1) exposure Observation exposure time (secs) sec double precision airmass Mass column of atmosphere along sightline relative to mass of air column at zenith obs.air.mass double precision rmag Red instrumental magnitude double precision rerr Red instrumental magnitude 1-sigma error stat.mean double precision rnormsky Red normalised sky stat.mean double precision rtype Red type double precision rcrowd Red crowding double precision rchi2 Red sodophot fit chi2 stat.fit.chi2 double precision rmpix Red PSF weighted sum of pixels that have ... double precision rcosmicrf Red cosmic ray flux double precision ramp Red amplifier identification number double precision rxpix Red x pixel coordinate double precision rypix Red y pixel coordinate double precision ravesky Red average sky stat.mean double precision rfwhm Red FWHM of PSF (pixels) double precision rtobs Red template observation for macho field corresponding with this observation meta.id;obs integer rcut Red cut flag: if mag or error bad, then=0; else 1 integer bmag Blue instrumental magnitude double precision berr Blue instrumental magnitude 1-sigma error stat.mean double precision bnormsky Blue normalised sky stat.mean double precision btype Blue type double precision bcrowd Blue crowding double precision bchi2 Blue sodophot fit chi2 stat.fit.chi2 double precision bmpix Blue PSF weighted sum of pixels that have ... double precision bcosmicrf Blue cosmic ray flux double precision bamp Blue amplifier identification number double precision bxpix Blue x pixel coordinate double precision bypix Blue y pixel coordinate double precision bavesky Blue average sky stat.mean double precision bfwhm Blue FWHM of PSF (pixels) double precision btobs Blue template observation for macho field corresponding with this observation meta.id;obs integer bcut Blue cut flag: if mag or error bad, then=0; else 1 integer public.starstat_view starid Unique identification for this Star field:tile:sequence meta.id:meta.main integer fieldid Star field number obs.field integer tileid Macho project Tile identification number obs.field integer seqn Unique Star Identification number within given MACHO field and tile meta.id integer npoints Number of observations taken of the tile containing this star stat.value integer rn Number of good points on the red lightcurve for this star stat.value integer rmagave Median magnitude of red lightcurve in instrumental units stat.median double precision rerrave Avg error on robustified red lightcurve stat.mean double precision rsig Sqrt of variance of A-1 measurements over red lightcurve stat.variance double precision rchi2w Red lightcurve chi^2 per fit dof to constant-flux hypothesis weighted by flux errors stat.fit.chi2 double precision rqw Red lightcurve probability of getting value as large as rchi2w by chance stat.probability double precision rnr Number of points on robustified red lightcurve stat.value integer rerraver Avg error on robustified red lightcurve stat.mean double precision rchi2r Chi^2 per degree of freedom for robustified red lightcurve (variable star search) stat.fit.chi2 double precision rqr Red lightcurve probability of getting value as large as rchi2r by chance stat.probability double precision rs5 Number of points on red lightcurve 5-sigma above median stat.value integer rs5d Number of points on red lightcurve 5-sigma below median (eclipsing binary search) stat.value integer rmagaveu Red lightcurve median magnitude in instrumental units before removing bad points stat.median double precision rdskyave Avg of red dsky sodophot measure stat.mean double precision rdskysig Sqrt of variance of red dsky sodophot measure stat.variance double precision rpsfave Avg over red lightcurve of sodophot measure of goodness of psf fit stat.mean double precision rpsfsig Sqrt of variance of red psf sodophot measure stat.variance double precision rcrdave Red lightcurve avg of crowding sodophot measure stat.mean double precision rcosmave Red lightcurve avg of cosmic ray sodophot measure stat.mean double precision rmissave Red lightcurve avg of missing pixel sodophot measure stat.mean double precision bn Number of good points on the blue lightcurve for this star stat.value integer bmagave Median magnitude of blue lightcurve in instrumental units stat.median double precision berrave Avg blue lightcurve measurement error in units of A == (measured flux / median flux) measured flux / median flux stat.mean double precision bsig Sqrt of variance of A-1 measurements over blue lightcurve stat.variance double precision bchi2w Blue lightcurve chi^2 per fit dof to constant-flux hypothesis weighted by flux errors stat.fit.chi2 double precision bqw Blue lightcurveprobability of getting value as large as rchi2w by chance stat.probability double precision bnr Number of points on robustified blue lightcurve stat.value integer berraver Avg error on robustified blue lightcurve stat.mean double precision bchi2r Chi^2 per degree of freedom for robustified blue lightcurve (variable star search) stat.fit.chi2 double precision bqr Blue lightcurve probability of getting value as large as rchi2r by chance stat.probability double precision bs5 Number of points on blue lightcurve 5-sigma above median stat.value integer bs5d Number of points on blue lightcurve 5-sigma below median (eclipsing binary search) stat.value integer bmagaveu Blue lightcurve median magnitude in instrumental units before removing bad points stat.median double precision bdskyave Avg of blue dsky sodophot measure stat.mean double precision bdskysig Sqrt of variance of blue dsky sodophot measure stat.variance double precision bpsfave Avg over blue lightcurve of sodophot measure of goodness of psf fit stat.mean double precision bpsfsig Sqrt of variance of blue psf sodophot measure stat.variance double precision bcrdave Blue lightcurve avg of crowding sodophot measure stat.mean double precision bcosmave Blue lightcurve avg of cosmic ray sodophot measure stat.mean double precision bmissave Blue lightcurve avg of missing pixel sodophot measure stat.mean double precision bmrn Number of points on the blue-red lightcurve [aka simultaneous R/B pts stat.value integer bmrsig Sqrt of variance of A-1 measurements over blue-red lightcurve stat.variance double precision bmrchi2w Chi^2 per fit dof to constant-flux hypothesis weighted by flux errors over blue-red lightcurve stat.fit.chi2 double precision bmrave Median magnitude of blue-red lightcurve in instrumental units stat.median double precision bmrprobspear Blue-red lightcurve spear probability stat.probability double precision rbcross A-1 robustified measurements over blue-red lightcurve cross correlation coefficient [Welch-Stetson; see AJ 105, 1813] stat.correlation double precision rauto Red A-1 robustified measurements over lightcurve autocorrelation (lag=0) coefficient stat.correlation double precision bauto Blue A-1 robustified measurements over lightcurve autocorrelation (lag=0) coefficient stat.correlation double precision filtern Number of filters applied (always 3) stat.value integer filter1rfilmax Filter 1 max value of optimum filter for red lightcurve stat.max double precision filter1rfiltime Filter 1 time at which red lightcurve maximum occurred stat.value double precision filter1rnhi Filter 1 number of points sigma threshold high within duration of filter at red lightcurve peak (rfiltime) stat.value integer filter1bfilmax Filter 1 max value of optimum filter for blue lightcurve stat.max double precision filter1bfiltime Filter 1 time at which blue lightcurve maximum occurred stat.value double precision filter1bnhi Filter 1 number of points sigma threshold high within duration of filter at blue lightcurve peak (bfiltime) stat.value integer filter2rfilmax Filter 2 max value of optimum filter for red lightcurve stat.max double precision filter2rfiltime Filter 2 time at which red lightcurve maximum occurred stat.value double precision filter2rnhi Filter 2 number of points sigma threshold high within duration of filter at red lightcurve peak (rfiltime) stat.value integer filter2bfilmax Filter 2 max value of optimum filter for blue lightcurve stat.max double precision filter2bfiltime Filter 2 time at which blue lightcurve maximum occurred stat.value double precision filter2bnhi Filter 2 number of points sigma threshold high within duration of filter at blue lightcurve peak (bfiltime) stat.value integer filter3rfilmax Filter 3 max value of optimum filter for red lightcurve stat.max double precision filter3rfiltime Filter 3 time at which red lightcurve maximum occurred stat.value double precision filter3rnhi Filter 3 number of points sigma threshold high within duration of filter at red lightcurve peak (rfiltime) stat.value integer filter3bfilmax Filter 3 max value of optimum filter for blue lightcurve stat.max double precision filter3bfiltime Filter 3 time at which blue lightcurve maximum occurred stat.value double precision filter3bnhi Filter 3 number of points sigma threshold high within duration of filter at blue lightcurve peak (bfiltime) stat.value integer public.star_view starid Star ID number meta.id:meta.main integer field Star field number obs.field integer tile Star tile number obs.field integer seqn Star seqence number meta.id integer rarad Star RA coord (radians) rad pos.eq.ra;meta.main double precision decrad Star DEC coord (radians) rad pos.eq.dec;meta.main double precision public.tile_view tileid Tile ID number meta.id:meta.main integer rarad Tile RA coord (radians) rad pos.eq.ra;meta.main double precision decrad Tile DEC coord (radians) rad pos.eq.dec;meta.main double precision tileregion Sky region covered by this tile (box, rad) rad box public.varstar_view starid Unique identification for this Star field:tile:sequence meta.id:meta.main integer rarad Star RA coord (radians) pos.eq.ra;meta.main double precision decrad Star DEC coord (radians) rad pos.eq.dec;meta.main double precision field Macho project Field identification number obs.field integer tile Macho project Tile identification number obs.field integer seqn Unique Star Identification number within given MACHO field and tile meta.id integer period_reqb Avg period is best single cycle period where red=blue period (days) time.period double precision period_r Red avg period is best single cycle period matching blue focal plane's period (days) time.period double precision period_b Blue avg period is best single cycle period matching red focal plane's period (days) time.period double precision magave_r Red mag avgd over all obs except if==-99, or mag brighter -12, or type not 1-6 or 21-26 stat.mean double precision magave_b Blue mag avgd over all obs except if==-99, or mag brighter -12, or type not 1-6, 21-26 stat.mean double precision magave_bminusr (Blue-Red) mag avgd over all obs except if==-99, or mag brighter -12, or type not 1-6, 21-26 stat.mean double precision magave_kv KV mag avgd over all obs except if==-99, or mag brighter than -12, or type not 1-6, 21-26 stat.mean double precision magave_kr KR mag avgd over all obs except if==-99, or mag brighter -12, or type not 1-6, 21-26 stat.mean double precision magave_kvminuskr (KV-KR) mag avgd over all obs except if==-99, or mag brighter -12, or type not 1-6 or 21-26 stat.mean double precision amp_r Red avg is peak-to-peak amplitude of the best fit to the lightcurve src.var.amplitude double precision amp_b Blue avg is peak-to-peak amplitude of best fit to the lightcurve src.var.amplitude double precision amp_bminusr (Blue-Red) avg is peak-to-peak amplitude of best fit to the lightcurve stat.mean double precision amp_reqb percentage of stat.value double precision suprsa_r 'Red weighted mean abs deviation of data from fit to lightcurve. Weighting good fits have values less than 1.0 A stat.mean double precision suprsa_b Blue weighted mean abs deviation of data from fit to lightcurve. Weighting good fits have values less than 1.0 A stat.mean double precision chi2r_r Red robust weighted mean-square difference of data and fit. Only central 80% of differences used stat.fit.chi2 double precision chi2r_b Blue robust weighted mean-square difference of data and fit. Only central 80% of differences used stat.fit.chi2 double precision sig_r Red standard deviation of focal plane's magnitude stat.stdev double precision sig_b Blue standard deviation of focal plane's magnitude stat.stdev double precision varindex Variability index from Pierce et al, 1994, Nature 371:385 src.var.index double precision classification 1. RRL AB : RRLyrae ab 2. RRL C : RRLyrae c 3. RRL E : RRLyrae e 4. Ceph Fundamental 5. Ceph 1st Overtone 6. LPV WoodA 7. LPV WoodB 8. LPV WoodC 9. LPV WoodD 10. EB : Eclipsing Binary default -- 11. RRL + GB : RR Lyrae and GB blends character varying(20) points_total Count of obs where star observed from either focal plane stat.value integer points_concurrent Count of obs where star observed simultaneously in both focal planes stat.value integer points_r Count of obs where star observed in red focal plane stat.value integer points_b Count of obs where star observed in blue focal plane stat.value integer TAP_SCHEMA TAP_SCHEMA.columnsThe required TAP metadata COLUMNS table column_name Column name character varying(64) indexed table_name Fully qualified table name character varying(64) indexed column_order The default order in which the column will output in a TAP query of the containing table integer description Brief description of column character varying(255) unit Unit in VO std format character varying(64) ucd UCD of column if any character varying(128) utype UTYPE if table corresponds to a data model character varying(255) datatype ADQL datatype as in section 2.5 character varying(32) "size" Length of variable length datatypes integer principal A principal column (1 true, 0 false) integer indexed An indexed column (1 true, 0 false) integer std A std column (1 true, 0 false) integer scs_verbosity The lowest verbosity level (1,2,3) at which this column should be included in a cone search result. Leave null to hide the column from SCS. integer db_column_name The database column name by which this table must be referenced in SQL. character varying(64) TAP_SCHEMA.tables table_name table_name TAP_SCHEMA.key_columnsThe required TAP key_columns table id For internal purposes integer indexed key_id Key identifier from keys table character varying(64) indexed from_column Key column name in the from_table character varying(64) target_column Key column name in the target_table character varying(64) from_table Fully qualified source table name character varying(64) target_table Fully qualified target table name character varying(64) TAP_SCHEMA.columns from_column column_name from_table table_name TAP_SCHEMA.columns target_column column_name target_table table_name TAP_SCHEMA.keys key_id key_id TAP_SCHEMA.keysThe required TAP keys table key_id Unique key descriptor character varying(64) indexed from_table Fully qualified table name character varying(70) target_table Fully qualified table name character varying(70) description Description of this key character varying(255) utype Utype of this key character varying(64) TAP_SCHEMA.tables from_table table_name TAP_SCHEMA.tables target_table table_name TAP_SCHEMA.schemasThe names of the TAP services schemas schema_name Fully qualified schema name character varying(64) indexed description The brief description of the schema character varying(256) utype The UTYPE if schema corresponds to a data model. character varying(64) TAP_SCHEMA.tablesThe parameters of the TAP services tables table_name Fully qualified table name in the format schema.table character varying(64) indexed table_type One of: table or view character varying(255) schema_name Fully qualified schema name character varying(64) indexed description The brief description of the table character varying(256) utype The UTYPE if table corresponds to a data model. character varying(64) db_schema_name The database schema name by which this table must be referenced in SQL. character varying(255) db_table_name The database table name by which this table must be referenced in SQL. character varying(255) scs_enabled Should this table be queryable using the Simple Cone Search service. boolean release_required Should unauthorised access to this table be restricted to released data, ie has a populated released_date column. boolean description_long The long description of the table character varying(2000) params Additional parameters of the table character varying(255) TAP_SCHEMA.schemas schema_name schema_name