多角形到地理位置

发布于 2025-01-27 19:17:15 字数 799 浏览 2 评论 0原文

我有这样的多角。我该如何将其转换为GEOM？当我使用更新表集时，GEOM = ST_GEOMFROMTEXT（'wkt'），我有一个错误：

错误：解析错误 - 无效的

几何提示：“ WK”＆lt; - - 在几何学中位置2的分析错误

WKT
MULTIPOLYGON (((24.0538073758627 37.7378703845543,24.0538007353528 37.7379487552645,24.0536236884047 37.7380046312008,24.0535794162991 37.7380077309477,24.0535382978588 37.7379758484951,24.0534338058209 37.7380279295364,24.0534348887244 37.7380896641314,24.053460740598 37.7381057377936,24.0534867036416 37.7381190093452,24.0535498820047 37.7381290046238,24.053633022553 37.7381254748393,24.0537206363065 37.7380982153644,24.0538080832798 37.7380751589808,24.0538873759795 37.7380350692302,24.0539348015795 37.7379969871668,24.0539640433116 37.7379275964686,24.0539663216762 37.7378701532806,24.0538073758627 37.7378703845543)))

原文

I have this kind of MultiPolygon. How can I convert it to a geom?
When I use UPDATE table SET geom = ST_GeomFromText('WKT'), I have an error:

ERROR: parse error - invalid geometry

HINT: "WK" <-- parse error at position 2 within geometry

WKT
MULTIPOLYGON (((24.0538073758627 37.7378703845543,24.0538007353528 37.7379487552645,24.0536236884047 37.7380046312008,24.0535794162991 37.7380077309477,24.0535382978588 37.7379758484951,24.0534338058209 37.7380279295364,24.0534348887244 37.7380896641314,24.053460740598 37.7381057377936,24.0534867036416 37.7381190093452,24.0535498820047 37.7381290046238,24.053633022553 37.7381254748393,24.0537206363065 37.7380982153644,24.0538080832798 37.7380751589808,24.0538873759795 37.7380350692302,24.0539348015795 37.7379969871668,24.0539640433116 37.7379275964686,24.0539663216762 37.7378701532806,24.0538073758627 37.7378703845543)))

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

别挽留 2025-02-03 19:17:15

SELECT
    ST_GeomFromText ('MULTIPOLYGON (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)');

或者

SELECT ST_GeomFromText(
'MULTIPOLYGON ((
    (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)))', 4326);

SELECT
    ST_GeomFromText ('MULTIPOLYGON (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)');

SELECT ST_GeomFromText(
'MULTIPOLYGON ((
    (24.0538073758627 37.7378703845543,
    24.0538007353528 37.7379487552645,
    24.0536236884047 37.7380046312008,
    24.0535794162991 37.7380077309477,
    24.0535382978588 37.7379758484951,
    24.0534338058209 37.7380279295364,
    24.0534348887244 37.7380896641314,
    24.053460740598 37.7381057377936,
    24.0534867036416 37.7381190093452,
    24.0535498820047 37.7381290046238,
    24.053633022553 37.7381254748393,
    24.0537206363065 37.7380982153644,
    24.0538080832798 37.7380751589808,
    24.0538873759795 37.7380350692302,
    24.0539348015795 37.7379969871668,
    24.0539640433116 37.7379275964686,
    24.0539663216762 37.7378701532806,
    24.0538073758627 37.7378703845543)))', 4326);

回复收藏 0 原文

~没有更多了~