Where can I find a comprehensive online database for stellar data analysis?

  • Context: Undergrad 
  • Thread starter Thread starter robertrej
  • Start date Start date
  • Tags Tags
    Database Stellar
Click For Summary

Discussion Overview

The discussion revolves around finding a comprehensive online or downloadable database for stellar data analysis, particularly for applications in gyrochronology. Participants explore various sources of astronomical data and their usability for analyzing large datasets.

Discussion Character

  • Exploratory, Technical explanation, Debate/contested

Main Points Raised

  • Bob seeks a detailed stellar database for analyzing large batches of data, noting that NASA's previous database is no longer available.
  • One participant suggests the Sloan Digital Sky Survey as a potential resource for Bob's needs.
  • Bob acknowledges the usefulness of the Sloan Digital Sky Survey but mentions needing to improve his SQL skills to utilize it effectively.
  • Another participant recommends Vizier as a good source for various astronomical data, including databases like SDSS.
  • Bob shares that he is currently using the NASA Exoplanet database for its simplicity and mentions its ability to convert results to CSV format for further analysis.
  • Bob reports a successful star search yielding 56,000 results, indicating the database's capability to handle extensive data.

Areas of Agreement / Disagreement

Participants express differing preferences for various databases, with no consensus on a single best option. Bob's exploration of multiple sources indicates ongoing evaluation of their effectiveness for his specific needs.

Contextual Notes

Bob's search for a suitable database is influenced by the need for specific features such as batch data analysis and ease of use. The discussion reflects varying levels of familiarity with different databases and tools.

Who May Find This Useful

Individuals interested in stellar data analysis, astronomy research, or those working on projects related to gyrochronology may find this discussion relevant.

robertrej
Messages
7
Reaction score
0
I am looking for a On line or downloadable stellar highly detailed database.
Nasa had a excellent one but seemed to remove it from (NASA Star and Exoplanet Database (NStED).
Wiki has lots of detail on there website but its star by star basis.I want to analyse
large batches of stellar data at once.

the website simbad is ok but lacks complete info.

I may begin some work in Gyrochronology but need rotational velocity.

Thanks very much
Bob
 
Astronomy news on Phys.org
robertrej, welcome to Physics Forums!

Is what you are seeking here at the Sloan Digital Sky Survey?

http://www.sdss.org/
 
Yes that looks very good, I just have to brush up on my SQL a bit .
The Nasa database was a little easier to use but I believe this one is more complete
and I can produce very precise reports .
I will follow up a bit later as to my progress.


Thanks
Bob
 
"Gyrochronology"

I thought I'd kept up with the field, but that's a new one to me ! Many Thanks for teaching me a new word and a fascinating technique !
 
Vizier is a good source of all kinds of astronomical data. It includes a large number of databases, including SDSS.
 
Well for now I am back to the Nasa Exoplanet database due to its simplicity.
I am able to search for star data if I go to Modify field .They have a convert results to CSV format function which I can than import to MYSQL and work with that data as I see fit.
I performed a star search which produced 56,000 results.( mass = .4 -2.4).

CSV = comma separated data file format.
MYSQL -Oracle: open source database program.

Have a good week
Bob
 

Attachments

  • nasa-exoplanet.jpg
    nasa-exoplanet.jpg
    65.8 KB · Views: 524

Similar threads

High School Where can I find a downloadable database of stars?
  • · Replies 11 ·
Replies
11
Views
4K