## Turtle Document That Describes Virtuoso functions and bif: usage ##
@prefix schema: .
@prefix sioc: .
@prefix xhv: .
@prefix gr: .
@prefix xsd: .
@prefix rdfs: .
@prefix rdf: .
@prefix owl: .
@prefix dcterms: .
@prefix wdrs: .
@prefix foaf: .
@prefix siocs: .
@prefix skos: .
@prefix cc: .
@prefix bibo: .
@prefix doc: .
# @prefix : .
@prefix : .
# @prefix source: .
@prefix source: .
@prefix sourceDAV: .
sourceDAV:
a foaf:Document ;
rdfs:label """Virtuoso BIF Functions"""^^xsd:string ;
rdfs:comment """Turtle Document about Virtuoso BIF Functions."""@en ;
foaf:maker ;
xhv:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
owl:sameAs source: .
source:
a foaf:Document ;
rdfs:label """About Virtuoso BIF Functions"""^^xsd:string ;
rdfs:comment """A collection of Virtuoso BIF Functions."""@en ;
dcterms:created "2014-01-21"^^xsd:date ;
dcterms:modified "2017-11-02"^^xsd:date ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
foaf:topic
:__max_notnull ,
:GeometryType ,
:ST_Affine ,
:ST_ExteriorRing ,
:ST_GeometryN ,
:ST_InteriorRingN ,
:ST_M ,
:ST_MMax ,
:ST_MMin ,
:ST_NumGeometries ,
:ST_NumInteriorRings ,
:ST_SRID ,
:ST_SetSRID ,
:ST_TransScale ,
:ST_Transform ,
:ST_Translate ,
:ST_XMax ,
:ST_XMin ,
:ST_YMax ,
:ST_YMin ,
:ST_Z ,
:ST_ZMax ,
:ST_ZMin ,
:ST_Zmflag ,
:__max ,
:__min ,
:__min_notnull ,
:abs ,
:acos ,
:adjust_timezone ,
:ascii ,
:asin ,
:atan ,
:atan2 ,
:atof ,
:atoi ,
:bit_and ,
:bit_not ,
:bit_or ,
:bit_shift ,
:bit_xor ,
:blob_to_string ,
:blob_to_string_output ,
:ceiling ,
:chr ,
:concat ,
:concatenate ,
:contains ,
:cos ,
:cot ,
:curdate ,
:curdatetime ,
:curdatetimeoffset ,
:current_timestamp ,
:curutcdatetime ,
:dateadd ,
:datediff ,
:datestring ,
:datestring_gmt ,
:dayname ,
:dayofmonth ,
:dayofweek ,
:dayofyear ,
:degrees ,
:dist_from_point_to_line_segment ,
:dt_set_tz ,
:earth_radius ,
:either ,
:ends_with ,
:equ ,
:exp ,
:floor ,
:forget_timezone ,
:geo_delete ,
:geo_insert ,
:get_timestamp ,
:getdate ,
:gt ,
:gte ,
:haversine_deg_km ,
:hour ,
:http_st_dxf_entity ,
:http_st_ewkt ,
:initcap ,
:is_timezoneless ,
:isarray ,
:isbinary ,
:isblob ,
:isdouble ,
:isentity ,
:isfinitenumeric ,
:isfloat ,
:isgeometry ,
:isinteger ,
:isnull ,
:isnumeric ,
:isstring ,
:iszero ,
:jvm_ref_import ,
:lcase ,
:left ,
:length ,
:locate ,
:log ,
:log10 ,
:lower ,
:lt ,
:lte ,
:ltrim ,
:make_string ,
:minute ,
:mod ,
:month ,
:monthname ,
:msec_time ,
:neq ,
:now ,
:pi ,
:position ,
:postgis_proj_version ,
:power ,
:quarter ,
:radians ,
:randomize ,
:rdf_now_impl ,
:regexp_instr ,
:regexp_like ,
:regexp_match ,
:regexp_parse ,
:regexp_replace ,
:regexp_substr ,
:repeat ,
:replace ,
:right ,
:rnd ,
:rtrim ,
:search_excerpt ,
:second ,
:serialize ,
:sign ,
:sin ,
:space ,
:split_and_decode ,
:sprintf ,
:sprintf_inverse ,
:sprintf_iri ,
:sprintf_iri_or_null ,
:sprintf_or_null ,
:sqrt ,
:st_astext ,
:st_contains ,
:st_distance ,
:st_ewkt_read ,
:st_geomfromtext ,
:st_get_bounding_box ,
:st_get_bounding_box_n ,
:st_intersects ,
:st_linestring ,
:st_may_intersect ,
:st_point ,
:st_transform_by_custom_projection ,
:st_within ,
:st_x ,
:st_y ,
:starts_with ,
:strcasestr ,
:strchr ,
:strcontains ,
:string_output ,
:string_output_flush ,
:string_output_gz_compress ,
:string_output_string ,
:string_to_file ,
:stringdate ,
:stringtime ,
:strrchr ,
:strstr ,
:subseq ,
:substring ,
:sysutcdatetime ,
:tan ,
:timezone ,
:tmp_file_name ,
:trim ,
:ucase ,
:upper ,
:vector ,
:vector_concat ,
:week ;
schema:about
:__max_notnull ,
:GeometryType ,
:ST_Affine ,
:ST_ExteriorRing ,
:ST_GeometryN ,
:ST_InteriorRingN ,
:ST_M ,
:ST_MMax ,
:ST_MMin ,
:ST_NumGeometries ,
:ST_NumInteriorRings ,
:ST_SRID ,
:ST_SetSRID ,
:ST_TransScale ,
:ST_Transform ,
:ST_Translate ,
:ST_XMax ,
:ST_XMin ,
:ST_YMax ,
:ST_YMin ,
:ST_Z ,
:ST_ZMax ,
:ST_ZMin ,
:ST_Zmflag ,
:__max ,
:__min ,
:__min_notnull ,
:abs ,
:acos ,
:adjust_timezone ,
:ascii ,
:asin ,
:atan ,
:atan2 ,
:atof ,
:atoi ,
:bit_and ,
:bit_not ,
:bit_or ,
:bit_shift ,
:bit_xor ,
:blob_to_string ,
:blob_to_string_output ,
:ceiling ,
:chr ,
:concat ,
:concatenate ,
:contains ,
:cos ,
:cot ,
:curdate ,
:curdatetime ,
:curdatetimeoffset ,
:current_timestamp ,
:curutcdatetime ,
:dateadd ,
:datediff ,
:datestring ,
:datestring_gmt ,
:dayname ,
:dayofmonth ,
:dayofweek ,
:dayofyear ,
:degrees ,
:dist_from_point_to_line_segment ,
:dt_set_tz ,
:earth_radius ,
:either ,
:ends_with ,
:equ ,
:exp ,
:floor ,
:forget_timezone ,
:geo_delete ,
:geo_insert ,
:get_timestamp ,
:getdate ,
:gt ,
:gte ,
:haversine_deg_km ,
:hour ,
:http_st_dxf_entity ,
:http_st_ewkt ,
:initcap ,
:is_timezoneless ,
:isarray ,
:isbinary ,
:isblob ,
:isdouble ,
:isentity ,
:isfinitenumeric ,
:isfloat ,
:isgeometry ,
:isinteger ,
:isnull ,
:isnumeric ,
:isstring ,
:iszero ,
:jvm_ref_import ,
:lcase ,
:left ,
:length ,
:locate ,
:log ,
:log10 ,
:lower ,
:lt ,
:lte ,
:ltrim ,
:make_string ,
:minute ,
:mod ,
:month ,
:monthname ,
:msec_time ,
:neq ,
:now ,
:pi ,
:position ,
:postgis_proj_version ,
:power ,
:quarter ,
:radians ,
:randomize ,
:rdf_now_impl ,
:regexp_instr ,
:regexp_like ,
:regexp_match ,
:regexp_parse ,
:regexp_replace ,
:regexp_substr ,
:repeat ,
:replace ,
:right ,
:rnd ,
:rtrim ,
:search_excerpt ,
:second ,
:serialize ,
:sign ,
:sin ,
:space ,
:split_and_decode ,
:sprintf ,
:sprintf_inverse ,
:sprintf_iri ,
:sprintf_iri_or_null ,
:sprintf_or_null ,
:sqrt ,
:st_astext ,
:st_contains ,
:st_distance ,
:st_ewkt_read ,
:st_geomfromtext ,
:st_get_bounding_box ,
:st_get_bounding_box_n ,
:st_intersects ,
:st_linestring ,
:st_may_intersect ,
:st_point ,
:st_transform_by_custom_projection ,
:st_within ,
:st_x ,
:st_y ,
:starts_with ,
:strcasestr ,
:strchr ,
:strcontains ,
:string_output ,
:string_output_flush ,
:string_output_gz_compress ,
:string_output_string ,
:string_to_file ,
:stringdate ,
:stringtime ,
:strrchr ,
:strstr ,
:subseq ,
:substring ,
:sysutcdatetime ,
:tan ,
:timezone ,
:tmp_file_name ,
:trim ,
:ucase ,
:upper ,
:vector ,
:vector_concat ,
:week ;
dcterms:subject
:__max_notnull ,
:GeometryType ,
:ST_Affine ,
:ST_ExteriorRing ,
:ST_GeometryN ,
:ST_InteriorRingN ,
:ST_M ,
:ST_MMax ,
:ST_MMin ,
:ST_NumGeometries ,
:ST_NumInteriorRings ,
:ST_SRID ,
:ST_SetSRID ,
:ST_TransScale ,
:ST_Transform ,
:ST_Translate ,
:ST_XMax ,
:ST_XMin ,
:ST_YMax ,
:ST_YMin ,
:ST_Z ,
:ST_ZMax ,
:ST_ZMin ,
:ST_Zmflag ,
:__max ,
:__min ,
:__min_notnull ,
:abs ,
:acos ,
:adjust_timezone ,
:ascii ,
:asin ,
:atan ,
:atan2 ,
:atof ,
:atoi ,
:bit_and ,
:bit_not ,
:bit_or ,
:bit_shift ,
:bit_xor ,
:blob_to_string ,
:blob_to_string_output ,
:ceiling ,
:chr ,
:concat ,
:concatenate ,
:contains ,
:cos ,
:cot ,
:curdate ,
:curdatetime ,
:curdatetimeoffset ,
:current_timestamp ,
:curutcdatetime ,
:dateadd ,
:datediff ,
:datestring ,
:datestring_gmt ,
:dayname ,
:dayofmonth ,
:dayofweek ,
:dayofyear ,
:degrees ,
:dist_from_point_to_line_segment ,
:dt_set_tz ,
:earth_radius ,
:either ,
:ends_with ,
:equ ,
:exp ,
:floor ,
:forget_timezone ,
:geo_delete ,
:geo_insert ,
:get_timestamp ,
:getdate ,
:gt ,
:gte ,
:haversine_deg_km ,
:hour ,
:http_st_dxf_entity ,
:http_st_ewkt ,
:initcap ,
:is_timezoneless ,
:isarray ,
:isbinary ,
:isblob ,
:isdouble ,
:isentity ,
:isfinitenumeric ,
:isfloat ,
:isgeometry ,
:isinteger ,
:isnull ,
:isnumeric ,
:isstring ,
:iszero ,
:jvm_ref_import ,
:lcase ,
:left ,
:length ,
:locate ,
:log ,
:log10 ,
:lower ,
:lt ,
:lte ,
:ltrim ,
:make_string ,
:minute ,
:mod ,
:month ,
:monthname ,
:msec_time ,
:neq ,
:now ,
:pi ,
:position ,
:postgis_proj_version ,
:power ,
:quarter ,
:radians ,
:randomize ,
:rdf_now_impl ,
:regexp_instr ,
:regexp_like ,
:regexp_match ,
:regexp_parse ,
:regexp_replace ,
:regexp_substr ,
:repeat ,
:replace ,
:right ,
:rnd ,
:rtrim ,
:search_excerpt ,
:second ,
:serialize ,
:sign ,
:sin ,
:space ,
:split_and_decode ,
:sprintf ,
:sprintf_inverse ,
:sprintf_iri ,
:sprintf_iri_or_null ,
:sprintf_or_null ,
:sqrt ,
:st_astext ,
:st_contains ,
:st_distance ,
:st_ewkt_read ,
:st_geomfromtext ,
:st_get_bounding_box ,
:st_get_bounding_box_n ,
:st_intersects ,
:st_linestring ,
:st_may_intersect ,
:st_point ,
:st_transform_by_custom_projection ,
:st_within ,
:st_x ,
:st_y ,
:starts_with ,
:strcasestr ,
:strchr ,
:strcontains ,
:string_output ,
:string_output_flush ,
:string_output_gz_compress ,
:string_output_string ,
:string_to_file ,
:stringdate ,
:stringtime ,
:strrchr ,
:strstr ,
:subseq ,
:substring ,
:sysutcdatetime ,
:tan ,
:timezone ,
:tmp_file_name ,
:trim ,
:ucase ,
:upper ,
:vector ,
:vector_concat ,
:week .
:concat
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "concat" ;
rdfs:comment """sparql select bif:concat(str(?s),(str(?o)) from where {?s ?p ?o} limit 10"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_concat.html .
:concatenate
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "concatenate" ;
rdfs:comment """select bif:concatenate(str(?s),(str(?o)) from where {?s ?p ?o} limit 10"""@en ;
dcterms:description """Concatenate is an alias of concat."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_concatenate.html .
:position
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "position" ;
rdfs:comment """select bif:position('b',(str(?o)) from where {?s ?p ?o} limit 10"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_position.html .
:vector
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "vector" ;
rdfs:comment """select bif:vector('1',(str(?o), '34') from where {?s ?p ?o} limit 10"""@en ;
dcterms:description """vector returns a new vector (one-dimensional array) constructed from the given arguments."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_vector.html .
:vector_concat
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "vector_concat" ;
rdfs:comment """Usage: bif:vector_concat."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_vector_concat.html .
:curdate
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "curdate" ;
rdfs:comment """Usage: bif:curdate."""@en ;
dcterms:description """Returns the current date or time as a date, time or datetime, respectively"""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_curdate.html .
:curdatetime
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "curdatetime" ;
rdfs:comment """Usage: bif:curdatetime."""@en ;
dcterms:description """Returns the current date or time as a date, time or datetime, respectively"""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_curdatetime.html .
:adjust_timezone
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "adjust_timezone" ;
rdfs:comment """Usage: bif:adjust_timezone."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_adjust_timezone.html .
:curdatetimeoffset
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "curdatetimeoffset" ;
rdfs:comment """Usage: bif:curdatetimeoffset."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_curdatetimeoffset.html .
:current_timestamp
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "current_timestamp" ;
rdfs:comment """Usage: bif:current_timestamp."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_current_timestamp.html .
:curutcdatetime
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "curutcdatetime" ;
rdfs:comment """Usage: bif:curutcdatetime."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_curutcdatetime.html .
:dateadd
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dateadd" ;
rdfs:comment """SELECT ?wiki,
?dbp,
bif:datediff('second', xsd:DateTime(str(?extracted)) , now()) AS ?secondsAgo
WHERE
{
?wiki foaf:primaryTopic ?dbp .
?dbp ?extracted .
FILTER ( xsd:DateTime(str(?extracted)) > bif:dateadd('minute', -10, now()))
}
ORDER BY DESC (xsd:DateTime(str(?extracted)))
LIMIT 30"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dateadd.html .
:datediff
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "datediff" ;
rdfs:comment """SELECT ?wiki, ?dbp, bif:datediff('second', xsd:DateTime(?extracted) , now()) AS ?secondsAgo FROM WHERE { ?wiki foaf:primaryTopic ?dbp . ?dbp dcterms:modified ?extracted . FILTER ( ?extracted > bif:dateadd('minute', -10, now())) } ORDER BY DESC (?extracted) LIMIT 30"""@en ;
dcterms:description """datediff subtracts date1 from date2 and returns the difference as an integer in the specified units."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_datediff.html .
:datestring
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "datestring" ;
rdfs:comment """Usage: bif:datestring."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_datestring.html .
:datestring_gmt
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "datestring_gmt" ;
rdfs:comment """Usage: bif:datestring_gmt."""@en ;
dcterms:description """Converts the local datetime to GMT and returns its external representation as a string."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_datestring_gmt.html .
:dayname
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dayname" ;
rdfs:comment """Usage: bif:dayname."""@en ;
dcterms:description """Decomposes a datetime to name of day. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dayname.html .
:dayofmonth
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dayofmonth" ;
rdfs:comment """Usage: bif:dayofmonth."""@en ;
dcterms:description """Decomposes a datetime to day of month. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dayofmonth.html .
:dayofweek
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dayofweek" ;
rdfs:comment """Usage: bif:dayofweek."""@en ;
dcterms:description """Decomposes a datetime to day of week. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dayofweek.html .
:dayofyear
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dayofyear" ;
rdfs:comment """Usage: bif:dayofyear."""@en ;
dcterms:description """Decomposes a datetime to day of year. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dayofyear.html .
:dt_set_tz
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "dt_set_tz" ;
rdfs:comment """Usage: bif:dt_set_tz."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_dt_set_tz.html .
:forget_timezone
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "forget_timezone" ;
rdfs:comment """Usage: bif:forget_timezone."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_forget_timezone.html .
:get_timestamp
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "get_timestamp" ;
rdfs:comment """Usage: bif:get_timestamp."""@en ;
dcterms:description """get_timestamp is merely an alias for now and is provided for backward compatibility."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_get_timestamp.html .
:getdate
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "getdate" ;
rdfs:comment """Usage: bif:getdate."""@en ;
dcterms:description """Returns the timestamp associated with current transaction. This is an alias of now(). """@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_getdate.html .
:hour
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "hour" ;
rdfs:comment """Usage: bif:hour."""@en ;
dcterms:description """Decomposes a datetime to hour. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_hour.html .
:is_timezoneless
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "is_timezoneless" ;
rdfs:comment """Usage: bif:is_timezoneless."""@en ;
dcterms:description """The function returns 1 for timezoneless arguments, zero for timezoned."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_is_timezoneless.html .
:minute
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "minute" ;
rdfs:comment """Usage: bif:minute."""@en ;
dcterms:description """Decomposes a datetime to minute. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_minute.html .
:month
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "month" ;
rdfs:comment """Usage: bif:month."""@en ;
dcterms:description """Decomposes a datetime to month number, starting at 1 for January. Can be used on timestamps, datetimes, dates and times."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_month.html .
:monthname
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "monthname" ;
rdfs:comment """Usage: bif:monthname."""@en ;
dcterms:description """Monthname takes a datetime and returns a string containing name of the month represented by the datetime"""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_monthname.html .
:msec_time
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "msec_time" ;
rdfs:comment """Usage: bif:msec_time."""@en ;
dcterms:description """Returns the number of milliseconds since system epoch. It is useful for benchmarking purposes, timing operations, etc."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_msec_time.html .
:now
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "now" ;
rdfs:comment """sparql select ?offer from where { ?offer a gr:Offering ; gr:validFrom ?validfrom ; gr:validThrough ?validto . FILTER(?validfrom <= bif:now() and ?validto >= bif:now()) . } """@en ;
dcterms:description """Returns the timestamp associated with current transaction as a DATETIME. This value is guaranteed to differ from the timestamp of any other transaction."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_now.html .
:quarter
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "quarter" ;
rdfs:comment """Usage: bif:quarter."""@en ;
dcterms:description """quarter takes a datetime and returns an integer containing a number representing the quarter of year of the datetime."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_quarter.html .
:rdf_now_impl
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "rdf_now_impl" ;
rdfs:comment """Usage: bif:rdf_now_impl."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_rdf_now_impl.html .
:second
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "second" ;
rdfs:comment """Usage: bif:second."""@en ;
dcterms:description """second takes a datetime and returns an integer containing a number representing the second of the datetime."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_second.html .
:stringdate
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "stringdate" ;
rdfs:comment """
PREFIX dst:
PREFIX dc:
SELECT (bif:year( bif:stringdate(?sdate)) AS ?syear) (bif:sum( bif:number(?dist)) AS ?distance)
FROM
WHERE
{
?row dc:date ?sdate .
?row dst:distance ?dist
}
GROUP BY (bif:year(bif:stringdate(?sdate)))
ORDER BY ASC(bif:year(bif:stringdate(?sdate)));"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_stringdate.html .
:stringtime
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "stringtime" ;
rdfs:comment """Usage: bif:stringtime."""@en ;
dcterms:description """Converts the argument to a time."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_stringtime.html .
:sysutcdatetime
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "sysutcdatetime" ;
rdfs:comment """Usage: bif:sysutcdatetime."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_sysutcdatetime.html .
:timezone
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "timezone" ;
rdfs:comment """Usage: bif:timezone."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_timezone.html .
:week
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "week" ;
rdfs:comment """Usage: bif:week."""@en ;
dcterms:description """week takes a datetime and returns an integer containing a number representing the week of year of the datetime."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_week.html .
:contains
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "contains" ;
rdfs:comment """SELECT * FROM WHERE { ?s ?p ?o . ?o bif:contains "world" };"""@en ;
dcterms:description """ 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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_contains.html .
:GeometryType
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "GeometryType" ;
rdfs:comment """
SELECT ?s,
bif:GeometryType(?o)
FROM
WHERE
{
?s ?p ?o
}
ORDER BY ASC(str(?s))"""@en ;
dcterms:description """GeometryType function returns EWKT type name of a given shape."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_GeometryType.html .
:ST_Affine
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_Affine" ;
rdfs:comment """
select st_affine (st_ewkt_read ('POLYGON((1 3,2 4,1 5,0 4,1 3),\n
(1 3.5,1.5 4,1 4.5,0.5 4,1 3.5))'),\n
30, 3, 1, 0.3, 0.001, 0.002)\n """@en ;
dcterms:description """performs standard 2d affine transformation with matrix"""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_Affine.html .
:ST_ExteriorRing
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_ExteriorRing" ;
rdfs:comment """Usage: bif:ST_ExteriorRing."""@en ;
dcterms:description """Returns an external (the very first) ring of a polygon. """@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_ExteriorRing.html .
:ST_GeometryN
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_GeometryN" ;
rdfs:comment """Usage: bif:ST_GeometryN."""@en ;
dcterms:description """Given a 1-based index of a member of a MULTI or COLLECTION shape, returns the member"""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_GeometryN.html .
:ST_InteriorRingN
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_InteriorRingN" ;
rdfs:comment """Usage: bif:ST_InteriorRingN."""@en ;
dcterms: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. """@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_InteriorRingN.html .
:ST_M
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_M" ;
rdfs:comment """Usage: bif:ST_M."""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_M.html .
:ST_MMax
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_MMax" ;
rdfs:comment """
SELECT ?s, bif:st_mmax(?o) as ?mmax
FROM
WHERE { ?s ?p ?o }"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_MMax.html .
:ST_MMin
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_MMin" ;
rdfs:comment """Usage: bif:ST_MMin. SPARQL
SELECT ?s, bif:st_mmin(?o) as ?mmin
FROM
WHERE { ?s ?p ?o };"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_MMin.html .
:ST_NumGeometries
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_NumGeometries" ;
rdfs:comment """
SELECT ?s, bif:GeometryType(?o),
bif:ST_NumGeometries(?o)
FROM
WHERE
{
?s ?p ?o
}
ORDER BY ASC(str(?s))"""@en ;
dcterms:description """Returns number of members of a MULTI or COLLECTION shape, 1 for other sorts of shapes. """@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_NumGeometries.html .
:ST_NumInteriorRings
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_NumInteriorRings" ;
rdfs:comment """
SELECT ?s bif:ST_NumInteriorRings (?o)
FROM
WHERE { ?s ?p ?o }
ORDER BY ASC(str(?s))"""@en ;
dcterms:description """Returns number of interior rings of the given polygon, NULL if shape is not a polygon. """@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_NumInteriorRings.html .
:ST_SRID
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_SRID" ;
rdfs:comment """
SELECT (bif:ST_SRID (?geo))
WHERE
{
?m geo:geometry ?geo .
}
LIMIT 10;"""@en ;
dcterms:description """Returns the SRID of a geometry."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_SRID.html .
:ST_SetSRID
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_SetSRID" ;
rdfs:comment """Usage: bif:ST_SetSRID."""@en ;
dcterms:description """The geometry given as argument is modified to have the specified SRID and the modified geometry is returned."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_SetSRID.html .
:ST_TransScale
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_TransScale" ;
rdfs:comment """
SELECT ?s, bif:ST_TransScale(?o, 0.1, 0.2, 0.1, 0.1)
FROM
WHERE
{
?s ?p ?o
}
ORDER BY ASC(str(?s))"""@en ;
dcterms: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."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_TransScale.html .
####here
:ST_Transform
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_Transform" ;
rdfs:comment """Usage: bif:ST_Transform."""@en ;
dcterms:description """Transforms the given shape from its current spatial reference system to one specified by dest_srid."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_Transform.html .
:ST_Translate
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_Translate" ;
rdfs:comment """Usage: bif:ST_Translate."""@en ;
dcterms:description """Returns a copy of a shape with all coordinates shifted by the provided dX, dY and dZ."""@en ;
foaf:maker ;
cc:license ;
cc:attributionName "OpenLink Software" ;
cc:attributionURL ;
is schema:about of doc:fn_ST_Translate.html .
:ST_XMax
a sioc:Item , ;
wdrs:describedby source: ;
rdfs:label "ST_XMax" ;
rdfs:comment """SELECT ?s,
bif:st_xmax(?o) as ?xmax
FROM