Opened 8 years ago

Closed 3 years ago

#2497 closed defect (fixed)

Incompatile PostGIS Topology export

Reported by: strk Owned by: grass-dev@…
Priority: normal Milestone: 7.6.1
Component: Vector Version: svn-trunk
Keywords: postgis, topology Cc:
CPU: Unspecified Platform: Unspecified

Description

I've tried exporting topology to PostGIS with v.out.postgis -l and the result was not correct.

First there was no record in TOPOSCHEMA.relation so that all the literal TopoGeometry values (written in the output feature layer) result empty.

Second all the calls to ST_GetFaceGeometry() return a null value, which I've yet to inspect/understand. All I noticed so far was that there were many negative face_id, which don't really have any special meaning in PostGIS/ISO (there's no difference between an area or an island, you only have faces, with roles being dependent on the upper abstraction level of the TopoGeometry).

Unfortunately, topology.ValidateTopology doesn't notice any of these problems (this would be a PostGIS bug).

Change History (6)

comment:1 by strk, 8 years ago

I've found that ST_GetFaceGeometry only returns a NULL value for faces with a negative id (which would make sense, assuming no edge would ever point to them as being on its right or left side.

Should these negative faces be put in a grass-specific table rather than polluting the ISO one ?

comment:2 by martinl, 6 years ago

Milestone: 7.0.07.0.5

comment:3 by martinl, 6 years ago

Keywords: postgis topology added

comment:4 by neteler, 6 years ago

Milestone: 7.0.57.0.6

comment:5 by neteler, 4 years ago

Milestone: 7.0.67.0.7

comment:6 by martinl, 3 years ago

Milestone: 7.0.77.6.1
Resolution: fixed
Status: newclosed

Already fixed.

Note: See TracTickets for help on using tickets.