---
# System prepended metadata

title: Testing Hipscat Gaia vs ESA Gaia Service

---

# Testing Hipscat Gaia vs ESA Gaia Service


- [ ] 

Author: Andy Tzanidakis (atzanida@uw.edu)

Here I run a very simple test to check it the `epyc.washington` hipscatted Gaia DR3 catalog is consistent with the official ESA gaia_dr3.source catalog. 

### Testing Locally

We will first begin with our local version: 
```python=
gaia = lsdb.read_hipscat("/data3/epyc/data3/hipscat/catalogs/gaia_dr3/gaia")
```

We will query a 100" cone search around an open cluster: 
```python=
# Coordinates to open cluster
ra, dec = 132.8460000, +11.8140000

rad = 100 # in arcseconds
_sample = gaia.cone_search(
    ra=ra,
    dec=dec, radius_arcsec=100)

print (_sample.compute().shape())
>> (61, 155)
```
**From the above we can see that we have found 61 sources in the following query.**

Now, we will perform the same search on the ESA Gaia service

### Testing with ESA `gaia_dr3.source`

Now we will run a simple AQDL query of the same search: 

```SQL!
SELECT * 
FROM gaiadr3.gaia_source 
WHERE 
CONTAINS(
	POINT('ICRS',gaiadr3.gaia_source.ra,gaiadr3.gaia_source.dec),
	CIRCLE('ICRS',132.846,11.814,0.027777777777777776)
)=1
```

![Screen Shot 2024-03-24 at 12.52.51 PM](https://hackmd.io/_uploads/rkZs4W0Cp.png)

**hooray!** From the above we can see that there's also 61 rows (i.e., 61 sources found within this cone search radius)



