Access Denied DeprecatedMPC Database Tables Schema Access Denied

MPC Database Tables Schema

The MPC makes its PostgreSQL database of observations and orbits available for replication via the SBN. Displayed below are two tables.

The first table lists the tables and a description of its contents.
The second table displayed lists each table and each field within each table and a description of it.

A machine-readable format of the table and its content description can be downloaded here.
A machine-readable format of each table and its schema can be downloaded here.
To order the columns click the header to sort the data.

Last Updated: 2024-05-01

Table Name	Description
current_identifications	Table containing all the primary designations (minor planets, comets and natural satellites) and their secondary designations, when available.
neocp_var	Table containing variant orbits for every object on the NEOCP
neocp_events	Table containing NEOCP related processing events
neocp_obs	Table containing observations for objects currently on the NEOCP
neocp_obs_archive	Table containing archived NEOCP observations
neocp_prev_des	Table containing objects that were previously listed on the NEOCP, their designation if designated and the reasons for their removal
obs_alterations_corrections	Table used to record the corrections made to the observations that have been published.
obs_alterations_redesignations	Table used to record the observations that have been redesignated
obs_alterations_deletions	Table used to record the corrections made to the observations that have been published by the MPC (in an MPEC, DOU or monthly circular) and that have have been also deleted
obs_alterations_unassociations	Table used to record the observations that were unassociated from their original designation and relocated to the Isolated Tracklet File (ITF)
neocp_els	Table containing the nominal orbital element for each tracklet that is currently on the NEOCP
numbered_identifications	Table containing the number and primary provisional designation for any object that have been numbered.
primary_objects	Table used to keep a record of all the primary designations for minor planets, comets and natural satellites that have been designated by the MPC.

Last Updated: 2024-05-01

