Viewing profile — ajfriend

Yes! A Gosper Island in H3 is just the outline of all the descendants of a cell at a some resolution. The H3 cells at that resolution tile the sphere, and the Gosper Islands are ju…

I appreciate the reply! So, I might be wrong here, but I think we may be talking about two different layers. I’m also not very familiar with the literature, so I’d be interested if…

Very cool! And the prefix queries you mention are what I was trying to get at in another comment, but you explained it better :)

I agree that the lack of congruency in H3 hexagons can cause weird overlaps and gaps if you plot mixed resolutions naively, but there are some workarounds that work pretty well in …

h3o-zip is really impressive! I've been wanting to play around with it more, and I've been meaning to ask you if you have any good references for that encoding approach. I understa…

I have project that's still very much at the experimental stage, where I try to get something similar to this pipe syntax by allowing users to chain "SQL snippets" together. That i…

I don't. And maybe I should have emphasized "and have a data source" more, since its doing a lot of the heavy-lifting in my statement :)

You can use those if they work for your application. One downside would be that you're storing 4 numbers compared to a single `int64` index with H3. You also have to decide how you…

They also only have one type of neighbor. Square grids have 2 neighbor types. Triangular grids have 3.

If you care about that and have a data source, you can add, for example, population density per H3 cell as part of your analysis. That has the additional benefit of denoting the th…

It depends on if you want to model a point or an area. lat/lng gives you a point , but you often want an area to, for example, count how many people are in that area. A spatial ind…

...and use H3 instead! https://h3geo.org/

That map does seem to be using H3 hexagons: https://h3geo.org/

Oh man, what an exciting opportunity. clears throat The hacker news title seems to mistranslate the original Em dash to an En dash.

We use a submodule in https://github.com/uber/h3-py to wrap the core H3 library, which is written in C. Submodules seemed like a reasonable way to handle the dependency, and, at le…

You can compose SQL with https://ibis-project.org/tutorials/ibis-for-sql-users , which is using https://github.com/tobymao/sqlglot to parse the SQL under the hood. As an alternativ…

One approach I've been enjoying recently in my personal use is to write a light wrapper around DuckDB to enable composable SQL snippets. Essentially like what I have here https://g…

This DuckDB blog post on range joins might be relevant: https://duckdb.org/2022/05/27/iejoin.html

If you're asking someone for help, it would be nice if you asked in a way that's most convenient for them.

Excellent textbook examples in there :)

I think that says more about programming today than it does Knuth.

What are some good alternatives to SQL?

I typically only rely on the logical parent/child relationship between cells, and containment there is strict even if geometric containment is only approximate. The logical relatio…

Can you recommend any good books or other resources?