Choose a database in the left panel then select the table you want!
Table: skymapper_dr2.master
(The bold columns are indexed columns)
| Column Name | Description | Datatype |
|---|---|---|
| allwise_cntr | Unique identifier (cntr) of closest AllWISE source | BIGINT |
| allwise_dist | Distance on sky to closest AllWISE source | REAL |
| class_star | Maximum stellarity index from photometry table (between 0=no star and 1=star) | REAL |
| dej2000 | Mean ICRS Declination of the object | DOUBLE |
| density | Number of DR2 sources within 15 arcsec (including this source) | REAL |
| dr1_dist | Distance to closest SkyMapper Data Release 1 source | REAL |
| dr1_id | object_id of closest SkyMapper Data Release 1 source | BIGINT |
| e_dej2000 | RMS variation around the mean Declination, in milliarcseconds | INTEGER |
| e_g_petro | Error in g-band Petrosian magnitude | REAL |
| e_g_psf | Error in g-band PSF magnitude | REAL |
| e_i_petro | Error in i-band Petrosian magnitude | REAL |
| e_i_psf | Error in i-band PSF magnitude | REAL |
| e_r_petro | Error in r-band Petrosian magnitude | REAL |
| e_r_psf | Error in r-band PSF magnitude | REAL |
| e_raj2000 | RMS variation around the mean Right Ascension, in milliarcseconds | INTEGER |
| e_u_petro | Error in u-band Petrosian magnitude | REAL |
| e_u_psf | Error in u-band PSF magnitude | REAL |
| e_v_petro | Error in v-band Petrosian magnitude | REAL |
| e_v_psf | Error in v-band PSF magnitude | REAL |
| e_z_petro | Error in z-band Petrosian magnitude | REAL |
| e_z_psf | Error in z-band PSF magnitude | REAL |
| ebmv_sfd | E(B-V) from Schlegel+1998 extinction maps at the ICRS coordinates | REAL |
| elat | Ecliptic latitude | DOUBLE |
| elon | Ecliptic longitude | DOUBLE |
| flags | Bitwise OR of Source Extractor flags across all observations | SMALLINT |
| flags_psf | Bitmask indicating whether photometry is likely biased by neighbours at >1%; bits 0-5 correspond to filters z-u | INTEGER |
| g_flags | Bitwise OR of Source Extractor flags from g-band measurements in photometry table | SMALLINT |
| g_nch | Number of g-band child sources combined into this object_id | SMALLINT |
| g_nclip | Number of g-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| g_ngood | Number of g-band observations used | SMALLINT |
| g_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from g-band measurements in photometry table | INTEGER |
| g_petro | Mean g-band Petrosian magnitude | REAL |
| g_psf | Mean g-band PSF magnitude | REAL |
| g_rchi2var | Reduced chi-squared for a constant-magnitude model of the g-band PSF magnitude, including clipped sources | REAL |
| gaia_dr2_dist1 | Distance on sky to closest Gaia DR2 source | REAL |
| gaia_dr2_dist2 | Distance on sky to second-closest Gaia DR2 source | REAL |
| gaia_dr2_id1 | Unique identifier (source_id) of closest Gaia DR2 source | BIGINT |
| gaia_dr2_id2 | Unique identifier (source_id) of second-closest Gaia DR2 source | BIGINT |
| galex_guv_dist | Distance on sky to closest GALEX GUVcat AIS source | REAL |
| galex_guv_id | Unique identifier (objid) of closest GALEX GUVcat AIS source (Bianchi et al. 2017) | BIGINT |
| glat | Galactic latitude derived from ICRS coordinates. Not to be used as primary astrometric reference. | DOUBLE |
| glon | Galactic longitude derived from ICRS coordinates. Not to be used as primary astrometric reference. | DOUBLE |
| htm9 | HTM index (order 9=>~10 arcmin size) | INTEGER |
| i_flags | Bitwise OR of Source Extractor flags from i-band measurements in photometry table | SMALLINT |
| i_nch | Number of i-band child sources combined into this object_id | SMALLINT |
| i_nclip | Number of i-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| i_ngood | Number of i-band observations used | SMALLINT |
| i_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from i-band measurements in photometry table | INTEGER |
| i_petro | Mean i-band Petrosian magnitude | REAL |
| i_psf | Mean i-band PSF magnitude | REAL |
| i_rchi2var | Reduced chi-squared for a constant-magnitude model of the i-band PSF magnitude, including clipped sources | REAL |
| mean_epoch | Mean MJD epoch of the observations | DOUBLE |
| nch_max | Maximum number of child sources combined into this global object_id in any filter | SMALLINT |
| nest4096 | HEALPIX index (Nsides 4096, Nest scheme=>~52 arcsec size) | INTEGER |
| ngood | Number of observations used across all filters | SMALLINT |
| ngood_min | Minimum number of observations used in any filter (excluding filters with 0 observations) | SMALLINT |
| nimaflags | Total number of flagged pixels from bad, saturated, and crosstalk pixel masks across all observations | INTEGER |
| object_id | Global unique object ID in the master table. | BIGINT |
| prox | Distance to next-closest DR2 source (=15 if no sources within 15 arcsec) | REAL |
| prox_id | object_id of next-closest DR2 source | BIGINT |
| ps1_dr1_dist | Distance on sky to closest Pan-STARRS1 DR1 source | REAL |
| ps1_dr1_id | Unique identifier (objID) of closest Pan-STARRS1 DR1 source | BIGINT |
| r_flags | Bitwise OR of Source Extractor flags from r-band measurements in photometry table | SMALLINT |
| r_nch | Number of r-band child sources combined into this object_id | SMALLINT |
| r_nclip | Number of r-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| r_ngood | Number of r-band observations used | SMALLINT |
| r_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from r-band measurements in photometry table | INTEGER |
| r_petro | Mean r-band Petrosian magnitude | REAL |
| r_psf | Mean r-band PSF magnitude | REAL |
| r_rchi2var | Reduced chi-squared for a constant-magnitude model of the r-band PSF magnitude, including clipped sources | REAL |
| radius_petro | Mean r-band Petrosian radius | REAL |
| raj2000 | Mean ICRS Right Ascension of the object | DOUBLE |
| random_id | Random ID in the range 0.0 => 100.0 | REAL |
| refcat2_dist | Distance on sky to closest ATLAS Refcat2 source | REAL |
| refcat2_id | Unique identifier (objid) of closest ATLAS Refcat2 source (only useful for this copy of Refcat2) | BIGINT |
| ring256 | HEALPIX index (Nsides 256=>~14 arcmin size) | INTEGER |
| rms_epoch | RMS variation around the mean epoch | REAL |
| smss_j | SkyMapper Southern Survey designation of the form SMSS Jhhmmss.ss+/-ddmmss.s, derived from mean ICRS coordinates | CHAR |
| twomass_dist | Distance on sky to closest 2MASS PSC source | REAL |
| twomass_key | Unique identifier (pts_key) of closest 2MASS PSC source | BIGINT |
| u_flags | Bitwise OR of Source Extractor flags from u-band measurements in photometry table | SMALLINT |
| u_nch | Number of u-band child sources combined into this object_id | SMALLINT |
| u_nclip | Number of u-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| u_ngood | Number of u-band observations used | SMALLINT |
| u_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from u-band measurements in photometry table | INTEGER |
| u_petro | Mean u-band Petrosian magnitude | REAL |
| u_psf | Mean u-band PSF magnitude | REAL |
| u_rchi2var | Reduced chi-squared for a constant-magnitude model of the u-band PSF magnitude, including clipped sources | REAL |
| ucac4_dist | Distance on sky to closest UCAC4 source | REAL |
| ucac4_mpos | Unique identifier (mpos) of closest UCAC4 source | BIGINT |
| v_flags | Bitwise OR of Source Extractor flags from v-band measurements in photometry table | SMALLINT |
| v_nch | Number of v-band child sources combined into this object_id | SMALLINT |
| v_nclip | Number of v-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| v_ngood | Number of v-band observations used | SMALLINT |
| v_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from v-band measurements in photometry table | INTEGER |
| v_petro | Mean v-band Petrosian magnitude | REAL |
| v_psf | Mean v-band PSF magnitude | REAL |
| v_rchi2var | Reduced chi-squared for a constant-magnitude model of the v-band PSF magnitude, including clipped sources | REAL |
| z_flags | Bitwise OR of Source Extractor flags from z-band measurements in photometry table | SMALLINT |
| z_nch | Number of z-band child sources combined into this object_id | SMALLINT |
| z_nclip | Number of z-band observations with magnitudes clipped from the final PSF magnitude estimate | SMALLINT |
| z_ngood | Number of z-band observations used | SMALLINT |
| z_nimaflags | Number of flagged pixels from bad, saturated, and crosstalk pixel masks from z-band measurements in photometry table | INTEGER |
| z_petro | Mean z-band Petrosian magnitude | REAL |
| z_psf | Mean z-band PSF magnitude | REAL |
| z_rchi2var | Reduced chi-squared for a constant-magnitude model of the z-band PSF magnitude, including clipped sources | REAL |
