This is an automated email from the ASF dual-hosted git repository.
jiayu 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 f02a6a0 docs: fixing formatting and adding pip (#148)
f02a6a0 is described below
commit f02a6a01df2a1478e375c33f3c61fef0b3a73b39
Author: Kelly-Ann Dolor <[email protected]>
AuthorDate: Wed Sep 24 21:07:16 2025 -0700
docs: fixing formatting and adding pip (#148)
---
docs/overture-examples.ipynb | 97 ++++++++++++++++++++++++--------------------
docs/overture-examples.md | 50 +++++++++++++----------
2 files changed, 82 insertions(+), 65 deletions(-)
diff --git a/docs/overture-examples.ipynb b/docs/overture-examples.ipynb
index 7070336..f76089c 100644
--- a/docs/overture-examples.ipynb
+++ b/docs/overture-examples.ipynb
@@ -31,6 +31,7 @@
"This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB.\n",
"\n",
"The notebook explains how to:\n",
+ "\n",
"* Load Overture data for the `buildings` and `divisions` themes directly
from S3.\n",
"* Perform spatial queries to find features within a specific geographic
area.\n",
"* Optimize subsequent query performance by caching a subset of data in
memory."
@@ -38,7 +39,17 @@
},
{
"cell_type": "code",
- "execution_count": 2,
+ "execution_count": null,
+ "id": "c5e580ff",
+ "metadata": {},
+ "outputs": [],
+ "source": [
+ "%pip install lonboard"
+ ]
+ },
+ {
+ "cell_type": "code",
+ "execution_count": 17,
"id": "6d6fa0ab-b4ed-4e60-b099-a1af0998b486",
"metadata": {},
"outputs": [],
@@ -62,7 +73,7 @@
},
{
"cell_type": "code",
- "execution_count": 3,
+ "execution_count": 18,
"id": "52855769-4872-472a-9c42-afced3d85ca8",
"metadata": {},
"outputs": [],
@@ -74,7 +85,7 @@
},
{
"cell_type": "code",
- "execution_count": 4,
+ "execution_count": 19,
"id": "b45b5e5c-64ed-49ba-a8aa-9f2292f617c6",
"metadata": {},
"outputs": [
@@ -86,25 +97,25 @@
"│ id ┆ geometry
┆ … ┆ roof_height │\n",
"│ utf8 ┆ geometry
┆ ┆ float64 │\n",
"╞══════════════════════════════════════╪═════════════════════════════════════════╪═══╪═════════════╡\n",
- "│ 97a89436-5295-417e-bde1-2dbf8fe10700 ┆ POLYGON((-107.0377042
28.8102782,-107.… ┆ … ┆ │\n",
+ "│ afc55d29-5916-42ad-8f9c-76ba9d749be9 ┆ POLYGON((-74.5920939
4.893956,-74.5920… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ e09fcdeb-65ab-443c-bc59-4f9acf32af17 ┆ POLYGON((-107.0372022
28.8103812,-107.… ┆ … ┆ │\n",
+ "│ 9c7ece54-88ff-48d4-8b48-11959fb058a1 ┆ POLYGON((-74.5906253
4.8896057,-74.590… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ cb06e75f-66a0-40ca-9029-e1a24dff1434 ┆ POLYGON((-107.0372848
28.8104923,-107.… ┆ … ┆ │\n",
+ "│ 24fde8c7-6771-4205-b9da-2599d825f85f ┆ POLYGON((-74.5905666
4.8896679,-74.590… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 ┆ POLYGON((-107.0371986
28.8104859,-107.… ┆ … ┆ │\n",
+ "│ 79bdbb6f-5a9f-4b35-8e30-eb9019a6a1d7 ┆ POLYGON((-74.5905272
4.8896867,-74.590… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 1a4fba29-6160-4a98-b8f7-03395fd6466a ┆ POLYGON((-107.0373331
28.8105281,-107.… ┆ … ┆ │\n",
+ "│ 45ca1264-1062-41de-9375-82d93d93ee31 ┆ POLYGON((-74.590441
4.8897205,-74.5904… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 9de2d803-ab58-46e1-9a35-7423f8d0d121 ┆ POLYGON((-107.0378928
28.8112268,-107.… ┆ … ┆ │\n",
+ "│ b22e0827-bc09-439f-85cf-5401db561a23 ┆ POLYGON((-74.5903646
4.889949,-74.5903… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 1704c72b-6f2b-445b-b9a3-36fdd0c74233 ┆ POLYGON((-107.0376099
28.8112085,-107.… ┆ … ┆ │\n",
+ "│ 754bf2dd-81a3-498f-910d-b2b2cc18e1a2 ┆ POLYGON((-74.589949
4.8891923,-74.5899… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ b30bf41d-479f-4ee5-bd45-d4e17ffd8875 ┆ POLYGON((-107.0377094
28.8115554,-107.… ┆ … ┆ │\n",
+ "│ 77464ae4-77d9-45ac-ac28-e6f972de9363 ┆ POLYGON((-74.5898331
4.889214,-74.5897… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ c88928d4-b165-4335-9bd8-ccc5c9f79cee ┆ POLYGON((-107.0374986
28.8111847,-107.… ┆ … ┆ │\n",
+ "│ 0f02d3f6-bbec-4cc0-89e5-65c3c4676cf1 ┆ POLYGON((-74.5899092
4.8892714,-74.589… ┆ … ┆ │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ ca1000b0-6af3-47fc-bdf2-61e8b1b716fc ┆ POLYGON((-107.0370972
28.8115247,-107.… ┆ … ┆ │\n",
+ "│ 696976a2-ff13-4b89-9953-8fd74b400828 ┆ POLYGON((-74.5902424
4.889916,-74.5902… ┆ … ┆ │\n",
"└──────────────────────────────────────┴─────────────────────────────────────────┴───┴─────────────┘\n"
]
}
@@ -115,7 +126,7 @@
},
{
"cell_type": "code",
- "execution_count": 5,
+ "execution_count": 20,
"id": "e37a023e-0e80-403a-a65b-b5a190004f72",
"metadata": {},
"outputs": [],
@@ -125,7 +136,7 @@
},
{
"cell_type": "code",
- "execution_count": 6,
+ "execution_count": 21,
"id": "ebfe4776-e08f-4f38-97fc-fca8ec6fc364",
"metadata": {},
"outputs": [
@@ -154,7 +165,7 @@
},
{
"cell_type": "code",
- "execution_count": 7,
+ "execution_count": 22,
"id": "b73f670d-0d10-4a7a-bfc7-e2abe5d9edd2",
"metadata": {},
"outputs": [
@@ -188,7 +199,7 @@
" roof_height: float64<Float64>"
]
},
- "execution_count": 7,
+ "execution_count": 22,
"metadata": {},
"output_type": "execute_result"
}
@@ -200,7 +211,7 @@
},
{
"cell_type": "code",
- "execution_count": 8,
+ "execution_count": 23,
"id": "68d1b68c-dd26-45c2-944f-61138b212943",
"metadata": {},
"outputs": [
@@ -262,7 +273,7 @@
},
{
"cell_type": "code",
- "execution_count": 9,
+ "execution_count": 24,
"id": "d9f122d3-4d90-46b0-ab9a-259a71cc423b",
"metadata": {},
"outputs": [],
@@ -274,7 +285,7 @@
},
{
"cell_type": "code",
- "execution_count": 10,
+ "execution_count": 25,
"id": "19a75b19-0b56-4167-b3f1-73a171ecc480",
"metadata": {},
"outputs": [
@@ -286,25 +297,25 @@
"│ id ┆ geometry ┆ bbox ┆ … ┆
is_territorial ┆ region ┆ division_id │\n",
"│ utf8 ┆ geometry ┆ struct ┆ ┆ boolean
┆ utf8 ┆ utf8 │\n",
"╞═════════════════╪════════════════╪════════════════╪═══╪════════════════╪════════╪════════════════╡\n",
- "│ cd743a89-9507-… ┆ POLYGON((111.… ┆ {xmin: 111.40… ┆ … ┆ true
┆ ┆ e08d9394-cbc8… │\n",
+ "│ ae415364-9d06-… ┆ MULTIPOLYGON(… ┆ {xmin: 29.525… ┆ … ┆ true
┆ BY-MA ┆ 7665e731-6552… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ eb9f314e-1184-… ┆ POLYGON((112.… ┆ {xmin: 112.15… ┆ … ┆ true
┆ ┆ aa2561c6-a578… │\n",
+ "│ d712e9e1-84c6-… ┆ POLYGON((29.5… ┆ {xmin: 29.577… ┆ … ┆ true
┆ BY-MA ┆ 4605a8a3-c576… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 89fbee90-bca0-… ┆ MULTIPOLYGON(… ┆ {xmin: 112.15… ┆ … ┆ true
┆ ┆ 1cf6b19e-756f… │\n",
+ "│ bee9663a-af50-… ┆ POLYGON((29.5… ┆ {xmin: 29.587… ┆ … ┆ true
┆ BY-MA ┆ 826a2333-7584… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 758c0e1e-67aa-… ┆ POLYGON((112.… ┆ {xmin: 112.27… ┆ … ┆ true
┆ ┆ 505f563f-7aa3… │\n",
+ "│ a083b661-eb7b-… ┆ POLYGON((29.4… ┆ {xmin: 29.326… ┆ … ┆ true
┆ BY-MA ┆ 17456e57-ebb6… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ e5d4c707-66d7-… ┆ POLYGON((109.… ┆ {xmin: 109.64… ┆ … ┆ true
┆ CN-HI ┆ 86939aee-1fbd… │\n",
+ "│ 83ef05fa-43ad-… ┆ POLYGON((29.6… ┆ {xmin: 29.598… ┆ … ┆ true
┆ BY-MA ┆ a44666eb-c61d… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ 26015e14-62ae-… ┆ POLYGON((109.… ┆ {xmin: 109.66… ┆ … ┆ true
┆ CN-HI ┆ ed052bae-e26f… │\n",
+ "│ 4d01e5b4-86f9-… ┆ POLYGON((29.5… ┆ {xmin: 29.531… ┆ … ┆ true
┆ BY-MA ┆ 77cdd054-ec26… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ eb42fd17-ad1e-… ┆ POLYGON((109.… ┆ {xmin: 109.83… ┆ … ┆ true
┆ CN-HI ┆ 201eeb03-4f5a… │\n",
+ "│ c2a12db9-a1d0-… ┆ POLYGON((29.5… ┆ {xmin: 29.537… ┆ … ┆ true
┆ BY-MA ┆ 4faa3881-e9a8… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ d63e1220-a308-… ┆ POLYGON((109.… ┆ {xmin: 109.90… ┆ … ┆ true
┆ CN-HI ┆ 71e30c32-2bc1… │\n",
+ "│ 7c290d7b-3f7f-… ┆ POLYGON((29.6… ┆ {xmin: 29.607… ┆ … ┆ true
┆ BY-MA ┆ e5233235-d513… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ e62cef5e-6768-… ┆ POLYGON((109.… ┆ {xmin: 109.74… ┆ … ┆ true
┆ CN-HI ┆ 24478621-6802… │\n",
+ "│ 579063f0-f751-… ┆ POLYGON((29.6… ┆ {xmin: 29.614… ┆ … ┆ true
┆ BY-MA ┆ 3f0c8f4e-c9c8… │\n",
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
- "│ c6fcbed1-ad8d-… ┆ POLYGON((110.… ┆ {xmin: 110.00… ┆ … ┆ true
┆ CN-HI ┆ ac0f434d-1e10… │\n",
+ "│ 675aab04-ed91-… ┆ POLYGON((29.6… ┆ {xmin: 29.616… ┆ … ┆ true
┆ BY-MA ┆ 02f5979e-7976… │\n",
"└─────────────────┴────────────────┴────────────────┴───┴────────────────┴────────┴────────────────┘\n"
]
}
@@ -316,7 +327,7 @@
},
{
"cell_type": "code",
- "execution_count": 11,
+ "execution_count": 26,
"id": "03b951de-3397-4fcf-9baf-50e139a38dd4",
"metadata": {},
"outputs": [],
@@ -326,7 +337,7 @@
},
{
"cell_type": "code",
- "execution_count": 12,
+ "execution_count": 27,
"id": "9c6bd69d-9407-432a-bdc8-d60976237a3a",
"metadata": {},
"outputs": [
@@ -353,7 +364,7 @@
},
{
"cell_type": "code",
- "execution_count": 13,
+ "execution_count": 28,
"id": "75a6d0ed-9767-4d36-a77a-4afb7952fbe4",
"metadata": {},
"outputs": [
@@ -376,7 +387,7 @@
" division_id: utf8<Utf8View>"
]
},
- "execution_count": 13,
+ "execution_count": 28,
"metadata": {},
"output_type": "execute_result"
}
@@ -387,7 +398,7 @@
},
{
"cell_type": "code",
- "execution_count": 14,
+ "execution_count": 29,
"id": "f1f7158c-ef2b-4377-9bee-180309ddd553",
"metadata": {},
"outputs": [],
@@ -410,7 +421,7 @@
},
{
"cell_type": "code",
- "execution_count": 15,
+ "execution_count": 30,
"id": "27e6909d-06fa-438b-88e0-d300fd2fb1ec",
"metadata": {},
"outputs": [],
@@ -420,7 +431,7 @@
},
{
"cell_type": "code",
- "execution_count": 16,
+ "execution_count": 31,
"id": "2dec92d8-a374-4021-990a-e50f5769516e",
"metadata": {},
"outputs": [],
@@ -434,7 +445,7 @@
},
{
"cell_type": "code",
- "execution_count": 17,
+ "execution_count": 32,
"id": "7f39a283-0eee-4f72-a30a-8dd9fa1aaa69",
"metadata": {
"scrolled": true
@@ -452,8 +463,8 @@
"├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n",
"│ Mud Island ┆ ┆
┆ POLYGON((-66.0222822… │\n",
"└────────────────────────┴────────────────────────┴────────────────────────┴───────────────────────┘\n",
- "CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms\n",
- "Wall time: 2.54 ms\n"
+ "CPU times: user 1.51 ms, sys: 1.69 ms, total: 3.2 ms\n",
+ "Wall time: 3.14 ms\n"
]
}
],
@@ -473,7 +484,7 @@
},
{
"cell_type": "code",
- "execution_count": 18,
+ "execution_count": 36,
"id": "f78583fd-a73a-4169-9c45-74d8026bb5fb",
"metadata": {
"collapsed": true,
@@ -485,7 +496,7 @@
{
"data": {
"application/vnd.jupyter.widget-view+json": {
- "model_id": "0dec2568b9e9420da04da4bf04eedc94",
+ "model_id": "560eccc4e795458b815ef78a70548d82",
"version_major": 2,
"version_minor": 1
},
@@ -493,7 +504,7 @@
"Map(basemap_style=<CartoBasemap.DarkMatter:
'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'…"
]
},
- "execution_count": 18,
+ "execution_count": 36,
"metadata": {},
"output_type": "execute_result"
}
diff --git a/docs/overture-examples.md b/docs/overture-examples.md
index b1de209..94f9cab 100644
--- a/docs/overture-examples.md
+++ b/docs/overture-examples.md
@@ -24,11 +24,17 @@
This notebook demonstrates how to query and analyze the [Overture
Maps](https://overturemaps.org/) dataset using SedonaDB.
The notebook explains how to:
+
* Load Overture data for the `buildings` and `divisions` themes directly from
S3.
* Perform spatial queries to find features within a specific geographic area.
* Optimize subsequent query performance by caching a subset of data in memory.
+```python
+%pip install lonboard
+```
+
+
```python
import sedona.db
import os
@@ -57,25 +63,25 @@ df.limit(10).show()
│ id ┆ geometry
┆ … ┆ roof_height │
│ utf8 ┆ geometry
┆ ┆ float64 │
╞══════════════════════════════════════╪═════════════════════════════════════════╪═══╪═════════════╡
- │ 97a89436-5295-417e-bde1-2dbf8fe10700 ┆ POLYGON((-107.0377042
28.8102782,-107.… ┆ … ┆ │
+ │ afc55d29-5916-42ad-8f9c-76ba9d749be9 ┆ POLYGON((-74.5920939
4.893956,-74.5920… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ e09fcdeb-65ab-443c-bc59-4f9acf32af17 ┆ POLYGON((-107.0372022
28.8103812,-107.… ┆ … ┆ │
+ │ 9c7ece54-88ff-48d4-8b48-11959fb058a1 ┆ POLYGON((-74.5906253
4.8896057,-74.590… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ cb06e75f-66a0-40ca-9029-e1a24dff1434 ┆ POLYGON((-107.0372848
28.8104923,-107.… ┆ … ┆ │
+ │ 24fde8c7-6771-4205-b9da-2599d825f85f ┆ POLYGON((-74.5905666
4.8896679,-74.590… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 ┆ POLYGON((-107.0371986
28.8104859,-107.… ┆ … ┆ │
+ │ 79bdbb6f-5a9f-4b35-8e30-eb9019a6a1d7 ┆ POLYGON((-74.5905272
4.8896867,-74.590… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 1a4fba29-6160-4a98-b8f7-03395fd6466a ┆ POLYGON((-107.0373331
28.8105281,-107.… ┆ … ┆ │
+ │ 45ca1264-1062-41de-9375-82d93d93ee31 ┆ POLYGON((-74.590441
4.8897205,-74.5904… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 9de2d803-ab58-46e1-9a35-7423f8d0d121 ┆ POLYGON((-107.0378928
28.8112268,-107.… ┆ … ┆ │
+ │ b22e0827-bc09-439f-85cf-5401db561a23 ┆ POLYGON((-74.5903646
4.889949,-74.5903… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 1704c72b-6f2b-445b-b9a3-36fdd0c74233 ┆ POLYGON((-107.0376099
28.8112085,-107.… ┆ … ┆ │
+ │ 754bf2dd-81a3-498f-910d-b2b2cc18e1a2 ┆ POLYGON((-74.589949
4.8891923,-74.5899… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ b30bf41d-479f-4ee5-bd45-d4e17ffd8875 ┆ POLYGON((-107.0377094
28.8115554,-107.… ┆ … ┆ │
+ │ 77464ae4-77d9-45ac-ac28-e6f972de9363 ┆ POLYGON((-74.5898331
4.889214,-74.5897… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ c88928d4-b165-4335-9bd8-ccc5c9f79cee ┆ POLYGON((-107.0374986
28.8111847,-107.… ┆ … ┆ │
+ │ 0f02d3f6-bbec-4cc0-89e5-65c3c4676cf1 ┆ POLYGON((-74.5899092
4.8892714,-74.589… ┆ … ┆ │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ ca1000b0-6af3-47fc-bdf2-61e8b1b716fc ┆ POLYGON((-107.0370972
28.8115247,-107.… ┆ … ┆ │
+ │ 696976a2-ff13-4b89-9953-8fd74b400828 ┆ POLYGON((-74.5902424
4.889916,-74.5902… ┆ … ┆ │
└──────────────────────────────────────┴─────────────────────────────────────────┴───┴─────────────┘
@@ -203,25 +209,25 @@ df.show(10)
│ id ┆ geometry ┆ bbox ┆ … ┆ is_territorial ┆
region ┆ division_id │
│ utf8 ┆ geometry ┆ struct ┆ ┆ boolean ┆
utf8 ┆ utf8 │
╞═════════════════╪════════════════╪════════════════╪═══╪════════════════╪════════╪════════════════╡
- │ cd743a89-9507-… ┆ POLYGON((111.… ┆ {xmin: 111.40… ┆ … ┆ true ┆
┆ e08d9394-cbc8… │
+ │ ae415364-9d06-… ┆ MULTIPOLYGON(… ┆ {xmin: 29.525… ┆ … ┆ true ┆
BY-MA ┆ 7665e731-6552… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ eb9f314e-1184-… ┆ POLYGON((112.… ┆ {xmin: 112.15… ┆ … ┆ true ┆
┆ aa2561c6-a578… │
+ │ d712e9e1-84c6-… ┆ POLYGON((29.5… ┆ {xmin: 29.577… ┆ … ┆ true ┆
BY-MA ┆ 4605a8a3-c576… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 89fbee90-bca0-… ┆ MULTIPOLYGON(… ┆ {xmin: 112.15… ┆ … ┆ true ┆
┆ 1cf6b19e-756f… │
+ │ bee9663a-af50-… ┆ POLYGON((29.5… ┆ {xmin: 29.587… ┆ … ┆ true ┆
BY-MA ┆ 826a2333-7584… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 758c0e1e-67aa-… ┆ POLYGON((112.… ┆ {xmin: 112.27… ┆ … ┆ true ┆
┆ 505f563f-7aa3… │
+ │ a083b661-eb7b-… ┆ POLYGON((29.4… ┆ {xmin: 29.326… ┆ … ┆ true ┆
BY-MA ┆ 17456e57-ebb6… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ e5d4c707-66d7-… ┆ POLYGON((109.… ┆ {xmin: 109.64… ┆ … ┆ true ┆
CN-HI ┆ 86939aee-1fbd… │
+ │ 83ef05fa-43ad-… ┆ POLYGON((29.6… ┆ {xmin: 29.598… ┆ … ┆ true ┆
BY-MA ┆ a44666eb-c61d… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ 26015e14-62ae-… ┆ POLYGON((109.… ┆ {xmin: 109.66… ┆ … ┆ true ┆
CN-HI ┆ ed052bae-e26f… │
+ │ 4d01e5b4-86f9-… ┆ POLYGON((29.5… ┆ {xmin: 29.531… ┆ … ┆ true ┆
BY-MA ┆ 77cdd054-ec26… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ eb42fd17-ad1e-… ┆ POLYGON((109.… ┆ {xmin: 109.83… ┆ … ┆ true ┆
CN-HI ┆ 201eeb03-4f5a… │
+ │ c2a12db9-a1d0-… ┆ POLYGON((29.5… ┆ {xmin: 29.537… ┆ … ┆ true ┆
BY-MA ┆ 4faa3881-e9a8… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ d63e1220-a308-… ┆ POLYGON((109.… ┆ {xmin: 109.90… ┆ … ┆ true ┆
CN-HI ┆ 71e30c32-2bc1… │
+ │ 7c290d7b-3f7f-… ┆ POLYGON((29.6… ┆ {xmin: 29.607… ┆ … ┆ true ┆
BY-MA ┆ e5233235-d513… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ e62cef5e-6768-… ┆ POLYGON((109.… ┆ {xmin: 109.74… ┆ … ┆ true ┆
CN-HI ┆ 24478621-6802… │
+ │ 579063f0-f751-… ┆ POLYGON((29.6… ┆ {xmin: 29.614… ┆ … ┆ true ┆
BY-MA ┆ 3f0c8f4e-c9c8… │
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
- │ c6fcbed1-ad8d-… ┆ POLYGON((110.… ┆ {xmin: 110.00… ┆ … ┆ true ┆
CN-HI ┆ ac0f434d-1e10… │
+ │ 675aab04-ed91-… ┆ POLYGON((29.6… ┆ {xmin: 29.616… ┆ … ┆ true ┆
BY-MA ┆ 02f5979e-7976… │
└─────────────────┴────────────────┴────────────────┴───┴────────────────┴────────┴────────────────┘
@@ -319,8 +325,8 @@ df.show(2)
├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤
│ Mud Island ┆ ┆
┆ POLYGON((-66.0222822… │
└────────────────────────┴────────────────────────┴────────────────────────┴───────────────────────┘
- CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms
- Wall time: 2.54 ms
+ CPU times: user 1.51 ms, sys: 1.69 ms, total: 3.2 ms
+ Wall time: 3.14 ms
## Visualize the results with lonboard
