QGIS Polygon layer table of adjacent polygons

Question

In a polygon layer, how can I generate a table of adjacent polygons?

Answer 1

What I would do is drop the polygon layer into Spatialite, then run a query like:

SELECT p1.PK_UID, p1.Name FROM Polys p1, Polys p2 
WHERE p2.PK_UID=1 AND 
ST_Touches(p1.Geometry, p2.Geometry)=1;

I'm assuming a primary key column named 'pk_uid', and a label column called 'Name'. The above will return all polygons adjacent to (touching) the polygon with ID=1.

Is that what you had in mind?