bif#
type: Ontology
label: OpenLink SPARQL BIF Extensions Ontology
comment: Ontology that defines entity and relation types used to describe SPARQL BIF extensions. Examples contains, str etc.
imports: 22-rdf-syntax-ns#
imports: terms
imports: sparql-extension-description#
creator: this
describedby: cert
created: 2015-06-09T11:00:00-05:00
version info: 1.0.0
defines: max notnull
defines: GeometryType
defines: ST Affine
defines: ST ExteriorRing
defines: ST GeometryN
defines: ST InteriorRingN
defines: ST M
defines: ST MMax
defines: ST MMin
defines: ST NumGeometries
defines: ST NumInteriorRings
defines: ST SRID
defines: ST SetSRID
defines: ST TransScale
defines: ST Transform
defines: ST Translate
defines: ST XMax
defines: ST XMin
defines: ST YMax
defines: ST YMin
defines: ST Z
defines: ST ZMax
defines: ST ZMin
defines: ST Zmflag
defines: max
defines: min
defines: min notnull
defines: abs
defines: acos
defines: adjust timezone
defines: ascii
defines: asin
defines: atan
defines: atan2
defines: atof
defines: atoi
defines: bit and
defines: bit not
defines: bit or
defines: bit shift
defines: bit xor
defines: blob to string
defines: blob to string output
defines: ceiling
defines: chr
defines: concat
defines: concatenate
defines: contains
defines: cos
defines: cot
defines: curdate
defines: curdatetime
defines: curdatetimeoffset
defines: current timestamp
defines: curutcdatetime
defines: dateadd
defines: datediff
defines: datestring
defines: datestring gmt
defines: dayname
defines: dayofmonth
defines: dayofweek
defines: dayofyear
defines: degrees
defines: dist from point to line segment
defines: dt set tz
defines: earth radius
defines: either
defines: ends with
defines: equ

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

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

bif
type: Document
type: TechArticle
label: OpenLink SPARQL BIF Extensions Ontology Description Document
license: http://creativecommons.org/licenses/by-sa/3.0/
creator: this
comment: This is a document that uses Linked Data oriented content to describe OpenLink SPARQL Extensions BIF Ontology.
subject: bif#
primary topic: bif#
topic: this
topic: max notnull
topic: GeometryType
topic: ST Affine
topic: ST ExteriorRing
topic: ST GeometryN
topic: ST InteriorRingN
topic: ST M
topic: ST MMax
topic: ST MMin
topic: ST NumGeometries
topic: ST NumInteriorRings
topic: ST SRID
topic: ST SetSRID
topic: ST TransScale
topic: ST Transform
topic: ST Translate
topic: ST XMax
topic: ST XMin
topic: ST YMax
topic: ST YMin
topic: ST Z
topic: ST ZMax
topic: ST ZMin
topic: ST Zmflag
topic: max
topic: min
topic: min notnull
topic: abs
topic: acos
topic: adjust timezone
topic: ascii
topic: asin
topic: atan
topic: atan2
topic: atof
topic: atoi
topic: bit and
topic: bit not
topic: bit or
topic: bit shift
topic: bit xor
topic: blob to string
topic: blob to string output
topic: ceiling
topic: chr
topic: concat
topic: concatenate
topic: contains
topic: cos
topic: cot
topic: curdate
topic: curdatetime
topic: curdatetimeoffset
topic: current timestamp
topic: curutcdatetime
topic: dateadd
topic: datediff
topic: datestring
topic: datestring gmt
topic: dayname
topic: dayofmonth
topic: dayofweek
topic: dayofyear
topic: degrees
topic: dist from point to line segment
topic: dt set tz
topic: earth radius
topic: either
topic: ends with
topic: equ
topic: exp

