(Beta) 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.
  1. The first table lists the tables and a description of its contents.
  2. 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-04-13

Table NameDescription
current_identificationsTable containing all the primary designations (minor planets, comets and natural satellites) and their secondary designations, when available.
neocp_varNEOCP variant orbits table
neocp_eventsTable containing NEOCP related processing events
neocp_obsNEOCP observations table
neocp_obs_archiveNEOCP archived observations table
neocp_prev_desPrevious NEO Confirmation Page Objects table
obs_alterations_correctionsIt is intended that the fields in this table will record updates that have been made to the obs table that require subsequent publication to announce UNPUBLISH/UNASSOCIATION/SEND-TO-ITF Some/all of these changes may be indicated in the obs table itself (e.g. via status flags), but this table is intended to help flag changes to observations that require publication in some form.
obs_alterations_redesignationsIt is intended that the fields in this table will record updates that have been made to the obs table that require subsequent publication to announce REDESIGNATIONS These changes may be indicated in the obs table itself (e.g. via status flags), but this table is intended to help flag changes to observations that require publication in some form.
obs_alterations_deletionsIt is intended that the fields in this table will record updates that have been made to the obs table that require subsequent publication to announce DELETION Some/all of these changes may be indicated in the obs table itself (e.g. via status flags), but this table is intended to help flag changes to observations that require publication in some form.
obs_alterations_unassociationsIt is intended that the fields in this table will record updates that have been made to the obs table that require subsequent publication to announce UNPUBLISH/UNASSOCIATION/SEND-TO-ITF Some/all of these changes may be indicated in the obs table itself (e.g. via status flags), but this table is intended to help flag changes to observations that require publication in some form.
neocp_elsTable containing all the nominal orbital element for each tracklet that is currently on the NEOCP
numbered_identificationsTable containing the number and primary provisional designation for any object that have been numbered.
primary_objectsAll Objects Live Here: Labelled by their primary provisional designation. Fields indicate the tables in which any orbit information might be found

Last Updated: 2024-04-13

