Functions

And

• Returns: boolean
• Arguments:

  Name	Title	Type
  left	left	boolean
  right	right	boolean

Area

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

Collection_Average

• Returns: integer
• Arguments:

  Name	Title	Type
  expression	expression	integer

Collection_Bounds

• Returns: string
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

Collection_Sum

• Returns: integer
• Arguments:

  Name	Title	Type
  expression	expression	integer

Concatenate

• Returns: string
• Arguments:

  Name	Title	Type
  text	text	string

EqualArea

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  areaFunction	areaFunction	number
  percentages	percentages	boolean

EqualInterval

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  percentages	percentages	boolean

IEEEremainder

• Returns: number
• Arguments:

  Name	Title	Type
  dividend	dividend	integer
  divisor	divisor	integer

Jenks

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  percentages	percentages	boolean

Or

• Returns: boolean
• Arguments:

  Name	Title	Type
  left	left	boolean
  right	right	boolean

Quantile

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  percentages	percentages	boolean

StandardDeviation

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  percentages	percentages	boolean

UniqueInterval

• Returns: string
• Arguments:

  Name	Title	Type
  value	value	number
  classes	classes	integer
  percentages	percentages	boolean

abs

• Returns: integer
• Arguments:

  Name	Title	Type
  int	int	integer

abs_2

• Returns: integer
• Arguments:

  Name	Title	Type
  number	number	integer

abs_3

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	number

abs_4

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	number

acos

• Returns: number
• Arguments:

  Name	Title	Type
  value	value	number

area2

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

array

• Returns: string
• Arguments:

  Name	Title	Type

asin

• Returns: number
• Arguments:

  Name	Title	Type
  value	value	number

atan

• Returns: number
• Arguments:

  Name	Title	Type
  value	value	number

atan2

• Returns: number
• Arguments:

  Name	Title	Type
  x	x	number
  y	y	number

bands

• Returns: integer
• Arguments:

  Name	Title	Type

boundary

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

boundaryDimension

• Returns: integer
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

boundedBy

• Returns: geometry
• Arguments:

  Name	Title	Type

buffer

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  distance	distance	integer

bufferWithSegments

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  distance	distance	integer
  numberOfSegments	numberOfSegments	integer

ceil

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	integer

centroid

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

contains

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

convexHull

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

cos

• Returns: number
• Arguments:

  Name	Title	Type
  radians	radians	number

crosses

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

dateDifference

• Returns: integer
• Arguments:

  Name	Title	Type
  a	a	string
  b	b	string
  timeUnits	timeUnits	string

dateFormat

• Returns: string
• Arguments:

  Name	Title	Type
  format	format	string
  date	date	string

dateParse

• Returns: string
• Arguments:

  Name	Title	Type
  format	format	string
  dateString	dateString	string

difference

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

dimension

• Returns: integer
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

disjoint

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

disjoint3D

• Returns: number
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

distance

• Returns: number
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

distance3D

• Returns: number
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

div

• Returns: integer
• Arguments:

  Name	Title	Type
  dividend	dividend	integer
  divisor	divisor	integer

double2bool

• Returns: boolean
• Arguments:

  Name	Title	Type
  double	double	number

endAngle

• Returns: number
• Arguments:

  Name	Title	Type
  linestring	linestring	geometry

endPoint

• Returns: geometry
• Arguments:

  Name	Title	Type
  linestring	linestring	geometry

env

• Returns: string
• Arguments:

  Name	Title	Type
  variable	variable	string

envelope

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

equalsExact

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

equalsExactTolerance

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry
  tolarance	tolarance	number

exp

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	integer

exteriorRing

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

floor

• Returns: number
• Arguments:

  Name	Title	Type
  double	double	number

footprints

• Returns: string
• Arguments:

  Name	Title	Type
  coverage	coverage	string

geomFromWKT

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	string

geomLength

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

geometry

• Returns: boolean
• Arguments:

  Name	Title	Type

geometryType

• Returns: string
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

getGeometryN

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  index	index	integer

getX

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

getY

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

