Filter capabilities

logical

• and
• or
• not

comparison

• lt
• lte
• gt
• gte
• gt
• neq
• like
• between
• in

spatial

• equals
• disjoint
• touches
• within
• overlaps
• crosses
• intersects
• contains

temporal

• after
• before
• begins
• begunby
• tcontains
• during
• endedby
• ends
• tequals
• meets
• metby
• toverlaps
• overlappedby
• anyinteracts
• intersects

arithmetic

• +
• -
• *
• /

Functions

And

Returns: boolean

Arguments:

• left: boolean
• right: boolean

Area

Returns: number

Arguments:

• geometry: geometry

Collection_Average

Returns: integer

Arguments:

• expression: integer

Collection_Bounds

Returns: string

Arguments:

• geometry: geometry

Collection_Sum

Returns: integer

Arguments:

• expression: integer

Concatenate

Returns: string

Arguments:

• text: string

EqualArea

Returns: string

Arguments:

• value: number
• classes: integer
• areaFunction: number
• percentages: boolean

EqualInterval

Returns: string

Arguments:

• value: number
• classes: integer
• percentages: boolean

IEEEremainder

Returns: number

Arguments:

• dividend: integer
• divisor: integer

Jenks

Returns: string

Arguments:

• value: number
• classes: integer
• percentages: boolean

Or

Returns: boolean

Arguments:

• left: boolean
• right: boolean

Quantile

Returns: string

Arguments:

• value: number
• classes: integer
• percentages: boolean

StandardDeviation

Returns: string

Arguments:

• value: number
• classes: integer
• percentages: boolean

UniqueInterval

Returns: string

Arguments:

• value: number
• classes: integer
• percentages: boolean

abs

Returns: integer

Arguments:

• int: integer

abs_2

Returns: integer

Arguments:

• number: integer

abs_3

Returns: number

Arguments:

• number: number

abs_4

Returns: number

Arguments:

• number: number

acos

Returns: number

Arguments:

• value: number

area2

Returns: number

Arguments:

• geometry: geometry

array

Returns: string

Arguments:

asin

Returns: number

Arguments:

• value: number

atan

Returns: number

Arguments:

• value: number

atan2

Returns: number

Arguments:

• x: number
• y: number

boundary

Returns: geometry

Arguments:

• geometry: geometry

boundaryDimension

Returns: integer

Arguments:

• geometry: geometry

boundedBy

Returns: string

Arguments:

buffer

Returns: geometry

Arguments:

• geometry: geometry
• distance: integer

bufferWithSegments

Returns: geometry

Arguments:

• geometry: geometry
• distance: integer
• numberOfSegments: integer

ceil

Returns: number

Arguments:

• number: integer

centroid

Returns: geometry

Arguments:

• geometry: geometry

contains

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry

convexHull

Returns: geometry

Arguments:

• geometry: geometry

cos

Returns: number

Arguments:

• radians: number

crosses

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry

dateDifference

Returns: integer

Arguments:

• a: dateTime
• b: dateTime

dateFormat

Returns: string

Arguments:

• format: string
• date: dateTime

dateParse

Returns: dateTime

Arguments:

• format: string
• dateString: string

difference

Returns: geometry

Arguments:

• geometry1: geometry
• geometry2: geometry

dimension

Returns: integer

Arguments:

• geometry: geometry

disjoint

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry

disjoint3D

Returns: number

Arguments:

• geometry1: geometry
• geometry2: geometry

distance

Returns: number

Arguments:

• geometry1: geometry
• geometry2: geometry

distance3D

Returns: number

Arguments:

• geometry1: geometry
• geometry2: geometry

double2bool

Returns: boolean

Arguments:

• double: number

endAngle

Returns: number

Arguments:

• linestring: geometry

endPoint

Returns: geometry

Arguments:

• linestring: geometry

env

Returns: string

Arguments:

• variable: string

envelope

Returns: geometry

Arguments:

• geometry: geometry

equalsExact

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry

