Skip to content

Instantly share code, notes, and snippets.

@brianv0

brianv0/adql.sql

Created March 30, 2016 23:59
Show Gist options
  • Save brianv0/c258bed55efc4836ad9a327d39756f89 to your computer and use it in GitHub Desktop.
Save brianv0/c258bed55efc4836ad9a327d39756f89 to your computer and use it in GitHub Desktop.
Download ZIP
adql example
Raw
adql.sql
SELECT *
FROM "II/295/SSTGC","II/293/glimpse"
WHERE 1=CONTAINS(
POINT('ICRS',"II/295/SSTGC".RAJ2000,"II/295/SSTGC".DEJ2000),
BOX('GALACTIC', 0, 0, 30/60., 10/60.)
)
AND 1=CONTAINS(
POINT('ICRS',"II/295/SSTGC".RAJ2000,"II/295/SSTGC".DEJ2000),
CIRCLE('ICRS',"II/293/glimpse".RAJ2000,"II/293/glimpse".DEJ2000, 2/3600.)
)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment