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-spatialbench.git
The following commit(s) were added to refs/heads/asf-site by this push:
new a36cedd update documentation for main branch
a36cedd is described below
commit a36cedd77026e508ed0dc42d373dedfc9aac0c46
Author: GitHub Actions <[email protected]>
AuthorDate: Thu Jan 15 04:35:07 2026 +0000
update documentation for main branch
---
contributors-guide/index.html | 2 +-
datasets-generators/index.html | 2 +-
index.html | 32 +++++++-
overview-methodology/index.html | 2 +-
queries/index.html | 2 +-
quickstart/index.html | 2 +-
search/search_index.json | 2 +-
single-node-benchmarks/index.html | 138 +++++++++++++++++++++++++++++++++-
spatialbench-distributions/index.html | 2 +-
9 files changed, 172 insertions(+), 12 deletions(-)
diff --git a/contributors-guide/index.html b/contributors-guide/index.html
index a89081e..5a3f5a9 100644
--- a/contributors-guide/index.html
+++ b/contributors-guide/index.html
@@ -1442,7 +1442,7 @@ cargo<span class="w"> </span><span class="nb">test</span>
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/datasets-generators/index.html b/datasets-generators/index.html
index f916ebe..9b1333d 100644
--- a/datasets-generators/index.html
+++ b/datasets-generators/index.html
@@ -1502,7 +1502,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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/index.html b/index.html
index 02441bd..b4bf8de 100644
--- a/index.html
+++ b/index.html
@@ -767,6 +767,17 @@
</span>
</a>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#automated-testing" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Automated Testing
+
+ </span>
+ </a>
+
</li>
<li class="md-nav__item">
@@ -1139,6 +1150,17 @@
</span>
</a>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#automated-testing" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Automated Testing
+
+ </span>
+ </a>
+
</li>
<li class="md-nav__item">
@@ -1241,6 +1263,14 @@ with a star schema extended with spatial attributes like
pickup/dropoff points,
<span class="k">ORDER</span><span class="w"> </span><span
class="k">BY</span><span class="w"> </span><span
class="n">nearby_pickup_count</span><span class="w"> </span><span
class="k">DESC</span><span class="p">;</span>
</code></pre></div>
<p>This query performs a distance join, followed by an aggregation. It's a
great example of a query that's useful for performance benchmarking a spatial
engine that can process vector geometries.</p>
+<h2 id="automated-testing">Automated Testing<a class="headerlink"
href="#automated-testing" title="Permanent link">¶</a></h2>
+<p>SpatialBench includes an automated benchmark that runs on GitHub Actions to
verify that all queries are fully runnable across supported engines (DuckDB,
GeoPandas, SedonaDB, and Spatial Polars).</p>
+<p><strong><a
href="https://github.com/apache/sedona-spatialbench/actions/workflows/benchmark.yml";>View
the latest test results →</a></strong></p>
+<p>Click on any successful workflow run and scroll to the
<strong>Summary</strong> section to see the results.</p>
+<div class="admonition note">
+<p class="admonition-title">Note</p>
+<p>The GitHub Actions benchmark is designed to validate correctness and
runnability, not for serious performance comparisons. For meaningful
performance benchmarks, see the <a href="single-node-benchmarks/">Single Node
Benchmarks</a> page.</p>
+</div>
<h2 id="join-the-community">Join the community<a class="headerlink"
href="#join-the-community" title="Permanent link">¶</a></h2>
<p>Feel free to start a <a
href="https://github.com/apache/sedona/discussions";>GitHub Discussion</a> or
join the <a href="https://discord.gg/9A3k5dEBsY";>Discord community</a> to ask
the developers any questions you may have.</p>
<p>We look forward to collaborating with you on these benchmarks!</p>
@@ -1264,7 +1294,7 @@ with a star schema extended with spatial attributes like
pickup/dropoff points,
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/overview-methodology/index.html b/overview-methodology/index.html
index cd28a35..275bc56 100644
--- a/overview-methodology/index.html
+++ b/overview-methodology/index.html
@@ -1309,7 +1309,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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/queries/index.html b/queries/index.html
index 6269468..0a5dd24 100644
--- a/queries/index.html
+++ b/queries/index.html
@@ -1901,7 +1901,7 @@ spatialbench-cli -s 1 --format=parquet --output-dir
sf1-parquet
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/quickstart/index.html b/quickstart/index.html
index ee49231..a4258d4 100644
--- a/quickstart/index.html
+++ b/quickstart/index.html
@@ -1318,7 +1318,7 @@ cargo<span class="w"> </span>install<span class="w">
</span>--path<span class="w
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/search/search_index.json b/search/search_index.json
index 0567fce..9d782f8 100644
--- a/search/search_index.json
+++ b/search/search_index.json
@@ -1 +1 @@
-{"config":{"lang":["en"],"separator":"[\\s\\-]+","pipeline":["stopWordFilter"],"fields":{"title":{"boost":1000.0},"text":{"boost":1.0},"tags":{"boost":1000000.0}}},"docs":[{"location":"","title":"SpatialBench","text":"<p>SpatialBench
is a benchmark for assessing geospatial SQL analytics query performance across
database systems, making it easy to run tests on a realistic dataset with any
query engine.</p> <p>The methodology is unbiased, allowing you to run the
benchmarks in any environme [...]
\ No newline at end of file
+{"config":{"lang":["en"],"separator":"[\\s\\-]+","pipeline":["stopWordFilter"],"fields":{"title":{"boost":1000.0},"text":{"boost":1.0},"tags":{"boost":1000000.0}}},"docs":[{"location":"","title":"SpatialBench","text":"<p>SpatialBench
is a benchmark for assessing geospatial SQL analytics query performance across
database systems, making it easy to run tests on a realistic dataset with any
query engine.</p> <p>The methodology is unbiased, allowing you to run the
benchmarks in any environme [...]
\ No newline at end of file
diff --git a/single-node-benchmarks/index.html
b/single-node-benchmarks/index.html
index ced7a7f..3937b5b 100644
--- a/single-node-benchmarks/index.html
+++ b/single-node-benchmarks/index.html
@@ -998,13 +998,63 @@
</ul>
</nav>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#automated-benchmarks-github-actions" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Automated Benchmarks (GitHub Actions)
+
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Automated Benchmarks (GitHub Actions)">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#view-latest-results" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ View Latest Results
+
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#supported-engines" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Supported Engines
+
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#run-your-own-benchmark" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Run Your Own Benchmark
+
+ </span>
+ </a>
+
+</li>
+
+ </ul>
+ </nav>
+
</li>
<li class="md-nav__item">
<a href="#benchmark-code" class="md-nav__link">
<span class="md-ellipsis">
- Benchmark code
+ Benchmark Code
</span>
</a>
@@ -1285,13 +1335,63 @@
</ul>
</nav>
+</li>
+
+ <li class="md-nav__item">
+ <a href="#automated-benchmarks-github-actions" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Automated Benchmarks (GitHub Actions)
+
+ </span>
+ </a>
+
+ <nav class="md-nav" aria-label="Automated Benchmarks (GitHub Actions)">
+ <ul class="md-nav__list">
+
+ <li class="md-nav__item">
+ <a href="#view-latest-results" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ View Latest Results
+
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#supported-engines" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Supported Engines
+
+ </span>
+ </a>
+
+</li>
+
+ <li class="md-nav__item">
+ <a href="#run-your-own-benchmark" class="md-nav__link">
+ <span class="md-ellipsis">
+
+ Run Your Own Benchmark
+
+ </span>
+ </a>
+
+</li>
+
+ </ul>
+ </nav>
+
</li>
<li class="md-nav__item">
<a href="#benchmark-code" class="md-nav__link">
<span class="md-ellipsis">
- Benchmark code
+ Benchmark Code
</span>
</a>
@@ -1416,7 +1516,37 @@
s3://wherobots-examples/data/spatialbench/SpatialBench_sf10/zone/
<p>SedonaDB completes KNN joins at both SF 1 and SF 10, thanks to its native
operator and optimized algorithm. In contrast, DuckDB and GeoPandas currently
lack built-in KNN join support. For these engines, we had to implement
additional code manually, which proved less efficient. Adding native KNN
capabilities in the future would likely help both engines close this gap.</p>
<h3 id="overall">Overall<a class="headerlink" href="#overall" title="Permanent
link">¶</a></h3>
<p>SedonaDB demonstrates balanced performance across all query types and
scales effectively to SF 10. DuckDB excels at spatial filters and some
geometric operations but faces challenges with complex joins and KNN queries.
GeoPandas, while popular in the Python ecosystem, requires manual optimization
and parallelization to handle larger datasets effectively.</p>
-<h2 id="benchmark-code">Benchmark code<a class="headerlink"
href="#benchmark-code" title="Permanent link">¶</a></h2>
+<h2 id="automated-benchmarks-github-actions">Automated Benchmarks (GitHub
Actions)<a class="headerlink" href="#automated-benchmarks-github-actions"
title="Permanent link">¶</a></h2>
+<p>We run automated benchmarks on every pull request and periodically via
GitHub Actions to verify that all SpatialBench queries are fully runnable
across supported engines.</p>
+<div class="admonition note">
+<p class="admonition-title">Not for Performance Comparison</p>
+<p>The GitHub Actions benchmark is designed to validate correctness and
runnability, <strong>not</strong> for serious performance comparisons. GitHub
Actions runners have variable performance characteristics and limited
resources. For meaningful performance benchmarks, please run SpatialBench on
dedicated hardware with appropriate scale factors as described in the sections
above.</p>
+</div>
+<h3 id="view-latest-results">View Latest Results<a class="headerlink"
href="#view-latest-results" title="Permanent link">¶</a></h3>
+<p>Visit the <a
href="https://github.com/apache/sedona-spatialbench/actions/workflows/benchmark.yml";>GitHub
Actions Benchmark Page</a> to see the latest results. Click on any successful
workflow run and scroll to the <strong>Summary</strong> section to view:</p>
+<ul>
+<li>Query execution status for each engine</li>
+<li>Comparison across all 12 queries</li>
+<li>Error and timeout information</li>
+</ul>
+<h3 id="supported-engines">Supported Engines<a class="headerlink"
href="#supported-engines" title="Permanent link">¶</a></h3>
+<p>The automated tests cover:</p>
+<ul>
+<li>🦆 <strong>DuckDB</strong> - In-process analytical database with spatial
extension</li>
+<li>🐼 <strong>GeoPandas</strong> - Python geospatial data analysis library</li>
+<li>🌵 <strong>SedonaDB</strong> - High-performance spatial analytics
engine</li>
+<li>🐻❄️ <strong>Spatial Polars</strong> - Geospatial extension for Polars
dataframes</li>
+</ul>
+<h3 id="run-your-own-benchmark">Run Your Own Benchmark<a class="headerlink"
href="#run-your-own-benchmark" title="Permanent link">¶</a></h3>
+<p>You can trigger the automated tests manually from the <a
href="https://github.com/apache/sedona-spatialbench/actions/workflows/benchmark.yml";>Actions
tab</a> with configurable options:</p>
+<ul>
+<li><strong>Scale Factor</strong>: 0.1, 1, or 10</li>
+<li><strong>Engines</strong>: Select which engines to test</li>
+<li><strong>Query Timeout</strong>: Adjust timeout for longer queries
(default: 60s)</li>
+<li><strong>Runs per Query</strong>: 1, 3, or 5 runs for averaging (default:
3)</li>
+<li><strong>Package Versions</strong>: Pin specific versions or use latest</li>
+</ul>
+<h2 id="benchmark-code">Benchmark Code<a class="headerlink"
href="#benchmark-code" title="Permanent link">¶</a></h2>
<p>You can access and run the benchmark code in the <a
href="https://github.com/apache/sedona-spatialbench";>sedona-spatialbench
GitHub</a> repository.</p>
<p>You can generate datasets and run benchmarks both locally and in cloud
environments.</p>
<p>The repository has an issue tracker where you can file bug reports or
suggest code improvements.</p>
@@ -1627,7 +1757,7 @@
s3://wherobots-examples/data/spatialbench/SpatialBench_sf10/zone/
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
diff --git a/spatialbench-distributions/index.html
b/spatialbench-distributions/index.html
index a5f9b15..22974dd 100644
--- a/spatialbench-distributions/index.html
+++ b/spatialbench-distributions/index.html
@@ -1344,7 +1344,7 @@ X, Y \sim \mathcal{N}(\mu, \sigma^2), \quad \text{clamped
to } [0,1]
<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="January 15, 2026 04:15:01
UTC">January 15, 2026 04:15:01</span>
+ <span class="git-revision-date-localized-plugin
git-revision-date-localized-plugin-datetime" title="January 15, 2026 04:31:12
UTC">January 15, 2026 04:31:12</span>
</span>
