How to use STIntersect in SQL SERVER

Question

I want to to perform a STInteract using two tables and finding the intersections of the lines onto a given polygon. I have converted all the tables to have geometries for all. I am having a problem writing the query for this.

These are my two table

HWY_Database = contains the lines
POLY_Database = Polygon of interest

This is my script:

--visually checking if they intersect
SELECT GEOM FROM [dbo].[HWY_Database] where STFIPS = '04'
UNION ALL 
SELECT NEATCELL FROM [dbo].[POLY_Database]

So I dont know how to write this so this what I Initially wrote:

--intersect Neatcell and GEOM
SELECT GEOM FROM [dbo].[HWY_Database] where STFIPS = '04'
Where GEOM.STIntersects(NEATCELL FROM [dbo].[POLY_Database])

Ben Thul · Accepted Answer · 2015-11-03 01:13:35Z

1

SELECT GEOM 
FROM [dbo].[HWY_Database] as hwy
join [dbo].[POLY_Database] as p
    on hwy.GEOM.STIntersects(p.NEATCELL) = 1
where STFIPS = '04'

answered Nov 3, 2015 at 1:13

Ben Thul

32.9k4 gold badges52 silver badges74 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to use STIntersect in SQL SERVER

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related