Hi, I try to Intersect 3d polygon and Lines on SQL Server. But it's not working. Please support me on this issue. How to correct dynamically calculate intersection of 3D Line and Polygon?
I wrote following SQL Query.
SELECT
P.*,
L.Shape.STIntersection(P.Shape).ToString() AS IntersectionPoint,
L.Shape.STIntersection(P.Shape).STLength() AS IntersectionLength
FROM
(
SELECT
geometry::UnionAggregate(Shape) AS Shape
FROM
Geol_LicenseBoundary3DA
WHERE
Layer LIKE 'LB_XXX%' AND last_edited_date IS NULL
) AS P
JOIN
(
SELECT
geometry::UnionAggregate(Shape) AS Shape
FROM
Geol_DH_ActualTraceL
WHERE
HOLEID = 'UGDXXX'
) AS L
ON
P.Shape.STIntersects(L.Shape) = 1;
Thanks
Thanks for bringing your question to Esri Community, @BattulgaGantulga.
Which ArcGIS product are you using? I'd like to help get this post moved to a more relevant Board where it's more likely to be seen and responded to by members with relevant expertise.
Hi Jesse Cloutier,
Our Database is SDE Spatial Database on MS SQL Server. We are using ArcGIS Products (ArcGIS Enterprise, ArcGIS Pro)
Thanks
Thanks for following up, @BattulgaGantulga. I've moved your post to our ArcGIS Pro Questions Board. All the best!