st_asbinary

Penting

Dukungan untuk nilai GEOGRAPHY ada di Pratinjau Umum. Dukungan untuk nilai GEOMETRY umumnya tersedia.

Mengembalikan nilai Input Geografi atau Geometri dalam format WKB.

Untuk fungsi Databricks SQL yang sesuai, lihat st_asbinary fungsi.

Syntax

from pyspark.databricks.sql import functions as dbf

dbf.st_asbinary(col1=<col1>, col2=<col2>)

Parameter-parameternya

Pengaturan	Tipe	Description
col1	pyspark.sql.Column atau str	Nilai geospasial, baik Geografi atau Geometri.
col2	pyspark.sql.Column atau str, opsional	Endianness opsional dari WKB output, NDR untuk little-endian (default) atau XDR untuk big-endian.

Examples

from pyspark.databricks.sql import functions as dbf
from pyspark.sql.functions import hex
df = spark.createDataFrame([('LINESTRING(1 2,3 4)',)], ['wkt'])
df.select(hex(dbf.st_asbinary(dbf.st_geogfromtext('wkt'))).alias('result')).collect()

[Row(result='010200000002000000000000000000F03F000000000000004000000000000008400000000000001040')]

from pyspark.databricks.sql import functions as dbf
from pyspark.sql.functions import hex
df = spark.createDataFrame([('LINESTRING(1 2,3 4)', 'NDR',)], ['wkt', 'e'])
df.select(hex(dbf.st_asbinary(dbf.st_geogfromtext('wkt'), df.e)).alias('result')).collect()

[Row(result='010200000002000000000000000000F03F000000000000004000000000000008400000000000001040')]

from pyspark.databricks.sql import functions as dbf
from pyspark.sql.functions import hex
df = spark.createDataFrame([('LINESTRING(1 2,3 4)',)], ['wkt'])
df.select(hex(dbf.st_asbinary(dbf.st_geogfromtext('wkt'), 'XDR')).alias('result')).collect()

[Row(result='0000000002000000023FF0000000000000400000000000000040080000000000004010000000000000')]