concat
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: concat
comment: sparql select bif:concat(str(?s),(str(?o)) from <http://example.com> where {?s ?p ?o} limit 10
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

position
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: position
comment: select bif:position('b',(str(?o)) from <http://example.com> where {?s ?p ?o} limit 10
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

vector concat
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: vector_concat
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

adjust timezone
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: adjust_timezone
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

curdatetimeoffset
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: curdatetimeoffset
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

current timestamp
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: current_timestamp
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

curutcdatetime
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: curutcdatetime
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

dateadd
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: dateadd
comment: SELECT ?wiki, ?dbp, bif:datediff('second', xsd:DateTime(str(?extracted)) , now()) AS ?secondsAgo WHERE { ?wiki foaf:primaryTopic ?dbp . ?dbp <http://dbpedia.org/ontology/activeYearsEndDate> ?extracted . FILTER ( xsd:DateTime(str(?extracted)) > bif:dateadd('minute', -10, now())) } ORDER BY DESC (xsd:DateTime(str(?extracted))) LIMIT 30
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

datediff
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: datediff
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
description: datediff subtracts date1 from date2 and returns the difference as an integer in the specified units.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

datestring
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: datestring
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

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

dt set tz
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: dt_set_tz
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

forget timezone
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: forget_timezone
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

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

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

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

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

now
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: now
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()) . }
description: Returns the timestamp associated with current transaction as a DATETIME. This value is guaranteed to differ from the timestamp of any other transaction.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

rdf now impl
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: rdf_now_impl
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

stringdate
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: stringdate
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)));
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
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)))
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.

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

sysutcdatetime
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sysutcdatetime
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

timezone
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: timezone
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

contains
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: contains
comment: SELECT * FROM <http://example.com> WHERE { ?s ?p ?o . ?o bif:contains "world" };
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

ST Affine
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_Affine
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)
description: performs standard 2d affine transformation with matrix
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

ST InteriorRingN
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_InteriorRingN
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST M
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_M
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST MMax
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_MMax
comment: SELECT ?s, bif:st_mmax(?o) as ?mmax FROM <http://example.com> WHERE { ?s ?p ?o }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST MMin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_MMin
comment: Usage: bif:ST_MMin. SPARQL SELECT ?s, bif:st_mmin(?o) as ?mmin FROM <http://example.com> WHERE { ?s ?p ?o };
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

ST TransScale
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_TransScale
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))
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

ST XMax
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_XMax
comment: SELECT ?s, bif:st_xmax(?o) as ?xmax FROM <http://example.com> WHERE { ?s ?p ?o }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST XMin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_XMin
comment: SELECT ?s, bif:ST_XMin(?o) as ?xmin FROM <http://example.com> WHERE { ?s ?p ?o }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST YMax
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_YMax
comment: Usage: bif: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
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST YMin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_YMin
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

ST ZMax
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_ZMax
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST ZMin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_ZMin
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ST Zmflag
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ST_Zmflag
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

geo delete
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: geo_delete
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

geo insert
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: geo_insert
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

haversine deg km
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: haversine_deg_km
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

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

st contains
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_contains
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

st distance
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_distance
comment: SELECT ?m (bif:st_distance (?geo, bif:st_point (0, 52))) WHERE { ?m geo:geometry ?geo . ?m a <http://dbpedia.org/ontology/City> . FILTER (bif:st_intersects (?geo, bif:st_point (0, 52), 30)) } ORDER BY DESC 2 LIMIT 20;
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

st get bounding box n
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_get_bounding_box_n
comment: Usage: bif: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)).
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

st intersects
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_intersects
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;
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

st linestring
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_linestring
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

st may intersect
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_may_intersect
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

st point
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_point
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;
description: Returns a point geometry. The x coordinate corresponds to longitude.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

st within
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: st_within
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

acos
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: acos
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

asin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: asin
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

atan
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: atan
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

atan2
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: atan2
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

cos
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: cos
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

cot
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: cot
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

degrees
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: degrees
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

pi
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: pi
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

radians
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: radians
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sin
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sin
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

tan
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: tan
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

atof
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: atof
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

bit and
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: bit_and
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

bit not
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: bit_not
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

bit or
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: bit_or
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

bit shift
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: bit_shift
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

bit xor
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: bit_xor
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

