either built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: either
type: WebPage

string_output built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: string_output
type: WebPage

sprintf_inverseX built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sprintf_inverse
type: WebPage

string_output_string built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: string_output_string
type: WebPage

split_and_decode built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: split_and_decode
type: WebPage

abs built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: abs
type: WebPage

ascii built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ascii
type: WebPage

atof built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: atof
type: WebPage

atoi built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: atoi
type: WebPage

bit_and built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: bit_and
type: WebPage

bit_or built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: bit_or
type: WebPage

bit_not built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: bit_not
type: WebPage

bit_shift built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: bit_shift
type: WebPage

bit_xor built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: bit_xor
type: WebPage

blob_to_string built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: blob_to_string
type: WebPage

blob_to_string_output built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: blob_to_string_output
type: WebPage

ceiling built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ceiling
type: WebPage

chr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: chr
type: WebPage

concat built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: concat
type: WebPage

concatenate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: concatenate
type: WebPage

contains built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: contains
type: WebPage

curdate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: curdate
type: WebPage

dateadd built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dateadd
type: WebPage

datediff built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: datediff
type: WebPage

datestring built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: datestring
type: WebPage

datestring_gmt built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: datestring_gmt
type: WebPage

dayname built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dayname
type: WebPage

dayofmonth built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dayofmonth
type: WebPage

dayofweek built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dayofweek
type: WebPage

dayofyear built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dayofyear
type: WebPage

dt_set_tz built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dt_set_tz
type: WebPage

equ, gt, gte, lt, lte, neq built-in functions description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: lte
about: lt
about: neq
about: equ
about: gt
about: gte
type: WebPage

exp built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: exp
type: WebPage

floor built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: floor
type: WebPage

get_timestamp built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: get_timestamp
type: WebPage

getdate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: getdate
type: WebPage

st_point built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_point
type: WebPage

st_x built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_x
type: WebPage

st_y built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_y
type: WebPage

st_distance built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_distance
type: WebPage

st_astext built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_astext
type: WebPage

st_geomfromtext built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_geomfromtext
type: WebPage

st_intersects built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_intersects
type: WebPage

st_contains built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_contains
type: WebPage

st_within built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_within
type: WebPage

isgeometry built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isgeometry
type: WebPage

geo_insert built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: geo_insert
type: WebPage

geo_delete built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: geo_delete
type: WebPage

hour built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: hour
type: WebPage

initcap built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: initcap
type: WebPage

isarray built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isarray
type: WebPage

isblob built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isblob
type: WebPage

isbinary built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isbinary
type: WebPage

isdouble built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isdouble
type: WebPage

isentity built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isentity
type: WebPage

isfloat built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isfloat
type: WebPage

isinteger built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isinteger
type: WebPage

isnull built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isnull
type: WebPage

isnumeric built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isnumeric
type: WebPage

isfinitenumeric built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isfinitenumeric
type: WebPage

isstring built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: isstring
type: WebPage

iszero built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: iszero
type: WebPage

__min built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: __min
type: WebPage

__max built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: __max
type: WebPage

__max_notnull built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: __max_notnull
type: WebPage

__min_notnull built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: __min_notnull
type: WebPage

jvm_ref_import built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: jvm_ref_import
type: WebPage

lcase built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: lcase
type: WebPage

left built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: left
type: WebPage

length built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: length
type: WebPage

locate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: locate
type: WebPage

log built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: log
type: WebPage

log10 built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: log10
type: WebPage

lower built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: lower
type: WebPage

ltrim built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ltrim
type: WebPage

make_string built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: make_string
type: WebPage

minute built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: minute
type: WebPage

mod built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: mod
type: WebPage

month built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: month
type: WebPage

monthname built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: monthname
type: WebPage

msec_time built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: msec_time
type: WebPage

now built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: now
type: WebPage

position built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: position
type: WebPage

power built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: power
type: WebPage

quarter built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: quarter
type: WebPage

randomize built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: randomize
type: WebPage

regexp_match built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_match
type: WebPage

regexp_parse built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_parse
type: WebPage

regexp_substr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_substr
type: WebPage

regexp_replace built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_replace
type: WebPage

regexp_instr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_instr
type: WebPage

regexp_like built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: regexp_like
type: WebPage

repeat built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: repeat
type: WebPage

replace built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: replace
type: WebPage

right built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: right
type: WebPage

rnd built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: rnd
type: WebPage

rtrim built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: rtrim
type: WebPage

search_excerpt built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: search_excerpt
type: WebPage

second built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: second
type: WebPage

serialize built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: serialize
type: WebPage

sign built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sign
type: WebPage

space built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: space
type: WebPage

sprintf built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sprintf
type: WebPage

sprintf_iri built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sprintf_iri
type: WebPage

sprintf_iri_or_null built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sprintf_iri_or_null
type: WebPage

sprintf_or_null built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sprintf_or_null
type: WebPage

sqrt built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sqrt
type: WebPage

strcasestr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: strcasestr
type: WebPage

strchr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: strchr
type: WebPage

stringdate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: stringdate
type: WebPage

stringtime built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: stringtime
type: WebPage

string_output_flush built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: string_output_flush
type: WebPage

string_output_gz_compress built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: string_output_gz_compress
type: WebPage

string_to_file built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: string_to_file
type: WebPage

strrchr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: strrchr
type: WebPage

strstr built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: strstr
type: WebPage

subseq built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: subseq
type: WebPage

substring built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: substring
type: WebPage

strcontains built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: strcontains
type: WebPage

starts_with built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: starts_with
type: WebPage

ends_with built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ends_with
type: WebPage

tmp_file_name built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: tmp_file_name
type: WebPage

timezone built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: timezone
type: WebPage

acos, asin, atan, atan2, cos, cot, degrees, pi, radians, sin, tan built-in functions description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: cot
about: degrees
about: atan2
about: cos
about: acos
about: asin
about: atan
about: sin
about: pi
about: radians
about: tan
type: WebPage

trim built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: trim
type: WebPage

ucase built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ucase
type: WebPage

upper built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: upper
type: WebPage

vector built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: vector
type: WebPage

vector_concat built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: vector_concat
type: WebPage

week built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: week
type: WebPage

OpenLink SPARQL BIF Extensions Ontology Description Document
primary topic: OpenLink SPARQL BIF Extensions Ontology
topic: this
topic: second
topic: serialize
topic: sign
topic: sin
topic: space
topic: split_and_decode
topic: sprintf
topic: sprintf_inverse
topic: regexp_replace
topic: regexp_substr
topic: repeat
topic: replace
topic: right
topic: rnd
topic: rtrim
topic: search_excerpt
topic: quarter
topic: radians
topic: randomize
topic: rdf_now_impl
topic: regexp_instr
topic: regexp_like
topic: regexp_match
topic: regexp_parse
topic: monthname
topic: msec_time
topic: neq
topic: now
topic: pi
topic: position
topic: postgis_proj_version
topic: power
topic: lower
topic: lt
topic: lte
topic: ltrim
topic: make_string
topic: minute
topic: mod
topic: month
topic: iszero
topic: jvm_ref_import
topic: lcase
topic: left
topic: length
topic: locate
topic: log
topic: log10
topic: isentity
topic: isfinitenumeric
topic: isfloat
topic: isgeometry
topic: isinteger
topic: isnull
topic: isnumeric
topic: isstring
topic: http_st_dxf_entity
topic: http_st_ewkt
topic: initcap
topic: is_timezoneless
topic: isarray
topic: isbinary
topic: isblob
topic: isdouble
topic: geo_delete
topic: geo_insert
topic: get_timestamp
topic: getdate
topic: gt
topic: gte
topic: haversine_deg_km
topic: hour
topic: dt_set_tz
topic: earth_radius
topic: either
topic: ends_with
topic: equ
topic: exp

