<html xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 15 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Aptos;
panose-1:2 11 0 4 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
font-size:11.0pt;
font-family:"Calibri",sans-serif;
mso-ligatures:standardcontextual;}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:#0563C1;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri",sans-serif;
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:11.0pt;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style></head><body lang=EN-US link="#0563C1" vlink="#954F72" style='word-wrap:break-word'><div class=WordSection1><p class=MsoNormal><span style='color:black;mso-ligatures:none'>With some recent commits to GDAL master branch, you can now do some amazing DuckDB queries in GDAL!<o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>For example, h3 level 6 indexing for POIs in NH from Overture Maps<o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>ogr2ogr -f parquet POI_NH_H3.parquet -nlt POINT -a_srs epsg:4326 -oo ADBC_DRIVER=libduckdb -oo PRELUDE_STATEMENTS="LOAD SPATIAL" -oo PRELUDE_STATEMENTS="load parquet" -oo PRELUDE_STATEMENTS="load httpfs" -oo PRELUDE_STATEMENTS="load aws" -oo PRELUDE_STATEMENTS="install h3 from community" -oo PRELUDE_STATEMENTS="load h3" -oo SQL="select h3_id, ST_GeomFromText(h3_cell_to_boundary_wkt(h3_id)) geometry, count(*) POI_count from (select id, h3_latlng_to_cell_string(st_y(geometry), st_x(geometry), 6) as h3_id from read_parquet('s3://overturemaps-us-west-2/release/2024-12-18.0/theme=places/type=place/*') where addresses[1].region = 'NH' and addresses[1].country='US' and bbox.xmin between -73 and -70 and bbox.ymin between 42 and 46) group by h3_id" ADBC:<o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>15.60s user 2.36s system <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>48% cpu <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>36.935 total<o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'> <o:p></o:p></span></p><p class=MsoNormal><span style='color:black;mso-ligatures:none'>This is using gdal-master from conda on my mac arm64.<o:p></o:p></span></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://imgur.com/a/zGp5Mwg">https://imgur.com/a/zGp5Mwg</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><a href="https://imgur.com/a/1H5JwwZ">https://imgur.com/a/1H5JwwZ</a><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal><span style='mso-ligatures:none'>-- <o:p></o:p></span></p></div><div><p class=MsoNormal><span style='mso-ligatures:none'>Michael Smith<o:p></o:p></span></p><p class=MsoNormal><span style='mso-ligatures:none'>Remote Sensing/GIS Center<o:p></o:p></span></p></div></div><p class=MsoNormal><span style='mso-ligatures:none'>US Army Corps of Engineers</span><o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>