either
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: either
comment: PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> SELECT ?team ( ( bif:either ( ?ew = 'W', -1, 1 ) ) * (?d + ( ( ( ?m * 60 ) + ?s ) / 3600.0 ) ) as ?v ) { ?team a dbo:HockeyTeam . ?team rdfs:label 'New Jersey Devils'@en . ?team dbp:city ?cityname . ?city rdfs:label ?cityname . ?city dbp:longd ?d ; dbp:longm ?m ; dbp:longs ?s ; dbp:longew ?ew . }
description: Returns a copy of arg1 if cond is something else than integer 0 (zero). Otherwise, a copy of arg2 is returned.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

equ
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: equ
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

gt
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: gt
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

gte
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: gte
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

lt
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: lt
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

lte
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: lte
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

neq
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: neq
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

exp
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: exp
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

isfinitenumeric
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: isfinitenumeric
comment: Usage: bif:isfinitenumeric.
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
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.

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

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

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

iszero
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: iszero
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
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.

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

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

lower
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: lower
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' ) ) }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

mod
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: mod
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

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

randomize
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: randomize
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

rnd
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: rnd
comment: SELECT ?s ?p ?o FROM <http://example.com> WHERE { ?s ?p ?o . FILTER ( 1 > <bif:rnd> (10, ?s, ?p, ?o) ) }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

blob to string
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: blob_to_string
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

blob to string output
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: blob_to_string_output
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

initcap
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: initcap
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

lcase
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: lcase
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

left
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: left
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

locate
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: locate
comment: PREFIX rdfs: <http://www.w3.org/2000/01/rdf-schema#> PREFIX dbo: <http://dbpedia.org/ontology/> PREFIX dbp: <http://dbpedia.org/property/> SELECT ?team ( ( bif:locate( 'W', ?ew )) * (?d + (((?m * 60) + ?s) / 3600.0)) as ?v ) { ?team a dbo:HockeyTeam . ?team rdfs:label 'New Jersey Devils'@en . ?team dbp:city ?cityname . ?city rdfs:label ?cityname . ?city dbp:longd ?d ; dbp:longm ?m ; dbp:longs ?s ; dbp:longew ?ew . }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ltrim
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ltrim
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

make string
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: make_string
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink
description: Returns a new string of length count, filled with binary zeros. If count is zero, an empty string '' is returned.

regexp instr
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: regexp_instr
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

regexp match
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: regexp_match
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

regexp replace
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: regexp_replace
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

regexp substr
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: regexp_substr
comment: Usage: bif: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]'.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

replace
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: replace
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 };
description: Replaces every occurrence of the second argument in the first argument with the third argument. The arguments can be narrow or wide strings.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

right
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: right
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

rtrim
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: rtrim
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

search excerpt
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: search_excerpt
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;
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

split and decode
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: split_and_decode
comment: SELECT bif:aref (bif:split_and_decode('https%3A%2F%2Fblue-sea-697d.quartiers047.workers.dev%3A443%2Fhttp%2Fexample.org%2Ftest1%3Bhttps%3A%2F%2Fblue-sea-697d.quartiers047.workers.dev%3A443%2Fhttp%2Fexample.org%2Ftest2',0), 0) { ?S ?P ?O } LIMIT 1
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sprintf
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sprintf
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 . } . })) ) . }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sprintf inverse
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sprintf_inverse
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 }
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sprintf iri
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sprintf_iri
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sprintf iri or null
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sprintf_iri_or_null
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

sprintf or null
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: sprintf_or_null
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

strcasestr
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: strcasestr
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

strchr
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: strchr
comment: SELECT distinct (bif:subseq (?s, bif:strchr (?s, '#'))) WHERE { graph ?g { ?s ?p `2+2` . FILTER (! bif:isnull (bif:strchr (?s, '#') ) ) } };
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

string output
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: string_output
comment: Usage: bif: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.)
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

string output flush
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: string_output_flush
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

string output gz compress
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: string_output_gz_compress
comment: Usage: bif: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
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

string output string
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: string_output_string
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

string to file
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: string_to_file
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

