This is an automated email from the ASF dual-hosted git repository.
paleolimbot pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/sedona-db.git
The following commit(s) were added to refs/heads/main by this push:
new 240898d4 docs: update overture date (#361)
240898d4 is described below
commit 240898d4f48b18821c4190abbeaa1d7c71a4253a
Author: Matthew Powers <[email protected]>
AuthorDate: Mon Nov 24 21:13:58 2025 -0500
docs: update overture date (#361)
---
README.md | 34 ++++-----
docs/overture-examples.ipynb | 172 ++++++++++++++++++++++++++-----------------
docs/overture-examples.md | 106 +++++++++++++++++---------
docs/programming-guide.ipynb | 46 ++++++------
docs/programming-guide.md | 24 +++---
5 files changed, 228 insertions(+), 154 deletions(-)
diff --git a/README.md b/README.md
index 0af69d2c..a96ee2e2 100644
--- a/README.md
+++ b/README.md
@@ -47,14 +47,14 @@ Raster functions are coming soon. We expect SedonaDB Raster
will match all raste
SedonaDB has several advantages:
-* **π High Performance:** Built in Rust for exceptional speed and memory
efficiency
-* **πΊοΈ Comprehensive Spatial Toolkit:** Supports both vector and raster
functions in a single library
-* **π CRS Propagation:** Always maintains coordinate reference system
information
-* **π Format Flexibility:** Supports legacy and modern file formats including
GeoParquet, Shapefile, GeoJSON
-* **β‘ Dual APIs:** Python and SQL interfaces for seamless workflow integration
-* **π§ Extensible:** Easily customizable and extensible architecture
-* **π Ecosystem Integration:** Interoperable with PyArrow-compatible libraries
like GeoPandas, DuckDB, and Polars
-* **π₯ Active Community:** Great maintainers and contributors who encourage
external contributions
+* **High Performance:** Built in Rust for exceptional speed and memory
efficiency
+* **Comprehensive Spatial Toolkit:** Supports both vector and raster functions
in a single library
+* **CRS Propagation:** Always maintains coordinate reference system information
+* **Format Flexibility:** Supports legacy and modern file formats including
GeoParquet, Shapefile, GeoJSON
+* **Dual APIs:** Python and SQL interfaces for seamless workflow integration
+* **Extensible:** Easily customizable and extensible architecture
+* **Ecosystem Integration:** Interoperable with PyArrow-compatible libraries
like GeoPandas, DuckDB, and Polars
+* **Active Community:** Great maintainers and contributors who encourage
external contributions
## Performance Benchmarks
@@ -119,7 +119,7 @@ Read the dataset into a Python SedonaDB `DataFrame`. This
is lazy: even though t
```python
df = sd.read_parquet(
-
"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=buildings/type=building/"
+
"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=buildings/type=building/"
)
df.to_view("buildings")
```
@@ -172,19 +172,19 @@ Here's the query output:
### Get Help
-- π¬ **Discord:** Join our [Discord
community](https://discord.com/invite/9A3k5dEBsY) for real-time chat and support
-- π **GitHub Discussions:** Start a [GitHub
Discussion](https://github.com/apache/sedona/discussions) with questions or
ideas
-- π **Documentation:** Check out our [comprehensive
docs](https://sedona.apache.org/sedonadb)
+- **Discord:** Join our [Discord
community](https://discord.com/invite/9A3k5dEBsY) for real-time chat and support
+- **GitHub Discussions:** Start a [GitHub
Discussion](https://github.com/apache/sedona/discussions) with questions or
ideas
+- **Documentation:** Check out our [comprehensive
docs](https://sedona.apache.org/sedonadb)
### Contributing
We welcome contributions! Here's how you can get involved:
-* π **Report Issues:** Found a bug? Open an issue on GitHub
-* π‘ **Suggest Features:** Have an idea? Start a GitHub Discussion
-* π§ **Fix Issues:** Comment "take" on any open issue to claim it
-* π **Submit PRs:** Brainstorm features with contributors and submit pull
requests
-* π
**Join Meetings:** Monthly contributor meetings - we'd love to have you!
+* **Report Issues:** Found a bug? Open an issue on GitHub
+* **Suggest Features:** Have an idea? Start a GitHub Discussion
+* **Fix Issues:** Comment "take" on any open issue to claim it
+* **Submit PRs:** Brainstorm features with contributors and submit pull
requests
+* **Join Meetings:** Monthly contributor meetings - we'd love to have you!
### About SedonaDB
diff --git a/docs/overture-examples.ipynb b/docs/overture-examples.ipynb
index f76089c8..fa716942 100644
--- a/docs/overture-examples.ipynb
+++ b/docs/overture-examples.ipynb
@@ -28,7 +28,7 @@
"\n",
"> Note: Before running this notebook, ensure that you have installed
SedonaDB: `pip install \"apache-sedona[db]\"`\n",
"\n",
- "This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB.\n",
+ "This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB. See [this
page](https://docs.overturemaps.org/release-calendar/) to get the latest
version of the Overture data.\n",
"\n",
"The notebook explains how to:\n",
"\n",
@@ -39,17 +39,62 @@
},
{
"cell_type": "code",
- "execution_count": null,
+ "execution_count": 19,
"id": "c5e580ff",
- "metadata": {},
- "outputs": [],
+ "metadata": {
+ "collapsed": true,
+ "jupyter": {
+ "outputs_hidden": true
+ },
+ "scrolled": true
+ },
+ "outputs": [
+ {
+ "name": "stdout",
+ "output_type": "stream",
+ "text": [
+ "Requirement already satisfied: lonboard in
/opt/miniconda3/lib/python3.12/site-packages (0.12.1)\n",
+ "Requirement already satisfied: anywidget~=0.9.0 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.9.18)\n",
+ "Requirement already satisfied: arro3-compute>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)\n",
+ "Requirement already satisfied: arro3-core>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)\n",
+ "Requirement already satisfied: arro3-io>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)\n",
+ "Requirement already satisfied: geoarrow-rust-core>=0.5.2 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.5.2)\n",
+ "Requirement already satisfied: ipywidgets>=7.6.0 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (8.1.7)\n",
+ "Requirement already satisfied: numpy>=1.14 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (2.3.3)\n",
+ "Requirement already satisfied: pyproj>=3.3 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (3.7.2)\n",
+ "Requirement already satisfied: traitlets>=5.7.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (5.14.3)\n",
+ "Requirement already satisfied: psygnal>=0.8.1 in
/opt/miniconda3/lib/python3.12/site-packages (from anywidget~=0.9.0->lonboard)
(0.14.1)\n",
+ "Requirement already satisfied: typing-extensions>=4.2.0 in
/opt/miniconda3/lib/python3.12/site-packages (from anywidget~=0.9.0->lonboard)
(4.15.0)\n",
+ "Requirement already satisfied: comm>=0.1.3 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(0.2.3)\n",
+ "Requirement already satisfied: ipython>=6.1.0 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(9.5.0)\n",
+ "Requirement already satisfied: widgetsnbextension~=4.0.14 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(4.0.14)\n",
+ "Requirement already satisfied: jupyterlab_widgets~=3.0.15 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(3.0.15)\n",
+ "Requirement already satisfied: certifi in
/opt/miniconda3/lib/python3.12/site-packages (from pyproj>=3.3->lonboard)
(2025.8.3)\n",
+ "Requirement already satisfied: decorator in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (5.2.1)\n",
+ "Requirement already satisfied: ipython-pygments-lexers in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (1.1.1)\n",
+ "Requirement already satisfied: jedi>=0.16 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.19.2)\n",
+ "Requirement already satisfied: matplotlib-inline in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.1.7)\n",
+ "Requirement already satisfied: pexpect>4.3 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (4.9.0)\n",
+ "Requirement already satisfied: prompt_toolkit<3.1.0,>=3.0.41 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (3.0.52)\n",
+ "Requirement already satisfied: pygments>=2.4.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (2.19.2)\n",
+ "Requirement already satisfied: stack_data in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.6.3)\n",
+ "Requirement already satisfied: parso<0.9.0,>=0.8.4 in
/opt/miniconda3/lib/python3.12/site-packages (from
jedi>=0.16->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.8.5)\n",
+ "Requirement already satisfied: ptyprocess>=0.5 in
/opt/miniconda3/lib/python3.12/site-packages (from
pexpect>4.3->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.7.0)\n",
+ "Requirement already satisfied: wcwidth in
/opt/miniconda3/lib/python3.12/site-packages (from
prompt_toolkit<3.1.0,>=3.0.41->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard)
(0.2.14)\n",
+ "Requirement already satisfied: executing>=1.2.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (2.2.1)\n",
+ "Requirement already satisfied: asttokens>=2.1.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (3.0.0)\n",
+ "Requirement already satisfied: pure-eval in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.2.3)\n",
+ "Note: you may need to restart the kernel to use updated packages.\n"
+ ]
+ }
+ ],
"source": [
"%pip install lonboard"
]
},
{
"cell_type": "code",
- "execution_count": 17,
+ "execution_count": 2,
"id": "6d6fa0ab-b4ed-4e60-b099-a1af0998b486",
"metadata": {},
"outputs": [],
@@ -73,19 +118,19 @@
},
{
"cell_type": "code",
- "execution_count": 18,
+ "execution_count": 3,
"id": "52855769-4872-472a-9c42-afced3d85ca8",
"metadata": {},
"outputs": [],
"source": [
"df = sd.read_parquet(\n",
- "
\"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=buildings/type=building/\"\n",
+ "
\"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=buildings/type=building/\"\n",
")"
]
},
{
"cell_type": "code",
- "execution_count": 19,
+ "execution_count": 4,
"id": "b45b5e5c-64ed-49ba-a8aa-9f2292f617c6",
"metadata": {},
"outputs": [
@@ -97,25 +142,25 @@
"β id β geometry
β β¦ β roof_height β\n",
"β utf8 β geometry
β β float64 β\n",
"ββββββββββββββββββββββββββββββββββββββββͺββββββββββββββββββββββββββββββββββββββββββͺββββͺββββββββββββββ‘\n",
- "β afc55d29-5916-42ad-8f9c-76ba9d749be9 β POLYGON((-74.5920939
4.893956,-74.5920β¦ β β¦ β β\n",
+ "β 85b47da4-1b8d-4132-ac6c-d8dc14fab4b8 β POLYGON((-6.4292972
54.8290034,-6.4291β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 9c7ece54-88ff-48d4-8b48-11959fb058a1 β POLYGON((-74.5906253
4.8896057,-74.590β¦ β β¦ β β\n",
+ "β ec12e345-d44d-4e40-8e08-e1e6e68d4d17 β POLYGON((-6.430836
54.8299412,-6.43095β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 24fde8c7-6771-4205-b9da-2599d825f85f β POLYGON((-74.5905666
4.8896679,-74.590β¦ β β¦ β β\n",
+ "β 285f9ff9-2d6d-409c-b214-74992c8d7e7d β POLYGON((-6.4311579
54.8300247,-6.4313β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 79bdbb6f-5a9f-4b35-8e30-eb9019a6a1d7 β POLYGON((-74.5905272
4.8896867,-74.590β¦ β β¦ β β\n",
+ "β abedfc7c-e5fd-4a29-931e-da77b610d02d β POLYGON((-6.4321833
54.8294427,-6.4322β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 45ca1264-1062-41de-9375-82d93d93ee31 β POLYGON((-74.590441
4.8897205,-74.5904β¦ β β¦ β β\n",
+ "β a203a2c6-e130-4979-a7d5-8a059c6f31fd β POLYGON((-6.4300627
54.829276,-6.43006β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β b22e0827-bc09-439f-85cf-5401db561a23 β POLYGON((-74.5903646
4.889949,-74.5903β¦ β β¦ β β\n",
+ "β 1d14caf6-b12d-486e-87dd-feef82fba9a7 β POLYGON((-6.4301786
54.8281533,-6.4299β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 754bf2dd-81a3-498f-910d-b2b2cc18e1a2 β POLYGON((-74.589949
4.8891923,-74.5899β¦ β β¦ β β\n",
+ "β 4b1e67cf-7355-439b-9a31-46a50f3ee227 β POLYGON((-6.4298614
54.8278977,-6.4299β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 77464ae4-77d9-45ac-ac28-e6f972de9363 β POLYGON((-74.5898331
4.889214,-74.5897β¦ β β¦ β β\n",
+ "β 06de994e-efd4-4a1c-8a20-b4e883904cb2 β POLYGON((-6.4296383
54.827599,-6.42956β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 0f02d3f6-bbec-4cc0-89e5-65c3c4676cf1 β POLYGON((-74.5899092
4.8892714,-74.589β¦ β β¦ β β\n",
+ "β ea0b2ea6-7c52-4395-9baa-bc023c7d3166 β POLYGON((-6.4296844
54.8277379,-6.4296β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€\n",
- "β 696976a2-ff13-4b89-9953-8fd74b400828 β POLYGON((-74.5902424
4.889916,-74.5902β¦ β β¦ β β\n",
+ "β 49f022ef-5574-4613-ae54-af139666fde3 β POLYGON((-6.4296843
54.8278169,-6.4296β¦ β β¦ β β\n",
"ββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββ΄ββββ΄ββββββββββββββ\n"
]
}
@@ -126,7 +171,7 @@
},
{
"cell_type": "code",
- "execution_count": 20,
+ "execution_count": 5,
"id": "e37a023e-0e80-403a-a65b-b5a190004f72",
"metadata": {},
"outputs": [],
@@ -136,7 +181,7 @@
},
{
"cell_type": "code",
- "execution_count": 21,
+ "execution_count": 6,
"id": "ebfe4776-e08f-4f38-97fc-fca8ec6fc364",
"metadata": {},
"outputs": [
@@ -148,7 +193,7 @@
"β count(*) β\n",
"β int64 β\n",
"ββββββββββββββ‘\n",
- "β 2539170484 β\n",
+ "β 2541497985 β\n",
"ββββββββββββββ\n"
]
}
@@ -165,7 +210,7 @@
},
{
"cell_type": "code",
- "execution_count": 22,
+ "execution_count": 7,
"id": "b73f670d-0d10-4a7a-bfc7-e2abe5d9edd2",
"metadata": {},
"outputs": [
@@ -177,7 +222,7 @@
" geometry: geometry<WkbView(ogc:crs84)>\n",
" bbox: struct<Struct(xmin Float32, xmax Float32, ymin Float32, ymax
Float32)>\n",
" version: int32<Int32>\n",
- " sources: list<List(Field { name: \"element\", data_type:
Struct([Field { name: \"property\", data_type: Utf8, nullable: true, dict_id:
0, dict_is_ordered: false, metadata: {} }, Field { name: \"dataset\",
data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false, metadata:
{} }, Field { name: \"record_id\", data_type: Utf8, nullable: true, dict_id: 0,
dict_is_ordered: false, metadata: {} }, Field { name: \"update_time\",
data_type: Utf8, nullable: true, dict_id: 0, di [...]
+ " sources: list<List(Field { name: \"element\", data_type:
Struct([Field { name: \"property\", data_type: Utf8, nullable: true, dict_id:
0, dict_is_ordered: false, metadata: {} }, Field { name: \"dataset\",
data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false, metadata:
{} }, Field { name: \"license\", data_type: Utf8, nullable: true, dict_id: 0,
dict_is_ordered: false, metadata: {} }, Field { name: \"record_id\", data_type:
Utf8, nullable: true, dict_id: 0, dict_i [...]
" level: int32<Int32>\n",
" subtype: utf8<Utf8View>\n",
" class: utf8<Utf8View>\n",
@@ -199,7 +244,7 @@
" roof_height: float64<Float64>"
]
},
- "execution_count": 22,
+ "execution_count": 7,
"metadata": {},
"output_type": "execute_result"
}
@@ -211,7 +256,7 @@
},
{
"cell_type": "code",
- "execution_count": 23,
+ "execution_count": 8,
"id": "68d1b68c-dd26-45c2-944f-61138b212943",
"metadata": {},
"outputs": [
@@ -223,15 +268,15 @@
"β id β height β num_floors β
roof_shape β centroid β\n",
"β utf8 β float64 β int32 β utf8
β geometry β\n",
"βββββββββββββββββββββββββββͺβββββββββββββββββββββͺβββββββββββββͺβββββββββββββͺββββββββββββββββββββββββββ‘\n",
- "β 1b9040c2-2e79-4f56-abaβ¦ β 22.4 β β
β POINT(-74.230407502993β¦ β\n",
+ "β aa8e3a73-c72c-4f1a-b6eβ¦ β 20.38205909729004 β β
β POINT(-74.187673580307β¦ β\n",
"βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€\n",
- "β 1b5e1cd2-d697-489e-892β¦ β 21.5 β β
β POINT(-74.231451103592β¦ β\n",
+ "β efe7616b-7f7e-464c-9ceβ¦ β 26.18361473083496 β β
β POINT(-74.189040982134β¦ β\n",
"βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€\n",
- "β c1afdf78-bf84-4b8f-ae1β¦ β 20.9 β β
β POINT(-74.232593032240β¦ β\n",
+ "β b3f734a1-325b-4e8c-b1dβ¦ β 27.025876998901367 β β
β POINT(-74.2558161 40.8β¦ β\n",
"βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€\n",
- "β 88f36399-b09f-491b-bb6β¦ β 24.5 β β
β POINT(-74.231878209597β¦ β\n",
+ "β 45d88655-e2f4-4a08-926β¦ β 25.485210418701172 β β
β POINT(-74.182252194444β¦ β\n",
"βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€\n",
- "β df37a283-f5bd-4822-a05β¦ β 24.154542922973633 β β
β POINT(-74.241910239840β¦ β\n",
+ "β 31e8353c-7d5b-4b20-94eβ¦ β 21.294815063476562 β β
β POINT(-74.197113787905β¦ β\n",
"βββββββββββββββββββββββββββ΄βββββββββββββββββββββ΄βββββββββββββ΄βββββββββββββ΄ββββββββββββββββββββββββββ\n"
]
}
@@ -273,19 +318,19 @@
},
{
"cell_type": "code",
- "execution_count": 24,
+ "execution_count": 9,
"id": "d9f122d3-4d90-46b0-ab9a-259a71cc423b",
"metadata": {},
"outputs": [],
"source": [
"df = sd.read_parquet(\n",
- "
\"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=divisions/type=division_area/\"\n",
+ "
\"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=divisions/type=division_area/\"\n",
")"
]
},
{
"cell_type": "code",
- "execution_count": 25,
+ "execution_count": 10,
"id": "19a75b19-0b56-4167-b3f1-73a171ecc480",
"metadata": {},
"outputs": [
@@ -297,25 +342,25 @@
"β id β geometry β bbox β β¦ β
is_territorial β region β division_id β\n",
"β utf8 β geometry β struct β β boolean
β utf8 β utf8 β\n",
"βββββββββββββββββββͺβββββββββββββββββͺβββββββββββββββββͺββββͺβββββββββββββββββͺβββββββββͺβββββββββββββββββ‘\n",
- "β ae415364-9d06-β¦ β MULTIPOLYGON(β¦ β {xmin: 29.525β¦ β β¦ β true
β BY-MA β 7665e731-6552β¦ β\n",
+ "β 3665c36d-d3a9-β¦ β POLYGON((12.5β¦ β {xmin: 12.455β¦ β β¦ β true
β IT-34 β f05aa29f-151fβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β d712e9e1-84c6-β¦ β POLYGON((29.5β¦ β {xmin: 29.577β¦ β β¦ β true
β BY-MA β 4605a8a3-c576β¦ β\n",
+ "β 18a69439-a1da-β¦ β POLYGON((12.5β¦ β {xmin: 12.596β¦ β β¦ β true
β IT-36 β ae00d58c-6e67β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β bee9663a-af50-β¦ β POLYGON((29.5β¦ β {xmin: 29.587β¦ β β¦ β true
β BY-MA β 826a2333-7584β¦ β\n",
+ "β 7d0f6d37-bb55-β¦ β POLYGON((12.6β¦ β {xmin: 12.567β¦ β β¦ β true
β IT-36 β bdfc82ca-5f23β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β a083b661-eb7b-β¦ β POLYGON((29.4β¦ β {xmin: 29.326β¦ β β¦ β true
β BY-MA β 17456e57-ebb6β¦ β\n",
+ "β 3f480ff6-6361-β¦ β POLYGON((12.5β¦ β {xmin: 12.549β¦ β β¦ β true
β IT-36 β 1c750104-4470β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 83ef05fa-43ad-β¦ β POLYGON((29.6β¦ β {xmin: 29.598β¦ β β¦ β true
β BY-MA β a44666eb-c61dβ¦ β\n",
+ "β 31c3ab5e-eb6f-β¦ β POLYGON((12.6β¦ β {xmin: 12.612β¦ β β¦ β true
β IT-34 β d90804ee-19a4β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 4d01e5b4-86f9-β¦ β POLYGON((29.5β¦ β {xmin: 29.531β¦ β β¦ β true
β BY-MA β 77cdd054-ec26β¦ β\n",
+ "β 308517e6-64b4-β¦ β POLYGON((12.5β¦ β {xmin: 12.589β¦ β β¦ β true
β IT-34 β aabd71e9-4d98β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β c2a12db9-a1d0-β¦ β POLYGON((29.5β¦ β {xmin: 29.537β¦ β β¦ β true
β BY-MA β 4faa3881-e9a8β¦ β\n",
+ "β 646e5b1f-b76a-β¦ β POLYGON((12.5β¦ β {xmin: 12.485β¦ β β¦ β true
β IT-34 β 502c1c4e-fc19β¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 7c290d7b-3f7f-β¦ β POLYGON((29.6β¦ β {xmin: 29.607β¦ β β¦ β true
β BY-MA β e5233235-d513β¦ β\n",
+ "β f2809a49-1082-β¦ β POLYGON((12.5β¦ β {xmin: 12.538β¦ β β¦ β true
β IT-34 β 8b446eed-00adβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 579063f0-f751-β¦ β POLYGON((29.6β¦ β {xmin: 29.614β¦ β β¦ β true
β BY-MA β 3f0c8f4e-c9c8β¦ β\n",
+ "β 72b27245-c7fd-β¦ β POLYGON((12.5β¦ β {xmin: 12.501β¦ β β¦ β true
β IT-34 β 1d535e1f-d19eβ¦ β\n",
"βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€\n",
- "β 675aab04-ed91-β¦ β POLYGON((29.6β¦ β {xmin: 29.616β¦ β β¦ β true
β BY-MA β 02f5979e-7976β¦ β\n",
+ "β 815855d9-05d0-β¦ β POLYGON((12.4β¦ β {xmin: 12.371β¦ β β¦ β true
β IT-34 β 5aa91354-9e8cβ¦ β\n",
"βββββββββββββββββββ΄βββββββββββββββββ΄βββββββββββββββββ΄ββββ΄βββββββββββββββββ΄βββββββββ΄βββββββββββββββββ\n"
]
}
@@ -327,7 +372,7 @@
},
{
"cell_type": "code",
- "execution_count": 26,
+ "execution_count": 11,
"id": "03b951de-3397-4fcf-9baf-50e139a38dd4",
"metadata": {},
"outputs": [],
@@ -337,7 +382,7 @@
},
{
"cell_type": "code",
- "execution_count": 27,
+ "execution_count": 12,
"id": "9c6bd69d-9407-432a-bdc8-d60976237a3a",
"metadata": {},
"outputs": [
@@ -349,7 +394,7 @@
"β count(*) β\n",
"β int64 β\n",
"ββββββββββββ‘\n",
- "β 1035749 β\n",
+ "β 1052542 β\n",
"ββββββββββββ\n"
]
}
@@ -364,7 +409,7 @@
},
{
"cell_type": "code",
- "execution_count": 28,
+ "execution_count": 13,
"id": "75a6d0ed-9767-4d36-a77a-4afb7952fbe4",
"metadata": {},
"outputs": [
@@ -377,7 +422,7 @@
" bbox: struct<Struct(xmin Float32, xmax Float32, ymin Float32, ymax
Float32)>\n",
" country: utf8<Utf8View>\n",
" version: int32<Int32>\n",
- " sources: list<List(Field { name: \"element\", data_type:
Struct([Field { name: \"property\", data_type: Utf8, nullable: true, dict_id:
0, dict_is_ordered: false, metadata: {} }, Field { name: \"dataset\",
data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false, metadata:
{} }, Field { name: \"record_id\", data_type: Utf8, nullable: true, dict_id: 0,
dict_is_ordered: false, metadata: {} }, Field { name: \"update_time\",
data_type: Utf8, nullable: true, dict_id: 0, di [...]
+ " sources: list<List(Field { name: \"element\", data_type:
Struct([Field { name: \"property\", data_type: Utf8, nullable: true, dict_id:
0, dict_is_ordered: false, metadata: {} }, Field { name: \"dataset\",
data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false, metadata:
{} }, Field { name: \"license\", data_type: Utf8, nullable: true, dict_id: 0,
dict_is_ordered: false, metadata: {} }, Field { name: \"record_id\", data_type:
Utf8, nullable: true, dict_id: 0, dict_i [...]
" subtype: utf8<Utf8View>\n",
" class: utf8<Utf8View>\n",
" names: struct<Struct(primary Utf8, common Map(Field { name:
\"key_value\", data_type: Struct([Field { name: \"key\", data_type: Utf8,
nullable: false, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field {
name: \"value\", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }]), nullable: false, dict_id: 0, dict_is_ordered: false,
metadata: {} }, false), rules List(Field { name: \"element\", data_type:
Struct([Field { name: \"variant\", data_t [...]
@@ -387,7 +432,7 @@
" division_id: utf8<Utf8View>"
]
},
- "execution_count": 28,
+ "execution_count": 13,
"metadata": {},
"output_type": "execute_result"
}
@@ -398,7 +443,7 @@
},
{
"cell_type": "code",
- "execution_count": 29,
+ "execution_count": 14,
"id": "f1f7158c-ef2b-4377-9bee-180309ddd553",
"metadata": {},
"outputs": [],
@@ -421,7 +466,7 @@
},
{
"cell_type": "code",
- "execution_count": 30,
+ "execution_count": 15,
"id": "27e6909d-06fa-438b-88e0-d300fd2fb1ec",
"metadata": {},
"outputs": [],
@@ -431,7 +476,7 @@
},
{
"cell_type": "code",
- "execution_count": 31,
+ "execution_count": 16,
"id": "2dec92d8-a374-4021-990a-e50f5769516e",
"metadata": {},
"outputs": [],
@@ -445,7 +490,7 @@
},
{
"cell_type": "code",
- "execution_count": 32,
+ "execution_count": 17,
"id": "7f39a283-0eee-4f72-a30a-8dd9fa1aaa69",
"metadata": {
"scrolled": true
@@ -459,12 +504,12 @@
"β __unnest_placeholder(n β __unnest_placeholder(n β
__unnest_placeholder(n β geometry β\n",
"β s_divisions.names).prβ¦ β s_divisions.names).coβ¦ β
s_divisions.names).ruβ¦ β geometry β\n",
"ββββββββββββββββββββββββββͺβββββββββββββββββββββββββͺβββββββββββββββββββββββββͺββββββββββββββββββββββββ‘\n",
- "β Seal Island β β
β POLYGON((-66.0528452β¦ β\n",
+ "β Apple River β β
β POLYGON((-64.7260681β¦ β\n",
"ββββββββββββββββββββββββββΌβββββββββββββββββββββββββΌβββββββββββββββββββββββββΌββββββββββββββββββββββββ€\n",
- "β Mud Island β β
β POLYGON((-66.0222822β¦ β\n",
+ "β Allen Hill β β
β POLYGON((-64.6956656β¦ β\n",
"ββββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄ββββββββββββββββββββββββ\n",
- "CPU times: user 1.51 ms, sys: 1.69 ms, total: 3.2 ms\n",
- "Wall time: 3.14 ms\n"
+ "CPU times: user 1.25 ms, sys: 805 ΞΌs, total: 2.05 ms\n",
+ "Wall time: 1.42 ms\n"
]
}
],
@@ -484,19 +529,14 @@
},
{
"cell_type": "code",
- "execution_count": 36,
+ "execution_count": 18,
"id": "f78583fd-a73a-4169-9c45-74d8026bb5fb",
- "metadata": {
- "collapsed": true,
- "jupyter": {
- "outputs_hidden": true
- }
- },
+ "metadata": {},
"outputs": [
{
"data": {
"application/vnd.jupyter.widget-view+json": {
- "model_id": "560eccc4e795458b815ef78a70548d82",
+ "model_id": "02a229b2c09f4acf8ae4daedcb8af8ae",
"version_major": 2,
"version_minor": 1
},
@@ -504,7 +544,7 @@
"Map(basemap_style=<CartoBasemap.DarkMatter:
'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'β¦"
]
},
- "execution_count": 36,
+ "execution_count": 18,
"metadata": {},
"output_type": "execute_result"
}
diff --git a/docs/overture-examples.md b/docs/overture-examples.md
index 94f9cab0..3f61d93d 100644
--- a/docs/overture-examples.md
+++ b/docs/overture-examples.md
@@ -21,7 +21,7 @@
> Note: Before running this notebook, ensure that you have installed SedonaDB:
> `pip install "apache-sedona[db]"`
-This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB.
+This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB. See [this
page](https://docs.overturemaps.org/release-calendar/) to get the latest
version of the Overture data.
The notebook explains how to:
@@ -34,6 +34,40 @@ The notebook explains how to:
%pip install lonboard
```
+ Requirement already satisfied: lonboard in
/opt/miniconda3/lib/python3.12/site-packages (0.12.1)
+ Requirement already satisfied: anywidget~=0.9.0 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.9.18)
+ Requirement already satisfied: arro3-compute>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)
+ Requirement already satisfied: arro3-core>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)
+ Requirement already satisfied: arro3-io>=0.4.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.6.3)
+ Requirement already satisfied: geoarrow-rust-core>=0.5.2 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (0.5.2)
+ Requirement already satisfied: ipywidgets>=7.6.0 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (8.1.7)
+ Requirement already satisfied: numpy>=1.14 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (2.3.3)
+ Requirement already satisfied: pyproj>=3.3 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (3.7.2)
+ Requirement already satisfied: traitlets>=5.7.1 in
/opt/miniconda3/lib/python3.12/site-packages (from lonboard) (5.14.3)
+ Requirement already satisfied: psygnal>=0.8.1 in
/opt/miniconda3/lib/python3.12/site-packages (from anywidget~=0.9.0->lonboard)
(0.14.1)
+ Requirement already satisfied: typing-extensions>=4.2.0 in
/opt/miniconda3/lib/python3.12/site-packages (from anywidget~=0.9.0->lonboard)
(4.15.0)
+ Requirement already satisfied: comm>=0.1.3 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(0.2.3)
+ Requirement already satisfied: ipython>=6.1.0 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(9.5.0)
+ Requirement already satisfied: widgetsnbextension~=4.0.14 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(4.0.14)
+ Requirement already satisfied: jupyterlab_widgets~=3.0.15 in
/opt/miniconda3/lib/python3.12/site-packages (from ipywidgets>=7.6.0->lonboard)
(3.0.15)
+ Requirement already satisfied: certifi in
/opt/miniconda3/lib/python3.12/site-packages (from pyproj>=3.3->lonboard)
(2025.8.3)
+ Requirement already satisfied: decorator in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (5.2.1)
+ Requirement already satisfied: ipython-pygments-lexers in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (1.1.1)
+ Requirement already satisfied: jedi>=0.16 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.19.2)
+ Requirement already satisfied: matplotlib-inline in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.1.7)
+ Requirement already satisfied: pexpect>4.3 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (4.9.0)
+ Requirement already satisfied: prompt_toolkit<3.1.0,>=3.0.41 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (3.0.52)
+ Requirement already satisfied: pygments>=2.4.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (2.19.2)
+ Requirement already satisfied: stack_data in
/opt/miniconda3/lib/python3.12/site-packages (from
ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.6.3)
+ Requirement already satisfied: parso<0.9.0,>=0.8.4 in
/opt/miniconda3/lib/python3.12/site-packages (from
jedi>=0.16->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.8.5)
+ Requirement already satisfied: ptyprocess>=0.5 in
/opt/miniconda3/lib/python3.12/site-packages (from
pexpect>4.3->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.7.0)
+ Requirement already satisfied: wcwidth in
/opt/miniconda3/lib/python3.12/site-packages (from
prompt_toolkit<3.1.0,>=3.0.41->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard)
(0.2.14)
+ Requirement already satisfied: executing>=1.2.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (2.2.1)
+ Requirement already satisfied: asttokens>=2.1.0 in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (3.0.0)
+ Requirement already satisfied: pure-eval in
/opt/miniconda3/lib/python3.12/site-packages (from
stack_data->ipython>=6.1.0->ipywidgets>=7.6.0->lonboard) (0.2.3)
+ Note: you may need to restart the kernel to use updated packages.
+
+
```python
import sedona.db
@@ -50,7 +84,7 @@ sd = sedona.db.connect()
```python
df = sd.read_parquet(
-
"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=buildings/type=building/"
+
"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=buildings/type=building/"
)
```
@@ -63,25 +97,25 @@ df.limit(10).show()
β id β geometry
β β¦ β roof_height β
β utf8 β geometry
β β float64 β
ββββββββββββββββββββββββββββββββββββββββͺββββββββββββββββββββββββββββββββββββββββββͺββββͺββββββββββββββ‘
- β afc55d29-5916-42ad-8f9c-76ba9d749be9 β POLYGON((-74.5920939
4.893956,-74.5920β¦ β β¦ β β
+ β 85b47da4-1b8d-4132-ac6c-d8dc14fab4b8 β POLYGON((-6.4292972
54.8290034,-6.4291β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 9c7ece54-88ff-48d4-8b48-11959fb058a1 β POLYGON((-74.5906253
4.8896057,-74.590β¦ β β¦ β β
+ β ec12e345-d44d-4e40-8e08-e1e6e68d4d17 β POLYGON((-6.430836
54.8299412,-6.43095β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 24fde8c7-6771-4205-b9da-2599d825f85f β POLYGON((-74.5905666
4.8896679,-74.590β¦ β β¦ β β
+ β 285f9ff9-2d6d-409c-b214-74992c8d7e7d β POLYGON((-6.4311579
54.8300247,-6.4313β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 79bdbb6f-5a9f-4b35-8e30-eb9019a6a1d7 β POLYGON((-74.5905272
4.8896867,-74.590β¦ β β¦ β β
+ β abedfc7c-e5fd-4a29-931e-da77b610d02d β POLYGON((-6.4321833
54.8294427,-6.4322β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 45ca1264-1062-41de-9375-82d93d93ee31 β POLYGON((-74.590441
4.8897205,-74.5904β¦ β β¦ β β
+ β a203a2c6-e130-4979-a7d5-8a059c6f31fd β POLYGON((-6.4300627
54.829276,-6.43006β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β b22e0827-bc09-439f-85cf-5401db561a23 β POLYGON((-74.5903646
4.889949,-74.5903β¦ β β¦ β β
+ β 1d14caf6-b12d-486e-87dd-feef82fba9a7 β POLYGON((-6.4301786
54.8281533,-6.4299β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 754bf2dd-81a3-498f-910d-b2b2cc18e1a2 β POLYGON((-74.589949
4.8891923,-74.5899β¦ β β¦ β β
+ β 4b1e67cf-7355-439b-9a31-46a50f3ee227 β POLYGON((-6.4298614
54.8278977,-6.4299β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 77464ae4-77d9-45ac-ac28-e6f972de9363 β POLYGON((-74.5898331
4.889214,-74.5897β¦ β β¦ β β
+ β 06de994e-efd4-4a1c-8a20-b4e883904cb2 β POLYGON((-6.4296383
54.827599,-6.42956β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 0f02d3f6-bbec-4cc0-89e5-65c3c4676cf1 β POLYGON((-74.5899092
4.8892714,-74.589β¦ β β¦ β β
+ β ea0b2ea6-7c52-4395-9baa-bc023c7d3166 β POLYGON((-6.4296844
54.8277379,-6.4296β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββΌββββββββββββββββββββββββββββββββββββββββββΌββββΌββββββββββββββ€
- β 696976a2-ff13-4b89-9953-8fd74b400828 β POLYGON((-74.5902424
4.889916,-74.5902β¦ β β¦ β β
+ β 49f022ef-5574-4613-ae54-af139666fde3 β POLYGON((-6.4296843
54.8278169,-6.4296β¦ β β¦ β β
ββββββββββββββββββββββββββββββββββββββββ΄ββββββββββββββββββββββββββββββββββββββββββ΄ββββ΄ββββββββββββββ
@@ -105,7 +139,7 @@ FROM
β count(*) β
β int64 β
ββββββββββββββ‘
- β 2539170484 β
+ β 2541497985 β
ββββββββββββββ
@@ -123,7 +157,7 @@ df.schema
geometry: geometry<WkbView(ogc:crs84)>
bbox: struct<Struct(xmin Float32, xmax Float32, ymin Float32, ymax
Float32)>
version: int32<Int32>
- sources: list<List(Field { name: "element", data_type: Struct([Field {
name: "property", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "dataset", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name:
"record_id", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "update_time", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: [...]
+ sources: list<List(Field { name: "element", data_type: Struct([Field {
name: "property", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "dataset", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name:
"license", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false,
metadata: {} }, Field { name: "record_id", data_type: Utf8, nullable: true,
dict_id: 0, dict_is_ordered: fal [...]
level: int32<Int32>
subtype: utf8<Utf8View>
class: utf8<Utf8View>
@@ -178,15 +212,15 @@ LIMIT 5;
β id β height β num_floors β roof_shape β
centroid β
β utf8 β float64 β int32 β utf8 β
geometry β
βββββββββββββββββββββββββββͺβββββββββββββββββββββͺβββββββββββββͺβββββββββββββͺββββββββββββββββββββββββββ‘
- β 1b9040c2-2e79-4f56-abaβ¦ β 22.4 β β β
POINT(-74.230407502993β¦ β
+ β aa8e3a73-c72c-4f1a-b6eβ¦ β 20.38205909729004 β β β
POINT(-74.187673580307β¦ β
βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€
- β 1b5e1cd2-d697-489e-892β¦ β 21.5 β β β
POINT(-74.231451103592β¦ β
+ β efe7616b-7f7e-464c-9ceβ¦ β 26.18361473083496 β β β
POINT(-74.189040982134β¦ β
βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€
- β c1afdf78-bf84-4b8f-ae1β¦ β 20.9 β β β
POINT(-74.232593032240β¦ β
+ β b3f734a1-325b-4e8c-b1dβ¦ β 27.025876998901367 β β β
POINT(-74.2558161 40.8β¦ β
βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€
- β 88f36399-b09f-491b-bb6β¦ β 24.5 β β β
POINT(-74.231878209597β¦ β
+ β 45d88655-e2f4-4a08-926β¦ β 25.485210418701172 β β β
POINT(-74.182252194444β¦ β
βββββββββββββββββββββββββββΌβββββββββββββββββββββΌβββββββββββββΌβββββββββββββΌββββββββββββββββββββββββββ€
- β df37a283-f5bd-4822-a05β¦ β 24.154542922973633 β β β
POINT(-74.241910239840β¦ β
+ β 31e8353c-7d5b-4b20-94eβ¦ β 21.294815063476562 β β β
POINT(-74.197113787905β¦ β
βββββββββββββββββββββββββββ΄βββββββββββββββββββββ΄βββββββββββββ΄βββββββββββββ΄ββββββββββββββββββββββββββ
@@ -195,7 +229,7 @@ LIMIT 5;
```python
df = sd.read_parquet(
-
"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=divisions/type=division_area/"
+
"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=divisions/type=division_area/"
)
```
@@ -209,25 +243,25 @@ df.show(10)
β id β geometry β bbox β β¦ β is_territorial β
region β division_id β
β utf8 β geometry β struct β β boolean β
utf8 β utf8 β
βββββββββββββββββββͺβββββββββββββββββͺβββββββββββββββββͺββββͺβββββββββββββββββͺβββββββββͺβββββββββββββββββ‘
- β ae415364-9d06-β¦ β MULTIPOLYGON(β¦ β {xmin: 29.525β¦ β β¦ β true β
BY-MA β 7665e731-6552β¦ β
+ β 3665c36d-d3a9-β¦ β POLYGON((12.5β¦ β {xmin: 12.455β¦ β β¦ β true β
IT-34 β f05aa29f-151fβ¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β d712e9e1-84c6-β¦ β POLYGON((29.5β¦ β {xmin: 29.577β¦ β β¦ β true β
BY-MA β 4605a8a3-c576β¦ β
+ β 18a69439-a1da-β¦ β POLYGON((12.5β¦ β {xmin: 12.596β¦ β β¦ β true β
IT-36 β ae00d58c-6e67β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β bee9663a-af50-β¦ β POLYGON((29.5β¦ β {xmin: 29.587β¦ β β¦ β true β
BY-MA β 826a2333-7584β¦ β
+ β 7d0f6d37-bb55-β¦ β POLYGON((12.6β¦ β {xmin: 12.567β¦ β β¦ β true β
IT-36 β bdfc82ca-5f23β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β a083b661-eb7b-β¦ β POLYGON((29.4β¦ β {xmin: 29.326β¦ β β¦ β true β
BY-MA β 17456e57-ebb6β¦ β
+ β 3f480ff6-6361-β¦ β POLYGON((12.5β¦ β {xmin: 12.549β¦ β β¦ β true β
IT-36 β 1c750104-4470β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β 83ef05fa-43ad-β¦ β POLYGON((29.6β¦ β {xmin: 29.598β¦ β β¦ β true β
BY-MA β a44666eb-c61dβ¦ β
+ β 31c3ab5e-eb6f-β¦ β POLYGON((12.6β¦ β {xmin: 12.612β¦ β β¦ β true β
IT-34 β d90804ee-19a4β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β 4d01e5b4-86f9-β¦ β POLYGON((29.5β¦ β {xmin: 29.531β¦ β β¦ β true β
BY-MA β 77cdd054-ec26β¦ β
+ β 308517e6-64b4-β¦ β POLYGON((12.5β¦ β {xmin: 12.589β¦ β β¦ β true β
IT-34 β aabd71e9-4d98β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β c2a12db9-a1d0-β¦ β POLYGON((29.5β¦ β {xmin: 29.537β¦ β β¦ β true β
BY-MA β 4faa3881-e9a8β¦ β
+ β 646e5b1f-b76a-β¦ β POLYGON((12.5β¦ β {xmin: 12.485β¦ β β¦ β true β
IT-34 β 502c1c4e-fc19β¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β 7c290d7b-3f7f-β¦ β POLYGON((29.6β¦ β {xmin: 29.607β¦ β β¦ β true β
BY-MA β e5233235-d513β¦ β
+ β f2809a49-1082-β¦ β POLYGON((12.5β¦ β {xmin: 12.538β¦ β β¦ β true β
IT-34 β 8b446eed-00adβ¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β 579063f0-f751-β¦ β POLYGON((29.6β¦ β {xmin: 29.614β¦ β β¦ β true β
BY-MA β 3f0c8f4e-c9c8β¦ β
+ β 72b27245-c7fd-β¦ β POLYGON((12.5β¦ β {xmin: 12.501β¦ β β¦ β true β
IT-34 β 1d535e1f-d19eβ¦ β
βββββββββββββββββββΌβββββββββββββββββΌβββββββββββββββββΌββββΌβββββββββββββββββΌβββββββββΌβββββββββββββββββ€
- β 675aab04-ed91-β¦ β POLYGON((29.6β¦ β {xmin: 29.616β¦ β β¦ β true β
BY-MA β 02f5979e-7976β¦ β
+ β 815855d9-05d0-β¦ β POLYGON((12.4β¦ β {xmin: 12.371β¦ β β¦ β true β
IT-34 β 5aa91354-9e8cβ¦ β
βββββββββββββββββββ΄βββββββββββββββββ΄βββββββββββββββββ΄ββββ΄βββββββββββββββββ΄βββββββββ΄βββββββββββββββββ
@@ -249,7 +283,7 @@ FROM division_area
β count(*) β
β int64 β
ββββββββββββ‘
- β 1035749 β
+ β 1052542 β
ββββββββββββ
@@ -267,7 +301,7 @@ df.schema
bbox: struct<Struct(xmin Float32, xmax Float32, ymin Float32, ymax
Float32)>
country: utf8<Utf8View>
version: int32<Int32>
- sources: list<List(Field { name: "element", data_type: Struct([Field {
name: "property", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "dataset", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name:
"record_id", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "update_time", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: [...]
+ sources: list<List(Field { name: "element", data_type: Struct([Field {
name: "property", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered:
false, metadata: {} }, Field { name: "dataset", data_type: Utf8, nullable:
true, dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name:
"license", data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false,
metadata: {} }, Field { name: "record_id", data_type: Utf8, nullable: true,
dict_id: 0, dict_is_ordered: fal [...]
subtype: utf8<Utf8View>
class: utf8<Utf8View>
names: struct<Struct(primary Utf8, common Map(Field { name: "key_value",
data_type: Struct([Field { name: "key", data_type: Utf8, nullable: false,
dict_id: 0, dict_is_ordered: false, metadata: {} }, Field { name: "value",
data_type: Utf8, nullable: true, dict_id: 0, dict_is_ordered: false, metadata:
{} }]), nullable: false, dict_id: 0, dict_is_ordered: false, metadata: {} },
false), rules List(Field { name: "element", data_type: Struct([Field { name:
"variant", data_type: Utf8, nul [...]
@@ -321,12 +355,12 @@ df.show(2)
β __unnest_placeholder(n β __unnest_placeholder(n β __unnest_placeholder(n
β geometry β
β s_divisions.names).prβ¦ β s_divisions.names).coβ¦ β s_divisions.names).ruβ¦
β geometry β
ββββββββββββββββββββββββββͺβββββββββββββββββββββββββͺβββββββββββββββββββββββββͺββββββββββββββββββββββββ‘
- β Seal Island β β
β POLYGON((-66.0528452β¦ β
+ β Apple River β β
β POLYGON((-64.7260681β¦ β
ββββββββββββββββββββββββββΌβββββββββββββββββββββββββΌβββββββββββββββββββββββββΌββββββββββββββββββββββββ€
- β Mud Island β β
β POLYGON((-66.0222822β¦ β
+ β Allen Hill β β
β POLYGON((-64.6956656β¦ β
ββββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄βββββββββββββββββββββββββ΄ββββββββββββββββββββββββ
- CPU times: user 1.51 ms, sys: 1.69 ms, total: 3.2 ms
- Wall time: 3.14 ms
+ CPU times: user 1.25 ms, sys: 805 ΞΌs, total: 2.05 ms
+ Wall time: 1.42 ms
## Visualize the results with lonboard
diff --git a/docs/programming-guide.ipynb b/docs/programming-guide.ipynb
index db15b7d2..6a3459c4 100644
--- a/docs/programming-guide.ipynb
+++ b/docs/programming-guide.ipynb
@@ -45,7 +45,7 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": 1,
"id": "53c3b7a8-c42a-407a-a454-6ee1e943fbcc",
"metadata": {},
"outputs": [],
@@ -71,7 +71,7 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": 2,
"id": "b3377767-d747-407c-92c0-8786c1998131",
"metadata": {},
"outputs": [],
@@ -94,17 +94,17 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": 3,
"id": "e8be30ab-4818-4db8-bae2-83e973ad1b77",
"metadata": {},
"outputs": [
{
"data": {
"text/plain": [
- "sedona.db.dataframe.DataFrame"
+ "sedonadb.dataframe.DataFrame"
]
},
- "execution_count": 4,
+ "execution_count": 3,
"metadata": {},
"output_type": "execute_result"
}
@@ -125,13 +125,13 @@
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": 4,
"id": "151df287-4b2d-433e-9769-c3378df03b1b",
"metadata": {},
"outputs": [],
"source": [
"sd.read_parquet(\n",
- "
\"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=divisions/type=division_area/\",\n",
+ "
\"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=divisions/type=division_area/\",\n",
" options={\"aws.skip_signature\": True, \"aws.region\":
\"us-west-2\"},\n",
").to_view(\"division_area\")"
]
@@ -152,7 +152,7 @@
},
{
"cell_type": "code",
- "execution_count": null,
+ "execution_count": 11,
"id": "b81549f2-0f58-49e4-9011-8de6578c2b0e",
"metadata": {},
"outputs": [],
@@ -173,7 +173,7 @@
},
{
"cell_type": "code",
- "execution_count": 7,
+ "execution_count": 6,
"id": "0e4819db-bf58-42d7-8b5b-f272d0f19266",
"metadata": {},
"outputs": [
@@ -215,7 +215,7 @@
},
{
"cell_type": "code",
- "execution_count": 8,
+ "execution_count": 12,
"id": "8c8a4b48-8c4e-412e-900f-8c0f6f4ccc1d",
"metadata": {},
"outputs": [
@@ -223,16 +223,16 @@
"name": "stdout",
"output_type": "stream",
"text": [
-
"ββββββββββββ¬βββββββββββ¬βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ\n",
- "β country β region β geometry
β\n",
- "β utf8view β utf8view β geometry
β\n",
-
"ββββββββββββͺβββββββββββͺβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ‘\n",
- "β CA β CA-NS β POLYGON((-66.0528452 43.4531336,-66.0883401
43.3978188,-65.9647654 43.361β¦ β\n",
-
"ββββββββββββΌβββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€\n",
- "β CA β CA-NS β POLYGON((-66.0222822 43.5166842,-66.0252286
43.5100071,-66.0528452 43.453β¦ β\n",
-
"ββββββββββββΌβββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€\n",
- "β CA β CA-NS β POLYGON((-65.7451389 43.5336263,-65.7450818
43.5347004,-65.7449545 43.535β¦ β\n",
-
"ββββββββββββ΄βββββββββββ΄βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ\n"
+
"βββββββββββ¬βββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ\n",
+ "β country β region β geometry
β\n",
+ "β utf8 β utf8 β geometry
β\n",
+
"βββββββββββͺβββββββββͺββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ‘\n",
+ "β CA β CA-NB β MULTIPOLYGON(((-67.1074147 44.4817314,-67.1058772
44.4815007,-67.104319 44.4β¦ β\n",
+
"βββββββββββΌβββββββββΌββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€\n",
+ "β CA β CA-NB β POLYGON((-66.2598821 45.1380421,-66.2599962
45.1381233,-66.2600591 45.138285β¦ β\n",
+
"βββββββββββΌβββββββββΌββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€\n",
+ "β CA β CA-NB β POLYGON((-66.4595418 45.2215004,-66.4595406
45.221468,-66.4595396 45.2213915β¦ β\n",
+
"βββββββββββ΄βββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ\n"
]
}
],
@@ -264,7 +264,7 @@
},
{
"cell_type": "code",
- "execution_count": null,
+ "execution_count": 8,
"id": "deaa36db-2fee-4ba2-ab79-1dc756cb1655",
"metadata": {},
"outputs": [],
@@ -296,7 +296,7 @@
},
{
"cell_type": "code",
- "execution_count": 10,
+ "execution_count": 9,
"id": "e3bc4976-4245-432f-b265-7f6aa13f35b9",
"metadata": {},
"outputs": [
@@ -331,7 +331,7 @@
},
{
"cell_type": "code",
- "execution_count": 11,
+ "execution_count": 10,
"id": "05565e15-ee18-431c-8fd2-673291d8d0ee",
"metadata": {},
"outputs": [
diff --git a/docs/programming-guide.md b/docs/programming-guide.md
index a59e7ced..1dfe982a 100644
--- a/docs/programming-guide.md
+++ b/docs/programming-guide.md
@@ -64,7 +64,7 @@ type(df)
- sedona.db.dataframe.DataFrame
+ sedonadb.dataframe.DataFrame
@@ -75,7 +75,7 @@ For most production applications, you will create SedonaDB
DataFrames by reading
```python
sd.read_parquet(
-
"s3://overturemaps-us-west-2/release/2025-08-20.0/theme=divisions/type=division_area/",
+
"s3://overturemaps-us-west-2/release/2025-11-19.0/theme=divisions/type=division_area/",
options={"aws.skip_signature": True, "aws.region": "us-west-2"},
).to_view("division_area")
```
@@ -139,16 +139,16 @@ WHERE ST_Intersects(geometry,
ST_SetSRID(ST_GeomFromText('{nova_scotia_bbox_wkt}
ns.show(3)
```
-
ββββββββββββ¬βββββββββββ¬βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
- β country β region β geometry
β
- β utf8view β utf8view β geometry
β
-
ββββββββββββͺβββββββββββͺβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ‘
- β CA β CA-NS β POLYGON((-66.0528452 43.4531336,-66.0883401
43.3978188,-65.9647654 43.361β¦ β
-
ββββββββββββΌβββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
- β CA β CA-NS β POLYGON((-66.0222822 43.5166842,-66.0252286
43.5100071,-66.0528452 43.453β¦ β
-
ββββββββββββΌβββββββββββΌβββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
- β CA β CA-NS β POLYGON((-65.7451389 43.5336263,-65.7450818
43.5347004,-65.7449545 43.535β¦ β
-
ββββββββββββ΄βββββββββββ΄βββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
+
βββββββββββ¬βββββββββ¬ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
+ β country β region β geometry
β
+ β utf8 β utf8 β geometry
β
+
βββββββββββͺβββββββββͺββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ‘
+ β CA β CA-NB β MULTIPOLYGON(((-67.1074147 44.4817314,-67.1058772
44.4815007,-67.104319 44.4β¦ β
+
βββββββββββΌβββββββββΌββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
+ β CA β CA-NB β POLYGON((-66.2598821 45.1380421,-66.2599962
45.1381233,-66.2600591 45.138285β¦ β
+
βββββββββββΌβββββββββΌββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ€
+ β CA β CA-NB β POLYGON((-66.4595418 45.2215004,-66.4595406
45.221468,-66.4595396 45.2213915β¦ β
+
βββββββββββ΄βββββββββ΄ββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββββ
You can see it only includes the divisions in the Nova Scotia area.