TABLE masterDR2

Primary table of mean astrometric, photometric and shape measurements per object, with cross-match information to external tables.

This table contains brief descriptions of the parameters provided for
each source in the SkyMapper DR2 master table. It contains 505,176,667 sources.
For more information see the DR2 documentation at http://skymapper.anu.edu.au/data-release/dr2/

Required constraints:
Primary key is (object_id)

Name Type Length Unit Description Default Value Unified Content Descriptor

object_id bigint 8 Global unique object ID in the master table. meta.id;meta.main

raj2000 float 8 deg Mean ICRS Right Ascension of the object pos.eq.ra;meta.main;stat.mean

dej2000 float 8 deg Mean ICRS Declination of the object pos.eq.dec;meta.main;stat.mean

e_raj2000 int 4 mas RMS variation around the mean Right Ascension, in milliarcseconds stat.stdev;pos.eq.ra

e_dej2000 int 4 mas RMS variation around the mean Declination, in milliarcseconds stat.stdev;pos.eq.dec

smss_j varchar 18 SkyMapper Southern Survey designation of the form SMSS Jhhmmss.ss+/-ddmmss.s, derived from mean ICRS coordinates meta.id;meta.main

mean_epoch float 8 d Mean MJD epoch of the observations time.epoch;stat.mean

rms_epoch real 4 d RMS variation around the mean epoch stat.stdev;time.epoch

glon real 4 deg Galactic longitude derived from ICRS coordinates. Not to be used as primary astrometric reference. pos.galactic.lon

glat real 4 deg Galactic latitude derived from ICRS coordinates. Not to be used as primary astrometric reference. pos.galactic.lat

flags smallint 2 Bitwise OR of Source Extractor flags across all observations meta.code

nimaflags int 4 Total number of flagged pixels from bad, saturated, and crosstalk pixel masks across all observations meta.code

ngood smallint 2 Number of observations used across all filters meta.number

ngood_min smallint 2 Minimum number of observations used in any filter (excluding filters with 0 observations) meta.number

nch_max smallint 2 Maximum number of child sources combined into this global object_id in any filter meta.number

density real 4 Number of DR2 sources within 15 arcsec (including this source) src.density

u_flags smallint 2 Bitwise OR of Source Extractor flags from u-band measurements in photometry table meta.code

u_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from u-band measurements in photometry table meta.code

u_ngood smallint 2 Number of u-band observations used meta.number

u_nch smallint 2 Number of u-band child sources combined into this object_id meta.number

u_nclip smallint 2 Number of u-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

v_flags smallint 2 Bitwise OR of Source Extractor flags from v-band measurements in photometry table meta.code

v_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from v-band measurements in photometry table meta.code

v_ngood smallint 2 Number of v-band observations used meta.number

v_nch smallint 2 Number of v-band child sources combined into this object_id meta.number

v_nclip smallint 2 Number of v-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

g_flags smallint 2 Bitwise OR of Source Extractor flags from g-band measurements in photometry table meta.code

g_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from g-band measurements in photometry table meta.code

g_ngood smallint 2 Number of g-band observations used meta.number

g_nch smallint 2 Number of g-band child sources combined into this object_id meta.number

g_nclip smallint 2 Number of g-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

r_flags smallint 2 Bitwise OR of Source Extractor flags from r-band measurements in photometry table meta.code

r_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from r-band measurements in photometry table meta.code

r_ngood smallint 2 Number of r-band observations used meta.number

r_nch smallint 2 Number of r-band child sources combined into this object_id meta.number

r_nclip smallint 2 Number of r-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

i_flags smallint 2 Bitwise OR of Source Extractor flags from i-band measurements in photometry table meta.code

i_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from i-band measurements in photometry table meta.code

i_ngood smallint 2 Number of i-band observations used meta.number

i_nch smallint 2 Number of i-band child sources combined into this object_id meta.number

i_nclip smallint 2 Number of i-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

z_flags smallint 2 Bitwise OR of Source Extractor flags from z-band measurements in photometry table meta.code

z_nimaflags int 4 Number of flagged pixels from bad, saturated, and crosstalk pixel masks from z-band measurements in photometry table meta.code