strrchr
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: strrchr
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

subseq
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: subseq
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)));
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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

substring
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: substring
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

tmp file name
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: tmp_file_name
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

trim
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: trim
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

ucase
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: ucase
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

upper
type: Item
type: FunctionalPredicate
type: Mx4rvVxAsJwpEbGdrcN5Y29ycA
is defined by: bif#
label: upper
comment: Usage: bif: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.
creator: this
license: deed.en US
attribution name: OpenLink Software
attribution URL: http://www.openlinksw.com/dataspace/organization/openlink

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

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

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

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

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

fn nm max notnull.html
type: WebPage
about: max notnull
describedby: bif#
label: __max_notnull built-in function description

fn GeometryType.html
type: WebPage
about: GeometryType
describedby: bif#
label: GeometryType built-in function description

fn ST Affine.html
type: WebPage
about: ST Affine
describedby: bif#
label: ST_Affine built-in function description

fn ST ExteriorRing.html
type: WebPage
about: ST ExteriorRing
describedby: bif#
label: ST_ExteriorRing built-in function description

fn ST GeometryN.html
type: WebPage
about: ST GeometryN
describedby: bif#
label: ST_GeometryN built-in function description

fn ST InteriorRingN.html
type: WebPage
about: ST InteriorRingN
describedby: bif#
label: ST_InteriorRingN built-in function description

fn ST M.html
type: WebPage
about: ST M
describedby: bif#
label: ST_M built-in function description

fn ST MMax.html
type: WebPage
about: ST MMax
describedby: bif#
label: ST_MMax built-in function description

fn ST MMin.html
type: WebPage
about: ST MMin
describedby: bif#
label: ST_MMin built-in function description

fn ST NumGeometries.html
type: WebPage
about: ST NumGeometries
describedby: bif#
label: ST_NumGeometries built-in function description

fn ST NumInteriorRings.html
type: WebPage
about: ST NumInteriorRings
describedby: bif#
label: ST_NumInteriorRings built-in function description

fn ST SRID.html
type: WebPage
about: ST SRID
describedby: bif#
label: ST_SRID built-in function description

fn ST SetSRID.html
type: WebPage
about: ST SetSRID
describedby: bif#
label: ST_SetSRID built-in function description

fn ST TransScale.html
type: WebPage
about: ST TransScale
describedby: bif#
label: ST_TransScale built-in function description

fn ST Transform.html
type: WebPage
about: ST Transform
describedby: bif#
label: ST_Transform built-in function description

fn ST Translate.html
type: WebPage
about: ST Translate
describedby: bif#
label: ST_Translate built-in function description

fn ST XMax.html
type: WebPage
about: ST XMax
describedby: bif#
label: ST_XMax built-in function description

fn ST XMin.html
type: WebPage
about: ST XMin
describedby: bif#
label: ST_XMin built-in function description

fn ST YMax.html
type: WebPage
about: ST YMax
describedby: bif#
label: ST_YMax built-in function description

fn ST YMin.html
type: WebPage
about: ST YMin
describedby: bif#
label: ST_YMin built-in function description

fn ST Z.html
type: WebPage
about: ST Z
describedby: bif#
label: ST_Z built-in function description

fn ST ZMax.html
type: WebPage
about: ST ZMax
describedby: bif#
label: ST_ZMax built-in function description

fn ST ZMin.html
type: WebPage
about: ST ZMin
describedby: bif#
label: ST_ZMin built-in function description

fn ST Zmflag.html
type: WebPage
about: ST Zmflag
describedby: bif#
label: ST_Zmflag built-in function description

fn nm max.html
type: WebPage
about: max
describedby: bif#
label: __max built-in function description

fn nm min.html
type: WebPage
about: min
describedby: bif#
label: __min built-in function description

fn nm min notnull.html
type: WebPage
about: min notnull
describedby: bif#
label: __min_notnull built-in function description

fn abs.html
type: WebPage
about: abs
describedby: bif#
label: abs built-in function description