equalsExactTolerance

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry
• tolarance: number

exp

Returns: number

Arguments:

• number: integer

exteriorRing

Returns: geometry

Arguments:

• geometry: geometry

floor

Returns: number

Arguments:

• double: number

geomFromWKT

Returns: geometry

Arguments:

• geometry: string

geomLength

Returns: number

Arguments:

• geometry: geometry

geometry

Returns: boolean

Arguments:

geometryType

Returns: string

Arguments:

• geometry: geometry

getGeometryN

Returns: geometry

Arguments:

• geometry: geometry
• index: integer

getX

Returns: number

Arguments:

• geometry: geometry

getY

Returns: number

Arguments:

• geometry: geometry

getz

Returns: number

Arguments:

• geometry: geometry

hsl

Returns: string

Arguments:

• hue: number
• saturation: number
• lightness: number

id

Returns: string

Arguments:

int2bbool

Returns: boolean

Arguments:

• int: integer

int2ddouble

Returns: number

Arguments:

• int: integer

interiorPoint

Returns: geometry

Arguments:

• geometry: geometry

interiorRingN

Returns: geometry

Arguments:

• geometry: geometry
• n: integer

intersection

Returns: geometry

Arguments:

• geometry1: geometry
• geometry2: geometry

intersects

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry

intersects3D

Returns: number

Arguments:

• geometry1: geometry
• geometry2: geometry

isClosed

Returns: boolean

Arguments:

• geometry: geometry

isCoverage

Returns: boolean

Arguments:

isEmpty

Returns: boolean

Arguments:

• geometry: geometry

isLike

Returns: boolean

Arguments:

• string: string
• regex: string

isRing

Returns: boolean

Arguments:

• geometry: geometry

isSimple

Returns: boolean

Arguments:

• geometry: geometry

isValid

Returns: boolean

Arguments:

• geometry: geometry

isWithinDistance

Returns: boolean

Arguments:

• geometry1: geometry
• geometry2: geometry
• distance: number

isWithinDistance3D

Returns: number

Arguments:

• geometry1: geometry
• geometry2: geometry
• distance: number

isometric

Returns: geometry

Arguments:

• geometry: geometry
• extrusion: number

jsonPointer

Returns: string

Arguments:

• json: string
• pointer: string

length

Returns: integer

Arguments:

• string: string

lessEqualThan

Returns: boolean

Arguments:

• a: integer
• b: integer

lessThan

Returns: boolean

Arguments:

• a: integer
• b: integer

listMultiply

Returns: string

Arguments:

• factor: integer
• list: string

log

Returns: number

Arguments:

• value: integer

max

Returns: number

Arguments:

• double: integer
• double: integer

max_2

Returns: integer

Arguments:

• long: integer
• long: integer

max_3

Returns: number

Arguments:

• float: integer
• float: integer

max_4

Returns: integer

Arguments:

• int: integer
• int: integer

min

Returns: number

Arguments:

• double: number
• double: number

min_2

Returns: integer

Arguments:

• long: integer
• long: integer

min_3

Returns: number

Arguments:

• float: integer
• float: integer

min_4

Returns: integer

Arguments:

• int: integer
• int: integer

mincircle

Returns: geometry

Arguments:

• geometry: geometry

minimumdiameter

Returns: geometry

Arguments:

• geometry: geometry

minrectangle

Returns: geometry

Arguments:

• geometry: geometry

modulo

Returns: integer

Arguments:

• dividend: integer
• divisor: integer

not

Returns: boolean

Arguments:

• logicValue: boolean

numGeometries

Returns: integer

Arguments:

• geometry: geometry

numInteriorRing

Returns: integer

Arguments:

• geometry: geometry

numPoints

Returns: integer

Arguments:

• geometry: geometry

numberFormat

Returns: string

Arguments:

• format: string
• number: integer
• language: string

numberFormat2

Returns: string

Arguments:

• format: string
• number: integer
• minus: string
• decimal: string
• separator: string

octagonalenvelope

Returns: geometry

