Search all planting records

Complete Search of living and dead plants
(everything ever planted)

Plant Records | Search Living Plants | Map of Gardens | Find Sections | Explanation of search terms

Please exercise care in the structure of queries and the use of wildcards to avoid excessively large reports. See instructions below.
Data may be queried by matching text patterns on a number of fields and data reports are available in a number of different formats.
Most fields are case sensitive and the wildcard is the percentage sign (%).

User Name and Password are usually not required unless links to Herbarium specimen data is sought.

Output format

User Name

Password

Display (Check to select; Default = all)	Sort Order (1,2...)	Query by value (% = wildcard, e.g. Rut% lepto%; ! = not, e.g. !ACT; most fields are case sensitive)
Exclude Booderee holdings		Uncheck to include Booderee* in search
Clone Photo		Photos of plants of the same clone based on Propagation Numbers
Taxon Photo		Photos of plants in APII with same taxon name (use !0 for at least 1)
Herb Code		Code showing who issued Prop ID; ANBG, CBG, CANB
Prop ID		Unique accession no. for this Herb Code
Suffix		Propagation method - (s)eed, (c)utting, (p)lant, (g)raft, (d)ivision
Taxon Gp		CA, CF, CL, CM, CP, PG, PD, PM
Family		Five-character abbreviation
Genus
Species
Rank		(s)ubspecies, (v)arietas, (f)orma, (c)ultivar
Infrasp Name
Name Plate		Name to be displayed
Qualifier		aff, cf, ?
Stock Notes		Wildcard is '%'
Num in Grp (text)		Number in planting group (text format)
Num in Grp (numeric)		Number in planting group (use !0 for at least 1 living, >3 etc)
Location (Section)		Section, bench or glasshouse code, n = nursery
Date Propd		Date of propagation
Planting Notes		Wildcard is '%'
Dot
Seed Room		Code showing seed room holdings
Cult/Wild		Propagated from (c)ultivated, (w)ild origin material
Conservation		Code showing conservation status
District		Code showing geographic region; e.g. NSC - NSW South Coast
Parent Herb Code		Herb Code of parent
Parent PropID		Prop ID of parent
Parent Suffix		(s)eed, (c)utting, (p)lant, (g)raft, (d)ivision
Parent Note		E.g. unknown or deleted IDs
Parent Loc		Location of parent
Opar Herb Code		Herb Code of original parent
Opar PropID		Prop ID of original parent
Opar Suffix		(s)eed, (c)utting, (p)lant, (g)raft, (d)ivision
Opar Note		E.g. unknown or deleted IDs
Registered		(r)ecord exists in ANHSIR (Herbarium database)
Accession No.		IBIS Accession No. if known
Features		Comments re form, colour
Requested For
Requested No.
Request Date
Stock Created By		User who created stock record
Stock Created On		Date stock record created
Stock Updated By		User who last changed stock record
Stock Updated On		Date stock record last changed
Planting Created By		User who created planting record
Planting Created On		Date planting record created
Planting Updated By		User who last changed planting record
Planting Updated On		Date planting record last changed
Planting ID		Tick to show every matching Planting record

User Name and Password are usually not required unless links to Herbarium specimens are sought.

Output Format - how you want to generate the results of your query. Leave as HTML for a web view.

Display - What results will be displayed.

Sort Order- Indicates alpha-numeric sorting of results (usually leave blank).
Putting a 1 in this column next to the field you want sorted by will result in sorts by either plant name or prop ID for example.

Execute query - Click to obtain results of search.

Reset Form - clears the entry ready for the next query.

Most fields are case sensitive and the wildcard is the percentage sign (%).

* The default setting is to exclude those plantings at Booderee Botanic Gardens (formerly Jervis Bay Annex of the ANBG) on the NSW south coast.
If these plants are included, they show a 'j' before their section number in the location field

Photos - the camera icon in column one links to photos of plants of the same clonal line as the Propagation Number.
the camera icon in column two links to photos of any plants with the same taxon name, and shows how many photos there are.
To search on criteria where there are no photos, put " null " in value field of 'Taxon Photo'.

Search all planting records

Complete Search of living and dead plants (everything ever planted)

Complete Search of living and dead plants
(everything ever planted)