fn equ.html
type: WebPage
about: equ
about: gt
about: gte
about: lt
about: lte
about: neq
describedby: bif#
label: equ, gt, gte, lt, lte, neq built-in functions description

fn acos.html
type: WebPage
about: acos
about: degrees
about: cot
about: pi
about: radians
about: sin
about: tan
about: asin
about: atan
about: atan2
about: cos
describedby: bif#
label: acos, asin, atan, atan2, cos, cot, degrees, pi, radians, sin, tan built-in functions description

fn adjust timezone.html
type: WebPage
about: adjust timezone
describedby: bif#
label: adjust_timezone built-in function description

fn ascii.html
type: WebPage
about: ascii
describedby: bif#
label: ascii built-in function description

fn atof.html
type: WebPage
about: atof
describedby: bif#
label: atof built-in function description

fn atoi.html
type: WebPage
about: atoi
describedby: bif#
label: atoi built-in function description

fn bit and.html
type: WebPage
about: bit and
describedby: bif#
label: bit_and built-in function description

fn bit not.html
type: WebPage
about: bit not
describedby: bif#
label: bit_not built-in function description

fn bit or.html
type: WebPage
about: bit or
describedby: bif#
label: bit_or built-in function description

fn bit shift.html
type: WebPage
about: bit shift
describedby: bif#
label: bit_shift built-in function description

fn bit xor.html
type: WebPage
about: bit xor
describedby: bif#
label: bit_xor built-in function description

fn blob to string.html
type: WebPage
about: blob to string
describedby: bif#
label: blob_to_string built-in function description

fn blob to string output.html
type: WebPage
about: blob to string output
describedby: bif#
label: blob_to_string_output built-in function description

fn ceiling.html
type: WebPage
about: ceiling
describedby: bif#
label: ceiling built-in function description

fn chr.html
type: WebPage
about: chr
describedby: bif#
label: chr built-in function description

fn concat.html
type: WebPage
about: concat
describedby: bif#
label: concat built-in function description

fn concatenate.html
type: WebPage
about: concatenate
describedby: bif#
label: concatenate built-in function description

fn contains.html
type: WebPage
about: contains
describedby: bif#
label: contains built-in function description

fn curdate.html
type: WebPage
about: curdate
describedby: bif#
label: curdate built-in function description

fn curdatetime.html
type: WebPage
about: curdatetime
describedby: bif#
label: curdatetime built-in function description

fn curdatetimeoffset.html
type: WebPage
about: curdatetimeoffset
describedby: bif#
label: curdatetimeoffset built-in function description

fn current timestamp.html
type: WebPage
about: current timestamp
describedby: bif#
label: current_timestamp built-in function description

fn curutcdatetime.html
type: WebPage
about: curutcdatetime
describedby: bif#
label: curutcdatetime built-in function description

fn dateadd.html
type: WebPage
about: dateadd
describedby: bif#
label: dateadd built-in function description

fn datediff.html
type: WebPage
about: datediff
describedby: bif#
label: datediff built-in function description

fn datestring.html
type: WebPage
about: datestring
describedby: bif#
label: datestring built-in function description

fn datestring gmt.html
type: WebPage
about: datestring gmt
describedby: bif#
label: datestring_gmt built-in function description

fn dayname.html
type: WebPage
about: dayname
describedby: bif#
label: dayname built-in function description

fn dayofmonth.html
type: WebPage
about: dayofmonth
describedby: bif#
label: dayofmonth built-in function description

fn dayofweek.html
type: WebPage
about: dayofweek
describedby: bif#
label: dayofweek built-in function description

fn dayofyear.html
type: WebPage
about: dayofyear
describedby: bif#
label: dayofyear built-in function description

fn dist from point to line segment.html
type: WebPage
about: dist from point to line segment
describedby: bif#
label: dist_from_point_to_line_segment built-in function description

fn dt set tz.html
type: WebPage
about: dt set tz
describedby: bif#
label: dt_set_tz built-in function description

fn earth radius.html
type: WebPage
about: earth radius
describedby: bif#
label: earth_radius built-in function description

