wiki:db/queries
Last modified 5 years ago Last modified on 12/09/2013 12:28:13 PM

Common Queries

This document contains a compilation of expected LSST common queries. It is based on extrapolations of some past and existing surveys (e.g. SDSS, SuperMacho) and input from the LSST Science Collaborations. It is intended to be similar to the so-called "SDSS 20 Queries". The queries are ordered based on their importance. Importance is calculated based on input from the LSST Science Collaborations.

Note that we only support a somewhat restricted subset of SQL, these restrictions are described here).

Notation:

  • :value indicates input value

$ indicates that the query has not been written or the LSST schema does not support it yet.

The queries

Analysis of a single object

Analysis of all objects meeting certain criteria

In a region

Across entire sky

Analysis of objects close to other objects

Find objects near one object meeting criteria

Find objects near objects in a region, meeting criteria

Find objects near objects across entire sky, meeting criteria

Analysis that require special grouping

Time series analysis

Cross match with external catalogs

Quality Assurance

Questions to Science Collaborations

See Questions about Data Analysis Queries

Attachments