Spatial Interaction (adjacency)

We recently looked at spatial interaction in the form of inverse distance weighting.  However, some spatial interaction matrices are binary in nature (0,1), with 0 meaning the two geographic objects are not neighbors, and 1 meaning they are.  A neighbor in this case could be an adjacent are (i.e. New York and Pennsylvania are neighbors, while New York and Virginia are not) or within a specified distance (i.e. with a specified distance of 100 miles, Rochester and Syracuse are neighbors, but Syracuse and Boston are not).

In our example, we have 6 New England States:


The SQL for creating the binary adjacency matrix is:

SELECT [States].name
FROM [States], [States] AS [States2]
WHERE Adjacent(states.[Geom (I)],states2.[Geom (i)])
GROUP BY [States].[Name]
PIVOT [States2].[Name]

The only differences is that instead of computing the Min(Distance…), we are just obtaining the aggregate COUNT of the adjacent States by using the WHERE clause for spatial adjacency.  This makes sense because Vermont for example is adjacent to New Hampshire and Massachusetts.   But, the count of the number of times Vermot is adjacent to New Hampshire is just once – the same holds true for the other states.

The result is an adjacenty table like the following:


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s