Teradata Package for Python Function Reference on VantageCloud Lake - num_geometry - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.
Teradata® Package for Python Function Reference on VantageCloud Lake
- Deployment
- VantageCloud
- Edition
- Lake
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.03
- Published
- December 2024
- ft:locale
- en-US
- ft:lastEdition
- 2024-12-19
- dita:id
- TeradataPython_FxRef_Lake_2000
- Product Category
- Teradata Vantage
- teradataml.geospatial.geodataframecolumn.GeoDataFrameColumn.num_geometry = num_geometry(self)
- DESCRIPTION:
Returns the number of distinct geometries that constitute a composite
geometry type (ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, or
ST_MultiPolygon).
PARAMETERS:
None
SUPPORTED GEOMETRY TYPES:
ST_GeomCollection, ST_MultiPoint, ST_MultiLineString, and ST_MultiPolygon
RAISES:
TypeError, ValueError, TeradataMlException
RETURNS:
GeoDataFrameColumn
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)
# Example 1: Get the number of distinct geometries that constitute the composite geometry type
# ST_GeometryCollection in column 'geom_collections'.
# Let's select only few columns from GeoDataFrame.
geomcdf = geodf.select(["skey", "geom_collections"])[geodf.skey.isin([1001, 1004, 1005])]
geomcdf.assign(res = geomcdf.geom_collections.num_geometry())
# Example 2: Get all the rows where the number of distinct geometries that constitute the
# composite geometry type ST_GeometryCollection in column 'geom_collections' is 3.
geomcdf[geomcdf.geom_collections.num_geometry() == 3]