The ARC/INFO IDENTITY operation seen here is sometimes confusing because it takes ALL of the Input feature, and the part of the IDENTITY...

I promised you that I would address the attributes.  Remember, our previous query only performed the ClipSubract for the geometries, and...

Today we are beginning another four-part session on the classical ESRI topological overlay functions of Erase, Intersect, Identity, and...

We’ve spent some time looking at how to create spatial interaction models using PIVOT tables and spatial constructs in SQL.  The one last...

In my book Introduction to Statistical Problem Solving in Geography, we talk about relationships among geographic objects. These...

Every geographer knows Tobler’s Law.  Near things are more similar to things that are far away.  From this, we often begin our...

I wrote a paper in 2006 about using SQL for the Modifiable Area Unit Problem (MAUP).  The example was an agricultural experiment field,...

Lets take another break from my textbook, and focus on a classic GIS operation.  If you are like me, you learned GIS with ARC/INFO.  I...

In case you are getting tired of reading examples from my book (did I mention that I have a textbook you can buy from Amazon?), I thought...

This post is part of a series entitled Spatial is not Special, where I will illustrate how spatial constructs in SQL provide us with a...

This post is part of a series entitled Spatial is not Special, where I will illustrate how spatial constructs in SQL provide us with a...

This post is part of a series entitled Spatial is not Special, where I will illustrate how spatial constructs in SQL provide us with a...

This post is part of a series entitled Spatial is not Special, where I will illustrate how spatial constructs in SQL provide us with a...

I have spent the last few years advocating the benefits of SQL, and in particular spatial constructs in SQL for solving geographic...