fn either.html
type: WebPage
about: either
describedby: bif#
label: either built-in function description

fn ends with.html
type: WebPage
about: ends with
describedby: bif#
label: ends_with built-in function description

fn exp.html
type: WebPage
about: exp
describedby: bif#
label: exp built-in function description

fn floor.html
type: WebPage
about: floor
describedby: bif#
label: floor built-in function description

fn forget timezone.html
type: WebPage
about: forget timezone
describedby: bif#
label: forget_timezone built-in function description

fn geo delete.html
type: WebPage
about: geo delete
describedby: bif#
label: geo_delete built-in function description

fn geo insert.html
type: WebPage
about: geo insert
describedby: bif#
label: geo_insert built-in function description

fn get timestamp.html
type: WebPage
about: get timestamp
describedby: bif#
label: get_timestamp built-in function description

fn getdate.html
type: WebPage
about: getdate
describedby: bif#
label: getdate built-in function description

fn haversine deg km.html
type: WebPage
about: haversine deg km
describedby: bif#
label: haversine_deg_km built-in function description

fn hour.html
type: WebPage
about: hour
describedby: bif#
label: hour built-in function description

fn http st dxf entity.html
type: WebPage
about: http st dxf entity
describedby: bif#
label: http_st_dxf_entity built-in function description

fn http st ewkt.html
type: WebPage
about: http st ewkt
describedby: bif#
label: http_st_ewkt built-in function description

fn initcap.html
type: WebPage
about: initcap
describedby: bif#
label: initcap built-in function description

fn is timezoneless.html
type: WebPage
about: is timezoneless
describedby: bif#
label: is_timezoneless built-in function description

fn isarray.html
type: WebPage
about: isarray
describedby: bif#
label: isarray built-in function description

fn isbinary.html
type: WebPage
about: isbinary
describedby: bif#
label: isbinary built-in function description

fn isblob.html
type: WebPage
about: isblob
describedby: bif#
label: isblob built-in function description

fn isdouble.html
type: WebPage
about: isdouble
describedby: bif#
label: isdouble built-in function description

fn isentity.html
type: WebPage
about: isentity
describedby: bif#
label: isentity built-in function description

fn isfinitenumeric.html
type: WebPage
about: isfinitenumeric
describedby: bif#
label: isfinitenumeric built-in function description

fn isfloat.html
type: WebPage
about: isfloat
describedby: bif#
label: isfloat built-in function description

fn isgeometry.html
type: WebPage
about: isgeometry
describedby: bif#
label: isgeometry built-in function description

fn isinteger.html
type: WebPage
about: isinteger
describedby: bif#
label: isinteger built-in function description

fn isnull.html
type: WebPage
about: isnull
describedby: bif#
label: isnull built-in function description

fn isnumeric.html
type: WebPage
about: isnumeric
describedby: bif#
label: isnumeric built-in function description

fn isstring.html
type: WebPage
about: isstring
describedby: bif#
label: isstring built-in function description

fn iszero.html
type: WebPage
about: iszero
describedby: bif#
label: iszero built-in function description

fn jvm ref import.html
type: WebPage
about: jvm ref import
describedby: bif#
label: jvm_ref_import built-in function description

fn lcase.html
type: WebPage
about: lcase
describedby: bif#
label: lcase built-in function description

fn left.html
type: WebPage
about: left
describedby: bif#
label: left built-in function description

fn length.html
type: WebPage
about: length
describedby: bif#
label: length built-in function description

fn locate.html
type: WebPage
about: locate
describedby: bif#
label: locate built-in function description

fn log.html
type: WebPage
about: log
describedby: bif#
label: log built-in function description

fn log10.html
type: WebPage
about: log10
describedby: bif#
label: log10 built-in function description

fn lower.html
type: WebPage
about: lower
describedby: bif#
label: lower built-in function description

fn lt.html
type: WebPage
about: lt
describedby: bif#
label: lt built-in function description

fn ltrim.html
type: WebPage
about: ltrim
describedby: bif#
label: ltrim built-in function description

