The 100% Free Database to the Best
African Violets in the world

Why use Pauli? It's free, frequently updated, has registered and unregistered cultivars, and is reviewed by a horticulturist taxonomist and Saintpaulia experts for accuracy. It is the ONLY AFRICAN VIOLET DATAFILE ANYWHERE that works on PC and Mac platforms, any laptop, netbook, Blackberry, nook, Kindle, Sony Bookreader, Palm, iPad, "clouds" like Google Fusion Tables, Google Docs, and nearly any phone including iPhone and Droid. You can modify it many ways for your projects including trade, sale, want, show, and collection lists. Now your AV data goes everywhere you and your plants go!

Main Links: Introduction - Downloads
Data: Cultivar Count=2000+ Datafield Codes
Versions: Current=1.3  Current version changes  History
Add your new cultivar - Cultivar selection tips
Violet Cloud (all software + data online): Google Fusion Tables - Google Docs
Non-PC Platform support:
Blackberry   Droid  iPhone Linux   Mac  nook Palm
Data format support:  CSV   DBF  Linux  Oracle  Quatro Pro  XLS
Developer support: Open Source - 
Developers Wanted
Plant sources: see Collection field links and also Internet source links to the best cultivars
Collection Management: Tutorial
Link to Pauli - Program and Version History
Author: About - Contact

Google Fusion Help
PDF Reports - nook Support - Open Source/Open Office Support
Copyright/Access Rights - FAQ/Help Topics - How to cite as a literature reference

Current Version is now 1.3 (2000 different cultivars)

Version changes include:
  1. 400 new cultivars - welll actually a few are vintage but new the Pauli
  2. Minor data corrections listed as (updated) in the Cultivar name field
  3. CULTIVAR FINDER with active, internet source links in the Collection field. If you obtain the plant just erase the link and include your accession data
  4. New character states for leaf type
    1. "white-margined undulate" - wavy with a white to cream leaf edge
    2. "pink-margined undulate" - wavy with a blush to pink leaf edge
    3. "white-margined clacamas" - white edge or marks plus the Cladamas type blade
* If you already use version 1.0 or 1.1 AND have modified it with data you need to keep (ie. new cultivar, collection or trade data)
*  If you're downloading PAULI for the first time OR have no existing 1.0 and 1.1 changes to save - use the following links

1. VIOLET CLOUD - GOOGLE FUSION TABLE - no direct link is allowed - A) load, B) select More menu from their top bar, C) select Even More at the bottom, D) click on Fusion tables, E) enter site or click Take Tour, F) enter Pauli in the search box, G) click the Paul AV listing that comes up - Once the table of data loads goto the View menu and click Filter. Enter your search criteria there.
2. XLS spreadsheet with all instructions and Autofilter (for Microsoft Excel and other compatible system reading XLS files). You can use this with other programs including Quatro Pro and pretty much an Microsoft product that imports XLS files including Access.  We dropped the first sheet into a blank Access table and it converted like a charm. XLS files are popular because more than 200 computers programs use XLS or Excel files as an exchange or import format.

3. Open Office Calc - free open source spreadsheet at least as good as Excel and Quattro Pro. Open Office is from Sun Microsystems and has been developed over two decades. It is just as good as Windows Office and is in some ways superior in our opinion. Goto and download the best version or your computer. Then import in the XLS Spreadsheet version of Paul from the link above in 2. Open Office Calc is a Microsoft Excel clone and much more!

4. Quatro Pro from the Word Perfect Suite - import the XLS format file from under 2. above. 

5. Microsoft Access and other relational database programs - this is going to be the most capable of all systems for serious data management, report generation, and collection management. Don't have one of these expensive programs? 
Goto and download their very capable Access clone called Open Office Base. We have tested Pauli with both Access and OOB. Basically you drop the XLS file format (see 2. above) into a Table screen using the procedure recommended for important spreadsheet data. There is also the DBF file import route (see 8. below)

6. iPhone support - very nice options:
7. CSV file format (for use in comma-delimited databases or export). Most systems will accept XLS but if not this is a good small version. If you are a "tinkerer" do-it-yourself programmer who likes to use simple data separated by commas such as a BASIC, VISUAL BASIC, C++, or other code, do consider this format. This will work in DOS and many other non-PC environments with ease.

