Online Access to Visnjan Observatory Image Database
Authors: Mario Juric,
Korado Korlevic
Visnjan Observatory is a scientific and educational institution situated in the Istrian peninsula of Croatia. Our primary scientific field of interest are the minor bodies of the Solar system, commonly divided into meteors, comets and asteroids. Of these three, asteroids (rocky bodies 1-1000 km in diameter) are by far the most abundant, projections of their numbers ranging from a couple of hundred thousands to millions. Besides being of purely scientific interest as the leftovers from the creation of the Solar system, asteroids are of wider concern to humanity because of the potential threat they pose. Tough most of the asteroid population resides in the "asteroid belt" between Mars and Jupiter, in recent years it's been found that a smaller population of asteroids, commonly referred to as NEOs (Near Earth Objects) resides in orbits crossing Earth's orbit. Such asteroids have the possibility of colliding with Earth, with possibly catastrophic results - an option that we (the global asteroid research community) hope to avoid by detecting a potential impactor early enough to divert and/or destroy such a civilization threatening object. We at Visnjan Observatory are helping this effort with our asteroid search and NEO orbit determination (astrometric followup) programs.
Currently, there are around 100,000 known asteroids, and around 1500 NEOs. That number has ballooned from a number in low tens of thousands from just a couple of years ago, propelled by heightened awareness and increased spending in asteroid related research. Each of these objects has it's motion through the solar system defined by it's orbit, a set of 7 numbers ("orbital elements") which unfortunately, due to deterministic chaos, is not cast in stone. Therefore, the position of each of those 100,000 asteroids has to be measured from time to time to, colloquially speaking, "improve it's orbit". It is obvious that with 100,000 objects, a number which is rising rapidly, the data analysis and decision making process has to be automated and a set of new tools developed. We have internally tried to answer the most commonly asked questions ("what part of the sky to image", "what asteroids needs to be measured", "is this asteroid already known or it's a new one") with a integrated database and software system called VOID (Visnjan Observatory Image Database), and it's second Oracle8i based incarnation VOID 2 (or V2 for short).
V2 consists of a central Oracle8i based database which contains at least the orbital elements of each of the currently known asteroids. That allows us to calculate where each of those asteroids is at the moment and plan our observations accordingly. In this database, we have also stored information on images taken at the Visnjan Observatory (coordinates of the images, time at which the image was taken and all other relevant information), and measurement information (astrometric measurements of asteroids).
The raw data, as just described, is of no use - to analyze and process it a set of Win32 based applications (known as the Rings suite) has been developed. Rings consist of a large number of smaller application each with it's own task (i.e. "Gandalf" - image processing, "Elrond" - database and sky visualization, etc.). These tools provide us with a unique datamining capabilities were already used successfully in developing a new method of asteroid observations which gained us a 2-fold increase in search efficiency (see Juric).
As an effort to make these tools publicly available, we have chosen to create a World Wide Web interface to the database and these tools (the "V2 Web"). V2 Web has been conceived to have a dual purpose - both educational and of interest to the general public, and one of more scientific orientation. Also, we see the V2 Web as a portal to asteroid related information not only contained in VOID 2, but also located elsewhere on the web. It's requirements can be summarized in the following :
Of interest to asteroid research community :
Of interest to general public
We have (hopefully) at least partially solved the simple query problem by introducing a "Generalized Query Facility" or GQF, which shall be elaborated in the following section. To solve the visualization problem, we've chosen VRML 2.0 as the technology of choice. Through VRML, result sets (mostly asteroid positions or asteroid orbits) can be visualized in 3D.
Generalized Query Facility (GQF) is a web based graphical/textual interface to underlying tables of the VOID 2 database. VOID 2 is an Oracle8i database - therefore it consists of a series of tables, each of which contains a specific set of data. From the V2 Web user's point of view, there are three main tables (currently, only the Asteroids table is publicly available) :
Each of these tables consists of columns of data. For example, some of the columns of Asteroids table are designation, numeration, discovery place, etc. There are also columns relating to orbital elements (elements of standard Keplerian orbit and photometry related columns). A complete reference of Asteroids table columns can be found here. Analogous situation exists for Measurements and Images tables.
While such datafiles of different properties are nothing new to the astronomical community (see for some excellent examples [Bowell, E. ], [Marsden, B. G. and Williams G. ]), that data is usually distributed in bulk text or binary datafiles. While very convenient for some applications (calculating current positions, doing calculations on complete datasets), it is difficult to use such bulk data for more complicated analysis. To answer even simple questions like Give me a list of asteroids whose major semiaxis is between 20 and 30 and inclination does not exceed 10 and observational arc is less than 100 programs or scripts have to be written. This significantly reduces the potential for quick data analysis, or for even more complex queries.
We have created GQF as a tool for rapid multidimensional analysis of data contained in VOID 2 datafiles. GQF enables the user to interactively query VOID 2 tables in a simple and yet powerful way. Before explaining how to write GQF queries, here are some examples :
| Select designation, numeration, arc, orbit where i > 45 |
| Select designation, numeration where observatory is 'Visnjan' order by discoveryDate |
| Select count(distinct ast) where ocSurname is 'Williams' |
| Select orbitComputer, count(distinct ast) group by orbitComputer |
An example GQF entry form is
shown below. This form is used to query for asteroid related data.
Figure 1 - A standard GQF entry form
Where conditions have the
following general form :
Examples of conditions are :
Individual conditions can (and should!) be connected to form more complex ones by a set of logical connectors. Currently available logical connectors are and and or. Also, it is possible to parenthesize the conditions and then join them with logical connectors. Here are a couple of examples :
Group by row is used in queries which use aggregate functions like count or sum. Here the columns are listed according to which the user would like the result of the query to be grouped before the aggregating has occurred. For example, let's say a count of how many asteroids were numerated from each observatory is desired. Then, the user would write a query satisfying the "numeration exists" condition, and after evaluating that query, the results should be split in groups according to discovery place, after which each of those groups is counted. The result of the query is the number of asteroids in each group, that is, the number of asteroids which were discovered from each observatory.
Here, the sort order of the returned rows is specified, that is, the columns which should be used for sorting. Columns are comma separated.
Figures 2. and 3. - A snapshot of VRML model of positions all currently known asteroids shown under two different zoom settings - the first image shows the inner part of the solar system, nicely showing the asteroid belt between Mars and Jupiter, while the second image shows the trans-Neptunian object population of the outer Solar system.
This is the simplest possible 3D model - the database was queried for all known asteroids. The blue circles designate planet orbits - Mercury, Venus, Earth, Mars, Jupiter, etc. The white dots indicate the positions of the asteroids returned by the query at the time the query was given. A number of things can be seen from this image: most of the asteroid population (as expected) is concentrated between Mars and Jupiter in the asteroid belt. There are two large populations of asteroids situated at L4 and L5 Langrange points of Jupiter's orbit - the so called "Trojans". What is also visible is an apparent population of asteroids in the vicinity of L3 Langrange point - something, interestingly enough, not widely discussed in the current asteroid dynamics literature!
The second image is the same 3D model, just zoomed out. The last visible orbit in this case is the orbit of planet Neptune, and the asteroids residing beyond that orbit are known as trans-Neptunian objects (TNOs). There are also some pretty obvious (and interesting things) to note just from a quick glance on this image. For one, there are two diametrically opposing gaps in the distribution of TNOs, at the spot in the sky where the Milky Way, our galaxy, lies. This indicates the technical inability of today's survey programs to work in densely populated regions of the sky. The second thing to notice are "radial streaks" of asteroids - a result of the fact that most of TNOs have been discovered by a very few search programs. These streaks indicate the locations where the search took place.
What was shown here is just a 2D snapshot of a 3D model. For a full view we suggest you visit the gallery at the VOID 2 website.
We've also set up a gallery of predefined 3D views, which can be accessed by a simple click. We hope this will motivate the casual user to try using more complex GQF facility.
VOID 2 as a database and a backbone of the operations of Visnjan Observatory has been in successful use for over a year. Through VOID 2 website we have tried to make that functionality available to the rest of the scientific community as well as the general public. Specifically, we have tried to fill in a gap in datamining tools which existed before introduction of VOID 2 Web, by creating the Generalized Query Facility - a simplified, more user friendly form of putting SQL queries against the VOID2 tables. The output of those queries is a set of tabular data or a 3D models of the resulting dataset. This 3D visualization capability coupled with GQF querying ability is to our knowledge a unique Web service in this field of science (minor body research).
Finally, V2 Web is, as all web projects are, a never-ending story. New features are constantly being added and old are being revised to further improve and simplify access to immense quantities of data which are becoming available in the field of minor body science. By creating and updating V2 Web we hope to have given a valuable tool to the scientific community interested in asteroid research. V2 web is accessible at http://void.astro.hr/.
Mario Juric
Student at Faculty of Natural Sciences and Mathematics, University
of Zagreb, Zagreb, Croatia;
majuric@astro.hr
Korado Korlevic
Visnjan Observatory, Visnjan, Croatia;
korado@astro.hr