FS_ tables are the T4 version, named ‘First Survey’ as it is circa year M0 of the 3I.  All the other tables are based on the M1100 data from the Genie files. TL_DIFFS has TL data for each world from both sets. Numworlds, I THINK, are just the UWP’s for each system in the sectors, I don’t remember what I made that table for :-/

I have a view that breaks out the UWP individually for the FS_ data I believe it’s in there.

It’s been a long time since I looked at these files…I have them loaded into our Oracle DB at work where they’re my ‘testing things’ schema. 

I have a much newer version of DBVisualizer now that should make proper SQL dumps with inserts instead of having to massage the data. I’ll strip out the oracle-specific syntax in the DDL and post it where the other one is.  That’ll make it a lot easier to load up!


On May 24, 2019, at 9:41 AM, Vareck Bostrom (via tml list) <xxxxxx@simplelists.com> wrote:

I presume “SECTORS” is the newer (T4) version and FS_SECTORS is the sunbane version? Do you have a description of which .dat/.ddl files are from which source? 

I do filter out my dataset for Milleu=M1105 and either OTU, Official, Reserve or InReview tags, which should limit the amount of non-canon data in there (aside from Reserve, I suppose). I have to leave InReview in as there is quite a lot InReview. 



On May 24, 2019, at 8:39 AM, Bruce Johnson <xxxxxx@Pharmacy.Arizona.EDU> wrote:

There are two datasets in the file: one is the ancient “Genie” DGP dataset, I believe it’s a copy-ish of the MegaT atlas of the Imperium. I believe I downloaded that from the old Sunbane FTP site back in the day. http://wiki.travellerrpg.com/Sunbane has info.

Those original sector files are also available here: http://dbdev2.pharmacy.arizona.edu/tprogs.html


 The other is the data from the T4 rules set, Marc put that up for downloading.  I’m confident that what I have is correct as to the content of those originals, but I”m not sure about the accuracy of the data to what is now canon.

The Travellermap dataset includes many non-canon sectors which may account for the difference in world count.

-----
The Traveller Mailing List
Archives at http://archives.simplelists.com/tml
Report problems to xxxxxx@simplelists.com
To unsubscribe from this list please go to
http://www.simplelists.com/confirm.php?u=SVsSnnCJk1ACiTghqxnWgr8yCl9WeXKi


-- 
Bruce Johnson
University of Arizona
College of Pharmacy
Information Technology Group

Institutions do not have opinions, merely customs