GeometryIntersection (Function)

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

New WINDEV, WEBDEV and WINDEV Mobile 2024 feature!

Help / WLanguage / Managing databases / HFSQL /

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

GeometryIntersection (Function)

In french: GéométrieIntersection

Returns a geometry representing the intersection of two geometries.

Input A and B geometries

Intersection result

Remarks:

If the type of the geometries passed as parameters is known, then the type of the result is also pre-determined. Most geospatial applications don't support columns with heterogeneous data (points, lines or polygons within a single item of type "Geometry"), so there's generally no need to check the type of geometry returned by the function.
To determine whether two geometries intersect, use GeometryIntersect.

Example

o2DPolygon_1 is Polygon2D
Linestring2DAddPoint(o2DPolygon_1.Outline, 2.00, 2.00)
Linestring2DAddPoint(o2DPolygon_1.Outline, 2.00, -2.00)
Linestring2DAddPoint(o2DPolygon_1.Outline, -2.00, -2.00)
Linestring2DAddPoint(o2DPolygon_1.Outline, -2.00, 2.00)
// Add last point (same as first)
Linestring2DAddPoint(o2DPolygon_1.Outline, 2.00, 2.00)
// Corrects the new geometry
o2DPolygon_1 = GeometryCorrect(o2DPolygon_1)

o2DPolygon_2 is Polygon2D
Linestring2DAddPoint(o2DPolygon_2.Outline, 3.00, 1.00)
Linestring2DAddPoint(o2DPolygon_2.Outline, 3.00, -1.00)
Linestring2DAddPoint(o2DPolygon_2.Outline, 1.00, -1.00)
Linestring2DAddPoint(o2DPolygon_2.Outline, 1.00, 1.00)
// Add last point (same as first)
Linestring2DAddPoint(o2DPolygon_2.Outline, 3.00, 1.00)
o2DPolygon_2 = GeometryCorrect(o2DPolygon_2)

// Retrieve intersection as a MultiPolygon2D object
// The intersection of two polygons is always a MultiPolygon
symmetric_difference is MultiPolygon2D = GeometryIntersection(o2DPolygon_1, o2DPolygon_2)

Syntax

<Result> = GeometryIntersection(<Geometry A> , <Geometry B>)

<Result>: Variable of type MultiPoint2D, MultiPointGeo, MultiLinestring2D, MultiLinestringGeo, MultiPolygon2D or MultiPolygonGeo

Intersection result. This geometry contains a collection of geometries of a given type:
MultiPoint2D or MultiPointGeo,
MultiLinestring2D or MultiLinestringGeo,
MultiPolygon2D or MultiPolygonGeo.
If the intersection between two geometries consists of a single element, the collection will contain a single element.
If the intersection is empty (for example, by calculating the difference between a geometry and itself), the collection is empty.
If the result of the intersection is disjoint (e.g. the intersection of two "U"-shaped polygons), the collection contains several elements.

<Geometry A>: Variable containing spatial data

First input geometry used for the intersection. This geometry can correspond to one of the following variable types:
PointGeo.
Point2D.
LinestringGeo.
Linestring2D.
PolygonGeo.
Polygon2D.
MultiPointGeo.
MultiPoint2D.
MultiLinestringGeo.
MultiLinestring2D.
MultiPolygonGeo.
MultiPolygon2D.

<Geometry B>: Variable containing spatial data

Second input geometry used for the intersection. This geometry can correspond to one of the following variable types:
PointGeo.
Point2D.
LinestringGeo.
Linestring2D.
PolygonGeo.
Polygon2D.
MultiPointGeo.
MultiPoint2D.
MultiLinestringGeo.
MultiLinestring2D.
MultiPolygonGeo.
MultiPolygon2D.

Business / UI classification: Business Logic

Component: wd290hf.dll