getz

• Returns: number
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

hsl

• Returns: string
• Arguments:

  Name	Title	Type
  hue	hue	number
  saturation	saturation	number
  lightness	lightness	number

id

• Returns: string
• Arguments:

  Name	Title	Type

int2bbool

• Returns: boolean
• Arguments:

  Name	Title	Type
  int	int	integer

int2ddouble

• Returns: number
• Arguments:

  Name	Title	Type
  int	int	integer

interiorPoint

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

interiorRingN

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  n	n	integer

intersection

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

intersects

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

intersects3D

• Returns: number
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

isClosed

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

isCoverage

• Returns: boolean
• Arguments:

  Name	Title	Type

isEmpty

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

isLike

• Returns: boolean
• Arguments:

  Name	Title	Type
  string	string	string
  regex	regex	string

isRing

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

isSimple

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

isValid

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

isWithinDistance

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry
  distance	distance	number

isWithinDistance3D

• Returns: number
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry
  distance	distance	number

isometric

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  extrusion	extrusion	number

jsonArrayContains

• Returns: boolean
• Arguments:

  Name	Title	Type
  column	column	string
  pointer	pointer	string
  expected	expected	string

jsonPointer

• Returns: string
• Arguments:

  Name	Title	Type
  json	json	string
  pointer	pointer	string

language

• Returns: string
• Arguments:

  Name	Title	Type

length

• Returns: integer
• Arguments:

  Name	Title	Type
  string	string	string

lessEqualThan

• Returns: boolean
• Arguments:

  Name	Title	Type
  a	a	integer
  b	b	integer

lessThan

• Returns: boolean
• Arguments:

  Name	Title	Type
  a	a	integer
  b	b	integer

listMultiply

• Returns: string
• Arguments:

  Name	Title	Type
  factor	factor	integer
  list	list	string

log

• Returns: number
• Arguments:

  Name	Title	Type
  value	value	integer

max

• Returns: number
• Arguments:

  Name	Title	Type
  double	double	integer
  double	double	integer

max_2

• Returns: integer
• Arguments:

  Name	Title	Type
  long	long	integer
  long	long	integer

max_3

• Returns: number
• Arguments:

  Name	Title	Type
  float	float	integer
  float	float	integer

max_4

• Returns: integer
• Arguments:

  Name	Title	Type
  int	int	integer
  int	int	integer

min

• Returns: number
• Arguments:

  Name	Title	Type
  double	double	number
  double	double	number

min_2

• Returns: integer
• Arguments:

  Name	Title	Type
  long	long	integer
  long	long	integer

min_3

• Returns: number
• Arguments:

  Name	Title	Type
  float	float	integer
  float	float	integer

min_4

• Returns: integer
• Arguments:

  Name	Title	Type
  int	int	integer
  int	int	integer

mincircle

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

minimumdiameter

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

minrectangle

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

modulo

• Returns: integer
• Arguments:

  Name	Title	Type
  dividend	dividend	integer
  divisor	divisor	integer

not

• Returns: boolean
• Arguments:

  Name	Title	Type
  logicValue	logicValue	boolean

now

• Returns: string
• Arguments:

  Name	Title	Type

numGeometries

• Returns: integer
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

numInteriorRing

• Returns: integer
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

numPoints

• Returns: integer
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

numberFormat

• Returns: string
• Arguments:

  Name	Title	Type
  format	format	string
  number	number	integer
  language	language	string

numberFormat2

• Returns: string
• Arguments:

  Name	Title	Type
  format	format	string
  number	number	integer
  minus	minus	string
  decimal	decimal	string
  separator	separator	string

octagonalenvelope

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

offset

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  offsetX	offsetX	number
  offsetY	offsetY	number

overlaps

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

parseBoolean

• Returns: boolean
• Arguments:

  Name	Title	Type
  string	string	string

parseDouble

• Returns: number
• Arguments:

  Name	Title	Type
  string	string	string

parseInt

• Returns: integer
• Arguments:

  Name	Title	Type
  string	string	string

parseLong

