SELECT s1.jMag, s1.b,
(s1.ra-s2.ra)*3600.0*COS(RADIANS(s2.dec)) as deltaRA,
(s1.dec-s2.dec)*3600.0 as deltaDec,
(s1.jmh-s2.jmh) as djmh,
(s1.hmk_1-s2.hmk_1) as dhmk
FROM gcsSource AS s1, gcsSource AS s2, gcsSourceNeighbours AS x
WHERE s1.jMag>0.0 AND s1.jClass=-1 AND s2.jMag>0.0 AND s2.jClass=-1 AND
s1.hMag>0.0 AND s1.hClass=-1 AND s2.hMag>0.0 AND s2.hClass=-1 AND
s1.k_1Mag>0.0 AND s1.k_1Class=-1 AND s2.k_1Mag>0.0 AND s2.k_1Class=-1 AND
masterObjID=s1.sourceID AND slaveObjID=s2.sourceID AND distanceMins<0.0166667
AND s1.jmh>-0.9e9 AND s1.hmk_1>-0.9e9 AND s2.jmh>-0.9e9 AND s2.hmk_1>-0.9e9
AND s1.sourceID < s2.sourceID
AND distanceMins IN (
SELECT MIN(distanceMins)
FROM gcsSourceNeighbours
WHERE masterObjID=x.masterObjID
)
SELECT s1.jMag, s1.b,
(s1.ra-s2.ra)*3600.0*COS(RADIANS(s2.dec)) as deltaRA,
(s1.dec-s2.dec)*3600.0 as deltaDec,
(s1.jmh-s2.jmh) as djmh,
(s1.hmk_1-s2.hmk_1) as dhmk
FROM gpsSource AS s1, gpsSource AS s2, gpsSourceNeighbours AS x
WHERE s1.jMag>0.0 AND s1.jClass=-1 AND s2.jMag>0.0 AND s2.jClass=-1 AND
s1.hMag>0.0 AND s1.hClass=-1 AND s2.hMag>0.0 AND s2.hClass=-1 AND
s1.k_1Mag>0.0 AND s1.k_1Class=-1 AND s2.k_1Mag>0.0 AND s2.k_1Class=-1 AND
masterObjID=s1.sourceID AND slaveObjID=s2.sourceID AND distanceMins<0.0166667
AND s1.sourceID < s2.sourceID
AND (s1.jObjID % 4) = 0
AND distanceMins IN (
SELECT MIN(distanceMins)
FROM gpsSourceNeighbours
WHERE masterObjID=x.masterObjID
)
SELECT s1.j_1Mag, s1.b,
(s1.ra-s2.ra)*3600.0*COS(RADIANS(s2.dec)) as deltaRA,
(s1.dec-s2.dec)*3600.0 as deltaDec,
(s1.j_1mh-s2.j_1mh) as djmh,
(s1.hmk-s2.hmk) as dhmk
FROM lasSource AS s1, lasSource AS s2, lasSourceNeighbours AS x
WHERE s1.j_1Mag>0.0 AND s1.j_1Class=-1 AND s2.j_1Mag>0.0 AND s2.j_1Class=-1 AND
s1.hMag>0.0 AND s1.hClass=-1 AND s2.hMag>0.0 AND s2.hClass=-1 AND
s1.kMag>0.0 AND s1.kClass=-1 AND s2.kMag>0.0 AND s2.kClass=-1 AND
masterObjID=s1.sourceID AND slaveObjID=s2.sourceID AND distanceMins<0.0166667
AND s1.sourceID < s2.sourceID
AND distanceMins IN (
SELECT MIN(distanceMins)
FROM lasSourceNeighbours
WHERE masterObjID=x.masterObjID
)
- so I selected neighbouring sources out to 1 arcsec with the same
set of passband detections as overlapping sources, only selecting
one way (i.e. not double counting source 1 differenced with source 2
and source 2 differenced with source 1) and taking only the
nearest match in each case.I've also used data from the LAS,
GPS and GCS.
The data are further broken down as a function of magnitude and
Galactic latitude for the purposes of examining the RMS (robustly
computed as 1.48x median of absolute deviation to guard against
non-Gaussian outliers affecting the results); note that in the
following plots the sigmas have been divided by 1.414 to indicate the
accuracy of a single measure as determined from the difference of two
measures:
Notes:
| I | Attachment | Action | Size | Date | Who | Comment |
|---|---|---|---|---|---|---|
| | extastsummary.gif | manage | 12.6 K | 09 Aug 2005 - 09:40 | NigelHambly | |
| | extastdetails.gif | manage | 11.5 K | 09 Aug 2005 - 09:55 | NigelHambly |
![]() |
Click here for the AstroGrid Service Web |
This is the AstroGrid Development Wiki |
|