Name

ST_ZMin — returns minimum z boundaries of a bounding box around a shape.

Synopsis

ST_ZMin ( in shape any );
 

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.

Parameters

shape

A bounding box.

Return Types

Returns double precision.

Examples

Example 24.683. Simple Use

DB.DBA.TTLP ('
<point2d>           <shape> "POINT(1 3)"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<point4d>           <shape> "POINTZM(0 1 2 3)"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<box1>              <shape> "BOX(0 0, 2 3)"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<linestring>        <shape> "LINESTRING(10 21, 12 23, 10 25)"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<polygon1>          <shape> "POLYGON((1 3,2 4,1 5,0 4,1 3))"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<polygon2>          <shape> "POLYGON((1.5 3.5,2.5 4.5,1.5 5.5,0.5 4.5,1.5 3.5))"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<polygon3>          <shape> "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))"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<multipolygon>      <shape> "MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2)))"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
<collection>        <shape> "GEOMETRYCOLLECTION(POINT(0 0),MULTILINESTRING((1 5,0 1,4 0,5 4),(1 5,1 0,4 0,4 5)),MULTIPOLYGON(((1 3,2 4,1 5,0 4,1 3)),((1 2,2 1,1 0,0 1,1 2))))"^^<http://www.openlinksw.com/schemas/virtrdf#Geometry> .
', 'http://geo-api-demo/', 'http://geo-api-demo/', 0)

--
SQL>
SPARQL
SELECT ?s,
       bif:st_zmin(?o) as ?zmin
FROM <http://geo-api-demo/>
WHERE { ?s ?p ?o };
s                                   zmin
ANY                                 DOUBLE PRECISION
_______________________________________________________________________________
 http://geo-api-demo/box1                 1e+38
 http://geo-api-demo/collection     1e+38
 http://geo-api-demo/linestring     1e+38
 http://geo-api-demo/multipolygon         1e+38
 http://geo-api-demo/point2d          1e+38
 http://geo-api-demo/point4d          2
 http://geo-api-demo/polygon1         1e+38
 http://geo-api-demo/polygon2         1e+38