Skip to content

Instantly share code, notes, and snippets.

@mfouesneau

mfouesneau/dstn.sql

Last active September 29, 2016 21:31
Show Gist options
  • Save mfouesneau/b6b25ed645eab9da4710153fcf9a4cb8 to your computer and use it in GitHub Desktop.
Save mfouesneau/b6b25ed645eab9da4710153fcf9a4cb8 to your computer and use it in GitHub Desktop.
Download ZIP
Gaia ADQL multiple position extraction
Raw
dstn.sql
SELECT TOP 5 source_id,ra,dec,phot_g_mean_mag,astrometric_excess_noise_sig FROM gaiadr1.gaia_source WHERE
CONTAINS(POINT('ICRS',gaiadr1.gaia_source.ra,gaiadr1.gaia_source.dec),CIRCLE('ICRS',18.69290, -0.00109,0.002777777777777778))=1
or
CONTAINS(POINT('ICRS',gaiadr1.gaia_source.ra,gaiadr1.gaia_source.dec),CIRCLE('ICRS',229.47509, 0.82868,0.002777777777777778))=1
or
CONTAINS(POINT('ICRS',gaiadr1.gaia_source.ra,gaiadr1.gaia_source.dec),CIRCLE('ICRS',229.46491, -0.79320,0.002777777777777778))=1
or
CONTAINS(POINT('ICRS',gaiadr1.gaia_source.ra,gaiadr1.gaia_source.dec),CIRCLE('ICRS',14.21622, 0.00584,0.002777777777777778))=1
@mfouesneau
Copy link
Author

mfouesneau commented Sep 29, 2016 •
edited
Loading

source_id ra dec phot_g_mean_mag astrometric_excess_noise_sig
4418634045995419392 229.46491238444054 -0.7932043721462791 17.876494376655305 532.0638316674941
2534626296344871040 18.69289815458169 -0.0010949322221137218 17.76603520626903 490.66818645726937
2536464164390771456 14.216221264621973 0.005841851016479788 17.387727446165446 491.06035079159113
4419132945102197632 229.47508733863964 0.8286805374949859 17.753608036257617 874.1061300448814

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment