wiki:db/queries/040
Last modified 6 years ago Last modified on 02/01/2013 12:12:47 AM

Provide a list of moving objects consistent with an asteroid

SELECT  objectId,                                            -- return object ID
        SQRT( POWER(rowv,2) + POWER(colv, 2) ) AS velocity   -- velocity
FROM    MovingObject                                         -- check each object
WHERE  (POWER(rowv,2) + POWER(colv, 2)) BETWEEN 50 AND 1000  -- square of velocity (units?)
                                                             -- big values indicate error

This query originally came from SDSS (S-15)

---

-LJ

This is another SDSS query that I'm not sure how it translates to LSST. What does 'consistent with an asteroid' mean? In SDSS, movingObject is different than our movingObject, because our movingObjects are orbits - SDSS are basically Objects with some velocity.

We could certainly do a query where we check if the q/e/i/node/argperi/timeperi+errors of the movingObject is consistent with orbital parameters of another asteroid, within some error bound. I'd have to check how we would translate to/from the covariance matrix for the orbital errors though.

Is this consistent with the spirit of the original query? (the original query above talks about velocity, not orbital parameters).