<p>A project I'm working on involves getting data from SDSS DR12, and cross-matching it with NED, as described in Section 2 of <a href="https://arxiv.org/pdf/2001.06514.pdf" rel="nofollow noreferrer">this paper</a>:</p>
<blockquote>
<p>2.1 The sample</p>
<p>From the SDSS Data Release 12 (DR12, Alam et al. 2015), we extracted the first 33 643 QSOs with accurate spectroscopic redshifts (δz/z &lt; 0.01), which span the magnitude range r = 14.667 − 22.618. We then used the source coordinates to obtain the nearest source within a 6 arc-second search radius in the NASA/IPAC Extragalactic Database (NED), which usually resulted in a single match. As well as obtaining the specific flux densities, we used the NED names to query the Wide-Field Infrared Survey Explorer (WISE, Wright et al. 2010) and the Two Micron All Sky Survey (2MASS, Skrutskie et al. 2006) databases. For each of the bands3, the photometric points which fell within ∆ log10 ν = ±0.05 of the central frequency of the band were averaged, with this then being converted to a magnitude.</p>
</blockquote>
<p>(<a href="https://i.sstatic.net/JcWOI.png" rel="nofollow noreferrer">screenshot</a>)</p>
<p>I can find the SDSS DR12 on VizieR, and I know there are tools for cross-matching catalogs (I have <a href="http://www.star.bris.ac.uk/%7Embt/topcat/" rel="nofollow noreferrer">TOPCAT</a>) but I'm not sure of what steps to follow.</p>
<p>Can anyone give me some guidance on how to do the cross-match as per the paper, please?</p>

CC BY-SA 4.0
2021-01-20T00:46:50.697Z
I think this is a programming question, not an astronomy one. If you disagree, please elaborate in your question. The algorithm's idea is described in the quoted section. (and please quote text as text, not as image)
planetmaker
CC BY-SA 4.0
2021-01-20T00:57:45.370Z
@planetmaker programming is an essential tool used by astronomers for astronomical research, it's incorrect and unhelpful to give the impression that questions about astronomy programming would not be on-topic here simply because it focuses on programming. [Searching this site for "python"](https://astronomy.stackexchange.com/search?q=python) yields 379 posts for example. See also [this recent comment](https://astronomy.stackexchange.com/questions/40850/issues-in-dimensions-and-slicing-while-plotting-contours-over-a-fits-image-in-as#comment83363_40850).
uhoh
CC BY-SA 4.0
2021-01-20T01:01:15.270Z
@planetmaker What's even worse about that, *this question is not about programming!* TOPCAT is an already-written program; the question simply asks about using it as a tool to analyze astronomical data.
uhoh
CC BY-SA 4.0
2021-01-20T19:01:26.320Z
I'm not asking about programming -- I'm asking for help using a common astronomical tool, as @uhoh said.
Jim421616
<observational-astronomy><star-catalogues>
Cross-matching astronomical catalogs
Jim421616
# Cross-matching astronomical catalogs

(Asked by: username_0 on 2021-01-19)

A project I'm working on involves getting data from SDSS DR12, and cross-matching it with NED, as described in Section 2 of [this paper](https://arxiv.org/pdf/2001.06514.pdf):

> 2.1 The sample
>
> From the SDSS Data Release 12 (DR12, Alam et al. 2015), we extracted the first 33 643 QSOs with accurate spectroscopic redshifts (δz/z < 0.01), which span the magnitude range r = 14.667 − 22.618. We then used the source coordinates to obtain the nearest source within a 6 arc-second search radius in the NASA/IPAC Extragalactic Database (NED), which usually resulted in a single match. As well as obtaining the specific flux densities, we used the NED names to query the Wide-Field Infrared Survey Explorer (WISE, Wright et al. 2010) and the Two Micron All Sky Survey (2MASS, Skrutskie et al. 2006) databases. For each of the bands3, the photometric points which fell within ∆ log10 ν = ±0.05 of the central frequency of the band were averaged, with this then being converted to a magnitude.

([screenshot](https://i.sstatic.net/JcWOI.png))

I can find the SDSS DR12 on VizieR, and I know there are tools for cross-matching catalogs (I have [TOPCAT](http://www.star.bris.ac.uk/%7Embt/topcat/)) but I'm not sure of what steps to follow.

Can anyone give me some guidance on how to do the cross-match as per the paper, please?

**Tags:** observational-astronomy, star-catalogues
> **Comments:**
> **username_1**: I think this is a programming question, not an astronomy one. If you disagree, please elaborate in your question. The algorithm's idea is described in the quoted section. (and please quote text as text, not as image)  
> **username_2**: @planetmaker programming is an essential tool used by astronomers for astronomical research, it's incorrect and unhelpful to give the impression that questions about astronomy programming would not be on-topic here simply because it focuses on programming. [Searching this site for "python"](https://astronomy.stackexchange.com/search?q=python) yields 379 posts for example. See also [this recent comment](https://astronomy.stackexchange.com/questions/40850/issues-in-dimensions-and-slicing-while-plotting-contours-over-a-fits-image-in-as#comment83363_40850).  
> **username_2**: @planetmaker What's even worse about that, *this question is not about programming!* TOPCAT is an already-written program; the question simply asks about using it as a tool to analyze astronomical data.  
> **username_0**: I'm not asking about programming -- I'm asking for help using a common astronomical tool, as @uhoh said.  

---

## 0 answers

