Demonstrate direct geometry retrieval and manipulation

Column Name : sp_point
Geo subtype : SINGLE_POINT
WKT value   : POINT(4.5 -2.323)
X= 4.50000000000000000E+00 (sp_point)
Y=-2.32300000000000000E+00

Column Name : sp_linestring
Geo subtype : SINGLE_LINE_STRING
WKT value   : LINESTRING(-0.2 14.7,21.33 20,0 0)
X=-2.00000000000000000E-01 (sp_linestring 1)
Y= 1.47000000000000000E+01
X= 2.13300000000000000E+01 (sp_linestring 2)
Y= 2.00000000000000000E+01
X= 0.00000000000000000E+00 (sp_linestring 3)
Y= 0.00000000000000000E+00

Column Name : sp_polygon
Geo subtype : SINGLE_POLYGON
WKT value   : POLYGON((35 10,45 45,15 40,10 20,35 10),(20 30,35 35,30 20,20 30))
Ring# 1
X= 3.50000000000000000E+01 (point 1)
Y= 1.00000000000000000E+01
X= 4.50000000000000000E+01 (point 2)
Y= 4.50000000000000000E+01
X= 1.50000000000000000E+01 (point 3)
Y= 4.00000000000000000E+01
X= 1.00000000000000000E+01 (point 4)
Y= 2.00000000000000000E+01
X= 3.50000000000000000E+01 (point 5)
Y= 1.00000000000000000E+01
Ring# 2
X= 2.00000000000000000E+01 (point 1)
Y= 3.00000000000000000E+01
X= 3.50000000000000000E+01 (point 2)
Y= 3.50000000000000000E+01
X= 3.00000000000000000E+01 (point 3)
Y= 2.00000000000000000E+01
X= 2.00000000000000000E+01 (point 4)
Y= 3.00000000000000000E+01

Column Name : sp_multi_point
Geo subtype : MULTI_POINT
WKT value   : MULTIPOINT(-0.7 0.7,1.2 -1.2,2.2 2.995,-9.99 -9.00001)
X=-7.00000000000000000E-01 (Multipoint# 1)
Y= 7.00000000000000000E-01
X= 1.20000000000000000E+00 (Multipoint# 2)
Y=-1.20000000000000000E+00
X= 2.20000000000000000E+00 (Multipoint# 3)
Y= 2.99500000000000000E+00
X=-9.99000000000000000E+00 (Multipoint# 4)
Y=-9.00001000000000000E+00

Column Name : sp_multi_line_string
Geo subtype : MULTI_LINE_STRING
WKT value   : MULTILINESTRING((10 10,20 20,10 40),(40 40,30 30,40 20,30 10))
line# 1: LINESTRING(10 10,20 20,10 40)
line# 2: LINESTRING(40 40,30 30,40 20,30 10)

Column Name : sp_multi_polygon
Geo subtype : MULTI_POLYGON
WKT value   : MULTIPOLYGON(((40 40,20 45,45 30,40 40)),((20 35,10 30,10 10,30 5,45 20,20 35),(30 20,20 15,20 25,30 20)))
polygon# 1: POLYGON((40 40,20 45,45 30,40 40))
polygon# 2: POLYGON((20 35,10 30,10 10,30 5,45 20,20 35),(30 20,20 15,20 25,30 20))
Inner ring 1 of polygon 2 : POLYGON((30 20,20 15,20 25,30 20))

Column Name : sp_geo_collection
Geo subtype : HETEROGENEOUS
Number of elements in collection : 7

Element 1 type : SINGLE_POINT
Element 1 size : 1
Element 1 wkt  : POINT(4 6)

Element 2 type : SINGLE_LINE_STRING
Element 2 size : 1
Element 2 wkt  : LINESTRING(4 6,7 10)

Element 3 type : SINGLE_POLYGON
Element 3 size : 1
Element 3 wkt  : POLYGON((30 10,40 40,20 40,10 20,30 10))

Element 4 type : MULTI_POLYGON
Element 4 size : 2
Element 4 wkt  : MULTIPOLYGON(((30 20,45 40,10 40,30 20)),((15 5,40 10,10 20,5 10,15 5)))

Element 5 type : MULTI_LINE_STRING
Element 5 size : 2
Element 5 wkt  : MULTILINESTRING((10 10,20 20,10 40),(40 40,30 30,40 20,30 10))

Element 6 type : MULTI_POINT
Element 6 size : 4
Element 6 wkt  : MULTIPOINT(11.2 42.4,45.1 30,20.25 20,30.9 10.117)

Element 7 type : SINGLE_POLYGON
Element 7 size : 1
Element 7 wkt  : POLYGON((30 10,40 40,20 40,10 20,30 10))