SQL-whether or inferred lines intersect to a plane within its interior

SQL as below:

Update Mapping_nj_roads
Set municipality= ' 227 '
From Mapping_geodata_boundary A
where a.supportfile_code= ' 227 ' and
(A.boundary.stcontains (Mapping_nj_roads.geom) =1 or a.boundary.stintersects (MAPPING_NJ_ROADS.GEOM) =1)

#1 Mapping_nj_roads is a table of all the roads of New Jersey, Geom is the Geometry field of the road

#2 mapping_geodata_boundary is the boundary table for all of New Jersey, boundary is the Geometry field

#3 227 is a township of Bergen County.

#4 methods used: Stcontains "include", "Stintersects" intersect "

Copyright notice: This article blog original article. Blogs, without consent, may not be reproduced.

SQL-whether or inferred lines intersect to a plane within its interior