Table NameColumnData TypeDateTime Precision (if applicable)Description
current_identificationscreated_attimestamp6Current date and time whenever a row is inserted
current_identificationsidint4NonePostgreSQL automatically generated identifier
current_identificationsidentifier_ids_textNoneList of unique identifiers used by the MPC to track credit for correct identifications
current_identificationsnumberedboolNoneFlag indicating if the primary designation is also numbered (True if it numbered, False if it is not numbered)
current_identificationsobject_typeint4NoneObject classification based on its orbital element. For more information please see https://minorplanetcenter.net/mpcops/documentation/object-types/
current_identificationspacked_primary_provisional_designationtextNonePacked form of the primary provisional designation (e.g. K17P08M).
current_identificationspacked_secondary_provisional_designationtextNonePacked form of one of the secondary provisional designations (e.g. K06Sf5M).
current_identificationspublishedint4NoneInteger 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_identificationsunpacked_primary_provisional_designationtextNoneUnpacked form of the primary provisional designation (e.g. 2017 PM8).
current_identificationsunpacked_secondary_provisional_designationtextNoneUnpacked form of one of the secondary provisional designations (e.g. 2006 SM415).
current_identificationsupdated_attimestamp6Current date and time whenever a row is updated
mpc_orbitsafloat8NoneSemi-major axis [au]
mpc_orbitsa1float8NoneA1 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbitsa1_uncfloat8NonePost-fit 1-sigma uncertainty in the A1 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbitsa2float8NoneA2 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbitsa2_uncfloat8NonePost-fit 1-sigma uncertainty in the A2 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbitsa3float8NoneA3 component of the non-gravitational acceleration for comets [10^(-10) au/d^2]
mpc_orbitsa3_uncfloat8NonePost-fit 1-sigma uncertainty in the A3 component of the non-gravitational acceleration [10^(-10) au/d^2]
mpc_orbitsarc_length_selfloat8NoneArc 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_orbitsarc_length_totalfloat8NoneArc 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_orbitsargperifloat8NoneArgument of the pericenter [degrees]
mpc_orbitsargperi_uncfloat8NonePost-fit 1-sigma uncertainty in the argument of the pericenter [degrees]
mpc_orbitsa_uncfloat8NonePost-fit 1-sigma uncertainty in the semi-major axis [au]
mpc_orbitscreated_attimestamp6Current date and time whenever a row is inserted
mpc_orbitsdtfloat8NoneDeltaT component of the non-gravitational acceleration [days]
mpc_orbitsdt_uncfloat8NonePost-fit 1-sigma uncertainty in the DeltaT component of the non-gravitational acceleration [days]
mpc_orbitsefloat8NoneEccentricity
mpc_orbitsearth_moidfloat8NoneMinimum Orbit Intersection Distance [au] with respect to the orbit of the Earth.
mpc_orbitsepoch_mjdfloat8NoneOrbit epoch [TT, MJD]
mpc_orbitse_uncfloat8NonePost-fit 1-sigma uncertainty in the eccentricity
mpc_orbitsfitting_datetimetimestamp6Date and time recorded when the orbital fit was performed
mpc_orbitsgfloat8NoneSlope parameter
mpc_orbitshfloat8NoneAbsolute magnitude as computed by OrbFit
mpc_orbitsifloat8NoneInclination [degrees]
mpc_orbitsidint4NonePostgreSQL automatically generated identifier
mpc_orbitsi_uncfloat8NonePost-fit 1-sigma uncertainty in the inclination [degrees]
mpc_orbitsmean_anomalyfloat8NoneMean anomaly [degrees]
mpc_orbitsmean_anomaly_uncfloat8NonePost-fit 1-sigma uncertainty in the mean anomaly [degrees]
mpc_orbitsmean_motionfloat8NoneOrbital mean motion [degrees per day]
mpc_orbitsmean_motion_uncfloat8NonePost-fit 1-sigma uncertainty in the mean motion [degrees]
mpc_orbitsmpc_orb_jsonbjsonbNoneMPC 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_orbitsnobs_totalint4NoneTotal number of observations associated to the object.
mpc_orbitsnobs_total_selint4NoneTotal number of observations used by the fit.
mpc_orbitsnodefloat8NoneLongitude of the ascending node [degrees]
mpc_orbitsnode_uncfloat8NonePost-fit 1-sigma uncertainty in the longitude of the node [degrees]
mpc_orbitsnoppint4NoneMPC computed number of oppositions.
mpc_orbitsnormalized_rmsfloat8NoneNormalized post-fit RMS
mpc_orbitsnot_normalized_rmsfloat8NoneNot normalized post-fit RMS [arcseconds]
mpc_orbitsorbit_type_intint4NoneOrbit classification based on the object orbital element. For more information please see https://minorplanetcenter.net/mpcops/documentation/orbit-types/
mpc_orbitspacked_primary_provisional_designationtextNonePacked form of the primary provisional designation (e.g. K17P08M).
mpc_orbitsperiodfloat8NoneOrbital period [days]
mpc_orbitsperiod_uncfloat8NonePost-fit 1-sigma uncertainty in the orbital period [days]
mpc_orbitsperi_timefloat8NoneTime of the passage at the pericenter [days]
mpc_orbitsperi_time_uncfloat8NonePost-fit 1-sigma uncertainty in the time of the pericenter passage [days]
mpc_orbitsqfloat8NonePerihelion distance [au]
mpc_orbitsq_uncfloat8NonePost-fit 1-sigma uncertainty in the perihelion distance [au]
mpc_orbitssrpfloat8NoneSolar radiation pressure [m^2/ton]
mpc_orbitssrp_uncfloat8NonePost-fit 1-sigma uncertainty in the solar radiation pressure [m^2/ton]
mpc_orbitsunpacked_primary_provisional_designationtextNoneUnpacked form of the primary provisional designation (e.g. 2017PM8).
mpc_orbitsu_paramint4NoneMPC defined U parameter. For more information please see https://www.minorplanetcenter.net/iau/info/UValue.html.
mpc_orbitsupdated_attimestamp6Current date and time whenever a row is updated
mpc_orbitsyarkovskyfloat8NoneA2 component of the Yarkovsky acceleration [10^(-10) au/d^2]
mpc_orbitsyarkovsky_uncfloat8NonePost-fit 1-sigma uncertainty in the A2 component of the Yarkovsky acceleration [10^(-10) au/d^2]
neocp_elscometbpcharNoneFlag=C indicating if 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_elscreated_attimestamp6Current date and time whenever a row is inserted
neocp_elsdesigvarcharNoneObserver-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_elsdigest2numericNoneDigest2 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_elsdsc_obsvarcharNone80 or 160-character observation string of the discovery observation.
neocp_elselsvarcharNoneOrbital elements string in the MPC ele220 format.
neocp_elsflagbpcharNoneFlag 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_elsidint4NonePostgreSQL automatically generated identifier
neocp_elsprepbpcharNoneFlag=P indicating if the object has been prepared for removal
neocp_elsupdated_attimestamp6Current date and time whenever a row is updated
neocp_eventscreated_attimestamp6Current date and time whenever a row is inserted
neocp_eventsdesigtextNoneObserver-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_eventsevent_texttextNoneA full description of the event type for each object, e.g. Additional obs posted to NEOCP or Object designated K23W00001U (MPEC 2023-W67)
neocp_eventsevent_typetextNoneEvent type, e.g. update, add, remove object
neocp_eventsevent_usertextNoneUser name of who/what processed the event, e.g. process_newneo (automated process), dbell (human)
neocp_eventsidint4NonePostgreSQL automatically generated identifier
neocp_eventsupdated_attimestamp6Current date and time whenever a row is updated
neocp_obscreated_attimestamp6None
neocp_obsdesigvarcharNoneObserver-assigned tracklet identifier, unique within submission batch.
neocp_obsforce_codetextNoneThis column is currently unused.
neocp_obsidint4NoneIn-built ID sequence number from Postgres
neocp_obsobs80varcharNone80 or 160-Character observation string
neocp_obsrmscorrnumericNoneADES_Observation: Correlation between RA and DEC or dist and PA that may result from the astrometric reduction. This is derived from the $\mathrm{RA}$-$\mathrm{DEC}$ or $\mathrm{dist}$-$\mathrm{PA}$ covariance matrix, where the off-diagonal term is $\mathrm{rmsCorr} * \mathrm{rmsRA} * \mathrm{rmsDec}$ or $\mathrm{rmsCorr} * \mathrm{rmsDist} * \mathrm{rmsPA}$.
neocp_obsrmsdecnumericNoneADES_Observation: Random component of the DEC $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
neocp_obsrmsranumericNoneADES_Observation: Random component of the $\mathrm{RA}\cos\mathrm{DEC}$ $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
neocp_obsrmstimenumericNoneADES_Observation: Random component of the obsTime 1-sigma uncertainty, in seconds, as estimated by observer
neocp_obstrkidtextNoneGlobally Unique alphnumeric tracklet ID assigned by MPC.
neocp_obsupdated_attimestamp6None
neocp_obs_archivecreated_attimestamp6None
neocp_obs_archivedesigvarcharNoneObserver-assigned tracklet identifier, unique within submission batch.
neocp_obs_archiveforce_codetextNoneNone
neocp_obs_archiveidint4NoneIn-built ID sequence number from Postgres
neocp_obs_archiveobs80varcharNone80 or 160-Character observation string
neocp_obs_archivermscorrnumericNoneADES_Observation: Correlation between RA and DEC or dist and PA that may result from the astrometric reduction. This is derived from the $\mathrm{RA}$-$\mathrm{DEC}$ or $\mathrm{dist}$-$\mathrm{PA}$ covariance matrix, where the off-diagonal term is $\mathrm{rmsCorr} * \mathrm{rmsRA} * \mathrm{rmsDec}$ or $\mathrm{rmsCorr} * \mathrm{rmsDist} * \mathrm{rmsPA}$.
neocp_obs_archivermsdecnumericNoneADES_Observation: Random component of the DEC $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
neocp_obs_archivermsranumericNoneADES_Observation: Random component of the $\mathrm{RA}\cos\mathrm{DEC}$ $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
neocp_obs_archivermstimenumericNoneADES_Observation: Random component of the obsTime 1-sigma uncertainty, in seconds, as estimated by observer
neocp_obs_archivetrkidtextNoneGlobally Unique alphnumeric tracklet ID assigned by MPC.
neocp_obs_archiveupdated_attimestamp6None
neocp_prev_descreated_attimestamp6None
neocp_prev_desdesigtextNoneObserver-assigned tracklet identifier, unique within submission batch.
neocp_prev_desdigest2numericNoneDigest2 Score
neocp_prev_desiau_desigtextNoneUnpacked provisional designation as specified by the IAU.
neocp_prev_desidint4NoneIn-built ID sequence from Postgres
neocp_prev_despkd_desigtextNoneExtended packed provisional designation.
neocp_prev_desreftextNoneMPEC reference
neocp_prev_desstatustextNoneReason for removal of object. E.g. lost, DNE.
neocp_prev_desupdated_attimestamp6None
neocp_varcreated_attimestamp6None
neocp_vardesigvarcharNoneObserver-assigned tracklet identifier, unique within submission batch.
neocp_varelsvarcharNoneOrbital elements string in ele220 format.
neocp_varidint4NoneIn-built ID sequence number from Postgres
neocp_varupdated_attimestamp6None
numbered_identificationscreated_attimestamp6Current date and time whenever a row is inserted
numbered_identificationsiau_designationtextNoneThis column is currently unused.
numbered_identificationsiau_nametextNoneThis column is currently unused. The MPC is not responsible for naming.
numbered_identificationsidint4NonePostgreSQL automatically generated identifier
numbered_identificationsnamed_publication_references_textNoneThis column is currently unused. The MPC is not responsible for naming.
numbered_identificationsnaming_credittextNoneThis column is currently unused. The MPC is not responsible for naming.
numbered_identificationsnumbered_publication_references_textNoneList of references to any MPC publication(s) including information on the numbering of the corresponding object (e.g. Monthly circulars, etc)
numbered_identificationspacked_primary_provisional_designationtextNonePacked form of the primary provisional designation (e.g. J81E29H ).
numbered_identificationspermidtextNoneUnpacked form of the permanent designation (number without parenthesis)
numbered_identificationsunpacked_primary_provisional_designationtextNoneUnpacked form of the primary provisional designation (e.g. 1981 EH29).
numbered_identificationsupdated_attimestamp6Current date and time whenever a row is updated
obs_alterations_correctionscreated_attimestamp6None
obs_alterations_correctionsidint4NoneNone
obs_alterations_correctionsobsid_newtextNoneThe unique obsid of the NEW observation that REPLACES the obsid_old
obs_alterations_correctionsobsid_oldtextNoneThe unique obsid of the OLD observation that was REPLACED
obs_alterations_correctionspublication_ref_textNoneArray of reference(s) to pubn(s) announcing this unassociation
obs_alterations_correctionsupdated_attimestamp6None
obs_alterations_deletionscreated_attimestamp6None
obs_alterations_deletionsidint4NoneNone
obs_alterations_deletionsobsidtextNoneThe unique obsid of the observation that was altered. Links to the observation record in the obs table.
obs_alterations_deletionspublication_ref_textNoneArray of reference(s) to pubn(s) announcing this deletion
obs_alterations_deletionsstatusint4NoneInteger to indicate state of publication. 0=Unpublished/Needs-to-be-published, 1=Published in DOU, 2=Published in Monthly
obs_alterations_deletionsupdated_attimestamp6None
obs_alterations_redesignationscreated_attimestamp6None
obs_alterations_redesignationsidint4NoneNone
obs_alterations_redesignationsnew_designation_createdboolNoneA flag to indicate if a new designation was created when the tracklet(s) were taken from a different object.
obs_alterations_redesignationsobsidtextNoneThe unique obsid of the observation that was altered. Links to the observation record in the obs table.
obs_alterations_redesignationspacked_provisional_designation_fromtextNoneOriginal packed provisional designation
obs_alterations_redesignationspacked_provisional_designation_totextNoneNew packed provisional designation
obs_alterations_redesignationspublication_ref_textNoneArray of reference(s) to pubn(s) announcing this redesignation
obs_alterations_redesignationsstatusint4NoneInteger to indicate state of publication. 0=Unpublished/Needs-to-be-published, 1=Published in DOU, 2=Published in Monthly
obs_alterations_redesignationsunpacked_provisional_designation_fromtextNoneOriginal unpacked provisional designation
obs_alterations_redesignationsunpacked_provisional_designation_totextNoneNew unpacked provisional designation
obs_alterations_redesignationsupdated_attimestamp6None
obs_alterations_unassociationscreated_attimestamp6None
obs_alterations_unassociationsidint4NoneNone
obs_alterations_unassociationsobsidtextNoneThe unique obsid of the observation that was altered. Links to the observation record in the obs table.
obs_alterations_unassociationspacked_provisional_designation_fromtextNoneThe packed provisional designation that these obervations were assigned.
obs_alterations_unassociationspublication_ref_textNoneArray of reference(s) to pubn(s) announcing this unassociation
obs_alterations_unassociationstrkmpc_totextNoneNew trkMPC used to label the observations within the ITF
obs_alterations_unassociationsunpacked_provisional_designation_fromtextNoneThe unpacked provisional designation that these obervations were assigned.
obs_alterations_unassociationsupdated_attimestamp6None
obs_sbnall_pub_ref_textNoneMPC_ops: Array of (potentially multiple) publication references
obs_sbnartsattextNoneADES_Observation: Name of an artificial satellite
obs_sbnastcattextNoneADES_Observation: Star catalog used for the astrometric reduction or for the occulted star in the case of occultation observations.
obs_sbnbandtextNoneADES_Observation: Filter designation for photometry.
obs_sbncomint2NoneADES_Observation: Flag to indicate that the observation is reduced to the center of mass. 0 implies a measurement to the peak power position, which is usually interpreted as the leading edge of the target, with the reflection point being modeled one object radius prior to the center of mass.
obs_sbncreated_attimestamptz6MPC_ops: database record of row creation
obs_sbnctrint4NoneADES_Observation: Origin of the reference system. Use public SPICE codes, e.g., 399 is the geocenter, 10 is the Sun center. Note; sys=WGS84 implies ctr=399
obs_sbndecnumericNoneADES_Observation: J2000.0 Astrometric equatorial declination in decimal degrees. Positive DEC values may optionally include a \verb|+| sign
obs_sbndecstarnumericNoneADES_Observation: J2000.0 DEC in decimal degrees of the occulted star
obs_sbndelaynumericNoneADES_Observation: Observed radar delay value in seconds.
obs_sbndeltadecnumericNoneADES_Observation: Measured $\Delta$DEC in arcseconds. For offset measurements of a satellite with respect to its primary, or for occultation observations with respect to the star in rectangular coordinates, J2000.0 frame
obs_sbndeltaranumericNoneADES_Observation: Measured $\Delta(\mathrm{RA})\cos\mathrm{ DEC}
obs_sbndeprecatedbpcharNoneADES_Observation: Marks deprecated observation.
obs_sbndesignation_asteriskboolNoneMPC_ops: Equivalent of the asterisks used to mark initial tracklets for component provisional designations. Can be multiple per object. Expeft that one of these is the same as the "disc"/"disc_ades"
obs_sbndiscbpcharNoneADES_Observations: Discovery flag. An asterisk marks a new discovery record
obs_sbndistnumericNoneADES_Observation: Measured distance in arcseconds. For offset measurements of a satellite with respect to its primary, or for occultation observations with respect to the star in polar coordinates.
obs_sbndopplernumericNoneADES_Observation: observed radar doppler value in \si{\hertz}
obs_sbnexpnumericNoneADES_Observation: Exposure time in \si{\second}. Total exposure time in the case of stacked image detections
obs_sbnfrqnumericNoneADES_Observation: Carrier reference frequence in \si{\mega\hertz}
obs_sbngroup_idtextNoneMPC_ops: Observation Group Identifier: Used to group duplicate/near-duplicate observations.
obs_sbnhealpixint8NoneMPC_ops: Convenience calculation; (RA,Dec) -> 63arc-sec healpix ( nside = 32768 nested = True )
obs_sbnidint4NoneMPC_ops: db-assigned unique ID
obs_sbnlocalusetextNoneADES_Observation: For user-defined fields in observations
obs_sbnlogsnrnumericNoneADES_Observation: $\log_{10}$ of the signal-to-noise ratio of the source in the image integrated on the entire aperture used for the astrometric centroid.
obs_sbnmagnumericNoneADES_Observation: Apparent Magnitude in specified band
obs_sbnmodetextNoneADES_Observation: Mode of optical and offset observations.
obs_sbnnotestextNoneADES_Observation: A set of one-character note flags to communicate observing circumstances.
obs_sbnnstarsint4NoneADES_Observation: Number of stars in astrometric fit.
obs_sbnnucmagint2NoneADES_Observation: Nuclear magnitude flag for comets. 0 for total magnitude (i.e., for most archival comet observations and all asteroid observations
obs_sbnobs80textNoneMPC_ops: 80 or 160-Character observation string
obs_sbnobscentertextNoneADES_Observation: Center of offset observation may be planet or other body with PermID or ProvID
obs_sbnobsidtextNoneMPC_ops: Unique MPC-Assigned Observation ID
obs_sbnobssubidtextNoneADES_Observation: Optional field in submissions to allow the submitter to annotate observations with their own observation ID
obs_sbnobstimetimestamp6ADES_Observations: UTC time of the observation in ISO 8601 format, i.e., {\em yyyy-mm-ddThh:mm:ss.ssZ}.
obs_sbnorbit_idtextNoneMPC_ops: Unique Identifier for Orbit Calculation ( one object may have had many orbit (re)calculations): Should have Foreign Key reference to the orbit-table
obs_sbnpanumericNoneADES_Observation: Measured position angle in degrees. For offset measurements of a satellite with respect to its primary, or for occultation observations with respect to the star in polar coordinates.
obs_sbnpermidtextNoneADES_Observation: IAU permanent designation, i.e., IAU number
obs_sbnphotapnumericNoneADES_Observation: Photometric aperture radius in arcseconds.
obs_sbnphotcattextNoneADES_Observation: Star catalog used for photometry measurements.
obs_sbnpos1numericNoneADES_Observation: Position of observer, first value.
obs_sbnpos2numericNoneADES_Observation: Position second value per sys
obs_sbnpos3numericNoneADES_Observation: Position third value per sys
obs_sbnposcov11numericNoneADES_Observation: 11 covariance per sys
obs_sbnposcov12numericNoneADES_Observation: 12 covariance per sys
obs_sbnposcov13numericNoneADES_Observation: 13 covariance per sys
obs_sbnposcov22numericNoneADES_Observation: 22 covariance per sys
obs_sbnposcov23numericNoneADES_Observation: 23 covariance per sys
obs_sbnposcov33numericNoneADES_Observation: 33 covariance per sys
obs_sbnprecdecnumericNoneADES_Observation: Precision in arcseconds of the reported DEC for archived MPC1992 data records.
obs_sbnprecranumericNoneADES_Observation: Precision in seconds of the reported RA for archived MPC1992 data records.
obs_sbnprectimeint4NoneADES_Observation: Precision in millionths of a day of the reported obeservation time for archived MPC1992 data records
obs_sbnprev_desigtextNoneMPC_ops: Previous designation for a redesignated observation: Can also track via "obs_alterations_redesignation"
obs_sbnprev_reftextNoneMPC_ops: Previous publication references for data
obs_sbnprogtextNoneADES_Observation: Program code as assigned by the MPC.
obs_sbnprovidtextNoneADES_Observation: MPC provisional designation (unpacked format)
obs_sbnranumericNoneADES_Observation: J2000.0 Astrometric equatorial right ascension in decimal degrees.
obs_sbnrastarnumericNoneADES_Observation: J2000.0 RA in decimal degrees of the occulted star
obs_sbnrcvtextNoneADES_Observation: Station code of receiving antenna.
obs_sbnreftextNoneADES_Observation: Reference field used for citations
obs_sbnremarkstextNoneADES_Observation: Comment field provided by the observer. This field can be used to report additional information that is not reportable in the notes field, but that may be of relevance for interpretation of the observations.
obs_sbnreplacesobsidtextNoneMPC_ops: Observation identifier, used to indicate that the submitted observation replaces the observation with the ObsID provided in the replacesObsID field
obs_sbnrmscorrnumericNoneADES_Observation: Correlation between RA and DEC or dist and PA that may result from the astrometric reduction. This is derived from the $\mathrm{RA}$-$\mathrm{DEC}$ or $\mathrm{dist}$-$\mathrm{PA}$ covariance matrix, where the off-diagonal term is $\mathrm{rmsCorr} * \mathrm{rmsRA} * \mathrm{rmsDec}$ or $\mathrm{rmsCorr} * \mathrm{rmsDist} * \mathrm{rmsPA}$.
obs_sbnrmsdecnumericNoneADES_Observation: Random component of the DEC $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
obs_sbnrmsdelaynumericNoneADES_Observation: Measurement $1\sigma$ uncertainty in \si{\micro\second} for radar delay
obs_sbnrmsdistnumericNoneADES_Observation: Random component of the distance $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
obs_sbnrmsdopplernumericNoneADES_Observation: Measurement $1\sigma$ uncertainty in \si{\hertz} for radar doppler
obs_sbnrmsfitnumericNoneADES_Observation: RMS of fit of astrometric comparison stars in arcseconds.
obs_sbnrmsmagnumericNoneADES_Observation: Apparent magnitude $1\sigma$ uncertainty in magnitudes.
obs_sbnrmspanumericNoneADES_Observation: Random component of the polar angle $1\sigma$ uncertainty in degrees as estimated by the observer as part of the image processing and astrometric reduction.
obs_sbnrmsranumericNoneADES_Observation: Random component of the $\mathrm{RA}\cos\mathrm{DEC}$ $1\sigma$ uncertainty in arcseconds as estimated by the observer as part of the image processing and astrometric reduction.
obs_sbnrmstimenumericNoneADES_Observation: Random component of the obsTime 1-sigma uncertainty, in seconds, as estimated by observer
obs_sbnseeingnumericNoneADES_Observation: Size of seeing disc in arcseconds, measured at Full Width Half Maximum (FWHM
obs_sbnshapeoccboolNoneADES_Observation: For occultation observations, a flag to indicate that the observation reduction assumes a shape-based (non-circular) plane-of-sky cross-section. False implies that a circular cross section was assumed
obs_sbnstatusbpcharNoneMPC_ops: processing status: to be tied to obs_status table
obs_sbnstntextNoneADES_Observation: Observatory code from MPC list.
obs_sbnsubfmttextNoneADES_Observation: Format in which the observation was originally submitted to the MPC, e.g., M92 for MPC1992 format or A17 for the current standard standard. Filled by the MPC according to a list provided and maintained by the MPC.
obs_sbnsubfrmtextNoneADES_Observation: Reference frame for the original submission of reported angular measurements.
obs_sbnsubmission_block_idtextNoneMPC_ops: Unique MPC-Assigned Submission-Block ID
obs_sbnsubmission_idtextNoneMPC_ops: Unique MPC-Assigned Submission ID
obs_sbnsystextNoneADES_Observation: Coordinate system for station coordinates and covariance.
obs_sbntrkidtextNoneADES_Observation: Globally Unique alphnumeric tracklet ID assigned by MPC
obs_sbntrkmpctextNoneADES_Observation: MPC-internal tracklet identifier, used in cases where the value of the trkSub element should be considered deprecated.
obs_sbntrksubtextNoneADES_Observation: Observer-assigned tracklet identifier, unique within submission batch.
obs_sbntrxtextNoneADES_Observation: Station code of transmiting antenna.
obs_sbnunctimenumericNoneADES_Observation: Estimated time uncertainty in seconds. Unlike the preceding RMS fields, which indicate random errors, this field indicates a presumed level of systematic clock error. NB: This field is generally only to be used to communicate exceptions and problems with clock calibration and is not intended to be used in routine submissions where clock errors are not a significant source of astrometric error.
obs_sbnupdated_attimestamptz6MPC_ops: database record of row update
primary_objectsbarycentricboolNoneBoolean to indicate whether the object-orbit is specified in the barycentric table. N.B. Can be in standard-table AND barycentric table
primary_objectscometboolNoneBoolean to indicate whether the object-orbit is specified in the comet table
primary_objectscreated_attimestamp6None
primary_objectsflag_all_object_obs_consistentboolNoneflag if/when all observations for an object have been checked to be consistent with obs-files
primary_objectsflag_allowed_externalboolNoneIf flag_all_object_obs_consistent=True and flag_orbit_calculated_from_consistent_obs=True, then set flag_allowed_external = True
primary_objectsflag_orbit_calculated_from_consistent_obsboolNoneWas this orbit calculated using obs flagged as consistent ? (may be necessary while developing / transitioning)
primary_objectsidint4NoneNone
primary_objectsnongravsboolNoneBoolean to indicate whether the object-orbit is specified in the nongravs table
primary_objectsno_orbitboolNoneIf no orbit calculated: new insert; no-possible calc; ...
primary_objectsobject_typeint4NoneInteger to indicate the object type as defined here: https://minorplanetcenter.net/mpcops/documentation/object-types/
primary_objectsorbfit_epochboolNoneIf in standard_minor_planet, boolean indicates whether orbit at mid-observation-epoch is populated
primary_objectsorbit_publication_references_textNoneArray of references to MPC publication(s) that contained this particular orbit calculation (e.g. DOU MPEC, mid-month, Monthly-MPC, etc)
primary_objectsorbit_publishedint4NoneHas this ORBIT (not object-desig) been published yet? i.e. has it been published in the DOU, Mid month, or monthly products. Field values: 0=unpublished ; 1=published as MPEC; 2=published in DOU ; 3=published in mid-month ; 4=published in monthly
primary_objectspacked_primary_provisional_designationtextNoneThe primary provisional designation in packed form (e.g. K08A00B). UNIQUE
primary_objectssatelliteboolNoneBoolean to indicate whether the object-orbit is specified in the satellite table
primary_objectsstandard_epochboolNoneIf in standard_minor_planet, boolean indicates whether orbit at standard-epoch is populated
primary_objectsstandard_minor_planetboolNoneBoolean to indicate whether the object-orbit is specified in the standard_minor_planet table
primary_objectsstatusint4Nonegranular status of orbfit results
primary_objectsunpacked_primary_provisional_designationtextNoneThe primary provisional designation in UNpacked form (e.g. 2008 AB). UNIQUE
primary_objectsupdated_attimestamp6None