fn make string.html
type: WebPage
about: make string
describedby: bif#
label: make_string built-in function description

fn minute.html
type: WebPage
about: minute
describedby: bif#
label: minute built-in function description

fn mod.html
type: WebPage
about: mod
describedby: bif#
label: mod built-in function description

fn month.html
type: WebPage
about: month
describedby: bif#
label: month built-in function description

fn monthname.html
type: WebPage
about: monthname
describedby: bif#
label: monthname built-in function description

fn msec time.html
type: WebPage
about: msec time
describedby: bif#
label: msec_time built-in function description

fn now.html
type: WebPage
about: now
describedby: bif#
label: now built-in function description

fn position.html
type: WebPage
about: position
describedby: bif#
label: position built-in function description

fn postgis proj version.html
type: WebPage
about: postgis proj version
describedby: bif#
label: postgis_proj_version built-in function description

fn power.html
type: WebPage
about: power
describedby: bif#
label: power built-in function description

fn quarter.html
type: WebPage
about: quarter
describedby: bif#
label: quarter built-in function description

fn randomize.html
type: WebPage
about: randomize
describedby: bif#
label: randomize built-in function description

fn rdf now impl.html
type: WebPage
about: rdf now impl
describedby: bif#
label: rdf_now_impl built-in function description

fn regexp instr.html
type: WebPage
about: regexp instr
describedby: bif#
label: regexp_instr built-in function description

fn regexp like.html
type: WebPage
about: regexp like
describedby: bif#
label: regexp_like built-in function description

fn regexp match.html
type: WebPage
about: regexp match
describedby: bif#
label: regexp_match built-in function description

fn regexp parse.html
type: WebPage
about: regexp parse
describedby: bif#
label: regexp_parse built-in function description

fn regexp replace.html
type: WebPage
about: regexp replace
describedby: bif#
label: regexp_replace built-in function description

fn regexp substr.html
type: WebPage
about: regexp substr
describedby: bif#
label: regexp_substr built-in function description

fn repeat.html
type: WebPage
about: repeat
describedby: bif#
label: repeat built-in function description

fn replace.html
type: WebPage
about: replace
describedby: bif#
label: replace built-in function description

fn right.html
type: WebPage
about: right
describedby: bif#
label: right built-in function description

fn rnd.html
type: WebPage
about: rnd
describedby: bif#
label: rnd built-in function description

fn rtrim.html
type: WebPage
about: rtrim
describedby: bif#
label: rtrim built-in function description

fn search excerpt.html
type: WebPage
about: search excerpt
describedby: bif#
label: search_excerpt built-in function description

fn second.html
type: WebPage
about: second
describedby: bif#
label: second built-in function description

fn serialize.html
type: WebPage
about: serialize
describedby: bif#
label: serialize built-in function description

fn sign.html
type: WebPage
about: sign
describedby: bif#
label: sign built-in function description

fn space.html
type: WebPage
about: space
describedby: bif#
label: space built-in function description

fn split and decode.html
type: WebPage
about: split and decode
describedby: bif#
label: split_and_decode built-in function description

fn sprintf.html
type: WebPage
about: sprintf
describedby: bif#
label: sprintf built-in function description

fn sprintf inverse.html
type: WebPage
about: sprintf inverse
describedby: bif#
label: sprintf_inverseX built-in function description

fn sprintf iri.html
type: WebPage
about: sprintf iri
describedby: bif#
label: sprintf_iri built-in function description

fn sprintf iri or null.html
type: WebPage
about: sprintf iri or null
describedby: bif#
label: sprintf_iri_or_null built-in function description

fn sprintf or null.html
type: WebPage
about: sprintf or null
describedby: bif#
label: sprintf_or_null built-in function description

fn sqrt.html
type: WebPage
about: sqrt
describedby: bif#
label: sqrt built-in function description

fn st astext.html
type: WebPage
about: st astext
describedby: bif#
label: st_astext built-in function description

fn st contains.html
type: WebPage
about: st contains
describedby: bif#
label: st_contains built-in function description

