A Collection Without a Database Is Just Storage
Glass insulator collecting has a precise vocabulary that most people outside it don't know exists. The CD number — the Consolidated Design number from the N.R. Woodward classification system — is the definitive identification system for insulator profiles. CD 145, CD 257, CD 304: these numbers describe the shell geometry independently of who made it, what it's embossed with, or what color the glass is. Two CD 145s from different makers, different decades, and different colors are the same profile — different pieces, same CD. A collector who can't sort their inventory by CD number is working at a fundamental disadvantage.
The Glass Insulators template is built around this reality. The CD field is an integer, sortable and filterable, not a text string where someone might enter "CD-145" or "145" or "Hemingray 145" inconsistently across 400 records.
The Three Fields That Actually Determine Value
The CD number gives you the profile. The Manufacturer, the Primary Embossing, and the Color together determine what a specific piece is worth on the NIA guide and on the secondary market.
Primary Embossing is the raised text cast into the insulator's dome or petticoat during production. "HEMINGRAY-42", "BROOKFIELD", "W.U.TEL.CO" — each is a distinct primary embossing even if the CD profile is identical. Some embossings are common across millions of pieces and worth a few dollars regardless of condition. Others — certain Canadian Railway Signal variants, early California Glass Works pieces, specific patent dates — command prices that non-collectors would find startling for an object pulled off a crossarm.
Other Embossing covers secondary markings: mold numbers, drip points coded on the base, additional patent text that appears beneath or alongside the primary dome embossing. A piece without secondary embossing and a piece with a specific mold number combination can be catalogued-distinct items even when the primary embossing is identical.
The Color field is a free-text description rather than a dropdown, and this is correct. Insulator color description is a collector art form. "Aqua" and "light aqua" and "pale aqua" are different. "7-Up green" is a recognized colloquial descriptor for a specific yellow-green glass shade. "Purple" means naturally sun-amethyst glass turned by UV exposure, not purple glass. Forcing color into a controlled vocabulary list would compress the nuance that the community actually trades on.
Condition, Drip Points, and the Box It Lives In
The Condition field carries the physical assessment in open text — inner skirt chips, base chips, flakes, bruises, mint. The NIA uses specific language for grading and collectors who are serious about the market use that language precisely. A "base chip" in the wrong location on a high-value piece can drop its price by 80 percent.
Drip Points is the field that puzzles non-collectors. Drip points are the small pointed projections molded into the lower skirt of some insulators, designed to help water run off and improve insulation performance on wet lines. Their presence, absence, and specific type (sharp points vs rounded) are distinguishing characteristics that affect identification and in some cases affect value. Having a dedicated field for it rather than burying the note in a general condition field means you can filter by drip point type across the whole collection.
The Box # field is the physical inventory link. A serious collection spanning hundreds of pieces isn't displayed — most of it is packed and stored. Knowing that CD 257 Brookfield mint is in Box 14, item number 87, is the difference between finding it in three minutes when a buyer calls and spending an hour pulling boxes from shelves.
When the Collection Has 300 Pieces
At 300 items, filtering on CD number gives you an instant view of how many pieces of each profile you hold. Filtering on Manufacturer = Hemingray and Condition containing "mint" gives you your best Hemingray pieces in seconds. Sorting by Estimated Value descending surfaces your top-20 pieces immediately — useful for insurance documentation and for deciding what to move first if you're thinning the collection.
The Estimated Value field uses "My opinion/Current NIA book rounded $" as the hint text. The NIA Price Guide is the community reference, but individual collector judgment — local market conditions, recent show prices, known buyer demand for a specific variant — always sits alongside the book value. Keeping value as an editable field rather than an auto-calculated lookup means you can mark what you actually know, not just what the guide says.