Teradata Package for Python Function Reference | 17.10 - 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

Product
Teradata Package for Python
Release Number
17.10
Published
April 2022
Language
English (United States)
Last Update
2022-08-19
lifecycle
previous
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]