--strk
Oops ... :-( you are right. I looked at an old version (1.4) of the
documentation. In 1.5 documentation everything seems to be ok. Please
excuse the noise I produced on the list!
Regards
Horst
Dr. Horst Düster
Stv. Amtschef / Chef Geoinfor
Hallo
I just upgraded PostGIS from 1.3 to 1.5. Now I found out that, some
queries are not running due to the lack of the ST_AddBBOX() function. In
postgis.sql row 7765 the function is removed with "DROP FUNCTION IF
EXISTS st_addbbox(geometry);". I'm a little bit confused about the fact
that ST_Add
am: Montag, 8. November 2010 10:58
An: Düster Horst
Cc: postgis-users
Betreff: Re: Re: [postgis-users] Announcement: PostGIS Versioning System
pgversion and QGIS Plugin
On QGIS 1.4 (mac), I overridden the 1.5 warning and continued with the
install. Plugin manager didn't activate it.
On qgis
25 32
Mobil ++41(0)79 511 54 12
Telefax ++41(0)32 627 22 14
mailto:horst.dues...@bd.so.ch
http://www.agi.so.ch
-Ursprüngliche Nachricht-
Von: maning sambale [mailto:emmanuel.samb...@gmail.com]
Gesendet am: Montag, 8. November 2010 10:58
An: Düster Horst
Cc: postgis-users
Betreff: Re
ternal users from, for example
a web
> system? We normally do not use the users on PostgreSQL for the data
content.
> Are you planning something on this direction?
> Thanks.
> Javier
> www.vizzuality.com
>
>
> On Nov 8, 2010, at 8:43 AM, Düster Horst wrote:
>
> I j
I just finished the first beta version of my newly released pgvs support
system. The idea of this system is to enable the editing of a single
PostGIS layer concurrently by more than one user at the same time,
similar to source code versioning systems like CVS or Subversion. You
will find further in
Martin
>Some more sophisticated approach is required, such as vertex snapping
>the lines to a given tolerance, or perhaps using a narrow buffer and
>some sort of segment-based containment tests.
In the ESRI ArcInfo world I lived in former times they use fuzzy
tolerances.
Horst
---
that :-) )
Or actually in your case you will only get that extra vertex on the
west part because there the line 1 changes direction. On the east
side the vertex is just moved a little bit.
Hope that helps
Nicklas
2009-09-16 Düster Horst wrote:
>
Mar
Martin, Nicklas
Thank you for your responses. To avoid precision problems I modified my
query to:
select st_intersection(st_snaptogrid(a.the_geom,0.01),
st_snaptogrid(b.the_geom,0.01)), a.myid
from aline1 as a, aline2 as b
As the result I do get a MULTIPOINT geometry with three points. These
poi
strk
I attached the geometries in my initial mail.
Take a look at aline1.sql and aline2.sql
regards
Horst
Dr. Horst Düster
Stv. Amtschef / GIS-Koordinator
Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
R
I do have 2 simple linestrings which partly have the same geometry (see
attached dump and image). My aim is to detect the common part of these
two linestrings with the following query:
select st_intersection(a.the_geom, b.the_geom), a.myid
from aline1, aline2
But as the result I get a geometrycol
I do have 2 simple linestrings which partly have the same geometry (see
attached dump and image). My aim is to detect the common part of these
two linestrings with the following query:
select st_intersection(a.the_geom, b.the_geom), a.myid
from aline1, aline2
But as the result I get a geometrycol
The PostGIS SQL Editor Plugin of QGIS does exactly what you want.
Dr. Horst Düster
Stv. Amtschef / GIS-Koordinator
Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn
Telefon ++4
Hi
Try to use the cleanGeometry function published on:
http://www.sogis1.so.ch/sogis/dl/postgis/cleanGeometry.sql
for cleaning your geometries.
Regards
Horst
Dr. Horst Düster
Stv. Amtschef / GIS-Koordinator
Kanton Solothurn
Bau- und Justizdep
Please excuse cross-posting
and german language, but this posting is addressed to the german speaking
FOSSGIS community.
--
2. FOSSGIS Höck in Solothurn - Nachlese.
Mit ca. 15 Teilnehmern aus Basel, Bern, Zürich, Uster, Thun, Burgdorf, Lausanne
und Solothurn hat e
Please excuse cross-posting and german language, but this posting is
addressed to the german speaking FOSSGIS community.
--
Am 28. Januar 2009 wird der 2. FOSSGIS-Höck in Solothurn stattfinden.
Wir wollen uns treffen und in lockerer Runde über FOSSGIS und den ganzen
Rest d
Hi
I played a little bit with pgrouting to build a routing plugin client for QGIS.
In principle it works fine but I found out some annoyances:
1. The functions like shortest_path, dijkstra etc. don't respect schema
qualified tables.
2. always it is supposed and hard coded that GID is the p
Hi David
What do you mean with unresponsiv?? When I click the link I get a
response.
Dr. Horst Düster
GIS-Koordinator, Stv. Amtschef
Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solo
ng invalid multipolygons
Hello Horst,
Düster Horst <[EMAIL PROTECTED]>, [20080829-09:02:02]:
> M...
> >Another solution which *may* work is to replace the geometry by a
> buffer
> >of size 0 around the geometry in your select statement
>
> No this is a bad ide
M...
>Another solution which *may* work is to replace the geometry by a
buffer
>of size 0 around the geometry in your select statement
No this is a bad idea. You do not have any control about the result of
your buffer(0). A better way is to clean the polygon geometry with the
cleangeometry()
Take a look at
http://www.vividsolutions.com/JTS/tests/index.html
Dr. Horst Düster
GIS-Koordinator, Stv. Amtschef
Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn
Telefon ++41
In the last few days I developed a plpgsql function to clean not valid
polygon and linestring geometries. This function cleans all ring-self-
and self-intersections in PostGIS layers.
The input is a valid or non valid geometry with one or more
self-intersections. The result is a clean Multi geome
e if you get a multipolygon ot a collection as the result.
-Steve W
Düster Horst wrote:
>
> Regina
>
> Thank you for your response. Mmmm.. your trick doesn't solve my
problem.
> Perhaps I should tell you why I do have a geometrycollection. My
> startingpoint is a sequenc
I do have a Geometrycollection which consists of a collection of
Multipolygons and Polygons. My aim is to create one single Multipolygon
from the mentioned Geometry collection.
Until now I tried the following steps without result:
1. ST_BUFFER(GEOMCOLL,0.0) => It works but all inner rings of my i
24 matches
Mail list logo