• Returns: integer
• Arguments:

  Name	Title	Type
  string	string	string

pgNearest

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  num_features	num_features	integer

pi

• Returns: number
• Arguments:

  Name	Title	Type

pointN

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  index	index	integer

pointOnLine

• Returns: geometry
• Arguments:

  Name	Title	Type
  linestring	linestring	geometry
  percentage	percentage	number

pow

• Returns: number
• Arguments:

  Name	Title	Type
  base	base	integer
  exponent	exponent	integer

property

• Returns: string
• Arguments:

  Name	Title	Type
  propertyName	propertyName	string

random

• Returns: number
• Arguments:

  Name	Title	Type

relate

• Returns: string
• Arguments:

  Name	Title	Type
  geometry1	geometry1	geometry
  geometry2	geometry2	geometry

relatePattern

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  geometry	geometry	geometry
  pattern	pattern	string

rint

• Returns: number
• Arguments:

  Name	Title	Type
  double	double	integer

round

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	integer

roundDouble

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	integer

round_2

• Returns: integer
• Arguments:

  Name	Title	Type
  number	number	integer

setCRS

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  CRS	CRS	string

sin

• Returns: number
• Arguments:

  Name	Title	Type
  radians	radians	integer

sqrt

• Returns: number
• Arguments:

  Name	Title	Type
  number	number	integer

startAngle

• Returns: number
• Arguments:

  Name	Title	Type
  linestring	linestring	geometry

startPoint

• Returns: geometry
• Arguments:

  Name	Title	Type
  linestring	linestring	geometry

strAbbreviate

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  lower	lower	integer
  upper	upper	integer
  appendTo	appendTo	string

strCapitalize

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string

strConcat

• Returns: string
• Arguments:

  Name	Title	Type
  string1	string1	string
  string2	string2	string

strDefaultIfBlank

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  default	default	string

strEndsWith

• Returns: boolean
• Arguments:

  Name	Title	Type
  String	String	string
  postfix	postfix	string

strEqualsIgnoreCase

• Returns: boolean
• Arguments:

  Name	Title	Type
  string	string	string
  lookup	lookup	string

strIndexOf

• Returns: integer
• Arguments:

  Name	Title	Type
  String	String	string
  lookup	lookup	string

strLastIndexOf

• Returns: integer
• Arguments:

  Name	Title	Type
  String	String	string
  lookup	lookup	string

strLength

• Returns: integer
• Arguments:

  Name	Title	Type
  string	string	string

strMatches

• Returns: boolean
• Arguments:

  Name	Title	Type
  string	string	string
  regex	regex	string

strPosition

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  lookup	lookup	string
  method	method	string

strReplace

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  search	search	string
  replace	replace	string
  all	all	boolean

strStartsWith

• Returns: boolean
• Arguments:

  Name	Title	Type
  string	string	string
  prefix	prefix	string

strStripAccents

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string

strSubstring

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  beginIndex	beginIndex	integer
  endIndex	endIndex	integer

strSubstringStart

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  beginIndex	beginIndex	integer

strToLowerCase

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string

strToUpperCase

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string

strTrim

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string

strTrim2

• Returns: string
• Arguments:

  Name	Title	Type
  string	string	string
  method	method	string
  character	character	string

strURLEncode

• Returns: string
• Arguments:

  Name	Title	Type
  encodeable	encodeable	string
  formUrlEncode	formUrlEncode	boolean

symDifference

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  geometry	geometry	geometry

tan

• Returns: number
• Arguments:

  Name	Title	Type
  radians	radians	integer

toDegrees

• Returns: number
• Arguments:

  Name	Title	Type
  radians	radians	integer

toRadians

• Returns: number
• Arguments:

  Name	Title	Type
  degree	degree	integer

toWKT

• Returns: string
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

touches

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  geometry	geometry	geometry

union

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  geometry	geometry	geometry

vertices

• Returns: geometry
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry

within

• Returns: boolean
• Arguments:

  Name	Title	Type
  geometry	geometry	geometry
  geometry	geometry	geometry