mattforrest

3 ms·

1.
by mattforrest 8mo ago
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 matters I would just use a better engine with GeoParquet to
2.
Price-performance benchmarks for spatial SQL (Databricks Serverless vs. Sedona)(sedona.apache.org)
3 points by mattforrest 9mo ago|1 comments
3.
by mattforrest 9mo ago
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 used it to compare Databricks SQL Serverless (Medium) vs D
4.
by mattforrest 1y ago
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, but again you are limited by the fact that your tables have
5.
Apache Sedona tutorial for Spark based spatial processing [video](youtube.com)
2 points by mattforrest 1y ago|1 comments
6.
by mattforrest 1y ago
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 basically makes spatial at scale way more accessible. Instead of
7.
by mattforrest 2y ago
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.
8.
by mattforrest 2y ago
Just use a spatial query. That’s what they are made for.
9.
by mattforrest 2y ago
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
10.
by mattforrest 2y ago
Well put
11.
by mattforrest 2y ago
Yeah but Zip+4 represent a collection of houses not a polygon so not useful for aggregations or statistical work
12.
by mattforrest 2y ago
Not necessarily true. The population isn't balanced at all between many. Census units are.
13.
by mattforrest 2y ago
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 are correct that no one knows their census unit is (if yo
14.
by mattforrest 2y ago
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