Grouped geometry envelope（分组几何包络线）¶
Supported in: Batch, Faster
Returns the envelope of all valid geometries in the given column. Invalid geometries are treated as null and ignored.
Expression categories: Geospatial
Declared arguments¶
- Expression: Column of geometries to compute the envelope of.
Expression\
Output type: Geometry
Examples¶
Example 1: Base case¶
Argument values:
- Expression:
geometry
Given input table:
| geometry |
|---|
| {"type":"LineString","coordinates":[[1,0],[0,8.4]]} |
| {"type":"Point","coordinates":[125.6, -92.3]} |
| {"type":"Polygon","coordinates":[[[0,0],[1,6.3],[-6,1],[0,0]]]} |
Outputs: {"type":"Polygon","coordinates":[[[-6.0,-92.3],[-6.0,8.4],[125.6,8.4],[125.6,-92.3],[-6.0,-92.3]]]}
Example 2: Null case¶
Argument values:
- Expression:
geometry
Given input table:
| geometry |
|---|
| null |
Outputs: null
Example 3: Edge case¶
Argument values:
- Expression:
geometry
Given input table:
| geometry |
|---|
| Invalid GeoJSON |
| {"type":"LineString","coordinates":[[2,0],[0,4.8]]} |
Outputs: {"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,4.8],[2.0,4.8],[2.0,0.0],[0.0,0.0]]]}
中文翻译¶
分组几何包络线¶
支持：Batch（批处理）、Faster（快速处理）
返回指定列中所有有效几何图形的包络线。无效几何图形视为空值并忽略。
表达式类别： 地理空间（Geospatial）
声明的参数¶
- 表达式（Expression）： 要计算包络线的几何图形列。
表达式\
输出类型： Geometry
示例¶
示例1：基础情况¶
参数值：
- 表达式：
geometry
输入表：
| geometry |
|---|
| {"type":"LineString","coordinates":[[1,0],[0,8.4]]} |
| {"type":"Point","coordinates":[125.6, -92.3]} |
| {"type":"Polygon","coordinates":[[[0,0],[1,6.3],[-6,1],[0,0]]]} |
输出： {"type":"Polygon","coordinates":[[[-6.0,-92.3],[-6.0,8.4],[125.6,8.4],[125.6,-92.3],[-6.0,-92.3]]]}
示例2：空值情况¶
参数值：
- 表达式：
geometry
输入表：
| geometry |
|---|
| null |
输出： null
示例3：边界情况¶
参数值：
- 表达式：
geometry
输入表：
| geometry |
|---|
| 无效的GeoJSON |
| {"type":"LineString","coordinates":[[2,0],[0,4.8]]} |
输出： {"type":"Polygon","coordinates":[[[0.0,0.0],[0.0,4.8],[2.0,4.8],[2.0,0.0],[0.0,0.0]]]}