to_geometry

Penting

Fitur ini ada di Pratinjau Umum.

Mengurai nilai BINER atau string input dan mengembalikan nilai Geometri yang sesuai. Terjadi kesalahan karena input yang tidak valid.

Untuk fungsi Databricks SQL yang sesuai, lihat to_geometry fungsi.

Syntax

from pyspark.databricks.sql import functions as dbf

dbf.to_geometry(col=<col>)

Parameter-parameternya

Pengaturan	Tipe	Description
col	pyspark.sql.Column atau str	Nilai string dalam format WKT atau GeoJSON, atau nilai BINER dalam format WKB atau EWKB yang mewakili nilai Geometri .

Examples

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('POINT Z (3 4 5)',)], ['wkt'])
df.select(dbf.st_asewkt(dbf.to_geometry('wkt')).alias('result')).collect()

[Row(result='POINT Z (3 4 5)')]

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([('{"type":"MultiPoint","coordinates":[[3,4,5]]}',)], ['geojson'])
df.select(dbf.st_asewkt(dbf.to_geometry('geojson')).alias('result')).collect()

[Row(result='SRID=4326;MULTIPOINT Z ((3 4 5))')]

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(bytes.fromhex('01ef0300000100000001e9030000000000000000084000000000000010400000000000001440'),)], ['wkb'])
df.select(dbf.st_asewkt(dbf.to_geometry('wkb')).alias('result')).collect()

[Row(result='GEOMETRYCOLLECTION Z (POINT Z (3 4 5))')]

from pyspark.databricks.sql import functions as dbf
df = spark.createDataFrame([(bytes.fromhex('01020000a0110f000002000000000000000000084000000000000010400000000000001440000000000000084000000000000010400000000000001440'),)], ['ewkb'])
df.select(dbf.st_asewkt(dbf.to_geometry('ewkb')).alias('result')).collect()

[Row(result='SRID=3857;LINESTRING Z (3 4 5,3 4 5)')]