In my last post, I showed you how to create multi-ring, non-overlapping buffers with spatial SQL in PostGIS. In this post, I want to do the same thing, but with Manifold GIS. To be honest, it is pretty much the same thing, although, I think Manifold is a little easier because they utilize a FIRST aggregate function in SQL, where in PostGIS, we had to use a DISTINCT ON. Either way, it is pretty easy, so now database and SQL professionals have a way to create multi-ring buffers entirely in SQL.
If you want to learn more about SQL, programming, open source GIS, or Manifold GIS, check out courses at www.gisadvisor.com.
コメント