STV_GeographyPoint
Returns a GEOGRAPHY point based on the input values.
This is the optimal way to convert raw coordinates to GEOGRAPHY points.
Behavior Type
Syntax
STV_GeographyPoint( x, y )
Arguments
x |
x-coordinate or longitude, FLOAT. |
y
|
y-coordinate or latitude, FLOAT. |
Returns
GEOGRAPHY
Examples
The following examples show how to use STV_GeographyPoint.
Return a GEOGRAPHY point:
=> SELECT ST_AsText(STV_GeographyPoint(-114.101588, 47.909677)); ST_AsText ------------------------------- POINT (-114.101588 47.909677) (1 row)
Return GEOGRAPHY points using two columns:
=> CREATE TABLE geog_data (id IDENTITY, x FLOAT, y FLOAT); CREATE TABLE => COPY geog_data FROM STDIN; Enter data to be copied followed by a newline. End with a backslash and a period on a line by itself. >> -114.101588|47.909677 >> -111.532377|46.430753 >> \. => SELECT id, ST_AsText(STV_GeographyPoint(x, y)) FROM geog_data; id | ST_AsText ----+------------------------------- 1 | POINT (-114.101588 47.909677) 2 | POINT (-111.532377 46.430753) (2 rows)
Create GEOGRAPHY points by manipulating data source columns during load:
=> CREATE TABLE geog_data_load (id IDENTITY, geog GEOGRAPHY); CREATE TABLE => COPY geog_data_load (lon FILLER FLOAT, lat FILLER FLOAT, geog AS STV_GeographyPoint(lon, lat)) FROM 'test_coords.csv' DELIMITER ','; Rows Loaded ------------- 2 (1 row) => SELECT id, ST_AsText(geog) FROM geog_data_load; id | ST_AsText ----+------------------------------------ 1 | POINT (-75.101654451 43.363830536) 2 | POINT (-75.106444487 43.367093798) (2 rows)