z_ngood smallint 2 Number of z-band observations used meta.number

z_nch smallint 2 Number of z-band child sources combined into this object_id meta.number

z_nclip smallint 2 Number of z-band observations with magnitudes clipped from the final PSF magnitude estimate meta.number

class_star real 4 Maximum stellarity index from photometry table (between 0=no star and 1=star) src.class.starGalaxy;stat.mean

flags_psf int 4 Bitmask indicating whether photometry is likely biased by neighbours at >1%; bits 0-5 correspond to filters z-u meta.code

radius_petro real 4 pix Mean r-band Petrosian radius phys.angSize;stat.mean

u_psf real 4 mag Mean u-band PSF magnitude phot.mag;stat.mean

e_u_psf real 4 mag Error in u-band PSF magnitude stat.error;phot.mag

u_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the u-band PSF magnitude, including clipped sources stat.fit.chi2

u_petro real 4 mag Mean u-band Petrosian magnitude phot.mag;stat.mean

e_u_petro real 4 mag Error in u-band Petrosian magnitude stat.error;phot.mag

v_psf real 4 mag Mean v-band PSF magnitude phot.mag;stat.mean

e_v_psf real 4 mag Error in v-band PSF magnitude stat.error;phot.mag

v_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the v-band PSF magnitude, including clipped sources stat.fit.chi2

v_petro real 4 mag Mean v-band Petrosian magnitude phot.mag;stat.mean

e_v_petro real 4 mag Error in v-band Petrosian magnitude stat.error;phot.mag

g_psf real 4 mag Mean g-band PSF magnitude phot.mag;stat.mean

e_g_psf real 4 mag Error in g-band PSF magnitude stat.error;phot.mag

g_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the g-band PSF magnitude, including clipped sources stat.fit.chi2

g_petro real 4 mag Mean g-band Petrosian magnitude phot.mag;stat.mean

e_g_petro real 4 mag Error in g-band Petrosian magnitude stat.error;phot.mag

r_psf real 4 mag Mean r-band PSF magnitude phot.mag;stat.mean

e_r_psf real 4 mag Error in r-band PSF magnitude stat.error;phot.mag

r_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the r-band PSF magnitude, including clipped sources stat.fit.chi2

r_petro real 4 mag Mean r-band Petrosian magnitude phot.mag;stat.mean

e_r_petro real 4 mag Error in r-band Petrosian magnitude stat.error;phot.mag

i_psf real 4 mag Mean i-band PSF magnitude phot.mag;stat.mean

e_i_psf real 4 mag Error in i-band PSF magnitude stat.error;phot.mag

i_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the i-band PSF magnitude, including clipped sources stat.fit.chi2

i_petro real 4 mag Mean i-band Petrosian magnitude phot.mag;stat.mean

e_i_petro real 4 mag Error in i-band Petrosian magnitude stat.error;phot.mag

z_psf real 4 mag Mean z-band PSF magnitude phot.mag;stat.mean

e_z_psf real 4 mag Error in z-band PSF magnitude stat.error;phot.mag

z_rchi2var real 4 Reduced chi-squared for a constant-magnitude model of the z-band PSF magnitude, including clipped sources stat.fit.chi2

z_petro real 4 mag Mean z-band Petrosian magnitude phot.mag;stat.mean

e_z_petro real 4 mag Error in z-band Petrosian magnitude stat.error;phot.mag

ebmv_sfd real 4 mag E(B-V) from Schlegel+1998 extinction maps at the ICRS coordinates phot.color.excess;phys.absorption

prox real 4 arcsec Distance to next-closest DR2 source (=15 if no sources within 15 arcsec) pos.angDistance

prox_id bigint 8 object_id of next-closest DR2 source meta.id

dr1_id bigint 8 object_id of closest SkyMapper Data Release 1 source meta.id.cross

dr1_dist real 4 arcsec Distance to closest SkyMapper Data Release 1 source pos.angDistance

twomass_key bigint 8 Unique identifier (pts_key) of closest 2MASS PSC source meta.id.cross

twomass_dist real 4 arcsec Distance on sky to closest 2MASS PSC source pos.angDistance

allwise_cntr bigint 8 Unique identifier (cntr) of closest AllWISE source meta.id.cross

