sql_where: Format a SQL where clause from arguments

In pfrater/arcpullr: Pull Data from an 'ArcGIS REST' API

Format a SQL where clause from arguments

Description

This function will create a where statement that is compatible with get_spatial_layer). This statement can then be passed to the where argument in this function.

Usage

sql_where(..., rel_op = "=")

Arguments

...	Named objects to be queried by
rel_op	Character. The relational operator in the SQL clause (i.e. "=", "IN", "NOT IN", etc.). If a single rel_op is provide with multiple ... parameters then it will be recycled length(...) times.

Value

A character string that can be passed to the where argument of get_spatial_layer

Examples

## Not run: 
wbics <- sql_where(WATERBODY_WBIC = c(805400, 804600), rel_op = "IN")
lakes <- get_spatial_layer(wi_hydro_url, where = wbics)
plot_layer(lakes)

## End(Not run)

pfrater/arcpullr documentation built on March 16, 2024, 6:29 a.m.