카테고리:: 지리 공간 함수

ST_ASEWKB¶

Given a value of type GEOGRAPHY or GEOMETRY, return the binary representation of that value in EWKB (extended well-known binary) format.

참고 항목:: ST_ASWKB

구문¶

ST_ASEWKB( <geography_or_geometry_expression> )

인자¶

geography_or_geometry_expression: The argument must be an expression of type GEOGRAPHY or GEOMETRY.

반환¶

BINARY 형식의 값입니다.

사용법 노트¶

For GEOGRAPHY objects, the SRID in the return value is always 4326. See the note on EWKT handling.
출력을 WKB 형식으로 반환하려면 대신 ST_ASWKB 를 사용하십시오.

예¶

GEOGRAPHY Examples¶

다음 예는 ST_ASEWKB 함수를 보여줍니다. EWKB 출력의 경우, BINARY_OUTPUT_FORMAT 매개 변수가 HEX (매개 변수의 기본값)로 설정되어 있다고 가정합니다.

create table geospatial_table (id INTEGER, g GEOGRAPHY);
insert into geospatial_table values
    (1, 'POINT(-122.35 37.55)'), (2, 'LINESTRING(-124.20 42.00, -120.01 41.99)');

select st_asewkb(g)
    from geospatial_table
    order by id;
+--------------------------------------------------------------------------------------------+
| ST_ASEWKB(G)                                                                               |
|--------------------------------------------------------------------------------------------|
| 0101000020E61000006666666666965EC06666666666C64240                                         |
| 0102000020E610000002000000CDCCCCCCCC0C5FC00000000000004540713D0AD7A3005EC01F85EB51B8FE4440 |
+--------------------------------------------------------------------------------------------+

GEOMETRY Examples¶

The example below demonstrates how to use the ST_ASEWKB function. The example returns the EWKB representations of two geometries that have different SRIDs.

CREATE OR REPLACE TABLE geometry_table (g GEOMETRY);
INSERT INTO geometry_table VALUES
  ('SRID=4326;POINT(-122.35 37.55)'),
  ('SRID=0;LINESTRING(0.75 0.75, -10 20)');

SELECT ST_ASEWKB(g) FROM geometry_table;

+--------------------------------------------------------------------------------------------+
| ST_ASEWKB(G)                                                                               |
|--------------------------------------------------------------------------------------------|
| 0101000020E61000006666666666965EC06666666666C64240                                         |
| 01020000200000000002000000000000000000E83F000000000000E83F00000000000024C00000000000003440 |
+--------------------------------------------------------------------------------------------+