rmap_save_subset: Save subsets

In rangeMapper: A Platform for the Study of Macro-Ecology of Life History Traits

Save subsets

Description

rmap_save_subset creates subsets based on the canvas properties and/or the properties of one or several bio tables.

Usage

rmap_save_subset(con, dst, ...)

## S4 method for signature 'rmapConnection,character'
rmap_save_subset(con, dst, ...)

Arguments

con	a rangeMapper connection made with rmap_connect().
dst	the name of the new subset table.
...	SQL WHERE calls, see Details.

Details

Subsets are defined using table_name = "CONDITION" where CONDITION can be any SQL WHERE call defined for the given table. Here is a summary of the SQL operators relevant in this context:

Operator	Description
= or == or IS or ! = or <> or IS NOT	Equals or Non-equals.
> or < or >= or <=	Greater (Less) than (or equal).
IN or NOT IN	multiple given values e.g. a IN (a,b,c,x,y).
BETWEEN	Between a given range (given values included) e.g. BETWEEN 1 and 10.
LIKE	Pattern search e.g. LIKE "%keyword%". LIKE is case insensitive.
GLOB	Similar to LIKE but uses the Unix wildcards (*,?,[]). e.g. [a-zA-Z0-9] matches any single alphanumeric. GLOB` is case sensitive.

Value

TRUE when the database view is written to the project file, FALSE otherwise.

Examples

require(rangeMapper)
con = rmap_connect()
wrens = read_wrens()
rmap_add_ranges(con, x = wrens, ID = 'sci_name')
rmap_prepare(con, 'hex', cellsize = 500)
rmap_add_bio(con, wrens, 'sci_name')
rmap_save_map(con) 
rmap_save_subset(con,'s1', 
   species_richness = 'species_richness > 10', 
   wrens = 'body_mass > 19 AND clutch_size > 3')

dbDisconnect(con)

rangeMapper documentation built on Oct. 4, 2022, 1:07 a.m.