Data Wizard Minor Planet Query
 


Data Wizard
Minor Planet Queries

The following is an example of how to use the handy Data Wizard to make a query specific on Minor Planets.  The target list can be created by using the files from the Minor Planet Center's file MPCORB.DAT, their files Distant, Critical, or Unusual lists, the Lowell Observatory's file ASTORB.DATor even a subset target list as created by the Lowell Observatory's "Hierarchial Observing Protocal for Asteroids" (HOP) page when the Output orbital elements to a file option is implemented.

 

WARNING:  When creating queries If you don't set the date and time in TheSky6 to the actual imaging date and time you want you will not get the minor planets you expect!

 

Using the TheSky's Data | Data Wizard select "Object Type and Databases" under Solar System check Extended Minor Planets.  If the minor planets of interest are already added to your local group choose "Minor Planet" not Extended Minor Planet.  The extended minor planet file allows you to access all of the currently available minor planets for the query (~275,000 at this writing) whereas the local group is limited to a total of 1,000 only.

 

Please refer to the following download links to the larger Extended Minor Planet files MPCORB.DAT from the  Minor Planet Center  and/or Lowell Observatory's file ASTORB.DAT The  Hierarchial Observing Protocal for Asteroids page can be used as well.

 

What is the difference between the "Local Group" of minor planets versus the "Extended Minor Planets"?

 

After you have loaded an Extended Minor Planet file next access the Data Wizard in TheSky6 using Data | Data Wizard.  Make a "NEW" Query using File | New.

WARNING!

Making a query on 275,000+ minor planets will take time!  AND, even when limiting the Extended Minor Planet query to only those minor planets with an altitude greater than say 40 degrees, a magnitude between 16th and 18th, and an Altitude and Azimuth between say 110 and 235, the query will return over 2,000 minor planets!  The MORE you can filter out unwanted objects the better.

Data | Comets and Minor Planets

Extended Minor Planets

A new query is made using the Extended Minor Planets.

New Minor Planet Query

Choose Query | Edit Parameters

Use the tab "Object Types and Databases" on the Editing dialog to limit the Database Query to Extended Minor Planets.  Expand the entry "Solar System" by double mouse clicking it.  You will see the entry for Extended Minor Planet here under Solar System.

Database Query on Extended Minor Planets

Limit our Query to Extended Minor Planets

Adding Attribute Filters to the Query

Now consider the following query.  Using the Attribute Filter dialog EXPAND the entry "Floating Point Values".  Pick the fields you wish to limit by then the Attribute for the field.  First click on Altitude.  In the Current Filter select "Compare Greater than" from the drop down list.  In the field Value enter 40.  Now you have all minor planets with an Altitude Greater than 40 degrees.  Easy enough.

Filter Altitude > 40 degrees

Select the fields you want then the criteria for each

The problem becomes when using ALL of the minor planets this query will result in finding thousands of minor planets (about 50,000)!  In order to use the Data Wizard effectively you will want to limit the query even further.  There are several ways to accomplish this.

For example, in addition to those minor planets that are 40 degree high in altitude you can limit the search to only those that are +- 1 hour from the meridian 15 degrees by using the field hour angle.  Add the filter hour angle > -1 and hour angle < 1.  Still a lot of hits.

Distant Minor Planet Expample

Even better start with a smaller set of orbital elements to begin with!  For example, let's use the "Distant" minor planet list from the MPC.  In TheSky use Data | Comets and Minor Planets | Minor Planets dialog.  Under the heading "From the web" click on the button Distant....

Minor Planets Dialog

Click "Distant"

Using your Internet connection TheSky will download the list of "Distant" minor planets from the Minor Planet Center's web page.  The entire list is displayed.  Currently a total of 1,000 minor planets can be imported into the "local group" this way.  If you try to drag more than 1,000 minor planets from a file only the first 1,000 will be imported and the rest are rejected!

Select those you want

Drag, or select individually!

Note the "total" number of minor planets imported is displayed!  673 in this case when all the Distant objects are dragged and imported to the local group.

All Distant Minor Planets loaded

From the Web

Here is a reality check.  Make a Query on the entire list of Minor Planets using the Data Wizard.  With no filtering you will get all 673 in the report.  Create a "new" query File New.  Under Query | Edit Parameters choose the Object Types and Databases tab.  The Minor Planets from the Distant group WERE IMPORTED into the "local group".  Therefore you are not querying the "Extended Minor Planets" in the case but rather the Minor Planets!