adjust_timezone built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: adjust_timezone
type: WebPage

curdatetime built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: curdatetime
type: WebPage

curdatetimeoffset built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: curdatetimeoffset
type: WebPage

current_timestamp built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: current_timestamp
type: WebPage

curutcdatetime built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: curutcdatetime
type: WebPage

forget_timezone built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: forget_timezone
type: WebPage

is_timezoneless built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: is_timezoneless
type: WebPage

rdf_now_impl built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: rdf_now_impl
type: WebPage

sysutcdatetime built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: sysutcdatetime
type: WebPage

OpenLink SPARQL BIF Extensions Ontology Description Document (Turtle)
primary topic: OpenLink SPARQL BIF Extensions Ontology
license: http://creativecommons.org/licenses/by-sa/3.0/
subject: OpenLink SPARQL BIF Extensions Ontology
comment: This is a turtle document that uses Linked Data oriented content to describe an OpenLink SPARQL BIF Extensions ontology
canonical: OpenLink SPARQL BIF Extensions Ontology Description Document
about: OpenLink SPARQL BIF Extensions Ontology
creator: this
type: TechArticle
type: Document
describes: OpenLink SPARQL BIF Extensions Ontology

ST_Affine built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_Affine
type: WebPage

ST_M built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_M
type: WebPage

ST_MMax built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_MMax
type: WebPage

ST_MMin built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_MMin
type: WebPage

ST_XMax built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_XMax
type: WebPage

ST_YMax built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_YMax
type: WebPage

ST_YMin built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_YMin
type: WebPage

ST_ZMax built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_ZMax
type: WebPage

ST_ZMin built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_ZMin
type: WebPage

ST_Zmflag built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_Zmflag
type: WebPage

earth_radius built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: earth_radius
type: WebPage

haversine_deg_km built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: haversine_deg_km
type: WebPage

dist_from_point_to_line_segment built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: dist_from_point_to_line_segment
type: WebPage

st_linestring built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_linestring
type: WebPage

ST_Z built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_Z
type: WebPage

ST_XMin built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_XMin
type: WebPage

st_may_intersect built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_may_intersect
type: WebPage

ST_SRID built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_SRID
type: WebPage

ST_SetSRID built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_SetSRID
type: WebPage

st_ewkt_read built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_ewkt_read
type: WebPage

http_st_ewkt built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: http_st_ewkt
type: WebPage

http_st_dxf_entity built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: http_st_dxf_entity
type: WebPage

st_get_bounding_box built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_get_bounding_box
type: WebPage

GeometryType built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: GeometryType
type: WebPage

ST_NumGeometries built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_NumGeometries
type: WebPage

ST_GeometryN built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_GeometryN
type: WebPage

ST_ExteriorRing built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_ExteriorRing
type: WebPage

ST_NumInteriorRings built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_NumInteriorRings
type: WebPage

ST_InteriorRingN built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_InteriorRingN
type: WebPage

st_get_bounding_box_n built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_get_bounding_box_n
type: WebPage

ST_Translate built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_Translate
type: WebPage

ST_TransScale built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_TransScale
type: WebPage

st_transform_by_custom_projection built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: st_transform_by_custom_projection
type: WebPage

ST_Transform built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: ST_Transform
type: WebPage

postgis_proj_version built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: postgis_proj_version
type: WebPage

OpenLink SPARQL BIF Extensions Ontology
created: 2015-06-09T11:00:00-05:00
describedby: cert
comment: Ontology that defines entity and relation types used to describe SPARQL BIF extensions. Examples contains, str etc.
version info: 1.0.0
imports: terms
imports: 22-rdf-syntax-ns#
imports: sparql-extension-description#
defines: upper
defines: vector
defines: vector_concat
defines: week
defines: timezone
defines: tmp_file_name
defines: trim
defines: ucase
defines: subseq
defines: substring
defines: sysutcdatetime
defines: tan
defines: st_linestring
defines: st_may_intersect
defines: st_point
defines: st_transform_by_custom_projection
defines: st_geomfromtext
defines: st_get_bounding_box
defines: st_get_bounding_box_n
defines: st_intersects
defines: st_astext
defines: st_contains
defines: st_distance
defines: st_ewkt_read
defines: sprintf_iri
defines: sprintf_iri_or_null
defines: sprintf_or_null
defines: sqrt
defines: stringdate
defines: stringtime
defines: strrchr
defines: strstr
defines: string_output_flush
defines: string_output_gz_compress
defines: string_output_string
defines: string_to_file
defines: strcasestr
defines: strchr
defines: strcontains
defines: string_output
defines: st_within
defines: st_x
defines: st_y
defines: starts_with
defines: regexp_instr
defines: regexp_like
defines: regexp_match
defines: regexp_parse
defines: quarter
defines: radians
defines: randomize
defines: rdf_now_impl
defines: pi
defines: position
defines: postgis_proj_version
defines: power
defines: monthname
defines: msec_time
defines: neq
defines: now
defines: space
defines: split_and_decode
defines: sprintf
defines: sprintf_inverse
defines: second
defines: serialize
defines: sign
defines: sin
defines: right
defines: rnd
defines: rtrim
defines: search_excerpt

OpenLink SPARQL BIF Extensions Ontology Description Document (Turtle)
primary topic: OpenLink SPARQL BIF Extensions Ontology
subject: OpenLink SPARQL BIF Extensions Ontology
comment: This is a turtle document that uses Linked Data oriented content to describe an OpenLink Identity & Certification Ontology
canonical: OpenLink SPARQL BIF Extensions Ontology Description Document
license: http://creativecommons.org/licenses/by-sa/3.0/
about: OpenLink SPARQL BIF Extensions Ontology
creator: this
type: Resource
type: TechArticle
type: Document
describes: OpenLink SPARQL BIF Extensions Ontology

__max_notnull
description: The function returns the maximum value among all values in all its arguments by ignoring NULLs entirely.
license: deed.en US
comment: Usage: bif:__max_notnull.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