allwise_dist real 4 arcsec Distance on sky to closest AllWISE source pos.angDistance

ucac4_mpos bigint 8 Unique identifier (mpos) of closest UCAC4 source meta.id.cross

ucac4_dist real 4 arcsec Distance on sky to closest UCAC4 source pos.angDistance

refcat2_id bigint 8 Unique identifier (objid) of closest ATLAS Refcat2 source (only useful for this copy of Refcat2) meta.id.cross

refcat2_dist real 4 arcsec Distance on sky to closest ATLAS Refcat2 source pos.angDistance

ps1_dr1_id bigint 8 Unique identifier (objID) of closest Pan-STARRS1 DR1 source meta.id.cross

ps1_dr1_dist real 4 arcsec Distance on sky to closest Pan-STARRS1 DR1 source pos.angDistance

galex_guv_id bigint 8 Unique identifier (objid) of closest GALEX GUVcat AIS source (Bianchi et al. 2017) meta.id.cross

galex_guv_dist real 4 arcsec Distance on sky to closest GALEX GUVcat AIS source pos.angDistance

gaia_dr2_id1 bigint 8 Unique identifier (source_id) of closest Gaia DR2 source meta.id.cross

gaia_dr2_dist1 real 4 arcsec Distance on sky to closest Gaia DR2 source pos.angDistance

gaia_dr2_id2 bigint 8 Unique identifier (source_id) of second-closest Gaia DR2 source meta.id.cross

gaia_dr2_dist2 real 4 arcsec Distance on sky to second-closest Gaia DR2 source pos.angDistance

cx float 8 unit vector of spherical co-ordinates pos.cartesian.x

cy float 8 unit vector of spherical co-ordinates pos.cartesian.y

cz float 8 unit vector of spherical co-ordinates pos.cartesian.z

htmID bigint 8 Level 20 Hierarchical Triangular Mesh (HTM) index for equatorial co-ordinates pos.htm

Total length 446

Name	Type	Length	Unit	Description	Unified Content Descriptor
object_id	bigint	8		Global unique object ID in the master table.	meta.id;meta.main
raj2000	float	8	deg	Mean ICRS Right Ascension of the object	pos.eq.ra;meta.main;stat.mean
dej2000	float	8	deg	Mean ICRS Declination of the object	pos.eq.dec;meta.main;stat.mean
e_raj2000	int	4	mas	RMS variation around the mean Right Ascension, in milliarcseconds	stat.stdev;pos.eq.ra
e_dej2000	int	4	mas	RMS variation around the mean Declination, in milliarcseconds	stat.stdev;pos.eq.dec
smss_j	varchar	18		SkyMapper Southern Survey designation of the form SMSS Jhhmmss.ss+/-ddmmss.s, derived from mean ICRS coordinates	meta.id;meta.main
mean_epoch	float	8	d	Mean MJD epoch of the observations	time.epoch;stat.mean
rms_epoch	real	4	d	RMS variation around the mean epoch	stat.stdev;time.epoch
glon	real	4	deg	Galactic longitude derived from ICRS coordinates. Not to be used as primary astrometric reference.	pos.galactic.lon
glat	real	4	deg	Galactic latitude derived from ICRS coordinates. Not to be used as primary astrometric reference.	pos.galactic.lat
flags	smallint	2		Bitwise OR of Source Extractor flags across all observations	meta.code
nimaflags	int	4		Total number of flagged pixels from bad, saturated, and crosstalk pixel masks across all observations	meta.code
ngood	smallint	2		Number of observations used across all filters	meta.number
ngood_min	smallint	2		Minimum number of observations used in any filter (excluding filters with 0 observations)	meta.number
nch_max	smallint	2		Maximum number of child sources combined into this global object_id in any filter	meta.number
density	real	4		Number of DR2 sources within 15 arcsec (including this source)	src.density
u_flags	smallint	2		Bitwise OR of Source Extractor flags from u-band measurements in photometry table	meta.code
u_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from u-band measurements in photometry table	meta.code
u_ngood	smallint	2		Number of u-band observations used	meta.number
u_nch	smallint	2		Number of u-band child sources combined into this object_id	meta.number
u_nclip	smallint	2		Number of u-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
v_flags	smallint	2		Bitwise OR of Source Extractor flags from v-band measurements in photometry table	meta.code
v_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from v-band measurements in photometry table	meta.code
v_ngood	smallint	2		Number of v-band observations used	meta.number
v_nch	smallint	2		Number of v-band child sources combined into this object_id	meta.number
v_nclip	smallint	2		Number of v-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
g_flags	smallint	2		Bitwise OR of Source Extractor flags from g-band measurements in photometry table	meta.code
g_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from g-band measurements in photometry table	meta.code
g_ngood	smallint	2		Number of g-band observations used	meta.number
g_nch	smallint	2		Number of g-band child sources combined into this object_id	meta.number
g_nclip	smallint	2		Number of g-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
r_flags	smallint	2		Bitwise OR of Source Extractor flags from r-band measurements in photometry table	meta.code
r_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from r-band measurements in photometry table	meta.code
r_ngood	smallint	2		Number of r-band observations used	meta.number
r_nch	smallint	2		Number of r-band child sources combined into this object_id	meta.number
r_nclip	smallint	2		Number of r-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
i_flags	smallint	2		Bitwise OR of Source Extractor flags from i-band measurements in photometry table	meta.code
i_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from i-band measurements in photometry table	meta.code
i_ngood	smallint	2		Number of i-band observations used	meta.number
i_nch	smallint	2		Number of i-band child sources combined into this object_id	meta.number
i_nclip	smallint	2		Number of i-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
z_flags	smallint	2		Bitwise OR of Source Extractor flags from z-band measurements in photometry table	meta.code
z_nimaflags	int	4		Number of flagged pixels from bad, saturated, and crosstalk pixel masks from z-band measurements in photometry table	meta.code
z_ngood	smallint	2		Number of z-band observations used	meta.number
z_nch	smallint	2		Number of z-band child sources combined into this object_id	meta.number
z_nclip	smallint	2		Number of z-band observations with magnitudes clipped from the final PSF magnitude estimate	meta.number
class_star	real	4		Maximum stellarity index from photometry table (between 0=no star and 1=star)	src.class.starGalaxy;stat.mean
flags_psf	int	4		Bitmask indicating whether photometry is likely biased by neighbours at >1%; bits 0-5 correspond to filters z-u	meta.code
radius_petro	real	4	pix	Mean r-band Petrosian radius	phys.angSize;stat.mean
u_psf	real	4	mag	Mean u-band PSF magnitude	phot.mag;stat.mean
e_u_psf	real	4	mag	Error in u-band PSF magnitude	stat.error;phot.mag
u_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the u-band PSF magnitude, including clipped sources	stat.fit.chi2
u_petro	real	4	mag	Mean u-band Petrosian magnitude	phot.mag;stat.mean
e_u_petro	real	4	mag	Error in u-band Petrosian magnitude	stat.error;phot.mag
v_psf	real	4	mag	Mean v-band PSF magnitude	phot.mag;stat.mean
e_v_psf	real	4	mag	Error in v-band PSF magnitude	stat.error;phot.mag
v_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the v-band PSF magnitude, including clipped sources	stat.fit.chi2
v_petro	real	4	mag	Mean v-band Petrosian magnitude	phot.mag;stat.mean
e_v_petro	real	4	mag	Error in v-band Petrosian magnitude	stat.error;phot.mag
g_psf	real	4	mag	Mean g-band PSF magnitude	phot.mag;stat.mean
e_g_psf	real	4	mag	Error in g-band PSF magnitude	stat.error;phot.mag
g_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the g-band PSF magnitude, including clipped sources	stat.fit.chi2
g_petro	real	4	mag	Mean g-band Petrosian magnitude	phot.mag;stat.mean
e_g_petro	real	4	mag	Error in g-band Petrosian magnitude	stat.error;phot.mag
r_psf	real	4	mag	Mean r-band PSF magnitude	phot.mag;stat.mean
e_r_psf	real	4	mag	Error in r-band PSF magnitude	stat.error;phot.mag
r_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the r-band PSF magnitude, including clipped sources	stat.fit.chi2
r_petro	real	4	mag	Mean r-band Petrosian magnitude	phot.mag;stat.mean
e_r_petro	real	4	mag	Error in r-band Petrosian magnitude	stat.error;phot.mag
i_psf	real	4	mag	Mean i-band PSF magnitude	phot.mag;stat.mean
e_i_psf	real	4	mag	Error in i-band PSF magnitude	stat.error;phot.mag
i_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the i-band PSF magnitude, including clipped sources	stat.fit.chi2
i_petro	real	4	mag	Mean i-band Petrosian magnitude	phot.mag;stat.mean
e_i_petro	real	4	mag	Error in i-band Petrosian magnitude	stat.error;phot.mag
z_psf	real	4	mag	Mean z-band PSF magnitude	phot.mag;stat.mean
e_z_psf	real	4	mag	Error in z-band PSF magnitude	stat.error;phot.mag
z_rchi2var	real	4		Reduced chi-squared for a constant-magnitude model of the z-band PSF magnitude, including clipped sources	stat.fit.chi2
z_petro	real	4	mag	Mean z-band Petrosian magnitude	phot.mag;stat.mean
e_z_petro	real	4	mag	Error in z-band Petrosian magnitude	stat.error;phot.mag
ebmv_sfd	real	4	mag	E(B-V) from Schlegel+1998 extinction maps at the ICRS coordinates	phot.color.excess;phys.absorption
prox	real	4	arcsec	Distance to next-closest DR2 source (=15 if no sources within 15 arcsec)	pos.angDistance
prox_id	bigint	8		object_id of next-closest DR2 source	meta.id
dr1_id	bigint	8		object_id of closest SkyMapper Data Release 1 source	meta.id.cross
dr1_dist	real	4	arcsec	Distance to closest SkyMapper Data Release 1 source	pos.angDistance
twomass_key	bigint	8		Unique identifier (pts_key) of closest 2MASS PSC source	meta.id.cross
twomass_dist	real	4	arcsec	Distance on sky to closest 2MASS PSC source	pos.angDistance
allwise_cntr	bigint	8		Unique identifier (cntr) of closest AllWISE source	meta.id.cross
allwise_dist	real	4	arcsec	Distance on sky to closest AllWISE source	pos.angDistance
ucac4_mpos	bigint	8		Unique identifier (mpos) of closest UCAC4 source	meta.id.cross
ucac4_dist	real	4	arcsec	Distance on sky to closest UCAC4 source	pos.angDistance
refcat2_id	bigint	8		Unique identifier (objid) of closest ATLAS Refcat2 source (only useful for this copy of Refcat2)	meta.id.cross
refcat2_dist	real	4	arcsec	Distance on sky to closest ATLAS Refcat2 source	pos.angDistance
ps1_dr1_id	bigint	8		Unique identifier (objID) of closest Pan-STARRS1 DR1 source	meta.id.cross
ps1_dr1_dist	real	4	arcsec	Distance on sky to closest Pan-STARRS1 DR1 source	pos.angDistance
galex_guv_id	bigint	8		Unique identifier (objid) of closest GALEX GUVcat AIS source (Bianchi et al. 2017)	meta.id.cross
galex_guv_dist	real	4	arcsec	Distance on sky to closest GALEX GUVcat AIS source	pos.angDistance
gaia_dr2_id1	bigint	8		Unique identifier (source_id) of closest Gaia DR2 source	meta.id.cross
gaia_dr2_dist1	real	4	arcsec	Distance on sky to closest Gaia DR2 source	pos.angDistance
gaia_dr2_id2	bigint	8		Unique identifier (source_id) of second-closest Gaia DR2 source	meta.id.cross
gaia_dr2_dist2	real	4	arcsec	Distance on sky to second-closest Gaia DR2 source	pos.angDistance
cx	float	8		unit vector of spherical co-ordinates	pos.cartesian.x
cy	float	8		unit vector of spherical co-ordinates	pos.cartesian.y
cz	float	8		unit vector of spherical co-ordinates	pos.cartesian.z
htmID	bigint	8		Level 20 Hierarchical Triangular Mesh (HTM) index for equatorial co-ordinates	pos.htm
Total length		446