On Wed, Jul 13, 2016 at 01:05:41PM +0200, Neumann, Andreas wrote:
> Yes - I will try that next - loading it in chunks. But wouldn't it miss
> out on some of the neighbourpolygons then if I use such subsets based on
> pkey?
The final goal is importing all of your geometries, so eventually
neighbo
Hi Strk,
Yes - I will try that next - loading it in chunks. But wouldn't it miss
out on some of the neighbourpolygons then if I use such subsets based on
pkey?
Thanks,
Andreas
On 2016-07-13 12:55, Sandro Santilli wrote:
> On Tue, Jul 12, 2016 at 01:15:41PM +0200, Neumann, Andreas wrote:
>
On Tue, Jul 12, 2016 at 01:15:41PM +0200, Neumann, Andreas wrote:
> Hi Sandro,
>
> I let this function run during the night and after 7.5h I got an error
> message:
Eh, that's why I suggested loading the topology in batches.
Use constructs like:
SELECT TopoGeo_addPolygon(...)
FROM input_t
Hi Sandro,
I let this function run during the night and after 7.5h I got an error
message:
ERROR: Corrupted topology: adjacent edges 159972 and -159958 bind
different face (0 and 78697)
CONTEXT: SQL statement "SELECT topology.ST_AddEdgeModFace(atopology,
s
On Mon, Jul 11, 2016 at 04:52:40PM +0200, Neumann, Andreas wrote:
> The ST_CreateTopoGeo() function runs for a very long time. >45 minutes
> on this relatively small dataset. Did I use the wrong combination of
> functions at the top, or is it a problem that after ST_CurveToLine() my
> data contain
Hi Strk,
I finally had the time to try out the topology extension in my project.
As you proposed, I used the following command.
-
SELECT CreateTopology('av_1700_bb_topo', 21781);
SELECT ST_CreateTopoGeo('av_1700_bb_topo', (
SELECT ST_Collect(ST_CurveToLine(geom)) FROM av
Hi Strk,
Thank you for these hints.
It will help me to get started - also combined with your blog entries on
the topic!
Andreas
On 2016-07-01 10:29, Sandro Santilli wrote:
> On Thu, Jun 30, 2016 at 11:25:22AM +0200, Neumann, Andreas wrote:
>
>> Is there a method in Postgis to create a Top
On Thu, Jun 30, 2016 at 11:25:22AM +0200, Neumann, Andreas wrote:
> Is there a method in Postgis to create a Topology, eliminating double
> borders from the original CurvePolygons and attaching left and right
> attributes from the original polygons? I came across the Postgis
> topology module. Is
Hi all,
I have a table with CurvePolygon geometry and I'd like to extract
CompoundCurve or Linestring geometry for the purpose of landcover
symbology in a complex map design. The common polygon borders should
exist in the data only once, but I'd need to know which land cover types
(attached to th