[nbos] Star Chart Base Data Release.
"Robert Graham"
Sat Jun 11th, 2011
Hi guys,

After some careful thought and everything into if I was feeling nice or not,
I've decided to actually be nice and release the actual core database for
the Star Chart data that I did for Astro 2.

Please be warned that this is a SQL file dump, you will need to be able to
read SQL into what ever program you attempt to look at it with on the other
hand it does include all of the following fields which help if you are
trying to work out where I got the data etc from I've added some comments in
here ;)


id` int(11) NOT NULL auto_increment, ---- this is just the id in the
case of this 1 - 87476
`sys` varchar(10) NOT NULL default 'star', ----- This defaults to Star
because that's what these are in Astro
`starid` varchar(30) NOT NULL default '0', --- Same as Id really but for
Astro rather then the database.
`hip` varchar(30) NOT NULL default '0', ---- this is the Hip catalog
number
`hd` varchar(30) default NULL, -- this is the HD catalog number
`hr` varchar(30) default NULL, --- This is the HR catalog number
`gliese` varchar(20) default NULL, -- This is the Gliese Catalog number
`bayerflamsteed` varchar(20) default NULL, -- This is the Bayerflamsteed
catalog number
`commonname` varchar(100) default NULL, -- This is the common name where
avalible.
`RA` varchar(30) NOT NULL default '0', -- This is the Right Ascession
Data as listed in the catalogs.
`DEC` varchar(30) NOT NULL default '0', -- This is the Declination as
listed in the catalogs.
`DISPar` varchar(30) NOT NULL default '0', -- this is the calculated
distance in Parsec
`DISLY` varchar(30) NOT NULL default '0', -- This is the calculated
distance in Light years.
`R` varchar(30) default NULL, -- I honestly can't remember obviously
something I used to calculate junk
`e` varchar(30) default NULL, -- I honestly can't remember obviously
something I used to calculate junk
`x` varchar(30) NOT NULL default '0', -- X co-ord from Sol
`y` varchar(30) NOT NULL default '0', -- Y Co-ord from Sol
`z` varchar(30) NOT NULL default '0', -- Z co-ord from Sol.
`mag` varchar(30) default NULL, -- Star Magnitude
`lum` varchar(30) default NULL, -- Star Lum
`mass` varchar(30) default NULL, -- Star Mass
`absmag` varchar(30) default NULL, -- Absolute Magnitude
`spect` varchar(50) default NULL, -- Spectral Type
`colindex` varchar(30) default NULL, -- Color index



You can dl the dump of this at

http://www.star-fleet.org/downloads/starchart.sql.zip

All I ask is if you use it that you please at least give me some credit for
the work I put into doing it.

Regards

Rob.

_______________________________________________
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