<p>What about <a href="http://heasarc.gsfc.nasa.gov/db-perl/W3Browse/w3table.pl?tablehead=name%3Dbsc5p&amp;Action=More+Options" rel="nofollow">BSC5p</a> for stars brighter than magnitude 6.5? The "<a href="http://heasarc.gsfc.nasa.gov/W3Browse/star-catalog/bsc5p.html#alt_name" rel="nofollow">alt_name</a>" "is usually the Flamsteed and/or Bayer constellation-based name for the star".</p>

<p><a href="http://tdc-www.harvard.edu/catalogs/index.html" rel="nofollow">Here</a> a list of more advanced catalogs.</p>

<p><a href="http://www.rssd.esa.int/index.php?page=common&amp;project=HIPPARCOS" rel="nofollow">Here</a> a list of some common star names for Hipparcos numbers. Probably not much different from your query result.</p>

<p><a href="http://en.wikipedia.org/wiki/List_of_proper_names_of_stars_in_alphabetical_order" rel="nofollow">On Wikipedia</a> a probably more complete list of more or less wide-spread common star names.</p>

<p>Those common names often are not unique, and not all common names are widely accepted. That's probably why they aren't provided in the star catalogs.</p>

<p>The only way I could imagine to get a solution is to convert the Wikipedia table to a csv file, and to import it to a database table used as a relation from the various catalog names to the proper names. That will probably need quite a bit of manual work.</p>

<p>None of the naming systems is complete, not even necessarily unique. Stars frequently turn out to be not one, but several stars, or no star at all. At some point it's easier to use 'scientifics'.</p>

CC BY-SA 4.0
2021-04-07T20:12:18.463Z
You could also look at SIMBAD or similar
Mad Physicist
CC BY-SA 3.0
2014-01-30T14:32:50.817Z
I can't find any I can download and import to PostgreSQL. (CSV like HYG Database).
Magno C
CC BY-SA 3.0
2014-01-30T14:42:16.103Z
Did you try   4. / Output Format / Excel compatible ?
Gerald
CC BY-SA 3.0
2014-01-30T15:37:24.047Z
Yeap. Their names are still 'scientifics' and some cases even doesn't exists. HYG Database uses Hipparcos data.
Magno C
CC BY-SA 3.0
2014-01-30T15:46:21.403Z
The Wikipedia list is what I'm looking for. I want to find `Alniyat` and not `Tau Sco`, for example.
Magno C
CC BY-SA 3.0
2014-01-30T16:07:14.173Z
Those common names often are not unique, and not all common names are widely accepted. That's probably why they aren't provided in the star catalogs. The only way I could imagine to get a solution is to convert the Wikipedia table to a csv file, and to import it to a database table used as a relation from the various catalog names to the proper names. That will probably need quite a bit of manual work. None of the naming systems is complete, not even necessarily unique. Stars frequently turn out to be not one, but several stars, or no star at all. At some point it's easier to use 'scientifics'
Gerald
CC BY-SA 3.0
2014-01-30T16:12:04.593Z
Understood. You're right. Please put it as an answer because I think consistent enough to be considered an answer.
Magno C
CC BY-SA 3.0
2014-01-30T16:19:36.857Z
@MagnoC: Ok, it's done.
Gerald
CC BY-SA 3.0
2014-01-30T16:25:53.943Z
`Alniyat` is a good example what you said. It's `Tau Sco` AND `Sigma Sco`.
Magno C
CC BY-SA 3.0
2014-01-30T13:57:08.087Z
2014-01-30T16:22:52.793Z
2014-01-30T16:22:52.793Z
Gerald
<p>Related to <a href="https://astronomy.stackexchange.com/questions/1556/convert-coordinates-between-ra-dec-and-wgs-84-srid-4326">Convert coordinates between RA/dec and WGS 84 (SRID=4326)</a>.</p>

<p>WARNING: I'm a noob in astronomy.</p>

<p>After import all stars from HYG Database (<a href="http://www.astronexus.com/node/34" rel="nofollow noreferrer">http://www.astronexus.com/node/34</a>) I noticed some missings:</p>

<p>1) NGC catalog seems to have other names ( maybe Gliese )</p>

