Viewing profile — mattforrest

I wrote a post about using H3 or any DGGS for that matter. Yes it speeds things up but you loose accuracy. If search is the primary concern it can help but if any level of accuracy…

SpatialBench is an open benchmark suite for spatial SQL. The goal is to compare engines on price-performance, since serverless makes raw “x times faster” claims hard to interpret. …

I wrote a book on PostGIS and used it for years and these single node analytical tools make sense when PostGIS performance starts to break down. For many tasks PostGIS works great,…

I put together a tutorial for Apache Sedona which brings geospatial to Spark. A project that crunches real estate and satellite imagery data with scalable spatial joins Sedona basi…

They aren’t reliable correct actually. The boundaries that the Census publishes are called Zip Code Tabulation Areas which are approximations of zip codes and include overlaps.

Just use a spatial query. That’s what they are made for.

Yeah but we have that already in the census hierarchy. Plus you have to pay to access Zip+4 geospatial data and it changes sometime as frequently as quarterly

Well put

Yeah but Zip+4 represent a collection of houses not a polygon so not useful for aggregations or statistical work

Not necessarily true. The population isn't balanced at all between many. Census units are.

Well you hit on all the points that discuss the compromises that zip codes offer. Just because you have them in your data doesn't mean that they can produce anything useful. You ar…

Funny to see this one pop up today (I wrote this one way back when) but I just refreshed it into a video on my channel: https://www.youtube.com/watch?v=x-opv4REEic