Teradata Package for Python Function Reference | 17.10 - overlaps - Teradata Package for Python
Teradata® Package for Python Function Reference
- Product
- Teradata Package for Python
- Release Number
- 17.10
- Published
- April 2022
- Language
- English (United States)
- Last Update
- 2022-08-19
- Product Category
- Teradata Vantage
- teradataml.geospatial.geodataframecolumn.GeoDataFrameColumn.overlaps = overlaps(self, geom_column)
- DESCRIPTION:
Tests if a Geometry value spatially overlaps another Geometry value.
Note:
* Using a geospatial index can greatly improve the performance of
queries that use this method.
PARAMETERS:
geom_column:
Required Argument.
Specifies the other Geometry value.
Types: str, ColumnExpression, GeometryType
SUPPORTED GEOMETRY TYPES:
Valid on all Geometry types, except geometry collections.
Note:
This method can be called on 3D geometries (those that include Z
coordinates). However, the Z coordinate is ignored in method
calculations.
RAISES:
TypeError, ValueError, TeradataMlException
RETURNS:
GeoDataFrameColumn
Resultant column contains:
* 1, if the geometries overlap
* 0, if the geometries do not overlap
EXAMPLES:
from teradataml import GeoDataFrame, load_example_data
from teradataml import Point, LineString, Polygon, GeometryCollection
# Load example data.
load_example_data("geodataframe", "sample_shapes")
# Create a GeoDataFrame.
geodf = GeoDataFrame("sample_shapes")
print(geodf)
# Let's select only few columns from GeoDataFrame.
pols_lines = geodf.select(["skey", "polygons", "linestrings"])
# Example 1: Check whether geometries in column 'polygons' and 'lienstrings'
# overlaps or not.
pols_lines.assign(res = pols_lines.polygons.overlaps(geom_column=pols_lines.linestrings))
# Example 2: Check whether geometries in column 'lienstrings' columns and
# a Linestring GeometryType object overlaps or not.
# Create an object of Linestring GeometryType.
l1 = LineString([(1,3,6), (3,0,6), (6,0,1)])
# Pass the LineString() GeometryType object as input to "geom_column" argument.
pols_lines.assign(res = pols_lines.linestrings.overlaps(l1))
# Example 3: Filter all rows whether geometries in column 'lienstrings' columns and
# a Linestring GeometryType object overlaps.
# Create an object of Linestring GeometryType.
l1 = LineString([(1,3,6), (3,0,6), (6,0,1)])
# Pass the LineString() GeometryType object as input to "geom_column" argument.
pols_lines[pols_lines.linestrings.overlaps(l1) == 1]