VSA - SQL Query Results

#userTable file: xab
#userTable rows: 100000
#userTable columns: col1,col2,col3

Submitted query: select u.*,c.*,s.sourceID,s.ra,s.dec,s.jAperMag3,s.jAperMag3Err,s.hAperMag3,s.hAperMag3Err,s.ksAperMag3,s.ksAperMag3Err from #usertable as u outer apply htm.dbo.fGetNearestVHSSourceEQ(u.col2,u.col3,2.0/60.0) as c left outer join vhssource as s on c.sourceId=s.sourceID

Start: Tue Nov 17 20:33:14 GMT 2020 End: Tue Nov 17 20:36:04 GMT 2020

Database: VHSDR6

(Query returned 100000 result rows, only the first 30 rows are shown in the displayed table.)

  col1 col2 col3 sourceID distance sourceID ra dec jAperMag3 jAperMag3Err hAperMag3 hAperMag3Err ksAperMag3 ksAperMag3Err
1 3666713262491912192 +215.6717873 +2.2766713 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
2 3712683152158821760 +202.5332635 +2.8023995 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
3 3712925461329478912 +203.0398286 +3.9047895 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
4 3712892475980656896 +202.8564902 +3.6009562 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
5 3712812452150011648 +203.3228756 +3.3501501 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
6 3712749127152102912 +201.9138076 +3.0241700 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
7 3712914839874940800 +203.2867878 +3.8557681 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
8 2183729740310348288 +312.0930038 +55.0926380 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
9 3712864747671860096 +203.5650809 +3.8005669 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
10 3712737719718980736 +202.3583963 +2.9896189 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
11 3712781184788073856 +202.4219543 +3.2922504 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
12 3712727171279294464 +202.1649947 +2.8011864 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
13 3712858597278688000 +203.5332391 +3.6588690 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
14 3712955457380322048 +201.5481746 +3.2036901 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
15 3712955457380978816 +201.5481473 +3.2041340 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
16 3712737719718300672 +202.3588619 +2.9896566 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
17 3712709304215389056 +202.6250042 +2.9286697 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
18 3712967719512641920 +201.7098013 +3.4318373 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
19 3712819667695006976 +202.9123503 +3.3173907 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
20 3712819667695007104 +202.9125446 +3.3182490 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
21 4119638866956595968 +268.5251503 -18.6296592 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
22 4119635774578068992 +268.7343598 -18.6544972 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
23 4119658520729649408 +268.4119340 -18.4161102 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
24 4119631479605891712 +268.1988644 -18.6357363 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
25 2183769047851717248 +310.9283928 +55.1624206 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
26 4119642406037689728 +268.7970774 -18.5820595 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
27 1882703076027294976 +343.9093894 +25.9364129 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
28 4119658280215974912 +268.3774384 -18.4415005 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
29 4119661063349017984 +268.5999608 -18.3907879 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000
30 4119660925910063488 +268.5780448 -18.4103639 0 +0.0000000E000 0 +0.0000000E000 +0.0000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000 +0.000000E000

(Query returned 100000 result rows, only the first 30 rows are shown in the displayed table.)

Download Results File , your results in a gzipped CSV ASCII file (Contains 100000 rows, 3.6 MB)