Search

Search terms
Scientific name
cunonia%
Stats
Number of plants
2
Number of accessions
2
Number of taxa
1
RBG Cranbourne
0
RBG Melbourne
2
Download plant list Download species list
1–2 of 2
1–2 of 2
  BENCHMARKS  
Loading Time: Base Classes  0.0110
Controller Execution Time ( Census / Search )  0.1282
Total Execution Time  0.1393
  GET DATA  
$_GET['q']   cunonia
  MEMORY USAGE  
4,594,200 bytes
  POST DATA  
No POST data exists
  URI STRING  
census/search
  CLASS/METHOD  
census/search
  DATABASE:  postgis   QUERIES: 3  (Hide)
0.0293   SELECT max(timestamp_modified) as timestamp_last_modified FROM rbgcensus.plant 
0.0378   SELECT count(DISTINCT p.plant_id) as num_plantscount(DISTINCT a.accession_id) as num_accessionscount(DISTINCT t.taxon_id) as num_taxacoalesce(COUNT(DISTINCT CASWHEN b.location='Melbourne' THEN p.plant_id END)0) AS melbournecoalesce(COUNT(DISTINCT CASWHEN b.location='Cranbourne' THEN p.plant_id END)0) AS cranbourne
FROM 
"rbgcensus"."taxon" t
LEFT JOIN 
"rbgcensus"."classification" ON "t"."genus_id"="c"."genus_id"
JOIN "rbgcensus"."accession" ON "t"."taxon_id"="a"."taxon_id"
JOIN "rbgcensus"."plant" ON "a"."accession_id"="p"."accession_id"
JOIN "rbgcensus"."bed" ON "p"."bed_id"="b"."bed_id"
LEFT JOIN "rbgcensus"."bed" pb ON "b"."parent_id"="pb"."bed_id"
LEFT JOIN "rbgcensus"."grid" ON "p"."grid_id"="g"."grid_id"
LEFT JOIN "rbgcensus"."deaccession" ON "p"."plant_id"="d"."plant_id"
WHERE d.deaccession_id IS NULL
AND lower(t.taxon_name) LIKE 'cunonia%'
AND "b"."is_restricted" != -1
AND (t.no_public_display!=OR t.no_public_display IS NULL) 
0.0330   SELECT t.guid as taxon_guidt.taxon_namec.familyt.common_nameb.guid as bed_guidb.locationb.bed_typeb.bed_namepb.guid as parent_bed_guidpb.bed_name as parent_bed_nameg.guid as grid_guidg.code as grid_codea.guid as accession_guida.accession_numberp.guid as plant_guidp.plant_numbera.provenance_type_codea.identification_statusp.date_planted
FROM 
"rbgcensus"."taxon" t
LEFT JOIN 
"rbgcensus"."classification" ON "t"."genus_id"="c"."genus_id"
JOIN "rbgcensus"."accession" ON "t"."taxon_id"="a"."taxon_id"
JOIN "rbgcensus"."plant" ON "a"."accession_id"="p"."accession_id"
JOIN "rbgcensus"."bed" ON "p"."bed_id"="b"."bed_id"
LEFT JOIN "rbgcensus"."bed" pb ON "b"."parent_id"="pb"."bed_id"
LEFT JOIN "rbgcensus"."grid" ON "p"."grid_id"="g"."grid_id"
LEFT JOIN "rbgcensus"."deaccession" ON "p"."plant_id"="d"."plant_id"
WHERE d.deaccession_id IS NULL
AND lower(t.taxon_name) LIKE 'cunonia%'
AND "b"."is_restricted" != -1
AND (t.no_public_display!=OR t.no_public_display IS NULL)
ORDER BY "taxon_name""a"."accession_number""p"."plant_number"
LIMIT 100 
  HTTP HEADERS  (Show)
  SESSION DATA  (Show)
  CONFIG VARIABLES  (Show)