fn st distance.html
type: WebPage
about: st distance
describedby: bif#
label: st_distance built-in function description

fn st ewkt read.html
type: WebPage
about: st ewkt read
describedby: bif#
label: st_ewkt_read built-in function description

fn st geomfromtext.html
type: WebPage
about: st geomfromtext
describedby: bif#
label: st_geomfromtext built-in function description

fn st get bounding box.html
type: WebPage
about: st get bounding box
describedby: bif#
label: st_get_bounding_box built-in function description

fn st get bounding box n.html
type: WebPage
about: st get bounding box n
describedby: bif#
label: st_get_bounding_box_n built-in function description

fn st intersects.html
type: WebPage
about: st intersects
describedby: bif#
label: st_intersects built-in function description

fn st linestring.html
type: WebPage
about: st linestring
describedby: bif#
label: st_linestring built-in function description

fn st may intersect.html
type: WebPage
about: st may intersect
describedby: bif#
label: st_may_intersect built-in function description

fn st point.html
type: WebPage
about: st point
describedby: bif#
label: st_point built-in function description

fn st transform by custom projection.html
type: WebPage
about: st transform by custom projection
describedby: bif#
label: st_transform_by_custom_projection built-in function description

fn st within.html
type: WebPage
about: st within
describedby: bif#
label: st_within built-in function description

fn st x.html
type: WebPage
about: st x
describedby: bif#
label: st_x built-in function description

fn st y.html
type: WebPage
about: st y
describedby: bif#
label: st_y built-in function description

fn starts with.html
type: WebPage
about: starts with
describedby: bif#
label: starts_with built-in function description

fn strcasestr.html
type: WebPage
about: strcasestr
describedby: bif#
label: strcasestr built-in function description

fn strchr.html
type: WebPage
about: strchr
describedby: bif#
label: strchr built-in function description

fn strcontains.html
type: WebPage
about: strcontains
describedby: bif#
label: strcontains built-in function description

fn string output.html
type: WebPage
about: string output
describedby: bif#
label: string_output built-in function description

fn string output flush.html
type: WebPage
about: string output flush
describedby: bif#
label: string_output_flush built-in function description

fn string output gz compress.html
type: WebPage
about: string output gz compress
describedby: bif#
label: string_output_gz_compress built-in function description

fn string output string.html
type: WebPage
about: string output string
describedby: bif#
label: string_output_string built-in function description

fn string to file.html
type: WebPage
about: string to file
describedby: bif#
label: string_to_file built-in function description

fn stringdate.html
type: WebPage
about: stringdate
describedby: bif#
label: stringdate built-in function description

fn stringtime.html
type: WebPage
about: stringtime
describedby: bif#
label: stringtime built-in function description

fn strrchr.html
type: WebPage
about: strrchr
describedby: bif#
label: strrchr built-in function description

fn strstr.html
type: WebPage
about: strstr
describedby: bif#
label: strstr built-in function description

fn subseq.html
type: WebPage
about: subseq
describedby: bif#
label: subseq built-in function description

fn substring.html
type: WebPage
about: substring
describedby: bif#
label: substring built-in function description

fn sysutcdatetime.html
type: WebPage
about: sysutcdatetime
describedby: bif#
label: sysutcdatetime built-in function description

fn timezone.html
type: WebPage
about: timezone
describedby: bif#
label: timezone built-in function description

fn tmp file name.html
type: WebPage
about: tmp file name
describedby: bif#
label: tmp_file_name built-in function description

fn trim.html
type: WebPage
about: trim
describedby: bif#
label: trim built-in function description

fn ucase.html
type: WebPage
about: ucase
describedby: bif#
label: ucase built-in function description

fn upper.html
type: WebPage
about: upper
describedby: bif#
label: upper built-in function description

fn vector.html
type: WebPage
about: vector
describedby: bif#
label: vector built-in function description

fn vector concat.html
type: WebPage
about: vector concat
describedby: bif#
label: vector_concat built-in function description

fn week.html
type: WebPage
about: week
describedby: bif#
label: week built-in function description