This is an automated email from the ASF dual-hosted git repository.
jiayu pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/sedona.git
The following commit(s) were added to refs/heads/master by this push:
new e386928a [DOCS] Add example outputs to all Sedona functions - 9 (#927)
e386928a is described below
commit e386928a2b0489f798c29fff47b47e3043221a5b
Author: Furqaanahmed Khan <[email protected]>
AuthorDate: Thu Jul 27 15:58:10 2023 -0400
[DOCS] Add example outputs to all Sedona functions - 9 (#927)
---
docs/api/flink/Aggregator.md | 30 ++++++++++++++++++++++++------
docs/api/sql/AggregateFunction.md | 30 ++++++++++++++++++++++++------
2 files changed, 48 insertions(+), 12 deletions(-)
diff --git a/docs/api/flink/Aggregator.md b/docs/api/flink/Aggregator.md
index 57e0c7e8..b3eae5d0 100644
--- a/docs/api/flink/Aggregator.md
+++ b/docs/api/flink/Aggregator.md
@@ -7,9 +7,15 @@ Format: `ST_Envelope_Aggr (A:geometryColumn)`
Since: `v1.3.0`
SQL example:
+
```sql
-SELECT ST_Envelope_Aggr(pointdf.arealandmark)
-FROM pointdf
+SELECT ST_Envelope_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1
103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+POLYGON ((1.1 101.1, 1.1 120.1, 20.1 120.1, 20.1 101.1, 1.1 101.1))
```
## ST_Intersection_Aggr
@@ -21,9 +27,15 @@ Format: `ST_Intersection_Aggr (A:geometryColumn)`
Since: `v1.5.0`
SQL example:
+
```sql
-SELECT ST_Intersection_Aggr(polygondf.polygonshape)
-FROM polygondf
+SELECT ST_Intersection_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1
102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1
109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+MULTIPOINT ((1.1 101.1), (2.1 102.1), (3.1 103.1), (4.1 104.1), (5.1 105.1),
(6.1 106.1), (7.1 107.1), (8.1 108.1), (9.1 109.1), (10.1 110.1))
```
## ST_Union_Aggr
@@ -35,7 +47,13 @@ Format: `ST_Union_Aggr (A:geometryColumn)`
Since: `v1.3.0`
SQL example:
+
```sql
-SELECT ST_Union_Aggr(polygondf.polygonshape)
-FROM polygondf
+SELECT ST_Union_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1
103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+MULTIPOINT ((1.1 101.1), (2.1 102.1), (3.1 103.1), (4.1 104.1), (5.1 105.1),
(6.1 106.1), (7.1 107.1), (8.1 108.1), (9.1 109.1), (10.1 110.1))
```
\ No newline at end of file
diff --git a/docs/api/sql/AggregateFunction.md
b/docs/api/sql/AggregateFunction.md
index e4e636e4..549e188a 100644
--- a/docs/api/sql/AggregateFunction.md
+++ b/docs/api/sql/AggregateFunction.md
@@ -7,9 +7,15 @@ Format: `ST_Envelope_Aggr (A:geometryColumn)`
Since: `v1.0.0`
Spark SQL example:
+
```sql
-SELECT ST_Envelope_Aggr(pointdf.arealandmark)
-FROM pointdf
+SELECT ST_Envelope_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1
103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+POLYGON ((1.1 101.1, 1.1 120.1, 20.1 120.1, 20.1 101.1, 1.1 101.1))
```
## ST_Intersection_Aggr
@@ -21,9 +27,15 @@ Format: `ST_Intersection_Aggr (A:geometryColumn)`
Since: `v1.0.0`
Spark SQL example:
+
```sql
-SELECT ST_Intersection_Aggr(polygondf.polygonshape)
-FROM polygondf
+SELECT ST_Intersection_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1
102.1,3.1 103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1
109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+MULTIPOINT ((1.1 101.1), (2.1 102.1), (3.1 103.1), (4.1 104.1), (5.1 105.1),
(6.1 106.1), (7.1 107.1), (8.1 108.1), (9.1 109.1), (10.1 110.1))
```
## ST_Union_Aggr
@@ -35,7 +47,13 @@ Format: `ST_Union_Aggr (A:geometryColumn)`
Since: `v1.0.0`
Spark SQL example:
+
```sql
-SELECT ST_Union_Aggr(polygondf.polygonshape)
-FROM polygondf
+SELECT ST_Union_Aggr(ST_GeomFromText('MULTIPOINT(1.1 101.1,2.1 102.1,3.1
103.1,4.1 104.1,5.1 105.1,6.1 106.1,7.1 107.1,8.1 108.1,9.1 109.1,10.1 110.1)'))
+```
+
+Output:
+
+```
+MULTIPOINT ((1.1 101.1), (2.1 102.1), (3.1 103.1), (4.1 104.1), (5.1 105.1),
(6.1 106.1), (7.1 107.1), (8.1 108.1), (9.1 109.1), (10.1 110.1))
```
\ No newline at end of file