Arguments:

• geometry: geometry

offset

Returns: geometry

Arguments:

• geometry: geometry
• offsetX: number
• offsetY: number

overlaps

Returns: geometry

Arguments:

• geometry1: geometry
• geometry2: geometry

parseBoolean

Returns: boolean

Arguments:

• string: string

parseDouble

Returns: number

Arguments:

• string: string

parseInt

Returns: integer

Arguments:

• string: string

parseLong

Returns: integer

Arguments:

• string: string

pgNearest

Returns: boolean

Arguments:

• geometry: string
• num_features: integer

pi

Returns: number

Arguments:

pointN

Returns: geometry

Arguments:

• geometry: geometry
• index: integer

pow

Returns: number

Arguments:

• base: integer
• exponent: integer

property

Returns: string

Arguments:

• propertyName: string

random

Returns: number

Arguments:

relate

Returns: string

Arguments:

• geometry1: geometry
• geometry2: geometry

relatePattern

Returns: boolean

Arguments:

• geometry: geometry
• geometry: geometry
• pattern: string

rint

Returns: number

Arguments:

• double: integer

round

Returns: number

Arguments:

• number: integer

roundDouble

Returns: number

Arguments:

• number: integer

round_2

Returns: integer

Arguments:

• number: integer

setCRS

Returns: geometry

Arguments:

• geometry: geometry
• CRS: string

sin

Returns: number

Arguments:

• radians: integer

sqrt

Returns: number

Arguments:

• number: integer

startAngle

Returns: number

Arguments:

• linestring: geometry

startPoint

Returns: geometry

Arguments:

• linestring: geometry

strAbbreviate

Returns: string

Arguments:

• string: string
• lower: integer
• upper: integer
• appendTo: string

strCapitalize

Returns: string

Arguments:

• string: string

strConcat

Returns: string

Arguments:

• string1: string
• string2: string

strDefaultIfBlank

Returns: string

Arguments:

• string: string
• default: string

strEndsWith

Returns: boolean

Arguments:

• String: string
• postfix: string

strEqualsIgnoreCase

Returns: boolean

Arguments:

• string: string
• lookup: string

strIndexOf

Returns: integer

Arguments:

• String: string
• lookup: string

strLastIndexOf

Returns: integer

Arguments:

• String: string
• lookup: string

strLength

Returns: integer

Arguments:

• string: string

strMatches

Returns: boolean

Arguments:

• string: string
• regex: string

strPosition

Returns: string

Arguments:

• string: string
• lookup: string
• method: string

strReplace

Returns: string

Arguments:

• string: string
• search: string
• replace: string
• all: boolean

strStartsWith

Returns: boolean

Arguments:

• string: string
• prefix: string

strStripAccents

Returns: string

Arguments:

• string: string

strSubstring

Returns: string

Arguments:

• string: string
• beginIndex: integer
• endIndex: integer

strSubstringStart

Returns: string

Arguments:

• string: string
• beginIndex: integer

strToLowerCase

Returns: string

Arguments:

• string: string

strToUpperCase

Returns: string

Arguments:

• string: string

strTrim

Returns: string

Arguments:

• string: string

strTrim2

Returns: string

Arguments:

• string: string
• method: string
• character: string

strURLEncode

Returns: string

Arguments:

• encodeable: string
• formUrlEncode: boolean

symDifference

Returns: geometry

Arguments:

• geometry: geometry
• geometry: geometry

tan

Returns: number

Arguments:

• radians: integer

toDegrees

Returns: number

Arguments:

• radians: integer

toRadians

Returns: number

Arguments:

• degree: integer

toWKT

Returns: string

Arguments:

• geometry: geometry

touches

Returns: boolean

Arguments:

• geometry: geometry
• geometry: geometry

union

Returns: geometry

Arguments:

• geometry: geometry
• geometry: geometry

vertices

Returns: geometry

Arguments:

• geometry: geometry

within

Returns: boolean

Arguments:

• geometry: geometry
• geometry: geometry