Replicated PostgreSQL Tables: Schema¶
The MPC makes its PostgreSQL database of observations and orbits available for replication via the SBN. Additional information on the replicated tables, including sample queries, can be found here.
The table below shows the name, the description and the status for all the tables that are currently replicated to the SBN.
The status column indicates the table's current state:
- Ready means the table is fully populated and serves as the MPC's main data source.
- Partially populated indicates that while data is being added, further work or consistency checks are needed before it can be fully utilized.
- Not populated signifies that the table is inactive and not yet suitable as a primary data source.
By clicking on the name of each table, you will get to the page of the schema of the specific table, including the column names, types, and descriptions.
| Table name | Description | Status |
|---|---|---|
| comet_names | Table containing a record of all the names assigned to comets by the WGSBN. | Ready |
| current_identifications | Table containing all the primary designations (minor planets, comets and natural satellites) and their secondary designations, when available. | Ready |
| minor_planet_names | Table containing a record of all the names assigned to minor planets by the WGSBN. | Ready |
| mpc_orbits | Table containing orbits and related information for any minor planet that has been designated and for which it is possible to fit an orbit with the available observations. | Partially populated |
| neocp_els | Table containing the nominal orbital element for each tracklet that is currently on the NEOCP. | Ready |
| neocp_events | Table containing NEOCP related processing events. | Ready |
| neocp_obs | Table containing observations for objects currently on the NEOCP. | Ready |
| neocp_obs_archive | Table containing archived NEOCP observations. | Ready |
| neocp_prev_des | Table containing objects that were previously listed on the NEOCP, their designation if designated and the reasons for their removal. | Ready |
| neocp_var | Table containing variant orbits for every object on the NEOCP. | Ready |
| numbered_identifications | Table containing the number and primary provisional designation for any object that have been numbered. | Ready |
| obs_alterations_corrections | Table used to record the corrections made to the observations that have been published. | Empty |
| obs_alterations_deletions | Table used to record the corrections made to the observations that have been published by the MPC and that have also been deleted. | Partially populated |
| obs_alterations_redesignations | Table used to record the observations that have been redesignated. | Partially populated |
| obs_alterations_unassociations | Table used to record the observations that were unassociated from their original designation and relocated to the Isolated Tracklet File (ITF). | Partially populated |
| obscodes | Table used to keep a record of all the observatory codes assigned by the MPC. | Ready |
| obs_sbn | Table used to record all the observations published by the MPC. Contains observations associated with designated objects and observations associated with the Isolated Tracklet File (ITF). | Ready |
| 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. | Ready |