Table Name	Column	Data Type	DateTime Precision (if applicable)	Description
current_identifications	created_at	timestamp	6	Date and time of initial row insert
current_identifications	id	int4	None	PostgreSQL automatically generated identifier
current_identifications	identifier_ids	_text	None	List of unique identifiers used by the MPC to track credit for correct identifications
current_identifications	numbered	bool	None	Flag indicating if the primary designation is also numbered (True if it numbered, False if it is not numbered)
current_identifications	object_type	int4	None	Object classification based on its orbital element. For more information please see https://minorplanetcenter.net/mpcops/documentation/object-types/
current_identifications	packed_primary_provisional_designation	text	None	Packed form of the primary provisional designation (e.g. K17P08M).
current_identifications	packed_secondary_provisional_designation	text	None	Packed form of one of the secondary provisional designations (e.g. K06Sf5M).
current_identifications	published	int4	None	Integer describing the publication status of the identification: 0=not published, 1=published in an MPEC, 2=published in the DOU, 3=published in a mid-month circular, 4=published in a monthly circular
current_identifications	unpacked_primary_provisional_designation	text	None	Unpacked form of the primary provisional designation (e.g. 2017 PM8).
current_identifications	unpacked_secondary_provisional_designation	text	None	Unpacked form of one of the secondary provisional designations (e.g. 2006 SM415).
current_identifications	updated_at	timestamp	6	Date and time of latest row update
mpc_orbits	a	float8	None	Semi-major axis [au]
mpc_orbits	a1	float8	None	A1 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbits	a1_unc	float8	None	Post-fit 1-sigma uncertainty in the A1 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbits	a2	float8	None	A2 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbits	a2_unc	float8	None	Post-fit 1-sigma uncertainty in the A2 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbits	a3	float8	None	A3 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbits	a3_unc	float8	None	Post-fit 1-sigma uncertainty in the A3 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbits	arc_length_sel	float8	None	Arc length of all the observations selected by the fit, computed as the difference between the time of the last selected observations and the time of the first selected observation.
mpc_orbits	arc_length_total	float8	None	Arc length of all the observations associated to the object, computed as the difference between the time of the last observations and the time of the first observation.
mpc_orbits	argperi	float8	None	Argument of the pericenter [degrees]
mpc_orbits	argperi_unc	float8	None	Post-fit 1-sigma uncertainty in the argument of the pericenter [degrees]
mpc_orbits	a_unc	float8	None	Post-fit 1-sigma uncertainty in the semi-major axis [au]
mpc_orbits	created_at	timestamp	6	Date and time of initial row insert
mpc_orbits	dt	float8	None	DeltaT component of the non-gravitational acceleration [days]
mpc_orbits	dt_unc	float8	None	Post-fit 1-sigma uncertainty in the DeltaT component of the non-gravitational acceleration [days]
mpc_orbits	e	float8	None	Eccentricity
mpc_orbits	earth_moid	float8	None	Minimum Orbit Intersection Distance [au] with respect to the orbit of the Earth.
mpc_orbits	epoch_mjd	float8	None	Orbit epoch [TT, MJD]
mpc_orbits	e_unc	float8	None	Post-fit 1-sigma uncertainty in the eccentricity
mpc_orbits	fitting_datetime	timestamp	6	Date and time recorded when the orbital fit was performed
mpc_orbits	g	float8	None	Slope parameter
mpc_orbits	h	float8	None	Absolute magnitude as computed by OrbFit
mpc_orbits	i	float8	None	Inclination [degrees]
mpc_orbits	id	int4	None	PostgreSQL automatically generated identifier
mpc_orbits	i_unc	float8	None	Post-fit 1-sigma uncertainty in the inclination [degrees]
mpc_orbits	mean_anomaly	float8	None	Mean anomaly [degrees]
mpc_orbits	mean_anomaly_unc	float8	None	Post-fit 1-sigma uncertainty in the mean anomaly [degrees]
mpc_orbits	mean_motion	float8	None	Orbital mean motion [degrees per day]
mpc_orbits	mean_motion_unc	float8	None	Post-fit 1-sigma uncertainty in the mean motion [degrees]
mpc_orbits	mpc_orb_jsonb	jsonb	None	MPC JSON format used to describe MPC orbits. The public python package is available as part of the MPC public Gitub https://github.com/Smithsonian/mpc-public/ with additional information.
mpc_orbits	nobs_total	int4	None	Total number of observations associated to the object.
mpc_orbits	nobs_total_sel	int4	None	Total number of observations used by the fit.
mpc_orbits	node	float8	None	Longitude of the ascending node [degrees]
mpc_orbits	node_unc	float8	None	Post-fit 1-sigma uncertainty in the longitude of the node [degrees]
mpc_orbits	nopp	int4	None	MPC computed number of oppositions.
mpc_orbits	normalized_rms	float8	None	Normalized post-fit RMS
mpc_orbits	not_normalized_rms	float8	None	Not normalized post-fit RMS [arcseconds]
mpc_orbits	orbit_type_int	int4	None	Orbit classification based on the object orbital element. For more information please see https://minorplanetcenter.net/mpcops/documentation/orbit-types/
mpc_orbits	packed_primary_provisional_designation	text	None	Packed form of the primary provisional designation (e.g. K17P08M).
mpc_orbits	period	float8	None	Orbital period [days]
mpc_orbits	period_unc	float8	None	Post-fit 1-sigma uncertainty in the orbital period [days]
mpc_orbits	peri_time	float8	None	Time of the passage at the pericenter [days]
mpc_orbits	peri_time_unc	float8	None	Post-fit 1-sigma uncertainty in the time of the pericenter passage [days]
mpc_orbits	q	float8	None	Perihelion distance [au]
mpc_orbits	q_unc	float8	None	Post-fit 1-sigma uncertainty in the perihelion distance [au]
mpc_orbits	srp	float8	None	Solar radiation pressure [m^2/ton]
mpc_orbits	srp_unc	float8	None	Post-fit 1-sigma uncertainty in the solar radiation pressure [m^2/ton]
mpc_orbits	unpacked_primary_provisional_designation	text	None	Unpacked form of the primary provisional designation (e.g. 2017PM8).
mpc_orbits	u_param	int4	None	MPC defined U parameter. For more information please see https://www.minorplanetcenter.net/iau/info/UValue.html.
mpc_orbits	updated_at	timestamp	6	Date and time of latest row update
mpc_orbits	yarkovsky	float8	None	A2 component of the Yarkovsky acceleration [10^(-10) au/d^2]
mpc_orbits	yarkovsky_unc	float8	None	Post-fit 1-sigma uncertainty in the A2 component of the Yarkovsky acceleration [10^(-10) au/d^2]
neocp_els	comet	bpchar	None	Flag=C indicating that the object is a comet. If the flag is present, the object can also be found on the PCCP (https://minorplanetcenter.net/iau/NEO/pccp_tabular.html)
neocp_els	created_at	timestamp	6	Date and time of initial row insert
neocp_els	desig	varchar	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_els	digest2	numeric	None	Digest2 score. For more information see https://ui.adsabs.harvard.edu/abs/2019PASP..131f4501K/abstract and https://ui.adsabs.harvard.edu/abs/2023PASP..135j4505V/abstract
neocp_els	dsc_obs	varchar	None	80 or 160-character observation string of the discovery observation.
neocp_els	els	varchar	None	Orbital element string in the MPC ele220 format.
neocp_els	flag	bpchar	None	Flag defining if an object is an articial satellite. Flag=S means that the object matched the TLEs of an artificial satellite; Flag=s means that the object did not match any known artificial satellite, but it looks like one (e.g. high geocentric score)
neocp_els	id	int4	None	PostgreSQL automatically generated identifier
neocp_els	prep	bpchar	None	Flag=P indicating that the object is being prepared for removal
neocp_els	updated_at	timestamp	6	Date and time of latest row update
neocp_events	created_at	timestamp	6	Date and time of initial row insert
neocp_events	desig	text	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_events	event_text	text	None	A full description of the event type for each object, e.g. Additional obs posted to NEOCP or Object designated K23W00001U (MPEC 2023-W67)
neocp_events	event_type	text	None	Event type, e.g. update, add, remove object
neocp_events	event_user	text	None	User name of who/what processed the event, e.g. process_newneo (automated process), dbell (human)
neocp_events	id	int4	None	PostgreSQL automatically generated identifier
neocp_events	updated_at	timestamp	6	Date and time of latest row update
neocp_obs	created_at	timestamp	6	Date and time of initial row insert
neocp_obs	desig	varchar	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_obs	force_code	text	None	This column is currently unused.
neocp_obs	id	int4	None	PostgreSQL automatically generated identifier
neocp_obs	obs80	varchar	None	80 or 160-Character observation string
neocp_obs	rmscorr	numeric	None	ADES: correlation between RA and Dec, as estimated by the observer. This is derived from the RA-Dec covariance matrix, where the off-diagonal term is rmsCorr x rmsRA x rmsDec
neocp_obs	rmsdec	numeric	None	ADES: random component of the Dec uncertainty in arcsec as estimated by the observer
neocp_obs	rmsra	numeric	None	ADES: random component of the RA*cos(Dec) uncertainty in arcsec as estimated by the observer
neocp_obs	rmstime	numeric	None	ADES: random uncertainty in time in seconds as estimated by the observer
neocp_obs	trkid	text	None	Globally Unique alphnumeric tracklet identifier assigned by MPC
neocp_obs	updated_at	timestamp	6	Date and time of latest row update
neocp_obs_archive	created_at	timestamp	6	Date and time of initial row insert
neocp_obs_archive	desig	varchar	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_obs_archive	force_code	text	None	This column is currently unused.
neocp_obs_archive	id	int4	None	PostgreSQL automatically generated identifier
neocp_obs_archive	obs80	varchar	None	80 or 160-Character observation string
neocp_obs_archive	rmscorr	numeric	None	ADES: correlation between RA and Dec, as estimated by the observer. This is derived from the RA-Dec covariance matrix, where the off-diagonal term is rmsCorr x rmsRA x rmsDec
neocp_obs_archive	rmsdec	numeric	None	ADES: random component of the Dec uncertainty in arcsec as estimated by the observer
neocp_obs_archive	rmsra	numeric	None	ADES: random component of the RA*cos(Dec) uncertainty in arcsec as estimated by the observer
neocp_obs_archive	rmstime	numeric	None	ADES: random uncertainty in time in seconds as estimated by the observer
neocp_obs_archive	trkid	text	None	Globally Unique alphnumeric tracklet identifier assigned by MPC
neocp_obs_archive	updated_at	timestamp	6	Date and time of latest row update
neocp_prev_des	created_at	timestamp	6	Date and time of initial row insert
neocp_prev_des	desig	text	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_prev_des	digest2	numeric	None	Digest2 score. For more information see https://ui.adsabs.harvard.edu/abs/2019PASP..131f4501K/abstract and https://ui.adsabs.harvard.edu/abs/2023PASP..135j4505V/abstract
neocp_prev_des	iau_desig	text	None	Unpacked provisional designation, as specified by the IAU (for more information see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#unpacked_provid)
neocp_prev_des	id	int4	None	PostgreSQL automatically generated identifier
neocp_prev_des	pkd_desig	text	None	Extended packed provisional designation (for more information see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#extended_packed_provid)
neocp_prev_des	ref	text	None	MPEC reference (see https://minorplanetcenter.net/iau/info/References.html)
neocp_prev_des	status	text	None	Reasons for removal (see https://minorplanetcenter.net/mpcops/documentation/neocp-prev-des-removal/)
neocp_prev_des	updated_at	timestamp	6	Date and time of latest row update
neocp_var	created_at	timestamp	6	Date and time of initial row insert
neocp_var	desig	varchar	None	Observer-assigned object identifier, unique within a submission batch. It could have been altered by the MPC if linking has been performed between NEOCP objects.
neocp_var	els	varchar	None	Orbital element string for each variant orbit in ele220 format
neocp_var	id	int4	None	PostgreSQL automatically generated identifier
neocp_var	updated_at	timestamp	6	Date and time of latest row update
numbered_identifications	created_at	timestamp	6	Date and time of initial row insert
numbered_identifications	iau_designation	text	None	This column is currently unused.
numbered_identifications	iau_name	text	None	This column is currently unused. The MPC is not responsible for naming.
numbered_identifications	id	int4	None	PostgreSQL automatically generated identifier
numbered_identifications	named_publication_references	_text	None	This column is currently unused. The MPC is not responsible for naming.
numbered_identifications	naming_credit	text	None	This column is currently unused. The MPC is not responsible for naming.
numbered_identifications	numbered_publication_references	_text	None	List of references to any MPC publication(s) including information on the numbering of the corresponding object (e.g. Monthly circulars, etc)
numbered_identifications	packed_primary_provisional_designation	text	None	Packed form of the primary provisional designation (e.g. J81E29H ).
numbered_identifications	permid	text	None	Unpacked form of the permanent designation (number without parenthesis, e.g. "500000")
numbered_identifications	unpacked_primary_provisional_designation	text	None	Unpacked form of the primary provisional designation (e.g. 1981 EH29).
numbered_identifications	updated_at	timestamp	6	Date and time of latest row update
obs_alterations_corrections	created_at	timestamp	6	Date and time of initial row insert
obs_alterations_corrections	id	int4	None	PostgreSQL automatically generated identifier
obs_alterations_corrections	obsid_new	text	None	Unique MPC assigned observation ID (in the obs_sbn table) of the new corrected observation
obs_alterations_corrections	obsid_old	text	None	Unique MPC assigned observation ID (in the obs_sbn table) of the wrong observation that was replaced
obs_alterations_corrections	publication_ref	_text	None	Array of references to the publications announcing the correction
obs_alterations_corrections	updated_at	timestamp	6	Date and time of latest row update
obs_alterations_deletions	created_at	timestamp	6	Date and time of initial row insert
obs_alterations_deletions	id	int4	None	PostgreSQL automatically generated identifier
obs_alterations_deletions	obsid	text	None	Unique MPC assigned observation ID (in the obs_sbn table) of the deleted observation
obs_alterations_deletions	publication_ref	_text	None	Array of references to the publications announcing the deletion
obs_alterations_deletions	status	int4	None	Integer describing the publication status: 0=Unpublished (waiting for publication), 1=Published in the DOU, 2=Published in the Monthy Circular
obs_alterations_deletions	updated_at	timestamp	6	Date and time of latest row update
obs_alterations_redesignations	created_at	timestamp	6	Date and time of initial row insert
obs_alterations_redesignations	id	int4	None	PostgreSQL automatically generated identifier
obs_alterations_redesignations	new_designation_created	bool	None	Boolean to indicate whether a new designation was created as a result of the redesignations: True=a new designation was created, False=the tracklets were associated to an already existing object
obs_alterations_redesignations	obsid	text	None	Unique MPC assigned observation ID (in the obs_sbn table) of the deleted observation
obs_alterations_redesignations	packed_provisional_designation_from	text	None	Previous packed provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#packed_provid)
obs_alterations_redesignations	packed_provisional_designation_to	text	None	New packed provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#packed_provid)
obs_alterations_redesignations	publication_ref	_text	None	Array of references to the publications announcing the redesignation
obs_alterations_redesignations	status	int4	None	Integer describing the publication status: 0=Unpublished (waiting for publication), 1=Published in the DOU, 2=Published in the Monthy Circular
obs_alterations_redesignations	unpacked_provisional_designation_from	text	None	Previous unpacked provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#unpacked_provid)
obs_alterations_redesignations	unpacked_provisional_designation_to	text	None	New unpacked provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#unpacked_provid)
obs_alterations_redesignations	updated_at	timestamp	6	Date and time of latest row update
obs_alterations_unassociations	created_at	timestamp	6	Date and time of initial row insert
obs_alterations_unassociations	id	int4	None	PostgreSQL automatically generated identifier
obs_alterations_unassociations	obsid	text	None	Unique MPC assigned observation ID (in the obs_sbn table) of the deleted observation
obs_alterations_unassociations	packed_provisional_designation_from	text	None	Previous packed provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#packed_provid)
obs_alterations_unassociations	publication_ref	_text	None	Array of references to the publications announcing the unassociation
obs_alterations_unassociations	trkmpc_to	text	None	New MPC object identifier used to label the observations in the ITF (for information on the ITF, please see https://minorplanetcenter.net/mpcops/documentation/identifications/)
obs_alterations_unassociations	unpacked_provisional_designation_from	text	None	Previous unpacked provisional designation (for information on the unpacked provisional designation see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/#unpacked_provid)
obs_alterations_unassociations	updated_at	timestamp	6	Date and time of latest row update
obs_sbn	all_pub_ref	_text	None	MPC_ops: Array of publication references that contained any information about the observation
obs_sbn	artsat	text	None	ADES: Artificial satellite identifier
obs_sbn	astcat	text	None	ADES: Star catalog used for the astrometric reduction or, in case of occultation observations, for the occulted star (a list of accepted astcat values is availble at the following link https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#astCat)
obs_sbn	band	text	None	ADES: Passband designation for photometry (a list of accepted astcat values is availble at the following link https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#band)
obs_sbn	com	int2	None	ADES: Flag to indicate that the observation is reduced to the center of mass. Values are 1=True, 0=False. False implies a measurement to the peak power position
obs_sbn	created_at	timestamptz	6	MPC_ops: Date and time of initial row insert
obs_sbn	ctr	int4	None	ADES: Origin of the reference system given by the coordinate frame (sys). Use public SPICE codes for possible values (https://naif.jpl.nasa.gov/pub/naif/toolkit_docs/C/req/naif_ids.html), e.g. 399=geocenter
obs_sbn	dec	numeric	None	ADES: Declination is decimal degrees in J2000.0 reference frame
obs_sbn	decstar	numeric	None	ADES: For occultation, only when stn=244, Declination in the J2000.0 reference frame in decimal degress of the occulted star.
obs_sbn	delay	numeric	None	ADES: Observed radar time delay in seconds
obs_sbn	deltadec	numeric	None	ADES: Measured DeltaDec in arcsec in the J2000.0 reference frame for offset measurements of a satellite with respect to osbCenter, or for occultation observations with respect to the star (only if stn=244)
obs_sbn	deltara	numeric	None	ADES: Measured DeltaRA*cos(Dec) in arcsec in the J2000.0 reference frame for offset measurements of a satellite with respect to osbCenter, or for occultation observations with respect to the star (stn=244)
obs_sbn	deprecated	bpchar	None	ADES: Deprecated observation that is preserved for historical purpose. Do not use it in the orbit fitting. The only allowed value is X
obs_sbn	designation_asterisk	bool	None	MPC_ops: Equivalent of the asterisks used to mark initial tracklets for component provisional designations. One object can have multiple discovery_asterisks
obs_sbn	disc	bpchar	None	ADES: Discovery flag (more documentation needs to be added here).
obs_sbn	dist	numeric	None	ADES: Measured distance in arcsec in degrees in the J2000.0 reference frame for offset measurements of a satellite wrt obsCenter, or for occultation observations wrt the star (only if stn=244)
obs_sbn	doppler	numeric	None	ADES: Observed radar Doppler shift in Hz
obs_sbn	exp	numeric	None	ADES: Exposure time in seconds
obs_sbn	frq	numeric	None	ADES: Carrier reference frequency in MHz
obs_sbn	group_id	text	None	MPC_ops: Observation group identifier used to group duplicate/near-duplicate observations. This field is not currently used
obs_sbn	healpix	int8	None	MPC_ops: A convenience calculation that maps the observed (Ra,Dec) to a healpix (healpix.sourceforge.io) patch of the sky indicated by the recorded integer. The chosen mapping assumes nside = 32768 & nested = True (see https://astropy-healpix.readthedocs.io/en/latest/coordinates.html), corresponding to a pixel scale of approx 6.4 arcsec.
obs_sbn	id	int4	None	MPC_ops: PostgreSQL automatically generated identifier
obs_sbn	localuse	text	None	ADES: Container to hold subelements carrying ancillary information not envisioned by the standard
obs_sbn	logsnr	numeric	None	ADES: The log10 of the signal-to-noise ratio of the source in the image integrated on the entire aperture used for astrometric centroid
obs_sbn	mag	numeric	None	ADES: Apparent magnitude in specified band
obs_sbn	mode	text	None	ADES: mode of instrumentation (for the documentation on valid values, see https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#mode)
obs_sbn	notes	text	None	ADES: A set of one-character note flags to communicate observing circumstances (a list of accepted notes values is availble at the following link https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#notes
obs_sbn	nstars	int4	None	ADES: Number of stars in the astrometric fit
obs_sbn	nucmag	int2	None	ADES: Nuclear magnitude flag for comets, primarily used for archival data (photap should be used to communicate information in the new standard). 1=True for archival cometary nuclear magnitude measurements, 0=False otherwise.
obs_sbn	obs80	text	None	MPC_ops: 80 or 160-Character observation string
obs_sbn	obscenter	text	None	ADES: Origin of offset observations (full name of a planet or permID or provID for a small body)
obs_sbn	obsid	text	None	ADES: Globally unique observation identifier assigned by the MPC
obs_sbn	obssubid	text	None	ADES: Observation identifier, optionally included by the observer in the submission, that is unique to a given observing program
obs_sbn	obstime	timestamp	6	ADES: UTC date and time of the observation.
obs_sbn	orbit_id	text	None	MPC_ops: Unique identifier for the orbit calculation. This field is not currently used
obs_sbn	pa	numeric	None	ADES: Measured Position Angle in arcsec in degrees in the J2000.0 reference frame for offset measurements of a satellite wrt obsCenter, or for occultation observations wrt the star (only if stn=244)
obs_sbn	permid	text	None	ADES: IAU permanent designation (e.g. the IAU number for a numbered minor planet)
obs_sbn	photap	numeric	None	ADES: Photometric aperture radius in arcsec
obs_sbn	photcat	text	None	ADES: Star catalog used for the photometric reduction (a list of accepted astcat values is availble at the following link https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#astCat)
obs_sbn	pos1	numeric	None	ADES: Position of the observer (see https://github.com/IAU-ADES/ADES-Master/blob/master/ADES_Description.pdf)
obs_sbn	pos2	numeric	None	ADES: Position of the observer (see https://github.com/IAU-ADES/ADES-Master/blob/master/ADES_Description.pdf)
obs_sbn	pos3	numeric	None	ADES: Position of the observer (see https://github.com/IAU-ADES/ADES-Master/blob/master/ADES_Description.pdf)
obs_sbn	poscov11	numeric	None	ADES: Element (1,1) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	poscov12	numeric	None	ADES: Element (1,2) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	poscov13	numeric	None	ADES: Element (1,3) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	poscov22	numeric	None	ADES: Element (2,2) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	poscov23	numeric	None	ADES: Element (2,3) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	poscov33	numeric	None	ADES: Element (3,3) of the upper triangular part of the covariance matrix for the observer position in the same units of position coordinates. Missing fields are presumed zero.
obs_sbn	precdec	numeric	None	ADES: Precision for archival MPC1992 observations or earlier data in arcsec for Dec
obs_sbn	precra	numeric	None	ADES: Precision for archival MPC1992 observations or earlier data in seconds for RA
obs_sbn	prectime	int4	None	ADES: Precision in millionths of a day of the reported observation time for archival MPC1992 observations and earlier data
obs_sbn	prev_desig	text	None	MPC_ops: Previous designation for a redesignated observations (see also the obs_alteration_redesignations table https://minorplanetcenter.net/mpcops/documentation/obs-alterations-redesignations/)
obs_sbn	prev_ref	text	None	MPC_ops: Previous publication references
obs_sbn	prog	text	None	ADES: Program code assigned by the MPC
obs_sbn	provid	text	None	ADES: unpacked MPC assigned provisional designation (for more information see https://minorplanetcenter.net/mpcops/documentation/provisional-designation-definition/)
obs_sbn	ra	numeric	None	ADES: Right Ascension is decimal degrees in J2000.0 reference frame
obs_sbn	rastar	numeric	None	ADES: For occultation, only when stn=244, Right Ascension in the J2000.0 reference frame in decimal degress of the occulted star.
obs_sbn	rcv	text	None	ADES: Station codes of receiving antenna for radar observations
obs_sbn	ref	text	None	ADES: Standard reference field used for citations
obs_sbn	remarks	text	None	ADES: A comment provided by the observer.
obs_sbn	replacesobsid	text	None	MPC_ops: Observation identifier of the old published observations that has been replaced by this new observation. This field is not currently used.
obs_sbn	rmscorr	numeric	None	ADES: Correlation between RA and Dec or between distance and position angle. This is derived from the covariance matrix, where the off-diagonal term is rmsCorr x rmsRA x rmsDec (for RA and Dec), and rmsCorr x rmsdist x rmspa (for dist and pa)
obs_sbn	rmsdec	numeric	None	ADES: Random component of the Dec uncertainty in arcsec as estimated by the observer
obs_sbn	rmsdelay	numeric	None	ADES: Delay uncertainty in microseconds
obs_sbn	rmsdist	numeric	None	ADES: Random component of the distance uncertainty in arcsec as estimated by the observer
obs_sbn	rmsdoppler	numeric	None	ADES: Doppler shift uncertainty in Hz
obs_sbn	rmsfit	numeric	None	ADES: RMS of fit of astrometric comparison stars in arcsec
obs_sbn	rmsmag	numeric	None	ADES: Apparent magnitude uncertainty in magnitudes
obs_sbn	rmspa	numeric	None	ADES: Random component of the position angle uncertainty in arcsec as estimated by the observer
obs_sbn	rmsra	numeric	None	ADES: Random component of the RA*cos(Dec) uncertainty in arcsec as estimated by the observer
obs_sbn	rmstime	numeric	None	ADES: Random uncertainty in time as estimated by the observer
obs_sbn	seeing	numeric	None	ADES: Size of seeing disc in arcsec, measured at Full-Width, Half-Max of the target point spread function
obs_sbn	shapeocc	bool	None	ADES: For occultation observations, a flag to indicate that the observation reduction assumes a shape-based plane-of-sky cross-section. Values are 1=True or 0=False that implies that a circular cross section was assumed
obs_sbn	status	bpchar	None	MPC_ops: processing status. Allowed values are: P for ufficially published in a circular (DOU, mid-month, monthly), p for accepted and waiting for publication in the next circular, I for ITF observations
obs_sbn	stn	text	None	ADES: Observatory code assigned by the MPC for ground-based or spaced-based stations (for the documentation on valid values, see https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#stn)
obs_sbn	subfmt	text	None	ADES: Format in which the observation was originally submitted to the MPC. This is filled by the MPC (a list of accepted astcat values is availble at the following link https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#subfmt)
obs_sbn	subfrm	text	None	ADES: Originally reported reference frame for angular measurements. The subfrm does not reflect the frame of the associated ADES observations, which are always J2000.0. For example, B1950.0 corresponds to the letter A in column 14 in the 80-column format
obs_sbn	submission_block_id	text	None	MPC_ops: Unique MPC-assigned submission block ID
obs_sbn	submission_id	text	None	MPC_ops: Unique MPC-assigned submission ID
obs_sbn	sys	text	None	ADES: Coordinate frame for roving or space-based station coordinates (for the documentation on valid values, see https://minorplanetcenter.net/mpcops/documentation/valid-ades-values/#sys)
obs_sbn	trkid	text	None	ADES: Globally unique tracklet identifier assigned by the MPC
obs_sbn	trkmpc	text	None	ADES: MPC-internal object identifier
obs_sbn	trksub	text	None	ADES: Observer-assigned object identifier, unique within a submission batch
obs_sbn	trx	text	None	ADES: Station codes of transmitting antenna for radar observations
obs_sbn	unctime	numeric	None	ADES: Estimated systematic time error in seconds. This field indicates a presumed level of systematic clock error.
obs_sbn	updated_at	timestamptz	6	MPC_ops: Date and time of latest row update
primary_objects	barycentric	bool	None	Boolean to indicate whether the orbit for the object is in a barycentric table. The values for this field are always false because we are not computing barycentric orbits.
primary_objects	comet	bool	None	Boolean to indicate whether the object-orbit is specified in the comet table. The values are currently false because we are not saving comet orbits in a comet table
primary_objects	created_at	timestamp	6	Date and time of initial row insert
primary_objects	flag_all_object_obs_consistent	bool	None	Flag to indicate if all observations for an object have been checked to be consistent with obs files. We are not currently using this field.
primary_objects	flag_allowed_external	bool	None	Flag to indicate if the orbit has been computed using all the observations available and if the observations were consisten with the flat files. This flat is not used.
primary_objects	flag_orbit_calculated_from_consistent_obs	bool	None	Flag to indicate if the the orbit was calculated using the observations flagged as consistent. This flag is not used
primary_objects	id	int4	None	PostgreSQL automatically generated identifier
primary_objects	nongravs	bool	None	Boolean to indicate whether the orbit of the object is specified in the table containing orbits with nongravitational perturbations. At the moment this is not used because we do not have a table for the orbits computed including nongravitational perturbations, even though we compute them. We might use this flag in the future it to indicate wheter we computed the orbit of the object using non-gravitational perturbations.
primary_objects	no_orbit	bool	None	Flag to indicate those cases for which it was not possible to compute an orbit.
primary_objects	object_type	int4	None	Integer to indicate the object type as defined in: https://minorplanetcenter.net/mpcops/documentation/object-types/
primary_objects	orbfit_epoch	bool	None	If the object is in the standard_minor_planet table, this boolean indicates whether the orbit at the mid-observation epoch is populated
primary_objects	orbit_publication_references	_text	None	Array of references to MPC publication(s) containing this particular orbit calculation (e.g. DOU MPEC, mid-month, Monthly-MPC, etc)
primary_objects	orbit_published	int4	None	Flag indicating if the orbit has been published in a Circular. Field values are: 0=unpublished ; 1=published as MPEC; 2=published in DOU ; 3=published in mid-month ; 4=published in monthly. Please note that we are talking about orbit publication and not object designations
primary_objects	packed_primary_provisional_designation	text	None	Packed form of the primary provisional designation (e.g. K17P08M)
primary_objects	satellite	bool	None	Boolean to indicate whether the object-orbit is specified in the satellite table
primary_objects	standard_epoch	bool	None	If the object is in the standard_minor_planet table, this boolean indicates whether an orbit at the standard-epoch is populated
primary_objects	standard_minor_planet	bool	None	Boolean to indicate whether the orbit of the object is specified in the standard_minor_planet table. This is not used right now, but we might use it in the future
primary_objects	status	int4	None	Result of the orbit fitting. This is still not used
primary_objects	unpacked_primary_provisional_designation	text	None	Unpacked form of the primary provisional designation (e.g. 2017 PM8)
primary_objects	updated_at	timestamp	6	Date and time of latest row update

Access Denied