SELECT id FROM gps_data WHERE ST_DWithinSphere(ST_GeomFromText('POINT(0 0)'),g,100);如果查询语句为低效查询语句，在查询语句中增加/*+_l_allow_filtering_*/，表示跳过该检查，强制执行低效查询操作。SELECT/*+_l_allow_filtering_*/...
语法 pcpatch ST_transform(pcpatch pc,integer pcid,float8 def default 0.0);参数 参数名称 描述 pc pcpatch对象。pcid 新的schema ID值，来自表pointcloud_formats。def 指定值，针对在新的schema中存在而在旧的schema中不存在的属性维...
语法 pcpatch ST_transform(pcpatch pc,integer pcid,float8 def default 0.0);参数 参数名称 描述 pc pcpatch对象。pcid 新的schema ID值，来自表pointcloud_formats。def 指定值，针对在新的schema中存在而在旧的schema中不存在的属性维...
语法 pcpatch ST_transform(pcpatch pc,integer pcid,float8 def default 0.0);参数 参数名称 描述 pc pcpatch对象。pcid 新的schema ID值，来自表pointcloud_formats。def 指定值，针对在新的schema中存在而在旧的schema中不存在的属性维...
SELECT ST_AsGLB(ST_ZupToYup(ST_3DRemoveDuplicateVertex(ST_MergeGeomByMaterial(ST_Triangulate(ST_Translate(ST_Transform(ST_Flatten(ST_Collect(ST_AsMeshgeom(array(SELECT grid FROM building_grid WHERE grid_type='border')):...
SELECT ST_AsGLB(ST_ZupToYup(ST_3DRemoveDuplicateVertex(ST_MergeGeomByMaterial(ST_Triangulate(ST_Translate(ST_Transform(ST_Flatten(ST_Collect(ST_AsMeshgeom(array(SELECT grid FROM building_grid WHERE grid_type='border')):...
描述 ST_RotateX（geomA，rotRadians）是 ST_Affine（geomA，1，0，0，0，cos（rotRadians），-sin（rotRadians），0，sin（rotRadians），cos（rotRadians），0，0，0）的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces...
描述 ST_RotateX（geomA，rotRadians）是 ST_Affine（geomA，1，0，0，0，cos（rotRadians），-sin（rotRadians），0，sin（rotRadians），cos（rotRadians），0，0，0）的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces...
描述 ST_RotateX(geomA,rotRadians)是 ST_Affine(geomA,1,0,0,0,cos(rotRadians),-sin(rotRadians),0,sin(rotRadians),cos(rotRadians),0,0,0)的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces、Triangles、Triangulated ...
对于给定的LineString或MultiLineString，返回其二维空间内的长度。语法 float ST_Length(geometry a2dlinestring);...示例 默认调用：SELECT ST_Length('LINESTRING(0 0,1 1)':geometry);st_length-1.4142135623731(1 row)
对于给定的LineString或MultiLineString，返回其二维空间内的长度。语法 float ST_Length(geometry a2dlinestring);...示例 默认调用：SELECT ST_Length('LINESTRING(0 0,1 1)':geometry);st_length-1.4142135623731(1 row)
对于给定的LineString或MultiLineString，返回其二维空间内的长度。语法 float ST_Length(geometry a2dlinestring);...示例 默认调用：SELECT ST_Length('LINESTRING(0 0,1 1)':geometry);st_length-1.4142135623731(1 row)
返回结果：+-+|ST_YMin(ST_GeomFromText('MULTIPOINT(1 2,2 4,3 6,4 8)'))|+-+|2.0|ST_Distance ST_Distance(g1,g2)命令说明：返回g1、g2之间的直线距离。返回值类型：DOUBLE。示例：SELECT ST_Distance(ST_Point(1,1),ST_Point(2,2));返回...
描述 ST_RotateY（geomA，rotRadians）是 ST_Affine（geomA，cos（rotRadians），0，sin（rotRadians），0，1，1，-sin（rotRadians），0，cos（rotRadians），0，0，0）的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces...
描述 ST_RotateY（geomA，rotRadians）是 ST_Affine（geomA，cos（rotRadians），0，sin（rotRadians），0，1，1，-sin（rotRadians），0，cos（rotRadians），0，0，0）的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces...
描述 ST_RotateY(geomA,rotRadians)是 ST_Affine(geomA,cos(rotRadians),0,sin(rotRadians),0,1,1,-sin(rotRadians),0,cos(rotRadians),0,0,0)的简写。该函数支持Circular Strings、Curves、Polyhedral surfaces、Triangles、Triangulated ...
ST_2dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_3dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_2dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50)),ST_3dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS...
ST_2dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_3dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_2dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50)),ST_3dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS...
ST_2dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_3dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_2dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50)),ST_3dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS...
ST_2dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_3dtContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(49)),ST_2dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS(50)),ST_3dContains(a,b,ST_PGEpochToTS(0),ST_PGEpochToTS...
返回结果：+-+|area|+-+|0.0|+-+ST_Distance 返回两个Geometry对象在二维平面上的欧氏距离，单位为degree。语法 BigDecimal ST_Distance(geometry geomA,geometry geomB)参数说明 参数 描述 geomA 指定的第一个Geometry对象。geomB 指定的...
返回结果：+-+|area|+-+|0.0|+-+ST_Distance 返回两个Geometry对象在二维平面上的欧氏距离，单位为degree。语法 double ST_Distance(geometry geomA,geometry geomB)参数说明 参数 描述 geomA 指定的第一个Geometry对象。geomB 指定的第二...
and-1 is the last point.The ST_SetPoint function is useful in triggers when you trying to maintain the relationship of joints when one vertex moves.This function supports 3D objects and does not delete z coordinates.......
and-1 is the last point.The ST_SetPoint function is useful in triggers when you trying to maintain the relationship of joints when one vertex moves.This function supports 3D objects and does not delete z coordinates.......
and-1 is the last point.The ST_SetPoint function is useful in triggers when you trying to maintain the relationship of joints when one vertex moves.This function supports 3D objects and does not delete z coordinates.......
由世界坐标及像元所在金字塔层级，根据逆仿射变换公式计算...st_world2rastcoord-(53205,32518)SELECT ST_AsText(ST_world2RastCoord(rast,0,ST_Rast2WorldCoord(rast,0,'POINT(511 0)':geometry)))FROM tb_world2rast;st_astext-POINT(511 0)
由世界坐标及像元所在金字塔层级，根据逆仿射变换公式计算...st_world2rastcoord-(53205,32518)SELECT ST_AsText(ST_world2RastCoord(rast,0,ST_Rast2WorldCoord(rast,0,'POINT(511 0)':geometry)))FROM tb_world2rast;st_astext-POINT(511 0)
由世界坐标及像元所在金字塔层级，根据逆仿射变换公式计算...st_world2rastcoord-(53205,32518)SELECT ST_AsText(ST_world2RastCoord(rast,0,ST_Rast2WorldCoord(rast,0,'POINT(511 0)':geometry)))FROM tb_world2rast;st_astext-POINT(511 0)
This function calculates the pixel coordinates of a ...st_world2rastcoord-(53205,32518)SELECT ST_AsText(ST_world2RastCoord(rast,0,ST_Rast2WorldCoord(rast,0,'POINT(511 0)':geometry)))FROM tb_world2rast;st_astext-POINT(511 0)
insert into agg_result values(0,ST_GeomFromText('POLYGON((0 0,0 0.5,0.5 0.5,0.5 0,0 0))'));insert into agg_result select i,st_buffer('POINT(0 0)',0.8+random()*0.1)from generate_series(1,100)as i;select st_astext(st_...
insert into agg_result values(0,ST_GeomFromText('POLYGON((0 0,0 0.5,0.5 0.5,0.5 0,0 0))'));insert into agg_result select i,st_buffer('POINT(0 0)',0.8+random()*0.1)from generate_series(1,100)as i;select st_astext(st_...
insert into agg_result values(0,ST_GeomFromText('POLYGON((0 0,0 0.5,0.5 0.5,0.5 0,0 0))'));insert into agg_result select i,st_buffer('POINT(0 0)',0.8+random()*0.1)from generate_series(1,100)as i;select st_astext(st_...