8. DBF file format for systems using the dBase style data. Be aware that many systems working with DBF files also import XLS files so consider using both.

9. DOCUMENTS 2 GO is a software platform that works on many handheld devices, phones, PDAs etc. Their website explains the details for Blackberry, Palm, iPhone, Droid, Google Ion, HTC, CLIO, T-Moble, and dozens of other products. This affordable software program will let you view Pauli files in Excel (XLS) and Adobe (PDF) formats.

10. DROID SUPPORT - Several nice choices:
11. Google Docs - Only version 1.1 is available at this time due to our current user testing project. Please the XLS or Google Fusion Table version for the newer versions.

12. Oracle support (Windows/Linux/Unix)  -
while Sun's Open Office is impressive their mainframe, heavy duty Oracle product has advantages for the search data cruncher. It competes with Microsoft Access and their own Open Office Base but you get powerful report functions, security, and it runs on Windows, Linux, and Unix systems. Single users start at $180.00 if you register 5 or more users (May 2010). The or XLS2Oracle open source code will get Pauli XLS files to Oracle with ease.

13. Mac OS X 10.5 (Tiger) and higher -
we recommend the programs Open Office Calc (most users) and Open Ofifce Base (advanced users) as both will accept the Paul XLS format.

14. Linux - choices include:
  1. or Open Office with Calc and Base programs which take Pauli XLS files with ease.
  2. Sun's Oracle platform supports database management at the very highest levels and with a price to match ($180 per user with a 5 user min)

13. Reports (fixed tables derived from database) - not sortable or searchable - but quicker for reference. These are best for phones and tablet devices which do not have spreadsheet or database software but can use PDF files.

Links are encouraged:

1. Copy the above small logo to your webpage
3. If you wish to be listed as a source for violet cultivars, please send us your link, showing the active Pauli link to and we'll add you. No sources will be listed until your link is posted and available to the public.

Version 1.3

PAULI is not intended to be a complete database of the 21,000 or so named clones, 90% of which are out of the trade, nor is it an official register of any society or ICRA. Some claim over 40,000 clones are named if you count numbered hybrids. You and I can only buy or trade for a fraction of that total so the rest is pure academic history. This searchable, sortable file is being developed in the public interest by the New Ornamentals Society (, the longest serving plant society devoted To horticultural taxonomy and cultivar selection. Our first cultivar selection computer database (ConiferBase) dates from 1982 and the NOS now offers over 2 Gigs of data.

We hope to provide a modern, practical, and did we mention...100% free... database to the best cultivars in the trade today.
PAULI uses basic Autofilter technology, producing pull-down menus to let you select a cultivar on one to eight criteria. We expect two, three, or four criteria to be most common in selections.

HOW TO SELECT CULTIVARS: Click on the downward black arrow next to the datafield names (Corolla Color, Color Type, Habit etc.). There are many possible combinations. If the arrows are missing, select the entire block or range of data  then goto Data - Autofilter. 
USE A YOUR COLLECTION DATABASE: download a copy. Use the Collection datafield to record what you Have, are offering for trade (leaf or plant), for sale (leaf or plant), as a want list, etc. You can then select a list of each category to produce a want list, Trade list, sales list, etc. Do remember that you can add as many new cultivars and records as you want with this this free, open format.
Such as Corolla Color=white and Habit=Semi for a white-flowered semiminature.

Copyright 2011. Laurence C. Hatch. All Rights Reserved. Please cite this work as follows: Hatch, L.C. 2011. Pauli. African Violet XLS Database. Your rights: you must agree to all these terms or your rights to use this product or retain any copies is immediately terminated: 1. You may download up to three copies for Personal or commercial use on various devices (desktop, laptop, Blackberry, iPad, iPhone, or other spreadsheet reader), 2. You may not distribute any copies yourself and That includes any modifications or changes of any kind to this document – all distirbution is via download only. 3. You are encouraged to link to this System but only via Direct links to any spreadsheet filename or URL are not permitted. 4. You may distribute lists and reports if not in XLS or ODS format So long as the spreadsheet itself is not copied nor is is distributed with more than 70% of content conveyed via any means, method, website, or portal. 5. This is not a public Domain document, it is not subject to “fair use”. 6. If this document in whole or part is used for distribution in an educational or commercial context for which tuition, consulting Fees, class fees, seminar charges, or other compensation is paid you must be a member of the New Ornamentals Society in good standing with all dues paid. Members get more.



The basic formula is:

 [color][shade or intensity] such as pink light,

For example:

pink dark (coral)
blue medium
red dark (blackish)

If the flower has multiple colors we use
 the format:

 [color][shade or intensity][pattern type][secondary color] such as:

Blue medium margined white

White thumbprint pink

White tinged yellow

Pink medium centered violet

Pink bar white (aka a pink flower with white chimera pinwheel)

Violet fantasy pink (violet with pink speckled)

Pink light margined white fantasy violet = pale pink base with a white edge with violet specklings

The pattern types include:

Margined – thin to wide picotee or edge of contrasting color. A fine contrasting picotee is often called a Geneva edge.

Tinged – a general flush or glow, not in a particular pattern or place, generally, an overall hue or glow

Centered – eye or center of another color or tints mostly confined to the corolla's center

Thumbprint – a distinct spot or central color zone in the middle of the petal as if stamped by a finger. But where does a big print end and a white margin on blue or pink begin?

Bar – what the AV calls “Chimera” or pinwheel stripes, the secondary is the color of this central band or zone. In truth, fantasy type

And all variegated leaf clones are chimeras too. By some odd twist of fate “chimera” in AV circles means just one type of chimera

Fantasy – having a very fine mottling, streaking, or speckling of a contrasting color, these spots most 1-2mm wide if not smaller

Mottled – having a larger mottling, large spots, or bit sectors of a contrasting color, those spots mostly 3-10mm wide, sometimes in sectors or wedges

Why use phrases like "red dark" instead of "dark red"?
Good question. This way when you sort by the corolla color field, all the reds, pinks, blues, etc. are grouped together. Dark red would group with dark pink and dark green - which is a missed opportunity for grouping cultivars. In Google Fusion Table you can also specify "corolla color starts with...." a color term and this lets us list all the blues, reds, pinks, etc. regardless of intensity, patterns, etc.

Google Fusion Search Ideas:
1. Use the "contains" option when searching on corolla color. You could say "contains green margined" and list all the green-edged cultivars regardless of base color. This list would pull white margined green, pink dark margined green, blue light fantasy violet margined green, etc.

2.Want a list of all fantasy clones or chimera (bar, stripped) clones, again use the "contains" option for the terms "fantasy" and "bar". You'll get white fantasy violet along with violet fantasy pink.

Color terms omitted and their equivalents:

"purple" - we use violet such as violet light, violet medium, violet dark. There is technically much difference between purple and violet (the later being a more pinkish or coral-toned shade). In truth, most "purple violets" have strong violet tones, so the two terms are merged as separate is nearly a hopeless exercise.

"fuchsia" - fuchsia is different things to different people. The British have a different standard than Americans. In general, we use "pink dark (magenta)" or "pink dark (coral)", the later less harsh and with fewer blue tints for what is called fuchsia. Some people consider mauve and fuchsia to be the same color and that is another issue with trade terms. The "violet-red" color of this database is also part of what some people think of the term fuchsia.

"cream" - white is used since most white flowers in any plant have cream tones are first or later when fading. A yellowish-cream flower here is "white tinged yellow"

"gold" - we are using yellow light, yellow medium, yellow dark, etc.

"red" - wow, where do we begin? Everyone wants to offer a true red violet but many are not. The codes red light, red medium (rose-red), and red dark (cranberry) are used for true reds. Violet-red reflects a more grapey or intense rosy-red shade of things.

"burgundy" - this should ideally have some relation to the wine of this name. People use burgundy for what are called here red dark, violet-red dark, and violet dark.


Single - most flowers have 5 basic petals, mostly in a flat face, if cupped, not strongly so.

Single Bell – campanulate or bell-shaped corolla to various degrees, generally not flat but petals forward-pointing

Single Starfish – a rare mutation with single petals folded or fluted to be narrow like arms of the starfish. We should be getting more of these in future years

Semi-double - having 6 or more petals and petaloids (minor, reduced petals), the center often clustered with many tiny petaloides.

Double - having 10 or more petals, usually these of nearly equal size, overlaps with "semi-double" and many plants have both types. If the cultivar often attains the true double morphology, we will pick this term for it.

Single Wasp – very irregular, asymmetrical flowers, somewhat insect-like as the name implies, often some petals much larger than others. Some extreme types have a very narrow oblong petal with a distinct narrow base or claw at the petal attachment point, petals not generally wide, often narrow, the upper petals sometimes reduced to tiny segments a fraction of the size of the three lower petals (10-40% of their surface)

COROLLA MARGIN: this field descriptions the margin of the petal

Flat – mostly flat, sometimes faintly convex or concave, very much a flat face or species-type petal formation

Semi-undulate – weak to low waves to the petals

Undulate – medium to strong waves to each petal, not finely crisped or crimped

Crisped – very finely toothed, lacy, crested, or sharply toothed edges. Many of the green-edged clones are crisped. Some have distinctly folded and fluted edges which are noted in the Misc. field. Others are more fimbriated (finely incised, lacy) while others are more serrulate (finely toothed) on close inspection.

LEAF GROUP: We are trying to restore classic terminology here and not using the amateurish, even if traditional terms of AV societies. Professionalism matters.

Green ovate – this is most cultivars, a basic ovate to cordiform (heart-shaped) leaf. For some unknown reason the term “ovate” in some AV circles has come
to refer to a cupped, concave leaf.

Green undulate – a wavy or ruffled leaf, sometimes called a Longifolia leaf in society circles even if not long!!! A variegated undulate leaf is coded by color (ie. white-margined, gold-mottled) and the margin notes in the Misc. field instread.

Green clacamas - leaves mostly narrowly ovate to elliptic, notably with 5-7 parallel or closely spaced reddish or bright pink veins on the leaf reverse, contrasting with the silvery to silvery-green base color. In some clones there is paler striations or veins above too in a so-called watermelon-like pattern; this being  a very imprecise and ill-defined term. Veins can be arcuate or incurved as Dogwood (Cornus) in some cases.

Green elliptic – much narrower or longer-looking blade, similar to some Longifolia references but without the waves or undulation. This taxonomically accurate term “elliptic” is more accurate

White-margined – this is the classic white-edged or Tommy Lou leaf, which in horticultural terms is a “margino-maculata” type of the variegation, a chimeral
margin formed of fused spots. Very few cultivars have a classsic margination in the style of other variegated plants

White-margined thin – a recent code for some clones with faint, weak, often slightly spotted white margins, usually 2-7% of surface

White-margined clacamas - white edge or stripes plus the clacamas type blade. This code added in version 1.2

white-margined undulate - white to cream leaf edges
with a distinctly wavy or undulate blade. This character
state was added with Version 1.2.

Pink-margined – as white-margined but the youngest leaves are some shade of light, medium, or tannish-pink

PInk-margined thin - very thin pinkish leaf edge, often ony the teeth or some narrow portions in rose, creamy--pink,
or tawny-rose.

Pink-margined undulate - blush to rich pink leaf margins
but on a wave or undulate blade edge. This character
state was added with Version 1.2

Tan crown- new growth from tan to olive-buff to golden-green shades, usually with leaves maturing to dark greens, these have subtle suffusions and are maculated or margined in the true sense

Green Concave – green leaf with rim turming up to form a cup. Some (not all) “spoon” leaf cultivars have this upwardly cupped style

White-mottled – leaf is spotted white over most of the surface, not confined in general to marginal spots. These are called in most AV circles a “mosaic”, a horrible word implying a mosaic virus infection.

Gold-mottled - similar to the above but markings in in yellow, gold, tan, or beige tones. "Mosaic" in AV literature.

Pink-mottled – as white-mottled but light pink to medium pink markings, often a silvery-rose shade.

MISC – general comments on the cultivar, including unique traits, clarifications of other fields, etc.

HABIT – or plant size and growth form

Standard – a full-sized modern violet

Semi = semiminature – usually 4-6 inches wide

Mini = miniature – usually 2-4 inches wide

Trailer = trailing or cascading habit. We do not distinguish between standard, semi, and mini trailers here as those classifications are
hard to make at times and most trailers are in general quite small.

ORIGIN – originator name

Format is:

[last name][initials if needed]

Doe J

Metropolis Nursery/Smith

Other, non-named origins are:

Species = a true Saintpaulia species, subspecies, variety, botanical form, or direct clone from them


[country] = sometimes a country is known but not the name of the originator

COLLECTION – this field is intended to record your collection data or plant accessions

One suggested format is:

[nursery source][year][price paid if known][plant type]

For example:

Lyon 2003 $3.50 leaf

Violet Barn 2009 $6.00 plant

Lost or removed plants may be coded with a * at the beginning so they sort out in a separate set

For example:

*Home Depot 2008 $2.99 plant

A second format using collection numbers based on the first format -if the collection # is first, you can sort by it in numerical order

2001-012 Violet Gallery $4.50 plant

2001-013 John Doe trade leaf
CULTIVAR FINDER LINKS: Beginning in version 1.2 we are filling up the Collection field with live, internet source links to major vendors. We are beginning with established, reliable vendors like Lyndon Lyon, Violet Barn, Blue Bird, Karen Dean, Violet Gallery, and several others we can personally recommend. 

2001-014 Mary Smith trade plant

TRADE/SALE/WANT – this field allows you to sort and compile lists – extracting them with a copy-and-paste to another file

For example:

Trade (leaf)

Trade (plant)

Sale (leaf) $1.99

Sale (plant) $5.99

Sale (plant) bid


You can easily produce trade, want, and sales list by sorting on this field. Be certain to select the entire database before sorting.

VERSION – this identifies under which version each cultivar (or amended record thereof) was issued.

Why is this important? “Variable upward compatability” to be clear. Or not. This means if you are using 1.0 and new versions are available you

Simply download the new file and sort by version number. Then copy and paste records in versions 1.1 and 1.2. If you

Are already using 1.1 you instead just add cultivars from version 1.2, and so on. This system of version allows users of many

Different versions, old and new, can get just what they need to add – no more, no less. Having years of plant database

Experience, your author has proven this kind of system works well for everyone.

FAQ/Help Topics

Adding Cultivars on your own:

GOOGLE FUSION TABLE does not permit additions because viewing it is open to the general public on a real time basic. Without scientific and expert review  all sorts of chaos would surely insue.

1. Go to the bottom the sheet and select the blank line under the last entry.
2. Enter your text in the exact columns, using the same codes.
3. When sorting or refreshing the Autofilter be sure to You specify select the entire new range of cells. Otherwise you may only filter or sort the original data.

ALWAYS SAVE A BACKUP COPY OF YOUR DATA BEFORE MODIFYING ANYTHING. In our alpha test, the major problem users had with adding cultivars were these issues to avoid: 1. Use the same field names as the original database. If we specify “blue dark” for corolla color and you enter “blue – dark” or Or “blue very dark”, the selection will favor these are different characters 2. When sorting or resetting the autofilter, always select the rows which contain your new data. You must include them. 3. Your additions will not be selected unless you specify the new expanded data range and select Data – Autofilter again. You must do this Every time a single cultivar is entered.

Add my cultivars for the public? You can submit a new cultivar for inclusion by sending all the field data (corolla color, corolla margin, etc.) to

Additions or new versions from NOS? How do I get them? We will issue expansions and these can be merged (copied) into your existing file, retaining any changed you made. These additions will be coded as versions 1.1, 1.2, 2.3, etc. so you can determine what set of data you need to add to your version. These additions will be offered on the NOS members website first and later to the general public via our link

Autofilter – this is the basis of a spreadsheet database with pull-down menus of the traits and other fields. You do not use a Autofilter with the Google Fusion Tables version. Select all the data (including the data field Headers ie. Cultivar, Corolla Color) and use the Data – Autofilter menu (or whatever your spreadsheet uses as a filter) and select this. Then the The field names will show a small arrow to pulldown, giving the choices that narrow down your list. If you are an experienced spreadsheet user this

Best cultivars? Who decides which are the best 1000 cultivars? This was a decision of the New Onramentals Society staff including Director Laurence Hatch who has grown Saintpaulia for three decades. We also use trade listings to determine what cultivars are popular. High ebay bid attention (not prices), that is, the number of bidders is also considered. Awarded cultivars from local Conventions are also used for our input.

Citations: Please cite this work as follows:

Hatch, Laurence C. 2011. Pauli. African Violet Database.

Copyright: as follows: Copyright 2011. Laurence C. Hatch. All Rights Reserved.

Corrections – these are very welcome. Be specific and email the change requests to .

Duplicate Records: we have intentionally used dupicate records for some cultivars so they can be described two or more ways. This makes character-based searches more accurate Duplicates are often coded as (record 2) or (record 3)

Google Fusion Table Guide:

Basic access:
Simple cultivar search:
Search by traits (two examples)

To got back to a full, unfiltered list click on "clear filter"

Other search ideas:

1. Try Corollla Color "starts with" red     to get all shades of red from medium to dark

2. Try Corolla Color "contains" words like "bar" (chimera) or "fantasy" for those types of floral patterns regardless of base color

3. Try Leaf Group "contains" margined + Habit = Standard for a list of both white and pink-margined cultivars (the traditional variegates)

Links: they are welcome but only through www.cultivar. Direct links to this file are not permitted

Sorting: in spreadsheet formats, select all the data (including field name headers, ie. Cultrivar, Corolla Color, including the entire set of rows and columns with data. Then do Data – Sort or whatever commands you spreadsheet system requires Special uses of sorts include:

Program and Version History

January 2011 - idea suggested by Larry Hatch of the New Ornamentals Society to society board members as a means of providing content to the forthcoming 1300-page encyclopedia of interior and house plants being developed for 2013 release.

March 2011 - test versions offered to NOS members and experts, character state terms standardized. Version field for 1.0, 1.1, 1.2, etc. developed so users could update their already modified files to whatever version they needed with ease.

April  2011 - data fields expanded to include collection management and trade/sale/want list functions so the system will appeal to serious AV collectors and vendors. Version 1.0 offered via Google and other search engine links,, and ebay listings of leaves for sale. ODS, XLS, CSV, and fixed report HTML and PDF cultivar tables offered. DBF version test version discontinued. Google Fusion Table added and recommended as the primary easy-to-use system requiring no downloads and no software.

May 5, 2011 - version 1.1 released with 1310+ different cultivars.

June 10, 2011 - version 1.2 released with 1600 different cultivars, CULTIVAR FINDER links added, new leaf types, and several corrections.

June 21, 2011 - version 1.3 released with 2000 different cultivars, adding live source links to major nurseries.

About the Author

Larry Hatch grew up in Syracuse , New York and was influenced by his parents, Clyde and Hope Hatch to love plants and enjoy gardening. My paternal grandmother Adah Hatch encouraged me very much and her little garden of choice wonderful plants inspired me very much.My aunt 

I attended the State University of New York at Farmingdale on Long Island and earned an AAS in Nursery Management in a strict, rigid program that taught horticulture from the approach of the apprenticeship model. From this wonderful location in 1978 I learned from the area's amazing gardens including New York Botanical, Brooklyn BG, Planting Fields Arboretum, Bayard-Cutting, Bailey Arboreutm, and many others. In 1980 I was blessed to earn a scholarship to Cornell University, working with Dr. Bob Mower with a specialty in plant materials and taxonomy. Learning from the great professors at the Bailey Hortorum (Drs. Ingram, Dress, and Hyypio in particular), 1983 took me to Raleigh, North Carolina to earn a Masters in Ornamental Horticulture, specializing in Horticultural Taxonomy under Drs. Paul Fantz, a noted horticultural taxonomist, the famous JC Raulston, and world-renowned woody plant taxonomy James Hardin, then editor of Systematic Botany. My thesis TAXONOMIC STUDIES OF THE CULTIVATED JUNIPERUS HORIZONTALIS MOENCH covers 58 cultivars of that difficult species and allowed me to study collections far and wide, resulting in a 354 page study of those complex cultivars. In our study of many sports, the cultivars LIMEGLOW 'Noslg' and 'Silver Sheen' were named. It was wonderful to work at the  NC State University Arboretum (now Raulston Arboretum) for four summers, working the Dr. Raulston in labeling and identifying plants from his amazing collection and propagaging amazing new cultivars and Asia seeds he collected from around the world.

In 1982 I became impressed with both the IBM PC and Mac and worked early on to use both for plant databases. In those years, Dr. JC Raulston bought . IIn 1983,Using a Tandy TRS-80 II computer,  I created ConiferBase I, which allowed you to sort and search for conifers by habit, vigor (full to dwarf), foliage color, and foliage type. We had swap in and out big floppy diskettes, each of which held only 64K of very abbreviated, coded data (P=pyramidal, G=gold). The printouts were mailed to a number of friends who are now all legends in the conifer world - Humphrey Welch, Jean Iseli, Tom Dilatush and JC Raulston. Iseli told me about his new mutations and seedling and shared enveloped after envelope of dot matrix, folded pages with his own amazing inventory of plants. Computers got better and soon we formed Taxonomic Computer Research (TCR) in 1983 releasing a word-processed guide to the latest cultivars called the REFERENCE GUIDE TO ORNAMENTAL PLANT CULTIVARS. Getting my own computer with a shocking large 10MB hard-drive for the time - something which was said to be able to hold any professionals life's work with ease. People criticized me for the expensive excess of the 10MB drive because 3.5 inch diskettes were now cheap and could be switched in and out with ease. Today I have digital photographs from my Nikon camera which are 7MB in size. How little we knew back then. Any-hoo, the PLANT DATABASE LIBRARY was developed by TCR and myself and we offered IBM PC databases which would run with PC-FILE dBase, and many other programs to let your select 800 azaleas, 2200 woody plants, 1300 perennials, 300 rhodies, and 1400 conifers with ease. Bulbs modules were sold later but did not have as wide a following. Annual updates were issued to thousands of users in 17 countries.

In the 1990's I became eager to use the internet

African violets came into my focus when as student at Farmingdale the adjacent Arcadia Nursery offered an assortment of cute-as-buttons miniature or at least tiny pots of cultivars in full bloom. Wth what little moneyI had I filled by dorm window with them and more than once gave away a plant to a pretty girl who asked for it. Over some months I attained 20 different cultivars of all sizes and found them wonderful. The Saintpaulia bug subsided for some years though at Cornell I enjoyed the worldclass Gesneriad collections there. I grew to occasional violet over the years but when coming to North Carolina I decided to learn more about indoor gardening with banks of 48 double-tube lights. Dwarf succulents, violets, and all sorts of odd things filled my home.

Nowadays I grow about 200 different violets at any given time, always the most interesting things, and give away or sell the boring stuff as time moves on.

Books by Mr. Hatch include the following offered from

Developers Corner

We kniow that the success of the PAULI Project like most free data sources lies with users and in the final analysis developers who make it better, more flexible, and unleash creativity that will allow the data to stand the tests of time.

The New Ornamentals Society is prepared to assist developers who want to use Pauli data in developing free, shareware, or paid tools or programs.

If you have an idea to use Pauli data in a new way, write us at and we'll make users here aware of your product, your terms, etc.

Developer Support - Open Source
2. - Simple Swing Database takes Pauli CSV fomat (comma-delimited) data and loads a simple speadsheet which can be sorted. The rest is up to you and your coding skill. We were impressed because we simply downloaded the program, clicked File- Open, and it was instant data. Not very many open source downloads are this clear and easy.
3. or Fly Calc is a C++ tool for managing Excel XLS files. It's fast online or offline, works on many computer platofmrs, and has many processing and filtering options already to go. Registration is justt $39 and this includes online collaboration. They also offer FlyBases with Access-style functions .

Collection Management Tutorial

To: Jim
From: Mary
Subject: AV trade list and my new stuff

Hi, here's a few things I have for trade and some new stuff I just bought. Let me know if
want anything from my Pauli list here. I'd like to trade for any Rob's or mini chimeras, also
love double Russians.


Mary could have just cut and paste this list out of Pauli. Instead she did more and sent a Screen-Print using the useful PicPick program (

Internet source links


Copyright 2011. Laurence C. Hatch. All Rights Reserved.