geometry_column_length | Display Options | teradataml - geometry_column_length - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

The geometry_column_length option specifies the length of the Geometry column while displaying the GeoDataFrame.

By default, geometry_column_length is set to 30. So, GeoDataFrame displays only first 30 characters in every geometry column.

Example 1: Display a GeoDataFrame with default geometry_column_length

>>> df = DataFrame("sample_shapes")
>>> df
                              points                     linestrings                        polygons                geom_collections                     geosequence
skey
1006    POINT (235.52 54.546 7.4564)  LINESTRING (1.35 3.6456 4.5,3.  POLYGON ((0 0 0,0 0 20,0 20 0,                            None                            None
1001                   POINT (10 20)    LINESTRING (1 1,2 2,3 3,4 4)  POLYGON ((0 0,0 20,20 20,20 0,  GEOMETRYCOLLECTION (POINT (10   GEOSEQUENCE((10 20,30 40,50 60
1010  MULTIPOINT (10.345 20.32 30.6,  MULTILINESTRING ((1 3 6,3 0 6,  MULTIPOLYGON (((0 0 0,0 0 20,0                            None                            None
1008  MULTIPOINT (1.65 1.76,1.23 3.7  MULTILINESTRING ((1 3,3 0,0 1)  MULTIPOLYGON (((0 0,0 20,20 20                            None                            None
1003           POINT (235.52 54.546)  LINESTRING (1.35 3.6456,3.6756  POLYGON ((0.6 0.8,0.6 20.8,20.                            None                            None
1002                     POINT (1 3)        LINESTRING (1 3,3 0,0 1)  POLYGON ((0 0,0 20,20 20,20 0,                            None  GEOSEQUENCE((10 10,15 15,-2 0)
1004                POINT (10 20 30)  LINESTRING (10 20 30,40 50 60,  POLYGON ((0 0 0,0 10 20,20 20   GEOMETRYCOLLECTION (POINT (10                             None
1005                   POINT (1 3 5)  LINESTRING (1 3 6,3 0 6,6 0 1)  POLYGON ((0 0 0,0 0 20.435,0.0  GEOMETRYCOLLECTION (POINT (10                             None
1007  MULTIPOINT (1 1,1 3,6 3,10 5,2  MULTILINESTRING ((1 1,1 3,6 3)  MULTIPOLYGON (((1 1,1 3,6 3,6                             None                            None
1009  MULTIPOINT (10 20 30,40 50 60,  MULTILINESTRING ((10 20 30,40   MULTIPOLYGON (((0 0 0,0 20 20,                            None                            None
>>>

Example 2: Set geometry_column_length to 35 and display the same GeoDataFrame

>>> display.geometry_column_length=35
>>> df
                                   points                          linestrings                             polygons                     geom_collections                          geosequence
skey
1010  MULTIPOINT (10.345 20.32 30.6,40.23  MULTILINESTRING ((1 3 6,3 0 6,6 0 1  MULTIPOLYGON (((0 0 0,0 0 20,0 20 0                                 None                                 None
1004                     POINT (10 20 30)  LINESTRING (10 20 30,40 50 60,70 80  POLYGON ((0 0 0,0 10 20,20 20 30,20  GEOMETRYCOLLECTION (POINT (10 20 30                                 None
1003                POINT (235.52 54.546)  LINESTRING (1.35 3.6456,3.6756 0.23  POLYGON ((0.6 0.8,0.6 20.8,20.6 20.                                 None                                 None
1006         POINT (235.52 54.546 7.4564)  LINESTRING (1.35 3.6456 4.5,3.6756   POLYGON ((0 0 0,0 0 20,0 20 0,0 20                                  None                                 None
1001                        POINT (10 20)         LINESTRING (1 1,2 2,3 3,4 4)  POLYGON ((0 0,0 20,20 20,20 0,0 0))  GEOMETRYCOLLECTION (POINT (10 10),P  GEOSEQUENCE((10 20,30 40,50 60),(20
1002                          POINT (1 3)             LINESTRING (1 3,3 0,0 1)  POLYGON ((0 0,0 20,20 20,20 0,0 0),                                 None  GEOSEQUENCE((10 10,15 15,-2 0),(200
1005                        POINT (1 3 5)       LINESTRING (1 3 6,3 0 6,6 0 1)  POLYGON ((0 0 0,0 0 20.435,0.0 20.4  GEOMETRYCOLLECTION (POINT (10 20 30                                 None
1008  MULTIPOINT (1.65 1.76,1.23 3.76,6.2  MULTILINESTRING ((1 3,3 0,0 1),(1.3  MULTIPOLYGON (((0 0,0 20,20 20,20 0                                 None                                 None
1007   MULTIPOINT (1 1,1 3,6 3,10 5,20 1)  MULTILINESTRING ((1 1,1 3,6 3),(10   MULTIPOLYGON (((1 1,1 3,6 3,6 0,1 1                                 None                                 None
1009  MULTIPOINT (10 20 30,40 50 60,70 80  MULTILINESTRING ((10 20 30,40 50 60  MULTIPOLYGON (((0 0 0,0 20 20,20 20                                 None                                 None
>>>