Spatial data functions

ONLINE HELP
WINDEV, WEBDEV AND WINDEV MOBILE

Version:

Home | Sign in | English

Help / WLanguage / Managing databases / HFSQL / Spatial data management

WINDEV

WEBDEV

WINDEV Mobile

Others

See also

Spatial data functions

The following functions are used to manipulate spatial data:


GeometryArea	Calculates the area of a given geometry.
GeometryContain	Determines if geometry A contains geometry B.
GeometryConvexHull	Calculates the convex hull of the specified geometry.
GeometryCorrect	Returns a corrected version of the specified geometry.
GeometryCover	Determines if geometry A covers geometry B.
GeometryCoveredBy	Determines if every point of geometry A lies inside or on the boundary of geometry B.
GeometryCross	Compares two geometries and determines if their intersection spatially crosses.
GeometryDeserializeWKT2D	Builds a 2D geometry from a Well-Known Text (WKT) representation.
GeometryDeserializeWKTGeo	Builds a geometry in geographic coordinates from a Well-Known Text (WKT) representation.
GeometryDifference	Returns a geometry representing the difference between two geometries.
GeometryDisjoint	Determines whether two geometries are disjoint, i.e. whether their intersection is empty.
GeometryDistance	Calculates the distance between two geometries.
GeometryEqual	Determines whether two geometries are spatially equal, i.e. whether the first geometry is included in the second, and vice versa.
GeometryIntersect	Checks whether two geometries have a non-empty intersection.
GeometryIntersection	Returns a geometry representing the intersection of two geometries.
GeometryIsValid	Checks whether the specified geometry is valid according to the OGC rules.
GeometryLength	Calculates the length of a given geometry.
GeometryOverlap	Determines whether two geometries overlap.
GeometryPerimeter	Calculates the perimeter of a given geometry (polygon or multipolygon).
GeometrySerializeDSV	Serializes a geometry using the specified DSV format.
GeometrySerializeWKT	Serializes a geometry using the Well-Known Text (WKT) format.
GeometrySymmetricDifference	Calculates the symmetric difference between two geometries.
GeometryTouch	Determines whether two geometries touch.
GeometryUnion	Returns a geometry corresponding to the union of two geometries.
GeometryWithin	Determines whether geometry A is completely within geometry B (i.e., geometry B completely contains geometry A).
Linestring2DAddPoint	Adds a new point to a 2D linestring.
LinestringGeoAddPoint	Adds a new point to a geographic linestring.

Spatial data functions manipulate the following variable types:

Variables corresponding to geometries defined using 2D coordinates:


Linestring2D	The Linestring2D type is used to define all the advanced characteristics of a linestring defined with 2D coordinates.
MultiLinestring2D	The MultiLinestring2D type can be used to store a collection of linestrings defined with 2D coordinates.
MultiPoint2D	The MultiPoint2D type is used to store a set of points defined with 2D coordinates. It is a collection of points: unlike in a linestring, points are not connected.
MultiPolygon2D	The MultiPolygon2D type can be used to store a collection of non-overlapping polygons defined with 2D coordinates.
Point2D	The Point2D type is used to define all the characteristics of a location represented on a Cartesian plane.
Polygon2D	The Polygon2D type is used to define all the advanced characteristics of a 2D polygon.

Variables corresponding to geometries defined using geographic coordinates:


LinestringGeo	The LinestringGeo type is used to define all the advanced characteristics of a geographic linestring.
MultiLinestringGeo	The MultiLinestring type can be used to store a collection of linestrings defined with geographic coordinates.
MultiPointGeo	The MultiPointGeo type is used to store a set of points defined with geographic coordinates. It is a collection of points: in this case, points are not connected.
MultiPolygonGeo	The MultiPolygonGeo type can be used to store a collection of non-overlapping polygons defined with geographic coordinates.
PointGeo	The PointGeo type is used to define all the advanced characteristics of a location represented on the spheroidal surface of the earth.
PolygonGeo	The PolygonGeo type is used to define all the advanced characteristics of a geographic polygon.