<p>2) Some stars have catalog names when could have simple (commom) names ('Mimosa' is 'Bet Cru').</p>

<p>In fact, I think the HYG Database is too professional (
<code>select count(*) from hygn where proper_name is not null</code> gives me only 87 stars) and keep the stars names more scientific.</p>

<p>Is there another database like <code>HYG Database</code> I can try?</p>

<star>
Star names and the HYG Database
Magno C
# Star names and the HYG Database

(Asked by: username_0 on 2014-01-30)

Related to [Convert coordinates between RA/dec and WGS 84 (SRID=4326)](https://astronomy.stackexchange.com/questions/1556/convert-coordinates-between-ra-dec-and-wgs-84-srid-4326).

WARNING: I'm a noob in astronomy.

After import all stars from HYG Database (<http://www.astronexus.com/node/34>) I noticed some missings:

1) NGC catalog seems to have other names ( maybe Gliese )

2) Some stars have catalog names when could have simple (commom) names ('Mimosa' is 'Bet Cru').

In fact, I think the HYG Database is too professional (
`select count(*) from hygn where proper_name is not null` gives me only 87 stars) and keep the stars names more scientific.

Is there another database like `HYG Database` I can try?

**Tags:** star


---

## 1 answers

### Answer by username_1 on 2014-01-30. Score: 3 | Accepted answer

What about [BSC5p](http://heasarc.gsfc.nasa.gov/db-perl/W3Browse/w3table.pl?tablehead=name%3Dbsc5p&Action=More+Options) for stars brighter than magnitude 6.5? The "[alt\_name](http://heasarc.gsfc.nasa.gov/W3Browse/star-catalog/bsc5p.html#alt_name)" "is usually the Flamsteed and/or Bayer constellation-based name for the star".

[Here](http://tdc-www.harvard.edu/catalogs/index.html) a list of more advanced catalogs.

[Here](http://www.rssd.esa.int/index.php?page=common&project=HIPPARCOS) a list of some common star names for Hipparcos numbers. Probably not much different from your query result.

[On Wikipedia](http://en.wikipedia.org/wiki/List_of_proper_names_of_stars_in_alphabetical_order) a probably more complete list of more or less wide-spread common star names.

Those common names often are not unique, and not all common names are widely accepted. That's probably why they aren't provided in the star catalogs.

The only way I could imagine to get a solution is to convert the Wikipedia table to a csv file, and to import it to a database table used as a relation from the various catalog names to the proper names. That will probably need quite a bit of manual work.

None of the naming systems is complete, not even necessarily unique. Stars frequently turn out to be not one, but several stars, or no star at all. At some point it's easier to use 'scientifics'.

> **Comments:**
> **username_0**: I can't find any I can download and import to PostgreSQL. (CSV like HYG Database).  
> **username_1**: Did you try   4. / Output Format / Excel compatible ?  
> **username_0**: Yeap. Their names are still 'scientifics' and some cases even doesn't exists. HYG Database uses Hipparcos data.  
> **username_0**: The Wikipedia list is what I'm looking for. I want to find `Alniyat` and not `Tau Sco`, for example.  
> **username_1**: Those common names often are not unique, and not all common names are widely accepted. That's probably why they aren't provided in the star catalogs. The only way I could imagine to get a solution is to convert the Wikipedia table to a csv file, and to import it to a database table used as a relation from the various catalog names to the proper names. That will probably need quite a bit of manual work. None of the naming systems is complete, not even necessarily unique. Stars frequently turn out to be not one, but several stars, or no star at all. At some point it's easier to use 'scientifics'  
> **username_0**: Understood. You're right. Please put it as an answer because I think consistent enough to be considered an answer.  
> **username_1**: @username_0: Ok, it's done.  
> **username_0**: `Alniyat` is a good example what you said. It's `Tau Sco` AND `Sigma Sco`.  
> **username_2**: You could also look at SIMBAD or similar  

---

