Re: [nbos] Star Chart Base Data Release.
"Mike Oliver"
Sun Jun 12th, 2011
Hi Rob:

As you probably recall, I'm no tecchie. I'd love to have a look at what
you've been doing (I've just offered up my Star Trek sector map on DropBox
and am looking at doing a Star Trek RPG soon using the Last Unicorn rules)
but I have no idea how to read your "SQL Dump" file.

Can I read the data into MS Excel as a csv file, or into Access or can you
suggest a piece of software I can use to produce something that will load
into AS2?

Cheers,

Mike
www.warmodelling.co.uk

-----Original Message-----
From: nbossoftware-bounces-at-nbos.com [mailto:nbossoftware-bounces-at-nbos.com]
On Behalf Of Robert Graham
Sent: 11 June 2011 11:55
To: nbossoftware-at-nbos.com
Subject: [nbos] Star Chart Base Data Release.

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



_______________________________________________
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