Teradata Package for Python Function Reference | 17.10 - point - 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.point = point(self, position)
- DESCRIPTION:
Returns the specified point from a Geometry type that represents an
ST_LineString or GeoSequence value.
Note:
* This method returns a point having a Z coordinate if the input
geometry is three-dimensional.
PARAMETERS:
position:
Required Argument.
Specifies a value for the requested point, where the position of the
first point is 1.
Types: int, str, ColumnExpression
SUPPORTED GEOMETRY TYPES:
ST_LineString and GeoSequence
RAISES:
TypeError, ValueError, TeradataMlException
RETURNS:
GeoDataFrameColumn containing Geometry values
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, also filter rows containing
# only ST_Linestring geometries.
lines = geodf.select(["skey", "linestrings"])[geodf.linestrings.geom_type == "ST_Linestring"]
# Example 1: Get the point specified at 1st position in ST_LineString geometries in column 'linestrings'.
lines.assign(res = lines.linestrings.point(1))
# Example 2: Get the point specified at 2nd position in ST_LineString geometries in column 'linestrings'.
lines.assign(res = lines.linestrings.point(position=2))
# Example 3: Filter the rows where the point specified at 1st position in ST_LineString geometries
# in column 'linestrings' is same as the specified Point GeometryType object.
# Create an object of Point GeometryType.
p1 = Point(1, 1)
lines[lines.linestrings.point(1) == p1]