(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.- 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 each table and its schema can be downloaded here.
To order the columns click the header to sort the data.
Last Updated: 2024-04-27
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 have unassociated from their current designation |
neocp_els | Table containing all 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 | All 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-27
Table Name | Column | Data Type | DateTime Precision (if applicable) | Description |
---|---|---|---|---|
current_identifications | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
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 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
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 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_els | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 elements 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 if the object has been prepared for removal |
neocp_els | updated_at | timestamp | 6 | Current date and time whenever a row is updated |
neocp_events | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
neocp_obs | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
neocp_obs_archive | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
neocp_prev_des | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 | Current date and time whenever a row is updated |
neocp_var | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 elements string for each variant orbit in ele220 format |
neocp_var | id | int4 | None | PostgreSQL automatically generated identifier |
neocp_var | updated_at | timestamp | 6 | Current date and time whenever a row is updated |
numbered_identifications | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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) |
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 | Current date and time whenever a row is updated |
obs_alterations_corrections | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
obs_alterations_corrections | id | int4 | None | PostgreSQL automatically generated identifier |
obs_alterations_corrections | obsid_new | text | None | Unique MPC assigned observation ID of the new corrected observation |
obs_alterations_corrections | obsid_old | text | None | Unique MPC assigned observation ID 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 | Current date and time whenever a row is updated |
obs_alterations_deletions | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
obs_alterations_deletions | id | int4 | None | PostgreSQL automatically generated identifier |
obs_alterations_deletions | obsid | text | None | Unique MPC assigned observation ID 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 | Current date and time whenever a row is updated |
obs_alterations_redesignations | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
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 of the deleted observation |
obs_alterations_redesignations | packed_provisional_designation_from | text | None | Original packed provisional designation |
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 | Current date and time whenever a row is updated |
obs_alterations_unassociations | created_at | timestamp | 6 | Current date and time whenever a row is inserted |
obs_alterations_unassociations | id | int4 | None | PostgreSQL automatically generated identifier |
obs_alterations_unassociations | obsid | text | None | Unique MPC assigned observation ID 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 | Current date and time whenever a row is updated |
obs_sbn | all_pub_ref | _text | None | MPC_ops: Array of (potentially multiple) publication references |
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: database record of row creation |
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. Can be multiple per object. Expeft that one of these is the same as the "disc"/"disc_ades" |
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. |
obs_sbn | healpix | int8 | None | MPC_ops: |
obs_sbn | id | int4 | None | MPC_ops: PostgreSQL automatically generated identifier |
obs_sbn | localuse | text | None | ADES_Observation: For user-defined fields in observations |
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_Observation: Number of stars in 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: Optional field in submissions to allow the submitter to annotate observations with their own observation ID |
obs_sbn | obstime | timestamp | 6 | ADES: UTC date and time of the observation. |
obs_sbn | orbit_id | text | None | MPC_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_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 observation: Can also track via "obs_alterations_redesignation" |
obs_sbn | prev_ref | text | None | MPC_ops: Previous publication references for data |
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, used to indicate that the submitted observation replaces the observation with the ObsID provided in the replacesObsID field |
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_Observation: Random component of the obsTime 1-sigma uncertainty, in seconds, as estimated by 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_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_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_Observation: MPC-internal tracklet identifier, used in cases where the value of the trkSub element should be considered deprecated. |
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: database record of row update |
primary_objects | barycentric | bool | None | Boolean to indicate whether the object-orbit is specified in the barycentric table. N.B. Can be in standard-table AND barycentric table |
primary_objects | comet | bool | None | Boolean to indicate whether the object-orbit is specified in the comet table |
primary_objects | created_at | timestamp | 6 | None |
primary_objects | flag_all_object_obs_consistent | bool | None | flag if/when all observations for an object have been checked to be consistent with obs-files |
primary_objects | flag_allowed_external | bool | None | If flag_all_object_obs_consistent=True and flag_orbit_calculated_from_consistent_obs=True, then set flag_allowed_external = True |
primary_objects | flag_orbit_calculated_from_consistent_obs | bool | None | Was this orbit calculated using obs flagged as consistent ? (may be necessary while developing / transitioning) |
primary_objects | id | int4 | None | None |
primary_objects | nongravs | bool | None | Boolean to indicate whether the object-orbit is specified in the nongravs table |
primary_objects | no_orbit | bool | None | If no orbit calculated: new insert; no-possible calc; ... |
primary_objects | object_type | int4 | None | Integer to indicate the object type as defined here: https://minorplanetcenter.net/mpcops/documentation/object-types/ |
primary_objects | orbfit_epoch | bool | None | If in standard_minor_planet, boolean indicates whether orbit at mid-observation-epoch is populated |
primary_objects | orbit_publication_references | _text | None | Array of references to MPC publication(s) that contained this particular orbit calculation (e.g. DOU MPEC, mid-month, Monthly-MPC, etc) |
primary_objects | orbit_published | int4 | None | Has 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_objects | packed_primary_provisional_designation | text | None | The primary provisional designation in packed form (e.g. K08A00B). UNIQUE |
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 in standard_minor_planet, boolean indicates whether orbit at standard-epoch is populated |
primary_objects | standard_minor_planet | bool | None | Boolean to indicate whether the object-orbit is specified in the standard_minor_planet table |
primary_objects | status | int4 | None | granular status of orbfit results |
primary_objects | unpacked_primary_provisional_designation | text | None | The primary provisional designation in UNpacked form (e.g. 2008 AB). UNIQUE |
primary_objects | updated_at | timestamp | 6 | None |