AnsweredAssumed Answered

Advanced spatial queries

Question asked by agnar on Jan 21, 2014
Latest reply on Jan 21, 2014 by geonetadmin
Frankly, I'm not impressed by ArgCIS query functionality.

Suppose that I have two datasets, say one with building polygons, and one with built-up areas.

Now I want to select all buildings within residental areas.  A spatial SQL query would easilly solve my problem:
(I'm not much into spaitial SQL, but I reckon you get the idea when I suggest the following syntax)

SELECT * FROM buildings
WHERE buildings.geometry INTERSECTS (SELECT builpup_area.geometry FROM builpup_area WHERE type = 'residental');

I know how to achieve this with ArcGIS with a sequence of operations, but it is very tedious.

Is there a way I can do this more easilly in ArcGIS?