Minor Planet query

Selected Object Types is Minor Planet

Now by not using ANY filtering just run the query.  You can pick individual fields to show in your REPORT in addition to the default Object Name.  Just use the Report Columns Tab and expand the Floating Point entry, Text values, and/or Integer values to see the fields available for your report.

Pick the fields of interest!

Move from the left to the right

At this point you are done.  Just press OK and you can "RUN" the query.  See below.

Run the Query

Data Wizard

Following are the results of the query.  Again note the total number of objects found on the dialog!

Query on Distant minor planets with no filtering

 

 

 

 

 

 



Note "Objects found" at the bottom

New query with filters!  Now Edit the Query Parameters choosing the Attribute Filter tab.  I have now added only those minor planets with an altitude > 40 degrees, an hour angle > -1 and hour angle < 1 (+- 15 degrees of the meridian).

New Query using filters

Run the query again!!

Be sure to Run the query again!  Note the difference in objects found!  Now there are only 48 minor planets found.  Again, by adding additional filters you can limit the matches even further OR just start with a list of minor planets that only has the ones you are interested in!

New Query Results

Total Objects = 48 with filters employed

HINT:  If you have only the minor planets of interest loaded in the "Extended Minor Planet" list or the local group all matches found will be those that are positioned EXACTLY where you want them.  Assuming of course they do meet the filtering criteria!

After you have the list created you can Sort the list by any of the fields.  Just click on that field name and the data is sorted by the field.  You can also choose to sort by minimizing telescope motion, the shortest path, including removing objects that are close to one another to avoid wasting imaging time!

Sorting by Minimum Telescope Motion

Advanced sorting

So, now what?

Exporting to an Orchestrate Script

Once you have your targets the list can be saved to a text file to be used with a VB, Java, Visual Basic, or equivalent program, Microsoft Excel, Access,  copied to the clip board, or even Exported as an Orchestrate Script to automatically image the targets for you.

Export dialog

Choose Export Options

Choose the "Scripting" tab to create the Orchestrate Script  for you.  Note the option "Export as a script" in the Export Dialog.  This will add the Orchestrate Script commands you have selected to the target list for you.  See below.
 

Add Scripting Commands to your list

Click and Add the commands you want

Enter Parameters to the right

This becomes the script!
 

And finally the script in Orchestrate ready to be executed.

Orchestrate Script ready to be carried out

Orchestrate Commands embedded in target list

OR

 

Following is the target list with fields chosen exported to a text file sorted by Object Name.
 

Object name ,RA (current epoch),Azimuth ,Altitude ,Magnitude,Transit time,Set time,Hour angle
1999 CN119, 09h 19m 02s , 196°00'09" ,+71°09'12" ,24.53 , 13:46, 20:34, 00h 21m 35s
1999 CX131, 09h 20m 15s , 195°56'17" ,+72°17'21" ,23.36 , 13:47, 20:38, 00h 20m 23s
2000 CG105, 09h 20m 55s , 192°39'39" ,+67°53'51" ,23.34 , 13:48, 20:25, 00h 19m 42s
60458 2000 CM114,09h 21m 31s , 192°21'35" ,+68°05'46" ,23.23 , 13:49, 20:27, 00h 19m 06s
2002 CZ224, 09h 22m 14s , 194°16'52" ,+72°12'03" ,23.53 , 13:49, 20:40, 00h 18m 24s
1999 CU153, 09h 22m 43s , 192°50'15" ,+70°32'54" ,23.67 , 13:50, 20:35, 00h 17m 54s
..... and so on.

How to create an Ephemeris

You can also use the Data Wizard to Export the data in intervals.  For example you could run the query 5 times in 1 hour intervals creating an ephemeris for the objects using the attribute filters chosen.

Ephemeris feature

Choose interval and number of times to run!

Run Query again.  The query can run for say 31 days with 1 day increments, hourly, etc.

Query run 5 times with 1 hour increments

Sorted by Minor Planet Name

Spot Checking the script

Plotting path on TheSky Display!

Great Reality Check!

Data Sort by Shortest Path

Results shown below

Screen showing Shortest Path taken

Check your path!

Here the filtering of all objects above 40 degrees declination is shown.  Look at the Altitude field.  And next sorting the list by the minimal telescope motion.

Minimum Telescope Motion

For comparison

Saving the Queries you have made

By saving your query you can then run it anytime without having to reenter the query parameters.  Use File Save As and assign your query a name.  You can save as many queries as you like, minor planet or otherwise!