ST_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom...
ST_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom...
ST_AsBinary
示例 with g as(select unnest(st_asgrid(ST_geomfromtext('POINT(116.31522216796875 39.910277777777778)',4490),15))as grid)select ST_asBinary(grid)from g;st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('...
ST_3DIntersects
st_3dintersects-t SELECT ST_3DIntersects(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom...
ST_{X|Y|Z|T}Min
获取BoxNDF类型中指定维度的最小值。语法 float8 ST_XMin...st_xmin-0 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_AsBinary
示例 with g as(select unnest(st_asgrid(ST_geomfromtext('POINT(116.31522216796875 39.910277777777778)',4490),15))as grid)select ST_asBinary(grid)from g;st_asbinary-\x0102000f74271236 select st_asbinary(unnest(st_as3dgrid('...
ST_GeometryType
如 ST_Linestring、ST_Polygon、ST_MultiPolygon 等。此函数与GeometryType（geometry）不同，它不显示Geometry对象是否有M值。该函数支持3D对象，并且不会删除Z坐标。该函数支持 Polyhedral Surface类型几何对象。示例 默认调用：SELECT ...
LIST FUNCTIONS
numpy-1.19.4-cp37-cp37m-manylinux1_x86_64.zip ST_Aggr_ConvexHull ALIYUN$@aliyun.com 2021-03-18 17:06:29 com.esri.hadoop.hive.ST_Aggr_ConvexHull esri-geometry-api.jar,spatial-sdk-hive.jar ST_Aggr_Intersection ALIYUN$@aliyun....
ST_3DContains
st_3dcontains-f SELECT ST_3DContains(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}...
ST_3DContains
st_3dcontains-f SELECT ST_3DContains(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}...
ST_GeometryType
如 ST_Linestring、ST_Polygon、ST_MultiPolygon 等。此函数与GeometryType（geometry）不同，它不显示Geometry对象是否有M值。该函数支持3D对象，并且不会删除Z坐标。该函数支持 Polyhedral Surface类型几何对象。示例 默认调用：SELECT ...
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_3DContains
st_3dcontains-f SELECT ST_3DContains(ST_GridFromText('GZ00262064'),st_meshfromtext('{"version":1,"srid":4490,"root":0,"meshgeoms":["MESHGEOM(PATCH(POLYGON Z((0 0 0,1 0 0,1 1 0,0 1 0,0 0 0))))"],"primitives":[{"meshgeom":0}...
ST_CoordDim
语法 integer ST_CoordDim(geometry geomA);参数 参数名称 描述 geomA 目标Geometry对象。描述 这是 ST_NDims 该函数支持Circular Strings、Curves、Polyhedral surfaces、Triangles、Triangulated Irregular Network Surfaces(TIN)和3D...
ST_GeometryType
如 ST_Linestring、ST_Polygon、ST_MultiPolygon 等。此函数与GeometryType（geometry）不同，它不显示Geometry对象是否有M值。该函数支持3D对象，并且不会删除Z坐标。该函数支持 Polyhedral Surface类型几何对象。示例 默认调用：SELECT ...
ST_{X|Y|Z|T}Min
获取BoxNDF类型中指定维度的最小值。语法 float8 ST_XMin...st_xmin-0 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_{X|Y|Z|T}Min
获取BoxNDF类型中指定维度的最小值。语法 float8 ST_XMin...st_xmin-0 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_CoordDim
语法 integer ST_CoordDim(geometry geomA);参数 参数名称 描述 geomA 目标Geometry对象。描述 这是 ST_NDims 该函数支持Circular Strings、Curves、Polyhedral surfaces、Triangles、Triangulated Irregular Network Surfaces(TIN)和3D...
ST_CoordDim
语法 integer ST_CoordDim(geometry geomA);参数 参数名称 描述 geomA 目标Geometry对象。描述 这是 ST_NDims 该函数支持Circular Strings、Curves、Polyhedral surfaces、Triangles、Triangulated Irregular Network Surfaces(TIN)和3D...
ST_Force3DM
将Geometry对象强制转换为XYM模式。语法 geometry ST_Force3DM(geometry geomA);...st_asewkt-POINTM(1 2 0)(1 row)覆盖原有Z值：SELECT ST_AsEWKT(ST_Force3DM(ST_GeomFromEWKT('POINT(1 2 3)')));st_asewkt-POINTM(1 2 0)(1 row)
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmax(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmax-NaN select ST_tmax(ST_MakeBox2d(0,0,20,20));st_tmax-infinity
ST_Force3DM
将Geometry对象强制转换为XYM模式。语法 geometry ST_Force3DM(geometry geomA);...st_asewkt-POINTM(1 2 0)(1 row)覆盖原有Z值：SELECT ST_AsEWKT(ST_Force3DM(ST_GeomFromEWKT('POINT(1 2 3)')));st_asewkt-POINTM(1 2 0)(1 row)
ST_{X|Y|Z|T}Max
获取BoxNDF类型中指定维度的最大值。...st_tmax-2020-01-01 00:00:00 select ST_zmin(ST_MakeBox2dt(0,0,'2000-01-01':timestamp,20,20,'2020-01-01':timestamp));st_zmin-NaN select ST_tmin(ST_MakeBox2d(0,0,20,20));st_tmin-infinity
ST_AsText
语法 text ST_AsText(geomgrid grid integer precision default-1,bool separated default false,text standard default 'GGER')text[]ST_AsText(geomgrid[]grid integer precision default-1,bool separated default false,text standard ...
ST_GeogFromText
返回与给定的标准WKT或扩展WKT字符串相对应的Geography对象。语法 geography ST_GeogFromText(text eWKT);...st_srid-4326(1 row)指定SRID：SELECT ST_SRID(ST_GeogFromText('SRID=4256;POINT(116 40)'));st_srid-4256(1 row)
ST_Generalize
示例 SELECT ST_AsText(ST_Generalize(ST_GridFromText('GZ0026206440'),5));st_astext-GZ00262 SELECT ST_Generalize(ST_As3DGrid('srid=4490;LINESTRING Z(116 39 2000,116.012 39.009 3000)':geometry,10),8);st_generalize-{...
ST_AsText
语法 text ST_AsText(geomgrid grid integer precision default-1,bool separated default false,text standard default 'GGER')text[]ST_AsText(geomgrid[]grid integer precision default-1,bool separated default false,text standard ...
ST_AsText
语法 text ST_AsText(geomgrid grid integer precision default-1,bool separated default false,text standard default 'GGER')text[]ST_AsText(geomgrid[]grid integer precision default-1,bool separated default false,text standard ...
ST_GeogFromText
返回与给定的标准WKT或扩展WKT字符串相对应的Geography对象。语法 geography ST_GeogFromText(text eWKT);...st_srid-4326(1 row)指定SRID：SELECT ST_SRID(ST_GeogFromText('SRID=4256;POINT(116 40)'));st_srid-4256(1 row)
ST_Generalize
示例 SELECT ST_AsText(ST_Generalize(ST_GridFromText('GZ0026206440'),5));st_astext-GZ00262 SELECT ST_Generalize(ST_As3DGrid('srid=4490;LINESTRING Z(116 39 2000,116.012 39.009 3000)':geometry,10),8);st_generalize-{...
ST_Percentile
获取影像的波段百分比值。语法 float8 ST_Percentile(raster raster_obj,integer ...29.7 ST_Quantile 的功能也可以使用ST_Percentile实现：SELECT st_percentile(rast_obj,0,25),st_percentile(rast_obj,0,50)FROM raster_table WHERE id=1;
ST_Volume/ST_3DVolume
语法 float8 ST_Volume(meshgeom geom);float8 ST_Volume(sfmesh sfmeshObject);参数 参数名称 描述 geom meshgeom对象 sfmeshObject sfmesh对象。描述 计算三维闭合模型的体积值。point、linestring、polygon的体积值为0。如果 geom 参数...
ST_Percentile
获取影像的波段百分比值。语法 float8 ST_Percentile(raster raster_obj,integer ...29.7 ST_Quantile 的功能也可以使用ST_Percentile实现：SELECT st_percentile(rast_obj,0,25),st_percentile(rast_obj,0,50)FROM raster_table WHERE id=1;
ST_Generalize
示例 SELECT ST_AsText(ST_Generalize(ST_GridFromText('GZ0026206440'),5));st_astext-GZ00262 SELECT ST_Generalize(ST_As3DGrid('srid=4490;LINESTRING Z(116 39 2000,116.012 39.009 3000)':geometry,10),8);st_generalize-{...
地理空间函数
示例：select ST_asText(ST_Centroid(ST_GeometryFromText('MULTIPOLYGON(((0 0,4 0,4 4,0 4,0 0),(1 1,2 1,2 2,1 2,1 1)),((-1-1,-1-2,-2-2,-2-1,-1-1)))')));col0|+-+|POINT(1.8125 1.8125)|+-+select ST_asText(ST_Centroid(ST_...
ST_GeogFromText
返回与给定的标准WKT或扩展WKT字符串相对应的Geography对象。语法 geography ST_GeogFromText(text eWKT);...st_srid-4326(1 row)指定SRID：SELECT ST_SRID(ST_GeogFromText('SRID=4256;POINT(116 40)'));st_srid-4256(1 row)
ST_AsEWKT
语法 text ST_AsEWKT(geometry g1);text ST_AsEWKT(geography g1);参数 参数名称 描述 g1 目标Geometry/Geography对象。描述 想获得不包含SRID的标准WKT对象，请调用 ST_AsText 函数。WKT格式不能保持精度，因此为了防止浮点精度被截断，请...
ST_HasZ
判断地理网格是否包含Z（高）维度。语法 bool ST_HasZ(geomgrid gridcode);参数 参数名称 描述 gridcode 地理网格对象。示例 SELECT ST_HasZ(ST_GridFromText('GZ0026206440'));st_hasz-t
ST_AsText
语法 text ST_AsText(geomgrid grid,integer precision,text standard default 'GGER')text[]ST_AsText(geomgrid[]grid,integer precision,text standard default 'GGER')参数 参数名称 描述 grid 需要输出的网格对象。precision 精度级别...
- 产品推荐
- 这些文档可能帮助您