Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[Err] 错误: lwpoly_from_lwlines: shell must be closed #5

Open
JishuaiWang opened this issue Jun 14, 2019 · 0 comments
Open

[Err] 错误: lwpoly_from_lwlines: shell must be closed #5

JishuaiWang opened this issue Jun 14, 2019 · 0 comments

Comments

@JishuaiWang
Copy link

您好。我执行 select FreeGIS_Coordinate_Transform('public','pg_build_dq','GCJ2WGS'); 时报错如下:请问怎么解决?是我数据的问题吗? 第一次转换的时候正常,第二次就报错了。
注意: 对拆分点进行偏移计算完成!
CONTEXT: 在RAISE的第97行的PL/pgSQL函数_freegis_coordinate_transform_1(text,text,freegis_coordinate_transform_type)
在RETURN的第8行的PL/pgSQL函数freegis_coordinate_transform(text,text,freegis_coordinate_transform_type)

注意: 偏移计算结果拼装原图形...
CONTEXT: 在RAISE的第99行的PL/pgSQL函数_freegis_coordinate_transform_1(text,text,freegis_coordinate_transform_type)
在RETURN的第8行的PL/pgSQL函数freegis_coordinate_transform(text,text,freegis_coordinate_transform_type)

[Err] 错误: lwpoly_from_lwlines: shell must be closed
CONTEXT: SQL 语句 "with _result as (
with _Multi_Polygon_result as (
with _polygon_result as (select rec_ctid,geom_path[1] as _path1,
geom_path[2] as _path2,ST_MakeLine(target_geom) as geom from _split_result group by rec_ctid,_path1, _path2)
select t1.rec_ctid,t1._path1,case when t2.geom is null then ST_MakePolygon(t1.geom) else ST_MakePolygon(t1.geom,t2.geom) end as geom
from (select rec_ctid,_path1,geom from _polygon_result t where t._path2=1) t1 left join
(select rec_ctid,_path1,array_agg(geom) as geom from _polygon_result t where t._path2!=1 group by rec_ctid,_path1) t2
on t1.rec_ctid=t2.rec_ctid
)
select t.rec_ctid,ST_Multi(ST_Union(geom)) as geom from _Multi_Polygon_result t group by t.rec_ctid
)
update public.pg_build_dq t1 set transform_geom=t2.geom from _result t2 where t1.ctid=t2.rec_ctid"
在EXECUTE的第128行的PL/pgSQL函数_freegis_coordinate_transform_1(text,text,freegis_coordinate_transform_type)
在RETURN的第8行的PL/pgSQL函数freegis_coordinate_transform(text,text,freegis_coordinate_transform_type)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant