search

SIMPLE-AstroDB / SIMPLE-db

Curated collection of data for low mass stars, brown dwarfs, and directly imaged exoplanets.
https://simple-bd-archive.org/
BSD 3-Clause "New" or "Revised" License
11 stars 22 forks source link

Complete Test Source #149

Open Will-Cooper opened 3 years ago

Will-Cooper commented 3 years ago

Can we find an object (or multiple) with complete information including: photometry (as much as possible); parallaxes, proper motions, radial velocities, etc?
Would allow me to do some plot creation, for which I'll need a test object to get working.
We could always make a dummy object but it would be nice to have something real yet well explored.

kelle commented 1 year ago

I would like this too. A source also with a bunch of spectral data.

kelle commented 10 months ago

@Will-Cooper , is this still high priority for you? It's related to #444 .

Will-Cooper commented 10 months ago

Yes, this is the main blocker (bar time) on me making some fun plots like Toomre diagrams

kelle commented 10 months ago

I used this SQL Query to identify 1366 sources with at least one photometry measurement and a parallax and a proper motion. We don't have any radial velocities at the moment. test_sources.csv

That didn't narrow it down very much, but it's a start!


SELECT  Photometry.source, Parallaxes.parallax, ProperMotions.mu_ra, ProperMotions.mu_dec, COUNT(Photometry.source)
FROM Photometry
INNER JOIN Parallaxes ON Photometry.source = Parallaxes.source
INNER JOIN ProperMotions ON Photometry.source = ProperMotions.source
GROUP BY Photometry.source, Parallaxes.source, ProperMotions.source
HAVING COUNT(Photometry.source) > 1
ORDER BY COUNT(Photometry.source) DESC