如何使用PostGIS扩展名正确存储LAT/长值

Question

描述

我是从 Google地理编码结果进入地理列。但是根据lat/long的不同，查询返回的值与插入的值不同。我在做什么错或失踪？

repro

CREATE EXTENSION IF NOT EXISTS postgis;

CREATE TABLE "public"."test_location" (
  "name" text,
  "location" GEOGRAPHY (point)
);

INSERT INTO "public"."test_location" ("name", "location")
  VALUES
  ('test 1', ST_POINT (32.714476, -117.151735)),
  ('test 2', ST_POINT (36.1450444, -85.4788305));

SELECT
  name,
  ST_AsText (location)
FROM
  "public"."test_location";

-- output:
-- |-----------------------------------------|
-- | name    | ST_AsText                     |
-- |-----------------------------------------|
-- | test 1  | POINT(32.714476 -62.848265)   | --> expected POINT(32.714476 -117.151735)
-- | test 2  | POINT(36.1450444 -85.4788305) |
-- |-----------------------------------------|

DROP TABLE "public"."test_location";

Answer 1

看起来经度和纬度被交换

st_point（经度，纬度）

经度的范围为-180至180

Latitude的范围为-90至90