[postgis-users] st_offsetcurve

[franco base]

Hi Sandro,
thank you for your answer,
I'll upgrade my GEOS, but I work for a Public Administration and this
process is slow.

So I have Isolated the geometry wher St_OffsetCurve crash.
There are two type of geometries:

1) Geometry with repeated points. I can solve the problem using:
 St_OffsetCurve (ST_RemoveRepeatedPoints(geom), 10)


2) Geomtery with repeated points but non consequential (see the .jpg)

The geometry is
"0102000020BB0B000013000000F49BB3FCAA3037413033606B9C3253412FD60B7D61303741EDE29F4E9B3253416842DD0745303741DD30E3C89A3253417776B8621830374149B42AE399325341EDC13D130430374122AE490A983253415FAF500FFC2F37410A84A0DD943253415500A09BFE2F3741D62BEB178532534166ECD670FF2F3741F01372E67A3253417713ABF605303741CE2AF9FC77325341BBA13CB0283037415C422E6F713253410B10133F2E303741256D85F770325341A024E9F33330374115D50563713253414B75A9D4363037419868B9B8723253410DFDE549353037415AF87C3177325341CAF46320303037411170B9E88F325341536848BF2F30374135F86EA19532534180088DD2363037417D62C985983253416842DD0745303741DD30E3C89A3253412FD60B7D61303741EDE29F4E9B325341"

(st_dumppoints(geom)).geom  give this output:

1;"0101000020BB0B0000F49BB3FCAA3037413033606B9C325341"
2;"0101000020BB0B00002FD60B7D61303741EDE29F4E9B325341"
3;"0101000020BB0B00006842DD0745303741DD30E3C89A325341"
4;"0101000020BB0B00007776B8621830374149B42AE399325341"
5;"0101000020BB0B0000EDC13D130430374122AE490A98325341"
6;"0101000020BB0B00005FAF500FFC2F37410A84A0DD94325341"
7;"0101000020BB0B00005500A09BFE2F3741D62BEB1785325341"
8;"0101000020BB0B000066ECD670FF2F3741F01372E67A325341"
9;"0101000020BB0B00007713ABF605303741CE2AF9FC77325341"
10;"0101000020BB0B0000BBA13CB0283037415C422E6F71325341"
11;"0101000020BB0B00000B10133F2E303741256D85F770325341"
12;"0101000020BB0B0000A024E9F33330374115D5056371325341"
13;"0101000020BB0B00004B75A9D4363037419868B9B872325341"
14;"0101000020BB0B00000DFDE549353037415AF87C3177325341"
15;"0101000020BB0B0000CAF46320303037411170B9E88F325341"
16;"0101000020BB0B0000536848BF2F30374135F86EA195325341"
17;"0101000020BB0B000080088DD2363037417D62C98598325341"
18;"0101000020BB0B00006842DD0745303741DD30E3C89A325341"
19;"0101000020BB0B00002FD60B7D61303741EDE29F4E9B325341"


You can see that n.3 and n.18 point have the same geometry.


You think that GEOS-3.3.9, or 3.4.2. solve this problem or this is a "bug"
of the St_OffsetCurve.

Thanks

regards
fb



2013/10/4 Sandro Santilli <strk at keybit.net>

> On Fri, Oct 04, 2013 at 01:13:48PM +0200, franco base wrote:
> > I resum this post (new offset in my life).
> > I try the select on that geometry using
> >
> > "POSTGIS="2.0.3 r11128" GEOS="3.3.8-CAPI-1.7.8" PROJ="Rel. 4.8.0, 6 March
> > 2012" GDAL="GDAL 1.10.0, released 2013/04/24" LIBXML="2.8.0"
> >
> > LIBJSON="UNKNOWN" (core procs from "2.0.1 r9979" need upgrade) RASTER
> > (raster procs from "2.0.1 r9979" need upgrade)"
> >
> >
> > And the error is
> >
> > ERROR: GEOSOffsetCurve: IllegalArgumentException: RobustDeterminant
> > encountered non-finite numbers SQL state: XX000.
> >
> >
> > Sandro I don't undesrtand if you have the same errror or if it works.
>
> I haven't tried it, but I know there have been fixes in GEOS about that.
> Try with GEOS-3.3.9, or 3.4.2.
> Let us know.
>
> Besides, your postgis version string is telling you that the upgrade to
> 2.0.3 wasn't completed successfully. See if you can find the scripts
> postgis_upgrade_20_minor.sql and rtpostgis_upgrade_20_minor.sql and load
> them both to fix that.
>
> --strk;
> _______________________________________________
> postgis-users mailing list
> postgis-users at lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131004/f400ec27/attachment.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: arc.jpg
Type: image/jpeg
Size: 4411 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20131004/f400ec27/attachment.jpg>