AstrodbWeb: BDNYC Database

The BDNYC Database contains records for 1530 brown dwarfs and includes information such as photometry, parallaxes, spectra, etc.
The list of all available tables within the database can be found here.
The forms below allow you to explore the database by submitting an SQL query; performing a search by source ID, name, or coordinates; plot a spectrum; and check the inventory for a specific source.
You can also browse the database and examine the sources in a sky plot.

The current version of this database is that of Filippazzo et al. 2015. You can grab a copy of the BDNYC database here.
We encourage additions to the database via its Github repository.

This application runs on Python and utilizes the astrodbkit package to generate queries to the database. We recommend using astrodbkit to work with your astronomy SQL databases.
This application has been created by David R. Rodriguez; you can grab a copy of the code here for use with your own databases.

Publications that benefit from the BDNYC database should cite its Zenodo record; those that benefit from this application should also cite this record.

---

Browse the Database

---

Please type your SQL query below

SELECT t.name, p.band, p.magnitude, p.magnitude_unc FROM telescopes as t JOIN photometry AS p ON p.telescope_id=t.id WHERE p.source_id=4

Want some example queries? Try these out:

• SELECT shortname, ra, dec FROM sources WHERE (22<ra AND ra<24) AND (-15<dec AND dec<15)
• SELECT band, magnitude, magnitude_unc FROM photometry WHERE source_id=4
• SELECT source_id, band, magnitude FROM photometry WHERE band='z' AND magnitude<15
• SELECT t.name, p.band, p.magnitude, p.magnitude_unc FROM telescopes as t JOIN photometry AS p ON p.telescope_id=t.id WHERE p.source_id=4
• SELECT p1.magnitude-p2.magnitude FROM photometry AS p1 JOIN photometry AS p2 ON p1.source_id=p2.source_id WHERE p1.band='J' AND p2.band='H'
• SELECT s.id, p.parallax, p.parallax_unc, p.publication_id FROM sources as s JOIN parallaxes AS p ON p.source_id=s.id
• SELECT s.id, s.ra, s.dec, s.shortname, p.source_id, p.band, p.magnitude FROM sources as s JOIN photometry as p ON s.id=p.source_id WHERE s.dec<=-10 AND (p.band IN ("J","H","Ks","W1","W2"))

---

Search for an object

Search for objects by partial name matching (e.g., 0355 to find 2M0355+11) or within 1 arcminute of an RA, Dec coordinate (in degrees):

---

Plot a Spectrum

Plot the spectrum of an object by providing the spectrum ID (from the spectra table):
To get the IDs, you can do something like: SELECT sp.id, s.shortname, s.names FROM spectra AS sp JOIN sources as s WHERE s.id=sp.source_id

---

Check Inventory

Search the database for information on a particular source ID: