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 8cf636a Deployed eff66aa to 0.1.0 with MkDocs 1.6.1 and mike 2.1.3
8cf636a is described below
commit 8cf636ab6a865e423bfcb47399e9707c6d6b8618
Author: GitHub Actions <[email protected]>
AuthorDate: Wed Sep 24 08:02:39 2025 +0000
Deployed eff66aa to 0.1.0 with MkDocs 1.6.1 and mike 2.1.3
---
0.1.0/404.html | 39 ++-
0.1.0/contributors-guide/index.html | 89 +++---
0.1.0/crs-examples/index.html | 89 +++---
0.1.0/geopandas-interop/index.html | 39 ++-
0.1.0/image/lonboard_ns.png | Bin 0 -> 523379 bytes
0.1.0/image/sf1-09242025.png | Bin 0 -> 20887 bytes
0.1.0/image/sf1.png | Bin 133443 -> 0 bytes
0.1.0/image/sf10-09242025.png | Bin 0 -> 25154 bytes
0.1.0/image/sf10.png | Bin 189589 -> 0 bytes
0.1.0/index.html | 47 ++-
0.1.0/overture-examples.ipynb | 133 ++++++---
0.1.0/overture-examples/index.html | 113 +++++--
0.1.0/programming-guide/index.html | 39 ++-
0.1.0/quickstart-python/index.html | 39 ++-
0.1.0/reference/python/index.html | 45 ++-
0.1.0/reference/sql-joins/index.html | 39 ++-
0.1.0/reference/sql/index.html | 39 ++-
0.1.0/requirements.txt | 1 +
0.1.0/search/search_index.json | 2 +-
0.1.0/sitemap.xml | 4 +
0.1.0/sitemap.xml.gz | Bin 314 -> 323 bytes
0.1.0/stylesheets/extra.css | 28 +-
0.1.0/working-with-parquet-files/index.html | 45 ++-
.../index.html | 324 +++++++++++++--------
24 files changed, 796 insertions(+), 358 deletions(-)
diff --git a/0.1.0/404.html b/0.1.0/404.html
index 0e39b05..2c3d9c4 100644
--- a/0.1.0/404.html
+++ b/0.1.0/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/0.1.0/contributors-guide/index.html
b/0.1.0/contributors-guide/index.html
index 0713086..0b31092 100644
--- a/0.1.0/contributors-guide/index.html
+++ b/0.1.0/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/0.1.0/crs-examples/index.html b/0.1.0/crs-examples/index.html
index 5f98ec3..f74267b 100644
--- a/0.1.0/crs-examples/index.html
+++ b/0.1.0/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/0.1.0/geopandas-interop/index.html
b/0.1.0/geopandas-interop/index.html
index 16e0ecc..4c05d2b 100644
--- a/0.1.0/geopandas-interop/index.html
+++ b/0.1.0/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/0.1.0/image/lonboard_ns.png b/0.1.0/image/lonboard_ns.png
new file mode 100644
index 0000000..482d17c
Binary files /dev/null and b/0.1.0/image/lonboard_ns.png differ
diff --git a/0.1.0/image/sf1-09242025.png b/0.1.0/image/sf1-09242025.png
new file mode 100644
index 0000000..34f146f
Binary files /dev/null and b/0.1.0/image/sf1-09242025.png differ
diff --git a/0.1.0/image/sf1.png b/0.1.0/image/sf1.png
deleted file mode 100644
index 2218a2d..0000000
Binary files a/0.1.0/image/sf1.png and /dev/null differ
diff --git a/0.1.0/image/sf10-09242025.png b/0.1.0/image/sf10-09242025.png
new file mode 100644
index 0000000..0a400fc
Binary files /dev/null and b/0.1.0/image/sf10-09242025.png differ
diff --git a/0.1.0/image/sf10.png b/0.1.0/image/sf10.png
deleted file mode 100644
index 9c932ea..0000000
Binary files a/0.1.0/image/sf10.png and /dev/null differ
diff --git a/0.1.0/index.html b/0.1.0/index.html
index 87db6e2..92b9bdb 100644
--- a/0.1.0/index.html
+++ b/0.1.0/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>
@@ -1684,10 +1707,10 @@
<li><strong>π Ecosystem Integration:</strong> Interoperable with
PyArrow-compatible libraries like GeoPandas, DuckDB, and Polars</li>
</ul>
<h2 id="performance-benchmarks">Performance Benchmarks<a class="headerlink"
href="#performance-benchmarks" title="Permanent link">ΒΆ</a></h2>
-<p>This is a performance benchmark comparing SedonaDB 0.1.0, DuckDB 1.4.0, and
GeoPandas 1.1.1 using SpatialBench Queries 1-12 at Scale Factors 1 and 10.
Details can be found at <a
href="https://sedona.apache.org/spatialbench/";>Apache Sedona
SpatialBench</a>.</p>
+<p>This is a performance benchmark comparing SedonaDB 0.1.0, DuckDB 1.4.0, and
GeoPandas 1.1.1 using SpatialBench Queries 1-12 at Scale Factors 1 and 10.
Details can be found at <a
href="https://sedona.apache.org/spatialbench/single-node-benchmarks/";>Apache
Sedona SpatialBench</a>.</p>
<div align="center">
- <a class="glightbox" data-type="image" data-width="100%" data-height="auto"
href="image/sf1.png" data-desc-position="bottom"><img src="image/sf1.png"
alt="SF1 Benchmark Results" width="45%"></a>
- <a class="glightbox" data-type="image" data-width="100%" data-height="auto"
href="image/sf10.png" data-desc-position="bottom"><img src="image/sf10.png"
alt="SF10 Benchmark Results" width="45%"></a>
+ <a class="glightbox" data-type="image" data-width="100%" data-height="auto"
href="image/sf1-09242025.png" data-desc-position="bottom"><img
src="image/sf1-09242025.png" alt="SF1 Benchmark Results" width="45%"></a>
+ <a class="glightbox" data-type="image" data-width="100%" data-height="auto"
href="image/sf10-09242025.png" data-desc-position="bottom"><img
src="image/sf10-09242025.png" alt="SF10 Benchmark Results" width="45%"></a>
</div>
<h2 id="install-sedonadb">Install SedonaDB<a class="headerlink"
href="#install-sedonadb" title="Permanent link">ΒΆ</a></h2>
@@ -1746,7 +1769,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 24, 2025 01:21:10
UTC">September 24, 2025 01:21:10</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="September 24, 2025 07:54:15
UTC">September 24, 2025 07:54:15</span>
</span>
diff --git a/0.1.0/overture-examples.ipynb b/0.1.0/overture-examples.ipynb
index ab1fd81..1be3f99 100644
--- a/0.1.0/overture-examples.ipynb
+++ b/0.1.0/overture-examples.ipynb
@@ -38,7 +38,7 @@
},
{
"cell_type": "code",
- "execution_count": 1,
+ "execution_count": 2,
"id": "6d6fa0ab-b4ed-4e60-b099-a1af0998b486",
"metadata": {},
"outputs": [],
@@ -62,7 +62,7 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": 3,
"id": "52855769-4872-472a-9c42-afced3d85ca8",
"metadata": {},
"outputs": [],
@@ -74,7 +74,7 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": 4,
"id": "b45b5e5c-64ed-49ba-a8aa-9f2292f617c6",
"metadata": {},
"outputs": [
@@ -86,25 +86,25 @@
"β id β geometry
β β¦ β roof_height β\n",
"β utf8 β geometry
β β float64 β\n",
"ββββββββββββββββββββββββββββββββββββββββͺββββββββββββββββββββββββββββββββββββββββββͺββββͺββββββββββββββ‘\n",
- "β 76045c54-bd50-415b-9ac8-35cfc22fe80f β POLYGON((-105.7936939
25.7460051,-105.β¦ β β¦ β β\n",
+ "β 97a89436-5295-417e-bde1-2dbf8fe10700 β POLYGON((-107.0377042
28.8102782,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β f1eb3f3e-c9b9-40af-b83e-7f2c09ef8e43 β POLYGON((-105.7971397
25.7517374,-105.β¦ β β¦ β β\n",
+ "β e09fcdeb-65ab-443c-bc59-4f9acf32af17 β POLYGON((-107.0372022
28.8103812,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β f6019f66-3137-4e62-9d84-e4f4febe2f6d β POLYGON((-105.7928137
25.7493614,-105.β¦ β β¦ β β\n",
+ "β cb06e75f-66a0-40ca-9029-e1a24dff1434 β POLYGON((-107.0372848
28.8104923,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 37b96ac3-0093-47d4-a898-263f6550ef14 β POLYGON((-105.7857365
25.7465883,-105.β¦ β β¦ β β\n",
+ "β 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 β POLYGON((-107.0371986
28.8104859,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β e686ab8d-7062-4c0a-a8da-32ab751f7212 β POLYGON((-105.7579541
25.7150521,-105.β¦ β β¦ β β\n",
+ "β 1a4fba29-6160-4a98-b8f7-03395fd6466a β POLYGON((-107.0373331
28.8105281,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 767a736b-ac77-4427-89f0-3f9544b1e9e9 β POLYGON((-105.7576387
25.7149905,-105.β¦ β β¦ β β\n",
+ "β 9de2d803-ab58-46e1-9a35-7423f8d0d121 β POLYGON((-107.0378928
28.8112268,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β db3a2233-a7cb-425a-ac75-ad83cf868a32 β POLYGON((-105.7589831
25.71648,-105.75β¦ β β¦ β β\n",
+ "β 1704c72b-6f2b-445b-b9a3-36fdd0c74233 β POLYGON((-107.0376099
28.8112085,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 53866308-afc7-4ff1-88f6-b2af571238e3 β POLYGON((-105.76268
25.7197151,-105.76β¦ β β¦ β β\n",
+ "β b30bf41d-479f-4ee5-bd45-d4e17ffd8875 β POLYGON((-107.0377094
28.8115554,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 31d8f64e-b7f9-4b26-8c2a-2fd205fed995 β POLYGON((-105.7626968
25.7197994,-105.β¦ β β¦ β β\n",
+ "β c88928d4-b165-4335-9bd8-ccc5c9f79cee β POLYGON((-107.0374986
28.8111847,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 72ec6ed0-d33c-4e64-8c8f-28e7a6ac6310 β POLYGON((-105.7578861
25.7190388,-105.β¦ β β¦ β β\n",
+ "β ca1000b0-6af3-47fc-bdf2-61e8b1b716fc β POLYGON((-107.0370972
28.8115247,-107.β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββ΄ββββ΄ββββββββββββββ\n"
]
}
@@ -115,7 +115,7 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": 5,
"id": "e37a023e-0e80-403a-a65b-b5a190004f72",
"metadata": {},
"outputs": [],
@@ -125,7 +125,7 @@
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": 6,
"id": "ebfe4776-e08f-4f38-97fc-fca8ec6fc364",
"metadata": {},
"outputs": [
@@ -154,7 +154,7 @@
},
{
"cell_type": "code",
- "execution_count": 6,
+ "execution_count": 7,
"id": "b73f670d-0d10-4a7a-bfc7-e2abe5d9edd2",
"metadata": {},
"outputs": [
@@ -188,7 +188,7 @@
" roof_height: float64<Float64>"
]
},
- "execution_count": 6,
+ "execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
@@ -200,7 +200,7 @@
},
{
"cell_type": "code",
- "execution_count": 7,
+ "execution_count": 8,
"id": "68d1b68c-dd26-45c2-944f-61138b212943",
"metadata": {},
"outputs": [
@@ -262,7 +262,7 @@
},
{
"cell_type": "code",
- "execution_count": 8,
+ "execution_count": 9,
"id": "d9f122d3-4d90-46b0-ab9a-259a71cc423b",
"metadata": {},
"outputs": [],
@@ -274,7 +274,7 @@
},
{
"cell_type": "code",
- "execution_count": 9,
+ "execution_count": 10,
"id": "19a75b19-0b56-4167-b3f1-73a171ecc480",
"metadata": {},
"outputs": [
@@ -286,25 +286,25 @@
"β id β geometry β bbox β β¦ β
is_territorial β region β division_id β\n",
"β utf8 β geometry β struct β β boolean
β utf8 β utf8 β\n",
"βββββββββββββββββββͺβββββββββββββββββͺβββββββββββββββββͺββββͺβββββββββββββββββͺβββββββββͺβββββββββββββββββ‘\n",
- "β 6dd2a4d4-542f-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 4b010ede-3285β¦ β\n",
+ "β cd743a89-9507-β¦ β POLYGON((111.β¦ β {xmin: 111.40β¦ β β¦ β true
β β e08d9394-cbc8β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 5eef9108-6811-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 4aa05d3a-0300β¦ β\n",
+ "β eb9f314e-1184-β¦ β POLYGON((112.β¦ β {xmin: 112.15β¦ β β¦ β true
β β aa2561c6-a578β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β fe123780-bf85-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 63c6570b-70fdβ¦ β\n",
+ "β 89fbee90-bca0-β¦ β MULTIPOLYGON(β¦ β {xmin: 112.15β¦ β β¦ β true
β β 1cf6b19e-756fβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β c0f0c861-a3bc-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β c3fc4642-f97bβ¦ β\n",
+ "β 758c0e1e-67aa-β¦ β POLYGON((112.β¦ β {xmin: 112.27β¦ β β¦ β true
β β 505f563f-7aa3β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β a57076cb-c74d-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 5d206247-f4b2β¦ β\n",
+ "β e5d4c707-66d7-β¦ β POLYGON((109.β¦ β {xmin: 109.64β¦ β β¦ β true
β CN-HI β 86939aee-1fbdβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β d86411e8-02a1-β¦ β POLYGON((-82.β¦ β {xmin: -82.40β¦ β β¦ β true
β PA-4 β c5564623-b42eβ¦ β\n",
+ "β 26015e14-62ae-β¦ β POLYGON((109.β¦ β {xmin: 109.66β¦ β β¦ β true
β CN-HI β ed052bae-e26fβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β d13f593f-7fde-β¦ β POLYGON((-82.β¦ β {xmin: -82.39β¦ β β¦ β true
β PA-4 β b02aa2a3-3889β¦ β\n",
+ "β eb42fd17-ad1e-β¦ β POLYGON((109.β¦ β {xmin: 109.83β¦ β β¦ β true
β CN-HI β 201eeb03-4f5aβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 3598138e-788a-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 6700edfc-96e5β¦ β\n",
+ "β d63e1220-a308-β¦ β POLYGON((109.β¦ β {xmin: 109.90β¦ β β¦ β true
β CN-HI β 71e30c32-2bc1β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β a5cecb4f-d6d1-β¦ β POLYGON((-82.β¦ β {xmin: -82.38β¦ β β¦ β true
β PA-4 β 9f24a80b-355dβ¦ β\n",
+ "β e62cef5e-6768-β¦ β POLYGON((109.β¦ β {xmin: 109.74β¦ β β¦ β true
β CN-HI β 24478621-6802β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β a4d912fc-69d9-β¦ β POLYGON((-82.β¦ β {xmin: -82.37β¦ β β¦ β true
β PA-4 β 65786eba-d8fdβ¦ β\n",
+ "β c6fcbed1-ad8d-β¦ β POLYGON((110.β¦ β {xmin: 110.00β¦ β β¦ β true
β CN-HI β ac0f434d-1e10β¦ β\n",
"βββββββββββββββββββ΄βββββββββββββββββ΄βββββββββββββββββ΄ββββ΄βββββββββββββββββ΄βββββββββ΄βββββββββββββββββ\n"
]
}
@@ -316,7 +316,7 @@
},
{
"cell_type": "code",
- "execution_count": 10,
+ "execution_count": 11,
"id": "03b951de-3397-4fcf-9baf-50e139a38dd4",
"metadata": {},
"outputs": [],
@@ -326,7 +326,7 @@
},
{
"cell_type": "code",
- "execution_count": 11,
+ "execution_count": 12,
"id": "9c6bd69d-9407-432a-bdc8-d60976237a3a",
"metadata": {},
"outputs": [
@@ -353,7 +353,7 @@
},
{
"cell_type": "code",
- "execution_count": 12,
+ "execution_count": 13,
"id": "75a6d0ed-9767-4d36-a77a-4afb7952fbe4",
"metadata": {},
"outputs": [
@@ -376,7 +376,7 @@
" division_id: utf8<Utf8View>"
]
},
- "execution_count": 12,
+ "execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
@@ -387,7 +387,7 @@
},
{
"cell_type": "code",
- "execution_count": 13,
+ "execution_count": 14,
"id": "f1f7158c-ef2b-4377-9bee-180309ddd553",
"metadata": {},
"outputs": [],
@@ -410,7 +410,7 @@
},
{
"cell_type": "code",
- "execution_count": 14,
+ "execution_count": 15,
"id": "27e6909d-06fa-438b-88e0-d300fd2fb1ec",
"metadata": {},
"outputs": [],
@@ -420,7 +420,7 @@
},
{
"cell_type": "code",
- "execution_count": 15,
+ "execution_count": 16,
"id": "2dec92d8-a374-4021-990a-e50f5769516e",
"metadata": {},
"outputs": [],
@@ -434,7 +434,7 @@
},
{
"cell_type": "code",
- "execution_count": 16,
+ "execution_count": 17,
"id": "7f39a283-0eee-4f72-a30a-8dd9fa1aaa69",
"metadata": {
"scrolled": true
@@ -452,8 +452,8 @@
"ββββββββββββββββββββββββββΌβββββββββββββββββββββββββΌβββββββββββββββββββββββββΌββββββββββββββββββββββββ€\n",
"β Mud Island β β
β POLYGON((-66.0222822β¦ β\n",
"ββββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄ββββββββββββββββββββββββ\n",
- "CPU times: user 1.2 ms, sys: 844 ΞΌs, total: 2.04 ms\n",
- "Wall time: 2.03 ms\n"
+ "CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms\n",
+ "Wall time: 2.54 ms\n"
]
}
],
@@ -462,11 +462,60 @@
"# this executes quickly because the Nova Scotia data was persisted in
memory with `to_memtable()`\n",
"df.show(2)"
]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "fc1d2023-c83a-4010-808b-212161b1b577",
+ "metadata": {},
+ "source": [
+ "## Visualize the results with lonboard"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 18,
+ "id": "f78583fd-a73a-4169-9c45-74d8026bb5fb",
+ "metadata": {
+ "collapsed": true,
+ "jupyter": {
+ "outputs_hidden": true
+ }
+ },
+ "outputs": [
+ {
+ "data": {
+ "application/vnd.jupyter.widget-view+json": {
+ "model_id": "0dec2568b9e9420da04da4bf04eedc94",
+ "version_major": 2,
+ "version_minor": 1
+ },
+ "text/plain": [
+ "Map(basemap_style=<CartoBasemap.DarkMatter:
'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'β¦"
+ ]
+ },
+ "execution_count": 18,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "import lonboard\n",
+ "\n",
+ "lonboard.viz(df)"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "0f668f51-462e-4e18-b774-c047140b224a",
+ "metadata": {},
+ "source": [
+ ""
+ ]
}
],
"metadata": {
"kernelspec": {
- "display_name": ".venv (3.13.3)",
+ "display_name": "Python 3 (ipykernel)",
"language": "python",
"name": "python3"
},
@@ -480,7 +529,7 @@
"name": "python",
"nbconvert_exporter": "python",
"pygments_lexer": "ipython3",
- "version": "3.13.3"
+ "version": "3.12.4"
}
},
"nbformat": 4,
diff --git a/0.1.0/overture-examples/index.html
b/0.1.0/overture-examples/index.html
index 0f11969..424b250 100644
--- a/0.1.0/overture-examples/index.html
+++ b/0.1.0/overture-examples/index.html
@@ -918,6 +918,15 @@
</span>
</a>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#visualize-the-results-with-lonboard" class="md-nav__link">
+ <span class="md-ellipsis">
+ Visualize the results with lonboard
+ </span>
+ </a>
+
</li>
</ul>
@@ -959,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>
@@ -982,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>
@@ -1021,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="">
@@ -1037,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>
@@ -1533,6 +1565,15 @@
</span>
</a>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#visualize-the-results-with-lonboard" class="md-nav__link">
+ <span class="md-ellipsis">
+ Visualize the results with lonboard
+ </span>
+ </a>
+
</li>
</ul>
@@ -1604,25 +1645,25 @@
β id β geometry
β β¦ β roof_height β
β utf8 β geometry
β β float64 β
ββββββββββββββββββββββββββββββββββββββββͺββββββββββββββββββββββββββββββββββββββββββͺββββͺββββββββββββββ‘
-β 76045c54-bd50-415b-9ac8-35cfc22fe80f β POLYGON((-105.7936939
25.7460051,-105.β¦ β β¦ β β
+β 97a89436-5295-417e-bde1-2dbf8fe10700 β POLYGON((-107.0377042
28.8102782,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β f1eb3f3e-c9b9-40af-b83e-7f2c09ef8e43 β POLYGON((-105.7971397
25.7517374,-105.β¦ β β¦ β β
+β e09fcdeb-65ab-443c-bc59-4f9acf32af17 β POLYGON((-107.0372022
28.8103812,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β f6019f66-3137-4e62-9d84-e4f4febe2f6d β POLYGON((-105.7928137
25.7493614,-105.β¦ β β¦ β β
+β cb06e75f-66a0-40ca-9029-e1a24dff1434 β POLYGON((-107.0372848
28.8104923,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β 37b96ac3-0093-47d4-a898-263f6550ef14 β POLYGON((-105.7857365
25.7465883,-105.β¦ β β¦ β β
+β 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 β POLYGON((-107.0371986
28.8104859,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β e686ab8d-7062-4c0a-a8da-32ab751f7212 β POLYGON((-105.7579541
25.7150521,-105.β¦ β β¦ β β
+β 1a4fba29-6160-4a98-b8f7-03395fd6466a β POLYGON((-107.0373331
28.8105281,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β 767a736b-ac77-4427-89f0-3f9544b1e9e9 β POLYGON((-105.7576387
25.7149905,-105.β¦ β β¦ β β
+β 9de2d803-ab58-46e1-9a35-7423f8d0d121 β POLYGON((-107.0378928
28.8112268,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β db3a2233-a7cb-425a-ac75-ad83cf868a32 β POLYGON((-105.7589831
25.71648,-105.75β¦ β β¦ β β
+β 1704c72b-6f2b-445b-b9a3-36fdd0c74233 β POLYGON((-107.0376099
28.8112085,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β 53866308-afc7-4ff1-88f6-b2af571238e3 β POLYGON((-105.76268
25.7197151,-105.76β¦ β β¦ β β
+β b30bf41d-479f-4ee5-bd45-d4e17ffd8875 β POLYGON((-107.0377094
28.8115554,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β 31d8f64e-b7f9-4b26-8c2a-2fd205fed995 β POLYGON((-105.7626968
25.7197994,-105.β¦ β β¦ β β
+β c88928d4-b165-4335-9bd8-ccc5c9f79cee β POLYGON((-107.0374986
28.8111847,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
-β 72ec6ed0-d33c-4e64-8c8f-28e7a6ac6310 β POLYGON((-105.7578861
25.7190388,-105.β¦ β β¦ β β
+β ca1000b0-6af3-47fc-bdf2-61e8b1b716fc β POLYGON((-107.0370972
28.8115247,-107.β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββ΄ββββ΄ββββββββββββββ
</code></pre></div>
@@ -1727,25 +1768,25 @@
<span class="err">β</span><span class="w"> </span><span
class="n">id</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span
class="n">geometry</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span
class="n">bbox</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span cl
[...]
<span class="err">β</span><span class="w"> </span><span
class="n">utf8</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span
class="n">geometry</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span
class="k">struct</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">boolean</span><span class="w"> </ [...]
<span
class="err">βββββββββββββββββββͺβββββββββββββββββͺβββββββββββββββββͺββββͺβββββββββββββββββͺβββββββββͺβββββββββββββββββ‘</span>
-<span class="err">β</span><span class="w"> </span><span
class="mh">6</span><span class="n">dd2a4d4</span><span class="o">-</span><span
class="mf">542f</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">cd743a89</span><span class="o">-</span><span
class="mh">9507</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">111.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="mh">5</span><span class="n">eef9108</span><span class="o">-</span><span
class="mh">6811</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">eb9f314e</span><span class="o">-</span><span
class="mh">1184</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">112.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">fe123780</span><span class="o">-</span><span
class="n">bf85</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="mf">89f</span><span class="n">bee90</span><span class="o">-</span><span
class="n">bca0</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">MULTIPOLYGON</span><span class="p">(</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="p">{</span><span class="nl">xmin:</span> [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">c0f0c861</span><span class="o">-</span><span
class="n">a3bc</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="mh">758</span><span class="n">c0e1e</span><span class="o">-</span><span
class="mh">67</span><span class="n">aa</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="mf">112.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">a57076cb</span><span class="o">-</span><span
class="n">c74d</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">e5d4c707</span><span class="o">-</span><span
class="mh">66</span><span class="n">d7</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="mf">109.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">d86411e8</span><span class="o">-</span><span
class="mh">02</span><span class="n">a1</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="o">-</span><span class="mf">82.</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="mf">26015e14</span><span class="o">-</span><span
class="mh">62</span><span class="n">ae</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="mf">109.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><spa [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">d13f593f</span><span class="o">-</span><span
class="mf">7f</span><span class="n">de</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="o">-</span><span class="mf">82.</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">eb42fd17</span><span class="o">-</span><span
class="n">ad1e</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">109.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span> [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="mf">3598138e-788</span><span class="n">a</span><span
class="o">-</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="n">POLYGON</span><span
class="p">((</span><span class="o">-</span><span class="mf">82.</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="p">{</span><span class="nl">xmin:</span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">d63e1220</span><span class="o">-</span><span
class="n">a308</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">109.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span> [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">a5cecb4f</span><span class="o">-</span><span
class="n">d6d1</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span class="o">-</span><span
class="mf">82.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">e62cef5e</span><span class="o">-</span><span
class="mh">6768</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">109.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span [...]
<span
class="err">βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€</span>
-<span class="err">β</span><span class="w"> </span><span
class="n">a4d912fc</span><span class="o">-</span><span
class="mh">69</span><span class="n">d9</span><span class="o">-</span><span
class="err">β¦</span><span class="w"> </span><span class="err">β</span><span
class="w"> </span><span class="n">POLYGON</span><span class="p">((</span><span
class="o">-</span><span class="mf">82.</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span [...]
+<span class="err">β</span><span class="w"> </span><span
class="n">c6fcbed1</span><span class="o">-</span><span
class="n">ad8d</span><span class="o">-</span><span class="err">β¦</span><span
class="w"> </span><span class="err">β</span><span class="w"> </span><span
class="n">POLYGON</span><span class="p">((</span><span
class="mf">110.</span><span class="err">β¦</span><span class="w"> </span><span
class="err">β</span><span class="w"> </span><span class="p">{</span><span
class="nl">xmin:</span> [...]
<span
class="err">βββββββββββββββββββ΄βββββββββββββββββ΄βββββββββββββββββ΄ββββ΄βββββββββββββββββ΄βββββββββ΄βββββββββββββββββ</span>
</code></pre></div>
@@ -1818,10 +1859,20 @@
ββββββββββββββββββββββββββΌβββββββββββββββββββββββββΌβββββββββββββββββββββββββΌββββββββββββββββββββββββ€
β Mud Island β β β
POLYGON((-66.0222822β¦ β
ββββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄ββββββββββββββββββββββββ
-CPU times: user 1.2 ms, sys: 844 ΞΌs, total: 2.04 ms
-Wall time: 2.03 ms
+CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms
+Wall time: 2.54 ms
+</code></pre></div>
+
+<h2 id="visualize-the-results-with-lonboard">Visualize the results with
lonboard<a class="headerlink" href="#visualize-the-results-with-lonboard"
title="Permanent link">ΒΆ</a></h2>
+<div class="highlight"><pre><span></span><code><span
class="kn">import</span><span class="w"> </span><span class="nn">lonboard</span>
+
+<span class="n">lonboard</span><span class="o">.</span><span
class="n">viz</span><span class="p">(</span><span class="n">df</span><span
class="p">)</span>
+</code></pre></div>
+<div
class="codehilite"><pre><span></span><code>Map(basemap_style=<CartoBasemap.DarkMatter:
'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'β¦
</code></pre></div>
+<p><a class="glightbox" data-type="image" data-width="100%" data-height="auto"
href="../image/lonboard_ns.png" data-desc-position="bottom"><img alt="Lonboard
NS" src="../image/lonboard_ns.png"></a></p>
+
@@ -1841,7 +1892,7 @@ Wall time: 2.03 ms
<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 24, 2025 01:21:10
UTC">September 24, 2025 01:21:10</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="September 24, 2025 07:47:59
UTC">September 24, 2025 07:47:59</span>
</span>
diff --git a/0.1.0/programming-guide/index.html
b/0.1.0/programming-guide/index.html
index 21ebf15..9e995fa 100644
--- a/0.1.0/programming-guide/index.html
+++ b/0.1.0/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/0.1.0/quickstart-python/index.html
b/0.1.0/quickstart-python/index.html
index 844ddd0..026b302 100644
--- a/0.1.0/quickstart-python/index.html
+++ b/0.1.0/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/0.1.0/reference/python/index.html
b/0.1.0/reference/python/index.html
index 542debc..ad680db 100644
--- a/0.1.0/reference/python/index.html
+++ b/0.1.0/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/0.1.0/reference/sql-joins/index.html
b/0.1.0/reference/sql-joins/index.html
index 23eb5a7..bce43a2 100644
--- a/0.1.0/reference/sql-joins/index.html
+++ b/0.1.0/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/0.1.0/reference/sql/index.html b/0.1.0/reference/sql/index.html
index c2f08b8..35a7b11 100644
--- a/0.1.0/reference/sql/index.html
+++ b/0.1.0/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/0.1.0/requirements.txt b/0.1.0/requirements.txt
index 5a5444b..6bd80c3 100644
--- a/0.1.0/requirements.txt
+++ b/0.1.0/requirements.txt
@@ -26,3 +26,4 @@ mkdocstrings[python]
nbconvert
pyproj
ruff
+lonboard
diff --git a/0.1.0/search/search_index.json b/0.1.0/search/search_index.json
index 5f9e782..679c683 100644
--- a/0.1.0/search/search_index.json
+++ b/0.1.0/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/0.1.0/sitemap.xml b/0.1.0/sitemap.xml
index e16f100..77d0e1f 100644
--- a/0.1.0/sitemap.xml
+++ b/0.1.0/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/0.1.0/sitemap.xml.gz b/0.1.0/sitemap.xml.gz
index 5e1c00a..1506e45 100644
Binary files a/0.1.0/sitemap.xml.gz and b/0.1.0/sitemap.xml.gz differ
diff --git a/0.1.0/stylesheets/extra.css b/0.1.0/stylesheets/extra.css
index f017b44..5cd0bcf 100644
--- a/0.1.0/stylesheets/extra.css
+++ b/0.1.0/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/0.1.0/working-with-parquet-files/index.html
b/0.1.0/working-with-parquet-files/index.html
index eb57fc9..0c7cea5 100644
--- a/0.1.0/working-with-parquet-files/index.html
+++ b/0.1.0/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/0.1.0/working-with-parquet-files/index.html
b/0.1.0/working-with-sql-sedonadb/index.html
similarity index 78%
copy from 0.1.0/working-with-parquet-files/index.html
copy to 0.1.0/working-with-sql-sedonadb/index.html
index eb57fc9..5fbb06e 100644
--- a/0.1.0/working-with-parquet-files/index.html
+++ b/0.1.0/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>
