Hi,
How can i make a topology in PostGIS?
Best regards
--
View this message in context:
http://www.nabble.com/PostGIS-topology-tp19560868p19560868.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
postgis-users mailing list
Hi. I’m trying to use postgis topology. And I have a question.
I have 3 nodes N1, N2, N3 and 2 edges E1 (with start_node = N1; end_node =
N2) and E2 (with start_node = N2; end_node = N3). I want to move node N2.
Do I have to select all edges, connected to node N2 (E1 and E2) and change
their geo
Hello post-GIS users!
I was wondering how many of you guys (if any) ever
tried or even currently makes use of the topology
model provided with PostGIS in the topology/ directory.
It's been there since 2005 (times of postgis-1.1.x, geos-2.1,
postgresql-7.3).
For the record: it has been broken for
>1. working with polygon coverages to maintain boundary coherence during
>edits
>2. simplify adjacent polygons without leaving gaps between them.
>3. editing road networks and maintaining coherence of joined segments
>and intersections
I'm very interesting to understand how actually the topology
>The idea behind topology is the if you have two polygons with a common
>edge, the the common edge is only represented as "one edge" and both
>polygons share that edge. if you make changes to that edge, then the
>polygons both have the same edge so it is not possible to create a gap
>between the tw
Hi all,
i'm "playing" with Postgis 2.0 Topology function and i like it.. but i receive
this error:
** Error **
ERROR: SQL/MM Spatial exception - point not on edge
SQL state: P0001
Context: PL/pgSQL function "topogeo_addpoint" line 66 at assignment
PL/pgSQL function "topogeo_addli
Nandorov schrieb:
> Hi,
> How can i make a topology in PostGIS?
>
> Best regards
>
Hi,
Not sure whether this is exactly what you're looking for, but pgRouting
has a function to create a network topology for routing.
The function is called name is "assign_vertex_id".
(http://pgrouting.postlbs.o
Daniel Kastl wrote:
> Nandorov schrieb:
>
>> Hi,
>> How can i make a topology in PostGIS?
>>
>> Best regards
>>
>>
> Hi,
> Not sure whether this is exactly what you're looking for, but pgRouting
> has a function to create a network topology for routing.
> The function is called name is
Hello,
Thanks for your replies. i read the info in
http://postgis.com/support/wiki/index.php?PostgisTopology
Mark, have you worked with GEOS before? I'm going to use windows enviroment
and i guess i have to build my own installer.(I found GEOS for Linux and
API's for a windows build) it's GEOS
Nandorov wrote:
> Hello,
>
> Thanks for your replies. i read the info in
> http://postgis.com/support/wiki/index.php?PostgisTopology
>
> Mark, have you worked with GEOS before? I'm going to use windows enviroment
> and i guess i have to build my own installer.(I found GEOS for Linux and
> API's fo
I use geos directly on windows xp using visual studio 2005. How do you plan to
use it?
Martin
--Original Message--
From: Mark Leslie
Sender: [EMAIL PROTECTED]
To: PostGIS Users Discussion
ReplyTo: PostGIS Users Discussion
Sent: Sep 21, 2008 5:33 PM
Subject: Re: [postgis-users] PostGIS
; To: PostGIS Users Discussion
> ReplyTo: PostGIS Users Discussion
> Sent: Sep 21, 2008 5:33 PM
> Subject: Re: [postgis-users] PostGIS topology
>
> Nandorov wrote:
>> Hello,
>>
>> Thanks for your replies. i read the info in
>> http://postgis.com/support/wiki/index
t;> --Original Message--
>> From: Mark Leslie
>> Sender: [EMAIL PROTECTED]
>> To: PostGIS Users Discussion
>> ReplyTo: PostGIS Users Discussion
>> Sent: Sep 21, 2008 5:33 PM
>> Subject: Re: [postgis-users] PostGIS topology
>>
>> Nandorov wrote:
&
;> --Original Message--
>>> From: Mark Leslie
>>> Sender: [EMAIL PROTECTED]
>>> To: PostGIS Users Discussion
>>> ReplyTo: PostGIS Users Discussion
>>> Sent: Sep 21, 2008 5:33 PM
>>> Subject: Re: [postgis-users] PostGIS topolog
GIS Users Discussion
> ReplyTo: PostGIS Users Discussion
> Sent: Sep 21, 2008 5:33 PM
> Subject: Re: [postgis-users] PostGIS topology
>
> Nandorov wrote:
>> Hello,
>>
>> Thanks for your replies. i read the info in
>> http://postgis.com/support/wiki/index.
I'm after some pointers on how I might use topology in this case:
We regularly undertake random stratified two phase trawl surveys for fisheries
stock assessments.
This requires the survey area to be divided into arbitrary strata, with sample
sites randomly defined for each strata. Generally t
Hi,
you can do this using triggers.
Try something like that:
--1 Create a function that return a Trigger ::
CREATE OR REPLACE FUNCTION your_trigger() RETURNS TRIGGER as $$
BEGIN
IF (TG_OP = 'UPDATE') THEN
UPDATE your_edge_table SET the_geom =
st_makeline(NEW.the_geom,ST_Endpoin
Hi, Fred.
Thanks for quick reply. I’ll try this way.
I’m just curious – how does it happen in pqrouting? Do I need something
like this trigger too using pqrouting (for moving node N2) or edges geometry
editing will be called automatically?
--
View this message in context:
http://old.nabble.c
Absurd wrote:
Hi, Fred.
Thanks for quick reply. I’ll try this way.
I’m just curious – how does it happen in pqrouting? Do I need something
like this trigger too using pqrouting (for moving node N2) or edges geometry
editing will be called automatically?
pgRouting does not use the postgis to
Thanks for information. It appears useful for me.
--
View this message in context:
http://old.nabble.com/postgis-topology-question-tp27334914p27353615.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
postgis-users mailing list
strk wrote:
Hello post-GIS users!
I was wondering how many of you guys (if any) ever
tried or even currently makes use of the topology
model provided with PostGIS in the topology/ directory.
It's been there since 2005 (times of postgis-1.1.x, geos-2.1,
postgresql-7.3).
For the record: it has be
The hardest thing is (as Steve said) it seems more of a higher level
application thing. PostGIS could leverage a datamodel to separate vertexes,
boundaries, areas, etc and even map what is common for each geometry, but I
think it would be really hard to enforce such dynamic events (editing
mostly).
Andrea Peri wrote:
1. working with polygon coverages to maintain boundary coherence during
edits
2. simplify adjacent polygons without leaving gaps between them.
3. editing road networks and maintaining coherence of joined segments
and intersections
I'm very interesting to understand how
On Thu, Jul 01, 2010 at 09:43:33AM -0400, Stephen Woodbridge wrote:
> 1. working with polygon coverages to maintain boundary coherence during
> edits
> 2. simplify adjacent polygons without leaving gaps between them.
> 3. editing road networks and maintaining coherence of joined segments
> and i
strk wrote:
On Thu, Jul 01, 2010 at 09:43:33AM -0400, Stephen Woodbridge wrote:
1. working with polygon coverages to maintain boundary coherence during
edits
2. simplify adjacent polygons without leaving gaps between them.
3. editing road networks and maintaining coherence of joined segments
As of revision 8963 (included in upcoming 2.0.0alpha3 [1]), the function
to convert simple layers to topologically defined layers [2] is completed.
[1] 2.0.0alpha3 http://www.postgis.org/download/
[2] toTopoGeom http://trac.osgeo.org/postgis/ticket/1017
This means that building a persistent top
Excellent work strk, thanks for this!
Could you please provide some examples how this can be used in queries? Does it
speed up querying for neighbours etc.?
Also, does it support network topologies, something I could use with pgrouting
or so?
Thanks,
Martin
--
Martin Tomko, PhD.
Senior Project
On Thu, Feb 09, 2012 at 05:01:15PM +0100, francescobocca...@libero.it wrote:
> Hi all,
> i'm "playing" with Postgis 2.0 Topology function and i like it.. but i
> receive
> this error:
>
> ** Error **
>
> ERROR: SQL/MM Spatial exception - point not on edge
> SQL state: P0001
> Co
On Sun, Apr 01, 2012 at 12:26:27AM -0700, pcr...@pcreso.com wrote:
> 1. depth contours
> 2. arbitrary lines between contours (generally following a lat or long)
> 3. areas of land or other excluded areas which are excluded from any strata
> overlapping them.
>
> My current Postgis model defines
Following on from the reply by strk (thanks!!) I'm still working through how to
use topologies.
I have a script which creates a topology, adds 5 linestrings looking like:
| | |
---
| | |
---
| | |
validates the result and then P
On Wed, Apr 04, 2012 at 09:57:10AM -0700, pcr...@pcreso.com wrote:
> Following on from the reply by strk (thanks!!) I'm still working through how
> to use topologies.
>
> I have a script which creates a topology, adds 5 linestrings looking like:
>
> | | |
> ---
> |
ect: Re: [postgis-users] Postgis topology
help
To: pcr...@pcreso.com, "PostGIS Users Discussion"
Date: Thursday, April 5, 2012, 5:49 AM
On Wed, Apr 04, 2012 at 09:57:10AM -0700, pcr...@pcreso.com wrote:
> Following on from the reply by strk (thanks!!) I'm still working through how
On Wed, Apr 04, 2012 at 12:14:13PM -0700, pcr...@pcreso.com wrote:
> Thanks again for a prompt reply.
>
> QGIS is showing the results of the inserts & polygonise in the attached
> image. So, yes, just as you sketched it.
What do you mean by "polygonise" ? Did you use topology.Polygonize ?
Mind y
Great news,
Congratulations! Lets try it!!
It would be really nice if some people from QGIS, gvSIG, uDIG, etc.
start thinking about building a plugin for it.
Regards,
Jose
On 30/01/2012 12:49, Sandro Santilli wrote:
As of revision 8963 (included in upcoming 2.0.0alpha3 [1]), the function
to c
On Mon, Jan 30, 2012 at 01:01:12PM +0100, Jose Carlos Martinez wrote:
> It would be really nice if some people from QGIS, gvSIG, uDIG, etc.
> start thinking about building a plugin for it.
We've discussed it some for QGIS in Zurich, mostly storming and comparing
GRASS and PostGIS topology to see
Thanks strk,
this is great news - thank you for your efforts,
cheers
Ben
On 30/01/2012, at 7:49 PM, Sandro Santilli wrote:
> As of revision 8963 (included in upcoming 2.0.0alpha3 [1]), the function
> to convert simple layers to topologically defined layers [2] is completed.
>
> [1] 2.0.0alph
Thanks strk,
I was trying to use the topology functions.
UPDATE public.sa_provinces
SET topogeom = toTopoGeom(the_geom, 'sa_provinces_topo');
I get the following message:
ERROR: function totopogeom(geometry, unknown) does not exist
LINE 2: SET topogeom = toTopoGeom(the_geom, 'sa_provinces_
On Mon, Jan 30, 2012 at 04:34:44PM +0200, Sindile Bidla wrote:
> Thanks strk,
>
> I was trying to use the topology functions.
>
> UPDATE public.sa_provinces
> SET topogeom = toTopoGeom(the_geom, 'sa_provinces_topo');
>
> I get the following message:
>
> ERROR: function totopogeom(geometry, u
On Mon, Jan 30, 2012 at 10:55:41PM +, Martin Tomko wrote:
> Excellent work strk, thanks for this!
> Could you please provide some examples how this can be used in queries? Does
> it speed up querying for neighbours etc.?
The focus insofar is about normalized storage. Speed you can squeeze out
[http://strk.keybit.net/blog/2011/10/14/postgis-topology-iso-sqlmm-complete/]
PostGIS implementation of the ISO SQL/MM Topology-Geometry model
is finally complete [1].
The SQL/MM model [2] is just a portion of the whole topology support [3],
but an important one, including schema definition and f
Hi Sandro,
This is great news!!
I think many people were waiting for a persistent topology model.
There is already some performance bechmark comparing the simple
feature model with the persistent topology model about quering,
writing topo geometries, etc. specially talking about face primitive
Il 17/10/2011 13:11, José Carlos Martínez Llario ha scritto:
Congratulations to the PostGIS team.
and to the sponsor of this work: Tuscany Regional Administration.
--
Paolo Cavallini
See: http://www.faunalia.it/pc
___
postgis-users mailing list
pos
On Mon, Oct 17, 2011 at 01:11:14PM +0200, José Carlos Martínez Llario wrote:
> I think many people were waiting for a persistent topology model.
Luckly someone also made something about it ! :)
> There is already some performance bechmark comparing the simple
> feature model with the persistent
This is just a reminder about the fundraising drive aimed at improving
the PostGIS topology support in upcoming 2.0 release.
<< I will implement a Geometry to TopoGeometry importer in
PostGIS-2.0 but only if 10 other people will donate 250 euro. >>
http://www.pledgebank.com/postgistopolo
44 matches
Mail list logo