This is an automated email from the ASF dual-hosted git repository. jiayu pushed a commit to branch branch-0.1.0 in repository https://gitbox.apache.org/repos/asf/sedona-db.git
commit aa124c18dbecf2953db17e20e6bf5e01e7218d44 Author: Matthew Powers <[email protected]> AuthorDate: Wed Sep 24 03:47:59 2025 -0400 docs: add lonboard visualization (#140) --- docs/image/lonboard_ns.png | Bin 0 -> 523379 bytes docs/overture-examples.ipynb | 133 +++++++++++++++++++++++++++++-------------- docs/overture-examples.md | 63 +++++++++++++------- docs/requirements.txt | 1 + 4 files changed, 133 insertions(+), 64 deletions(-) diff --git a/docs/image/lonboard_ns.png b/docs/image/lonboard_ns.png new file mode 100644 index 0000000..482d17c Binary files /dev/null and b/docs/image/lonboard_ns.png differ diff --git a/docs/overture-examples.ipynb b/docs/overture-examples.ipynb index ab1fd81..1be3f99 100644 --- a/docs/overture-examples.ipynb +++ b/docs/overture-examples.ipynb @@ -38,7 +38,7 @@ }, { "cell_type": "code", - "execution_count": 1, + "execution_count": 2, "id": "6d6fa0ab-b4ed-4e60-b099-a1af0998b486", "metadata": {}, "outputs": [], @@ -62,7 +62,7 @@ }, { "cell_type": "code", - "execution_count": 2, + "execution_count": 3, "id": "52855769-4872-472a-9c42-afced3d85ca8", "metadata": {}, "outputs": [], @@ -74,7 +74,7 @@ }, { "cell_type": "code", - "execution_count": 3, + "execution_count": 4, "id": "b45b5e5c-64ed-49ba-a8aa-9f2292f617c6", "metadata": {}, "outputs": [ @@ -86,25 +86,25 @@ "│ id ┆ geometry ┆ … ┆ roof_height │\n", "│ utf8 ┆ geometry ┆ ┆ float64 │\n", "╞══════════════════════════════════════╪═════════════════════════════════════════╪═══╪═════════════╡\n", - "│ 76045c54-bd50-415b-9ac8-35cfc22fe80f ┆ POLYGON((-105.7936939 25.7460051,-105.… ┆ … ┆ │\n", + "│ 97a89436-5295-417e-bde1-2dbf8fe10700 ┆ POLYGON((-107.0377042 28.8102782,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ f1eb3f3e-c9b9-40af-b83e-7f2c09ef8e43 ┆ POLYGON((-105.7971397 25.7517374,-105.… ┆ … ┆ │\n", + "│ e09fcdeb-65ab-443c-bc59-4f9acf32af17 ┆ POLYGON((-107.0372022 28.8103812,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ f6019f66-3137-4e62-9d84-e4f4febe2f6d ┆ POLYGON((-105.7928137 25.7493614,-105.… ┆ … ┆ │\n", + "│ cb06e75f-66a0-40ca-9029-e1a24dff1434 ┆ POLYGON((-107.0372848 28.8104923,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 37b96ac3-0093-47d4-a898-263f6550ef14 ┆ POLYGON((-105.7857365 25.7465883,-105.… ┆ … ┆ │\n", + "│ 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 ┆ POLYGON((-107.0371986 28.8104859,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ e686ab8d-7062-4c0a-a8da-32ab751f7212 ┆ POLYGON((-105.7579541 25.7150521,-105.… ┆ … ┆ │\n", + "│ 1a4fba29-6160-4a98-b8f7-03395fd6466a ┆ POLYGON((-107.0373331 28.8105281,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 767a736b-ac77-4427-89f0-3f9544b1e9e9 ┆ POLYGON((-105.7576387 25.7149905,-105.… ┆ … ┆ │\n", + "│ 9de2d803-ab58-46e1-9a35-7423f8d0d121 ┆ POLYGON((-107.0378928 28.8112268,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ db3a2233-a7cb-425a-ac75-ad83cf868a32 ┆ POLYGON((-105.7589831 25.71648,-105.75… ┆ … ┆ │\n", + "│ 1704c72b-6f2b-445b-b9a3-36fdd0c74233 ┆ POLYGON((-107.0376099 28.8112085,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 53866308-afc7-4ff1-88f6-b2af571238e3 ┆ POLYGON((-105.76268 25.7197151,-105.76… ┆ … ┆ │\n", + "│ b30bf41d-479f-4ee5-bd45-d4e17ffd8875 ┆ POLYGON((-107.0377094 28.8115554,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 31d8f64e-b7f9-4b26-8c2a-2fd205fed995 ┆ POLYGON((-105.7626968 25.7197994,-105.… ┆ … ┆ │\n", + "│ c88928d4-b165-4335-9bd8-ccc5c9f79cee ┆ POLYGON((-107.0374986 28.8111847,-107.… ┆ … ┆ │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 72ec6ed0-d33c-4e64-8c8f-28e7a6ac6310 ┆ POLYGON((-105.7578861 25.7190388,-105.… ┆ … ┆ │\n", + "│ ca1000b0-6af3-47fc-bdf2-61e8b1b716fc ┆ POLYGON((-107.0370972 28.8115247,-107.… ┆ … ┆ │\n", "└──────────────────────────────────────┴─────────────────────────────────────────┴───┴─────────────┘\n" ] } @@ -115,7 +115,7 @@ }, { "cell_type": "code", - "execution_count": 4, + "execution_count": 5, "id": "e37a023e-0e80-403a-a65b-b5a190004f72", "metadata": {}, "outputs": [], @@ -125,7 +125,7 @@ }, { "cell_type": "code", - "execution_count": 5, + "execution_count": 6, "id": "ebfe4776-e08f-4f38-97fc-fca8ec6fc364", "metadata": {}, "outputs": [ @@ -154,7 +154,7 @@ }, { "cell_type": "code", - "execution_count": 6, + "execution_count": 7, "id": "b73f670d-0d10-4a7a-bfc7-e2abe5d9edd2", "metadata": {}, "outputs": [ @@ -188,7 +188,7 @@ " roof_height: float64<Float64>" ] }, - "execution_count": 6, + "execution_count": 7, "metadata": {}, "output_type": "execute_result" } @@ -200,7 +200,7 @@ }, { "cell_type": "code", - "execution_count": 7, + "execution_count": 8, "id": "68d1b68c-dd26-45c2-944f-61138b212943", "metadata": {}, "outputs": [ @@ -262,7 +262,7 @@ }, { "cell_type": "code", - "execution_count": 8, + "execution_count": 9, "id": "d9f122d3-4d90-46b0-ab9a-259a71cc423b", "metadata": {}, "outputs": [], @@ -274,7 +274,7 @@ }, { "cell_type": "code", - "execution_count": 9, + "execution_count": 10, "id": "19a75b19-0b56-4167-b3f1-73a171ecc480", "metadata": {}, "outputs": [ @@ -286,25 +286,25 @@ "│ id ┆ geometry ┆ bbox ┆ … ┆ is_territorial ┆ region ┆ division_id │\n", "│ utf8 ┆ geometry ┆ struct ┆ ┆ boolean ┆ utf8 ┆ utf8 │\n", "╞═════════════════╪════════════════╪════════════════╪═══╪════════════════╪════════╪════════════════╡\n", - "│ 6dd2a4d4-542f-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 4b010ede-3285… │\n", + "│ cd743a89-9507-… ┆ POLYGON((111.… ┆ {xmin: 111.40… ┆ … ┆ true ┆ ┆ e08d9394-cbc8… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 5eef9108-6811-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 4aa05d3a-0300… │\n", + "│ eb9f314e-1184-… ┆ POLYGON((112.… ┆ {xmin: 112.15… ┆ … ┆ true ┆ ┆ aa2561c6-a578… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ fe123780-bf85-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 63c6570b-70fd… │\n", + "│ 89fbee90-bca0-… ┆ MULTIPOLYGON(… ┆ {xmin: 112.15… ┆ … ┆ true ┆ ┆ 1cf6b19e-756f… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ c0f0c861-a3bc-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ c3fc4642-f97b… │\n", + "│ 758c0e1e-67aa-… ┆ POLYGON((112.… ┆ {xmin: 112.27… ┆ … ┆ true ┆ ┆ 505f563f-7aa3… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ a57076cb-c74d-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 5d206247-f4b2… │\n", + "│ e5d4c707-66d7-… ┆ POLYGON((109.… ┆ {xmin: 109.64… ┆ … ┆ true ┆ CN-HI ┆ 86939aee-1fbd… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ d86411e8-02a1-… ┆ POLYGON((-82.… ┆ {xmin: -82.40… ┆ … ┆ true ┆ PA-4 ┆ c5564623-b42e… │\n", + "│ 26015e14-62ae-… ┆ POLYGON((109.… ┆ {xmin: 109.66… ┆ … ┆ true ┆ CN-HI ┆ ed052bae-e26f… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ d13f593f-7fde-… ┆ POLYGON((-82.… ┆ {xmin: -82.39… ┆ … ┆ true ┆ PA-4 ┆ b02aa2a3-3889… │\n", + "│ eb42fd17-ad1e-… ┆ POLYGON((109.… ┆ {xmin: 109.83… ┆ … ┆ true ┆ CN-HI ┆ 201eeb03-4f5a… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ 3598138e-788a-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 6700edfc-96e5… │\n", + "│ d63e1220-a308-… ┆ POLYGON((109.… ┆ {xmin: 109.90… ┆ … ┆ true ┆ CN-HI ┆ 71e30c32-2bc1… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ a5cecb4f-d6d1-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 9f24a80b-355d… │\n", + "│ e62cef5e-6768-… ┆ POLYGON((109.… ┆ {xmin: 109.74… ┆ … ┆ true ┆ CN-HI ┆ 24478621-6802… │\n", "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", - "│ a4d912fc-69d9-… ┆ POLYGON((-82.… ┆ {xmin: -82.37… ┆ … ┆ true ┆ PA-4 ┆ 65786eba-d8fd… │\n", + "│ c6fcbed1-ad8d-… ┆ POLYGON((110.… ┆ {xmin: 110.00… ┆ … ┆ true ┆ CN-HI ┆ ac0f434d-1e10… │\n", "└─────────────────┴────────────────┴────────────────┴───┴────────────────┴────────┴────────────────┘\n" ] } @@ -316,7 +316,7 @@ }, { "cell_type": "code", - "execution_count": 10, + "execution_count": 11, "id": "03b951de-3397-4fcf-9baf-50e139a38dd4", "metadata": {}, "outputs": [], @@ -326,7 +326,7 @@ }, { "cell_type": "code", - "execution_count": 11, + "execution_count": 12, "id": "9c6bd69d-9407-432a-bdc8-d60976237a3a", "metadata": {}, "outputs": [ @@ -353,7 +353,7 @@ }, { "cell_type": "code", - "execution_count": 12, + "execution_count": 13, "id": "75a6d0ed-9767-4d36-a77a-4afb7952fbe4", "metadata": {}, "outputs": [ @@ -376,7 +376,7 @@ " division_id: utf8<Utf8View>" ] }, - "execution_count": 12, + "execution_count": 13, "metadata": {}, "output_type": "execute_result" } @@ -387,7 +387,7 @@ }, { "cell_type": "code", - "execution_count": 13, + "execution_count": 14, "id": "f1f7158c-ef2b-4377-9bee-180309ddd553", "metadata": {}, "outputs": [], @@ -410,7 +410,7 @@ }, { "cell_type": "code", - "execution_count": 14, + "execution_count": 15, "id": "27e6909d-06fa-438b-88e0-d300fd2fb1ec", "metadata": {}, "outputs": [], @@ -420,7 +420,7 @@ }, { "cell_type": "code", - "execution_count": 15, + "execution_count": 16, "id": "2dec92d8-a374-4021-990a-e50f5769516e", "metadata": {}, "outputs": [], @@ -434,7 +434,7 @@ }, { "cell_type": "code", - "execution_count": 16, + "execution_count": 17, "id": "7f39a283-0eee-4f72-a30a-8dd9fa1aaa69", "metadata": { "scrolled": true @@ -452,8 +452,8 @@ "├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤\n", "│ Mud Island ┆ ┆ ┆ POLYGON((-66.0222822… │\n", "└────────────────────────┴────────────────────────┴────────────────────────┴───────────────────────┘\n", - "CPU times: user 1.2 ms, sys: 844 μs, total: 2.04 ms\n", - "Wall time: 2.03 ms\n" + "CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms\n", + "Wall time: 2.54 ms\n" ] } ], @@ -462,11 +462,60 @@ "# this executes quickly because the Nova Scotia data was persisted in memory with `to_memtable()`\n", "df.show(2)" ] + }, + { + "cell_type": "markdown", + "id": "fc1d2023-c83a-4010-808b-212161b1b577", + "metadata": {}, + "source": [ + "## Visualize the results with lonboard" + ] + }, + { + "cell_type": "code", + "execution_count": 18, + "id": "f78583fd-a73a-4169-9c45-74d8026bb5fb", + "metadata": { + "collapsed": true, + "jupyter": { + "outputs_hidden": true + } + }, + "outputs": [ + { + "data": { + "application/vnd.jupyter.widget-view+json": { + "model_id": "0dec2568b9e9420da04da4bf04eedc94", + "version_major": 2, + "version_minor": 1 + }, + "text/plain": [ + "Map(basemap_style=<CartoBasemap.DarkMatter: 'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'…" + ] + }, + "execution_count": 18, + "metadata": {}, + "output_type": "execute_result" + } + ], + "source": [ + "import lonboard\n", + "\n", + "lonboard.viz(df)" + ] + }, + { + "cell_type": "markdown", + "id": "0f668f51-462e-4e18-b774-c047140b224a", + "metadata": {}, + "source": [ + "" + ] } ], "metadata": { "kernelspec": { - "display_name": ".venv (3.13.3)", + "display_name": "Python 3 (ipykernel)", "language": "python", "name": "python3" }, @@ -480,7 +529,7 @@ "name": "python", "nbconvert_exporter": "python", "pygments_lexer": "ipython3", - "version": "3.13.3" + "version": "3.12.4" } }, "nbformat": 4, diff --git a/docs/overture-examples.md b/docs/overture-examples.md index c073f49..b1de209 100644 --- a/docs/overture-examples.md +++ b/docs/overture-examples.md @@ -57,25 +57,25 @@ df.limit(10).show() │ id ┆ geometry ┆ … ┆ roof_height │ │ utf8 ┆ geometry ┆ ┆ float64 │ ╞══════════════════════════════════════╪═════════════════════════════════════════╪═══╪═════════════╡ - │ 76045c54-bd50-415b-9ac8-35cfc22fe80f ┆ POLYGON((-105.7936939 25.7460051,-105.… ┆ … ┆ │ + │ 97a89436-5295-417e-bde1-2dbf8fe10700 ┆ POLYGON((-107.0377042 28.8102782,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ f1eb3f3e-c9b9-40af-b83e-7f2c09ef8e43 ┆ POLYGON((-105.7971397 25.7517374,-105.… ┆ … ┆ │ + │ e09fcdeb-65ab-443c-bc59-4f9acf32af17 ┆ POLYGON((-107.0372022 28.8103812,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ f6019f66-3137-4e62-9d84-e4f4febe2f6d ┆ POLYGON((-105.7928137 25.7493614,-105.… ┆ … ┆ │ + │ cb06e75f-66a0-40ca-9029-e1a24dff1434 ┆ POLYGON((-107.0372848 28.8104923,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 37b96ac3-0093-47d4-a898-263f6550ef14 ┆ POLYGON((-105.7857365 25.7465883,-105.… ┆ … ┆ │ + │ 5b8eaaca-5628-41d2-9e74-8c4c1205ed54 ┆ POLYGON((-107.0371986 28.8104859,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ e686ab8d-7062-4c0a-a8da-32ab751f7212 ┆ POLYGON((-105.7579541 25.7150521,-105.… ┆ … ┆ │ + │ 1a4fba29-6160-4a98-b8f7-03395fd6466a ┆ POLYGON((-107.0373331 28.8105281,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 767a736b-ac77-4427-89f0-3f9544b1e9e9 ┆ POLYGON((-105.7576387 25.7149905,-105.… ┆ … ┆ │ + │ 9de2d803-ab58-46e1-9a35-7423f8d0d121 ┆ POLYGON((-107.0378928 28.8112268,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ db3a2233-a7cb-425a-ac75-ad83cf868a32 ┆ POLYGON((-105.7589831 25.71648,-105.75… ┆ … ┆ │ + │ 1704c72b-6f2b-445b-b9a3-36fdd0c74233 ┆ POLYGON((-107.0376099 28.8112085,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 53866308-afc7-4ff1-88f6-b2af571238e3 ┆ POLYGON((-105.76268 25.7197151,-105.76… ┆ … ┆ │ + │ b30bf41d-479f-4ee5-bd45-d4e17ffd8875 ┆ POLYGON((-107.0377094 28.8115554,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 31d8f64e-b7f9-4b26-8c2a-2fd205fed995 ┆ POLYGON((-105.7626968 25.7197994,-105.… ┆ … ┆ │ + │ c88928d4-b165-4335-9bd8-ccc5c9f79cee ┆ POLYGON((-107.0374986 28.8111847,-107.… ┆ … ┆ │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 72ec6ed0-d33c-4e64-8c8f-28e7a6ac6310 ┆ POLYGON((-105.7578861 25.7190388,-105.… ┆ … ┆ │ + │ ca1000b0-6af3-47fc-bdf2-61e8b1b716fc ┆ POLYGON((-107.0370972 28.8115247,-107.… ┆ … ┆ │ └──────────────────────────────────────┴─────────────────────────────────────────┴───┴─────────────┘ @@ -203,25 +203,25 @@ df.show(10) │ id ┆ geometry ┆ bbox ┆ … ┆ is_territorial ┆ region ┆ division_id │ │ utf8 ┆ geometry ┆ struct ┆ ┆ boolean ┆ utf8 ┆ utf8 │ ╞═════════════════╪════════════════╪════════════════╪═══╪════════════════╪════════╪════════════════╡ - │ 6dd2a4d4-542f-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 4b010ede-3285… │ + │ cd743a89-9507-… ┆ POLYGON((111.… ┆ {xmin: 111.40… ┆ … ┆ true ┆ ┆ e08d9394-cbc8… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 5eef9108-6811-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 4aa05d3a-0300… │ + │ eb9f314e-1184-… ┆ POLYGON((112.… ┆ {xmin: 112.15… ┆ … ┆ true ┆ ┆ aa2561c6-a578… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ fe123780-bf85-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 63c6570b-70fd… │ + │ 89fbee90-bca0-… ┆ MULTIPOLYGON(… ┆ {xmin: 112.15… ┆ … ┆ true ┆ ┆ 1cf6b19e-756f… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ c0f0c861-a3bc-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ c3fc4642-f97b… │ + │ 758c0e1e-67aa-… ┆ POLYGON((112.… ┆ {xmin: 112.27… ┆ … ┆ true ┆ ┆ 505f563f-7aa3… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ a57076cb-c74d-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 5d206247-f4b2… │ + │ e5d4c707-66d7-… ┆ POLYGON((109.… ┆ {xmin: 109.64… ┆ … ┆ true ┆ CN-HI ┆ 86939aee-1fbd… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ d86411e8-02a1-… ┆ POLYGON((-82.… ┆ {xmin: -82.40… ┆ … ┆ true ┆ PA-4 ┆ c5564623-b42e… │ + │ 26015e14-62ae-… ┆ POLYGON((109.… ┆ {xmin: 109.66… ┆ … ┆ true ┆ CN-HI ┆ ed052bae-e26f… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ d13f593f-7fde-… ┆ POLYGON((-82.… ┆ {xmin: -82.39… ┆ … ┆ true ┆ PA-4 ┆ b02aa2a3-3889… │ + │ eb42fd17-ad1e-… ┆ POLYGON((109.… ┆ {xmin: 109.83… ┆ … ┆ true ┆ CN-HI ┆ 201eeb03-4f5a… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ 3598138e-788a-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 6700edfc-96e5… │ + │ d63e1220-a308-… ┆ POLYGON((109.… ┆ {xmin: 109.90… ┆ … ┆ true ┆ CN-HI ┆ 71e30c32-2bc1… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ a5cecb4f-d6d1-… ┆ POLYGON((-82.… ┆ {xmin: -82.38… ┆ … ┆ true ┆ PA-4 ┆ 9f24a80b-355d… │ + │ e62cef5e-6768-… ┆ POLYGON((109.… ┆ {xmin: 109.74… ┆ … ┆ true ┆ CN-HI ┆ 24478621-6802… │ ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ - │ a4d912fc-69d9-… ┆ POLYGON((-82.… ┆ {xmin: -82.37… ┆ … ┆ true ┆ PA-4 ┆ 65786eba-d8fd… │ + │ c6fcbed1-ad8d-… ┆ POLYGON((110.… ┆ {xmin: 110.00… ┆ … ┆ true ┆ CN-HI ┆ ac0f434d-1e10… │ └─────────────────┴────────────────┴────────────────┴───┴────────────────┴────────┴────────────────┘ @@ -319,5 +319,24 @@ df.show(2) ├╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┼╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌╌┤ │ Mud Island ┆ ┆ ┆ POLYGON((-66.0222822… │ └────────────────────────┴────────────────────────┴────────────────────────┴───────────────────────┘ - CPU times: user 1.2 ms, sys: 844 μs, total: 2.04 ms - Wall time: 2.03 ms + CPU times: user 1.31 ms, sys: 1.02 ms, total: 2.33 ms + Wall time: 2.54 ms + + +## Visualize the results with lonboard + + +```python +import lonboard + +lonboard.viz(df) +``` + + + + + Map(basemap_style=<CartoBasemap.DarkMatter: 'https://basemaps.cartocdn.com/gl/dark-matter-gl-style/style.json'… + + + + diff --git a/docs/requirements.txt b/docs/requirements.txt index 5a5444b..6bd80c3 100644 --- a/docs/requirements.txt +++ b/docs/requirements.txt @@ -26,3 +26,4 @@ mkdocstrings[python] nbconvert pyproj ruff +lonboard
