Traveller Store CotI Features New Posts Mark Forums Read Register


Go Back TravellerRPG.com > Citizens of the Imperium > General Traveller Discussions > In the OTU

In the OTU In the Official Traveller Universe. Any milieux that's been published in any edition. Not for discussion of rules except in reference to how they reflect the OTU

Reply
 
Thread Tools Display Modes
  #1  
Old April 24th, 2021, 05:52 AM
harunmushod harunmushod is offline
Citizen: SOC-3
 
Join Date: Nov 2013
Location: London
Posts: 9
Gallery : 0
harunmushod Citizen
Default OTU UWP searchable database?

Is there an online database that is searchable on the basis of sector and ranges of individual planetary characteristics that are often included in adventures (particularly Amber Zones)?

E.g. adventure is set on a planet: Starport D-E, Siz 6-8, Atmo 5-8, Hydro 9-A, Pop 9-A, Gov any, Law 8+, TL any. What worlds fit those criteria in Trojan Reaches?

(Stats taken from: https://amber.zone/2021/04/22/amber-zone-spindrift/)

Is there a database where I could enter those ranges and get back a list of planets that fit those criteria in the Trojan Reaches?
Reply With Quote
  #2  
Old April 24th, 2021, 02:20 PM
whulorigan's Avatar
whulorigan whulorigan is offline
Count
 
Join Date: Mar 2008
Location: Philadelphia
Posts: 2,813
Gallery : 0
Visit whulorigan's Blog
whulorigan Respected Citizenwhulorigan Respected Citizenwhulorigan Respected Citizenwhulorigan Respected Citizenwhulorigan Respected Citizenwhulorigan Respected Citizen
Default

Quote:
Originally Posted by harunmushod View Post
Is there an online database that is searchable on the basis of sector and ranges of individual planetary characteristics that are often included in adventures (particularly Amber Zones)?

E.g. adventure is set on a planet: Starport D-E, Siz 6-8, Atmo 5-8, Hydro 9-A, Pop 9-A, Gov any, Law 8+, TL any. What worlds fit those criteria in Trojan Reaches?

(Stats taken from: https://amber.zone/2021/04/22/amber-zone-spindrift/)

Is there a database where I could enter those ranges and get back a list of planets that fit those criteria in the Trojan Reaches?

Try going to TravellerMap and see the "Tips and Tricks" section under the About Traveller Map menu.
__________________
.



WHULorigan (Wayne)

Lord Richard Elruinn Ilendrick Rhovanion of Rhylanor
Count RhovanionSPIN 2716 Rhylanor A434934-FSir Richard, Knight (Kt)SPIN 2716 Rhylanor A434934-F
MarquisSPIN 0433 Jone B792785-9Sir Richard Elruinn, Knight (Kt)FORN 0727 Dirli C994422-8
Baronet of Jae TellonaSPIN 2814 Jae Tellona A560565-8Knight of Deneb (KD)SPIN 2814 Jae Tellona A560565-8
Baron of the Third ImperiumSPIN 3220 Powaza C787566-5Knight of the Third Imperium (KTI)SPIN 3235 Trin A894A96-F
Knight of the Iridium Throne (KIT)CORE 2419 Sevan A544576-A
Richard Elruinn Rhovanion (TAS Member #0008)SPIN 2716 Rhylanor A434934-F

Other Awards
:
Duke of the Third ImperiumREAV 3209 Kylian BA57742-A
Duke of KhouthCORR 0104 Khouth A8C3999-D
Viscount of AlellSPIN 1706 Alell B56789CA
Baron of ImlaarDENE 2212 Imlaar D677551-6SEH - For Extreme Heroism @ The Battle of Ruby
Baroness of NorthammonDENE 0921 Northammon B764667-AMCGx2 - For Conspicuous Gallantry @ The Assaults on Dinomn & Denotam

Link: Traveller5 Noble Patents Registry
Reply With Quote
  #3  
Old April 24th, 2021, 02:48 PM
harunmushod harunmushod is offline
Citizen: SOC-3
 
Join Date: Nov 2013
Location: London
Posts: 9
Gallery : 0
harunmushod Citizen
Default

Quote:
Originally Posted by whulorigan View Post
Try going to TravellerMap and see the "Tips and Tricks" section under the About Traveller Map menu.
Thanks. That's exactly what i was looking for.
Reply With Quote
  #4  
Old April 24th, 2021, 07:06 PM
whartung whartung is offline
Citizen: SOC-14
 
Join Date: Nov 2004
Posts: 2,900
Gallery : 0
whartung Citizen+whartung Citizen+whartung Citizen+
Default

So for lulz I downloaded all of the Traveller Map sector data, and imported it in to a Sqlite database.

For the time being, it can be found here:

https://www.dropbox.com/s/vuc9xgedhj...map.db.gz?dl=0

It's GZipped, so you'll need to decompress it.

This is the schema:

Code:
CREATE TABLE STARSYSTEM (
    KEY NUMBER(10) NOT NULL,
    ALLEGIANCE VARCHAR, 
    ATMOSPHERE NUMBER(10), 
    BASES VARCHAR,
    CX VARCHAR,
    EX VARCHAR,
    GOVERMENT NUMBER(10),
    HEX VARCHAR,
    HYDROGRAPHICS NUMBER(10),
    IX VARCHAR,
    LAWLEVEL NUMBER(10),
    NAME VARCHAR,
    NOBILITY VARCHAR,
    PBG VARCHAR,
    POPULATION NUMBER(10),
    REMARKS VARCHAR,
    SIZE NUMBER(10),
    STARPORT VARCHAR,
    STELLAR VARCHAR,
    TECHLEVEL NUMBER(10),
    TRAVELZONE VARCHAR,
    UWP VARCHAR,
    WORLDS VARCHAR,
    SUBSECTOR_KEY NUMBER(10),
    PRIMARY KEY (KEY));

CREATE TABLE SECTOR (
    KEY NUMBER(10) NOT NULL,
    NAME VARCHAR,
    PRIMARY KEY (KEY));

CREATE TABLE SUBSECTOR (
    KEY NUMBER(10) NOT NULL,
    CODE VARCHAR,
    NAME VARCHAR,
    SECTOR_KEY NUMBER(10),
    PRIMARY KEY (KEY));
The assorted KEY values are arbitrary values used only for joining.

Any value from the UWP that doesn't fit as a hex value, has its corresponding field set to null.

So:

Code:
select sub.name, ss.hex, ss.name, ss.uwp 
from sector s, starsystem ss, subsector sub
where ss.subsector_key = sub.key
   and sub.sector_key = s.key
   and s.name = 'Trojan Reach'
   and ss.starport in ('D', 'E')
   and ss.atmosphere between 5 and 8
   and ss.size between 6 and 8
   and ss.hydrographics between 9 and 10
   and ss.population between 9 and 10
   and ss.lawlevel >= 8
   order by sub.name, ss.hex
 ;
Turns out there are zero systems that match this criteria.

This is a nice tool use run commands against the DB.

https://sqlitebrowser.org

Just download the file, gunzip it, then launch the tool and open it.

TMap has a service to return all of the sector names. And then one to return the data for the named sectors.

I can't speak to milieu, or anything like that. It was rather brutally shoved in.

There's 940 sectors, and over 156,000 systems.

If there's any glaring errors, I can correct them.
Reply With Quote
  #5  
Old April 26th, 2021, 09:56 PM
Kilgs Kilgs is offline
Citizen: SOC-14
 
Join Date: Apr 2007
Location: Midwest America
Posts: 1,129
Gallery : 0
Visit Kilgs's Blog
Kilgs Citizen++Kilgs Citizen++Kilgs Citizen++Kilgs Citizen++
Default

There is also an old program out there. I can't find it right now in my PC since I migrated everything into a new hard drive. It's called something... "What It's Like" and you enter a UWP. It spits out the possible planets in all of Charted Space and then it narrates what the morning/evening look like.

It's old. I'll dig around and see if I can find it.

But it definitely locates every planet based on UWP characteristics. Sort of a roundabout way but you get there...
__________________
"What's the point of watching out for assassins?" Floyt grouched. "The underhanded bastards are always sneaking up on us anyways."
Reply With Quote
  #6  
Old May 1st, 2021, 02:12 PM
harunmushod harunmushod is offline
Citizen: SOC-3
 
Join Date: Nov 2013
Location: London
Posts: 9
Gallery : 0
harunmushod Citizen
Default

Thanks all. The Travellermap search tips approach from whulorigan works for me, and is about as complex as I can handle. Grateful for the other suggestions though.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
How to create searchable PDF from scans w/o Acrobat Thunderbolt Classic Traveller 1 June 24th, 2008 04:44 PM
Searchable database R_Chance Recruiting Office 3 May 6th, 2008 10:17 AM
Didn't realize we were searchable... Spinward Scout Random Static 4 July 9th, 2007 10:22 PM
TML list server rebuilt - searchable again. far-trader The Lone Star 0 February 23rd, 2006 12:13 PM
UWP Database R_Kane In My Traveller Universe 4 October 1st, 2003 10:56 AM

This website and its contents are copyright ©2010- Far Future Enterprises. All rights reserved. Traveller is a registered trademark of Far Future Enterprises .
Powered by vBulletin® Version 3.8.4
Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright (c) 2010-2013, Far Future Enterprises. All Rights Reserved.