You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sedona.apache.org by gi...@apache.org on 2025/11/03 20:19:59 UTC
(sedona-db) branch asf-site updated: Deployed e531723 to latest-snapshot with MkDocs 1.6.1 and mike 2.1.3
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 75563a1 Deployed e531723 to latest-snapshot with MkDocs 1.6.1 and mike 2.1.3
75563a1 is described below
commit 75563a1f337e9fa00a988a774a5a266c87853896
Author: GitHub Actions <ac...@github.com>
AuthorDate: Mon Nov 3 20:19:54 2025 +0000
Deployed e531723 to latest-snapshot with MkDocs 1.6.1 and mike 2.1.3
---
latest-snapshot/404.html | 178 ++++--
latest-snapshot/contributors-guide/index.html | 341 ++++++-----
latest-snapshot/crs-examples/index.html | 289 +++++----
latest-snapshot/delta-lake.ipynb | 425 +++++++++++++
.../{quickstart-python => delta-lake}/index.html | 663 ++++++++++++---------
latest-snapshot/geopandas-interop/index.html | 289 +++++----
latest-snapshot/index.html | 187 ++++--
latest-snapshot/overture-examples/index.html | 283 +++++----
latest-snapshot/programming-guide/index.html | 193 ++++--
latest-snapshot/quickstart-python/index.html | 187 ++++--
latest-snapshot/reference/python/index.html | 367 +++++++-----
latest-snapshot/reference/sql-joins/index.html | 379 +++++++-----
latest-snapshot/reference/sql/index.html | 361 ++++++-----
latest-snapshot/search/search_index.json | 2 +-
latest-snapshot/sitemap.xml | 4 +
latest-snapshot/sitemap.xml.gz | Bin 323 -> 331 bytes
.../working-with-parquet-files/index.html | 281 +++++----
.../working-with-sql-sedonadb/index.html | 317 ++++++----
18 files changed, 3147 insertions(+), 1599 deletions(-)
diff --git a/latest-snapshot/404.html b/latest-snapshot/404.html
index f0d71ba..1723858 100644
--- a/latest-snapshot/404.html
+++ b/latest-snapshot/404.html
@@ -655,22 +655,42 @@
- <li class="md-nav__item">
- <a href="/sedonadb/latest/geopandas-interop/" class="md-nav__link">
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4" >
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="0">
+
<span class="md-ellipsis">
- GeoPandas interop
+ API
</span>
- </a>
- </li>
-
-
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -679,12 +699,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/overture-examples/" class="md-nav__link">
+ <a href="/sedonadb/latest/reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ Python
</span>
@@ -702,12 +722,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/crs-examples/" class="md-nav__link">
+ <a href="/sedonadb/latest/reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- CRS Examples
+ SQL
</span>
@@ -725,12 +745,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/working-with-parquet-files/" class="md-nav__link">
+ <a href="/sedonadb/latest/reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Spatial Joins
</span>
@@ -741,6 +761,57 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" >
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="0">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
@@ -748,12 +819,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="/sedonadb/latest/geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ GeoPandas interop
</span>
@@ -771,12 +842,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/contributors-guide/" class="md-nav__link">
+ <a href="/sedonadb/latest/overture-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Overture Examples
</span>
@@ -793,42 +864,22 @@
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--nested">
-
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10" >
+ <li class="md-nav__item">
+ <a href="/sedonadb/latest/crs-examples/" class="md-nav__link">
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="0">
-
<span class="md-ellipsis">
- API
+ CRS Examples
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
+ </a>
+ </li>
+
+
+
@@ -837,12 +888,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/reference/python/" class="md-nav__link">
+ <a href="/sedonadb/latest/delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Python
+ Delta Lake
</span>
@@ -860,12 +911,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/reference/sql/" class="md-nav__link">
+ <a href="/sedonadb/latest/working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with Parquet Files
</span>
@@ -883,12 +934,12 @@
<li class="md-nav__item">
- <a href="/sedonadb/latest/reference/sql-joins/" class="md-nav__link">
+ <a href="/sedonadb/latest/working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Working with SQL in SedonaDB
</span>
@@ -907,6 +958,29 @@
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="/sedonadb/latest/contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
</ul>
</nav>
diff --git a/latest-snapshot/contributors-guide/index.html b/latest-snapshot/contributors-guide/index.html
index 6c2ce6a..7ffa7d9 100644
--- a/latest-snapshot/contributors-guide/index.html
+++ b/latest-snapshot/contributors-guide/index.html
@@ -13,8 +13,6 @@
<link rel="prev" href="../working-with-sql-sedonadb/">
- <link rel="next" href="../reference/python/">
-
<link rel="icon" href="../image/sedona_logo_symbol.png">
<meta name="generator" content="mkdocs-1.6.1, mkdocs-material-9.6.23">
@@ -681,6 +679,175 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/python/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Python
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ SQL
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql-joins/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Spatial Joins
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../geopandas-interop/" class="md-nav__link">
@@ -750,6 +917,29 @@
+ <li class="md-nav__item">
+ <a href="../delta-lake/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../working-with-parquet-files/" class="md-nav__link">
@@ -790,6 +980,14 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
@@ -1021,129 +1219,6 @@
</li>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
-
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
-
-
- <span class="md-ellipsis">
- API
-
- </span>
-
-
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Python
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- SQL
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Spatial Joins
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
- </ul>
- </nav>
-
- </li>
-
-
</ul>
@@ -1739,22 +1814,6 @@ cargo<span class="w"> </span>bench
</a>
-
- <a href="../reference/python/" class="md-footer__link md-footer__link--next" aria-label="Next: Python">
- <div class="md-footer__title">
- <span class="md-footer__direction">
- Next
- </span>
- <div class="md-ellipsis">
- Python
- </div>
- </div>
- <div class="md-footer__button md-icon">
-
- <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M4 11v2h12l-5.5 5.5 1.42 1.42L19.84 12l-7.92-7.92L10.5 5.5 16 11z"></path></svg>
- </div>
- </a>
-
</nav>
diff --git a/latest-snapshot/crs-examples/index.html b/latest-snapshot/crs-examples/index.html
index 1277831..40e9121 100644
--- a/latest-snapshot/crs-examples/index.html
+++ b/latest-snapshot/crs-examples/index.html
@@ -13,7 +13,7 @@
<link rel="prev" href="../overture-examples/">
- <link rel="next" href="../working-with-parquet-files/">
+ <link rel="next" href="../delta-lake/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -681,6 +681,177 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/python/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Python
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ SQL
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql-joins/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Spatial Joins
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../geopandas-interop/" class="md-nav__link">
@@ -835,12 +1006,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Delta Lake
</span>
@@ -858,12 +1029,12 @@
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ Working with Parquet Files
</span>
@@ -881,12 +1052,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Working with SQL in SedonaDB
</span>
@@ -897,93 +1068,9 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+ </ul>
+ </nav>
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
-
-
- <span class="md-ellipsis">
- API
-
- </span>
-
-
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Python
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- SQL
-
- </span>
-
-
- </a>
</li>
@@ -996,12 +1083,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -1018,14 +1105,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-
@@ -1522,13 +1601,13 @@
- <a href="../working-with-parquet-files/" class="md-footer__link md-footer__link--next" aria-label="Next: Working with Parquet Files">
+ <a href="../delta-lake/" class="md-footer__link md-footer__link--next" aria-label="Next: Delta Lake">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- Working with Parquet Files
+ Delta Lake
</div>
</div>
<div class="md-footer__button md-icon">
diff --git a/latest-snapshot/delta-lake.ipynb b/latest-snapshot/delta-lake.ipynb
new file mode 100644
index 0000000..c156a0f
--- /dev/null
+++ b/latest-snapshot/delta-lake.ipynb
@@ -0,0 +1,425 @@
+{
+ "cells": [
+ {
+ "cell_type": "markdown",
+ "id": "3425268d-6430-4e52-9019-969d61ef5458",
+ "metadata": {},
+ "source": [
+ "# SedonaDB + Delta Lake\n",
+ "\n",
+ "This page shows how to read and write Delta Lake tables with SedonaDB.\n",
+ "\n",
+ "Make sure you run `pip install deltalake` to run the code snippets below."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 42,
+ "id": "83f5ca25-8059-4624-bd00-e44cd172d9c2",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "from deltalake import write_deltalake, DeltaTable\n",
+ "import sedona.db\n",
+ "import pyarrow.compute as pc\n",
+ "\n",
+ "sd = sedona.db.connect()"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "1a90b1bf-99f9-4f50-987b-f1f30bf9988a",
+ "metadata": {},
+ "source": [
+ "Read in a GeoParquet dataset into a SedonaDB DataFrame."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 43,
+ "id": "a37f3a30-3267-4bfc-8e5b-e234053927af",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "countries = sd.read_parquet(\n",
+ " \"https://raw.githubusercontent.com/geoarrow/geoarrow-data/v0.2.0/natural-earth/files/natural-earth_countries_geo.parquet\"\n",
+ ")"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "1f82b047-8182-4120-82d7-945ff38ecbca",
+ "metadata": {},
+ "source": [
+ "## Create a Delta Lake table with WKT\n",
+ "\n",
+ "Now write the DataFrame to a Delta Lake table. Notice that you must convert the geometry column to Well-Known Text (WKT) or Well-Known Binary (WKB) before writing to the Delta table.\n",
+ "\n",
+ "Delta Lake does not support geometry columns.\n",
+ "\n",
+ "This example shows how to create a Delta table with a WKT column. The section that follows shows how to create a Delta table with a WKB column."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 44,
+ "id": "35bdc296-d9ef-4ea2-9ba5-dac1cfd115ef",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "countries.to_view(\"countries\", True)\n",
+ "df = sd.sql(\n",
+ " \"select name, continent, ST_AsText(geometry) as geometry_wkt from countries\"\n",
+ ")\n",
+ "table_path = \"/tmp/delta_with_wkt\"\n",
+ "write_deltalake(table_path, df.to_pandas(), mode=\"overwrite\")"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "974a5558-fb18-49b7-a304-fa93bdd363e8",
+ "metadata": {},
+ "source": [
+ "## Read Delta table into SedonaDB\n",
+ "\n",
+ "Now read the Delta table back into a SedonaDB DataFrame."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 45,
+ "id": "c15d4605-483a-4041-973a-547098bdeef4",
+ "metadata": {},
+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "┌─────────────────────────────┬───────────────┬────────────────────────────────────────────────────┐\n",
+ "│ name ┆ continent ┆ geometry_wkt │\n",
+ "│ utf8 ┆ utf8 ┆ utf8 │\n",
+ "╞═════════════════════════════╪═══════════════╪════════════════════════════════════════════════════╡\n",
+ "│ Fiji ┆ Oceania ┆ MULTIPOLYGON(((180 -16.067132663642447,180 -16.55… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ United Republic of Tanzania ┆ Africa ┆ POLYGON((33.90371119710453 -0.9500000000000001,34… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Western Sahara ┆ Africa ┆ POLYGON((-8.665589565454809 27.656425889592356,-8… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Canada ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ United States of America ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Kazakhstan ┆ Asia ┆ POLYGON((87.35997033076265 49.21498078062912,86.5… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Uzbekistan ┆ Asia ┆ POLYGON((55.96819135928291 41.30864166926936,55.9… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Papua New Guinea ┆ Oceania ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Indonesia ┆ Asia ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Argentina ┆ South America ┆ MULTIPOLYGON(((-68.63401022758323 -52.63637045887… │\n",
+ "└─────────────────────────────┴───────────────┴────────────────────────────────────────────────────┘\n"
+ ]
+ }
+ ],
+ "source": [
+ "dt = DeltaTable(table_path)\n",
+ "arrow_table = dt.to_pyarrow_table()\n",
+ "df = sd.create_data_frame(arrow_table)\n",
+ "df.show()"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "a44fd9bd-85d2-4f1b-9df4-cc98ac6223f0",
+ "metadata": {},
+ "source": [
+ "Notice that the `geometry_wkt` column is `utf8`. It's not a geometry column.\n",
+ "\n",
+ "Let's convert the `geometry_wkt` column to a geometry column."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 46,
+ "id": "9052c4af-4478-4038-81ae-cf9c0ba84345",
+ "metadata": {},
+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "┌─────────────────────────────┬───────────────┬────────────────────────────────────────────────────┐\n",
+ "│ name ┆ continent ┆ geom │\n",
+ "│ utf8 ┆ utf8 ┆ geometry │\n",
+ "╞═════════════════════════════╪═══════════════╪════════════════════════════════════════════════════╡\n",
+ "│ Fiji ┆ Oceania ┆ MULTIPOLYGON(((180 -16.067132663642447,180 -16.55… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ United Republic of Tanzania ┆ Africa ┆ POLYGON((33.90371119710453 -0.9500000000000001,34… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Western Sahara ┆ Africa ┆ POLYGON((-8.665589565454809 27.656425889592356,-8… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Canada ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ United States of America ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Kazakhstan ┆ Asia ┆ POLYGON((87.35997033076265 49.21498078062912,86.5… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Uzbekistan ┆ Asia ┆ POLYGON((55.96819135928291 41.30864166926936,55.9… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Papua New Guinea ┆ Oceania ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Indonesia ┆ Asia ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Argentina ┆ South America ┆ MULTIPOLYGON(((-68.63401022758323 -52.63637045887… │\n",
+ "└─────────────────────────────┴───────────────┴────────────────────────────────────────────────────┘\n"
+ ]
+ }
+ ],
+ "source": [
+ "df.to_view(\"my_table\", True)\n",
+ "res = sd.sql(\"\"\"\n",
+ "SELECT\n",
+ " name,\n",
+ " continent,\n",
+ " ST_GeomFromWKT(geometry_wkt) as geom\n",
+ "from my_table\n",
+ "\"\"\")\n",
+ "res.show()"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "802be3a7-5b1d-4f02-85f9-9460743a921d",
+ "metadata": {},
+ "source": [
+ "Confirm the schema of the DataFrame."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 47,
+ "id": "5758bfec-86c0-4a14-8e4e-201149a59fac",
+ "metadata": {},
+ "outputs": [
+ {
+ "data": {
+ "text/plain": [
+ "SedonaSchema with 3 fields:\n",
+ " name: utf8<Utf8>\n",
+ " continent: utf8<Utf8>\n",
+ " geom: geometry<Wkb>"
+ ]
+ },
+ "execution_count": 47,
+ "metadata": {},
+ "output_type": "execute_result"
+ }
+ ],
+ "source": [
+ "res.schema"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "7c975e52-5b2d-4ee9-a7c6-51cb3304c0d6",
+ "metadata": {},
+ "source": [
+ "## Filter countries in a particular geographic region\n",
+ "\n",
+ "Now, let's grab some countries in the western portion of South America using a polygon region.\n",
+ "\n",
+ "SedonaDB can run these types of queries on geometric data."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 48,
+ "id": "c210e29a-170b-4a01-b464-c7d2f79998eb",
+ "metadata": {},
+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "┌──────────┬───────────────┬───────────────────────────────────────────────────────────────────────┐\n",
+ "│ name ┆ continent ┆ geom │\n",
+ "│ utf8 ┆ utf8 ┆ geometry │\n",
+ "╞══════════╪═══════════════╪═══════════════════════════════════════════════════════════════════════╡\n",
+ "│ Chile ┆ South America ┆ MULTIPOLYGON(((-68.63401022758323 -52.63637045887449,-68.63335000000… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Peru ┆ South America ┆ POLYGON((-69.89363521999663 -4.2981869441943275,-70.7947688463023 -4… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Colombia ┆ South America ┆ POLYGON((-66.87632585312258 1.253360500489336,-67.0650481838525 1.13… │\n",
+ "├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Ecuador ┆ South America ┆ POLYGON((-75.37322323271385 -0.1520317521204504,-75.23372270374195 -… │\n",
+ "└──────────┴───────────────┴───────────────────────────────────────────────────────────────────────┘\n"
+ ]
+ }
+ ],
+ "source": [
+ "res = sd.sql(\"\"\"\n",
+ "SELECT\n",
+ " name,\n",
+ " continent,\n",
+ " ST_GeomFromWKT(geometry_wkt) as geom\n",
+ "FROM my_table\n",
+ "WHERE ST_Intersects(\n",
+ " ST_GeomFromWKT(geometry_wkt),\n",
+ " ST_GeomFromWKT('POLYGON((-81 5, -75 5, -75 -56, -81 -56, -81 5))')\n",
+ ")\n",
+ "\"\"\")\n",
+ "res.show()"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "996a56e2-a5b6-42f8-88b0-90d3a0c4c30c",
+ "metadata": {},
+ "source": [
+ "## Create a Delta Lake table with WKB\n",
+ "\n",
+ "You can also create a Delta table with WKB.\n",
+ "\n",
+ "WKB is binary, can be compressed more effectively than WKT, and results in smaller file sizes.\n",
+ "\n",
+ "The following example shows how to store the cities dataset in a Delta table with the geometry data stored as WKB.\n",
+ "\n",
+ "It also demonstrates how to add a `bbox` column to the Delta table, enabling more efficient filtering."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 49,
+ "id": "143a8485-773f-4b94-b487-40ad63706669",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "cities = sd.read_parquet(\n",
+ " \"https://raw.githubusercontent.com/geoarrow/geoarrow-data/v0.2.0/natural-earth/files/natural-earth_cities_geo.parquet\"\n",
+ ")\n",
+ "cities.to_view(\"cities\", True)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 50,
+ "id": "36bce474-51b8-468e-931e-347c19624221",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "df = sd.sql(\"\"\"\n",
+ "select \n",
+ " name, \n",
+ " ST_AsBinary(geometry) as geometry_wkb,\n",
+ " STRUCT(\n",
+ " ST_XMin(geometry) as xmin,\n",
+ " ST_YMin(geometry) as ymin,\n",
+ " ST_XMax(geometry) as xmax,\n",
+ " ST_YMax(geometry) as ymax\n",
+ " ) as bbox\n",
+ "from cities\n",
+ "\"\"\")\n",
+ "table_path = \"/tmp/delta_with_wkb\"\n",
+ "write_deltalake(table_path, df.to_pandas(), mode=\"overwrite\", schema_mode=\"overwrite\")"
+ ]
+ },
+ {
+ "cell_type": "markdown",
+ "id": "cfb1739c-6e60-4330-be98-48b2faa4c6cf",
+ "metadata": {},
+ "source": [
+ "Read the Delta table and filter it to only include cities in the eastern half of North America."
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 51,
+ "id": "590d056d-60bb-4637-9981-eea721c559a2",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "dt = DeltaTable(table_path)\n",
+ "dataset = dt.to_pyarrow_dataset()\n",
+ "filter_expr = (\n",
+ " (pc.field(\"bbox\", \"xmax\") >= -97.0)\n",
+ " & (pc.field(\"bbox\", \"xmin\") <= -67.0)\n",
+ " & (pc.field(\"bbox\", \"ymax\") >= 25.0)\n",
+ " & (pc.field(\"bbox\", \"ymin\") <= 50.0)\n",
+ ")\n",
+ "filtered_table = dataset.to_table(filter=filter_expr)"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 52,
+ "id": "65578ebb-4797-4aaa-9377-87893f9a7694",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "df = sd.create_data_frame(filtered_table.to_pandas())"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 53,
+ "id": "a0cb1afd-153b-413d-8f04-0d533e717b30",
+ "metadata": {},
+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "┌──────────────────┬──────────────────────────────────────────────┐\n",
+ "│ name ┆ geom │\n",
+ "│ utf8 ┆ geometry │\n",
+ "╞══════════════════╪══════════════════════════════════════════════╡\n",
+ "│ Ottawa ┆ POINT(-75.7019612 45.4186427) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Nassau ┆ POINT(-77.3500438 25.0833901) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Houston ┆ POINT(-95.34843625672217 29.741272831862542) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Miami ┆ POINT(-80.2260519 25.7895566) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Atlanta ┆ POINT(-84.36764186571386 33.73945728378348) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Chicago ┆ POINT(-87.63523655322338 41.847961283364114) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Toronto ┆ POINT(-79.38945855491194 43.66464454743429) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ Washington, D.C. ┆ POINT(-77.0113644 38.9014952) │\n",
+ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
+ "│ New York ┆ POINT(-73.99571754361698 40.72156174972766) │\n",
+ "└──────────────────┴──────────────────────────────────────────────┘\n"
+ ]
+ }
+ ],
+ "source": [
+ "df.to_view(\"us_east_cities\", True)\n",
+ "sd.sql(\"select name, ST_GeomFromWKB(geometry_wkb) as geom from us_east_cities\").show()"
+ ]
+ }
+ ],
+ "metadata": {
+ "kernelspec": {
+ "display_name": "Python 3 (ipykernel)",
+ "language": "python",
+ "name": "python3"
+ },
+ "language_info": {
+ "codemirror_mode": {
+ "name": "ipython",
+ "version": 3
+ },
+ "file_extension": ".py",
+ "mimetype": "text/x-python",
+ "name": "python",
+ "nbconvert_exporter": "python",
+ "pygments_lexer": "ipython3",
+ "version": "3.12.4"
+ }
+ },
+ "nbformat": 4,
+ "nbformat_minor": 5
+}
diff --git a/latest-snapshot/quickstart-python/index.html b/latest-snapshot/delta-lake/index.html
similarity index 66%
copy from latest-snapshot/quickstart-python/index.html
copy to latest-snapshot/delta-lake/index.html
index 75f6983..452b8de 100644
--- a/latest-snapshot/quickstart-python/index.html
+++ b/latest-snapshot/delta-lake/index.html
@@ -7,13 +7,13 @@
- <link rel="canonical" href="https://sedona.apache.org/sedonadb/latest/quickstart-python/">
+ <link rel="canonical" href="https://sedona.apache.org/sedonadb/latest/delta-lake/">
- <link rel="prev" href="..">
+ <link rel="prev" href="../crs-examples/">
- <link rel="next" href="../programming-guide/">
+ <link rel="next" href="../working-with-parquet-files/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -21,7 +21,7 @@
- <title>Quickstart - SedonaDB</title>
+ <title>Delta Lake - SedonaDB</title>
@@ -86,7 +86,7 @@
<div data-md-component="skip">
- <a href="#python-quickstart" class="md-skip">
+ <a href="#sedonadb-delta-lake" 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">
- Quickstart
+ Delta Lake
</span>
</div>
@@ -633,20 +633,11 @@
-
-
- <li class="md-nav__item md-nav__item--active">
-
- <input class="md-nav__toggle md-toggle" type="checkbox" id="__toc">
-
-
+ <li class="md-nav__item">
+ <a href="../quickstart-python/" class="md-nav__link">
-
-
- <label class="md-nav__link md-nav__link--active" for="__toc">
-
<span class="md-ellipsis">
@@ -655,62 +646,80 @@
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <a href="./" class="md-nav__link md-nav__link--active">
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../programming-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Quickstart
+ Programming Guide
</span>
</a>
-
-
-
-<nav class="md-nav md-nav--secondary" aria-label="Table of contents">
+ </li>
+
+
+
+
+
-
- <label class="md-nav__title" for="__toc">
- <span class="md-nav__icon md-icon"></span>
- Table of contents
- </label>
- <ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
+
+
+
+
- <li class="md-nav__item">
- <a href="#point-in-polygon-join" class="md-nav__link">
- <span class="md-ellipsis">
- Point in polygon join
- </span>
- </a>
-
-</li>
- <li class="md-nav__item">
- <a href="#manually-create-sedonadb-dataframes" class="md-nav__link">
- <span class="md-ellipsis">
- Manually create SedonaDB DataFrames
- </span>
- </a>
-
-</li>
+
+
+
+
- </ul>
-
-</nav>
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
- </li>
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -719,12 +728,12 @@
<li class="md-nav__item">
- <a href="../programming-guide/" class="md-nav__link">
+ <a href="../reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- Programming Guide
+ Python
</span>
@@ -742,12 +751,12 @@
<li class="md-nav__item">
- <a href="../geopandas-interop/" class="md-nav__link">
+ <a href="../reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- GeoPandas interop
+ SQL
</span>
@@ -765,12 +774,12 @@
<li class="md-nav__item">
- <a href="../overture-examples/" class="md-nav__link">
+ <a href="../reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ Spatial Joins
</span>
@@ -781,28 +790,61 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
- <li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
<span class="md-ellipsis">
- CRS Examples
+ Examples
</span>
- </a>
- </li>
-
-
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -811,12 +853,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ GeoPandas interop
</span>
@@ -834,12 +876,12 @@
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../overture-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ Overture Examples
</span>
@@ -857,12 +899,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
+ CRS Examples
</span>
@@ -877,47 +919,102 @@
+
-
-
-
-
+
+ <li class="md-nav__item md-nav__item--active">
+
+ <input class="md-nav__toggle md-toggle" type="checkbox" id="__toc">
-
-
-
+
+ <label class="md-nav__link md-nav__link--active" for="__toc">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+ <a href="./" class="md-nav__link md-nav__link--active">
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
<span class="md-ellipsis">
- API
+ Delta Lake
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
+ </a>
+
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
+
+<nav class="md-nav md-nav--secondary" aria-label="Table of contents">
+
+
+
+
+
+
+ <label class="md-nav__title" for="__toc">
+ <span class="md-nav__icon md-icon"></span>
+ Table of contents
+ </label>
+ <ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
+
+ <li class="md-nav__item">
+ <a href="#create-a-delta-lake-table-with-wkt" class="md-nav__link">
+ <span class="md-ellipsis">
+ Create a Delta Lake table with WKT
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#read-delta-table-into-sedonadb" class="md-nav__link">
+ <span class="md-ellipsis">
+ Read Delta table into SedonaDB
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#filter-countries-in-a-particular-geographic-region" class="md-nav__link">
+ <span class="md-ellipsis">
+ Filter countries in a particular geographic region
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#create-a-delta-lake-table-with-wkb" class="md-nav__link">
+ <span class="md-ellipsis">
+ Create a Delta Lake table with WKB
+ </span>
+ </a>
+
+</li>
+
+ </ul>
+
+</nav>
+
+ </li>
+
+
+
@@ -926,12 +1023,12 @@
<li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- Python
+ Working with Parquet Files
</span>
@@ -949,12 +1046,12 @@
<li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with SQL in SedonaDB
</span>
@@ -965,6 +1062,14 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
@@ -972,12 +1077,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -994,14 +1099,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-
@@ -1118,18 +1215,36 @@
<ul class="md-nav__list" data-md-component="toc" data-md-scrollfix>
<li class="md-nav__item">
- <a href="#point-in-polygon-join" class="md-nav__link">
+ <a href="#create-a-delta-lake-table-with-wkt" class="md-nav__link">
<span class="md-ellipsis">
- Point in polygon join
+ Create a Delta Lake table with WKT
</span>
</a>
</li>
<li class="md-nav__item">
- <a href="#manually-create-sedonadb-dataframes" class="md-nav__link">
+ <a href="#read-delta-table-into-sedonadb" class="md-nav__link">
<span class="md-ellipsis">
- Manually create SedonaDB DataFrames
+ Read Delta table into SedonaDB
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#filter-countries-in-a-particular-geographic-region" class="md-nav__link">
+ <span class="md-ellipsis">
+ Filter countries in a particular geographic region
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#create-a-delta-lake-table-with-wkb" class="md-nav__link">
+ <span class="md-ellipsis">
+ Create a Delta Lake table with WKB
</span>
</a>
@@ -1151,7 +1266,7 @@
- <a href="https://github.com/apache/sedona-db/blob/main/docs/quickstart-python.md" title="Edit this page" class="md-content__button md-icon" rel="edit">
+ <a href="https://github.com/apache/sedona-db/blob/main/docs/delta-lake.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>
@@ -1159,82 +1274,78 @@
-<!---
- 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="python-quickstart">Python Quickstart<a class="headerlink" href="#python-quickstart" title="Permanent link">¶</a></h1>
-<p>First, install SedonaDB:</p>
-<div class="highlight"><pre><span></span><code>pip<span class="w"> </span>install<span class="w"> </span><span class="s2">"apache-sedona[db]"</span>
-</code></pre></div>
-<p>If the import and connection are successful, your installation is complete.</p>
-<div class="highlight"><pre><span></span><code><span class="kn">import</span><span class="w"> </span><span class="nn">sedona.db</span>
+<h1 id="sedonadb-delta-lake">SedonaDB + Delta Lake<a class="headerlink" href="#sedonadb-delta-lake" title="Permanent link">¶</a></h1>
+<p>This page shows how to read and write Delta Lake tables with SedonaDB.</p>
+<p>Make sure you run <code>pip install deltalake</code> to run the code snippets below.</p>
+<div class="highlight"><pre><span></span><code><span class="kn">from</span><span class="w"> </span><span class="nn">deltalake</span><span class="w"> </span><span class="kn">import</span> <span class="n">write_deltalake</span><span class="p">,</span> <span class="n">DeltaTable</span>
+<span class="kn">import</span><span class="w"> </span><span class="nn">sedona.db</span>
+<span class="kn">import</span><span class="w"> </span><span class="nn">pyarrow.compute</span><span class="w"> </span><span class="k">as</span><span class="w"> </span><span class="nn">pc</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>
-<span class="n">sd</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="s2">"SELECT ST_Point(0, 1) as geom"</span><span class="p">)</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
</code></pre></div>
-<div class="codehilite"><pre><span></span><code>┌────────────┐
-│ geom │
-│ geometry │
-╞════════════╡
-│ POINT(0 1) │
-└────────────┘
+<p>Read in a GeoParquet dataset into a SedonaDB DataFrame.</p>
+<div class="highlight"><pre><span></span><code><span class="n">countries</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/natural-earth/files/natural-earth_countries_geo.parquet"</span>
+<span class="p">)</span>
</code></pre></div>
-
-<h2 id="point-in-polygon-join">Point in polygon join<a class="headerlink" href="#point-in-polygon-join" title="Permanent link">¶</a></h2>
-<div class="highlight"><pre><span></span><code><span class="n">cities</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/natural-earth/files/natural-earth_cities_geo.parquet"</span>
+<h2 id="create-a-delta-lake-table-with-wkt">Create a Delta Lake table with WKT<a class="headerlink" href="#create-a-delta-lake-table-with-wkt" title="Permanent link">¶</a></h2>
+<p>Now write the DataFrame to a Delta Lake table. Notice that you must convert the geometry column to Well-Known Text (WKT) or Well-Known Binary (WKB) before writing to the Delta table.</p>
+<p>Delta Lake does not support geometry columns.</p>
+<p>This example shows how to create a Delta table with a WKT column. The section that follows shows how to create a Delta table with a WKB column.</p>
+<div class="highlight"><pre><span></span><code><span class="n">countries</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"countries"</span><span class="p">,</span> <span class="kc">True</span><span class="p">)</span>
+<span class="n">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 name, continent, ST_AsText(geometry) as geometry_wkt from countries"</span>
<span class="p">)</span>
+<span class="n">table_path</span> <span class="o">=</span> <span class="s2">"/tmp/delta_with_wkt"</span>
+<span class="n">write_deltalake</span><span class="p">(</span><span class="n">table_path</span><span class="p">,</span> <span class="n">df</span><span class="o">.</span><span class="n">to_pandas</span><span class="p">(),</span> <span class="n">mode</span><span class="o">=</span><span class="s2">"overwrite"</span><span class="p">)</span>
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">cities</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
+<h2 id="read-delta-table-into-sedonadb">Read Delta table into SedonaDB<a class="headerlink" href="#read-delta-table-into-sedonadb" title="Permanent link">¶</a></h2>
+<p>Now read the Delta table back into a SedonaDB DataFrame.</p>
+<div class="highlight"><pre><span></span><code><span class="n">dt</span> <span class="o">=</span> <span class="n">DeltaTable</span><span class="p">(</span><span class="n">table_path</span><span class="p">)</span>
+<span class="n">arrow_table</span> <span class="o">=</span> <span class="n">dt</span><span class="o">.</span><span class="n">to_pyarrow_table</span><span class="p">()</span>
+<span class="n">df</span> <span class="o">=</span> <span class="n">sd</span><span class="o">.</span><span class="n">create_data_frame</span><span class="p">(</span><span class="n">arrow_table</span><span class="p">)</span>
+<span class="n">df</span><span class="o">.</span><span class="n">show</span><span class="p">()</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) │
-└──────────────┴───────────────────────────────┘
+<div class="codehilite"><pre><span></span><code>┌─────────────────────────────┬───────────────┬────────────────────────────────────────────────────┐
+│ name ┆ continent ┆ geometry_wkt │
+│ utf8 ┆ utf8 ┆ utf8 │
+╞═════════════════════════════╪═══════════════╪════════════════════════════════════════════════════╡
+│ Fiji ┆ Oceania ┆ MULTIPOLYGON(((180 -16.067132663642447,180 -16.55… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ United Republic of Tanzania ┆ Africa ┆ POLYGON((33.90371119710453 -0.9500000000000001,34… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Western Sahara ┆ Africa ┆ POLYGON((-8.665589565454809 27.656425889592356,-8… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Canada ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ United States of America ┆ North America ┆ MULTIPOLYGON(((-122.84000000000003 49.00000000000… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Kazakhstan ┆ Asia ┆ POLYGON((87.35997033076265 49.21498078062912,86.5… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Uzbekistan ┆ Asia ┆ POLYGON((55.96819135928291 41.30864166926936,55.9… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Papua New Guinea ┆ Oceania ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Indonesia ┆ Asia ┆ MULTIPOLYGON(((141.00021040259185 -2.600151055515… │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Argentina ┆ South America ┆ MULTIPOLYGON(((-68.63401022758323 -52.63637045887… │
+└─────────────────────────────┴───────────────┴────────────────────────────────────────────────────┘
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">countries</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/natural-earth/files/natural-earth_countries_geo.parquet"</span>
-<span class="p">)</span>
-</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">countries</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
+<p>Notice that the <code>geometry_wkt</code> column is <code>utf8</code>. It's not a geometry column.</p>
+<p>Let's convert the <code>geometry_wkt</code> column to a geometry column.</p>
+<div class="highlight"><pre><span></span><code><span class="n">df</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"my_table"</span><span class="p">,</span> <span class="kc">True</span><span class="p">)</span>
+<span class="n">res</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">"""</span>
+<span class="s2">SELECT</span>
+<span class="s2"> name,</span>
+<span class="s2"> continent,</span>
+<span class="s2"> ST_GeomFromWKT(geometry_wkt) as geom</span>
+<span class="s2">from my_table</span>
+<span class="s2">"""</span><span class="p">)</span>
+<span class="n">res</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
</code></pre></div>
<div class="codehilite"><pre><span></span><code>┌─────────────────────────────┬───────────────┬────────────────────────────────────────────────────┐
-│ name ┆ continent ┆ geometry │
+│ name ┆ continent ┆ geom │
│ utf8 ┆ utf8 ┆ geometry │
╞═════════════════════════════╪═══════════════╪════════════════════════════════════════════════════╡
│ Fiji ┆ Oceania ┆ MULTIPOLYGON(((180 -16.067132663642447,180 -16.55… │
@@ -1259,108 +1370,108 @@
└─────────────────────────────┴───────────────┴────────────────────────────────────────────────────┘
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">cities</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"cities"</span><span class="p">)</span>
-<span class="n">countries</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"countries"</span><span class="p">)</span>
+<p>Confirm the schema of the DataFrame.</p>
+<div class="highlight"><pre><span></span><code><span class="n">res</span><span class="o">.</span><span class="n">schema</span>
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="c1"># join the cities and countries tables</span>
-<span class="n">sd</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="s2">"""</span>
-<span class="s2">select * from cities</span>
-<span class="s2">join countries</span>
-<span class="s2">where ST_Intersects(cities.geometry, countries.geometry)</span>
-<span class="s2">"""</span><span class="p">)</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
-</code></pre></div>
-<div class="codehilite"><pre><span></span><code>┌───────────────┬──────────────────────┬─────────────────────┬───────────────┬─────────────────────┐
-│ name ┆ geometry ┆ name ┆ continent ┆ geometry │
-│ utf8 ┆ geometry ┆ utf8 ┆ utf8 ┆ geometry │
-╞═══════════════╪══════════════════════╪═════════════════════╪═══════════════╪═════════════════════╡
-│ Suva ┆ POINT(178.4417073 -… ┆ Fiji ┆ Oceania ┆ MULTIPOLYGON(((180… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Dodoma ┆ POINT(35.7500036 -6… ┆ United Republic of… ┆ Africa ┆ POLYGON((33.903711… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Dar es Salaam ┆ POINT(39.266396 -6.… ┆ United Republic of… ┆ Africa ┆ POLYGON((33.903711… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Bir Lehlou ┆ POINT(-9.6525222 26… ┆ Western Sahara ┆ Africa ┆ POLYGON((-8.665589… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Ottawa ┆ POINT(-75.7019612 4… ┆ Canada ┆ North America ┆ MULTIPOLYGON(((-12… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Vancouver ┆ POINT(-123.1235901 … ┆ Canada ┆ North America ┆ MULTIPOLYGON(((-12… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Toronto ┆ POINT(-79.389458554… ┆ Canada ┆ North America ┆ MULTIPOLYGON(((-12… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ San Francisco ┆ POINT(-122.39959956… ┆ United States of A… ┆ North America ┆ MULTIPOLYGON(((-12… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Denver ┆ POINT(-104.9859618 … ┆ United States of A… ┆ North America ┆ MULTIPOLYGON(((-12… │
-├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ Houston ┆ POINT(-95.348436256… ┆ United States of A… ┆ North America ┆ MULTIPOLYGON(((-12… │
-└───────────────┴──────────────────────┴─────────────────────┴───────────────┴─────────────────────┘
+<div class="codehilite"><pre><span></span><code>SedonaSchema with 3 fields:
+ name: utf8<Utf8>
+ continent: utf8<Utf8>
+ geom: geometry<Wkb>
</code></pre></div>
-<h2 id="manually-create-sedonadb-dataframes">Manually create SedonaDB DataFrames<a class="headerlink" href="#manually-create-sedonadb-dataframes" title="Permanent link">¶</a></h2>
-<p>Let's create a DataFrame with one string column and one geometry column to show some of the functionality of the SedonaDB Python interface.</p>
-<div class="highlight"><pre><span></span><code><span class="n">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">"""</span>
-<span class="s2"> SELECT * FROM (VALUES</span>
-<span class="s2"> ('one', ST_GeomFromWkt('POINT(1 2)')),</span>
-<span class="s2"> ('two', ST_GeomFromWkt('POLYGON((</span>
-<span class="s2"> -74.0 40.7, -74.0 40.8, -73.9 40.8,</span>
-<span class="s2"> -73.9 40.7, -74.0 40.7</span>
-<span class="s2"> ))')),</span>
-<span class="s2"> ('three', ST_GeomFromWkt('LINESTRING(</span>
-<span class="s2"> -74.0060 40.7128, -73.9352 40.7306,</span>
-<span class="s2"> -73.8561 40.8484</span>
-<span class="s2"> )'))</span>
-<span class="s2"> ) AS t(val, point)</span>
+<h2 id="filter-countries-in-a-particular-geographic-region">Filter countries in a particular geographic region<a class="headerlink" href="#filter-countries-in-a-particular-geographic-region" title="Permanent link">¶</a></h2>
+<p>Now, let's grab some countries in the western portion of South America using a polygon region.</p>
+<p>SedonaDB can run these types of queries on geometric data.</p>
+<div class="highlight"><pre><span></span><code><span class="n">res</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">"""</span>
+<span class="s2">SELECT</span>
+<span class="s2"> name,</span>
+<span class="s2"> continent,</span>
+<span class="s2"> ST_GeomFromWKT(geometry_wkt) as geom</span>
+<span class="s2">FROM my_table</span>
+<span class="s2">WHERE ST_Intersects(</span>
+<span class="s2"> ST_GeomFromWKT(geometry_wkt),</span>
+<span class="s2"> ST_GeomFromWKT('POLYGON((-81 5, -75 5, -75 -56, -81 -56, -81 5))')</span>
+<span class="s2">)</span>
<span class="s2">"""</span><span class="p">)</span>
+<span class="n">res</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">df</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
-</code></pre></div>
-<div class="codehilite"><pre><span></span><code>┌───────┬──────────────────────────────────────────────────────────────────────────────────────────┐
-│ val ┆ point │
-│ utf8 ┆ binary │
-╞═══════╪══════════════════════════════════════════════════════════════════════════════════════════╡
-│ one ┆ 0101000000000000000000f03f0000000000000040 │
-├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ two ┆ 0103000000010000000500000000000000008052c09a9999999959444000000000008052c06666666666664… │
-├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ three ┆ 010200000003000000aaf1d24d628052c05e4bc8073d5b444007ce1951da7b52c0933a014d845d4440c286a… │
-└───────┴──────────────────────────────────────────────────────────────────────────────────────────┘
+<div class="codehilite"><pre><span></span><code>┌──────────┬───────────────┬───────────────────────────────────────────────────────────────────────┐
+│ name ┆ continent ┆ geom │
+│ utf8 ┆ utf8 ┆ geometry │
+╞══════════╪═══════════════╪═══════════════════════════════════════════════════════════════════════╡
+│ Chile ┆ South America ┆ MULTIPOLYGON(((-68.63401022758323 -52.63637045887449,-68.63335000000… │
+├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Peru ┆ South America ┆ POLYGON((-69.89363521999663 -4.2981869441943275,-70.7947688463023 -4… │
+├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Colombia ┆ South America ┆ POLYGON((-66.87632585312258 1.253360500489336,-67.0650481838525 1.13… │
+├╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Ecuador ┆ South America ┆ POLYGON((-75.37322323271385 -0.1520317521204504,-75.23372270374195 -… │
+└──────────┴───────────────┴───────────────────────────────────────────────────────────────────────┘
</code></pre></div>
-<p>Verify that this object is a SedonaDB DataFrame.</p>
-<div class="highlight"><pre><span></span><code><span class="nb">type</span><span class="p">(</span><span class="n">df</span><span class="p">)</span>
-</code></pre></div>
-<div class="codehilite"><pre><span></span><code>sedonadb.dataframe.DataFrame
+<h2 id="create-a-delta-lake-table-with-wkb">Create a Delta Lake table with WKB<a class="headerlink" href="#create-a-delta-lake-table-with-wkb" title="Permanent link">¶</a></h2>
+<p>You can also create a Delta table with WKB.</p>
+<p>WKB is binary, can be compressed more effectively than WKT, and results in smaller file sizes.</p>
+<p>The following example shows how to store the cities dataset in a Delta table with the geometry data stored as WKB.</p>
+<p>It also demonstrates how to add a <code>bbox</code> column to the Delta table, enabling more efficient filtering.</p>
+<div class="highlight"><pre><span></span><code><span class="n">cities</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/natural-earth/files/natural-earth_cities_geo.parquet"</span>
+<span class="p">)</span>
+<span class="n">cities</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"cities"</span><span class="p">,</span> <span class="kc">True</span><span class="p">)</span>
</code></pre></div>
-
-<p>Expose the DataFrame as a view and run a SQL operation on the geometry data.</p>
-<div class="highlight"><pre><span></span><code><span class="n">df</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"fun_table"</span><span class="p">)</span>
+<div class="highlight"><pre><span></span><code><span class="n">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">"""</span>
+<span class="s2">select </span>
+<span class="s2"> name, </span>
+<span class="s2"> ST_AsBinary(geometry) as geometry_wkb,</span>
+<span class="s2"> STRUCT(</span>
+<span class="s2"> ST_XMin(geometry) as xmin,</span>
+<span class="s2"> ST_YMin(geometry) as ymin,</span>
+<span class="s2"> ST_XMax(geometry) as xmax,</span>
+<span class="s2"> ST_YMax(geometry) as ymax</span>
+<span class="s2"> ) as bbox</span>
+<span class="s2">from cities</span>
+<span class="s2">"""</span><span class="p">)</span>
+<span class="n">table_path</span> <span class="o">=</span> <span class="s2">"/tmp/delta_with_wkb"</span>
+<span class="n">write_deltalake</span><span class="p">(</span><span class="n">table_path</span><span class="p">,</span> <span class="n">df</span><span class="o">.</span><span class="n">to_pandas</span><span class="p">(),</span> <span class="n">mode</span><span class="o">=</span><span class="s2">"overwrite"</span><span class="p">,</span> <span class="n">schema_mode</span><span class="o">=</span><span class="s2">"overwrite"</span><span class="p">)</span>
</code></pre></div>
-<div class="highlight"><pre><span></span><code><span class="n">sd</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="s2">"DESCRIBE fun_table"</span><span class="p">)</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
+<p>Read the Delta table and filter it to only include cities in the eastern half of North America.</p>
+<div class="highlight"><pre><span></span><code><span class="n">dt</span> <span class="o">=</span> <span class="n">DeltaTable</span><span class="p">(</span><span class="n">table_path</span><span class="p">)</span>
+<span class="n">dataset</span> <span class="o">=</span> <span class="n">dt</span><span class="o">.</span><span class="n">to_pyarrow_dataset</span><span class="p">()</span>
+<span class="n">filter_expr</span> <span class="o">=</span> <span class="p">(</span>
+ <span class="p">(</span><span class="n">pc</span><span class="o">.</span><span class="n">field</span><span class="p">(</span><span class="s2">"bbox"</span><span class="p">,</span> <span class="s2">"xmax"</span><span class="p">)</span> <span class="o">>=</span> <span class="o">-</span><span class="mf">97.0</span><span class="p">)</span>
+ <span class="o">&</span> <span class="p">(</span><span class="n">pc</span><span class="o">.</span><span class="n">field</span><span class="p">(</span><span class="s2">"bbox"</span><span class="p">,</span> <span class="s2">"xmin"</span><span class="p">)</span> <span class="o"><=</span> <span class="o">-</span><span class="mf">67.0</span><span class="p">)</span>
+ <span class="o">&</span> <span class="p">(</span><span class="n">pc</span><span class="o">.</span><span class="n">field</span><span class="p">(</span><span class="s2">"bbox"</span><span class="p">,</span> <span class="s2">"ymax"</span><span class="p">)</span> <span class="o">>=</span> <span class="mf">25.0</span><span class="p">)</span>
+ <span class="o">&</span> <span class="p">(</span><span class="n">pc</span><span class="o">.</span><span class="n">field</span><span class="p">(</span><span class="s2">"bbox"</span><span class="p">,</span> <span class="s2">"ymin"</span><span class="p">)</span> <span class="o"><=</span> <span class="mf">50.0</span><span class="p">)</span>
+<span class="p">)</span>
+<span class="n">filtered_table</span> <span class="o">=</span> <span class="n">dataset</span><span class="o">.</span><span class="n">to_table</span><span class="p">(</span><span class="nb">filter</span><span class="o">=</span><span class="n">filter_expr</span><span class="p">)</span>
</code></pre></div>
-<div class="codehilite"><pre><span></span><code><span class="err">┌─────────────┬───────────┬─────────────┐</span>
-<span class="err">│</span><span class="w"> </span><span class="nx">column_name</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">data_type</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">is_nullable</span><span class="w"> </span><span class="err">│</span>
-<span class="err">│</span><span class="w"> </span><span class="nx">utf8</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">utf8</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">utf8</span><span class="w"> </span><span class="err">│</span>
-<span class="err">╞═════════════╪═══════════╪═════════════╡</span>
-<span class="err">│</span><span class="w"> </span><span class="nx">val</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">Utf8</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">YES</span><span class="w"> </span><span class="err">│</span>
-<span class="err">├╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤</span>
-<span class="err">│</span><span class="w"> </span><span class="nx">point</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">Binary</span><span class="w"> </span><span class="err">┆</span><span class="w"> </span><span class="nx">YES</span><span class="w"> </span><span class="err">│</span>
-<span class="err">└─────────────┴───────────┴─────────────┘</span>
+<div class="highlight"><pre><span></span><code><span class="n">df</span> <span class="o">=</span> <span class="n">sd</span><span class="o">.</span><span class="n">create_data_frame</span><span class="p">(</span><span class="n">filtered_table</span><span class="o">.</span><span class="n">to_pandas</span><span class="p">())</span>
</code></pre></div>
-
-<div class="highlight"><pre><span></span><code><span class="n">sd</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="s2">"""</span>
-<span class="s2"> SELECT *, ST_Centroid(ST_GeomFromWKB(point)) as centroid</span>
-<span class="s2"> FROM fun_table</span>
-<span class="s2">"""</span><span class="p">)</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
+<div class="highlight"><pre><span></span><code><span class="n">df</span><span class="o">.</span><span class="n">to_view</span><span class="p">(</span><span class="s2">"us_east_cities"</span><span class="p">,</span> <span class="kc">True</span><span class="p">)</span>
+<span class="n">sd</span><span class="o">.</span><span class="n">sql</span><span class="p">(</span><span class="s2">"select name, ST_GeomFromWKB(geometry_wkb) as geom from us_east_cities"</span><span class="p">)</span><span class="o">.</span><span class="n">show</span><span class="p">()</span>
</code></pre></div>
-<div class="codehilite"><pre><span></span><code>┌───────┬─────────────────────────────────────────────┬────────────────────────────────────────────┐
-│ val ┆ point ┆ centroid │
-│ utf8 ┆ binary ┆ geometry │
-╞═══════╪═════════════════════════════════════════════╪════════════════════════════════════════════╡
-│ one ┆ 0101000000000000000000f03f0000000000000040 ┆ POINT(1 2) │
-├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ two ┆ 0103000000010000000500000000000000008052c0… ┆ POINT(-73.95 40.75) │
-├╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
-│ three ┆ 010200000003000000aaf1d24d628052c05e4bc807… ┆ POINT(-73.92111155675562 40.7664673976246… │
-└───────┴─────────────────────────────────────────────┴────────────────────────────────────────────┘
+<div class="codehilite"><pre><span></span><code>┌──────────────────┬──────────────────────────────────────────────┐
+│ name ┆ geom │
+│ utf8 ┆ geometry │
+╞══════════════════╪══════════════════════════════════════════════╡
+│ Ottawa ┆ POINT(-75.7019612 45.4186427) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Nassau ┆ POINT(-77.3500438 25.0833901) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Houston ┆ POINT(-95.34843625672217 29.741272831862542) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Miami ┆ POINT(-80.2260519 25.7895566) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Atlanta ┆ POINT(-84.36764186571386 33.73945728378348) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Chicago ┆ POINT(-87.63523655322338 41.847961283364114) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Toronto ┆ POINT(-79.38945855491194 43.66464454743429) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ Washington, D.C. ┆ POINT(-77.0113644 38.9014952) │
+├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
+│ New York ┆ POINT(-73.99571754361698 40.72156174972766) │
+└──────────────────┴──────────────────────────────────────────────┘
</code></pre></div>
@@ -1382,7 +1493,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 23, 2025 03:55:58 UTC">September 23, 2025 03:55:58</span>
+ <span class="git-revision-date-localized-plugin git-revision-date-localized-plugin-datetime" title="November 3, 2025 20:16:13 UTC">November 3, 2025 20:16:13</span>
</span>
@@ -1418,7 +1529,7 @@
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href=".." class="md-footer__link md-footer__link--prev" aria-label="Previous: Home">
+ <a href="../crs-examples/" class="md-footer__link md-footer__link--prev" aria-label="Previous: CRS Examples">
<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>
@@ -1428,20 +1539,20 @@
Previous
</span>
<div class="md-ellipsis">
- Home
+ CRS Examples
</div>
</div>
</a>
- <a href="../programming-guide/" class="md-footer__link md-footer__link--next" aria-label="Next: Programming Guide">
+ <a href="../working-with-parquet-files/" class="md-footer__link md-footer__link--next" aria-label="Next: Working with Parquet Files">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- Programming Guide
+ Working with Parquet Files
</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 9385877..da405f5 100644
--- a/latest-snapshot/geopandas-interop/index.html
+++ b/latest-snapshot/geopandas-interop/index.html
@@ -10,7 +10,7 @@
<link rel="canonical" href="https://sedona.apache.org/sedonadb/latest/geopandas-interop/">
- <link rel="prev" href="../programming-guide/">
+ <link rel="prev" href="../reference/sql-joins/">
<link rel="next" href="../overture-examples/">
@@ -679,6 +679,177 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/python/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Python
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ SQL
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql-joins/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Spatial Joins
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
@@ -820,12 +991,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Delta Lake
</span>
@@ -843,12 +1014,12 @@
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ Working with Parquet Files
</span>
@@ -866,12 +1037,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Working with SQL in SedonaDB
</span>
@@ -882,93 +1053,9 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+ </ul>
+ </nav>
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
-
-
- <span class="md-ellipsis">
- API
-
- </span>
-
-
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Python
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- SQL
-
- </span>
-
-
- </a>
</li>
@@ -981,12 +1068,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -1003,14 +1090,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-
@@ -1370,7 +1449,7 @@
<nav class="md-footer__inner md-grid" aria-label="Footer">
- <a href="../programming-guide/" class="md-footer__link md-footer__link--prev" aria-label="Previous: Programming Guide">
+ <a href="../reference/sql-joins/" class="md-footer__link md-footer__link--prev" aria-label="Previous: Spatial Joins">
<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>
@@ -1380,7 +1459,7 @@
Previous
</span>
<div class="md-ellipsis">
- Programming Guide
+ Spatial Joins
</div>
</div>
</a>
diff --git a/latest-snapshot/index.html b/latest-snapshot/index.html
index 657ae96..2a3fdf2 100644
--- a/latest-snapshot/index.html
+++ b/latest-snapshot/index.html
@@ -771,22 +771,45 @@
- <li class="md-nav__item">
- <a href="geopandas-interop/" class="md-nav__link">
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
<span class="md-ellipsis">
- GeoPandas interop
+ API
</span>
- </a>
- </li>
-
-
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -795,12 +818,12 @@
<li class="md-nav__item">
- <a href="overture-examples/" class="md-nav__link">
+ <a href="reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ Python
</span>
@@ -818,12 +841,12 @@
<li class="md-nav__item">
- <a href="crs-examples/" class="md-nav__link">
+ <a href="reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- CRS Examples
+ SQL
</span>
@@ -841,12 +864,12 @@
<li class="md-nav__item">
- <a href="working-with-parquet-files/" class="md-nav__link">
+ <a href="reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Spatial Joins
</span>
@@ -855,6 +878,14 @@
</li>
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
@@ -863,13 +894,59 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
- <a href="working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ GeoPandas interop
</span>
@@ -887,12 +964,12 @@
<li class="md-nav__item">
- <a href="contributors-guide/" class="md-nav__link">
+ <a href="overture-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Overture Examples
</span>
@@ -909,45 +986,22 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
-
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
+ <li class="md-nav__item">
+ <a href="crs-examples/" class="md-nav__link">
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
<span class="md-ellipsis">
- API
+ CRS Examples
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
+ </a>
+ </li>
+
+
+
@@ -956,12 +1010,12 @@
<li class="md-nav__item">
- <a href="reference/python/" class="md-nav__link">
+ <a href="delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Python
+ Delta Lake
</span>
@@ -979,12 +1033,12 @@
<li class="md-nav__item">
- <a href="reference/sql/" class="md-nav__link">
+ <a href="working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with Parquet Files
</span>
@@ -1002,12 +1056,12 @@
<li class="md-nav__item">
- <a href="reference/sql-joins/" class="md-nav__link">
+ <a href="working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Working with SQL in SedonaDB
</span>
@@ -1026,6 +1080,29 @@
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
</ul>
</nav>
diff --git a/latest-snapshot/overture-examples/index.html b/latest-snapshot/overture-examples/index.html
index 03416bb..f23c18b 100644
--- a/latest-snapshot/overture-examples/index.html
+++ b/latest-snapshot/overture-examples/index.html
@@ -681,6 +681,177 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/python/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Python
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ SQL
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql-joins/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Spatial Joins
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../geopandas-interop/" class="md-nav__link">
@@ -820,12 +991,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Delta Lake
</span>
@@ -843,12 +1014,12 @@
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ Working with Parquet Files
</span>
@@ -866,12 +1037,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Working with SQL in SedonaDB
</span>
@@ -882,93 +1053,9 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+ </ul>
+ </nav>
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
-
-
- <span class="md-ellipsis">
- API
-
- </span>
-
-
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Python
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- SQL
-
- </span>
-
-
- </a>
</li>
@@ -981,12 +1068,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -1003,14 +1090,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-
diff --git a/latest-snapshot/programming-guide/index.html b/latest-snapshot/programming-guide/index.html
index fc42771..f35d48c 100644
--- a/latest-snapshot/programming-guide/index.html
+++ b/latest-snapshot/programming-guide/index.html
@@ -13,7 +13,7 @@
<link rel="prev" href="../quickstart-python/">
- <link rel="next" href="../geopandas-interop/">
+ <link rel="next" href="../reference/python/">
<link rel="icon" href="../image/sedona_logo_symbol.png">
@@ -789,22 +789,45 @@
- <li class="md-nav__item">
- <a href="../geopandas-interop/" class="md-nav__link">
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
<span class="md-ellipsis">
- GeoPandas interop
+ API
</span>
- </a>
- </li>
-
-
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -813,12 +836,12 @@
<li class="md-nav__item">
- <a href="../overture-examples/" class="md-nav__link">
+ <a href="../reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ Python
</span>
@@ -836,12 +859,12 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- CRS Examples
+ SQL
</span>
@@ -859,12 +882,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Spatial Joins
</span>
@@ -873,6 +896,14 @@
</li>
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
@@ -881,13 +912,59 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ GeoPandas interop
</span>
@@ -905,12 +982,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../overture-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Overture Examples
</span>
@@ -927,45 +1004,22 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
-
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
+ <li class="md-nav__item">
+ <a href="../crs-examples/" class="md-nav__link">
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
<span class="md-ellipsis">
- API
+ CRS Examples
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
+ </a>
+ </li>
+
+
+
@@ -974,12 +1028,12 @@
<li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Python
+ Delta Lake
</span>
@@ -997,12 +1051,12 @@
<li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with Parquet Files
</span>
@@ -1020,12 +1074,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Working with SQL in SedonaDB
</span>
@@ -1044,6 +1098,29 @@
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
</ul>
</nav>
@@ -1504,13 +1581,13 @@
- <a href="../geopandas-interop/" class="md-footer__link md-footer__link--next" aria-label="Next: GeoPandas interop">
+ <a href="../reference/python/" class="md-footer__link md-footer__link--next" aria-label="Next: Python">
<div class="md-footer__title">
<span class="md-footer__direction">
Next
</span>
<div class="md-ellipsis">
- GeoPandas interop
+ Python
</div>
</div>
<div class="md-footer__button md-icon">
diff --git a/latest-snapshot/quickstart-python/index.html b/latest-snapshot/quickstart-python/index.html
index 75f6983..41aa4b0 100644
--- a/latest-snapshot/quickstart-python/index.html
+++ b/latest-snapshot/quickstart-python/index.html
@@ -741,22 +741,45 @@
- <li class="md-nav__item">
- <a href="../geopandas-interop/" class="md-nav__link">
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
<span class="md-ellipsis">
- GeoPandas interop
+ API
</span>
- </a>
- </li>
-
-
-
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
@@ -765,12 +788,12 @@
<li class="md-nav__item">
- <a href="../overture-examples/" class="md-nav__link">
+ <a href="../reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ Python
</span>
@@ -788,12 +811,12 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- CRS Examples
+ SQL
</span>
@@ -811,12 +834,12 @@
<li class="md-nav__item">
- <a href="../working-with-parquet-files/" class="md-nav__link">
+ <a href="../reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ Spatial Joins
</span>
@@ -825,6 +848,14 @@
</li>
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
@@ -833,13 +864,59 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ GeoPandas interop
</span>
@@ -857,12 +934,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../overture-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Overture Examples
</span>
@@ -879,45 +956,22 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
-
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
+ <li class="md-nav__item">
+ <a href="../crs-examples/" class="md-nav__link">
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
<span class="md-ellipsis">
- API
+ CRS Examples
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
+ </a>
+ </li>
+
+
+
@@ -926,12 +980,12 @@
<li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Python
+ Delta Lake
</span>
@@ -949,12 +1003,12 @@
<li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
+ <a href="../working-with-parquet-files/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with Parquet Files
</span>
@@ -972,12 +1026,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Working with SQL in SedonaDB
</span>
@@ -996,6 +1050,29 @@
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
</ul>
</nav>
diff --git a/latest-snapshot/reference/python/index.html b/latest-snapshot/reference/python/index.html
index 58a152f..22dd291 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="../../contributors-guide/">
+ <link rel="prev" href="../../programming-guide/">
<link rel="next" href="../sql/">
@@ -679,144 +679,6 @@
-
-
- <li class="md-nav__item">
- <a href="../../geopandas-interop/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- GeoPandas interop
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../overture-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Overture Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- CRS Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <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="../../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>
-
-
-
-
-
-
-
-
@@ -838,10 +700,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10" checked>
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4" checked>
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
@@ -854,8 +716,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="true">
- <label class="md-nav__title" for="__nav_6_10">
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_4">
<span class="md-nav__icon md-icon"></span>
API
</label>
@@ -1278,6 +1140,221 @@
</li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../geopandas-interop/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ GeoPandas interop
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../overture-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Overture Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../crs-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ CRS Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../delta-lake/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <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="../../working-with-sql-sedonadb/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
</ul>
@@ -4575,7 +4652,7 @@ the name of the provided function.</p>
<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="../../programming-guide/" class="md-footer__link md-footer__link--prev" aria-label="Previous: Programming 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>
@@ -4585,7 +4662,7 @@ the name of the provided function.</p>
Previous
</span>
<div class="md-ellipsis">
- Contributors Guide
+ Programming Guide
</div>
</div>
</a>
diff --git a/latest-snapshot/reference/sql-joins/index.html b/latest-snapshot/reference/sql-joins/index.html
index 29a1222..5555a79 100644
--- a/latest-snapshot/reference/sql-joins/index.html
+++ b/latest-snapshot/reference/sql-joins/index.html
@@ -13,6 +13,8 @@
<link rel="prev" href="../sql/">
+ <link rel="next" href="../../geopandas-interop/">
+
<link rel="icon" href="../../image/sedona_logo_symbol.png">
<meta name="generator" content="mkdocs-1.6.1, mkdocs-material-9.6.23">
@@ -677,144 +679,6 @@
-
-
- <li class="md-nav__item">
- <a href="../../geopandas-interop/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- GeoPandas interop
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../overture-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Overture Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- CRS Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <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="../../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>
-
-
-
-
-
-
-
-
@@ -836,10 +700,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10" checked>
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4" checked>
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
@@ -852,8 +716,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="true">
- <label class="md-nav__title" for="__nav_6_10">
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_4">
<span class="md-nav__icon md-icon"></span>
API
</label>
@@ -1048,6 +912,221 @@
</li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../geopandas-interop/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ GeoPandas interop
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../overture-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Overture Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../crs-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ CRS Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../delta-lake/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <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="../../working-with-sql-sedonadb/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
</ul>
@@ -1411,6 +1490,22 @@
</a>
+
+ <a href="../../geopandas-interop/" class="md-footer__link md-footer__link--next" aria-label="Next: GeoPandas interop">
+ <div class="md-footer__title">
+ <span class="md-footer__direction">
+ Next
+ </span>
+ <div class="md-ellipsis">
+ GeoPandas interop
+ </div>
+ </div>
+ <div class="md-footer__button md-icon">
+
+ <svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 24 24"><path d="M4 11v2h12l-5.5 5.5 1.42 1.42L19.84 12l-7.92-7.92L10.5 5.5 16 11z"></path></svg>
+ </div>
+ </a>
+
</nav>
diff --git a/latest-snapshot/reference/sql/index.html b/latest-snapshot/reference/sql/index.html
index cb93549..ad5c8cb 100644
--- a/latest-snapshot/reference/sql/index.html
+++ b/latest-snapshot/reference/sql/index.html
@@ -679,144 +679,6 @@
-
-
- <li class="md-nav__item">
- <a href="../../geopandas-interop/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- GeoPandas interop
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../overture-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Overture Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../../crs-examples/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- CRS Examples
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <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="../../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>
-
-
-
-
-
-
-
-
@@ -838,10 +700,10 @@
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10" checked>
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4" checked>
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
@@ -854,8 +716,8 @@
<span class="md-nav__icon md-icon"></span>
</label>
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="true">
- <label class="md-nav__title" for="__nav_6_10">
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_4">
<span class="md-nav__icon md-icon"></span>
API
</label>
@@ -1527,6 +1389,221 @@
</li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5">
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../geopandas-interop/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ GeoPandas interop
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../overture-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Overture Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../crs-examples/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ CRS Examples
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../delta-lake/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <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="../../working-with-sql-sedonadb/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Working with SQL in SedonaDB
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../../contributors-guide/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Contributors Guide
+
+ </span>
+
+
+ </a>
+ </li>
+
+
</ul>
diff --git a/latest-snapshot/search/search_index.json b/latest-snapshot/search/search_index.json
index b285de5..b839277 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 9a8f4ff..dc00524 100644
--- a/latest-snapshot/sitemap.xml
+++ b/latest-snapshot/sitemap.xml
@@ -12,6 +12,10 @@
<loc>https://sedona.apache.org/sedonadb/latest/crs-examples/</loc>
<lastmod>2025-11-03</lastmod>
</url>
+ <url>
+ <loc>https://sedona.apache.org/sedonadb/latest/delta-lake/</loc>
+ <lastmod>2025-11-03</lastmod>
+ </url>
<url>
<loc>https://sedona.apache.org/sedonadb/latest/geopandas-interop/</loc>
<lastmod>2025-11-03</lastmod>
diff --git a/latest-snapshot/sitemap.xml.gz b/latest-snapshot/sitemap.xml.gz
index 36249e1..5f1bda0 100644
Binary files a/latest-snapshot/sitemap.xml.gz and b/latest-snapshot/sitemap.xml.gz differ
diff --git a/latest-snapshot/working-with-parquet-files/index.html b/latest-snapshot/working-with-parquet-files/index.html
index 5111b65..368db97 100644
--- a/latest-snapshot/working-with-parquet-files/index.html
+++ b/latest-snapshot/working-with-parquet-files/index.html
@@ -10,7 +10,7 @@
<link rel="canonical" href="https://sedona.apache.org/sedonadb/latest/working-with-parquet-files/">
- <link rel="prev" href="../crs-examples/">
+ <link rel="prev" href="../delta-lake/">
<link rel="next" href="../working-with-sql-sedonadb/">
@@ -681,13 +681,59 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
- <a href="../geopandas-interop/" class="md-nav__link">
+ <a href="../reference/python/" class="md-nav__link">
<span class="md-ellipsis">
- GeoPandas interop
+ Python
</span>
@@ -705,12 +751,12 @@
<li class="md-nav__item">
- <a href="../overture-examples/" class="md-nav__link">
+ <a href="../reference/sql/" class="md-nav__link">
<span class="md-ellipsis">
- Overture Examples
+ SQL
</span>
@@ -728,12 +774,12 @@
<li class="md-nav__item">
- <a href="../crs-examples/" class="md-nav__link">
+ <a href="../reference/sql-joins/" class="md-nav__link">
<span class="md-ellipsis">
- CRS Examples
+ Spatial Joins
</span>
@@ -744,6 +790,14 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
@@ -752,76 +806,87 @@
- <li class="md-nav__item md-nav__item--active">
-
- <input class="md-nav__toggle md-toggle" type="checkbox" id="__toc">
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
- <label class="md-nav__link md-nav__link--active" for="__toc">
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
<span class="md-ellipsis">
- Working with Parquet Files
+ Examples
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <a href="./" class="md-nav__link md-nav__link--active">
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../geopandas-interop/" class="md-nav__link">
<span class="md-ellipsis">
- Working with Parquet Files
+ GeoPandas interop
</span>
</a>
-
-
+ </li>
+
-<nav class="md-nav md-nav--secondary" aria-label="Table of contents">
+
+
+
+
-
+ <li class="md-nav__item">
+ <a href="../overture-examples/" class="md-nav__link">
+
- <label class="md-nav__title" for="__toc">
- <span class="md-nav__icon md-icon"></span>
- Table of contents
- </label>
- <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">
- <span class="md-ellipsis">
- Install SedonaDB
- </span>
- </a>
-</li>
-
- <li class="md-nav__item">
- <a href="#implementation" class="md-nav__link">
- <span class="md-ellipsis">
- Implementation
- </span>
- </a>
-
-</li>
-
- </ul>
+ <span class="md-ellipsis">
+ Overture Examples
+
+ </span>
-</nav>
-
+
+ </a>
</li>
@@ -834,12 +899,12 @@
<li class="md-nav__item">
- <a href="../working-with-sql-sedonadb/" class="md-nav__link">
+ <a href="../crs-examples/" class="md-nav__link">
<span class="md-ellipsis">
- Working with SQL in SedonaDB
+ CRS Examples
</span>
@@ -857,12 +922,12 @@
<li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
+ <a href="../delta-lake/" class="md-nav__link">
<span class="md-ellipsis">
- Contributors Guide
+ Delta Lake
</span>
@@ -877,66 +942,80 @@
+
-
-
-
-
+
+ <li class="md-nav__item md-nav__item--active">
+
+ <input class="md-nav__toggle md-toggle" type="checkbox" id="__toc">
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
+ <label class="md-nav__link md-nav__link--active" for="__toc">
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
<span class="md-ellipsis">
- API
+ Working with Parquet Files
</span>
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <a href="./" class="md-nav__link md-nav__link--active">
<span class="md-ellipsis">
- Python
+ Working with Parquet Files
</span>
</a>
+
+
+
+<nav class="md-nav md-nav--secondary" aria-label="Table of contents">
+
+
+
+
+
+
+ <label class="md-nav__title" for="__toc">
+ <span class="md-nav__icon md-icon"></span>
+ Table of contents
+ </label>
+ <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">
+ <span class="md-ellipsis">
+ Install SedonaDB
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#implementation" class="md-nav__link">
+ <span class="md-ellipsis">
+ Implementation
+ </span>
+ </a>
+
+</li>
+
+ </ul>
+
+</nav>
+
</li>
@@ -949,12 +1028,12 @@
<li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
+ <a href="../working-with-sql-sedonadb/" class="md-nav__link">
<span class="md-ellipsis">
- SQL
+ Working with SQL in SedonaDB
</span>
@@ -965,6 +1044,14 @@
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
@@ -972,12 +1059,12 @@
<li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -994,14 +1081,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-
@@ -1299,7 +1378,7 @@
<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: CRS Examples">
+ <a href="../delta-lake/" class="md-footer__link md-footer__link--prev" aria-label="Previous: Delta Lake">
<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>
@@ -1309,7 +1388,7 @@
Previous
</span>
<div class="md-ellipsis">
- CRS Examples
+ Delta Lake
</div>
</div>
</a>
diff --git a/latest-snapshot/working-with-sql-sedonadb/index.html b/latest-snapshot/working-with-sql-sedonadb/index.html
index d2b19f8..fc9eb2c 100644
--- a/latest-snapshot/working-with-sql-sedonadb/index.html
+++ b/latest-snapshot/working-with-sql-sedonadb/index.html
@@ -681,6 +681,177 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_4">
+
+
+ <label class="md-nav__link" for="__nav_6_4" id="__nav_6_4_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ API
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_4_label" aria-expanded="false">
+ <label class="md-nav__title" for="__nav_6_4">
+ <span class="md-nav__icon md-icon"></span>
+ API
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/python/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Python
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ SQL
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item">
+ <a href="../reference/sql-joins/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Spatial Joins
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+ </ul>
+ </nav>
+
+ </li>
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ <li class="md-nav__item md-nav__item--active md-nav__item--section md-nav__item--nested">
+
+
+
+ <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_5" checked>
+
+
+ <label class="md-nav__link" for="__nav_6_5" id="__nav_6_5_label" tabindex="">
+
+
+
+ <span class="md-ellipsis">
+ Examples
+
+ </span>
+
+
+ <span class="md-nav__icon md-icon"></span>
+ </label>
+
+ <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_5_label" aria-expanded="true">
+ <label class="md-nav__title" for="__nav_6_5">
+ <span class="md-nav__icon md-icon"></span>
+ Examples
+ </label>
+ <ul class="md-nav__list" data-md-scrollfix>
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../geopandas-interop/" class="md-nav__link">
@@ -750,6 +921,29 @@
+ <li class="md-nav__item">
+ <a href="../delta-lake/" class="md-nav__link">
+
+
+
+ <span class="md-ellipsis">
+ Delta Lake
+
+ </span>
+
+
+ </a>
+ </li>
+
+
+
+
+
+
+
+
+
+
<li class="md-nav__item">
<a href="../working-with-parquet-files/" class="md-nav__link">
@@ -889,93 +1083,9 @@
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../contributors-guide/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Contributors Guide
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item md-nav__item--section md-nav__item--nested">
+ </ul>
+ </nav>
-
-
- <input class="md-nav__toggle md-toggle " type="checkbox" id="__nav_6_10">
-
-
- <label class="md-nav__link" for="__nav_6_10" id="__nav_6_10_label" tabindex="">
-
-
-
- <span class="md-ellipsis">
- API
-
- </span>
-
-
- <span class="md-nav__icon md-icon"></span>
- </label>
-
- <nav class="md-nav" data-md-level="2" aria-labelledby="__nav_6_10_label" aria-expanded="false">
- <label class="md-nav__title" for="__nav_6_10">
- <span class="md-nav__icon md-icon"></span>
- API
- </label>
- <ul class="md-nav__list" data-md-scrollfix>
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/python/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- Python
-
- </span>
-
-
- </a>
</li>
@@ -988,35 +1098,12 @@
<li class="md-nav__item">
- <a href="../reference/sql/" class="md-nav__link">
-
-
-
- <span class="md-ellipsis">
- SQL
-
- </span>
-
-
- </a>
- </li>
-
-
-
-
-
-
-
-
-
-
- <li class="md-nav__item">
- <a href="../reference/sql-joins/" class="md-nav__link">
+ <a href="../contributors-guide/" class="md-nav__link">
<span class="md-ellipsis">
- Spatial Joins
+ Contributors Guide
</span>
@@ -1033,14 +1120,6 @@
</li>
-
-
- </ul>
- </nav>
-
- </li>
-
-