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
derivedobjects	derivedobject_id	bigint	19		√		Auto-assigned internal MOPS numeric ID
ssm_desc	desc_id	bigint	19		√		Auto-generated row ID
export_dets	det_export_id	bigint	19		√		detection export id
detections	det_id	bigint	19		√		Auto-defined MOPS internal detection ID
history	event_id	bigint	19		√		Auto-generated internal event ID
runtime	event_id	bigint	19		√
fields	field_id	bigint	19		√		Auto-assigned internal MOPS field ID
known	known_id	bigint	19		√		internal table/row ID
orbits	orbit_id	bigint	19		√
export	revision_id	bigint	19		√		id of revision record created for handling export
shapes	shape_id	bigint	19		√		Auto-generated shape ID
ssm	ssm_id	bigint	19		√
tracklets	tracklet_id	bigint	19		√		Auto-generated internal MOPS tracklet ID
shapes	a_km	double	22	√		null	Triaxial diameter a, km
derivedobjects	albedo	double	22	√		null	Albedo, dimensionless
ssm	albedo	double	22	√		null	Albedo, dimensionless
shapes	amp_mag	double	22	√		null	Maximum amplitude (dimensionless)
derivedobjects	amplitude	double	22	√		null	Amplitude, magnitudes (dimensionless)
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
orbits	arc_length_days	double	22	√		null	Arc length of detections used to compute orbit
known	arg_peri	double	22				argument of perihelion, deg
orbits	arg_peri	double	22				argument of perihelion, deg
ssm	arg_peri	double	22				argument of perihelion, deg
residuals	ast_reject	char	1	√		null	Set when astrometry reject flag raised for this det
shapes	b_km	double	22	√		null	Triaxial diameter b, km
shapes	beta_deg	double	22	√		null	Rotational pole orientation, deg
deteff	bin_end	float	12	√		null	End of magnitude bin
deteff	bin_start	float	12	√		null	Start of magnitude bin
shapes	c_km	double	22	√		null	Triaxial diameter c, km
det_rawattr_v2	cal_psf_mag	float	12	√		null
det_rawattr_v2	cal_psf_mag_sig	float	12	√		null
orbits	chi_squared	double	22	√		null	chi-squared statistic
history_identifications	child_orbit_id	bigint	19				Child orbit ID
history_identifications	childobject_id	bigint	19				Matching (child) derived object ID
det_rawattr_v3	chin	float	12	√		null
derivedobjects	classification	char	1	√		null	MOPS efficiency classification (C/M/B/N/X)
history	classification	char	1	√		null	MOPS efficiency classification for event
tracklets	classification	char	1	√		null	MOPS efficiency classification
config	config_text	text	65535	√		null	Config contents
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)
det_rawattr_v2	cr_sig	float	12	√		null
config	created	timestamp	19			CURRENT_TIMESTAMP	Creation timestamp
derivedobjects	created	timestamp	19			CURRENT_TIMESTAMP	Timestamp for derived object creation
manual_detections	creation_timestamp	timestamp	19			CURRENT_TIMESTAMP
manual_detections	creator	varchar	20				Who created the detection
runs	czared	bit	0			0
history	d3	float	12	√		null	Computed 3-parameter D-criterion
history	d4	float	12	√		null	Computed 4-parameter D-criterion
runtime	data	bigint	19	√		null
runtime	date_submitted	timestamp	19			CURRENT_TIMESTAMP
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
detections	dec_deg	double	22				Dec, deg
fields	dec_deg	double	22				Dec, deg, of field center
residuals	dec_error_deg	float	12	√		null	DEC error, deg
residuals	dec_resid_deg	float	12	√		null	Residual in DEC
fields	dec_sigma	double	22	√		null	Uncertainty in Dec
detections	dec_sigma_deg	float	12	√		null	Working 1-sigma uncertainty in Dec, deg
derivedobject_attrib	derivedobject_id	bigint	19
eon_queue	derivedobject_id	bigint	19				Referring derived object
history	derivedobject_id	bigint	19	√		null	Referring derived object ID
ssm	desc_id	bigint	19	√		null	Pointer to SSM description
ssm_desc	description	varchar	100	√		null	Long description
det_rawattr_v2	det_id	bigint	19	√		null	Source det_id
det_rawattr_v3	det_id	bigint	19	√		null	Source det_id
det_sig	det_id	bigint	19
export_dets	det_id	bigint	19	√		null	id of detection from table detections
manual_detections	det_id	bigint	19				Detection ID from this database
residuals	det_id	bigint	19				ID of detection for this post-fit residual
tracklet_attrib	det_id	bigint	19
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
fields	diff_id	varchar	20	√		null	IPP DIFF_ID (image diff 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
tracklets	digest	float	12	√		null	NEO digest
det_rawattr_v3	dirty	int	10	√		null
export	do_export_id	bigint	19	√		null	ID of Derived Object
det_rawattr_v3	dstar	int	10	√		null
known	e	double	22				eccentricity e (dimensionless)
orbits	e	double	22				eccentricity e (dimensionless)
ssm	e	double	22				eccentricity e (dimensionless)
fields	eb_deg	double	22	√		null	Ecliptic latitude (eb) of field center, degrees
deteff	eff_type	enum	9	√		null	type of efficiency, tracklet or detection
history_attributions	ephemeris_distance	float	12				Predicted position minus actual, arcsecs
history_precoveries	ephemeris_distance	float	12				Predicted minus actual position, arcsecs
history_attributions	ephemeris_uncertainty	float	12	√		null	Predicted error ellipse semi-major axis, arcsecs
history_precoveries	ephemeris_uncertainty	float	12	√		null	Predicted error ellipse semi-major axis, arcsecs
known	epoch	double	22				epoch of osculating elements, MJD
orbits	epoch	double	22				epoch of osculating elements, MJD
ssm	epoch	double	22				epoch of osculating elements, MJD
detections	epoch_mjd	double	22				Exact time of detection acquistion, not necessarily constant across field
fields	epoch_mjd	double	22				Time (epoch) of field acquisition, MJD, UTC
eon_queue	event_id	bigint	19				Referring history event causing insertion
history_attributions	event_id	bigint	19				Parent event ID (from history table)
history_derivations	event_id	bigint	19				Parent event ID (from history table)
history_identifications	event_id	bigint	19				Parent event ID (from history table)
history_precoveries	event_id	bigint	19				Parent event ID (from history table)
history_removals	event_id	bigint	19				Parent event ID (from history table)
moid_queue	event_id	bigint	19				Referring history event causing insertion
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
fields	exp_id	varchar	20	√		null	IPP EXP_ID (full exposure ID)
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
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
det_rawattr_v2	ext_sig	float	12	√		null
det_rawattr_v2	f_pos	float	12	√		null
detections	field_id	bigint	19	√		null	Source field ID containing this detection
history	field_id	bigint	19	√		null	Referring field ID generating the event
runs	field_id	bigint	19			0	ID of processed field in the fields table
tracklets	field_id	bigint	19				Terminating field ID
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)
filter_info	filter_desc	varchar	40	√		null	Description
detections	filter_id	char	2				Filter used for this detection
deteff	filter_id	char	1	√		null	PS1 filter
fields	filter_id	char	2	√		null	Filter used for acquisition, g/r/i/z/y/w
filter_info	filter_id	char	2				Single-character (usually) filter specification, g/r/i/z/y/w
det_rawattr_v2	flags	int	10	√		null
det_rawattr_v2	flags2	int	10	√		null
deteff	found	int	10	√		null	Number of found objects in bin
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)
derivedobjects	g	double	22	√		null	Slope parameter g
shapes	g	double	22	√		null	Slope parameter g (dimensionless)
ssm	g	double	22	√		null	Slope parameter g, dimensionless
fields	gb_deg	double	22	√		null	Galactic latitude (gb) of field center, degrees
tracklets	gcr_arcsec	float	12	√		null	great-circle residual, arcsec
tracklets	geo_prob	float	12	√		null
ssm	h_ss	double	22	√		null	??
known	h_v	double	22				Absolute magnitude
orbits	h_v	double	22				Absolute magnitude
ssm	h_v	double	22				Absolute magnitude
known	i	double	22				inclination, deg
orbits	i	double	22				inclination, deg
ssm	i	double	22				inclination, deg
fields	imfile	varchar	1024	√		null	Image filename
ingest_status	ingest_date	timestamp	19			CURRENT_TIMESTAMP	Date of ingest
eon_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP	Wall clock time object was queued
moid_queue	insert_timestamp	timestamp	19			CURRENT_TIMESTAMP	Wall clock time object was queued
det_rawattr_v2	ipp_idet	int	10	√		null
history	is_lsd	char	1				Y/N if event involves LSD detection
detections	is_synthetic	char	1	√		null	efficiency marker; indicates detection is synthetic
deteff	known	int	10	√		null	Number of known objects in bin
tracklets	known_id	bigint	19	√		null	Optional externally-assigned known object ID
known	known_name	varbinary	50	√		null	MPC/IAU name or designation
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
shapes	lambda_deg	double	22	√		null	Rotational pole orientation, deg
history	last_event_id	bigint	19	√		null	refers to last event that modified this object
detections	length_deg	float	12	√		null	Length of detection, deg
fields	limiting_mag	double	22	√		null	Field limiting magnitude
detections	mag	float	12				Apparent magnitude of detection
detections	mag_sigma	float	12	√		null	Uncertainty in magnitude
runtime	message	varchar	250
manual_detections	mode	char	8				How the detection was created
orbits	moid_1	double	22	√		null	Minimum orbital intersection distance (MOID) solution 1
ssm	moid_1	double	22	√		null	Vestigial, deprecated
orbits	moid_2	double	22	√		null	Minimum orbital intersection distance (MOID) solution 2
ssm	moid_2	double	22	√		null	Vestigial, deprecated
orbits	moid_long_1	double	22	√		null	Longitude of MOID 1
ssm	moid_long_1	double	22	√		null	Vestigial, deprecated
orbits	moid_long_2	double	22	√		null	Longitude of MOID 2
ssm	moid_long_2	double	22	√		null	Vestigial, deprecated
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
derivedobjects	mops_classification	char	3	√		null	3-char MOPS asteroid classification
export_dets	mpc_accepted	char	1	√		null	{Y|N} for accepted by MPC
det_rawattr_v3	mstar	float	12	√		null
det_rawattr_v2	n_frames	int	10	√		null
det_rawattr_v2	n_pos	int	10	√		null
deteff	nn	int	10	√		null	MOPS night number
fields	nn	int	10	√		null	pre-comptued night number
known	node	double	22				longitude of ascending node, deg
orbits	node	double	22				longitude of ascending node, deg
ssm	node	double	22				longitude of ascending node, deg
orbits	o_minus_c	double	22	√		null	Vestigial observed-computed position, essentially RMS residual
history_removals	object_id	bigint	19				ID of the removed item
derivedobjects	object_name	varbinary	32	√		null	MOPS base-64 object name
detections	object_name	varbinary	32	√		null	Originating SSM object name, if synthetic
ssm	object_name	varbinary	32				MOPS synthetic object name
history_removals	object_type	varchar	128				Type of object removed. T = Tracklet, D = Derived Object
detections	obscode	char	3	√		null	MPC observatory code
fields	obscode	char	3	√		null	MPC observatory code
fields	ocnum	int	10	√		null	pre-computed observing cycle number
history	orbit_code	char	1	√		null	Information about computed orbit
derivedobjects	orbit_id	bigint	19	√		null	Pointer to current orbit
history	orbit_id	bigint	19	√		null	Pointer to resulting orbit
moid_queue	orbit_id	bigint	19				Referring orbit
detections	orient_deg	float	12	√		null	Orientation of detection, deg; 0 => N, + toward E
shapes	p	double	22	√		null	Albedo (dimensionless)
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
history_identifications	parent_orbit_id	bigint	19				Parent orbit ID
tracklets	pchin	float	12	√		null
det_rawattr_v3	peak	int	10	√		null
det_rawattr_v2	peak_flux_as_mag	float	12	√		null
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)
derivedobjects	pole_lat	double	22	√		null	Rotation pole latitude, deg
derivedobjects	pole_long	double	22	√		null	Rotation pole longitude, deg
tracklets	pos_ang_deg	float	12	√		null	Position angle, degrees
det_rawattr_v3	preal	float	12	√		null
ssm_desc	prefix	char	4	√		null	MOPS prefix code S0/S1/etc.
tracklets	probability	float	12	√		null	Likelihood tracklet is real (unused currently)
detections	proc_id	bigint	19	√		null	opaque IPP processing identifier (usually DIFFIM_ID)
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_v3	pstar	float	12	√		null
known	q	double	22				semi-major axis, AU
orbits	q	double	22				semi-major axis, AU
ssm	q	double	22				semi-major axis, AU
detections	ra_deg	double	22				RA, deg
fields	ra_deg	double	22				RA, deg, of field center
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))
fields	ra_sigma	double	22	√		null	Uncertainty in RA
detections	ra_sigma_deg	float	12	√		null	Working 1-sigma uncertainty in RA, deg
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_sig	rdcorr	float	12	√		null
detections	ref_mag	float	12	√		null	Reference magnitude before shape modulation applied (for synth dets)
manual_detections	related_det_id	bigint	19	√		null	The detection (if any) which is related to this detection
export_dets	removal	char	1	√		null	flag to indicate that the detection is to be removed
orbits	residual	double	22				RMS residual, arcsec
export_dets	rev_id	bigint	19	√		null	id of revision from table export
export	rev_time	datetime	19	√		null	time of revision processing
derivedobjects	rotation_epoch	double	22	√		null	Rotation time origin, MJD
derivedobjects	rotation_period	double	22	√		null	Rotation period, days
runs	run_date	timestamp	19			CURRENT_TIMESTAMP
runs	run_id	bigint	19				Auto-assigned internal MOPS run ID
detections	s2n	float	12	√		null	Detection signal-to-noise
fields	se_deg	double	22	√		null	Solar elongation of field center, degrees
det_rawattr_v2	sky	float	12	√		null
det_rawattr_v3	sky	float	12	√		null
det_rawattr_v2	sky_sigma	float	12	√		null
derivedobjects	ssm_id	bigint	19	√		null	Source SSM obje t for C classification
history	ssm_id	bigint	19	√		null	Matching SSM ID for clean classifications
shapes	ssm_id	bigint	19				SSM ID of described object
tracklets	ssm_id	bigint	19	√		null	Matching SSM ID for clean classifications
derivedobjects	stable_pass	char	1	√		null	NULL, or set to Y when stable precovery pass completed
det_rawattr_v3	star	int	10	√		null
derivedobjects	status	char	1	√		null	NULL, or set to M when DO is merged with parent
detections	status	char	1	√		null	efficiency marker; indicates detection was detected (not lost in chip gap, etc.)
eon_queue	status	char	1	√		N	Processing status N => new, I => ID1 done, P => precov done, X => finished
fields	status	char	1	√		N	processing status of field
ingest_status	status	char	1	√		N	processing status of field N=new I=ingested
locks	status	char	1	√		N	Lock status N => non locked, L => locked
runs	status	char	1	√		null	Status up to which field was processed during the run
runtime	status	char	1	√		null
tracklets	status	char	1	√		null	processing status (unfound X, unattributed U, attributed A)
runtime	subsystem	varchar	20
fields	survey_mode	varchar	120	√		null	PS-defined survey mode, e.g. ESS, MSS, 3PI, CAL
locks	table_name	varchar	30	√		null	name of the table to lock/unlock
derivedobjects	taxonomic_type	char	2	√		null	Asteroid taxonomic type
ssm	taxonomic_type	char	2	√		null	Asteroid taxonomic type (vestigial, deprecated)
known	time_peri	double	22				time of perihelion, MJD
orbits	time_peri	double	22				time of perihelion, MJD
ssm	time_peri	double	22				time of perihelion, MJD
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
export	tracklet_export_id	bigint	19	√		null	Tracklet ID of tracklet with known_id
derivedobject_attrib	tracklet_id	bigint	19
history_attributions	tracklet_id	bigint	19				Attributed tracklet ID
history_derivations	tracklet_id	bigint	19				Associated tracklet ID (multiple rows per event)
history_precoveries	tracklet_id	bigint	19				Precovered tracklet ID
residuals	tracklet_id	bigint	19				ID of tracklet for this post-fit residual
tracklet_attrib	tracklet_id	bigint	19
det_sig	tsig	float	12	√		null
fields	uncorrected_epoch_mjd	double	22				Uncorrected epoch of field acquisition, MJD, UTC
derivedobjects	updated	timestamp	19			0000-00-00 00:00:00	Timestamp for derived object modification
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
det_rawattr_v3	vtflags	varchar	8	√		null
det_sig	xsig	float	12	√		null
detections	xyidx	int	10	√		null	XY spatial index number within field
fields	xyidx_size	int	10	√		null	num of bins in each direction of X/Y index