You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@sedona.apache.org by ji...@apache.org on 2026/09/18 08:47:58 UTC
(sedona) branch branch-1.9.1 updated: [DOCS] Add blog post: ORDER BY Is an Index. Does It Have to Be? (#3382)
This is an automated email from the ASF dual-hosted git repository.
jiayuasu pushed a commit to branch branch-1.9.1
in repository https://gitbox.apache.org/repos/asf/sedona.git
The following commit(s) were added to refs/heads/branch-1.9.1 by this push:
new 6d92bfc7e43 [DOCS] Add blog post: ORDER BY Is an Index. Does It Have to Be? (#3382)
6d92bfc7e43 is described below
commit 6d92bfc7e43142e8d260c9d1dcd8f6ec83644e87
Author: Jia Yu <ji...@apache.org>
AuthorDate: Fri Sep 18 01:26:50 2026 -0700
[DOCS] Add blog post: ORDER BY Is an Index. Does It Have to Be? (#3382)
(cherry picked from commit c17b3f9ae11e0fb1d2c243e320d5bebb6e8821d5)
---
.github/linters/codespell.txt | 1 +
docs/blog/posts/orderby-index-cover.png | Bin 0 -> 403947 bytes
docs/blog/posts/orderby-index-rowgroups.svg | 3397 +++++++++++++++++++++++++++
docs/blog/posts/orderby-index.md | 115 +
4 files changed, 3513 insertions(+)
diff --git a/.github/linters/codespell.txt b/.github/linters/codespell.txt
index a4a089cc957..a3979b5dbca 100644
--- a/.github/linters/codespell.txt
+++ b/.github/linters/codespell.txt
@@ -2,6 +2,7 @@ actualy
afterall
allEdges
atmost
+brin
celle
checkin
eiter
diff --git a/docs/blog/posts/orderby-index-cover.png b/docs/blog/posts/orderby-index-cover.png
new file mode 100644
index 00000000000..6a32762d7f7
Binary files /dev/null and b/docs/blog/posts/orderby-index-cover.png differ
diff --git a/docs/blog/posts/orderby-index-rowgroups.svg b/docs/blog/posts/orderby-index-rowgroups.svg
new file mode 100644
index 00000000000..4bb9969870b
--- /dev/null
+++ b/docs/blog/posts/orderby-index-rowgroups.svg
@@ -0,0 +1,3397 @@
+<?xml version="1.0" encoding="utf-8" standalone="no"?>
+<!DOCTYPE svg PUBLIC "-//W3C//DTD SVG 1.1//EN"
+ "http://www.w3.org/Graphics/SVG/1.1/DTD/svg11.dtd">
+<svg xmlns:xlink="http://www.w3.org/1999/xlink" width="936pt" height="374.4pt" viewBox="0 0 936 374.4" xmlns="http://www.w3.org/2000/svg" version="1.1">
+ <metadata>
+ <rdf:RDF xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:cc="http://creativecommons.org/ns#" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#">
+ <cc:Work>
+ <dc:type rdf:resource="http://purl.org/dc/dcmitype/StillImage"/>
+ <dc:date>2026-09-18T00:57:01.522251</dc:date>
+ <dc:format>image/svg+xml</dc:format>
+ <dc:creator>
+ <cc:Agent>
+ <dc:title>Matplotlib v3.11.2, https://matplotlib.org/</dc:title>
+ </cc:Agent>
+ </dc:creator>
+ </cc:Work>
+ </rdf:RDF>
+ </metadata>
+ <defs>
+ <style type="text/css">*{stroke-linejoin: round; stroke-linecap: butt}</style>
+ </defs>
+ <g id="figure_1">
+ <g id="patch_1">
+ <path d="M 0 374.4
+L 936 374.4
+L 936 0
+L 0 0
+z
+" style="fill: #fcfcfb"/>
+ </g>
+ <g id="axes_1">
+ <g id="patch_2">
+ <path d="M 47.765 286.273676
+L 323.371901 286.273676
+L 323.371901 118.086
+L 47.765 118.086
+z
+" style="fill: #fcfcfb"/>
+ </g>
+ <g id="matplotlib.axis_1">
+ <g id="xtick_1">
+ <g id="line2d_1">
+ <defs>
+ <path id="m71ddc384de" d="M 0 0
+L 0 3.5
+" style="stroke: #000000; stroke-width: 0.8"/>
+ </defs>
+ <g>
+ <use xlink:href="#m71ddc384de" x="76.822041" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_1">
+ <!-- Seattle -->
+ <g style="fill: #52514e" transform="translate(45.05101 322.073426) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-36" d="M 894 1481
+Q 916 1091 1078 847
+Q 1388 391 2169 391
+Q 2519 391 2806 491
+Q 3363 684 3363 1184
+Q 3363 1559 3128 1719
+Q 2891 1875 2384 1991
+L 1763 2131
+Q 1153 2269 900 2434
+Q 463 2722 463 3294
+Q 463 3913 891 4309
+Q 1319 4706 2103 4706
+Q 2825 4706 3329 4357
+Q 3834 4009 3834 3244
+L 3250 3244
+Q 3203 3613 3050 3809
+Q 2766 4169 2084 4169
+Q 1534 4169 1293 3937
+Q 1053 3706 1053 3400
+Q 1053 3063 1334 2906
+Q 1519 2806 2169 2656
+L 2813 2509
+Q 3278 2403 3531 2219
+Q 3969 1897 3969 1284
+Q 3969 522 3414 194
+Q 2859 -134 2125 -134
+Q 1269 -134 784 303
+Q 300 738 309 1481
+L 894 1481
+z
+M 2150 4716
+L 2150 4716
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-48" d="M 1806 3422
+Q 2163 3422 2497 3255
+Q 2831 3088 3006 2822
+Q 3175 2569 3231 2231
+Q 3281 2000 3281 1494
+L 828 1494
+Q 844 984 1069 676
+Q 1294 369 1766 369
+Q 2206 369 2469 659
+Q 2619 828 2681 1050
+L 3234 1050
+Q 3213 866 3089 639
+Q 2966 413 2813 269
+Q 2556 19 2178 -69
+Q 1975 -119 1719 -119
+Q 1094 -119 659 336
+Q 225 791 225 1609
+Q 225 2416 662 2919
+Q 1100 3422 1806 3422
+z
+M 2703 1941
+Q 2669 2306 2544 2525
+Q 2313 2931 1772 2931
+Q 1384 2931 1121 2651
+Q 859 2372 844 1941
+L 2703 1941
+z
+M 1753 3428
+L 1753 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-44" d="M 844 891
+Q 844 647 1022 506
+Q 1200 366 1444 366
+Q 1741 366 2019 503
+Q 2488 731 2488 1250
+L 2488 1703
+Q 2384 1638 2221 1594
+Q 2059 1550 1903 1531
+L 1563 1488
+Q 1256 1447 1103 1359
+Q 844 1213 844 891
+z
+M 2206 2028
+Q 2400 2053 2466 2191
+Q 2503 2266 2503 2406
+Q 2503 2694 2298 2823
+Q 2094 2953 1713 2953
+Q 1272 2953 1088 2716
+Q 984 2584 953 2325
+L 428 2325
+Q 444 2944 830 3186
+Q 1216 3428 1725 3428
+Q 2316 3428 2684 3203
+Q 3050 2978 3050 2503
+L 3050 575
+Q 3050 488 3086 434
+Q 3122 381 3238 381
+Q 3275 381 3322 386
+Q 3369 391 3422 400
+L 3422 -16
+Q 3291 -53 3222 -62
+Q 3153 -72 3034 -72
+Q 2744 -72 2613 134
+Q 2544 244 2516 444
+Q 2344 219 2022 53
+Q 1700 -113 1313 -113
+Q 847 -113 551 170
+Q 256 453 256 878
+Q 256 1344 547 1600
+Q 838 1856 1309 1916
+L 2206 2028
+z
+M 1741 3428
+L 1741 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-57" d="M 525 4281
+L 1094 4281
+L 1094 3347
+L 1628 3347
+L 1628 2888
+L 1094 2888
+L 1094 703
+Q 1094 528 1213 469
+Q 1278 434 1431 434
+Q 1472 434 1519 436
+Q 1566 438 1628 444
+L 1628 0
+Q 1531 -28 1426 -40
+Q 1322 -53 1200 -53
+Q 806 -53 665 148
+Q 525 350 525 672
+L 525 2888
+L 72 2888
+L 72 3347
+L 525 3347
+L 525 4281
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-4f" d="M 428 4591
+L 991 4591
+L 991 0
+L 428 0
+L 428 4591
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_2">
+ <g id="line2d_2">
+ <g>
+ <use xlink:href="#m71ddc384de" x="120.320605" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_2">
+ <!-- Tacoma -->
+ <g style="fill: #52514e" transform="translate(84.734373 324.744859) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-37" d="M 3828 4591
+L 3828 4044
+L 2281 4044
+L 2281 0
+L 1650 0
+L 1650 4044
+L 103 4044
+L 103 4591
+L 3828 4591
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-46" d="M 1703 3444
+Q 2269 3444 2623 3169
+Q 2978 2894 3050 2222
+L 2503 2222
+Q 2453 2531 2275 2736
+Q 2097 2941 1703 2941
+Q 1166 2941 934 2416
+Q 784 2075 784 1575
+Q 784 1072 996 728
+Q 1209 384 1666 384
+Q 2016 384 2220 598
+Q 2425 813 2503 1184
+L 3050 1184
+Q 2956 519 2581 211
+Q 2206 -97 1622 -97
+Q 966 -97 575 383
+Q 184 863 184 1581
+Q 184 2463 612 2953
+Q 1041 3444 1703 3444
+z
+M 1616 3428
+L 1616 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-52" d="M 1741 363
+Q 2300 363 2508 786
+Q 2716 1209 2716 1728
+Q 2716 2197 2566 2491
+Q 2328 2953 1747 2953
+Q 1231 2953 997 2559
+Q 763 2166 763 1609
+Q 763 1075 997 719
+Q 1231 363 1741 363
+z
+M 1763 3444
+Q 2409 3444 2856 3012
+Q 3303 2581 3303 1744
+Q 3303 934 2909 406
+Q 2516 -122 1688 -122
+Q 997 -122 590 345
+Q 184 813 184 1600
+Q 184 2444 612 2944
+Q 1041 3444 1763 3444
+z
+M 1744 3428
+L 1744 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-50" d="M 413 3347
+L 969 3347
+L 969 2872
+Q 1169 3119 1331 3231
+Q 1609 3422 1963 3422
+Q 2363 3422 2606 3225
+Q 2744 3113 2856 2894
+Q 3044 3163 3297 3292
+Q 3550 3422 3866 3422
+Q 4541 3422 4784 2934
+Q 4916 2672 4916 2228
+L 4916 0
+L 4331 0
+L 4331 2325
+Q 4331 2659 4164 2784
+Q 3997 2909 3756 2909
+Q 3425 2909 3186 2687
+Q 2947 2466 2947 1947
+L 2947 0
+L 2375 0
+L 2375 2184
+Q 2375 2525 2294 2681
+Q 2166 2916 1816 2916
+Q 1497 2916 1236 2669
+Q 975 2422 975 1775
+L 975 0
+L 413 0
+L 413 3347
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-37"/>
+ <use xlink:href="#Helvetica-44" transform="translate(50 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(105.609375 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(155.609375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(211.21875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(294.515625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_3">
+ <g id="line2d_3">
+ <g>
+ <use xlink:href="#m71ddc384de" x="163.819168" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_3">
+ <!-- Spokane -->
+ <g style="fill: #52514e" transform="translate(123.581278 327.81636) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-53" d="M 1825 378
+Q 2219 378 2480 708
+Q 2741 1038 2741 1694
+Q 2741 2094 2625 2381
+Q 2406 2934 1825 2934
+Q 1241 2934 1025 2350
+Q 909 2038 909 1556
+Q 909 1169 1025 897
+Q 1244 378 1825 378
+z
+M 369 3331
+L 916 3331
+L 916 2888
+Q 1084 3116 1284 3241
+Q 1569 3428 1953 3428
+Q 2522 3428 2919 2992
+Q 3316 2556 3316 1747
+Q 3316 653 2744 184
+Q 2381 -113 1900 -113
+Q 1522 -113 1266 53
+Q 1116 147 931 375
+L 931 -1334
+L 369 -1334
+L 369 3331
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-4e" d="M 400 4591
+L 941 4591
+L 941 1925
+L 2384 3347
+L 3103 3347
+L 1822 2094
+L 3175 0
+L 2456 0
+L 1413 1688
+L 941 1256
+L 941 0
+L 400 0
+L 400 4591
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-51" d="M 413 3347
+L 947 3347
+L 947 2872
+Q 1184 3166 1450 3294
+Q 1716 3422 2041 3422
+Q 2753 3422 3003 2925
+Q 3141 2653 3141 2147
+L 3141 0
+L 2569 0
+L 2569 2109
+Q 2569 2416 2478 2603
+Q 2328 2916 1934 2916
+Q 1734 2916 1606 2875
+Q 1375 2806 1200 2600
+Q 1059 2434 1017 2257
+Q 975 2081 975 1753
+L 975 0
+L 413 0
+L 413 3347
+z
+M 1734 3428
+L 1734 3428
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-53" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(227.921875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(283.53125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(339.140625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_4">
+ <g id="line2d_4">
+ <g>
+ <use xlink:href="#m71ddc384de" x="207.317732" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_4">
+ <!-- Olympia -->
+ <g style="fill: #52514e" transform="translate(169.792861 325.888068) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-32" d="M 2469 4716
+Q 3684 4716 4269 3934
+Q 4725 3325 4725 2375
+Q 4725 1347 4203 666
+Q 3591 -134 2456 -134
+Q 1397 -134 791 566
+Q 250 1241 250 2272
+Q 250 3203 713 3866
+Q 1306 4716 2469 4716
+z
+M 2531 422
+Q 3353 422 3720 1011
+Q 4088 1600 4088 2366
+Q 4088 3175 3664 3669
+Q 3241 4163 2506 4163
+Q 1794 4163 1344 3673
+Q 894 3184 894 2231
+Q 894 1469 1280 945
+Q 1666 422 2531 422
+z
+M 2488 4716
+L 2488 4716
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-5c" d="M 2503 3347
+L 3125 3347
+Q 3006 3025 2597 1878
+Q 2291 1016 2084 472
+Q 1597 -809 1397 -1090
+Q 1197 -1372 709 -1372
+Q 591 -1372 527 -1362
+Q 463 -1353 369 -1328
+L 369 -816
+Q 516 -856 581 -865
+Q 647 -875 697 -875
+Q 853 -875 926 -823
+Q 1000 -772 1050 -697
+Q 1066 -672 1162 -440
+Q 1259 -209 1303 -97
+L 66 3347
+L 703 3347
+L 1600 622
+L 2503 3347
+z
+M 1597 3428
+L 1597 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-4c" d="M 413 3331
+L 984 3331
+L 984 0
+L 413 0
+L 413 3331
+z
+M 413 4591
+L 984 4591
+L 984 3953
+L 413 3953
+L 413 4591
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-32"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(100 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-53" transform="translate(233.296875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(288.90625 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(311.125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_5">
+ <g id="line2d_5">
+ <g>
+ <use xlink:href="#m71ddc384de" x="250.816296" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_5">
+ <!-- Leavenworth -->
+ <g style="fill: #52514e" transform="translate(193.364849 340.055048) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-2f" d="M 488 4591
+L 1109 4591
+L 1109 547
+L 3434 547
+L 3434 0
+L 488 0
+L 488 4591
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-59" d="M 688 3347
+L 1581 622
+L 2516 3347
+L 3131 3347
+L 1869 0
+L 1269 0
+L 34 3347
+L 688 3347
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-5a" d="M 672 3347
+L 1316 709
+L 1969 3347
+L 2600 3347
+L 3256 725
+L 3941 3347
+L 4503 3347
+L 3531 0
+L 2947 0
+L 2266 2591
+L 1606 0
+L 1022 0
+L 56 3347
+L 672 3347
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-55" d="M 428 3347
+L 963 3347
+L 963 2769
+Q 1028 2938 1284 3180
+Q 1541 3422 1875 3422
+Q 1891 3422 1928 3419
+Q 1966 3416 2056 3406
+L 2056 2813
+Q 2006 2822 1964 2825
+Q 1922 2828 1872 2828
+Q 1447 2828 1219 2554
+Q 991 2281 991 1925
+L 991 0
+L 428 0
+L 428 3347
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-4b" d="M 413 4606
+L 975 4606
+L 975 2894
+Q 1175 3147 1334 3250
+Q 1606 3428 2013 3428
+Q 2741 3428 3000 2919
+Q 3141 2641 3141 2147
+L 3141 0
+L 2563 0
+L 2563 2109
+Q 2563 2478 2469 2650
+Q 2316 2925 1894 2925
+Q 1544 2925 1259 2684
+Q 975 2444 975 1775
+L 975 0
+L 413 0
+L 413 4606
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-2f"/>
+ <use xlink:href="#Helvetica-48" transform="translate(55.609375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(111.21875 0)"/>
+ <use xlink:href="#Helvetica-59" transform="translate(166.828125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(216.828125 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(272.4375 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(328.046875 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(400.265625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(455.875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(489.171875 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(516.953125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_6">
+ <g id="line2d_6">
+ <g>
+ <use xlink:href="#m71ddc384de" x="294.31486" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_6">
+ <!-- Seattle 5 km -->
+ <g style="fill: #52514e" transform="translate(238.51298 338.900008) rotate(-35) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-3" transform="scale(0.015625)"/>
+ <path id="Helvetica-18" d="M 791 1141
+Q 847 659 1238 475
+Q 1438 381 1700 381
+Q 2200 381 2440 700
+Q 2681 1019 2681 1406
+Q 2681 1875 2395 2131
+Q 2109 2388 1709 2388
+Q 1419 2388 1211 2275
+Q 1003 2163 856 1963
+L 369 1991
+L 709 4400
+L 3034 4400
+L 3034 3856
+L 1131 3856
+L 941 2613
+Q 1097 2731 1238 2791
+Q 1488 2894 1816 2894
+Q 2431 2894 2859 2497
+Q 3288 2100 3288 1491
+Q 3288 856 2895 371
+Q 2503 -113 1644 -113
+Q 1097 -113 676 195
+Q 256 503 206 1141
+L 791 1141
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(311.3125 0)"/>
+ <use xlink:href="#Helvetica-18" transform="translate(339.09375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(394.703125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(422.484375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(472.484375 0)"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <g id="matplotlib.axis_2">
+ <g id="ytick_1">
+ <g id="line2d_7">
+ <path d="M 47.765 286.273676
+L 323.371901 286.273676
+" clip-path="url(#p3ff16522ac)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_8">
+ <defs>
+ <path id="m210d293422" d="M 0 0
+L -3.5 0
+" style="stroke: #52514e; stroke-width: 0.8"/>
+ </defs>
+ <g>
+ <use xlink:href="#m210d293422" x="47.765" y="286.273676" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_7">
+ <!-- 0 -->
+ <g style="fill: #52514e" transform="translate(34.091875 290.773676) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-13" d="M 1731 4475
+Q 2600 4475 2988 3759
+Q 3288 3206 3288 2244
+Q 3288 1331 3016 734
+Q 2622 -122 1728 -122
+Q 922 -122 528 578
+Q 200 1163 200 2147
+Q 200 2909 397 3456
+Q 766 4475 1731 4475
+z
+M 1725 391
+Q 2163 391 2422 778
+Q 2681 1166 2681 2222
+Q 2681 2984 2493 3476
+Q 2306 3969 1766 3969
+Q 1269 3969 1039 3501
+Q 809 3034 809 2125
+Q 809 1441 956 1025
+Q 1181 391 1725 391
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-13"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_2">
+ <g id="line2d_9">
+ <path d="M 47.765 246.559939
+L 323.371901 246.559939
+" clip-path="url(#p3ff16522ac)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_10">
+ <g>
+ <use xlink:href="#m210d293422" x="47.765" y="246.559939" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_8">
+ <!-- 20 -->
+ <g style="fill: #52514e" transform="translate(27.41875 251.059939) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-15" d="M 200 0
+Q 231 578 439 1006
+Q 647 1434 1250 1784
+L 1850 2131
+Q 2253 2366 2416 2531
+Q 2672 2791 2672 3125
+Q 2672 3516 2437 3745
+Q 2203 3975 1813 3975
+Q 1234 3975 1013 3538
+Q 894 3303 881 2888
+L 309 2888
+Q 319 3472 525 3841
+Q 891 4491 1816 4491
+Q 2584 4491 2939 4075
+Q 3294 3659 3294 3150
+Q 3294 2613 2916 2231
+Q 2697 2009 2131 1694
+L 1703 1456
+Q 1397 1288 1222 1134
+Q 909 863 828 531
+L 3272 531
+L 3272 0
+L 200 0
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-15"/>
+ <use xlink:href="#Helvetica-13" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_3">
+ <g id="line2d_11">
+ <path d="M 47.765 206.846202
+L 323.371901 206.846202
+" clip-path="url(#p3ff16522ac)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_12">
+ <g>
+ <use xlink:href="#m210d293422" x="47.765" y="206.846202" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_9">
+ <!-- 40 -->
+ <g style="fill: #52514e" transform="translate(27.41875 211.346202) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-17" d="M 2116 1584
+L 2116 3613
+L 681 1584
+L 2116 1584
+z
+M 2125 0
+L 2125 1094
+L 163 1094
+L 163 1644
+L 2213 4488
+L 2688 4488
+L 2688 1584
+L 3347 1584
+L 3347 1094
+L 2688 1094
+L 2688 0
+L 2125 0
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-17"/>
+ <use xlink:href="#Helvetica-13" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_4">
+ <g id="line2d_13">
+ <path d="M 47.765 167.132465
+L 323.371901 167.132465
+" clip-path="url(#p3ff16522ac)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_14">
+ <g>
+ <use xlink:href="#m210d293422" x="47.765" y="167.132465" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_10">
+ <!-- 60 -->
+ <g style="fill: #52514e" transform="translate(27.41875 171.632465) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-19" d="M 1872 4494
+Q 2622 4494 2917 4105
+Q 3213 3716 3213 3303
+L 2656 3303
+Q 2606 3569 2497 3719
+Q 2294 4000 1881 4000
+Q 1409 4000 1131 3564
+Q 853 3128 822 2316
+Q 1016 2600 1309 2741
+Q 1578 2866 1909 2866
+Q 2472 2866 2890 2506
+Q 3309 2147 3309 1434
+Q 3309 825 2912 354
+Q 2516 -116 1781 -116
+Q 1153 -116 697 361
+Q 241 838 241 1966
+Q 241 2800 444 3381
+Q 834 4494 1872 4494
+z
+M 1831 384
+Q 2275 384 2495 682
+Q 2716 981 2716 1388
+Q 2716 1731 2519 2042
+Q 2322 2353 1803 2353
+Q 1441 2353 1167 2112
+Q 894 1872 894 1388
+Q 894 963 1142 673
+Q 1391 384 1831 384
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-19"/>
+ <use xlink:href="#Helvetica-13" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_5">
+ <g id="line2d_15">
+ <path d="M 47.765 127.418728
+L 323.371901 127.418728
+" clip-path="url(#p3ff16522ac)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_16">
+ <g>
+ <use xlink:href="#m210d293422" x="47.765" y="127.418728" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_11">
+ <!-- 80 -->
+ <g style="fill: #52514e" transform="translate(27.41875 131.918728) scale(0.12 -0.12)">
+ <defs>
+ <path id="Helvetica-1b" d="M 1741 2600
+Q 2113 2600 2322 2808
+Q 2531 3016 2531 3303
+Q 2531 3553 2331 3762
+Q 2131 3972 1722 3972
+Q 1316 3972 1134 3762
+Q 953 3553 953 3272
+Q 953 2956 1187 2778
+Q 1422 2600 1741 2600
+z
+M 1775 384
+Q 2166 384 2423 595
+Q 2681 806 2681 1225
+Q 2681 1659 2415 1884
+Q 2150 2109 1734 2109
+Q 1331 2109 1076 1879
+Q 822 1650 822 1244
+Q 822 894 1055 639
+Q 1288 384 1775 384
+z
+M 975 2384
+Q 741 2484 609 2619
+Q 363 2869 363 3269
+Q 363 3769 725 4128
+Q 1088 4488 1753 4488
+Q 2397 4488 2762 4148
+Q 3128 3809 3128 3356
+Q 3128 2938 2916 2678
+Q 2797 2531 2547 2391
+Q 2825 2263 2984 2097
+Q 3281 1784 3281 1284
+Q 3281 694 2884 283
+Q 2488 -128 1763 -128
+Q 1109 -128 657 226
+Q 206 581 206 1256
+Q 206 1653 400 1942
+Q 594 2231 975 2384
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-1b"/>
+ <use xlink:href="#Helvetica-13" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="text_12">
+ <!-- row groups read, of 77 -->
+ <g style="fill: #52514e" transform="translate(20.431875 269.713588) rotate(-90) scale(0.135 -0.135)">
+ <defs>
+ <path id="Helvetica-4a" d="M 1594 3406
+Q 1988 3406 2281 3213
+Q 2441 3103 2606 2894
+L 2606 3316
+L 3125 3316
+L 3125 272
+Q 3125 -366 2938 -734
+Q 2588 -1416 1616 -1416
+Q 1075 -1416 706 -1173
+Q 338 -931 294 -416
+L 866 -416
+Q 906 -641 1028 -763
+Q 1219 -950 1628 -950
+Q 2275 -950 2475 -494
+Q 2594 -225 2584 466
+Q 2416 209 2178 84
+Q 1941 -41 1550 -41
+Q 1006 -41 598 345
+Q 191 731 191 1622
+Q 191 2463 602 2934
+Q 1013 3406 1594 3406
+z
+M 2606 1688
+Q 2606 2309 2350 2609
+Q 2094 2909 1697 2909
+Q 1103 2909 884 2353
+Q 769 2056 769 1575
+Q 769 1009 998 714
+Q 1228 419 1616 419
+Q 2222 419 2469 966
+Q 2606 1275 2606 1688
+z
+M 1659 3428
+L 1659 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-58" d="M 975 3347
+L 975 1125
+Q 975 869 1056 706
+Q 1206 406 1616 406
+Q 2203 406 2416 931
+Q 2531 1213 2531 1703
+L 2531 3347
+L 3094 3347
+L 3094 0
+L 2563 0
+L 2569 494
+Q 2459 303 2297 172
+Q 1975 -91 1516 -91
+Q 800 -91 541 388
+Q 400 644 400 1072
+L 400 3347
+L 975 3347
+z
+M 1747 3428
+L 1747 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-56" d="M 747 1050
+Q 772 769 888 619
+Q 1100 347 1625 347
+Q 1938 347 2175 483
+Q 2413 619 2413 903
+Q 2413 1119 2222 1231
+Q 2100 1300 1741 1391
+L 1294 1503
+Q 866 1609 663 1741
+Q 300 1969 300 2372
+Q 300 2847 642 3140
+Q 984 3434 1563 3434
+Q 2319 3434 2653 2991
+Q 2863 2709 2856 2384
+L 2325 2384
+Q 2309 2575 2191 2731
+Q 1997 2953 1519 2953
+Q 1200 2953 1036 2831
+Q 872 2709 872 2509
+Q 872 2291 1088 2159
+Q 1213 2081 1456 2022
+L 1828 1931
+Q 2434 1784 2641 1647
+Q 2969 1431 2969 969
+Q 2969 522 2630 197
+Q 2291 -128 1597 -128
+Q 850 -128 539 211
+Q 228 550 206 1050
+L 747 1050
+z
+M 1578 3428
+L 1578 3428
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-47" d="M 769 1634
+Q 769 1097 997 734
+Q 1225 372 1728 372
+Q 2119 372 2370 708
+Q 2622 1044 2622 1672
+Q 2622 2306 2362 2611
+Q 2103 2916 1722 2916
+Q 1297 2916 1033 2591
+Q 769 2266 769 1634
+z
+M 1616 3406
+Q 2000 3406 2259 3244
+Q 2409 3150 2600 2916
+L 2600 4606
+L 3141 4606
+L 3141 0
+L 2634 0
+L 2634 466
+Q 2438 156 2169 18
+Q 1900 -119 1553 -119
+Q 994 -119 584 351
+Q 175 822 175 1603
+Q 175 2334 548 2870
+Q 922 3406 1616 3406
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-f" d="M 531 -653
+Q 747 -616 834 -350
+Q 881 -209 881 -78
+Q 881 -56 879 -39
+Q 878 -22 872 0
+L 531 0
+L 531 681
+L 1200 681
+L 1200 50
+Q 1200 -322 1050 -603
+Q 900 -884 531 -950
+L 531 -653
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-49" d="M 553 3856
+Q 566 4206 675 4369
+Q 872 4656 1434 4656
+Q 1488 4656 1544 4653
+Q 1600 4650 1672 4644
+L 1672 4131
+Q 1584 4138 1545 4139
+Q 1506 4141 1472 4141
+Q 1216 4141 1166 4008
+Q 1116 3875 1116 3331
+L 1672 3331
+L 1672 2888
+L 1109 2888
+L 1109 0
+L 553 0
+L 553 2888
+L 88 2888
+L 88 3331
+L 553 3331
+L 553 3856
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-1a" d="M 3347 4400
+L 3347 3909
+Q 3131 3700 2773 3181
+Q 2416 2663 2141 2063
+Q 1869 1478 1728 997
+Q 1638 688 1494 0
+L 872 0
+Q 1084 1281 1809 2550
+Q 2238 3294 2709 3834
+L 234 3834
+L 234 4400
+L 3347 4400
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-55"/>
+ <use xlink:href="#Helvetica-52" transform="translate(33.296875 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(88.90625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(161.125 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(188.90625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(244.515625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(277.8125 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(333.421875 0)"/>
+ <use xlink:href="#Helvetica-53" transform="translate(389.03125 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(444.640625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(494.640625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(522.421875 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(555.71875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(611.328125 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(666.9375 0)"/>
+ <use xlink:href="#Helvetica-f" transform="translate(722.546875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(750.328125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(778.109375 0)"/>
+ <use xlink:href="#Helvetica-49" transform="translate(833.71875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(861.5 0)"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(889.28125 0)"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(944.890625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="patch_3">
+ <path d="M 60.292586 286.273676
+L 76.822041 286.273676
+L 76.822041 278.330929
+L 60.292586 278.330929
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_4">
+ <path d="M 103.79115 286.273676
+L 120.320605 286.273676
+L 120.320605 280.316616
+L 103.79115 280.316616
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_5">
+ <path d="M 147.289714 286.273676
+L 163.819168 286.273676
+L 163.819168 276.345242
+L 147.289714 276.345242
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_6">
+ <path d="M 190.788278 286.273676
+L 207.317732 286.273676
+L 207.317732 278.330929
+L 190.788278 278.330929
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_7">
+ <path d="M 234.286842 286.273676
+L 250.816296 286.273676
+L 250.816296 282.302302
+L 234.286842 282.302302
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_8">
+ <path d="M 277.785406 286.273676
+L 294.31486 286.273676
+L 294.31486 270.388181
+L 277.785406 270.388181
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_9">
+ <path d="M 76.822041 286.273676
+L 93.351495 286.273676
+L 93.351495 282.302302
+L 76.822041 282.302302
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_10">
+ <path d="M 120.320605 286.273676
+L 136.850059 286.273676
+L 136.850059 282.302302
+L 120.320605 282.302302
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_11">
+ <path d="M 163.819168 286.273676
+L 180.348623 286.273676
+L 180.348623 284.287989
+L 163.819168 284.287989
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_12">
+ <path d="M 207.317732 286.273676
+L 223.847187 286.273676
+L 223.847187 284.287989
+L 207.317732 284.287989
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_13">
+ <path d="M 250.816296 286.273676
+L 267.34575 286.273676
+L 267.34575 284.287989
+L 250.816296 284.287989
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_14">
+ <path d="M 294.31486 286.273676
+L 310.844314 286.273676
+L 310.844314 274.359555
+L 294.31486 274.359555
+z
+" clip-path="url(#p3ff16522ac)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_15">
+ <path d="M 47.765 286.273676
+L 47.765 118.086
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="patch_16">
+ <path d="M 47.765 286.273676
+L 323.371901 286.273676
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="text_13">
+ <!-- 4 -->
+ <g style="fill: #52514e" transform="translate(65.359774 276.345242) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-17"/>
+ </g>
+ </g>
+ <g id="text_14">
+ <!-- 2 -->
+ <g style="fill: #52514e" transform="translate(81.889229 280.316616) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-15"/>
+ </g>
+ </g>
+ <g id="text_15">
+ <!-- 3 -->
+ <g style="fill: #52514e" transform="translate(108.858338 278.330929) scale(0.115 -0.115)">
+ <defs>
+ <path id="Helvetica-16" d="M 1663 -122
+Q 869 -122 511 314
+Q 153 750 153 1375
+L 741 1375
+Q 778 941 903 744
+Q 1122 391 1694 391
+Q 2138 391 2406 628
+Q 2675 866 2675 1241
+Q 2675 1703 2392 1887
+Q 2109 2072 1606 2072
+Q 1550 2072 1492 2070
+Q 1434 2069 1375 2066
+L 1375 2563
+Q 1463 2553 1522 2550
+Q 1581 2547 1650 2547
+Q 1966 2547 2169 2647
+Q 2525 2822 2525 3272
+Q 2525 3606 2287 3787
+Q 2050 3969 1734 3969
+Q 1172 3969 956 3594
+Q 838 3388 822 3006
+L 266 3006
+Q 266 3506 466 3856
+Q 809 4481 1675 4481
+Q 2359 4481 2734 4176
+Q 3109 3872 3109 3294
+Q 3109 2881 2888 2625
+Q 2750 2466 2531 2375
+Q 2884 2278 3082 2001
+Q 3281 1725 3281 1325
+Q 3281 684 2859 281
+Q 2438 -122 1663 -122
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-16"/>
+ </g>
+ </g>
+ <g id="text_16">
+ <!-- 2 -->
+ <g style="fill: #52514e" transform="translate(125.387793 280.316616) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-15"/>
+ </g>
+ </g>
+ <g id="text_17">
+ <!-- 5 -->
+ <g style="fill: #52514e" transform="translate(152.356902 274.359555) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-18"/>
+ </g>
+ </g>
+ <g id="text_18">
+ <!-- 1 -->
+ <g style="fill: #52514e" transform="translate(168.886356 282.302302) scale(0.115 -0.115)">
+ <defs>
+ <path id="Helvetica-14" d="M 613 3169
+L 613 3600
+Q 1222 3659 1462 3798
+Q 1703 3938 1822 4456
+L 2266 4456
+L 2266 0
+L 1666 0
+L 1666 3169
+L 613 3169
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-14"/>
+ </g>
+ </g>
+ <g id="text_19">
+ <!-- 4 -->
+ <g style="fill: #52514e" transform="translate(195.855466 276.345242) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-17"/>
+ </g>
+ </g>
+ <g id="text_20">
+ <!-- 1 -->
+ <g style="fill: #52514e" transform="translate(212.38492 282.302302) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-14"/>
+ </g>
+ </g>
+ <g id="text_21">
+ <!-- 2 -->
+ <g style="fill: #52514e" transform="translate(239.35403 280.316616) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-15"/>
+ </g>
+ </g>
+ <g id="text_22">
+ <!-- 1 -->
+ <g style="fill: #52514e" transform="translate(255.883484 282.302302) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-14"/>
+ </g>
+ </g>
+ <g id="text_23">
+ <!-- 8 -->
+ <g style="fill: #52514e" transform="translate(282.852594 268.402495) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1b"/>
+ </g>
+ </g>
+ <g id="text_24">
+ <!-- 6 -->
+ <g style="fill: #52514e" transform="translate(299.382048 272.373868) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-19"/>
+ </g>
+ </g>
+ <g id="text_25">
+ <!-- ORDER BY s2 (geometry) -->
+ <g style="fill: #0b0b0b" transform="translate(82.752982 106.086) scale(0.17 -0.17)">
+ <defs>
+ <path id="Helvetica-Bold-32" d="M 2525 -128
+Q 1538 -128 1016 409
+Q 316 1069 316 2309
+Q 316 3575 1016 4209
+Q 1538 4747 2525 4747
+Q 3513 4747 4034 4209
+Q 4731 3575 4731 2309
+Q 4731 1069 4034 409
+Q 3513 -128 2525 -128
+z
+M 3434 1109
+Q 3769 1531 3769 2309
+Q 3769 3084 3433 3507
+Q 3097 3931 2525 3931
+Q 1953 3931 1612 3509
+Q 1272 3088 1272 2309
+Q 1272 1531 1612 1109
+Q 1953 688 2525 688
+Q 3097 688 3434 1109
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-35" d="M 2444 1806
+L 1450 1806
+L 1450 0
+L 509 0
+L 509 4606
+L 2769 4606
+Q 3253 4597 3514 4487
+Q 3775 4378 3956 4166
+Q 4106 3991 4193 3778
+Q 4281 3566 4281 3294
+Q 4281 2966 4115 2648
+Q 3950 2331 3569 2200
+Q 3888 2072 4020 1836
+Q 4153 1600 4153 1116
+L 4153 806
+Q 4153 491 4178 378
+Q 4216 200 4353 116
+L 4353 0
+L 3294 0
+Q 3250 153 3231 247
+Q 3194 441 3191 644
+L 3184 1072
+Q 3178 1513 3023 1659
+Q 2869 1806 2444 1806
+z
+M 3028 2644
+Q 3316 2775 3316 3163
+Q 3316 3581 3038 3725
+Q 2881 3806 2569 3806
+L 1450 3806
+L 1450 2569
+L 2541 2569
+Q 2866 2569 3028 2644
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-27" d="M 2472 0
+L 488 0
+L 488 4606
+L 2472 4606
+Q 2900 4600 3184 4506
+Q 3669 4347 3969 3922
+Q 4209 3578 4296 3178
+Q 4384 2778 4384 2416
+Q 4384 1497 4016 859
+Q 3516 0 2472 0
+z
+M 3188 3431
+Q 2966 3806 2309 3806
+L 1422 3806
+L 1422 800
+L 2309 800
+Q 2991 800 3259 1472
+Q 3406 1841 3406 2350
+Q 3406 3053 3188 3431
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-28" d="M 3694 2013
+L 1456 2013
+L 1456 828
+L 4006 828
+L 4006 0
+L 516 0
+L 516 4606
+L 3894 4606
+L 3894 3791
+L 1456 3791
+L 1456 2813
+L 3694 2813
+L 3694 2013
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-3" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-25" d="M 2591 0
+L 503 0
+L 503 4606
+L 2741 4606
+Q 3588 4594 3941 4116
+Q 4153 3822 4153 3413
+Q 4153 2991 3941 2734
+Q 3822 2591 3591 2472
+Q 3944 2344 4123 2066
+Q 4303 1788 4303 1391
+Q 4303 981 4097 656
+Q 3966 441 3769 294
+Q 3547 125 3245 62
+Q 2944 0 2591 0
+z
+M 2569 2028
+L 1422 2028
+L 1422 800
+L 2553 800
+Q 2856 800 3025 881
+Q 3331 1031 3331 1456
+Q 3331 1816 3034 1950
+Q 2869 2025 2569 2028
+z
+M 3047 2906
+Q 3234 3019 3234 3309
+Q 3234 3631 2984 3734
+Q 2769 3806 2434 3806
+L 1422 3806
+L 1422 2791
+L 2553 2791
+Q 2856 2791 3047 2906
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-3c" d="M 4206 4606
+L 2666 1731
+L 2666 0
+L 1703 0
+L 1703 1731
+L 109 4606
+L 1244 4606
+L 2200 2600
+L 3116 4606
+L 4206 4606
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-56" d="M 2763 3250
+Q 3163 2994 3222 2369
+L 2331 2369
+Q 2313 2541 2234 2641
+Q 2088 2822 1734 2822
+Q 1444 2822 1320 2731
+Q 1197 2641 1197 2519
+Q 1197 2366 1328 2297
+Q 1459 2225 2256 2050
+Q 2788 1925 3053 1672
+Q 3316 1416 3316 1031
+Q 3316 525 2939 204
+Q 2563 -116 1775 -116
+Q 972 -116 589 223
+Q 206 563 206 1088
+L 1109 1088
+Q 1138 850 1231 750
+Q 1397 572 1844 572
+Q 2106 572 2261 650
+Q 2416 728 2416 884
+Q 2416 1034 2291 1113
+Q 2166 1191 1363 1381
+Q 784 1525 547 1741
+Q 309 1953 309 2353
+Q 309 2825 679 3164
+Q 1050 3503 1722 3503
+Q 2359 3503 2763 3250
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-15" d="M 2225 3609
+Q 2066 3800 1769 3800
+Q 1363 3800 1216 3497
+Q 1131 3322 1116 2941
+L 250 2941
+Q 272 3519 459 3875
+Q 816 4553 1725 4553
+Q 2444 4553 2869 4154
+Q 3294 3756 3294 3100
+Q 3294 2597 2994 2206
+Q 2797 1947 2347 1628
+L 1991 1375
+Q 1656 1138 1532 1031
+Q 1409 925 1325 784
+L 3303 784
+L 3303 0
+L 200 0
+Q 213 488 409 891
+Q 600 1344 1309 1850
+Q 1925 2291 2106 2481
+Q 2384 2778 2384 3131
+Q 2384 3419 2225 3609
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-b" d="M 1394 -1291
+L 1172 -988
+Q 956 -713 713 -169
+Q 278 803 278 1744
+Q 278 2600 644 3444
+Q 891 4019 1366 4681
+L 2038 4681
+L 1847 4331
+Q 1453 3609 1300 2819
+Q 1200 2300 1200 1688
+Q 1200 731 1478 -72
+Q 1641 -547 2053 -1291
+L 1394 -1291
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-4a" d="M 1378 -597
+Q 1522 -719 1863 -719
+Q 2344 -719 2506 -397
+Q 2613 -191 2613 297
+L 2613 516
+Q 2484 297 2338 188
+Q 2072 -16 1647 -16
+Q 991 -16 598 445
+Q 206 906 206 1694
+Q 206 2453 584 2970
+Q 963 3488 1656 3488
+Q 1913 3488 2103 3409
+Q 2428 3275 2628 2916
+L 2628 3406
+L 3494 3406
+L 3494 175
+Q 3494 -484 3272 -819
+Q 2891 -1394 1809 -1394
+Q 1156 -1394 743 -1137
+Q 331 -881 288 -372
+L 1256 -372
+Q 1294 -528 1378 -597
+z
+M 1228 1163
+Q 1409 731 1878 731
+Q 2191 731 2406 967
+Q 2622 1203 2622 1719
+Q 2622 2203 2417 2456
+Q 2213 2709 1869 2709
+Q 1400 2709 1222 2269
+Q 1128 2034 1128 1691
+Q 1128 1394 1228 1163
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-48" d="M 3331 1000
+Q 3297 697 3016 384
+Q 2578 -113 1791 -113
+Q 1141 -113 644 306
+Q 147 725 147 1669
+Q 147 2553 595 3025
+Q 1044 3497 1759 3497
+Q 2184 3497 2525 3337
+Q 2866 3178 3088 2834
+Q 3288 2531 3347 2131
+Q 3381 1897 3375 1456
+L 1044 1456
+Q 1063 944 1366 738
+Q 1550 609 1809 609
+Q 2084 609 2256 766
+Q 2350 850 2422 1000
+L 3331 1000
+z
+M 2450 2044
+Q 2428 2397 2236 2580
+Q 2044 2763 1759 2763
+Q 1450 2763 1279 2569
+Q 1109 2375 1066 2044
+L 2450 2044
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-52" d="M 3256 2975
+Q 3688 2434 3688 1697
+Q 3688 947 3256 414
+Q 2825 -119 1947 -119
+Q 1069 -119 637 414
+Q 206 947 206 1697
+Q 206 2434 637 2975
+Q 1069 3516 1947 3516
+Q 2825 3516 3256 2975
+z
+M 1944 2763
+Q 1553 2763 1342 2486
+Q 1131 2209 1131 1697
+Q 1131 1184 1342 906
+Q 1553 628 1944 628
+Q 2334 628 2543 906
+Q 2753 1184 2753 1697
+Q 2753 2209 2543 2486
+Q 2334 2763 1944 2763
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-50" d="M 2328 2469
+Q 2216 2716 1888 2716
+Q 1506 2716 1375 2469
+Q 1303 2328 1303 2050
+L 1303 0
+L 400 0
+L 400 3400
+L 1266 3400
+L 1266 2903
+Q 1431 3169 1578 3281
+Q 1838 3481 2250 3481
+Q 2641 3481 2881 3309
+Q 3075 3150 3175 2900
+Q 3350 3200 3609 3341
+Q 3884 3481 4222 3481
+Q 4447 3481 4665 3393
+Q 4884 3306 5063 3088
+Q 5206 2909 5256 2650
+Q 5288 2478 5288 2147
+L 5281 0
+L 4369 0
+L 4369 2169
+Q 4369 2363 4306 2488
+Q 4188 2725 3869 2725
+Q 3500 2725 3359 2419
+Q 3288 2256 3288 2028
+L 3288 0
+L 2391 0
+L 2391 2028
+Q 2391 2331 2328 2469
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-57" d="M 1975 634
+L 1975 -31
+L 1553 -47
+Q 922 -69 691 172
+Q 541 325 541 644
+L 541 2741
+L 66 2741
+L 66 3375
+L 541 3375
+L 541 4325
+L 1422 4325
+L 1422 3375
+L 1975 3375
+L 1975 2741
+L 1422 2741
+L 1422 941
+Q 1422 731 1475 679
+Q 1528 628 1800 628
+Q 1841 628 1886 629
+Q 1931 631 1975 634
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-55" d="M 2128 2584
+Q 1591 2584 1406 2234
+Q 1303 2038 1303 1628
+L 1303 0
+L 406 0
+L 406 3406
+L 1256 3406
+L 1256 2813
+Q 1463 3153 1616 3278
+Q 1866 3488 2266 3488
+Q 2291 3488 2308 3486
+Q 2325 3484 2384 3481
+L 2384 2569
+Q 2300 2578 2234 2581
+Q 2169 2584 2128 2584
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-5c" d="M 1800 894
+L 2503 3406
+L 3450 3406
+L 2281 56
+Q 1944 -913 1747 -1145
+Q 1550 -1378 959 -1378
+Q 841 -1378 769 -1376
+Q 697 -1375 553 -1366
+L 553 -653
+L 666 -659
+Q 797 -666 915 -650
+Q 1034 -634 1116 -578
+Q 1194 -525 1261 -356
+Q 1328 -188 1316 -150
+L 66 3406
+L 1056 3406
+L 1800 894
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-c" d="M 947 -988
+L 725 -1291
+L 66 -1291
+Q 478 -547 641 -72
+Q 919 731 919 1688
+Q 919 2300 819 2819
+Q 666 3609 272 4331
+L 81 4681
+L 753 4681
+Q 1228 4019 1475 3444
+Q 1841 2600 1841 1744
+Q 1841 803 1406 -169
+Q 1163 -713 947 -988
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-Bold-32"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-Bold-27" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-Bold-28" transform="translate(222.21875 0)"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(288.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(361.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-25" transform="translate(388.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3c" transform="translate(461.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(526.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-56" transform="translate(553.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-15" transform="translate(609.484375 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(665.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-b" transform="translate(692.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-4a" transform="translate(726.171875 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(787.25 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(842.859375 0)"/>
+ <use xlink:href="#Helvetica-Bold-50" transform="translate(903.9375 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(992.859375 0)"/>
+ <use xlink:href="#Helvetica-Bold-57" transform="translate(1048.46875 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(1081.765625 0)"/>
+ <use xlink:href="#Helvetica-Bold-5c" transform="translate(1120.6875 0)"/>
+ <use xlink:href="#Helvetica-Bold-c" transform="translate(1176.296875 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="axes_2">
+ <g id="patch_17">
+ <path d="M 348.67905 286.273676
+L 624.28595 286.273676
+L 624.28595 118.086
+L 348.67905 118.086
+z
+" style="fill: #fcfcfb"/>
+ </g>
+ <g id="matplotlib.axis_3">
+ <g id="xtick_7">
+ <g id="line2d_17">
+ <g>
+ <use xlink:href="#m71ddc384de" x="377.73609" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_26">
+ <!-- Seattle -->
+ <g style="fill: #52514e" transform="translate(345.96506 322.073426) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_8">
+ <g id="line2d_18">
+ <g>
+ <use xlink:href="#m71ddc384de" x="421.234654" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_27">
+ <!-- Tacoma -->
+ <g style="fill: #52514e" transform="translate(385.648423 324.744859) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-37"/>
+ <use xlink:href="#Helvetica-44" transform="translate(50 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(105.609375 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(155.609375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(211.21875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(294.515625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_9">
+ <g id="line2d_19">
+ <g>
+ <use xlink:href="#m71ddc384de" x="464.733218" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_28">
+ <!-- Spokane -->
+ <g style="fill: #52514e" transform="translate(424.495328 327.81636) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-53" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(227.921875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(283.53125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(339.140625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_10">
+ <g id="line2d_20">
+ <g>
+ <use xlink:href="#m71ddc384de" x="508.231782" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_29">
+ <!-- Olympia -->
+ <g style="fill: #52514e" transform="translate(470.706911 325.888068) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-32"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(100 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-53" transform="translate(233.296875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(288.90625 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(311.125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_11">
+ <g id="line2d_21">
+ <g>
+ <use xlink:href="#m71ddc384de" x="551.730346" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_30">
+ <!-- Leavenworth -->
+ <g style="fill: #52514e" transform="translate(494.278899 340.055048) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-2f"/>
+ <use xlink:href="#Helvetica-48" transform="translate(55.609375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(111.21875 0)"/>
+ <use xlink:href="#Helvetica-59" transform="translate(166.828125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(216.828125 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(272.4375 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(328.046875 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(400.265625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(455.875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(489.171875 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(516.953125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_12">
+ <g id="line2d_22">
+ <g>
+ <use xlink:href="#m71ddc384de" x="595.22891" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_31">
+ <!-- Seattle 5 km -->
+ <g style="fill: #52514e" transform="translate(539.42703 338.900008) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(311.3125 0)"/>
+ <use xlink:href="#Helvetica-18" transform="translate(339.09375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(394.703125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(422.484375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(472.484375 0)"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <g id="matplotlib.axis_4">
+ <g id="ytick_6">
+ <g id="line2d_23">
+ <path d="M 348.67905 286.273676
+L 624.28595 286.273676
+" clip-path="url(#p5725f90031)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_24">
+ <g>
+ <use xlink:href="#m210d293422" x="348.67905" y="286.273676" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_7">
+ <g id="line2d_25">
+ <path d="M 348.67905 246.559939
+L 624.28595 246.559939
+" clip-path="url(#p5725f90031)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_26">
+ <g>
+ <use xlink:href="#m210d293422" x="348.67905" y="246.559939" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_8">
+ <g id="line2d_27">
+ <path d="M 348.67905 206.846202
+L 624.28595 206.846202
+" clip-path="url(#p5725f90031)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_28">
+ <g>
+ <use xlink:href="#m210d293422" x="348.67905" y="206.846202" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_9">
+ <g id="line2d_29">
+ <path d="M 348.67905 167.132465
+L 624.28595 167.132465
+" clip-path="url(#p5725f90031)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_30">
+ <g>
+ <use xlink:href="#m210d293422" x="348.67905" y="167.132465" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_10">
+ <g id="line2d_31">
+ <path d="M 348.67905 127.418728
+L 624.28595 127.418728
+" clip-path="url(#p5725f90031)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_32">
+ <g>
+ <use xlink:href="#m210d293422" x="348.67905" y="127.418728" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <g id="patch_18">
+ <path d="M 361.206636 286.273676
+L 377.73609 286.273676
+L 377.73609 179.046586
+L 361.206636 179.046586
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_19">
+ <path d="M 404.7052 286.273676
+L 421.234654 286.273676
+L 421.234654 183.01796
+L 404.7052 183.01796
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_20">
+ <path d="M 448.203764 286.273676
+L 464.733218 286.273676
+L 464.733218 238.617192
+L 448.203764 238.617192
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_21">
+ <path d="M 491.702328 286.273676
+L 508.231782 286.273676
+L 508.231782 222.731697
+L 491.702328 222.731697
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_22">
+ <path d="M 535.200892 286.273676
+L 551.730346 286.273676
+L 551.730346 204.860515
+L 535.200892 204.860515
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_23">
+ <path d="M 578.699455 286.273676
+L 595.22891 286.273676
+L 595.22891 179.046586
+L 578.699455 179.046586
+z
+" clip-path="url(#p5725f90031)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_24">
+ <path d="M 377.73609 286.273676
+L 394.265545 286.273676
+L 394.265545 270.388181
+L 377.73609 270.388181
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_25">
+ <path d="M 421.234654 286.273676
+L 437.764108 286.273676
+L 437.764108 266.416808
+L 421.234654 266.416808
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_26">
+ <path d="M 464.733218 286.273676
+L 481.262672 286.273676
+L 481.262672 280.316616
+L 464.733218 280.316616
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_27">
+ <path d="M 508.231782 286.273676
+L 524.761236 286.273676
+L 524.761236 280.316616
+L 508.231782 280.316616
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_28">
+ <path d="M 551.730346 286.273676
+L 568.2598 286.273676
+L 568.2598 280.316616
+L 551.730346 280.316616
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_29">
+ <path d="M 595.22891 286.273676
+L 611.758364 286.273676
+L 611.758364 270.388181
+L 595.22891 270.388181
+z
+" clip-path="url(#p5725f90031)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_30">
+ <path d="M 348.67905 286.273676
+L 348.67905 118.086
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="patch_31">
+ <path d="M 348.67905 286.273676
+L 624.28595 286.273676
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="text_32">
+ <!-- 54 -->
+ <g style="fill: #52514e" transform="translate(363.076285 177.060899) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-18"/>
+ <use xlink:href="#Helvetica-17" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_33">
+ <!-- 8 -->
+ <g style="fill: #52514e" transform="translate(382.803278 268.402495) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1b"/>
+ </g>
+ </g>
+ <g id="text_34">
+ <!-- 52 -->
+ <g style="fill: #52514e" transform="translate(406.574849 181.032273) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-18"/>
+ <use xlink:href="#Helvetica-15" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_35">
+ <!-- 10 -->
+ <g style="fill: #52514e" transform="translate(423.104303 264.431121) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-14"/>
+ <use xlink:href="#Helvetica-13" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_36">
+ <!-- 24 -->
+ <g style="fill: #52514e" transform="translate(450.073413 236.631505) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-15"/>
+ <use xlink:href="#Helvetica-17" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_37">
+ <!-- 3 -->
+ <g style="fill: #52514e" transform="translate(469.800406 278.330929) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-16"/>
+ </g>
+ </g>
+ <g id="text_38">
+ <!-- 32 -->
+ <g style="fill: #52514e" transform="translate(493.571977 220.74601) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-16"/>
+ <use xlink:href="#Helvetica-15" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_39">
+ <!-- 3 -->
+ <g style="fill: #52514e" transform="translate(513.29897 278.330929) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-16"/>
+ </g>
+ </g>
+ <g id="text_40">
+ <!-- 41 -->
+ <g style="fill: #52514e" transform="translate(537.070541 202.874828) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-17"/>
+ <use xlink:href="#Helvetica-14" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_41">
+ <!-- 3 -->
+ <g style="fill: #52514e" transform="translate(556.797534 278.330929) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-16"/>
+ </g>
+ </g>
+ <g id="text_42">
+ <!-- 54 -->
+ <g style="fill: #52514e" transform="translate(580.569104 177.060899) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-18"/>
+ <use xlink:href="#Helvetica-17" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_43">
+ <!-- 8 -->
+ <g style="fill: #52514e" transform="translate(600.296098 268.402495) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1b"/>
+ </g>
+ </g>
+ <g id="text_44">
+ <!-- ORDER BY place (another column) -->
+ <g style="fill: #0b0b0b" transform="translate(345.897812 106.086) scale(0.17 -0.17)">
+ <defs>
+ <path id="Helvetica-Bold-53" d="M 3269 3041
+Q 3681 2600 3681 1747
+Q 3681 847 3276 375
+Q 2872 -97 2234 -97
+Q 1828 -97 1559 106
+Q 1413 219 1272 434
+L 1272 -1341
+L 391 -1341
+L 391 3406
+L 1244 3406
+L 1244 2903
+Q 1388 3125 1550 3253
+Q 1847 3481 2256 3481
+Q 2853 3481 3269 3041
+z
+M 2763 1703
+Q 2763 2097 2583 2400
+Q 2403 2703 2000 2703
+Q 1516 2703 1334 2244
+Q 1241 2000 1241 1625
+Q 1241 1031 1556 791
+Q 1744 650 2000 650
+Q 2372 650 2567 937
+Q 2763 1225 2763 1703
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-4f" d="M 434 4606
+L 1325 4606
+L 1325 0
+L 434 0
+L 434 4606
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-44" d="M 544 3038
+Q 897 3488 1756 3488
+Q 2316 3488 2750 3266
+Q 3184 3044 3184 2428
+L 3184 866
+Q 3184 703 3191 472
+Q 3200 297 3244 234
+Q 3288 172 3375 131
+L 3375 0
+L 2406 0
+Q 2366 103 2350 193
+Q 2334 284 2325 400
+Q 2141 200 1900 59
+Q 1613 -106 1250 -106
+Q 788 -106 486 158
+Q 184 422 184 906
+Q 184 1534 669 1816
+Q 934 1969 1450 2034
+L 1753 2072
+Q 2000 2103 2106 2150
+Q 2297 2231 2297 2403
+Q 2297 2613 2151 2692
+Q 2006 2772 1725 2772
+Q 1409 2772 1278 2616
+Q 1184 2500 1153 2303
+L 294 2303
+Q 322 2750 544 3038
+z
+M 1206 644
+Q 1331 541 1513 541
+Q 1800 541 2042 709
+Q 2284 878 2294 1325
+L 2294 1656
+Q 2209 1603 2123 1570
+Q 2038 1538 1888 1509
+L 1688 1472
+Q 1406 1422 1284 1350
+Q 1078 1228 1078 972
+Q 1078 744 1206 644
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-46" d="M 3363 2184
+L 2450 2184
+Q 2425 2375 2322 2528
+Q 2172 2734 1856 2734
+Q 1406 2734 1241 2288
+Q 1153 2050 1153 1656
+Q 1153 1281 1241 1053
+Q 1400 628 1841 628
+Q 2153 628 2284 797
+Q 2416 966 2444 1234
+L 3353 1234
+Q 3322 828 3059 466
+Q 2641 -119 1819 -119
+Q 997 -119 609 368
+Q 222 856 222 1634
+Q 222 2513 650 3000
+Q 1078 3488 1831 3488
+Q 2472 3488 2880 3200
+Q 3288 2913 3363 2184
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-51" d="M 2019 2747
+Q 1566 2747 1397 2363
+Q 1309 2159 1309 1844
+L 1309 0
+L 422 0
+L 422 3400
+L 1281 3400
+L 1281 2903
+Q 1453 3166 1606 3281
+Q 1881 3488 2303 3488
+Q 2831 3488 3167 3211
+Q 3503 2934 3503 2294
+L 3503 0
+L 2591 0
+L 2591 2072
+Q 2591 2341 2519 2484
+Q 2388 2747 2019 2747
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-4b" d="M 3494 2000
+L 3494 0
+L 2584 0
+L 2584 2072
+Q 2584 2347 2491 2516
+Q 2369 2753 2028 2753
+Q 1675 2753 1492 2517
+Q 1309 2281 1309 1844
+L 1309 0
+L 422 0
+L 422 4591
+L 1309 4591
+L 1309 2963
+Q 1503 3259 1758 3376
+Q 2013 3494 2294 3494
+Q 2609 3494 2867 3384
+Q 3125 3275 3291 3050
+Q 3431 2859 3462 2657
+Q 3494 2456 3494 2000
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-58" d="M 2600 481
+Q 2588 466 2538 387
+Q 2488 309 2419 250
+Q 2209 63 2014 -6
+Q 1819 -75 1556 -75
+Q 800 -75 538 469
+Q 391 769 391 1353
+L 391 3406
+L 1303 3406
+L 1303 1353
+Q 1303 1063 1372 916
+Q 1494 656 1850 656
+Q 2306 656 2475 1025
+Q 2563 1225 2563 1553
+L 2563 3406
+L 3466 3406
+L 3466 0
+L 2600 0
+L 2600 481
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-Bold-32"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-Bold-27" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-Bold-28" transform="translate(222.21875 0)"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(288.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(361.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-25" transform="translate(388.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3c" transform="translate(461.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(526.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-53" transform="translate(553.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-4f" transform="translate(614.953125 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(642.734375 0)"/>
+ <use xlink:href="#Helvetica-Bold-46" transform="translate(698.34375 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(753.953125 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(809.5625 0)"/>
+ <use xlink:href="#Helvetica-Bold-b" transform="translate(837.34375 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(870.640625 0)"/>
+ <use xlink:href="#Helvetica-Bold-51" transform="translate(926.25 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(987.328125 0)"/>
+ <use xlink:href="#Helvetica-Bold-57" transform="translate(1048.40625 0)"/>
+ <use xlink:href="#Helvetica-Bold-4b" transform="translate(1081.703125 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(1142.78125 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(1198.390625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(1237.3125 0)"/>
+ <use xlink:href="#Helvetica-Bold-46" transform="translate(1265.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(1320.703125 0)"/>
+ <use xlink:href="#Helvetica-Bold-4f" transform="translate(1381.78125 0)"/>
+ <use xlink:href="#Helvetica-Bold-58" transform="translate(1409.5625 0)"/>
+ <use xlink:href="#Helvetica-Bold-50" transform="translate(1470.640625 0)"/>
+ <use xlink:href="#Helvetica-Bold-51" transform="translate(1559.5625 0)"/>
+ <use xlink:href="#Helvetica-Bold-c" transform="translate(1620.640625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="axes_3">
+ <g id="patch_32">
+ <path d="M 649.593099 286.273676
+L 925.2 286.273676
+L 925.2 118.086
+L 649.593099 118.086
+z
+" style="fill: #fcfcfb"/>
+ </g>
+ <g id="matplotlib.axis_5">
+ <g id="xtick_13">
+ <g id="line2d_33">
+ <g>
+ <use xlink:href="#m71ddc384de" x="678.65014" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_45">
+ <!-- Seattle -->
+ <g style="fill: #52514e" transform="translate(646.879109 322.073426) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_14">
+ <g id="line2d_34">
+ <g>
+ <use xlink:href="#m71ddc384de" x="722.148704" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_46">
+ <!-- Tacoma -->
+ <g style="fill: #52514e" transform="translate(686.562472 324.744859) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-37"/>
+ <use xlink:href="#Helvetica-44" transform="translate(50 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(105.609375 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(155.609375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(211.21875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(294.515625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_15">
+ <g id="line2d_35">
+ <g>
+ <use xlink:href="#m71ddc384de" x="765.647268" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_47">
+ <!-- Spokane -->
+ <g style="fill: #52514e" transform="translate(725.409377 327.81636) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-53" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(227.921875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(283.53125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(339.140625 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_16">
+ <g id="line2d_36">
+ <g>
+ <use xlink:href="#m71ddc384de" x="809.145832" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_48">
+ <!-- Olympia -->
+ <g style="fill: #52514e" transform="translate(771.620961 325.888068) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-32"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(100 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-53" transform="translate(233.296875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(288.90625 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(311.125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_17">
+ <g id="line2d_37">
+ <g>
+ <use xlink:href="#m71ddc384de" x="852.644395" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_49">
+ <!-- Leavenworth -->
+ <g style="fill: #52514e" transform="translate(795.192948 340.055048) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-2f"/>
+ <use xlink:href="#Helvetica-48" transform="translate(55.609375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(111.21875 0)"/>
+ <use xlink:href="#Helvetica-59" transform="translate(166.828125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(216.828125 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(272.4375 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(328.046875 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(400.265625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(455.875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(489.171875 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(516.953125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="xtick_18">
+ <g id="line2d_38">
+ <g>
+ <use xlink:href="#m71ddc384de" x="896.142959" y="286.273676" style="stroke: #000000; stroke-width: 0.8"/>
+ </g>
+ </g>
+ <g id="text_50">
+ <!-- Seattle 5 km -->
+ <g style="fill: #52514e" transform="translate(840.341079 338.900008) rotate(-35) scale(0.12 -0.12)">
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-48" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(122.3125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(177.921875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(205.703125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(233.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(255.703125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(311.3125 0)"/>
+ <use xlink:href="#Helvetica-18" transform="translate(339.09375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(394.703125 0)"/>
+ <use xlink:href="#Helvetica-4e" transform="translate(422.484375 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(472.484375 0)"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <g id="matplotlib.axis_6">
+ <g id="ytick_11">
+ <g id="line2d_39">
+ <path d="M 649.593099 286.273676
+L 925.2 286.273676
+" clip-path="url(#p5aa6b8dcee)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_40">
+ <g>
+ <use xlink:href="#m210d293422" x="649.593099" y="286.273676" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_12">
+ <g id="line2d_41">
+ <path d="M 649.593099 246.559939
+L 925.2 246.559939
+" clip-path="url(#p5aa6b8dcee)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_42">
+ <g>
+ <use xlink:href="#m210d293422" x="649.593099" y="246.559939" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_13">
+ <g id="line2d_43">
+ <path d="M 649.593099 206.846202
+L 925.2 206.846202
+" clip-path="url(#p5aa6b8dcee)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_44">
+ <g>
+ <use xlink:href="#m210d293422" x="649.593099" y="206.846202" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_14">
+ <g id="line2d_45">
+ <path d="M 649.593099 167.132465
+L 925.2 167.132465
+" clip-path="url(#p5aa6b8dcee)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_46">
+ <g>
+ <use xlink:href="#m210d293422" x="649.593099" y="167.132465" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ <g id="ytick_15">
+ <g id="line2d_47">
+ <path d="M 649.593099 127.418728
+L 925.2 127.418728
+" clip-path="url(#p5aa6b8dcee)" style="fill: none; stroke: #ecece8; stroke-linecap: square"/>
+ </g>
+ <g id="line2d_48">
+ <g>
+ <use xlink:href="#m210d293422" x="649.593099" y="127.418728" style="fill: #52514e; stroke: #52514e; stroke-width: 0.8"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <g id="patch_33">
+ <path d="M 662.120686 286.273676
+L 678.65014 286.273676
+L 678.65014 133.375789
+L 662.120686 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_34">
+ <path d="M 705.61925 286.273676
+L 722.148704 286.273676
+L 722.148704 133.375789
+L 705.61925 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_35">
+ <path d="M 749.117813 286.273676
+L 765.647268 286.273676
+L 765.647268 133.375789
+L 749.117813 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_36">
+ <path d="M 792.616377 286.273676
+L 809.145832 286.273676
+L 809.145832 133.375789
+L 792.616377 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_37">
+ <path d="M 836.114941 286.273676
+L 852.644395 286.273676
+L 852.644395 133.375789
+L 836.114941 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_38">
+ <path d="M 879.613505 286.273676
+L 896.142959 286.273676
+L 896.142959 133.375789
+L 879.613505 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #2a78d6"/>
+ </g>
+ <g id="patch_39">
+ <path d="M 678.65014 286.273676
+L 695.179594 286.273676
+L 695.179594 133.375789
+L 678.65014 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_40">
+ <path d="M 722.148704 286.273676
+L 738.678158 286.273676
+L 738.678158 133.375789
+L 722.148704 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_41">
+ <path d="M 765.647268 286.273676
+L 782.176722 286.273676
+L 782.176722 133.375789
+L 765.647268 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_42">
+ <path d="M 809.145832 286.273676
+L 825.675286 286.273676
+L 825.675286 133.375789
+L 809.145832 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_43">
+ <path d="M 852.644395 286.273676
+L 869.17385 286.273676
+L 869.17385 133.375789
+L 852.644395 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_44">
+ <path d="M 896.142959 286.273676
+L 912.672414 286.273676
+L 912.672414 133.375789
+L 896.142959 133.375789
+z
+" clip-path="url(#p5aa6b8dcee)" style="fill: #eb6834"/>
+ </g>
+ <g id="patch_45">
+ <path d="M 649.593099 286.273676
+L 649.593099 118.086
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="patch_46">
+ <path d="M 649.593099 286.273676
+L 925.2 286.273676
+" style="fill: none; stroke: #d9d8d3; stroke-width: 0.8; stroke-linejoin: miter; stroke-linecap: square"/>
+ </g>
+ <g id="text_51">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(672.255062 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_52">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(715.753626 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_53">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(759.25219 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_54">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(802.750753 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_55">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(846.249317 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_56">
+ <!-- 77 -->
+ <g style="fill: #52514e" transform="translate(889.747881 131.390102) scale(0.115 -0.115)">
+ <use xlink:href="#Helvetica-1a"/>
+ <use xlink:href="#Helvetica-1a" transform="translate(55.609375 0)"/>
+ </g>
+ </g>
+ <g id="text_57">
+ <!-- ORDER BY rnd (shuffle) -->
+ <g style="fill: #0b0b0b" transform="translate(690.744909 106.086) scale(0.17 -0.17)">
+ <defs>
+ <path id="Helvetica-Bold-47" d="M 3516 4600
+L 3516 0
+L 2650 0
+L 2650 472
+Q 2459 169 2215 31
+Q 1972 -106 1609 -106
+Q 1013 -106 605 376
+Q 197 859 197 1616
+Q 197 2488 598 2988
+Q 1000 3488 1672 3488
+Q 1981 3488 2222 3352
+Q 2463 3216 2613 2975
+L 2613 4600
+L 3516 4600
+z
+M 1116 1681
+Q 1116 1209 1303 928
+Q 1488 644 1866 644
+Q 2244 644 2441 925
+Q 2638 1206 2638 1653
+Q 2638 2278 2322 2547
+Q 2128 2709 1872 2709
+Q 1481 2709 1298 2414
+Q 1116 2119 1116 1681
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-49" d="M 2013 4634
+L 2013 3909
+Q 1938 3919 1761 3923
+Q 1584 3928 1517 3845
+Q 1450 3763 1450 3663
+L 1450 3375
+L 2034 3375
+L 2034 2747
+L 1450 2747
+L 1450 0
+L 563 0
+L 563 2747
+L 66 2747
+L 66 3375
+L 553 3375
+L 553 3594
+Q 553 4141 738 4347
+Q 931 4653 1672 4653
+Q 1756 4653 1825 4648
+Q 1894 4644 2013 4634
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-c1" d="M 2034 4634
+L 2034 3909
+Q 1972 3913 1912 3914
+Q 1853 3916 1769 3916
+Q 1559 3916 1512 3800
+Q 1466 3684 1472 3438
+L 1472 3375
+L 2056 3375
+L 2056 2747
+L 1472 2747
+L 1472 0
+L 584 0
+L 584 2747
+L 88 2747
+L 88 3375
+L 575 3375
+L 575 3594
+Q 575 4138 816 4403
+Q 1031 4653 1694 4653
+Q 1775 4653 1859 4647
+Q 1944 4641 2034 4634
+z
+M 3472 4606
+L 3472 0
+L 2584 0
+L 2584 4606
+L 3472 4606
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-Bold-32"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(77.78125 0)"/>
+ <use xlink:href="#Helvetica-Bold-27" transform="translate(150 0)"/>
+ <use xlink:href="#Helvetica-Bold-28" transform="translate(222.21875 0)"/>
+ <use xlink:href="#Helvetica-Bold-35" transform="translate(288.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(361.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-25" transform="translate(388.921875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3c" transform="translate(461.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(526.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(553.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-51" transform="translate(592.796875 0)"/>
+ <use xlink:href="#Helvetica-Bold-47" transform="translate(653.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(714.953125 0)"/>
+ <use xlink:href="#Helvetica-Bold-b" transform="translate(742.734375 0)"/>
+ <use xlink:href="#Helvetica-Bold-56" transform="translate(776.03125 0)"/>
+ <use xlink:href="#Helvetica-Bold-4b" transform="translate(831.640625 0)"/>
+ <use xlink:href="#Helvetica-Bold-58" transform="translate(892.71875 0)"/>
+ <use xlink:href="#Helvetica-Bold-49" transform="translate(953.796875 0)"/>
+ <use xlink:href="#Helvetica-Bold-c1" transform="translate(987.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(1048.171875 0)"/>
+ <use xlink:href="#Helvetica-Bold-c" transform="translate(1103.78125 0)"/>
+ </g>
+ </g>
+ </g>
+ <g id="text_58">
+ <!-- Row groups a query has to read, per layout -->
+ <g style="fill: #0b0b0b" transform="translate(18.72 16.872) scale(0.2 -0.2)">
+ <defs>
+ <path id="Helvetica-Bold-5a" d="M 3000 0
+L 2466 2481
+L 1925 0
+L 1000 0
+L 44 3406
+L 1000 3406
+L 1531 963
+L 2022 3406
+L 2925 3406
+L 3444 953
+L 3975 3406
+L 4903 3406
+L 3916 0
+L 3000 0
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-54" d="M 2613 -1350
+L 2613 422
+Q 2513 216 2270 55
+Q 2028 -106 1609 -106
+Q 1019 -106 603 366
+Q 188 838 188 1625
+Q 188 2475 605 2984
+Q 1022 3494 1634 3494
+Q 2059 3494 2322 3284
+Q 2475 3166 2634 2894
+L 2634 3400
+L 3494 3400
+L 3494 -1350
+L 2613 -1350
+z
+M 1209 1084
+Q 1384 656 1859 656
+Q 2319 656 2513 1050
+Q 2638 1309 2638 1706
+Q 2638 2019 2531 2266
+Q 2341 2709 1863 2709
+Q 1525 2709 1320 2450
+Q 1116 2191 1116 1663
+Q 1116 1309 1209 1084
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-Bold-f" d="M 1275 -319
+Q 1219 -550 1066 -719
+Q 900 -900 676 -992
+Q 453 -1084 369 -1084
+L 369 -741
+Q 638 -666 764 -491
+Q 891 -316 909 0
+L 369 0
+L 369 931
+L 1331 931
+L 1331 125
+Q 1331 -88 1275 -319
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-Bold-35"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(72.21875 0)"/>
+ <use xlink:href="#Helvetica-Bold-5a" transform="translate(133.296875 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(211.078125 0)"/>
+ <use xlink:href="#Helvetica-Bold-4a" transform="translate(238.859375 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(299.9375 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(338.859375 0)"/>
+ <use xlink:href="#Helvetica-Bold-58" transform="translate(399.9375 0)"/>
+ <use xlink:href="#Helvetica-Bold-53" transform="translate(461.015625 0)"/>
+ <use xlink:href="#Helvetica-Bold-56" transform="translate(522.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(577.703125 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(605.484375 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(661.09375 0)"/>
+ <use xlink:href="#Helvetica-Bold-54" transform="translate(688.875 0)"/>
+ <use xlink:href="#Helvetica-Bold-58" transform="translate(749.953125 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(811.03125 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(866.640625 0)"/>
+ <use xlink:href="#Helvetica-Bold-5c" transform="translate(905.5625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(961.171875 0)"/>
+ <use xlink:href="#Helvetica-Bold-4b" transform="translate(988.953125 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(1050.03125 0)"/>
+ <use xlink:href="#Helvetica-Bold-56" transform="translate(1105.640625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(1161.25 0)"/>
+ <use xlink:href="#Helvetica-Bold-57" transform="translate(1189.03125 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(1222.328125 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(1283.40625 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(1311.1875 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(1350.109375 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(1405.71875 0)"/>
+ <use xlink:href="#Helvetica-Bold-47" transform="translate(1461.328125 0)"/>
+ <use xlink:href="#Helvetica-Bold-f" transform="translate(1522.40625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(1550.1875 0)"/>
+ <use xlink:href="#Helvetica-Bold-53" transform="translate(1577.96875 0)"/>
+ <use xlink:href="#Helvetica-Bold-48" transform="translate(1639.046875 0)"/>
+ <use xlink:href="#Helvetica-Bold-55" transform="translate(1694.65625 0)"/>
+ <use xlink:href="#Helvetica-Bold-3" transform="translate(1733.578125 0)"/>
+ <use xlink:href="#Helvetica-Bold-4f" transform="translate(1761.359375 0)"/>
+ <use xlink:href="#Helvetica-Bold-44" transform="translate(1789.140625 0)"/>
+ <use xlink:href="#Helvetica-Bold-5c" transform="translate(1844.75 0)"/>
+ <use xlink:href="#Helvetica-Bold-52" transform="translate(1900.359375 0)"/>
+ <use xlink:href="#Helvetica-Bold-58" transform="translate(1961.4375 0)"/>
+ <use xlink:href="#Helvetica-Bold-57" transform="translate(2022.515625 0)"/>
+ </g>
+ </g>
+ <g id="text_59">
+ <!-- Six query windows over 3.82 million Washington buildings; the file, the footer and the query are identical, only the row order changes -->
+ <g style="fill: #52514e" transform="translate(18.72 35.568) scale(0.13 -0.13)">
+ <defs>
+ <path id="Helvetica-5b" d="M 94 3347
+L 822 3347
+L 1591 2169
+L 2369 3347
+L 3053 3331
+L 1925 1716
+L 3103 0
+L 2384 0
+L 1553 1256
+L 747 0
+L 34 0
+L 1213 1716
+L 94 3347
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-54" d="M 775 1628
+Q 775 1194 897 900
+Q 1113 378 1669 378
+Q 2256 378 2478 928
+Q 2600 1231 2600 1703
+Q 2600 2138 2466 2428
+Q 2238 2925 1663 2925
+Q 1297 2925 1036 2608
+Q 775 2291 775 1628
+z
+M 1606 3422
+Q 2022 3422 2306 3213
+Q 2463 3100 2606 2881
+L 2606 3347
+L 3141 3347
+L 3141 -1334
+L 2575 -1334
+L 2575 384
+Q 2434 159 2186 26
+Q 1938 -106 1566 -106
+Q 1031 -106 609 312
+Q 188 731 188 1588
+Q 188 2391 583 2906
+Q 978 3422 1606 3422
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-11" d="M 547 681
+L 1200 681
+L 1200 0
+L 547 0
+L 547 681
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-3a" d="M 791 4591
+L 1656 856
+L 2694 4591
+L 3369 4591
+L 4406 856
+L 5272 4591
+L 5953 4591
+L 4747 0
+L 4094 0
+L 3034 3806
+L 1969 0
+L 1316 0
+L 116 4591
+L 791 4591
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-45" d="M 369 4606
+L 916 4606
+L 916 2941
+Q 1100 3181 1356 3307
+Q 1613 3434 1913 3434
+Q 2538 3434 2927 3004
+Q 3316 2575 3316 1738
+Q 3316 944 2931 419
+Q 2547 -106 1866 -106
+Q 1484 -106 1222 78
+Q 1066 188 888 428
+L 888 0
+L 369 0
+L 369 4606
+z
+M 1831 391
+Q 2288 391 2514 753
+Q 2741 1116 2741 1709
+Q 2741 2238 2514 2584
+Q 2288 2931 1847 2931
+Q 1463 2931 1173 2647
+Q 884 2363 884 1709
+Q 884 1238 1003 944
+Q 1225 391 1831 391
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-1e" d="M 709 -653
+Q 928 -613 1013 -363
+Q 1056 -231 1056 -75
+Q 1056 -59 1054 -48
+Q 1053 -38 1050 0
+L 709 0
+L 709 681
+L 1375 681
+L 1375 50
+Q 1375 -284 1278 -509
+Q 1116 -878 709 -950
+L 709 -653
+z
+M 709 3303
+L 1375 3303
+L 1375 2622
+L 709 2622
+L 709 3303
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-c0" d="M 553 3856
+Q 566 4206 675 4369
+Q 872 4656 1434 4656
+Q 1488 4656 1544 4653
+Q 1600 4650 1672 4644
+L 1672 4131
+Q 1584 4138 1545 4139
+Q 1506 4141 1472 4141
+Q 1216 4141 1166 4008
+Q 1116 3875 1116 3331
+L 1672 3331
+L 1672 2888
+L 1109 2888
+L 1109 0
+L 553 0
+L 553 2888
+L 88 2888
+L 88 3331
+L 553 3331
+L 553 3856
+z
+M 2213 3953
+L 2213 4591
+L 2775 4591
+L 2775 3953
+L 2213 3953
+z
+M 2213 3331
+L 2775 3331
+L 2775 0
+L 2213 0
+L 2213 3331
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-36"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(66.703125 0)"/>
+ <use xlink:href="#Helvetica-5b" transform="translate(88.921875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(138.921875 0)"/>
+ <use xlink:href="#Helvetica-54" transform="translate(166.703125 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(222.3125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(277.921875 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(333.53125 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(366.828125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(416.828125 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(444.609375 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(516.828125 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(539.046875 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(594.65625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(650.265625 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(705.875 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(778.09375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(828.09375 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(855.875 0)"/>
+ <use xlink:href="#Helvetica-59" transform="translate(911.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(961.484375 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(1017.09375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1050.390625 0)"/>
+ <use xlink:href="#Helvetica-16" transform="translate(1078.171875 0)"/>
+ <use xlink:href="#Helvetica-11" transform="translate(1133.78125 0)"/>
+ <use xlink:href="#Helvetica-1b" transform="translate(1161.5625 0)"/>
+ <use xlink:href="#Helvetica-15" transform="translate(1217.171875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1272.78125 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(1300.5625 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(1383.859375 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(1406.078125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(1428.296875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(1450.515625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(1472.734375 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(1528.34375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1583.953125 0)"/>
+ <use xlink:href="#Helvetica-3a" transform="translate(1611.734375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(1702.46875 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(1758.078125 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(1808.078125 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(1863.6875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(1885.90625 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(1941.515625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(1997.125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(2024.90625 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(2080.515625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(2136.125 0)"/>
+ <use xlink:href="#Helvetica-45" transform="translate(2163.90625 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(2219.515625 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(2275.125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(2297.34375 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(2319.5625 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(2375.171875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(2397.390625 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(2453 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(2508.609375 0)"/>
+ <use xlink:href="#Helvetica-1e" transform="translate(2558.609375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(2586.390625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(2614.171875 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(2641.953125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(2697.5625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(2753.171875 0)"/>
+ <use xlink:href="#Helvetica-c0" transform="translate(2780.953125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(2830.953125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(2853.171875 0)"/>
+ <use xlink:href="#Helvetica-f" transform="translate(2908.78125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(2936.5625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(2964.34375 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(2992.125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(3047.734375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(3103.34375 0)"/>
+ <use xlink:href="#Helvetica-49" transform="translate(3131.125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(3158.90625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(3214.515625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(3270.125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(3297.90625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(3353.515625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(3386.8125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(3414.59375 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(3470.203125 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(3525.8125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(3581.421875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(3609.203125 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(3636.984375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(3692.59375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(3748.203125 0)"/>
+ <use xlink:href="#Helvetica-54" transform="translate(3775.984375 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(3831.59375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(3887.203125 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(3942.8125 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(3976.109375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(4026.109375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(4053.890625 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(4109.5 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(4142.796875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(4198.40625 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(4226.1875 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(4248.40625 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(4304.015625 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(4359.625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(4415.234375 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(4443.015625 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(4465.234375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(4515.234375 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(4570.84375 0)"/>
+ <use xlink:href="#Helvetica-f" transform="translate(4593.0625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(4620.84375 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(4648.625 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(4704.234375 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(4759.84375 0)"/>
+ <use xlink:href="#Helvetica-5c" transform="translate(4782.0625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(4832.0625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(4859.84375 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(4887.625 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(4943.234375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(4998.84375 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(5026.625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(5059.921875 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(5115.53125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(5187.75 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(5215.53125 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(5271.140625 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(5304.4375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(5360.046875 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(5415.65625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(5448.953125 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(5476.734375 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(5526.734375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(5582.34375 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(5637.953125 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(5693.5625 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(5749.171875 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(5804.78125 0)"/>
+ </g>
+ </g>
+ <g id="legend_1">
+ <g id="patch_47">
+ <path d="M 142.227109 367.31175
+L 168.227109 367.31175
+L 168.227109 358.21175
+L 142.227109 358.21175
+z
+" style="fill: #2a78d6"/>
+ </g>
+ <g id="text_60">
+ <!-- bounding-box statistics (GeoParquet covering) -->
+ <g transform="translate(178.627109 367.31175) scale(0.13 -0.13)">
+ <defs>
+ <path id="Helvetica-10" d="M 266 2072
+L 1834 2072
+L 1834 1494
+L 266 1494
+L 266 2072
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-b" d="M 1894 4666
+Q 1403 3713 1256 3263
+Q 1034 2578 1034 1681
+Q 1034 775 1288 25
+Q 1444 -438 1903 -1306
+L 1525 -1306
+Q 1069 -594 959 -397
+Q 850 -200 722 138
+Q 547 600 478 1125
+Q 444 1397 444 1644
+Q 444 2569 734 3291
+Q 919 3750 1503 4666
+L 1894 4666
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-2a" d="M 2472 4709
+Q 3119 4709 3591 4459
+Q 4275 4100 4428 3200
+L 3813 3200
+Q 3700 3703 3347 3933
+Q 2994 4163 2456 4163
+Q 1819 4163 1383 3684
+Q 947 3206 947 2259
+Q 947 1441 1306 927
+Q 1666 413 2478 413
+Q 3100 413 3508 773
+Q 3916 1134 3925 1941
+L 2488 1941
+L 2488 2456
+L 4503 2456
+L 4503 0
+L 4103 0
+L 3953 591
+Q 3638 244 3394 109
+Q 2984 -122 2353 -122
+Q 1538 -122 950 406
+Q 309 1069 309 2225
+Q 309 3378 934 4059
+Q 1528 4709 2472 4709
+z
+M 2369 4716
+L 2369 4716
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-33" d="M 547 4591
+L 2613 4591
+Q 3225 4591 3600 4245
+Q 3975 3900 3975 3275
+Q 3975 2738 3640 2339
+Q 3306 1941 2613 1941
+L 1169 1941
+L 1169 0
+L 547 0
+L 547 4591
+z
+M 3347 3272
+Q 3347 3778 2972 3959
+Q 2766 4056 2406 4056
+L 1169 4056
+L 1169 2466
+L 2406 2466
+Q 2825 2466 3086 2644
+Q 3347 2822 3347 3272
+z
+" transform="scale(0.015625)"/>
+ <path id="Helvetica-c" d="M 222 -1306
+Q 719 -338 863 106
+Q 1081 778 1081 1681
+Q 1081 2584 828 3334
+Q 672 3797 213 4666
+L 591 4666
+Q 1072 3897 1173 3717
+Q 1275 3538 1394 3222
+Q 1544 2831 1608 2450
+Q 1672 2069 1672 1716
+Q 1672 791 1378 66
+Q 1194 -400 613 -1306
+L 222 -1306
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-45"/>
+ <use xlink:href="#Helvetica-52" transform="translate(55.609375 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(111.21875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(166.828125 0)"/>
+ <use xlink:href="#Helvetica-47" transform="translate(222.4375 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(278.046875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(300.265625 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(355.875 0)"/>
+ <use xlink:href="#Helvetica-10" transform="translate(411.484375 0)"/>
+ <use xlink:href="#Helvetica-45" transform="translate(444.78125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(500.390625 0)"/>
+ <use xlink:href="#Helvetica-5b" transform="translate(556 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(606 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(633.78125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(683.78125 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(711.5625 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(767.171875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(794.953125 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(817.171875 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(867.171875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(894.953125 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(917.171875 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(967.171875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1017.171875 0)"/>
+ <use xlink:href="#Helvetica-b" transform="translate(1044.953125 0)"/>
+ <use xlink:href="#Helvetica-2a" transform="translate(1078.25 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(1156.03125 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(1211.640625 0)"/>
+ <use xlink:href="#Helvetica-33" transform="translate(1267.25 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(1333.953125 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(1389.5625 0)"/>
+ <use xlink:href="#Helvetica-54" transform="translate(1422.859375 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(1478.46875 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(1534.078125 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(1589.6875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1617.46875 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(1645.25 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(1695.25 0)"/>
+ <use xlink:href="#Helvetica-59" transform="translate(1750.859375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(1800.859375 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(1856.46875 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(1889.765625 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(1911.984375 0)"/>
+ <use xlink:href="#Helvetica-4a" transform="translate(1967.59375 0)"/>
+ <use xlink:href="#Helvetica-c" transform="translate(2023.203125 0)"/>
+ </g>
+ </g>
+ <g id="patch_48">
+ <path d="M 471.972109 367.31175
+L 497.972109 367.31175
+L 497.972109 358.21175
+L 471.972109 358.21175
+z
+" style="fill: #eb6834"/>
+ </g>
+ <g id="text_61">
+ <!-- plus an S2 cell column with a Parquet Bloom filter -->
+ <g transform="translate(508.372109 367.31175) scale(0.13 -0.13)">
+ <defs>
+ <path id="Helvetica-25" d="M 2213 2650
+Q 2606 2650 2825 2759
+Q 3169 2931 3169 3378
+Q 3169 3828 2803 3984
+Q 2597 4072 2191 4072
+L 1081 4072
+L 1081 2650
+L 2213 2650
+z
+M 2422 531
+Q 2994 531 3238 863
+Q 3391 1072 3391 1369
+Q 3391 1869 2944 2050
+Q 2706 2147 2316 2147
+L 1081 2147
+L 1081 531
+L 2422 531
+z
+M 472 4591
+L 2444 4591
+Q 3250 4591 3591 4109
+Q 3791 3825 3791 3453
+Q 3791 3019 3544 2741
+Q 3416 2594 3175 2472
+Q 3528 2338 3703 2169
+Q 4013 1869 4013 1341
+Q 4013 897 3734 538
+Q 3319 0 2413 0
+L 472 0
+L 472 4591
+z
+" transform="scale(0.015625)"/>
+ </defs>
+ <use xlink:href="#Helvetica-53"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(55.609375 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(77.828125 0)"/>
+ <use xlink:href="#Helvetica-56" transform="translate(133.4375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(183.4375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(211.21875 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(266.828125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(322.4375 0)"/>
+ <use xlink:href="#Helvetica-36" transform="translate(350.21875 0)"/>
+ <use xlink:href="#Helvetica-15" transform="translate(416.921875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(472.53125 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(500.3125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(550.3125 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(605.921875 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(628.140625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(650.359375 0)"/>
+ <use xlink:href="#Helvetica-46" transform="translate(678.140625 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(728.140625 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(783.75 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(805.96875 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(861.578125 0)"/>
+ <use xlink:href="#Helvetica-51" transform="translate(944.875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1000.484375 0)"/>
+ <use xlink:href="#Helvetica-5a" transform="translate(1028.265625 0)"/>
+ <use xlink:href="#Helvetica-4c" transform="translate(1100.484375 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(1122.703125 0)"/>
+ <use xlink:href="#Helvetica-4b" transform="translate(1150.484375 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1206.09375 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(1233.875 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1289.484375 0)"/>
+ <use xlink:href="#Helvetica-33" transform="translate(1317.265625 0)"/>
+ <use xlink:href="#Helvetica-44" transform="translate(1383.96875 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(1439.578125 0)"/>
+ <use xlink:href="#Helvetica-54" transform="translate(1472.875 0)"/>
+ <use xlink:href="#Helvetica-58" transform="translate(1528.484375 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(1584.09375 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(1639.703125 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1667.484375 0)"/>
+ <use xlink:href="#Helvetica-25" transform="translate(1695.265625 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(1761.96875 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(1784.1875 0)"/>
+ <use xlink:href="#Helvetica-52" transform="translate(1839.796875 0)"/>
+ <use xlink:href="#Helvetica-50" transform="translate(1895.40625 0)"/>
+ <use xlink:href="#Helvetica-3" transform="translate(1978.703125 0)"/>
+ <use xlink:href="#Helvetica-c0" transform="translate(2006.484375 0)"/>
+ <use xlink:href="#Helvetica-4f" transform="translate(2056.484375 0)"/>
+ <use xlink:href="#Helvetica-57" transform="translate(2078.703125 0)"/>
+ <use xlink:href="#Helvetica-48" transform="translate(2106.484375 0)"/>
+ <use xlink:href="#Helvetica-55" transform="translate(2162.09375 0)"/>
+ </g>
+ </g>
+ </g>
+ </g>
+ <defs>
+ <clipPath id="p3ff16522ac">
+ <rect x="47.765" y="118.086" width="275.606901" height="168.187676"/>
+ </clipPath>
+ <clipPath id="p5725f90031">
+ <rect x="348.67905" y="118.086" width="275.606901" height="168.187676"/>
+ </clipPath>
+ <clipPath id="p5aa6b8dcee">
+ <rect x="649.593099" y="118.086" width="275.606901" height="168.187676"/>
+ </clipPath>
+ </defs>
+</svg>
diff --git a/docs/blog/posts/orderby-index.md b/docs/blog/posts/orderby-index.md
new file mode 100644
index 00000000000..a126c6a39f6
--- /dev/null
+++ b/docs/blog/posts/orderby-index.md
@@ -0,0 +1,115 @@
+---
+date:
+ created: 2026-09-18
+links:
+ - "Hippo (PVLDB 2016)": https://jiayuasu.github.io/files/paper/hippo_vldb2016_fullpaper.pdf
+ - GeoParquet in Sedona: https://sedona.apache.org/latest/tutorial/files/geoparquet-sedona-spark/
+ - SedonaDB to_parquet: https://sedona.apache.org/sedonadb/latest/reference/python/
+authors:
+ - jia
+title: "ORDER BY Is an Index. Does It Have to Be?"
+slug: order-by-is-an-index-does-it-have-to-be
+---
+
+# ORDER BY Is an Index. Does It Have to Be?
+
+*SedonaDB, GeoParquet, and a story that started at VLDB 2016, now in Rust.*
+
+Parquet has stored a minimum and a maximum for every column in every row group [since September 2013](https://github.com/apache/parquet-format/commit/2c4ada8e988c1c0018332e420764c09bab16bf9c). PostgreSQL 9.5 [added BRIN in January 2016](https://www.postgresql.org/docs/release/9.5.0/): one small summary per range of blocks, cheap to update, useful when the data is clustered. In the same year the original creators of Apache Sedona, Jia Yu and Mohamed Sarwat, published [Hippo](https://jiayu [...]
+
+Ten years later, data skipping is how every lakehouse engine reads a file, and the question from 2016 is still open. Below: 3.82 million Washington buildings in one GeoParquet file, written three ways. Sorted by geometry, sorted by another column, and shuffled.
+
+
+
+<!-- more -->
+
+## Skipping is the index now
+
+Parquet row-group statistics, Iceberg and Delta file statistics, DuckDB zone maps and Snowflake micro-partitions all come from the same idea: summarize a block, then skip the block when the summary says the answer cannot be inside. For geometry the summary is a bounding box, stored in GeoParquet's `covering` columns. SedonaDB reports what it skipped in `EXPLAIN ANALYZE`:
+
+```
+row_groups_spatial_pruned=770 total → 40 matched, row_groups_pruned_statistics=4 total → 4 matched,
+bytes_scanned=20.12 M
+```
+
+A query over downtown Seattle reads 4 of the 77 row groups, 20 MB of 555. The limit is the same as BRIN's: a summary is only as good as the rows in its block, and no file format groups the rows for you.
+
+## Same buildings, three layouts
+
+The rows are the 3.82 million Overture buildings in Washington State. Each carries a place name: the city when the building sits inside one, which is the case for 53% of them, and the county for the rest. SedonaDB's writer takes a sort key, so the three files differ in one argument: the geometry, another column, or a random number.
+
+??? example "Three writes"
+
+ ```python
+ # pip install "apache-sedona[db]"
+ import sedona.db
+
+ sd = sedona.db.connect()
+ sd.read_parquet("buildings_wa.parquet").to_view("raw")
+ sd.sql("""
+ SELECT id, place, geometry,
+ S2_CellIdFromPoint(ST_ToGeography(ST_Centroid(geometry))) AS s2,
+ S2_CoveringCellIds(ST_ToGeography(ST_Centroid(geometry)), 12, 12, 1)[1] AS cell,
+ random() AS rnd
+ FROM raw
+ """).to_memtable().to_view("b")
+
+ for name, key in {"geo": "s2", "name": "place", "random": "rnd"}.items():
+ sd.sql("SELECT * FROM b").to_parquet(
+ f"layout_{name}.parquet",
+ sort_by=[key],
+ single_file_output=True,
+ max_row_group_size=50_000,
+ geoparquet_version="1.1",
+ options={"bloom_filter_enabled::cell": True, "bloom_filter_ndv::cell": 10000},
+ )
+ ```
+
+`s2` is ORDER BY geometry. Rows follow a space-filling curve, the same idea as the geohash sort in the [GeoParquet tutorial](https://sedona.apache.org/latest/tutorial/files/geoparquet-sedona-spark/). `place` is ORDER BY another column, here the place name from above. This is how most data arrives: sorted by whatever key the producer used, an ID, a name or a timestamp. The rows are still grouped in space, because a city or a county is one compact area, but the groups are in no spatial ord [...]
+
+## One query, three answers
+
+Six query windows: 1 by 1.5 km over downtown Seattle, Tacoma, Spokane, Olympia and Leavenworth, plus a 5 by 8 km window over Seattle. Each runs as `ST_Intersects` against each file:
+
+
+
+The Seattle query reads 4 row groups in the geometry order (20 MB, 40 ms), 54 in the name order (253 MB, 105 ms), and 77 in the shuffle (373 MB). All three files carry the same statistics. The row order is the index. The file sorted by name, the realistic one, reads almost everything.
+
+## Can we skip without sorting?
+
+Z-order and liquid clustering are sorts under another name, and they cost a full rewrite. [Bloom filters](https://github.com/apache/parquet-format/blob/master/BloomFilter.md), in Parquet since format 2.9 and a column property in Iceberg and Delta, answer `=` and `IN` only. A range predicate passes straight through them, and every spatial query is a range predicate.
+
+Hippo summarized a range of pages with a bitmap: one bit per bucket of the table's histogram, set when the range holds a value from that bucket. Three clusters far apart set three bits instead of one span the size of the state. That is why Hippo can skip data that is grouped but not sorted, like the file sorted by name.
+
+That bitmap can be built from parts every format already has. Store the S2 cell of each geometry as an integer column, put a Bloom filter on it, and turn the range query into an `IN` list:
+
+```python
+cells = sd.sql(f"""
+ SELECT S2_CoveringCellIds(ST_ToGeography(ST_GeomFromWKT('{window}', 4326)), 12, 12, 100000) AS c
+""").to_pandas().c[0]
+
+sd.sql(f"""
+ SELECT COUNT(*) FROM t
+ WHERE cell IN ({", ".join(str(c) for c in cells)})
+ AND ST_Intersects(geometry, ST_GeomFromWKT('{window}', 4326))
+""")
+```
+
+The row stores the cell of the centroid, so a shape that crosses a cell boundary can be missed at the edge of a query; the limits below return to this. The orange bars are this query. In the file sorted by name, Seattle drops from 54 row groups to 8, from 253 MB to 43 MB, and from 105 ms to 62 ms. Leavenworth drops from 41 to 3, Olympia from 32 to 3, Spokane from 24 to 3, Tacoma from 52 to 10, and the 5 by 8 km window from 54 to 8. The file was never sorted by geometry, and the filter on [...]
+
+## What we left open
+
+The cell column is a shortcut, and it has four limits.
+
+- **Skew.** The cells are a grid of equal-sized squares, S2 level 12, about 5 km² each. The 21,493 cells with a Washington building hold between 1 and 13,267 of them, median 15. Hippo's histogram used buckets of equal count, so every bucket held the same number of rows.
+- **Shape boundaries.** Each row stores one cell, the cell of its centroid. A shape that crosses a cell boundary can slip past the filter at the edge of a query: the 55 km window below returns 929,211 buildings without the filter and 929,208 with it. A lake or a coastline spans hundreds of cells, and one cell per row cannot describe it at all.
+- **Wide queries.** A query much wider than a cell becomes a long `IN` list, and the gain shrinks. On the file sorted by name, a 30 by 30 km window over Seattle lists 223 cells and reads 32 row groups instead of 56. A 55 by 55 km window lists 684 cells and reads 47 instead of 62, in the same time: 113 ms against 112.
+- **Tuning.** The level is a guess. Level 12 fits these buildings and these windows. Other data and other queries need another level, and finding it takes trial runs.
+
+Hippo's design, moved to two dimensions, handles all four with one structure: a histogram with equal-count buckets follows the skew, a bitmap can carry every bucket a large object touches, a wide query tests more bits of the same bitmap at the same cost, and the bucket count is the only setting. So the next step is to adapt Hippo itself to Parquet. Where does the summary live: in the footer, in an Iceberg Puffin file, or in a separate sidecar file? How does it survive appends? Hippo solv [...]
+
+## The point
+
+Sort by geometry when you can: one `sort_by`, and the statistics already in the file read 4 row groups instead of 77. When the data arrives sorted by something else, the usual case, a cell column and a Bloom filter recover most of the difference without a rewrite, for small objects and small queries. Skew, shape boundaries, wide queries and the level itself are the question from 2016, still open, and the file format has room for the answer in its footer.
+
+*Buildings, cities and counties from Overture Maps. Measurements on SedonaDB 0.4.1.*