Page 1 of 2

Gazzateer of the Dread Realms

Posted: Wed Dec 02, 2009 3:09 pm
by Vlad
Hi all,

I collect two D&D world, Ravenloft (complete) and Forgotten Realms (almost complete). While DMing both, I always encounter the problem (moreso in FR, but also in RL), that I find it hard to get all info on one place since I have so many books of RL/FR (not counting netbooks, novels, etc). I have played with the idea of creating a sort of (geographical) gazzateer with reference to all places/NPCs to make my life easier as a DM. I intended to make one for the FR (although my PCs are in RL right now, strange me... :? ) first. Turns out that there is already something similar for the FR into being... so than to the other world, RL.
I do know that there was an encyclopedia on the old Kargatane site, but I don't know if that was complete (don't want to do more than necessary of course).

I did a little bit on FR, as allready told, here you can see what it looks like:
http://rapidshare.com/files/314966117/1 ... r.xls.html

My questions:
1. Is there something similar already somewhere on the net?
2. If not, is the format used in the attachment right? Do you miss something?

Grz,
Vlad

Posted: Wed Dec 02, 2009 3:16 pm
by Gonzoron of the FoS
I can't look at your file from work, but is this kind of thing you're looking for:

The Companion Atlas to the Ravenloft Gazetteers

?

There's also the (incomplete) RL catalogue

Posted: Wed Dec 02, 2009 3:30 pm
by Vlad
Nope, although a great link as well, I didn't intend to make a map/atlas, but an excelfile, where you can use the filter function (on places, NPCs, unique magic items, etc). It looks like your second link (the incomplete catalogue, which I referred to in my first post). I wanted to keep it simple, therefore no webapplication, just plain excel.
Not really an catalogue either, more like a gazzatteer arranged by placename (although you can filter on every entry you like of course).

Posted: Wed Dec 02, 2009 4:06 pm
by Gonzoron of the FoS
Sorry, read your post quickly and didn't notice the reference to the Catalogue.

I also forgot to mention this:
List of Canon & Fanmade Ravenloft material, in excel That may be close to what you're looking for, though it doesn't have any fancy features for narrowing down to an area, you can simply search it for a place name, as you can with the Catalogue (in the catalogue, click on "show me records related to ...." for more on that location.)

Posted: Wed Dec 02, 2009 4:44 pm
by Vlad
Wow that comes pretty close. I did have something different in mind (see attachment, when you are able to do so), something more structured around places. It's an impressive piece of work, though

Posted: Wed Dec 02, 2009 5:36 pm
by Ail
There's always the raw files on which the Catalogue is based. It might be translatable to an Excel file :-s

Posted: Wed Dec 02, 2009 5:44 pm
by Ail
Gonzoron of the FoS wrote:Sorry, read your post quickly and didn't notice the reference to the Catalogue.

I also forgot to mention this:
List of Canon & Fanmade Ravenloft material, in excel That may be close to what you're looking for, though it doesn't have any fancy features for narrowing down to an area, you can simply search it for a place name, as you can with the Catalogue (in the catalogue, click on "show me records related to ...." for more on that location.)
This list is impressive! :-O

Who had the patience to type it in, and check all the sources? I assume this was a collective work?

Posted: Wed Dec 02, 2009 8:41 pm
by Catman Jim
Ail wrote:Who had the patience to type it in, and check all the sources? I assume this was a collective work?
I believe it was Joel that did all the work, and I remember doing the checking. (cell A41) :wink:

Posted: Thu Dec 03, 2009 9:17 am
by Gonzoron of the FoS
Ail wrote:There's always the raw files on which the Catalogue is based. It might be translatable to an Excel file :-s
.... or something.

Foreshadowing!

Posted: Thu Dec 03, 2009 10:33 am
by Ail
Gonzoron of the FoS wrote:
Ail wrote:There's always the raw files on which the Catalogue is based. It might be translatable to an Excel file :-s
.... or something.

Foreshadowing!
:shock: What do you mean? Do you have plans?

Well, I actually checked what files I had from the catalogue in my system. Yesterday I was too tired to look for them, but now I did.
I do have an excel file with a version from it, dated from March 2006 at the latest. It's not very presentable though, and I think it's a direct import from the .db files you or Joël sent me.

