You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
[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)
The text was updated successfully, but these errors were encountered:
您好。我执行 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)
The text was updated successfully, but these errors were encountered: