Re: [postgis-users] English please (was: Get parallel some route.)

2015-02-03 Thread Rémi Cura 
/*french version at the end*/
Ok I think I found the problem :
your geometry are not simple, that is in postgis langage, there is no
selfintersection.
Your lines have tone of selfintersection , which is forbiden (because GEOS
does topological computation)!

So now of to fixe this : use this function

to transform your non-simple (multi)line into multiline where each line
inside is simple.
You code becomes :

SELECT objectid, nom, code
, ST_OffsetCurve(dmp.geom, 25, 'quad_segs=4 join=round') as
offseted_linestring
FROM web.trs_itineraire , st_Dump(rc_MakeSimple(shape)) as dmp
WHERE code = '06-20B'

It execute successfully (now does it do what you expect, I don't know)
(tested on the data you shared, no translation, no snapping)
Cheers,
Rémi-C

 French version 

J'ai trouvé le problème je pense.
En fait les géométries ne sont pas simple au sens de PostGIS, c'est à dire
"qui ne s'autointersecte pas".
Cela est interdit et cause les erreurs de GEOS (qui fait du calcul
topologique).

Maintenant la solution pour régler simplement le problème :
utiliser cette fonction

pour passer de (multi)lignes avec des autointersections à des multilignes
dont chaque lignes composante ne s'autointersecte pas.

Du coup,
votre code devient :
SELECT objectid, nom, code
, ST_OffsetCurve(dmp.geom, 25, 'quad_segs=4 join=round') as
offseted_linestring
FROM web.trs_itineraire , st_Dump(rc_MakeSimple(shape)) as dmp
WHERE code = '06-20B'

La requete s'execute sans erreurs (après le résultat ne sera pas
nécessairement ce que vous attendez, mais c'est une autre histoire).
(testé sur les données que vous avez partagées, sans translation ni
snapping).

Salutations,
Rémi-C

2015-02-03 9:12 GMT+01:00 Sandro Santilli :

> On Sun, Feb 01, 2015 at 08:46:16PM +0100, Rémi Cura wrote:
>
> > We are coming closer to a GEOS or PostGIS bug.
>
> Please use the bug tracker for these, thanks.
>
> --strk;
> ___
> postgis-users mailing list
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] English please (was: Get parallel some route.)

2015-02-03 Thread Sandro Santilli 
On Sun, Feb 01, 2015 at 08:46:16PM +0100, Rémi Cura wrote:

> We are coming closer to a GEOS or PostGIS bug.

Please use the bug tracker for these, thanks.

--strk;
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] English please (was: Get parallel some route.)

2015-02-01 Thread Rémi Cura 
Hey Sandro, glad you come here, I'm running out of ideas.
Sometime English is not an option for everybody ;-)

We are coming closer to a GEOS or PostGIS bug.

So here is the summary,
 - Using about 250 linestring, trying to use the st_offsetcurve function
 - lines are simple, valid, snapped to grid, translated to increase
precision
 - the function fails and return

** Erreur **
ERROR: GEOSOffsetCurve: TopologyException: assigned depths do not match at
69544.468193216031 50450.347638143896
État SQL :XX000


 - the data is available here : http://guigui182.free.fr/travail/export.zip
 - postgis version is  : "PostgreSQL 9.2.2, compiled by Visual C++ build
1600, 64-bit POSTGIS="2.0.4" GEOS="3.4.2-CAPI-1.8.2 r0" PROJ="Rel. 4.8.0, 6
March 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.7.8"
LIBJSON="UNKNOWN" (core procs from "2.0.4" need upgrade) RASTER (raster
procs from "2.0.4" need upgrade)"


2015-01-29 22:44 GMT+01:00 Robert Coup :

> Hi Sandro,
>
> On Fri, Jan 30, 2015 at 9:13 AM, Sandro Santilli  wrote:
>
>> May I ask everyone to use simple english when writing on the mailing list
>> ?
>> It easily become noisy otherwise.
>>
>
> My 2c: I'm happy with non-English threads if people get their problems
> solved faster - Google Translate is wonderful, which means I can read the
> messages in gmail in English by clicking the a button. And ignoring it is
> just like ignoring any other thread that I'm not interested in.
>
> Rémi also provided an English summary, which is helpful for the archives &
> future searchers.
>
> Rob :)
>
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

Re: [postgis-users] English please (was: Get parallel some route.)

2015-01-29 Thread Robert Coup 
Hi Sandro,

On Fri, Jan 30, 2015 at 9:13 AM, Sandro Santilli  wrote:

> May I ask everyone to use simple english when writing on the mailing list ?
> It easily become noisy otherwise.
>

My 2c: I'm happy with non-English threads if people get their problems
solved faster - Google Translate is wonderful, which means I can read the
messages in gmail in English by clicking the a button. And ignoring it is
just like ignoring any other thread that I'm not interested in.

Rémi also provided an English summary, which is helpful for the archives &
future searchers.

Rob :)
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users

[postgis-users] English please (was: Get parallel some route.)

2015-01-29 Thread Sandro Santilli 
May I ask everyone to use simple english when writing on the mailing list ?
It easily become noisy otherwise.
Thanks.

--strk;
___
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users