This is an automated email from the ASF dual-hosted git repository.
github-bot pushed a commit to branch asf-site
in repository https://gitbox.apache.org/repos/asf/sedona-db.git
The following commit(s) were added to refs/heads/asf-site by this push:
new 23b3472 Deployed 51450ef to latest-snapshot with MkDocs 1.6.1 and
mike 2.1.3
23b3472 is described below
commit 23b34723ed9e869c331ebc3a11372040a36d3064
Author: GitHub Actions <[email protected]>
AuthorDate: Wed Sep 24 06:32:11 2025 +0000
Deployed 51450ef to latest-snapshot with MkDocs 1.6.1 and mike 2.1.3
---
latest-snapshot/404.html | 39 ++-
latest-snapshot/contributors-guide/index.html | 89 +++---
latest-snapshot/crs-examples/index.html | 89 +++---
latest-snapshot/geopandas-interop/index.html | 39 ++-
latest-snapshot/index.html | 39 ++-
latest-snapshot/overture-examples/index.html | 39 ++-
latest-snapshot/programming-guide/index.html | 39 ++-
latest-snapshot/quickstart-python/index.html | 39 ++-
latest-snapshot/reference/python/index.html | 45 ++-
latest-snapshot/reference/sql-joins/index.html | 39 ++-
latest-snapshot/reference/sql/index.html | 39 ++-
latest-snapshot/search/search_index.json | 2 +-
latest-snapshot/sitemap.xml | 4 +
latest-snapshot/sitemap.xml.gz | Bin 314 -> 323 bytes
latest-snapshot/stylesheets/extra.css | 28 +-
.../working-with-parquet-files/index.html | 45 ++-
.../index.html | 324 +++++++++++++--------
17 files changed, 649 insertions(+), 289 deletions(-)
diff --git a/latest-snapshot/404.html b/latest-snapshot/404.html
index 0e39b05..2c3d9c4 100644
--- a/latest-snapshot/404.html
+++ b/latest-snapshot/404.html
@@ -873,12 +873,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/contributors-guide/" class="md-nav__link">
+ <a href="/sedonadb/latest/crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -896,12 +896,35 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/crs-examples/" class="md-nav__link">
+ <a href="/sedonadb/latest/working-with-sql-sedonadb/"
class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="/sedonadb/latest/contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -932,10 +955,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7" >
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8" >
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -948,8 +971,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/contributors-guide/index.html
b/latest-snapshot/contributors-guide/index.html
index 0713086..0b31092 100644
--- a/latest-snapshot/contributors-guide/index.html
+++ b/latest-snapshot/contributors-guide/index.html
@@ -10,10 +10,10 @@
<link rel="canonical"
href="https://sedona.apache.org/sedonadb/latest/contributors-guide/";>
- <link rel="prev" href="../working-with-parquet-files/">
+ <link rel="prev" href="../working-with-sql-sedonadb/">
- <link rel="next" href="../crs-examples/">
+ <link rel="next" href="../reference/python/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -896,6 +896,52 @@
+
+
+ <li class="md-nav__item">
+ <a href="../crs-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Joining Spatial Data with Different Coordinate Systems
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
@@ -1089,29 +1135,6 @@
- <li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1129,10 +1152,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1145,8 +1168,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
@@ -2026,7 +2049,7 @@ save and load various baselines).</p>
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href="../working-with-parquet-files/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Working with Parquet Files">
+ <a href="../working-with-sql-sedonadb/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Working with SQL in SedonaDB">
<div class="md-footer__button md-icon">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24
24"><path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8
11z"></path></svg>
@@ -2036,20 +2059,20 @@ save and load various baselines).</p>
Previous
</span>
<div class="md-ellipsis">
- Working with Parquet Files
+ Working with SQL in SedonaDB
</div>
</div>
</a>
- <a href="../crs-examples/" class="md-footer__link
md-footer__link--next" aria-label="Next: Joining Spatial Data with Different
Coordinate Systems">
+ <a href="../reference/python/" class="md-footer__link
md-footer__link--next" aria-label="Next: Python Functions">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Python Functions
</div>
</div>
<div class="md-footer__button md-icon">
diff --git a/latest-snapshot/crs-examples/index.html
b/latest-snapshot/crs-examples/index.html
index 5f98ec3..f74267b 100644
--- a/latest-snapshot/crs-examples/index.html
+++ b/latest-snapshot/crs-examples/index.html
@@ -10,10 +10,10 @@
<link rel="canonical"
href="https://sedona.apache.org/sedonadb/latest/crs-examples/";>
- <link rel="prev" href="../contributors-guide/">
+ <link rel="prev" href="../working-with-parquet-files/">
- <link rel="next" href="../reference/python/">
+ <link rel="next" href="../working-with-sql-sedonadb/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -896,29 +896,6 @@
-
-
- <li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Contributors Guide
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
@@ -1028,6 +1005,52 @@
+ <li class="md-nav__item">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
@@ -1045,10 +1068,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1061,8 +1084,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
@@ -1905,7 +1928,7 @@
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href="../contributors-guide/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Contributors Guide">
+ <a href="../working-with-parquet-files/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Working with Parquet Files">
<div class="md-footer__button md-icon">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24
24"><path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8
11z"></path></svg>
@@ -1915,20 +1938,20 @@
Previous
</span>
<div class="md-ellipsis">
- Contributors Guide
+ Working with Parquet Files
</div>
</div>
</a>
- <a href="../reference/python/" class="md-footer__link
md-footer__link--next" aria-label="Next: Python Functions">
+ <a href="../working-with-sql-sedonadb/" class="md-footer__link
md-footer__link--next" aria-label="Next: Working with SQL in SedonaDB">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- Python Functions
+ Working with SQL in SedonaDB
</div>
</div>
<div class="md-footer__button md-icon">
diff --git a/latest-snapshot/geopandas-interop/index.html
b/latest-snapshot/geopandas-interop/index.html
index 16e0ecc..4c05d2b 100644
--- a/latest-snapshot/geopandas-interop/index.html
+++ b/latest-snapshot/geopandas-interop/index.html
@@ -968,12 +968,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -991,12 +991,35 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1030,10 +1053,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1046,8 +1069,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/index.html b/latest-snapshot/index.html
index 87db6e2..164ecee 100644
--- a/latest-snapshot/index.html
+++ b/latest-snapshot/index.html
@@ -992,12 +992,12 @@
<li class="md-nav__item">
- <a href="contributors-guide/" class="md-nav__link">
+ <a href="crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -1015,12 +1015,35 @@
<li class="md-nav__item">
- <a href="crs-examples/" class="md-nav__link">
+ <a href="working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1051,10 +1074,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -1067,8 +1090,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/overture-examples/index.html
b/latest-snapshot/overture-examples/index.html
index 0f11969..f41c326 100644
--- a/latest-snapshot/overture-examples/index.html
+++ b/latest-snapshot/overture-examples/index.html
@@ -959,12 +959,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -982,12 +982,35 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1021,10 +1044,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1037,8 +1060,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/programming-guide/index.html
b/latest-snapshot/programming-guide/index.html
index 21ebf15..9e995fa 100644
--- a/latest-snapshot/programming-guide/index.html
+++ b/latest-snapshot/programming-guide/index.html
@@ -1007,12 +1007,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -1030,12 +1030,35 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1069,10 +1092,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1085,8 +1108,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/quickstart-python/index.html
b/latest-snapshot/quickstart-python/index.html
index 844ddd0..026b302 100644
--- a/latest-snapshot/quickstart-python/index.html
+++ b/latest-snapshot/quickstart-python/index.html
@@ -962,12 +962,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -985,12 +985,35 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1021,10 +1044,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -1037,8 +1060,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/reference/python/index.html
b/latest-snapshot/reference/python/index.html
index 542debc..ad680db 100644
--- a/latest-snapshot/reference/python/index.html
+++ b/latest-snapshot/reference/python/index.html
@@ -10,7 +10,7 @@
<link rel="canonical"
href="https://sedona.apache.org/sedonadb/latest/reference/python/";>
- <link rel="prev" href="../../crs-examples/">
+ <link rel="prev" href="../../contributors-guide/">
<link rel="next" href="../sql/">
@@ -896,12 +896,12 @@
<li class="md-nav__item">
- <a href="../../contributors-guide/" class="md-nav__link">
+ <a href="../../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -919,12 +919,35 @@
<li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
+ <a href="../../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -955,10 +978,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -971,8 +994,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
@@ -3986,7 +4009,7 @@ DBAPI is experimental.</p>
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href="../../crs-examples/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Joining Spatial Data with
Different Coordinate Systems">
+ <a href="../../contributors-guide/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Contributors Guide">
<div class="md-footer__button md-icon">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24
24"><path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8
11z"></path></svg>
@@ -3996,7 +4019,7 @@ DBAPI is experimental.</p>
Previous
</span>
<div class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Contributors Guide
</div>
</div>
</a>
diff --git a/latest-snapshot/reference/sql-joins/index.html
b/latest-snapshot/reference/sql-joins/index.html
index 23eb5a7..bce43a2 100644
--- a/latest-snapshot/reference/sql-joins/index.html
+++ b/latest-snapshot/reference/sql-joins/index.html
@@ -894,12 +894,12 @@
<li class="md-nav__item">
- <a href="../../contributors-guide/" class="md-nav__link">
+ <a href="../../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -917,12 +917,35 @@
<li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
+ <a href="../../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -953,10 +976,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -969,8 +992,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/reference/sql/index.html
b/latest-snapshot/reference/sql/index.html
index c2f08b8..35a7b11 100644
--- a/latest-snapshot/reference/sql/index.html
+++ b/latest-snapshot/reference/sql/index.html
@@ -896,12 +896,12 @@
<li class="md-nav__item">
- <a href="../../contributors-guide/" class="md-nav__link">
+ <a href="../../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -919,12 +919,35 @@
<li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
+ <a href="../../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -955,10 +978,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="0">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="0">
@@ -971,8 +994,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
diff --git a/latest-snapshot/search/search_index.json
b/latest-snapshot/search/search_index.json
index 5f9e782..7634517 100644
--- a/latest-snapshot/search/search_index.json
+++ b/latest-snapshot/search/search_index.json
@@ -1 +1 @@
-{"config":{"lang":["en"],"separator":"[\\s\\-]+","pipeline":["stopWordFilter"]},"docs":[{"location":"","title":"Introducing
SedonaDB","text":"<p>SedonaDB is an open-source single-node analytical
database engine with geospatial as a first-class citizen. It aims to deliver
the fastest spatial analytics query speed and the most comprehensive function
coverage available.</p> <p>SedonaDB is perfect for processing smaller to medium
datasets on local machines or cloud instances. For distributed [...]
\ No newline at end of file
+{"config":{"lang":["en"],"separator":"[\\s\\-]+","pipeline":["stopWordFilter"]},"docs":[{"location":"","title":"Introducing
SedonaDB","text":"<p>SedonaDB is an open-source single-node analytical
database engine with geospatial as a first-class citizen. It aims to deliver
the fastest spatial analytics query speed and the most comprehensive function
coverage available.</p> <p>SedonaDB is perfect for processing smaller to medium
datasets on local machines or cloud instances. For distributed [...]
\ No newline at end of file
diff --git a/latest-snapshot/sitemap.xml b/latest-snapshot/sitemap.xml
index e16f100..77d0e1f 100644
--- a/latest-snapshot/sitemap.xml
+++ b/latest-snapshot/sitemap.xml
@@ -32,6 +32,10 @@
<loc>https://sedona.apache.org/sedonadb/latest/working-with-parquet-files/</loc>
<lastmod>2025-09-24</lastmod>
</url>
+ <url>
+
<loc>https://sedona.apache.org/sedonadb/latest/working-with-sql-sedonadb/</loc>
+ <lastmod>2025-09-24</lastmod>
+ </url>
<url>
<loc>https://sedona.apache.org/sedonadb/latest/reference/python/</loc>
<lastmod>2025-09-24</lastmod>
diff --git a/latest-snapshot/sitemap.xml.gz b/latest-snapshot/sitemap.xml.gz
index 5e1c00a..1506e45 100644
Binary files a/latest-snapshot/sitemap.xml.gz and
b/latest-snapshot/sitemap.xml.gz differ
diff --git a/latest-snapshot/stylesheets/extra.css
b/latest-snapshot/stylesheets/extra.css
index f017b44..5cd0bcf 100644
--- a/latest-snapshot/stylesheets/extra.css
+++ b/latest-snapshot/stylesheets/extra.css
@@ -107,18 +107,22 @@
Swap Logo ONLY in Mobile Navigation
==========================================================================
*/
-/* 1. Hide the default logo image inside the mobile nav */
-.md-nav--primary .md-nav__title .md-logo img {
- display: none;
-}
-
-/* 2. Apply the new mobile logo as a background image */
-.md-nav--primary .md-nav__title .md-logo {
- display: block;
- height: 48px; /* Adjust size as needed */
- width: 100%;
- background-image: url('../image/sedona_logo_symbol_white.svg'); /*
IMPORTANT: Update this path */
+/*
+ Target the logo link (<a> tag) directly and apply the new logo
+ as a background image, overriding the theme's default icon.
+*/
+.md-sidebar--primary .md-nav__title a.md-nav__button.md-logo {
+ background-image: url('/docs/image/sedona_logo_symbol.svg');
background-size: contain;
background-repeat: no-repeat;
- background-position: center left;
+ background-position: center;
+
+ /* Hide the theme's default icon which is applied via a mask */
+ -webkit-mask: none;
+ mask: none;
+}
+
+/* Change the mobile nav header label text to white */
+label.md-nav__title {
+ color: #FFFFFF !important;
}
diff --git a/latest-snapshot/working-with-parquet-files/index.html
b/latest-snapshot/working-with-parquet-files/index.html
index eb57fc9..0c7cea5 100644
--- a/latest-snapshot/working-with-parquet-files/index.html
+++ b/latest-snapshot/working-with-parquet-files/index.html
@@ -13,7 +13,7 @@
<link rel="prev" href="../overture-examples/">
- <link rel="next" href="../contributors-guide/">
+ <link rel="next" href="../crs-examples/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -959,12 +959,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</span>
@@ -982,12 +982,35 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
</span>
@@ -1021,10 +1044,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1037,8 +1060,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
@@ -1716,13 +1739,13 @@
- <a href="../contributors-guide/" class="md-footer__link
md-footer__link--next" aria-label="Next: Contributors Guide">
+ <a href="../crs-examples/" class="md-footer__link
md-footer__link--next" aria-label="Next: Joining Spatial Data with Different
Coordinate Systems">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- Contributors Guide
+ Joining Spatial Data with Different Coordinate Systems
</div>
</div>
<div class="md-footer__button md-icon">
diff --git a/latest-snapshot/working-with-parquet-files/index.html
b/latest-snapshot/working-with-sql-sedonadb/index.html
similarity index 78%
copy from latest-snapshot/working-with-parquet-files/index.html
copy to latest-snapshot/working-with-sql-sedonadb/index.html
index eb57fc9..5fbb06e 100644
--- a/latest-snapshot/working-with-parquet-files/index.html
+++ b/latest-snapshot/working-with-sql-sedonadb/index.html
@@ -7,10 +7,10 @@
- <link rel="canonical"
href="https://sedona.apache.org/sedonadb/latest/working-with-parquet-files/";>
+ <link rel="canonical"
href="https://sedona.apache.org/sedonadb/latest/working-with-sql-sedonadb/";>
- <link rel="prev" href="../overture-examples/">
+ <link rel="prev" href="../crs-examples/">
<link rel="next" href="../contributors-guide/">
@@ -21,7 +21,7 @@
- <title>Working with Parquet Files - SedonaDB</title>
+ <title>Working with SQL in SedonaDB - SedonaDB</title>
@@ -86,7 +86,7 @@
<div data-md-component="skip">
- <a href="#working-with-parquet-files" class="md-skip">
+ <a href="#working-with-sql-in-sedonadb" class="md-skip">
Skip to content
</a>
@@ -125,7 +125,7 @@
<div class="md-header__topic" data-md-component="header-topic">
<span class="md-ellipsis">
- Working with Parquet Files
+ Working with SQL in SedonaDB
</span>
</div>
@@ -873,6 +873,52 @@
+
+
+ <li class="md-nav__item">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with Parquet Files
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../crs-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Joining Spatial Data with Different Coordinate Systems
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
@@ -890,7 +936,7 @@
<span class="md-ellipsis">
- Working with Parquet Files
+ Working with SQL in SedonaDB
</span>
@@ -903,7 +949,7 @@
<span class="md-ellipsis">
- Working with Parquet Files
+ Working with SQL in SedonaDB
</span>
@@ -926,21 +972,60 @@
<ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
<li class="md-nav__item">
- <a href="#install-sedonadb" class="md-nav__link">
+ <a href="#creating-arrays-of-spatial-types-in-sql" class="md-nav__link">
+ <span class="md-ellipsis">
+ Creating Arrays of Spatial Types in SQL
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Creating Arrays of Spatial Types in SQL">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#the-incorrect-method-array" class="md-nav__link">
+ <span class="md-ellipsis">
+ The Incorrect Method: ARRAY()
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#the-correct-method-brackets" class="md-nav__link">
<span class="md-ellipsis">
- Install SedonaDB
+ The Correct Method: Brackets
</span>
</a>
+</li>
+
+ </ul>
+ </nav>
+
</li>
<li class="md-nav__item">
- <a href="#implementation" class="md-nav__link">
+ <a href="#temporary-views-not-supported-in-sql" class="md-nav__link">
+ <span class="md-ellipsis">
+ Temporary Views Not Supported in SQL
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Temporary Views Not Supported in SQL">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#recommended-alternative" class="md-nav__link">
<span class="md-ellipsis">
- Implementation
+ Recommended Alternative
</span>
</a>
+</li>
+
+ </ul>
+ </nav>
+
</li>
</ul>
@@ -981,29 +1066,6 @@
- <li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Joining Spatial Data with Different Coordinate Systems
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
@@ -1021,10 +1083,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_7">
+ <input class="md-nav__toggle md-toggle " type="checkbox"
id="__nav_3_8">
- <label class="md-nav__link" for="__nav_3_7" id="__nav_3_7_label"
tabindex="">
+ <label class="md-nav__link" for="__nav_3_8" id="__nav_3_8_label"
tabindex="">
@@ -1037,8 +1099,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_7_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_3_7">
+ <nav class="md-nav" data-md-level="2"
aria-labelledby="__nav_3_8_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_3_8">
<span class="md-nav__icon md-icon"></span>
Get Involved
</label>
@@ -1518,21 +1580,60 @@
<ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
<li class="md-nav__item">
- <a href="#install-sedonadb" class="md-nav__link">
+ <a href="#creating-arrays-of-spatial-types-in-sql" class="md-nav__link">
<span class="md-ellipsis">
- Install SedonaDB
+ Creating Arrays of Spatial Types in SQL
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Creating Arrays of Spatial Types in SQL">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#the-incorrect-method-array" class="md-nav__link">
+ <span class="md-ellipsis">
+ The Incorrect Method: ARRAY()
</span>
</a>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#the-correct-method-brackets" class="md-nav__link">
+ <span class="md-ellipsis">
+ The Correct Method: Brackets
+ </span>
+ </a>
+
+</li>
+
+ </ul>
+ </nav>
+
</li>
<li class="md-nav__item">
- <a href="#implementation" class="md-nav__link">
+ <a href="#temporary-views-not-supported-in-sql" class="md-nav__link">
+ <span class="md-ellipsis">
+ Temporary Views Not Supported in SQL
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Temporary Views Not Supported in SQL">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#recommended-alternative" class="md-nav__link">
<span class="md-ellipsis">
- Implementation
+ Recommended Alternative
</span>
</a>
+</li>
+
+ </ul>
+ </nav>
+
</li>
</ul>
@@ -1551,7 +1652,7 @@
- <a
href="https://github.com/apache/sedona-db/blob/main/docs/working-with-parquet-files.md";
title="Edit this page" class="md-content__button md-icon" rel="edit">
+ <a
href="https://github.com/apache/sedona-db/blob/main/docs/working-with-sql-sedonadb.md";
title="Edit this page" class="md-content__button md-icon" rel="edit">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24 24"><path d="M10
20H6V4h7v5h5v3.1l2-2V8l-6-6H6c-1.1 0-2 .9-2 2v16c0 1.1.9 2 2 2h4zm10.2-7c.1 0
.3.1.4.2l1.3 1.3c.2.2.2.6 0 .8l-1 1-2.1-2.1 1-1c.1-.1.2-.2.4-.2m0 3.9L14.1
23H12v-2.1l6.1-6.1z"></path></svg>
</a>
@@ -1559,89 +1660,64 @@
-<h1 id="working-with-parquet-files">Working with Parquet Files<a
class="headerlink" href="#working-with-parquet-files" title="Permanent
link">¶</a></h1>
-<p>The easiest way to read a GeoParquet or Parquet file is to use
<code>sd.read_parquet()</code>. Alternatively, you can query these files
directly by their path in SQL.</p>
-<h2 id="install-sedonadb">Install SedonaDB<a class="headerlink"
href="#install-sedonadb" title="Permanent link">¶</a></h2>
-<p>Use pip to install SedonaDB from the Python Package Index (PyPI).</p>
-<blockquote>
-<p><strong>Note</strong>: Before running this notebook on your local machine,
you must have SedonaDB installed in your environment. You can install SedonaDB
with the following command: <code>pip install "apache-sedona[db]"</code></p>
-</blockquote>
-<h2 id="implementation">Implementation<a class="headerlink"
href="#implementation" title="Permanent link">¶</a></h2>
-<p>A common workflow for working with GeoParquet and/or Parquet files is:</p>
-<ol>
-<li><strong>Load</strong> the Parquet file into a data frame using
<code>sd.read_parquet()</code>.</li>
-<li><strong>Register</strong> the data frame as a view with
<code>to_view()</code>.</li>
-<li><strong>Query</strong> the view using <code>sd.sql()</code>.</li>
-<li><strong>Write</strong> your results to a Parquet file with
<code>.to_parquet()</code> or use <code>.to_pandas()</code> to export your
results to a DataFrame or GeoDataFrame.</li>
-</ol>
-<div class="highlight"><pre><span></span><code><span class="c1"># Import the
sedona.db module and connect to SedonaDB</span>
-<span class="kn">import</span><span class="w"> </span><span
class="nn">sedona.db</span>
-
-<span class="n">sd</span> <span class="o">=</span> <span
class="n">sedona</span><span class="o">.</span><span class="n">db</span><span
class="o">.</span><span class="n">connect</span><span class="p">()</span>
+<!---
+ Licensed to the Apache Software Foundation (ASF) under one
+ or more contributor license agreements. See the NOTICE file
+ distributed with this work for additional information
+ regarding copyright ownership. The ASF licenses this file
+ to you under the Apache License, Version 2.0 (the
+ "License"); you may not use this file except in compliance
+ with the License. You may obtain a copy of the License at
+
+ http://www.apache.org/licenses/LICENSE-2.0
+
+ Unless required by applicable law or agreed to in writing,
+ software distributed under the License is distributed on an
+ "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
+ KIND, either express or implied. See the License for the
+ specific language governing permissions and limitations
+ under the License.
+--><h1 id="working-with-sql-in-sedonadb">Working with SQL in SedonaDB<a
class="headerlink" href="#working-with-sql-in-sedonadb" title="Permanent
link">¶</a></h1>
+<p>This page details several nuances of using SQL in SedonaDB.</p>
+<h2 id="creating-arrays-of-spatial-types-in-sql">Creating Arrays of Spatial
Types in SQL<a class="headerlink"
href="#creating-arrays-of-spatial-types-in-sql" title="Permanent
link">¶</a></h2>
+<p>When constructing an array of spatial objects (like <code>ST_POINT</code>)
in SedonaDB, you must use bracket notation <code>[...]</code> instead of the
standard <code>ARRAY()</code> function.</p>
+<h3 id="the-incorrect-method-array">The Incorrect Method:
<code>ARRAY()</code><a class="headerlink" href="#the-incorrect-method-array"
title="Permanent link">¶</a></h3>
+<p>Attempting to use the <code>ARRAY()</code> function to create an array of
spatial types is not supported and will result in a planning error. SedonaDB
will not recognize <code>ARRAY</code> as a valid function for this
operation.</p>
+<div class="highlight"><span class="filename">Example
(Fails)</span><pre><span></span><code><span class="o">>>></span> <span
class="n">sd</span><span class="o">.</span><span class="n">sql</span><span
class="p">(</span><span class="s2">"SELECT ARRAY(ST_POINT(1,2),
ST_POINT(3,4))"</span><span class="p">)</span>
+<span class="o">...</span>
+<span class="n">Error</span> <span class="n">during</span> <span
class="n">planning</span><span class="p">:</span> <span
class="n">Invalid</span> <span class="n">function</span> <span
class="s1">'array'</span>
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="c1"># 1. Load the
Parquet file</span>
-<span class="n">df</span> <span class="o">=</span> <span
class="n">sd</span><span class="o">.</span><span
class="n">read_parquet</span><span class="p">(</span>
- <span
class="s2">"https://raw.githubusercontent.com/geoarrow/geoarrow-data/v0.2.0/";</span>
- <span
class="s2">"natural-earth/files/natural-earth_cities_geo.parquet"</span>
-<span class="p">)</span>
-
-<span class="c1"># 2. Register the data frame as a view</span>
-<span class="n">df</span><span class="o">.</span><span
class="n">to_view</span><span class="p">(</span><span
class="s2">"zone"</span><span class="p">)</span>
-
-<span class="c1"># 3. Query the view and store the result in a new
DataFrame</span>
-<span class="n">query_result_df</span> <span class="o">=</span> <span
class="n">sd</span><span class="o">.</span><span class="n">sql</span><span
class="p">(</span><span class="s2">"SELECT * FROM zone LIMIT 10"</span><span
class="p">)</span>
-<span class="n">query_result_df</span><span class="o">.</span><span
class="n">show</span><span class="p">()</span>
+<h3 id="the-correct-method-brackets">The Correct Method: Brackets<a
class="headerlink" href="#the-correct-method-brackets" title="Permanent
link">¶</a></h3>
+<p>To correctly build an array, enclose your comma-separated spatial objects
in <strong>square brackets <code>[]</code></strong>. This syntax
+successfully creates a list containing the spatial data structures.</p>
+<div class="highlight"><span class="filename">Example
(Works)</span><pre><span></span><code><span class="o">>>></span> <span
class="n">sd</span><span class="o">.</span><span class="n">sql</span><span
class="p">(</span><span class="s2">"SELECT [ST_POINT(1,2),
ST_POINT(3,4)]"</span><span class="p">)</span><span class="o">.</span><span
class="n">show</span><span class="p">()</span>
+<span
class="err">┌──────────────────────────────────────────────────────────────────────────────────────────┐</span>
+<span class="err">│</span> <span class="n">make_array</span><span
class="p">(</span><span class="n">st_point</span><span class="p">(</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">1</span><span
class="p">),</span><span class="n">Int64</span><span class="p">(</span><span
class="mi">2</span><span class="p">)),</span><span
class="n">st_point</span><span class="p">(</span><span
class="n">Int64</span><span class="p">(</span><span class="mi">3</span><span
[...]
+<span class="err">│</span> <span
class="nb">list</span> <span
class="err">│</span>
+<span
class="err">╞══════════════════════════════════════════════════════════════════════════════════════════╡</span>
+<span class="err">│</span> <span class="p">[</span><span
class="mi">0101000000000000000000</span><span
class="n">f03f0000000000000040</span><span class="p">,</span> <span
class="mi">010100000000000000000008400000000000001040</span><span
class="p">]</span> <span class="err">│</span>
+<span
class="err">└──────────────────────────────────────────────────────────────────────────────────────────┘</span>
</code></pre></div>
-<div
class="codehilite"><pre><span></span><code>┌──────────────┬───────────────────────────────┐
-│ name ┆ geometry │
-│ utf8 ┆ geometry │
-╞══════════════╪═══════════════════════════════╡
-│ Vatican City ┆ POINT(12.4533865 41.9032822) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ San Marino ┆ POINT(12.4417702 43.9360958) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Vaduz ┆ POINT(9.5166695 47.1337238) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Lobamba ┆ POINT(31.1999971 -26.4666675) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Luxembourg ┆ POINT(6.1300028 49.6116604) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Palikir ┆ POINT(158.1499743 6.9166437) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Majuro ┆ POINT(171.3800002 7.1030043) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Funafuti ┆ POINT(179.2166471 -8.516652) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Melekeok ┆ POINT(134.6265485 7.4873962) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Bir Lehlou ┆ POINT(-9.6525222 26.1191667) │
-└──────────────┴───────────────────────────────┘
+<p>This approach correctly instructs SedonaDB to construct an array containing
the two <code>ST_POINT</code> objects.</p>
+<h2 id="temporary-views-not-supported-in-sql">Temporary Views Not Supported in
SQL<a class="headerlink" href="#temporary-views-not-supported-in-sql"
title="Permanent link">¶</a></h2>
+<p>SedonaDB does not support the <code>CREATE TEMP VIEW</code> or <code>CREATE
TEMPORARY VIEW</code> SQL commands. Executing these statements will result in
an error.</p>
+<p>Attempting to create a temporary view directly with <code>sd.sql()</code>
will fail, as shown below.</p>
+<div class="highlight"><span class="filename">Unsupported
Example</span><pre><span></span><code><span class="o">>>></span> <span
class="n">sd</span><span class="o">.</span><span class="n">sql</span><span
class="p">(</span><span class="s2">"CREATE TEMP VIEW b AS SELECT * FROM
'/path/to/building.parquet'"</span><span class="p">)</span>
+<span class="n">Traceback</span> <span class="p">(</span><span
class="n">most</span> <span class="n">recent</span> <span class="n">call</span>
<span class="n">last</span><span class="p">):</span>
+ <span class="o">...</span>
+<span class="n">sedonadb</span><span class="o">.</span><span
class="n">_lib</span><span class="o">.</span><span
class="n">SedonaError</span><span class="p">:</span> <span
class="n">Temporary</span> <span class="n">views</span> <span
class="ow">not</span> <span class="n">supported</span>
</code></pre></div>
+<h3 id="recommended-alternative">Recommended Alternative<a class="headerlink"
href="#recommended-alternative" title="Permanent link">¶</a></h3>
+<p>The correct way to create a view is to load your data and use
<code>to_view()</code>.</p>
+<p>This approach provides the same functionality and is the standard practice
in Spark-based environments.</p>
+<div class="highlight"><span class="filename">Working
Example</span><pre><span></span><code><span class="c1"># Step 1: Load your data
into a DataFrame first</span>
+<span class="o">>>></span> <span class="n">building_df</span> <span
class="o">=</span> <span class="n">sd</span><span class="o">.</span><span
class="n">read_parquet</span><span class="p">(</span><span
class="s2">"/path/to/building.parquet"</span><span class="p">)</span>
-<div class="highlight"><pre><span></span><code><span class="c1"># 4. Write the
result to a new Parquet file</span>
-<span class="n">output_path</span> <span class="o">=</span> <span
class="s2">"query_results.parquet"</span>
-<span class="n">query_result_df</span><span class="o">.</span><span
class="n">to_parquet</span><span class="p">(</span><span
class="n">output_path</span><span class="p">)</span>
+<span class="c1"># Step 2: Register the DataFrame as a temporary view</span>
+<span class="o">>>></span> <span class="n">building_df</span><span
class="o">.</span><span class="n">to_view</span><span class="p">(</span><span
class="s2">"b"</span><span class="p">)</span>
-<span class="c1"># (Optional) Verify the written file</span>
-<span class="nb">print</span><span class="p">(</span><span
class="sa">f</span><span class="s2">"</span><span class="se">\n</span><span
class="s2">Verifying the written file at '</span><span class="si">{</span><span
class="n">output_path</span><span class="si">}</span><span
class="s2">'..."</span><span class="p">)</span>
-<span class="n">verified_df</span> <span class="o">=</span> <span
class="n">sd</span><span class="o">.</span><span
class="n">read_parquet</span><span class="p">(</span><span
class="n">output_path</span><span class="p">)</span>
-<span class="n">verified_df</span><span class="o">.</span><span
class="n">show</span><span class="p">(</span><span class="mi">5</span><span
class="p">)</span>
-</code></pre></div>
-<div class="codehilite"><pre><span></span><code>Verifying the written file at
'query_results.parquet'...
-┌──────────────┬───────────────────────────────┐
-│ name ┆ geometry │
-│ utf8 ┆ geometry │
-╞══════════════╪═══════════════════════════════╡
-│ Vatican City ┆ POINT(12.4533865 41.9032822) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ San Marino ┆ POINT(12.4417702 43.9360958) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Vaduz ┆ POINT(9.5166695 47.1337238) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Lobamba ┆ POINT(31.1999971 -26.4666675) │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Luxembourg ┆ POINT(6.1300028 49.6116604) │
-└──────────────┴───────────────────────────────┘
+<span class="c1"># Step 3: You can now successfully query the view using
SQL</span>
+<span class="o">>>></span> <span class="n">sd</span><span
class="o">.</span><span class="n">sql</span><span class="p">(</span><span
class="s2">"SELECT * FROM b LIMIT 5"</span><span class="p">)</span><span
class="o">.</span><span class="n">show</span><span class="p">()</span>
</code></pre></div>
@@ -1663,7 +1739,7 @@
<span class="md-icon" title="Last update">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24 24"><path d="M21
13.1c-.1 0-.3.1-.4.2l-1 1 2.1 2.1 1-1c.2-.2.2-.6
0-.8l-1.3-1.3c-.1-.1-.2-.2-.4-.2m-1.9 1.8-6.1 6V23h2.1l6.1-6.1zM12.5 7v5.2l4
2.4-1 1L11 13V7zM11 21.9c-5.1-.5-9-4.8-9-9.9C2 6.5 6.5 2 12 2c5.3 0 9.6 4.1 10
9.3-.3-.1-.6-.2-1-.2s-.7.1-1 .2C19.6 7.2 16.2 4 12 4c-4.4 0-8 3.6-8 8 0 4.1 3.1
7.5 7.1 7.9l-.1.2z"></path></svg>
</span>
- <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="September 19, 2025 07:13:30
UTC">September 19, 2025 07:13:30</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="September 24, 2025 06:28:47
UTC">September 24, 2025 06:28:47</span>
</span>
@@ -1699,7 +1775,7 @@
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href="../overture-examples/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Working with Overture">
+ <a href="../crs-examples/" class="md-footer__link
md-footer__link--prev" aria-label="Previous: Joining Spatial Data with
Different Coordinate Systems">
<div class="md-footer__button md-icon">
<svg xmlns="http://www.w3.org/2000/svg"; viewBox="0 0 24
24"><path d="M20 11v2H8l5.5 5.5-1.42 1.42L4.16 12l7.92-7.92L13.5 5.5 8
11z"></path></svg>
@@ -1709,7 +1785,7 @@
Previous
</span>
<div class="md-ellipsis">
- Working with Overture
+ Joining Spatial Data with Different Coordinate Systems
</div>
</div>
</a>
