Re: [nbos] Star Chart Base Data Release.
"Robert Graham"
Mon Jun 13th, 2011

This is from memory Dalton, I can't find the original Excel database which
had a lot of the original calculation data..

But it is

x = Distance * cos(RA) * Cose(Dec)
y = Distance * sin(Dec)
z = Dist * Cos(Dec) * Sin(RA)

where distance = r in the table.. from memory.. It's been a while and I did
it from a set of books etc I've been trying to find my old excel file.

Hopefully it helps... with out unpacking a lot of astronomy books and the
like I'm not 100% certain these days.
I'll see if I can't find the excel file on one of my drives (I can hope).

-a cold rob at 5am ;)

-----Original Message-----
From: []
On Behalf Of Dalton Calford
Sent: Tuesday, 14 June 2011 4:18 AM
Subject: Re: [nbos] Star Chart Base Data Release.

Hi Rob,

Any chance of getting the calculations you used for x,y,z from the RA/Dec?

Also, are there any newer databases available online for star data?

Best regards


-----Original Message-----
From: []
On Behalf Of Robert Graham
Sent: Monday, June 13, 2011 8:03 AM
Subject: Re: [nbos] Star Chart Base Data Release.


Well basically by and by, the data your seeing there.. is the data that
created the 100, 200, 500, 1000, 10000 LY products I put out when Astro 2
came out, hence why in some respects they likely look familiar ;).

You can read it in as a tab-deliminated file but you'll need to modify the
file slightly.. you'll need to remove the insert into starchart values (

And take it from a tab deliminated or comma deliminated to being deliminated
by ' ' marks.

But I'll see about doing a mdb dump if I get a chance I can't promise
though I've not had a load of time of late and I've been feeling less then
above the weather.


-----Original Message-----
From: []
On Behalf Of Mike Oliver
Sent: Monday, 13 June 2011 8:13 PM
Subject: Re: [nbos] Star Chart Base Data Release.


See my on-going correspondence with Rob. I admire your ability to handle the
math - I'm not sure I could. I also own the T2300 package and started
playing around with the data provided on their tables compared to more
"serious" info. I found one or two discrepancies but nothing serious. I got
into correspondence with somebody on more or less the same tack that you are
taking but I've lost track of it. I'll try to find it and see if any of it
looks like it might be useful to you.

Rob's file, imported into Excel as a csv file, looks very much like the
Kepner lists I used for my AS2 Star Trek map and my next step is to see if
it will go into AS2 with a little juggling.



-----Original Message-----
From: []
On Behalf Of Cam Kirmser
Sent: 12 June 2011 20:32
Subject: Re: [nbos] Star Chart Base Data Release.

> Mike,
> If I'm not wrong with out needing an actual MySql or MS sql databse
> you
> use Microsoft access to import the file.
> -Rob

True, you can. Or, download - what is it, SQL Express? MySQL? Something like

I've been working on the same sort of thing, but trying to attach as much as
possible to real stars. Then, something most catalogues don't take into
account, I adjust for their distance from Earth. In other words, most - if
not all - star catalogs, like Hipparcos - give coordinate data for how the
star is seen from Earth. Makes sense; after all, the catalog is not a
navigation tool, but a viewing tool. So, armed with the star's X, Y, Z data,
I then take the star's distance from Earth in LYs and then adjust
accordingly using the star's real motion. With that, I then record the
actual position of each star, not just the apparent position from Earth.

The problem that arises is that, often, the star's radial velocity is not
provided. I've got a database for Traveller, T2300 and Star Trek that, I
think, is correct for the local group of 50 LY. It's been about a year since
I've worked on it, maybe two, so I'd have to go over it to make sure it's
clean. But, I think it is. I've got data for every known star, something
like 120,000 records and a bit cumbersome for AS as a whole.

Nbossoftware mailing list

Nbossoftware mailing list

Nbossoftware mailing list

Nbossoftware mailing list

Nbossoftware mailing list

Copyright © 2003-2007, NBOS Software. All rights reserved. 'Fractal Mapper', 'ScreenMonkey', 'Character Sketcher', 'Inspiration Pad', 'Fractal World Explorer', 'Goblin API', 'AstroSynthesis' are trademarks of NBOS Software. 'Dwarven Beserker' art by V. Shane.
Member contributed resources