But on the other hand, I checked the FR gazetteer presented by the OP and I don't think it's a good structure either, so I'd prefer the RL Catalogue, personally.

Anyway, the main problem with my excel file is all the HTML tags. I could remove those easily, I just don't know if it would be suitable for the OP.

For reference, the file has the following columns:

- Id (just a unique number for each record)
- Name (whatever concept is being described)
- Type (existing types: city, domain, event, item, location, magic, monster, npc, society)
- Sources (published books and fan work)
- Artwork (same)
- Stats / Rules (same)
- Description (same)
- Maps (same)
- See also (other relevant articles in the catalogue)
- Created
- Last Modified

It would give something perhaps similar to the FR gazetteer if the records in each line were fully separated and demultiplied, but then it would produce a HUGE database, perhaps more than what Excel can hold.
It is currently at 2942 lines. If I were to demultiply all the book references, some records could turn into as many as 10000 lines or more, so it's not worth it. But perhaps I could try to forget some columns. Don't know, this requires some thought and the OP input.

Posted: Thu Dec 03, 2009 11:03 am
by Gonzoron of the FoS
Ail wrote:
Gonzoron of the FoS wrote:
Ail wrote:There's always the raw files on which the Catalogue is based. It might be translatable to an Excel file :-s
.... or something.

Foreshadowing!
:shock: What do you mean? Do you have plans?
It wouldn't be foreshadowing if I answered that question. It would be an announcement. And I'm not announcing anything right now.

(Let's just say, don't waste too much of your time on any fancy manipulations on the catalogue.)

BTW, since you last hacked on the catalogue database, I've added a few fields:
Alias (alternate names for the subject)

And four flags that can be on/off:
Canon (described in Canon products)
Kargatane (described in Kargatane netbooks)
FoS (described in Fraternity of Shadows Netbooks)
MotRD (Masque of the Red Death subsetting)

Posted: Thu Dec 03, 2009 11:22 am
by Ail
Gonzoron of the FoS wrote:
Ail wrote:
Gonzoron of the FoS wrote: .... or something.

Foreshadowing!
:shock: What do you mean? Do you have plans?
It wouldn't be foreshadowing if I answered that question. It would be an announcement. And I'm not announcing anything right now.

(Let's just say, don't waste too much of your time on any fancy manipulations on the catalogue.)

BTW, since you last hacked on the catalogue database, I've added a few fields:
Alias (alternate names for the subject)

And four flags that can be on/off:
Canon (described in Canon products)
Kargatane (described in Kargatane netbooks)
FoS (described in Fraternity of Shadows Netbooks)
MotRD (Masque of the Red Death subsetting)
Ok, I won't push the envelope then :-)
But I'm excited with the news, anyway...

As for those additions, they're very useful too!
And with a little bit of luck they can be computed almost automatically from the info already in the catalogue.

Good work!

Posted: Thu Dec 03, 2009 11:44 am
by Joël of the FoS
Ail wrote: Who had the patience to type it in, and check all the sources? I assume this was a collective work?
At first, this index was something I started for myself, a work of dark obsessions you might say :) I fully understand what JWM meant in his "labor of love" comments about his RL timeline :)

Then the list grew very big and I thought it was a fine complement to the kargatane catalogue, which was then at a temporary stall. Also, it referenced all netbooks, which weren't in the K catalogue.

I always tried to include the domain where the entry was found. So with Ctrl-F, a DM could quickly see what were the feartures fo this place.

Being French, I did the list with French words in many of the entries. So when the project was moved to become a public one, I translated many things and then I asked Catman Jim to reread the entries to make sure all the French words I used in the list were transmutted to English. I'm sure there are still a few of these still hidden in the file :)

Joël

Posted: Thu Dec 03, 2009 11:48 am
by Joël of the FoS
Since my list includes all netbook stuff, it would be cool to merge the K catalogue and my list into one big data-golem. :)

Joël

Posted: Thu Dec 03, 2009 2:06 pm
by Gonzoron of the FoS
Ail wrote:As for those additions, they're very useful too!
And with a little bit of luck they can be computed almost automatically from the info already in the catalogue.
True, but I didn't go that far. I just filled them in myself, and any new entries now prompt the editor to fill them in as they enter data.