Up

There are six tables of summaries behind this application. They represent a progressive summarisation of data as depicted below. Begin at the top left (least summarised), and work right and down, to the bottom right (most summarised).


gmap_grid_species[1]
"GRID_REF" (1km sq)
"TAXANB"
"SCIENTIFIC"
"COMMON_NAM"
"RECORDS" (count)
"LATEST" (max)
summarise
species
into
taxon
gmap_grid_taxa[2]
"GRID_REF" (1km sq)
"TAXANB"
"SPECIES" (distinct)

"RECORDS" (sum)
"LATEST" (max)
summarise
taxa
into
square
gmap_grid[2]
"GRID_REF" (1km sq)
"TAXA" (distinct)
"SPECIES" (distinct)

"RECORDS" (sum)
"LATEST" (max)
summarise
squares
above		 summarise
squares
above		 summarise
squares
above
gmap_species[2]

"TAXANB"
"SCIENTIFIC"
"COMMON_NAM"
"RECORDS" (sum)       
"LATEST" (max)
summarise
species
into
taxon
gmap_taxa[2]

"TAXANB"
"SPECIES" (distinct)   

"RECORDS" (sum)
"LATEST" (max)
summarise
taxa
into
grid
gmap[2]

"TAXA" (distinct)
"SPECIES" (distinct)   

"RECORDS" (sum)
"LATEST" (max)


Notes
1. Requires a complex and expensive query to generate, hence a table and not a view.
2. Are all summarised from [1] because of the need to count distinct species.

How the Tables are Used

Up