HeraldicArt.org: Traceable Art | Armorial | Indices | Emblazons | Blog

A SQL Interface for the SCA Armorial

As powerful as the Morsulus O-and-A software is, it’s not particularly easy to install and get running on your own computer, and it’s a bit daunting to extend with new functionality.

I had an idea that it would be easier to work with the armorial data if it was loaded into a regular SQL database, and spent my weekend putting together a proof-of-concept implementation.

The results are available as Clerk-0.1.tar.gz, a pair of Perl scripts designed to work with a MySQL database. Continue reading “A SQL Interface for the SCA Armorial”

Interfaces to the Armorial Database

I’m working on some possible improvements to the web interface used to search the SCA’s heraldic database, known colloquially as the “O and A,” short for “Ordinary and Armorial.”

(Traditionally, an armorial is a printed listing of armory registrations with their blazons and the names of their holders; mundane armorials typically include all, or all of the notable, registrations within a certain heraldic jurisdiction. An armorial is typically organized alphabetically by the holder’s name; in contrast an ordinary is a specialized index used for looking up armory based on its blazon or appearance, grouping registrations under their primary charges.)

For decades the SCA’s armorial database has been maintained and distributed as a delimited text file, but searching it by hand in this format is inconvenient, and so there are several tools that provide an interface to this data. Continue reading “Interfaces to the Armorial Database”

OSCAR Color Gamuts

While there are a wide range of colors that can be used for digital renditions of heraldic art, the set of colors that gets discussed most often in the context of SCA submissions is the one used for OSCAR’s “color checker” display.

When armory images are uploaded to OSCAR, color-checker thumbnails are generated which convert each area to one of these standard tinctures. This doesn’t mean you should use those specific colors in your graphics, but it does simplify things if the colors in your image are not transformed incorrectly.

The tinctures used by OSCAR’s color-checker thumbnails are shown in dashed circles below, with outlines delimiting the range of colors that are converted to each of those targets.

(Click for a larger image, or download a printable PDF.)

While the color-checking process usually goes smoothly, there are a few things to watch out for:

  • Warm golds (containing more red than green) can end up being rendered as orange or brown.
  • Warm browns can develop streaks or splotches of red.
  • Blues and purples can become ambiguous if they come too close to the violet boundary.
  • Although not apparent on this chart, fine-line details, like black outlines within a charge or around an argent charge in a fieldless badge, can disappear entirely, so it’s better if the overall silhouettes of your charges are still recognizable without that detailing.

Many thanks to Elena Wyth for the experimentation which allowed these OSCAR ranges to be estimated.

Heraldic Search Shortcuts

I’ve put together an integrated search page that allows you to easily run search queries against a number of different websites that contain useful heraldry information.

It was inspired by similar collections of search shortcuts posted by Morsulus Herald and Sofya la Rus, but I’ve added a bit of JavaScript to make the interface less repetitive. I’ve extended the list of search targets with some other useful sites including OSCAR, some of the onomastic reference books posted by Wenyeva atte grene, and some old armory books I have been using as sources for images for the Book of Traceable Heraldic Art.

I hope it may prove useful to others — if there are websites that seem of general interest that I have omitted please feel free to point them out and I’ll see if I can add them as well.