On Jan 17, 2018, at 4:01 PM, Ethan Henry <xxxxxx@gmail.com> wrote:

Hello Travellers. Long time, no see.

So the other day I was curious about the distribution of a bunch of things in the official Imperial survey data so I pulled the raw data from travellermap.com, tweaked it a bit by hand and then pulled it into a google spreadsheet to do some analysis.

You can play with the sheet here: https://docs.google.com/spreadsheets/d/1hAOoxliGdlaWbJ4DTL3ICMFZH5OH18-ISFjw7HpNimE/edit?usp=sharing

Feel free to make a copy and tweak the pivot tables yourself if you like that sort of thing.

For example 93% of the population of the Marches is on the 42 pop 9 & A worlds. There are 397 other inhabited worlds that make up the remaining 7% of the population of the Marches. So there's a lot of concentration of population and a lot - A LOT - of empty space to hide if you want to.

92B of the 375B of the sophonts in the Marches live on a TL 8 or lower world. 50B live at TL 8. That's like 6.7 Earth's at today's TL.

There are 14 TL 5 Agricultural worlds. There's one extremely high-tech Ag world, Tenalphi, that's TL E, size 7 and has 60M inhabitants. It's a nearly Earth-like planet that basically only has New York state and California, or a country between the size of France & Italy. Quite possibly the population is distributed over the entire planet so it ends up being endless Kansas.

Anyway, if you also like spreadsheets, have a look.

If anyone is interested I have the original GENIE (aka DGP, aka MT era?)  and T4 data available in generic sql format at http://dbdev2.pharmacy.arizona.edu/archives/tdata.tar.gz I have imported it into MySQL without an issue. It’s sparsely documented, but if anyone has any questions let me know.

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

Institutions do not have opinions, merely customs