Rather than starting with the easiest or hardest function, I thought I'd start somewhere in the middle - for GIS experts I don't want to bore you, and for novices, I don't want to blow you away with something more complex. But, after this post, we'll work through some easy queries and move on to more advanced queries. For those of you who used ARC/INFO, you probably found that the NEAR function was one of your best friends.  I used it every week to transfer attributes from

I wanted to give you another look at some features that Radian Studio will offer. I’ve shown how we can use SQL to replicate the ARC/INFO...

In previous posts, I showed how to create ARC/INFO functions in SQL using Manifold 8.  While I love SQL, it is somewhat frustrating to...

Dale posted a request to see Line Density recreated in SQL.  Please take a look at the ESRI help topic for line density. I will warn you,...

I was recently asked by danb to illustrate the ARC/INFO function symmetrical difference. We basically want to find those areas in layer A...

We are going to conclude our overlay posts with the ARC/INFO UNION command.  This should be a lot easier than it actually is.  I think...

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...

I love the Tabulate Area command in ArcGIS.  The ability to create a cross tabulation of two feature datasets is very cool.  SQL has...

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...