GeometryType
description: GeometryType function returns EWKT type name of a given shape.
license: deed.en US
comment: SELECT ?s, bif:GeometryType(?o) FROM <http://example.com> WHERE { ?s ?p ?o } ORDER BY ASC(str(?s))
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_Affine
description: performs standard 2d affine transformation with matrix
license: deed.en US
comment: select st_affine (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3), (1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'), 30, 3, 1, 0.3, 0.001, 0.002)
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_ExteriorRing
description: Returns an external (the very first) ring of a polygon.
license: deed.en US
comment: Usage: bif:ST_ExteriorRing.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_GeometryN
description: Given a 1-based index of a member of a MULTI or COLLECTION shape, returns the member
license: deed.en US
comment: Usage: bif:ST_GeometryN.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_InteriorRingN
description: Given a 1-based index of an interior ring of a polygon, returns the ring. Wrong index is not reported as an error and NULL is returned.
license: deed.en US
comment: Usage: bif:ST_InteriorRingN.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_M
description: Returns the M coordinate. M is for mileage or the like. M equal to 245.3 could be 245.3 km of road or 0.3 distance from buoy 245 to buoy 246 or similar.
license: deed.en US
comment: Usage: bif:ST_M.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_MMax
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: SELECT ?s, bif:st_mmax(?o) as ?mmax FROM <http://example.com> WHERE { ?s ?p ?o }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_MMin
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: Usage: bif:ST_MMin. SPARQL SELECT ?s, bif:st_mmin(?o) as ?mmin FROM <http://example.com> WHERE { ?s ?p ?o };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_NumGeometries
description: Returns number of members of a MULTI or COLLECTION shape, 1 for other sorts of shapes.
license: deed.en US
comment: SELECT ?s, bif:GeometryType(?o), bif:ST_NumGeometries(?o) FROM <http://example.com> WHERE { ?s ?p ?o } ORDER BY ASC(str(?s))
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_NumInteriorRings
description: Returns number of interior rings of the given polygon, NULL if shape is not a polygon.
license: deed.en US
comment: SELECT ?s bif:ST_NumInteriorRings (?o) FROM <http://example.com/> WHERE { ?s ?p ?o } ORDER BY ASC(str(?s))
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_SRID
description: Returns the SRID of a geometry.
license: deed.en US
comment: SELECT (bif:ST_SRID (?geo)) WHERE { ?m geo:geometry ?geo . } LIMIT 10;
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_SetSRID
description: The geometry given as argument is modified to have the specified SRID and the modified geometry is returned.
license: deed.en US
comment: Usage: bif:ST_SetSRID.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_TransScale
description: Returns a copy of a shape with all coordinates shifted by the provided dX, dY and then multiplied by Xfactor and Yfactor. Different values for Xfactor and Yfactor will result in distorted arcs.
license: deed.en US
comment: SELECT ?s, bif:ST_TransScale(?o, 0.1, 0.2, 0.1, 0.1) FROM <http://example.com> WHERE { ?s ?p ?o } ORDER BY ASC(str(?s))
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_Transform
description: Transforms the given shape from its current spatial reference system to one specified by dest_srid.
license: deed.en US
comment: Usage: bif:ST_Transform.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_Translate
description: Returns a copy of a shape with all coordinates shifted by the provided dX, dY and dZ.
license: deed.en US
comment: Usage: bif:ST_Translate.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_XMax
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: SELECT ?s, bif:st_xmax(?o) as ?xmax FROM <http://example.com> WHERE { ?s ?p ?o }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Item
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ST_XMin
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: SELECT ?s, bif:ST_XMin(?o) as ?xmin FROM <http://example.com> WHERE { ?s ?p ?o }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_YMax
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle
license: deed.en US
comment: Usage: bif:ST_YMax.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_YMin
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: Usage: bif:ST_YMin.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_Z
description: Retrieves the x coordinate of a geometry.
license: deed.en US
comment: Usage: bif:ST_Z.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_ZMax
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in assumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: Usage: bif:ST_ZMax.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_ZMin
description: Returns boundaries of a bounding box around a shape. Bounding boxes around arcs are calculated in ssumption that no one arc is longer than a half of full circle.
license: deed.en US
comment: Usage: bif:ST_ZMin.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ST_Zmflag
description: Returns bits indicating presence of Z and/or M coordinates. 0 means that the shape has only X and Y, 1 means that M is also in use (but not Z), 2 means Z but ont M, 3 is for both M and Z.
license: deed.en US
comment: Usage: bif:ST_Zmflag.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

__max
description: The function returns the maximum value among all values in all its arguments.
license: deed.en US
comment: Usage: bif:__max.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

__min
description: The function returns the minimum value among all values in all its arguments.
license: deed.en US
comment: Usage: bif:__min.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

__min_notnull
description: The function returns the minimum value among all values in all its arguments by ignoring NULLs entirely.
license: deed.en US
comment: Usage: bif:__min_notnull.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

abs
description: Returns the absolute value of its argument.
license: deed.en US
comment: Usage: bif:abs.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

acos
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:acos
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

adjust_timezone
description: The function returns its first argument with unchanged GMT value but new timezone offset, as it is specified by the second argument. If the first argument is timezoneless and third argument is missing or zero then error 22023 is signaled. If the first argument is timezoneless and third argument is nonzero then no error is signaled and the argument is handled like it is a GMT value.
license: deed.en US
comment: Usage: bif:adjust_timezone.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ascii
description: ascii returns the ASCII value of the first character of a string. If an empty string is given, then zero is returned.
license: deed.en US
comment: Usage: bif:ascii.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

asin
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:asin
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

atan
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:atan
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

atan2
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:atan2
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

atof
description: Returns its argument as a single precision floating point. If the string cannot be parsed and converted to a valid float, a value 0.0 is returned.
license: deed.en US
comment: Usage: bif:atof.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

atoi
description: Returns its argument as an integer. If the string cannot be parsed and converted to a valid integer, a value 0 is returned.
license: deed.en US
comment: SELECT * FROM <http://example.com> WHERE { ?s ?p ?o . filter (bif:atoi (?o) > 130) };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

bit_and
description: Returns bitwise AND of two given integers. On 64-bit platforms, both arguments are intentionally truncated to 32 bits to maintain compatibility.
license: deed.en US
comment: Usage: bif:bit_and.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

bit_not
description: Returns bitwise NOT of a given integer. On 64-bit platforms the argument is intentionally truncated to 32 bits to maintain compatibility.
license: deed.en US
comment: Usage: bif:bit_not.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

bit_or
description: Returns bitwise OR of two given integers. On 64-bit platforms, both arguments are intentionally truncated to 32 bits to maintain compatibility.
license: deed.en US
comment: Usage: bif:bit_or.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

bit_shift
description: Returns bitwise shift of two given integers. Depending on the arguments, the shift may be left or right. For right-shift, leftmost bits of the result are filled by the value of the 31-st bit. On 64-bit platforms, both arguments are intentionally truncated to 32 bits and the shift is restricted to 32 bits to maintain compatibility.
license: deed.en US
comment: Usage: bif:bit_shift.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

bit_xor
description: Returns bitwise XOR (exclusive "or") of two given integers. On 64-bit platforms, both arguments are intentionally truncated to 32 bits, to provide compartibility.
license: deed.en US
comment: Usage: bif:bit_xor.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

blob_to_string
description: Although primarily used for converting blobs (long varbinary, long varchar) to string, blob_to_string may also be used to convert from wide string, persistent XML (XPER) and string_output streams. If the data being converted is longer than maximum length of a string, blob_to_string will signal an error.
license: deed.en US
comment: Usage: bif:blob_to_string.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

blob_to_string_output
description: Although primarily used for converting blobs (long varbinary, long varchar) to string output object, blob_to_string_output may also be used to convert from wide string, persistent XML (XPER) and string_output streams.
license: deed.en US
comment: Usage: bif:blob_to_string_output.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ceiling
description: Calculates the smallest integer greater than or equal to x.
license: deed.en US
comment: Usage: bif:ceiling.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

chr
description: chr returns a new one character long string containing the character with character code given as parameter.
license: deed.en US
comment: Usage: bif:chr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

concat
description: Function concat returns a new string, concatenated from a variable number of strings given as arguments. NULL arguments are handled as empty strings. concat (str) returns a copy of str. concat () returns an empty string.
license: deed.en US
comment: sparql select bif:concat(str(?s),(str(?o)) from <http://example.com> where {?s ?p ?o} limit 10
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

concatenate
description: Concatenate is an alias of concat.
license: deed.en US
comment: select bif:concatenate(str(?s),(str(?o)) from <http://example.com> where {?s ?p ?o} limit 10
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

contains
description: A custom property (magic predicate) that applies string matching patterns to its object. This property exposes a built-in SQL function as a SPARQL extension. This is a SQL predicate that specifies a condition on a column on which a free text index exists. The expression is a string matching the grammar of a text search expression. This is computed for each evaluation of the contains predicate and does not have to be a constant. For example a parameter or variable of a containing score (e.g. procedure) is accepted. The score_limit is optional. If specified, it should be a numeric expression determining the minimum score required to produce a hit. A virtual column named 'SCORE' is available in queries involving a contains predicate. This can for example be returned in a result set or used for sorting. Note that the name is in upper case and is case sensitive in all case modes.
license: deed.en US
comment: SELECT * FROM <http://example.com> WHERE { ?s ?p ?o . ?o bif:contains "world" };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

cos
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:cos
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

cot
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:cot
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

curdate
description: Returns the current date or time as a date, time or datetime, respectively
license: deed.en US
comment: Usage: bif:curdate.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

curdatetime
description: Returns the current date or time as a date, time or datetime, respectively
license: deed.en US
comment: Usage: bif:curdatetime.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

curdatetimeoffset
description: The function returns current datetime, like now(), but fractional part of seconds can be adjusted by providing the number of "microseconds" as the argument. It is like curdatetime() but the returned datetime is in GMT timezone.
license: deed.en US
comment: Usage: bif:curdatetimeoffset.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

current_timestamp
description: The function name refer to one function ( alias of now() ) that returns the timestamp of current transaction. It is the datetime of the beginning of current transaction with the fractional part of seconds replaced with serial number of a transaction within the second. If TimezonelessDatetimes=0 then the time has local timezone offset (as it was set at the time of last server start); otherwise it is timezoneless.
license: deed.en US
comment: Usage: bif:current_timestamp.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

curutcdatetime
description: The function returns current datetime, like now(), but fractional part of seconds can be adjusted by providing the number of "microseconds" as the argument. The function is similar to curdatetime() but the returned datetime is in GMT timezone.
license: deed.en US
comment: Usage: bif:curutcdatetime.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dateadd
description: dateadd adds a positive or negative quantity of units to a date (in the internal date time format), and returns a new date so formed. The unit is specified as a string and can be one of the following: 'second', 'minute', 'hour', 'day', 'month', or 'year'. Use datestring to convert the result to a human-readable string.
license: deed.en US
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

datediff
description: datediff subtracts date1 from date2 and returns the difference as an integer in the specified units.
license: deed.en US
comment: SELECT ?wiki, ?dbp, bif:datediff('second', xsd:DateTime(?extracted) , now()) AS ?secondsAgo FROM <example.com> WHERE { ?wiki foaf:primaryTopic ?dbp . ?dbp dcterms:modified ?extracted . FILTER ( ?extracted > bif:dateadd('minute', -10, now())) } ORDER BY DESC (?extracted) LIMIT 30
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

datestring
description: datestring and datestring_gmt convert timestamps or datetimes from internal to external date-time representation. The external representation is a human-readable ASCII string of up to 30 characters. The external format is: YYYY-MM-DD hh:mm:ss uuuuuu where uuuuuu represents microseconds.
license: deed.en US
comment: Usage: bif:datestring.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

datestring_gmt
description: Converts the local datetime to GMT and returns its external representation as a string.
license: deed.en US
comment: Usage: bif:datestring_gmt.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dayname
description: Decomposes a datetime to name of day. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:dayname.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dayofmonth
description: Decomposes a datetime to day of month. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:dayofmonth.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dayofweek
description: Decomposes a datetime to day of week. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:dayofweek.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dayofyear
description: Decomposes a datetime to day of year. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:dayofyear.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

degrees
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:degrees
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dist_from_point_to_line_segment
description: Returns the distance between a point and a segment on a plane.
license: deed.en US
comment: Usage: bif:dist_from_point_to_line_segment.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

dt_set_tz
description: Modifies the timezone component of a datetime. The value remains equal for purposes of comparison but will look different when converted to a string. The timezone component is an offset from UTC in minutes. It can be retrieved with the timezone function.
license: deed.en US
comment: Usage: bif:dt_set_tz.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

earth_radius
description: Returns geom.mean of radius of Earth in kilometers, 6367.43568
license: deed.en US
comment: Usage: bif:earth_radius.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

either
description: Returns a copy of arg1 if cond is something else than integer 0 (zero). Otherwise, a copy of arg2 is returned.
license: deed.en US
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

ends_with
description: ends_with checks whether string X ends with Y, ignoring occurencies of Y in other places. Returns 1 or 0.
license: deed.en US
comment: Usage: bif:ends_with.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

equ
description: This function returns 1 if its first argument is equivalent to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator = and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:equ .
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

exp
description: The function raises e to the power of x, it works with double precision floating point numbers, converts its argument to an IEEE 64-bit float and returns a result of that type.
license: deed.en US
comment: Usage: bif:exp.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

floor
description: floor calculates the largest integer smaller than or equal to x.
license: deed.en US
comment: Usage: bif:floor.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

forget_timezone
description: The function returns its first argument as a timezoned value. If the first argument is timezoneless then it is returned unchanged. If the first argument is timezoned and second argument is missing or zero then the result is timezoneless value that "looks like" local time notation. If the first argument is timezoned and second argument is nonzero then the value is first made GMT and then it becomes timezoneless.
license: deed.en US
comment: Usage: bif:forget_timezone.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

geo_delete
description: Deletes a geometry from an R tree index. The tb must be a fully qualified name of an R tree table. This function is typically used from triggers on a geometry column. The function is transactional and makes a transaction log record of the action.
license: deed.en US
comment: Usage: bif:geo_delete.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

geo_insert
description: Inserts a geometry from an R tree index. The tb must be a fully qualified name of an R tree table. This function is typically used from triggers on a geometry column. The function is transactional and makes a transaction log record of the action.
license: deed.en US
comment: Usage: bif:geo_insert.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

get_timestamp
description: get_timestamp is merely an alias for now and is provided for backward compatibility.
license: deed.en US
comment: Usage: bif:get_timestamp.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

getdate
description: Returns the timestamp associated with current transaction. This is an alias of now().
license: deed.en US
comment: Usage: bif:getdate.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

gt
description: This function returns 1 if its first argument greater than to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator > and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:gt.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

gte
description: This function returns 1 if its first argument is greater than or equivalent to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator >= and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:gte.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

haversine_deg_km
description: The function calculates the approximate distance between two points, using haversine formula with an adjustment for case when points are ends of some diameter. Note that the order of arguments is latitude-longitude, not longitude-latitude.
license: deed.en US
comment: Usage: bif:haversine_deg_km.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

hour
description: Decomposes a datetime to hour. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:hour.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: Item

http_st_dxf_entity
description: This function writes a DXF (Data Exchange Format) representation of shape into the given output session.
license: deed.en US
comment: Usage: bif:http_st_dxf_entity.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

http_st_ewkt
description: Writes a EWKT representation of a shape to the given session, a fast replacement for http (st_astext (shape), ses).
license: deed.en US
comment: Usage: bif:http_st_ewkt.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

initcap
description: initcap returns a copy of string str with the first character, if it is a lowercase letter, converted to the corresponding uppercase letter. Otherwise, an identical copy of the string is returned.
license: deed.en US
comment: Usage: bif:initcap.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

is_timezoneless
description: The function returns 1 for timezoneless arguments, zero for timezoned.
license: deed.en US
comment: Usage: bif:is_timezoneless.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isarray
description: isarray is true if the argument is a valid argument to aref. This is the case for any string or vector.
license: deed.en US
comment: Usage: bif:isarray.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isbinary
description: Returns one if its argument is of type VARBINARY, zero otherwise.
license: deed.en US
comment: Usage: bif:isbinary.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isblob
description: Returns one if its argument as a handle to an object of the type LONG VARCHAR, zero otherwise.
description: isblob returns one if its argument as a handle to an object of the type LONG VARCHAR, zero otherwise.
license: deed.en US
comment: Usage: bif:isblob.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isdouble
description: Returns one if its argument is of type double precision float, zero otherwise.
description: isdouble returns one if its argument is of type double precision float, zero otherwise.
license: deed.en US
comment: Usage: bif:isdouble.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isentity
description: Returns true if its argument is an XML entity
license: deed.en US
comment: Usage: bif:isentity.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isfinitenumeric
description: Returns 1 if its argument is of numeric type and its value is plain valid numeric value, not a peculiarity like infinity or not-a-number.
description: isfinitenumeric returns 1 if its argument is of numeric type and its value is plain valid numeric value, not a peculiarity like infinity or not-a-number.
license: deed.en US
comment: Usage: bif:isfinitenumeric.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isfloat
description: Returns one if its argument is of type single float, zero otherwise.
description: isfloat returns one if its argument is of type single float, zero otherwise.
license: deed.en US
comment: Usage: bif:isfloat.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isgeometry
description: Returns 1 if the argument is a geometry.
license: deed.en US
comment: Usage: bif:isgeometry.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isinteger
description: Returns one if its argument is of type integer, zero otherwise.
description: isinteger returns one if its argument is of type integer, zero otherwise.
license: deed.en US
comment: Usage: bif:isinteger.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isnull
description: Returns one if its argument is NULL, zero otherwise.
license: deed.en US
comment: SELECT distinct (bif:subseq (?s, bif:strchr (?s, '#'))) WHERE { graph ?g { ?s ?p `2+2` . FILTER (! bif:isnull (bif:strchr (?s, '#') ) ) } };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isnumeric
description: isnumeric returns one if its argument is of type integer, single float or double precision floating point number, zero otherwise.
description: Returns one if its argument is of type integer, single float or double precision floating point number, zero otherwise.
license: deed.en US
comment: SELECT round(?o) WHERE { ?s a ?c . ?s geo:geometry ?geo . ?s ?p ?o . FILTER ( bif:isnumeric(?o) ) } LIMIT 10
comment: Usage: bif:isnumeric.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

isstring
description: Returns one if its argument is of type VARCHAR, zero otherwise.
description: isstring returns one if its argument is of type VARCHAR, zero otherwise.
license: deed.en US
comment: Usage: bif:isstring.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

iszero
description: iszero returns one if its argument is an integer 0, a float 0.0 or a double 0.0 For any other arguments, of whatever type, it will return zero.
description: Returns one if its argument is an integer 0, a float 0.0 or a double 0.0 For any other arguments, of whatever type, it will return zero.
license: deed.en US
comment: Usage: bif:iszero.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

jvm_ref_import
description: Creates XML description of Java class.
license: deed.en US
comment: Usage: bif:jvm_ref_import.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

lcase
description: lcase returns a copy of string str with all the uppercase alphabetical characters converted to corresponding lowercase letters. This includes also the diacritic letters present in the ISO 8859/1 standard in range 192 - 222 decimal, excluding the character 223, German double-s which stays the same. lower is an alias for lcase.
license: deed.en US
comment: Usage: bif:lcase.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

left
description: left returns a subsequence of string str, taking count characters from the beginning of the string. If count is zero an empty string '' is returned. If length of str is less than count then a copy of the whole str is returned.
license: deed.en US
comment: Usage: bif:left.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

length
description: Returns the length of its argument.
license: deed.en US
comment: SELECT ?label FROM <http://example.com> WHERE { ?s ?p ?label FILTER (bif:length(str(?label))<= 256) }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

locate
description: Returns the starting position of the first occurrence of string_exp1 within string_exp2. The search for the first occurrence of string_exp1 begins with the first character position in string_exp2 unless the optional argument, start, is specified. If start is specified, the search begins with the character position indicated by the value of start. The first character position in string_exp2 is indicated by the value 1. If string_exp1 is not found within string_exp2, the value 0 is returned.
license: deed.en US
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

log
description: log calculates the natural logarithm of its argument and returns it as a IEEE 64-bit float.
license: deed.en US
comment: Usage: bif:log.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

log10
description: log10 calculates the 10-based logarithm of its argument and returns it as a IEEE 64-bit float.
license: deed.en US
comment: Usage: bif:log10.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

lower
description: lcase returns a copy of string str with all the uppercase alphabetical characters converted to corresponding lowercase letters. This includes also the diacritic letters present in the ISO 8859/1 standard in range 192 - 222 decimal, excluding the character 223, German double-s which stays the same. lower is just an alias for lcase.
license: deed.en US
comment: PREFIX sioc_t:<http://rdfs.org/sioc/types#> SELECT DISTINCT ?s FROM <http://example.com> WHERE { ?s sioc_t:Tag ?Tag. FILTER ( bif:lower(str(?Tag)) in ('analisi', 'autonomas', 'autonomia de gobierno', 'autonomia', 'autonomica', 'comun', 'comunidades', 'critico' ) ) }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

lt
description: This function returns 1 if its first argument is less than to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator < and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:lt.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

lte
description: This function returns 1 if its first argument is less than or equivalent to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator <= and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:lte.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

ltrim
description: ltrim returns a copy of subsequence of string str with all the characters present in trimchars trimmed off from the beginning. If the second argument is omitted, it is a space ' ' by default. rtrim is similar except that it trims from the right. trim trims from both ends.
license: deed.en US
comment: Usage: bif:ltrim.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

make_string
description: make_string returns a new string of length count, filled with binary zeros. If count is zero, an empty string '' is returned.
description: Returns a new string of length count, filled with binary zeros. If count is zero, an empty string '' is returned.
license: deed.en US
comment: Usage: bif:make_string.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

minute
description: Decomposes a datetime to minute. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:minute.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

mod
description: mod returns the modulus (i.e. remainder) of the division dividend/divisor. If the divisor is zero the SQL error 22012 "Division by zero" is generated.
license: deed.en US
comment: Usage: bif:mod.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

month
description: Decomposes a datetime to month number, starting at 1 for January. Can be used on timestamps, datetimes, dates and times.
license: deed.en US
comment: Usage: bif:month.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

monthname
description: Monthname takes a datetime and returns a string containing name of the month represented by the datetime
license: deed.en US
comment: Usage: bif:monthname.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

msec_time
description: Returns the number of milliseconds since system epoch. It is useful for benchmarking purposes, timing operations, etc.
license: deed.en US
comment: Usage: bif:msec_time.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

neq
description: This function returns 1 if its first argument is not equivalent to the second argument, respectively. If the arguments are not of the same type, then an appropriate type coercion is done for them before comparison. The function corresponds to SQL query operator <> and is needed because the SQL syntax does not allow these operators to be used on the left side of FROM keyword in a SELECT statement.
license: deed.en US
comment: Usage: bif:neq.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

now
description: Returns the timestamp associated with current transaction as a DATETIME. This value is guaranteed to differ from the timestamp of any other transaction.
license: deed.en US
comment: sparql select ?offer from <http://example.com> where { ?offer a gr:Offering ; gr:validFrom ?validfrom ; gr:validThrough ?validto . FILTER(?validfrom <= bif:now() and ?validto >= bif:now()) . }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

pi
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:pi
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

position
description: Returns the one-based index for the first occurrence of element within an array or string, beginning from offset start_index and iterating with step. If the second argument is a string, the first argument must be a string with a single character. If the second argument is an array of any, then depending of type of it's elements same type is expected as the first argument.
license: deed.en US
comment: select bif:position('b',(str(?o)) from <http://example.com> where {?s ?p ?o} limit 10
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

postgis_proj_version
description: Returns the version of the v7proj4 plugin in use, as a string, for compatibility with PostGIS.
license: deed.en US
comment: Usage: bif:postgis_proj_version.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

power
description: power raises x to the yth power and returns the value as a IEEE 64-bit float.
license: deed.en US
comment: Usage: bif:power.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

quarter
description: quarter takes a datetime and returns an integer containing a number representing the quarter of year of the datetime.
license: deed.en US
comment: Usage: bif:quarter.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

radians
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:radians
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

randomize
description: The rnd function returns a random number between zero and n - 1, inclusive. randomize initializes the random number generator. The random number generator is initialized after the clock at first usage, so the produced sequences will be different each time unless specifically initialized.
license: deed.en US
comment: Usage: bif:randomize.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

rdf_now_impl
description: This function returns the timestamp associated with current transaction as a DATETIME. The function name refer to one function ( alias of now() ) that returns the timestamp of current transaction. It is the datetime of the beginning of current transaction with the fractional part of seconds replaced with serial number of a transaction within the second. If TimezonelessDatetimes=0 then the time has local timezone offset (as it was set at the time of last server start); otherwise it is timezoneless.
license: deed.en US
comment: Usage: bif:rdf_now_impl.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_instr
description: This function looks for a pattern and returns the first position of the pattern. Optionally, you can indicate the start_position you want to begin the search. The occurrence parameter defaults to 1 unless you indicate that you are looking for a subsequent occurrence. The default value of the return_option is 0, which returns the starting position of the pattern; a value of 1 returns the starting position of the next character following the match. This function returns the starting position of a pattern, so it works much like the familiar INSTR function. The main difference between the two functions is that REGEXP_INSTR lets you specify a pattern instead of a specific search string; thus providing greater versatility.
license: deed.en US
comment: Usage: bif:regexp_instr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_like
description: Allows a like comparison using regular-expression.
license: deed.en US
comment: Usage: bif:regexp_like.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_match
description: The regexp_match function returns a copy of substring of string str which matches the regular expression pattern. Previous behavior of this function would cut the first characters of str until the end of regular expression matched substring. In this way str could be passed to this function again to find the next occurrence of substring that matches the regular expression. By default this behavior is not adopted by this function, but can be enabled for pre 3.2 compatibility by supplying the optional third parameter. If either the pattern or str parameter contain wide characters this function will operate in wide mode, first converting any narrow characters to wide and returning a wide character response. Otherwise this function operates in narrow mode by default.
license: deed.en US
comment: Usage: bif:regexp_match.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_parse
description: Returns substrings that match the regular expression in supplied string after an offset
license: deed.en US
comment: Usage: bif:regexp_parse.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_replace
description: This function replaces occurrence(s) of the matching pattern in the source_string with a specified replace_string, allowing complex search-and-replace operations. The traditional REPLACE SQL function substitutes one string with another. Assume your data has extraneous spaces in the text and you would like to replace them with a single space. With the REPLACE function, you would need to list exactly how many spaces you want to replace. However, the number of extra spaces may not be the same everywhere in the text.
license: deed.en US
comment: Usage: bif:regexp_replace.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

regexp_substr
description: This function will return the whole string value of the first substring in "str" that matches the regexp in "pattern" or a sub part of the first match. The regexp syntax allows subexpressions to be marked in the regular expression (using the braces syntax). An example of such type of expression will be: '(2[34]).*(2[35])' which means a regular expression having two subexpressions: '2[34]' and '2[35]'.
license: deed.en US
comment: Usage: bif:regexp_substr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

repeat
description: repeat returns a new string, composed of the string str repeated count times. If count is zero, an empty string '' is returned.
license: deed.en US
comment: Usage: bif:repeat.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

replace
description: Replaces every occurrence of the second argument in the first argument with the third argument. The arguments can be narrow or wide strings.
license: deed.en US
comment: CONSTRUCT { ?s <http://www.w3.org/2002/07/owl#equivalentClass> `iri (bif:replace(?o,'http://schema.rdfs.org/', 'http://schema.org/'))` } FROM <http://www.openlinksw.com/schemas/rdfs> WHERE { ?s <http://www.w3.org/2002/07/owl#equivalentClass> ?o };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

right
description: Returns the count rightmost characters of string str. If count is zero an empty string '' is returned. If length of str is less than count then a copy of the whole str is returned.
license: deed.en US
comment: Usage: bif:right.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

rnd
description: The rnd function returns a random number between zero and n - 1, inclusive. Randomize initializes the random number generator. The random number generator is initialized after the clock at first usage, so the produced sequences will be different each time unless specifically initialized.
license: deed.en US
comment: SELECT ?s ?p ?o FROM <http://example.com> WHERE { ?s ?p ?o . FILTER ( 1 > <bif:rnd> (10, ?s, ?p, ?o) ) }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

rtrim
description: Returns a copy of subsequence of string str with all the characters present in trimchars trimmed off from the beginning. If the second argument is omitted, it is a space ' ' by default. rtrim is similar except that it trims from the right. trim trims from both ends.
license: deed.en US
comment: Usage: bif:rtrim.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

search_excerpt
description: This function produces representative samples for use in displaying a query hit. There are two modes: html mode and text mode. In html mode everything looks like html tags is ignored and searching of excerpt begins from tag. All found hit words highlighted by html_hit_tag. In text mode text is treated as plain text, html tag detection is disabled and hit words is not highlighted.
license: deed.en US
comment: SELECT ?s ?o ?an ( bif:search_excerpt ( bif:vector ( 'In', 'Your' ) , ?o ) ) WHERE { ?s rdf:type mo:Record . ?s schema:creator ?a . ?a foaf:name ?an . ?s dc:title ?o . FILTER ( bif:contains ( ?o, '"in your"' ) ) } LIMIT 10;
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

second
description: second takes a datetime and returns an integer containing a number representing the second of the datetime.
license: deed.en US
comment: Usage: bif:second.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

serialize
description: This function will convert any heterogeneous array or tree of arrays into a binary string and back. The format is platform independent.
license: deed.en US
comment: Usage: bif:serialize.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

sign
description: sign returns either -1, 0 or 1 depending whether its numeric argument is negative, zero or positive.
description: Returns either -1, 0 or 1 depending whether its numeric argument is negative, zero or positive.
license: deed.en US
comment: Usage: bif:sign.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

sin
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:sin
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

space
description: space returns a new string, composed of count spaces. If count is zero, an empty string '' is returned.
license: deed.en US
comment: Usage: bif:space.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

split_and_decode
description: Converts the escaped var=val pair inputs text to a corresponding vector of string elements. If the optional third argument is a string of less than three characters, then does only the decoding (but no splitting) and returns back a string.
license: deed.en US
comment: SELECT bif:aref (bif:split_and_decode('http%3A%2F%2Fexample.org%2Ftest1%3Bhttp%3A%2F%2Fexample.org%2Ftest2',0), 0) { ?S ?P ?O } LIMIT 1
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

sprintf
description: Returns a new string formed by "printing" a variable number of arguments arg_1 - arg_x according to the format string format, that is, exactly the same way as with the sprintf function of C language. However the sprintf function enforces some additional limitations over the sprintf C function.
license: deed.en US
comment: PREFIX nrl:<http://www.semanticdesktop.org/ontologies/2007/08/15/nrl#> SELECT ( bif:exec(bif:sprintf("SPARQL CLEAR GRAPH<%s>", str(?mg)))) WHERE { ?mg nrl:coreGraphMetadataFor ?g . FILTER(?g in ( <http://example.com> )) . FILTER ( !bif:exists((SELECT (1) WHERE { GRAPH ?g { ?s ?p ?o . } . })) ) . }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

sprintf_inverse
description: Gets a string to parse, a format string and an integer (0,1 or 2) that indicates error recovery method. If the first argument matches the format string then it returns vector of the pattern values.
license: deed.en US
comment: define input:storage "" select (bif:aref(bif:sprintf_inverse (str(?idx), bif:concat (str(rdf:_), "%d"), 0), 0)) ?qm from virtrdf: where { virtrdf:DefaultQuadStorage-UserMaps ?idx ?qm . ?qm a virtrdf:QuadMap }
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
type: FunctionalPredicate
type: Item

sprintf_iri
description: Similar to sprintf returns a new string formed by "printing" a variable number of arguments arg_1 - arg_x according to the format string format. The difference is that the returned string is marked as being IRI string so some applications and clients may distinguish between RDF reference string and RDF literal.
license: deed.en US
comment: Usage: bif:sprintf_iri.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

sprintf_iri_or_null
description: Similar to sprintf_iri and returns a new string formed by "printing" a variable number of arguments arg_1 - arg_x according to the format string format. The difference is that the function can return null if any of the arguments except the first one is null. The returned string is marked as being IRI string so some applications and clients may distinguish between RDF reference string and RDF literal.
license: deed.en US
comment: Usage: bif:sprintf_iri_or_null.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

sprintf_or_null
description: Similar to sprintf and returns a new string formed by "printing" a variable number of arguments arg_1 - arg_x according to the format string format. The difference is that the function can return null if any of the arguments except the first one is null.
license: deed.en US
comment: Usage: bif:sprintf_or_null.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

sqrt
description: sqrt calculates the square root of its argument and returns it as a IEEE 64-bit float.
license: deed.en US
comment: Usage: bif:sqrt.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_astext
description: Returns the well known text (WKT) representation of the geometry.
license: deed.en US
comment: Usage: bif:st_astext.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_contains
description: Returns true if all points of a given geometry g2 are in another geometry g1. If prec is supplied, this is a tolerance for the matching in units of linear distance appropriate to the srid. Both geometries should have the same srid.
license: deed.en US
comment: Usage: bif:st_contains.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_distance
description: Returns the shortest distance between two points such that the first point is part of g1 and the second of g2. The srid of g1 and g2 must be the same. If the srid is 4326, the haversine function is used to compute a great circle distance in kilometers on Earth. Otherwise the distance is calculated as on a flat Euclidean plane.
license: deed.en US
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_ewkt_read
description: Parses the given text as a EWKT and returns the parsed shape.
license: deed.en US
comment: Usage: bif:st_ewkt_read.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_geomfromtext
description: Parses the string and returns the corresponding geometry. The string is to be in well known text representation (WKT).
license: deed.en US
comment: Usage: bif:st_geomfromtext.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_get_bounding_box
description: Returns BOX2D that is a bounding box of a shape.
license: deed.en US
comment: Usage: bif:st_get_bounding_box.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_get_bounding_box_n
description: Given a 1-based index of a member of a MULTI or COLLECTION shape, returns the bounding box of a member. This is a fast equivalent of st_get_bounding_box_n(ST_GeometryN (shape,idx)).
license: deed.en US
comment: Usage: bif:st_get_bounding_box_n.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_intersects
description: Returns intersects between two geometries. If prec is supplied, this is a tolerance for the matching in units of linear distance appropriate to the srid. Both geometries should have the same srid. st_intersects is true if there is at least one point in common.
license: deed.en US
comment: SELECT ?c COUNT (*) WHERE { ?m geo:geometry ?geo . ?m a ?c . FILTER (bif:st_intersects (?geo, bif:st_point (0, 52), 100)) } GROUP BY ?c ORDER BY DESC 2;
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_linestring
description: Returns a linestring in default SRID, the coordinates of vertices are specified by arguments that are points, 2-, 3- or 4-item vectors of coordinates, linestrings, arcstrings or vectors of the above mentioned values. Repeating vertices are automatically removed, except the case of repeating vertices in the middle of a linestring/arcstring argument.
license: deed.en US
comment: Usage: bif:st_linestring.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_may_intersect
description: checks whether bounding boxes of two shapes intersect or some of its points are within the specified proximity. This is much faster than full st_intersects() check.
license: deed.en US
comment: Usage: bif:st_may_intersect.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_point
description: Returns a point geometry. The x coordinate corresponds to longitude.
license: deed.en US
comment: SELECT ?c COUNT (*) WHERE { ?m geo:geometry ?geo . ?m a ?c . FILTER (bif:st_intersects (?geo, bif:st_point (0, 52), 100)) } GROUP BY ?c ORDER BY DESC 2;
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_transform_by_custom_projection
description: Performs a custom projection of shape, using the specified algorithm and algorithm-specific arguments.
license: deed.en US
comment: Usage: bif:st_transform_by_custom_projection.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_within
description: Returns true if all points of g1 are in g2. If prec is supplied, this is a tolerance for the matching in units of linear distance appropriate to the srid. Both geometries should have the same srid.
license: deed.en US
comment: Usage: bif:st_within.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_x
description: Retrieves the x coordinate of a geometry.
license: deed.en US
comment: Usage: bif:st_x.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

st_y
description: Retrieves the y coordinate of a geometry.
license: deed.en US
comment: Usage: bif:st_y.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

starts_with
description: Checks whether string X begins with Y, ignoring occurencies of Y in other places. Returns 1 or 0.
license: deed.en US
comment: Usage: bif:starts_with.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

strcasestr
description: Performs a case-insensitive substring search, returning a zero-based index pointing to beginning of first occurrence of sub or NULL if not found.
license: deed.en US
comment: Usage: bif:strcasestr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

strchr
description: Returns a zero-based index to the first occurrence of char. If char is not found NULL is returned. char can be given either as an integer ASCII value or a string, in which case the first character of that string is searched fo.
license: deed.en US
comment: SELECT distinct (bif:subseq (?s, bif:strchr (?s, '#'))) WHERE { graph ?g { ?s ?p `2+2` . FILTER (! bif:isnull (bif:strchr (?s, '#') ) ) } };
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

strcontains
description: Performs a substring search, returning 1 or 0.
license: deed.en US
comment: Usage: bif:strcontains.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

string_output
description: A string output stream is a special object that may be used to buffer arbitrarily long streams of data. They are useful for handling data that would not otherwise fit within normal varchar size limitations. The HTTP output functions optionally take a string output stream handle as a parameter and then output to said stream instead of the HTTP client. A string output stream can be assigned to a database column in insert or update, causing the characters written to the stream to be assigned to the column as a narrow string. The function string_output_string can be used to produce a varchar out of a string output stream. It may be called repeatedly to obtain several copies of the data. http_rewrite can be used to flush a string output stream. If a string output stream is passed to the function result the data stored in it is sent to the client. The string output object cannot be copied. It cannot therefore be assigned between two variables or passed by value (as an IN parameter.) It can be passed by reference (OUT, INOUT parameter.)
license: deed.en US
comment: Usage: bif:string_output.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

string_output_flush
description: Resets the state of the string output object. The string associated with the string output is dropped and is of 0 characters after this call.
license: deed.en US
comment: Usage: bif:string_output_flush.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

string_output_gz_compress
description: Compresses its string_output argument using the gzip algorithm and writes the result to another string_output given as an argument. When successful, the number of bytes written to str_out_out is returned
license: deed.en US
comment: Usage: bif:string_output_gz_compress.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

string_output_string
description: This function is used to produce a string from contents of a string output stream. See string_output for more information about string output streams.
license: deed.en US
comment: Usage: bif:string_output_string.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

string_to_file
description: This function requires dba privileges. string_to_file writes a varchar value or string session to a file. The path is relative to the server's working directory. The mode is an integer value interpreted as a position. A mode of 0 writes the content starting at offset 0. A mode of -1 appends to the end of the file. The append option is probably the most useful for producing application level logs, etc. The string argument can also be a string output object. In this case the content is used as the string. If the mode is -2, the new content supersedes the old. This is different from 0 in that the file will be truncated if the new content is shorter than the old. The DirsAllowed and DirsDenied lists in Parameters section of the virtuoso configuration file (virtuoso.ini by default) are used to control disk access. An error 42000/FA024 is signalled if an attempt is made to write to a file in a directory to which disk access is not explicitly allowed.
license: deed.en US
comment: Usage: bif:string_to_file.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

stringdate
description: stringdate converts dates and timestamps from text to the internal DATETIME type. The external format is: YYYY.MM.DD hh:mm.ss uuuuuu where uuuuuu represents number of microseconds. If trailing parts are omitted from the string given to stringdate, they are assumed to be zero. The three first parts are mandatory. Note that use of cast (x as datetime) is preferred over this function.
description: Converts dates and timestamps from text to the internal DATETIME type. The external format is: YYYY.MM.DD hh:mm.ss uuuuuu where uuuuuu represents number of microseconds. If trailing parts are omitted from the string given to stringdate, they are assumed to be zero. The three first parts are mandatory. Note that use of cast (x as datetime) is preferred over this function.
license: deed.en US
comment: PREFIX dst: <http://linkedgeodata.org/vocabulary#> PREFIX dc: <http://purl.org/dc/elements/1.1/> SELECT (bif:year( bif:stringdate(?sdate)) AS ?syear) (bif:sum( bif:number(?dist)) AS ?distance) FROM <http://example.com> WHERE { ?row dc:date ?sdate . ?row dst:distance ?dist } GROUP BY (bif:year(bif:stringdate(?sdate))) ORDER BY ASC(bif:year(bif:stringdate(?sdate)));
comment: PREFIX dst: <http://linkedgeodata.org/vocabulary#> PREFIX dc: <http://purl.org/dc/elements/1.1/> SELECT (bif:year( bif:stringdate(?sdate)) AS ?syear) (bif:sum( bif:number(?dist)) AS ?distance) FROM <http://example.com> WHERE { ?row dc:date ?sdate . ?row dst:distance ?dist } GROUP BY (bif:year(bif:stringdate(?sdate))) ORDER BY ASC(bif:year(bif:stringdate(?sdate)))
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

stringtime
description: Converts the argument to a time.
license: deed.en US
comment: Usage: bif:stringtime.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

strrchr
description: Returns a zero-based index to the last occurrence of char in string. If char is not found NULL is returned. char can be given either as an integer ASCII value or a string, in which case the first character of that string is searched for in str.
license: deed.en US
comment: Usage: bif:strrchr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

strstr
description: Performs a substring search, returning a zero-based index pointing to beginning of first occurrence of sub or NULL if not found.
license: deed.en US
comment: Usage: bif:strstr.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

subseq
description: Returns a copy of subsequence of string or vector str using zero-based indices from (inclusive) and to (exclusive) to delimit the substring or the vector extracted. If to is omitted or is NULL, then it equals by default to the length of str, i.e. everything from from to the end of str is returned. If to and from are equal, an empty string '' (empty vector) is returned. If from is greater than to or length of str an error is signalled. If str is NULL then NULL is returned.
license: deed.en US
comment: SELECT (xsd:date(bif:subseq(str(?a_dt), 0, 10))), count(*) FROM <http://example.com> WHERE { ?s <http://purl.org/dc/elements/1.1/date> ?a_dt } GROUP BY (xsd:date(bif:subseq(str(?a_dt), 0, 10)));
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

substring
description: Returns a substring of string str. The start index is 1 based. The substring is sublen characters long. This function follows SQL 92.
license: deed.en US
comment: Usage: bif:substring.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

sysutcdatetime
description: The function returns current datetime, like now(), but fractional part of seconds can be adjusted by providing the number of "microseconds" as the argument. The function is similar to curdatetime() but the returned datetime is in GMT timezone.
license: deed.en US
comment: Usage: bif:sysutcdatetime.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

tan
description: This function works with double precision floating point numbers. It converts its argument to an IEEE 64-bit float and return a result of that type.
license: deed.en US
comment: Usage: bif:tan
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

timezone
description: The function returns timezone offset of its first argument, as an integer value in minutes. If the first argument is timezoneless and second argument is missing or zero then the returned value is NULL. If the first argument is timezoneless and second argument is nonzero then the returned value is 0.
license: deed.en US
comment: Usage: bif:timezone.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

tmp_file_name
description: This function is used to obtain unique name of a file, which is located in temporary directory on file system. The two optional parameters can be supplied: prefix of the file and extension for it. These will be prepended and appended (dot MUST be omitted) to the unique string. The directory where this file is located depends of $TMPDIR or %TMP% environment settings for UNIX's and Windows platforms respectively. If these environment settings are not available or empty, the defaults will be used for the operation system. (in practice for most UNIX's it's /tmp or /var/tmp directory). Note that this function do NOT open the file, it only give us a name.
license: deed.en US
comment: Usage: bif:tmp_file_name.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

trim
description: Returns a copy of subsequence of string str with all the characters present in trimchars trimmed off from the beginning. If the second argument is omitted, it is a space ' ' by default. rtrim is similar except that it trims from the right. trim trims from both ends.
license: deed.en US
comment: Usage: bif:trim.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

ucase
description: Returns a copy of string str with all the lowercase alphabetical characters converted to corresponding uppercase letters. This includes also the diacritic letters present in the ISO 8859/1 standard in range 224 - 254 decimal, excluding the character 255, y diaeresis, which is not converted to a German double-s. upper is just an alias for ucase.
license: deed.en US
comment: Usage: bif:ucase.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

upper
description: Returns a copy of string str with all the lowercase alphabetical characters converted to corresponding uppercase letters. This includes also the diacritic letters present in the ISO 8859/1 standard in range 224 - 254 decimal, excluding the character 255, y diaeresis, which is not converted to a German double-s. upper is just an alias for ucase.
license: deed.en US
comment: Usage: bif:upper.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

vector
description: vector returns a new vector (one-dimensional array) constructed from the given arguments.
license: deed.en US
comment: select bif:vector('1',(str(?o), '34') from <http://example.com> where {?s ?p ?o} limit 10
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

vector_concat
description: vector_concat takes a variable number of vectors (heterogeneous arrays) and constructs a new vector containing copies of each (top level) element in the arguments.
license: deed.en US
comment: Usage: bif:vector_concat.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

week
description: week takes a datetime and returns an integer containing a number representing the week of year of the datetime.
license: deed.en US
comment: Usage: bif:week.
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
attribution name: OpenLink Software
creator: this
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA

lt built-in function description
describedby: OpenLink SPARQL BIF Extensions Ontology
about: lt
type: WebPage