atlas_T08 contains 339 columns - click on heading to sort:

Table	Column	Type	Size	Nulls	Auto	Default	Comments
config	config_id	bigint	19		√		Referring derived object
config	config_text	text	65535	√		null	Config contents
config	created	timestamp	19			CURRENT_TIMESTAMP	Creation timestamp
derivedobject_attrib	derivedobject_id	bigint	19
derivedobject_attrib	tracklet_id	bigint	19
derivedobjects	albedo	double	22	√		null	Albedo, dimensionless
derivedobjects	amplitude	double	22	√		null	Amplitude, magnitudes (dimensionless)
derivedobjects	classification	char	1	√		null	MOPS efficiency classification (C/M/B/N/X)
derivedobjects	created	timestamp	19			CURRENT_TIMESTAMP	Timestamp for derived object creation
derivedobjects	derivedobject_id	bigint	19		√		Auto-assigned internal MOPS numeric ID
derivedobjects	g	double	22	√		null	Slope parameter g
derivedobjects	mops_classification	char	3	√		null	3-char MOPS asteroid classification
derivedobjects	object_name	varbinary	32	√		null	MOPS base-64 object name
derivedobjects	orbit_id	bigint	19	√		null	Pointer to current orbit
derivedobjects	pole_lat	double	22	√		null	Rotation pole latitude, deg
derivedobjects	pole_long	double	22	√		null	Rotation pole longitude, deg
derivedobjects	rotation_epoch	double	22	√		null	Rotation time origin, MJD
derivedobjects	rotation_period	double	22	√		null	Rotation period, days
derivedobjects	ssm_id	bigint	19	√		null	Source SSM obje t for C classification
derivedobjects	stable_pass	char	1	√		null	NULL, or set to Y when stable precovery pass completed
derivedobjects	status	char	1	√		null	NULL, or set to M when DO is merged with parent
derivedobjects	taxonomic_type	char	2	√		null	Asteroid taxonomic type
derivedobjects	updated	timestamp	19			0000-00-00 00:00:00	Timestamp for derived object modification
det_rawattr_v2	ap_flux	float	12	√		null
det_rawattr_v2	ap_flux_sig	float	12	√		null
det_rawattr_v2	ap_mag	float	12	√		null
det_rawattr_v2	ap_mag_radius	float	12	√		null
det_rawattr_v2	ap_mag_raw	float	12	√		null
det_rawattr_v2	cal_psf_mag	float	12	√		null
det_rawattr_v2	cal_psf_mag_sig	float	12	√		null
det_rawattr_v2	cr_sig	float	12	√		null
det_rawattr_v2	det_id	bigint	19	√		null	Source det_id
det_rawattr_v2	diff_r_m	float	12	√		null
det_rawattr_v2	diff_r_p	float	12	√		null
det_rawattr_v2	diff_sn_m	float	12	√		null
det_rawattr_v2	diff_sn_p	float	12	√		null
det_rawattr_v2	ext_sig	float	12	√		null
det_rawattr_v2	f_pos	float	12	√		null
det_rawattr_v2	flags	int	10	√		null
det_rawattr_v2	flags2	int	10	√		null
det_rawattr_v2	ipp_idet	int	10	√		null
det_rawattr_v2	kron_flux	float	12	√		null
det_rawattr_v2	kron_flux_err	float	12	√		null
det_rawattr_v2	kron_flux_inner	float	12	√		null
det_rawattr_v2	kron_flux_outer	float	12	√		null
det_rawattr_v2	moments_r1	float	12	√		null
det_rawattr_v2	moments_rh	float	12	√		null
det_rawattr_v2	moments_xx	float	12	√		null
det_rawattr_v2	moments_xy	float	12	√		null
det_rawattr_v2	moments_yy	float	12	√		null
det_rawattr_v2	n_frames	int	10	√		null
det_rawattr_v2	n_pos	int	10	√		null
det_rawattr_v2	peak_flux_as_mag	float	12	√		null
det_rawattr_v2	psf_chi2	float	12	√		null
det_rawattr_v2	psf_dof	int	10	√		null
det_rawattr_v2	psf_inst_flux	float	12	√		null
det_rawattr_v2	psf_inst_flux_sig	float	12	√		null
det_rawattr_v2	psf_major	float	12	√		null
det_rawattr_v2	psf_minor	float	12	√		null
det_rawattr_v2	psf_npix	int	10	√		null
det_rawattr_v2	psf_qf_perfect	float	12	√		null
det_rawattr_v2	psf_quality	float	12	√		null
det_rawattr_v2	psf_theta	float	12	√		null
det_rawattr_v2	ratio_all	float	12	√		null
det_rawattr_v2	ratio_bad	float	12	√		null
det_rawattr_v2	ratio_mask	float	12	√		null
det_rawattr_v2	sky	float	12	√		null
det_rawattr_v2	sky_sigma	float	12	√		null
det_rawattr_v3	chin	float	12	√		null
det_rawattr_v3	det_id	bigint	19	√		null	Source det_id
det_rawattr_v3	dirty	int	10	√		null
det_rawattr_v3	dstar	int	10	√		null
det_rawattr_v3	mstar	float	12	√		null
det_rawattr_v3	peak	int	10	√		null
det_rawattr_v3	preal	float	12	√		null
det_rawattr_v3	pstar	float	12	√		null
det_rawattr_v3	sky	float	12	√		null
det_rawattr_v3	star	int	10	√		null
det_rawattr_v3	vtflags	varchar	8	√		null
det_sig	det_id	bigint	19
det_sig	rdcorr	float	12	√		null
det_sig	tsig	float	12	√		null
det_sig	xsig	float	12	√		null
detections	dec_deg	double	22				Dec, deg
detections	dec_sigma_deg	float	12	√		null	Working 1-sigma uncertainty in Dec, deg
detections	det_id	bigint	19		√		Auto-defined MOPS internal detection ID
detections	det_num	bigint	19	√		null	zero-based detection number in source IPP FITS file
detections	dev_id	bigint	19	√		null	device ID
detections	dev_x	float	12	√		null	device X coordinate
detections	dev_y	float	12	√		null	device Y coordinate
detections	epoch_mjd	double	22				Exact time of detection acquistion, not necessarily constant across field
detections	field_id	bigint	19	√		null	Source field ID containing this detection
detections	filter_id	char	2				Filter used for this detection
detections	is_synthetic	char	1	√		null	efficiency marker; indicates detection is synthetic
detections	length_deg	float	12	√		null	Length of detection, deg
detections	mag	float	12				Apparent magnitude of detection
detections	mag_sigma	float	12	√		null	Uncertainty in magnitude
detections	object_name	varbinary	32	√		null	Originating SSM object name, if synthetic
detections	obscode	char	3	√		null	MPC observatory code
detections	orient_deg	float	12	√		null	Orientation of detection, deg; 0 => N, + toward E
detections	proc_id	bigint	19	√		null	opaque IPP processing identifier (usually DIFFIM_ID)
detections	ra_deg	double	22				RA, deg
detections	ra_sigma_deg	float	12	√		null	Working 1-sigma uncertainty in RA, deg
detections	ref_mag	float	12	√		null	Reference magnitude before shape modulation applied (for synth dets)
detections	s2n	float	12	√		null	Detection signal-to-noise
detections	status	char	1	√		null	efficiency marker; indicates detection was detected (not lost in chip gap, etc.)
detections	xyidx	int	10	√		null	XY spatial index number within field
deteff	bin_end	float	12	√		null	End of magnitude bin
deteff	bin_start	float	12	√		null	Start of magnitude bin
deteff	eff_type	enum	9	√		null	type of efficiency, tracklet or detection
deteff	filter_id	char	1	√		null	PS1 filter
deteff	found	int	10	√		null	Number of found objects in bin
deteff	known	int	10	√		null	Number of known objects in bin
deteff	nn	int	10	√		null	MOPS night number
eon_queue	derivedobject_id	bigint	19				Referring derived object
eon_queue	event_id	bigint	19				Referring history event causing insertion
eon_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP	Wall clock time object was queued
eon_queue	status	char	1	√		N	Processing status N => new, I => ID1 done, P => precov done, X => finished
export	do_export_id	bigint	19	√		null	ID of Derived Object
export	export_status	char	1	√		null	P for pending, E for exported
export	export_time	datetime	19	√		null	time of actual export, status changes from P to E
export	rev_time	datetime	19	√		null	time of revision processing
export	revision_id	bigint	19		√		id of revision record created for handling export
export	tracklet_export_id	bigint	19	√		null	Tracklet ID of tracklet with known_id
export_dets	det_export_id	bigint	19		√		detection export id
export_dets	det_id	bigint	19	√		null	id of detection from table detections
export_dets	mpc_accepted	char	1	√		null	{Y|N} for accepted by MPC
export_dets	removal	char	1	√		null	flag to indicate that the detection is to be removed
export_dets	rev_id	bigint	19	√		null	id of revision from table export
fields	de1	double	22	√		null	IPP-defined detection efficiency 1
fields	de10	double	22	√		null	IPP-defined detection efficiency 10
fields	de2	double	22	√		null	IPP-defined detection efficiency 2
fields	de3	double	22	√		null	IPP-defined detection efficiency 3
fields	de4	double	22	√		null	IPP-defined detection efficiency 4
fields	de5	double	22	√		null	IPP-defined detection efficiency 5
fields	de6	double	22	√		null	IPP-defined detection efficiency 6
fields	de7	double	22	√		null	IPP-defined detection efficiency 7
fields	de8	double	22	√		null	IPP-defined detection efficiency 8
fields	de9	double	22	√		null	IPP-defined detection efficiency 9
fields	dec_deg	double	22				Dec, deg, of field center
fields	dec_sigma	double	22	√		null	Uncertainty in Dec
fields	diff_id	varchar	20	√		null	IPP DIFF_ID (image diff ID)
fields	eb_deg	double	22	√		null	Ecliptic latitude (eb) of field center, degrees
fields	epoch_mjd	double	22				Time (epoch) of field acquisition, MJD, UTC
fields	exp_id	varchar	20	√		null	IPP EXP_ID (full exposure ID)
fields	field_id	bigint	19		√		Auto-assigned internal MOPS field ID
fields	filter_id	char	2	√		null	Filter used for acquisition, g/r/i/z/y/w
fields	fov_deg	double	22	√		null	Field-of-view (diameter [circular] or side [rect], degrees
fields	fpa_id	varchar	20	√		null	IPP EXP_NAME (camera ID)
fields	gb_deg	double	22	√		null	Galactic latitude (gb) of field center, degrees
fields	imfile	varchar	1024	√		null	Image filename
fields	limiting_mag	double	22	√		null	Field limiting magnitude
fields	nn	int	10	√		null	pre-comptued night number
fields	obscode	char	3	√		null	MPC observatory code
fields	ocnum	int	10	√		null	pre-computed observing cycle number
fields	pa_deg	double	22	√		null	Boresight position angle, 0=North
fields	parent_id	bigint	19	√		null	ID of master (final) parent in tuple; NULL to indicate master
fields	ra_deg	double	22				RA, deg, of field center
fields	ra_sigma	double	22	√		null	Uncertainty in RA
fields	se_deg	double	22	√		null	Solar elongation of field center, degrees
fields	status	char	1	√		N	processing status of field
fields	survey_mode	varchar	120	√		null	PS-defined survey mode, e.g. ESS, MSS, 3PI, CAL
fields	time_start	double	22	√		null	Time of field start acquisition, MJD, UTC
fields	time_stop	double	22	√		null	Time of field stop acquisition, MJD, UTC
fields	uncorrected_epoch_mjd	double	22				Uncorrected epoch of field acquisition, MJD, UTC
fields	xyidx_size	int	10	√		null	num of bins in each direction of X/Y index
filter_info	filter_desc	varchar	40	√		null	Description
filter_info	filter_id	char	2				Single-character (usually) filter specification, g/r/i/z/y/w
history	classification	char	1	√		null	MOPS efficiency classification for event
history	d3	float	12	√		null	Computed 3-parameter D-criterion
history	d4	float	12	√		null	Computed 4-parameter D-criterion
history	derivedobject_id	bigint	19	√		null	Referring derived object ID
history	event_id	bigint	19		√		Auto-generated internal event ID
history	event_time	timestamp	19			CURRENT_TIMESTAMP	Timestamp for event creation
history	event_type	char	1				Type of event (A)ttribution/(P)recovery/(D)erivation/(I)dentification/(R)emoval
history	field_id	bigint	19	√		null	Referring field ID generating the event
history	is_lsd	char	1				Y/N if event involves LSD detection
history	last_event_id	bigint	19	√		null	refers to last event that modified this object
history	orbit_code	char	1	√		null	Information about computed orbit
history	orbit_id	bigint	19	√		null	Pointer to resulting orbit
history	ssm_id	bigint	19	√		null	Matching SSM ID for clean classifications
history_attributions	ephemeris_distance	float	12				Predicted position minus actual, arcsecs
history_attributions	ephemeris_uncertainty	float	12	√		null	Predicted error ellipse semi-major axis, arcsecs
history_attributions	event_id	bigint	19				Parent event ID (from history table)
history_attributions	tracklet_id	bigint	19				Attributed tracklet ID
history_derivations	event_id	bigint	19				Parent event ID (from history table)
history_derivations	tracklet_id	bigint	19				Associated tracklet ID (multiple rows per event)
history_identifications	child_orbit_id	bigint	19				Child orbit ID
history_identifications	childobject_id	bigint	19				Matching (child) derived object ID
history_identifications	event_id	bigint	19				Parent event ID (from history table)
history_identifications	parent_orbit_id	bigint	19				Parent orbit ID
history_precoveries	ephemeris_distance	float	12				Predicted minus actual position, arcsecs
history_precoveries	ephemeris_uncertainty	float	12	√		null	Predicted error ellipse semi-major axis, arcsecs
history_precoveries	event_id	bigint	19				Parent event ID (from history table)
history_precoveries	tracklet_id	bigint	19				Precovered tracklet ID
history_removals	event_id	bigint	19				Parent event ID (from history table)
history_removals	object_id	bigint	19				ID of the removed item
history_removals	object_type	varchar	128				Type of object removed. T = Tracklet, D = Derived Object
ingest_status	file_id	varchar	100				IPP datastore file ID
ingest_status	file_size	int	10				Size of file in bytes
ingest_status	file_type	char	12	√		null	Datastore file type (usually ipp-mops)
ingest_status	ingest_date	timestamp	19			CURRENT_TIMESTAMP	Date of ingest
ingest_status	status	char	1	√		N	processing status of field N=new I=ingested
known	arg_peri	double	22				argument of perihelion, deg
known	e	double	22				eccentricity e (dimensionless)
known	epoch	double	22				epoch of osculating elements, MJD
known	h_v	double	22				Absolute magnitude
known	i	double	22				inclination, deg
known	known_id	bigint	19		√		internal table/row ID
known	known_name	varbinary	50	√		null	MPC/IAU name or designation
known	node	double	22				longitude of ascending node, deg
known	q	double	22				semi-major axis, AU
known	time_peri	double	22				time of perihelion, MJD
locks	status	char	1	√		N	Lock status N => non locked, L => locked
locks	table_name	varchar	30	√		null	name of the table to lock/unlock
manual_detections	creation_timestamp	timestamp	19			CURRENT_TIMESTAMP
manual_detections	creator	varchar	20				Who created the detection
manual_detections	det_id	bigint	19				Detection ID from this database
manual_detections	mode	char	8				How the detection was created
manual_detections	related_det_id	bigint	19	√		null	The detection (if any) which is related to this detection
moid_queue	event_id	bigint	19				Referring history event causing insertion
moid_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP	Wall clock time object was queued
moid_queue	orbit_id	bigint	19				Referring orbit
orbits	arc_length_days	double	22	√		null	Arc length of detections used to compute orbit
orbits	arg_peri	double	22				argument of perihelion, deg
orbits	chi_squared	double	22	√		null	chi-squared statistic
orbits	conv_code	varchar	8	√		null	JPL convergence code
orbits	cov_01	double	22	√		null	covariance EC EC (see SQL documentation)
orbits	cov_02	double	22	√		null	covariance EC QR (see SQL documentation)
orbits	cov_03	double	22	√		null	covariance QR QR (see SQL documentation)
orbits	cov_04	double	22	√		null	covariance EC TP (see SQL documentation)
orbits	cov_05	double	22	√		null	covariance QR TP (see SQL documentation)
orbits	cov_06	double	22	√		null	covariance TP TP (see SQL documentation)
orbits	cov_07	double	22	√		null	covariance EC OM (see SQL documentation)
orbits	cov_08	double	22	√		null	covariance QR OM (see SQL documentation)
orbits	cov_09	double	22	√		null	covariance TP OM (see SQL documentation)
orbits	cov_10	double	22	√		null	covariance OM OM (see SQL documentation)
orbits	cov_11	double	22	√		null	covariance EC W (see SQL documentation)
orbits	cov_12	double	22	√		null	covariance QR W (see SQL documentation)
orbits	cov_13	double	22	√		null	covariance TP W (see SQL documentation)
orbits	cov_14	double	22	√		null	covariance OM W (see SQL documentation)
orbits	cov_15	double	22	√		null	covariance W W (see SQL documentation)
orbits	cov_16	double	22	√		null	covariance EC IN (see SQL documentation)
orbits	cov_17	double	22	√		null	covariance QR IN (see SQL documentation)
orbits	cov_18	double	22	√		null	covariance TP IN (see SQL documentation)
orbits	cov_19	double	22	√		null	covariance OM IN (see SQL documentation)
orbits	cov_20	double	22	√		null	covariance W IN (see SQL documentation)
orbits	cov_21	double	22	√		null	covariance IN IN (see SQL documentation)
orbits	e	double	22				eccentricity e (dimensionless)
orbits	epoch	double	22				epoch of osculating elements, MJD
orbits	h_v	double	22				Absolute magnitude
orbits	i	double	22				inclination, deg
orbits	moid_1	double	22	√		null	Minimum orbital intersection distance (MOID) solution 1
orbits	moid_2	double	22	√		null	Minimum orbital intersection distance (MOID) solution 2
orbits	moid_long_1	double	22	√		null	Longitude of MOID 1
orbits	moid_long_2	double	22	√		null	Longitude of MOID 2
orbits	node	double	22				longitude of ascending node, deg
orbits	o_minus_c	double	22	√		null	Vestigial observed-computed position, essentially RMS residual
orbits	orbit_id	bigint	19		√
orbits	q	double	22				semi-major axis, AU
orbits	residual	double	22				RMS residual, arcsec
orbits	time_peri	double	22				time of perihelion, MJD
residuals	ast_reject	char	1	√		null	Set when astrometry reject flag raised for this det
residuals	dec_error_deg	float	12	√		null	DEC error, deg
residuals	dec_resid_deg	float	12	√		null	Residual in DEC
residuals	det_id	bigint	19				ID of detection for this post-fit residual
residuals	ra_error_deg	float	12	√		null	RA error, deg
residuals	ra_resid_deg	float	12	√		null	Residual in RA direction (multiplied by cos(dec))
residuals	tracklet_id	bigint	19				ID of tracklet for this post-fit residual
runs	czared	bit	0			0
runs	field_id	bigint	19			0	ID of processed field in the fields table
runs	run_date	timestamp	19			CURRENT_TIMESTAMP
runs	run_id	bigint	19				Auto-assigned internal MOPS run ID
runs	status	char	1	√		null	Status up to which field was processed during the run
runtime	data	bigint	19	√		null
runtime	date_submitted	timestamp	19			CURRENT_TIMESTAMP
runtime	event_id	bigint	19		√
runtime	message	varchar	250
runtime	status	char	1	√		null
runtime	subsystem	varchar	20
shapes	a_km	double	22	√		null	Triaxial diameter a, km
shapes	amp_mag	double	22	√		null	Maximum amplitude (dimensionless)
shapes	b_km	double	22	√		null	Triaxial diameter b, km
shapes	beta_deg	double	22	√		null	Rotational pole orientation, deg
shapes	c_km	double	22	√		null	Triaxial diameter c, km
shapes	g	double	22	√		null	Slope parameter g (dimensionless)
shapes	lambda_deg	double	22	√		null	Rotational pole orientation, deg
shapes	p	double	22	√		null	Albedo (dimensionless)
shapes	period_d	double	22	√		null	Period, days
shapes	ph_a	double	22	√		null	Phase parameter a (dimensionless)
shapes	ph_d	double	22	√		null	Phase parameter d (dimensionless)
shapes	ph_k	double	22	√		null	Phase parameter k (dimensionless)
shapes	shape_id	bigint	19		√		Auto-generated shape ID
shapes	ssm_id	bigint	19				SSM ID of described object
ssm	albedo	double	22	√		null	Albedo, dimensionless
ssm	arg_peri	double	22				argument of perihelion, deg
ssm	desc_id	bigint	19	√		null	Pointer to SSM description
ssm	e	double	22				eccentricity e (dimensionless)
ssm	epoch	double	22				epoch of osculating elements, MJD
ssm	g	double	22	√		null	Slope parameter g, dimensionless
ssm	h_ss	double	22	√		null	??
ssm	h_v	double	22				Absolute magnitude
ssm	i	double	22				inclination, deg
ssm	moid_1	double	22	√		null	Vestigial, deprecated
ssm	moid_2	double	22	√		null	Vestigial, deprecated
ssm	moid_long_1	double	22	√		null	Vestigial, deprecated
ssm	moid_long_2	double	22	√		null	Vestigial, deprecated
ssm	node	double	22				longitude of ascending node, deg
ssm	object_name	varbinary	32				MOPS synthetic object name
ssm	q	double	22				semi-major axis, AU
ssm	ssm_id	bigint	19		√
ssm	taxonomic_type	char	2	√		null	Asteroid taxonomic type (vestigial, deprecated)
ssm	time_peri	double	22				time of perihelion, MJD
ssm_desc	desc_id	bigint	19		√		Auto-generated row ID
ssm_desc	description	varchar	100	√		null	Long description
ssm_desc	prefix	char	4	√		null	MOPS prefix code S0/S1/etc.
tracklet_attrib	det_id	bigint	19
tracklet_attrib	tracklet_id	bigint	19
tracklets	classification	char	1	√		null	MOPS efficiency classification
tracklets	digest	float	12	√		null	NEO digest
tracklets	ext_dec	double	22	√		null	Extrapolated (central) Dec, deg
tracklets	ext_epoch	double	22	√		null	Extrapolated (central) epoch, MJD
tracklets	ext_mag	double	22	√		null	Extrapolated (central) magnitude
tracklets	ext_ra	double	22	√		null	Extrapolated (central) RA, deg
tracklets	field_id	bigint	19				Terminating field ID
tracklets	gcr_arcsec	float	12	√		null	great-circle residual, arcsec
tracklets	geo_prob	float	12	√		null
tracklets	known_id	bigint	19	√		null	Optional externally-assigned known object ID
tracklets	pchin	float	12	√		null
tracklets	pos_ang_deg	float	12	√		null	Position angle, degrees
tracklets	probability	float	12	√		null	Likelihood tracklet is real (unused currently)
tracklets	ssm_id	bigint	19	√		null	Matching SSM ID for clean classifications
tracklets	status	char	1	√		null	processing status (unfound X, unattributed U, attributed A)
tracklets	tracklet_id	bigint	19		√		Auto-generated internal MOPS tracklet ID
tracklets	v_dec	float	12	√		null	Average Dec velocity, deg/day)
tracklets	v_dec_sigma	float	12	√		null	Uncertainty in Dec velocity
tracklets	v_ra	float	12	√		null	Average RA velocity deg/day, cos(dec) applied
tracklets	v_ra_sigma	float	12	√		null	Uncertainty in RA velocity
tracklets	v_tot	float	12	√		null	Average total velocity, deg/day