AnsweredAssumed Answered

ArcGIS Spatial SQL Query to find features within a certain distance from other table

Question asked by kundalay1 on Apr 24, 2017
Latest reply on Jun 6, 2017 by kundalay1

I am trying to work on a SQL spatial query to duplicate what you can do on Arcmap. I am basically trying to select features from one SQL table which contains parcels data(polygons), which is within 200 feet of another layer which contains streams(lines). I am using pure SQL and not ArcSDE.. I have tried to find solutions online but have not been able to find anything that works so far.

 

basically need features selected from parcel layer(polygons) that are within 200 feet of streams(lines) 

 

I would greatly appreciate any help.

 

I am using SQL Server 2008 and spatial columns on both tables are geometry data type.

Outcomes