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

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
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_Enterprise_2000
lifecycle
latest
Product Category
Teradata Vantage
teradataml.geospatial.geodataframecolumn.GeoDataFrameColumn.wkb_geom_to_sql = wkb_geom_to_sql(self, column)
DESCRIPTION:
    Returns a specified Geometry value.
    Note:
        *  Vantage provides this method because it is in the SQL/MM
          Spatial standard, where it is defined to implement transform
          functionality that allows importing the Geometry type to the server.
 
PARAMETERS:
    column:
        Required Argument.
        Specifies the geometry value specified in the well-known binary (WKB) format.
        The data type of "column" is BLOB. The maximum size of "column" is
        approximately 16 MB (the exact maximum is 16 MB - 1 KB), allowing
        for a representation of approximately one million points. For more
        information on WKB formats, see Well-Known Binary Format in SQL documentation.
        Types: str, ColumnExpression
 
SUPPORTED GEOMETRY TYPES:
    All Geometry types.
 
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 WKB geometry in SQL format.
    # Let's select only few columns from GeoDataFrame.
    geodfbin = geodf.select(["skey", "points"]).assign(str_column=geodf.points.to_binary())
    geodfbin.assign(res = geodfbin.points.wkb_geom_to_sql(column="str_column"))