CAVEAT
These pages are a transcription of the /db/queries space of the former LSST Trac Wiki. In some places this content is quite dated and in need of revision. Please help!
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 dbScalableArchSQL 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
- 001 Extract light curve for a given object (time, magnitude and/or position)
- 006 Select the full color image of a single (given) galaxy
- 009 Find an object with a particular objectId
- 015 Select transient variable objects near a known galaxy
- 052 Give me astrometry for a given moving object
Analysis of all objects meeting certain criteria
In a region
- 003 Cone-magnitude-color search
- 014 Select all galaxies in given area
- 008 Select all variable objects in given area
- 007 Select time series data for all objects in a given area of the sky, in a given photometric band with a given variability index
- 050 How many objects cross both Jupiter and Saturn?
- 053 Select all unresolved objects (stellar PSF) in a given region of sky, and return their attributes
- 054 Select all unresolved objects in a specified region with cuts on attributes
- 055 For a specified patch of sky, give me the source count density of unresolved sources (star like morphology)
Across entire sky
- 002 Select all variable objects of a specific type
- 004 Random sample of the data
- 012 Find all objects similar to the colors of a quasar with redshift in a given range
- 018 Find quasars
- 010 Find stars with multiple measurements and with certain magnitude variations
- 011 Select all objects with certain variability or period or amplitude
- 020 Low-z QSO candidates using the color cuts
- 019 Select all "new" objects
- 030 The BRG sample. Create a volume-limited sample of luminous red galaxies with ? < z < ? $
- 021 Return moving objects whose motion uncertainty is smaller than measured motion
- 032 Find all galaxies brighter than given magnitude
- 033 Find all galaxies with a deVaucouleours profile (r¼ falloff of intensity on disk) and the photometric colors consistent with an elliptical galaxy $
- 037 Find extremely red galaxies
- 026 Find high proper motion white dwarf candidates
- 027 Select objects with proper motion
- 031 Select objects with a measured parallax
- 038 Find galaxies with an isophotal surface brightness (SB) larger than ? in the ? band, with an ellipticity > ? and with position angle between ? and ? arc seconds
- 035 Search for Cataclysmic Variables and pre-CVs with White Dwarfs and very late secondaries
- 063 Shape cut (select fuzzy objects) $
- 041 Galaxies with bluer centers $
- 039 Find possible stellar occultations by a given asteroid $
- 040 Provide a list of moving objects consistent with an asteroid $
- 042 Select diameter-limited sample of galaxies $
- 045 Select all variable extended objects
- 049 (Query Moving Object Catalog see ssd.jpl.nasa.gov) $
- 051 Select all asteroids with certain color parameters
- 056 Select time series for every object
- 057 Select light curves for all potentially variable objects which are currently not classified as variable objects $
- 062 Counts of objects that are unpaired between epochs $
- 005 Find new transients for given epoch $
- 066 Return info about extremely red objects $
- 068 Matching Source Catalog with the SimRefObjectCatalog through precomputed Match table
- 069 Matching Detected Stars with the !SimRefObject Catalog through precomputed Match table
Analysis of objects close to other object
Find objects near one object meeting criteria
Find objects near objects in a region, meeting criteria
- 022 Find near-neighbor objects in a given region
- 028 For each galaxy in the BCG data set (brightest color galaxy), in certain region, count the number of galaxies within ?" of it that have a photoz within ? of that galaxy$
Find objects near objects across entire sky, meeting criteria
- 013 Find all objects within ? arcseconds of one another that have very similar colors
- 024 Find galaxies that are blended with a star, output the deblended galaxy (or stellar) magnitudes $
- 034 Search for merging galaxy pairs, as per the prescription in Allam et al. 2004 $
- 029 Find the brightness of the closest source within ? arcmin $
- 047 Select all variable objects within certain distance of all known galaxies
- 043 Find stars with stellar neighbor within distance x where at least one of the stellar neighbors has the colors of a white dwarf
- 044 Find variable stars close to hot stars
- 046 For each galaxy in the BRG dataset, return those which have a neighbour closer than ? arcsec with ellipticity > ? and position angle <> ? $
- 065 Find all objects within some distance of one another that have very similar colors and light curves $
Analysis that require special grouping
- 017 Create a count of galaxies for each of the predefined areas which satisfy a certain color cut, generate output adequate for visualization $
- 025 Find all galaxies in dense regions $
- 036 Provide a list of star-like objects that are ?% rare
- 048 Select all variable objects in clusters $
Time series analysis
- 058 Find all objects that are varying with the same pattern as a given object, possibly at different time $
- 064 Find stars that have light curves like a simulated one $
- 059 Find all pairs of objects that have similar time series meeting certain criteria $
- 065 Find all objects within some distance of one another that have very similar colors and light curves $
- 067 Find Anomalies / Surprising Patterns in a Time Series $
- 071 Time machine: how will this object look like at time x $
Cross match with external catalogs
- 060 Joining LSST main catalogs with other catalogs (cross match) $
- 061 Joining LSST main catalogs with other catalogs (anti-cross match) $
Quality Assurance
Questions to Science Collaborations
See dataAnalysisQuestions Questions about Data Analysis Queries