Choose a database in the left panel then select the table you want!
Table: skymapper_dr1.master
(The bold columns are indexed columns)
Column Name | Description | Datatype |
---|---|---|
a | Mean r-band semi-major axis length | REAL |
allwise_cntr | Unique identifier (cntr) of closest AllWISE source | BIGINT |
allwise_dist | Distance on sky to closest AllWISE source | REAL |
apass_dist | Distance on sky to closest APASS DR9 source | REAL |
apass_recno | 0 | BIGINT |
b | Mean r-band semi-minor axis length | REAL |
class_star | 0 | REAL |
dej2000 | Mean ICRS Declination of the object | DOUBLE |
e_a | Error in mean r-band semi-major axis length | REAL |
e_b | Error in mean r-band semi-minor axis length | REAL |
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_pa | Error in mean r-band position angle | 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 | 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 | DOUBLE |
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 |
edr_dist | Distance to closest Early Data Release source | REAL |
edr_id | object_id of closest Early Data Release source | BIGINT |
elat | Ecliptic latitude | DOUBLE |
elon | Ecliptic longitude | DOUBLE |
flags | Bitwise OR of Source Extractor flags from photometry table | INTEGER |
g_flags | 0 | SMALLINT |
g_nch | Number of g-band child sources combined into this object_id | SMALLINT |
g_ngood | Number of g-band observations used | SMALLINT |
g_nimaflags | 0 | INTEGER |
g_nvisit | 0 | SMALLINT |
g_petro | Mean g-band ZP-corrected Petrosian magnitude | DOUBLE |
g_psf | Mean g-band PSF magnitude | REAL |
gaia_dr1_dist | Distance on sky to closest Gaia DR1 source | REAL |
gaia_dr1_id | Unique identifier (source_id) of closest Gaia DR1 source | BIGINT |
galex_bcs_dist | Distance on sky to closest GALEX AIS source | REAL |
galex_bcs_id | 0 | BIGINT |
glat | 0 | REAL |
glon | 0 | REAL |
htm9 | HTM index (order 9 => ~10 arcmin size) | INTEGER |
i_flags | 0 | SMALLINT |
i_nch | Number of i-band child sources combined into this object_id | SMALLINT |
i_ngood | Number of i-band observations used | SMALLINT |
i_nimaflags | 0 | INTEGER |
i_nvisit | 0 | SMALLINT |
i_petro | Mean i-band Petrosian magnitude | REAL |
i_psf | Mean i-band PSF magnitude | REAL |
mean_epoch | Mean MJD epoch of the observations | DOUBLE |
nch_max | 0 | SMALLINT |
nest4096 | HEALPIX index (Nsides 4096, Nest scheme => ~52 arcsec size) | INTEGER |
ngood | Number of observations used across all filters | SMALLINT |
ngood_min | 0 | SMALLINT |
nimaflags | 0 | INTEGER |
object_id | Global unique object ID in the master table. | BIGINT |
pa | Mean r-band position angle (E of N, -90..+90 deg) | REAL |
prox | Distance to closest EDR source | REAL |
prox_id | object_id of next-closest DR1 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 | 0 | SMALLINT |
r_nch | Number of r-band child sources combined into this object_id | SMALLINT |
r_ngood | Number of r-band observations used | SMALLINT |
r_nimaflags | 0 | INTEGER |
r_nvisit | 0 | SMALLINT |
r_petro | Mean r-band Petrosian magnitude | REAL |
r_psf | Mean r-band PSF magnitude | REAL |
radius_petro | Mean r-band Petrosian radius | DOUBLE |
raj2000 | Mean ICRS Right Ascension of the object | DOUBLE |
random_id | Random ID in the range 0.0 => 100.0 | REAL |
ring256 | HEALPIX index (Nsides 256 => ~14 arcmin size) | INTEGER |
rms_epoch | RMS variation around the mean epoch | REAL |
smss_j | 0 | VARCHAR |
twomass_cat1 | 2MASS catalogue of closest match (point source PSC, or extended XSC) | VARCHAR |
twomass_cat2 | 0 | VARCHAR |
twomass_dist1 | Distance on sky to closest 2MASS source | REAL |
twomass_dist2 | Distance on sky to second closest 2MASS source | REAL |
twomass_key1 | Unique identifier (pts_key/ext_key) of closest 2MASS source | BIGINT |
twomass_key2 | Unique identifier (pts_key/ext_key) of second closest 2MASS source | BIGINT |
u_flags | 0 | SMALLINT |
u_nch | Number of u-band child sources combined into this object_id | SMALLINT |
u_ngood | Number of u-band observations used | SMALLINT |
u_nimaflags | 0 | INTEGER |
u_nvisit | 0 | SMALLINT |
u_petro | Mean u-band ZP-corrected Petrosian magnitude | DOUBLE |
u_psf | Mean u-band ZP-corrected PSF magnitude | DOUBLE |
ucac4_dist | Distance on sky to closest UCAC4 source | REAL |
ucac4_mpos | Unique identifier (mpos) of closest UCAC4 source | BIGINT |
v_flags | 0 | SMALLINT |
v_nch | Number of v-band child sources combined into this object_id | SMALLINT |
v_ngood | Number of v-band observations used | SMALLINT |
v_nimaflags | 0 | INTEGER |
v_nvisit | 0 | SMALLINT |
v_petro | Mean v-band Petrosian magnitude | REAL |
v_psf | Mean v-band PSF magnitude | REAL |
z_flags | 0 | SMALLINT |
z_nch | Number of z-band child sources combined into this object_id | SMALLINT |
z_ngood | Number of z-band observations used | SMALLINT |
z_nimaflags | 0 | INTEGER |
z_nvisit | 0 | SMALLINT |
z_petro | Mean z-band Petrosian magnitude | REAL |
z_psf | Mean z-band PSF magnitude | REAL |