# [postgis-users] Splitting a polygon.

Kevin Neufeld kneufeld at refractions.net
Mon Jan 25 08:03:17 PST 2010

```No problem at all.  By the way, great job with how you asked for help.  You had a clear example script and stated the
results and what you expected to see.  It made debugging the problem scenario a whole lot simpler.  Kudos!

Cheers,
Kevin

On 1/25/2010 6:53 AM, Paul Moen wrote:
> Thanks. I stared at that for so long I couldn't see the answer.
>
> On Jan 25, 2010, at 12:21 AM, Kevin Neufeld wrote:
>
>> No, not a bug.  It looks like you have a gap in your split line of 10^-5, which obviously disappears when you reduce the precision.
>>
>> At coordinates
>> (1972865.08581219 378326.311285453)
>> (1972865.08581219 378326.311279507)
>>
>> Cheers,
>> Kevin
>>
>> On 1/24/2010 5:19 PM, Paul moen wrote:
>>> I made a much more simplified version of what I am trying to do.  I am using PostgreSQL 8.4.2 and POSTGIS="1.4.1" GEOS="3.2.0-CAPI-1.6.0" PROJ="Rel. 4.7.1, 23 September 2009"
>>>
>>> I create the table testlines as follows
>>>
>>> CREATE TABLE testlines
>>> (
>>> gid integer,
>>> the_geom geometry
>>> )
>>> WITH (OIDS=TRUE);
>>> ALTER TABLE testlines OWNER TO postgres;
>>> INSERT INTO testlines(gid, the_geom) VALUES (1, st_geomfromtext('LINESTRING(1972865.08581219 378326.311285453,1975599.79273051 379853.261981628)',-1));
>>> INSERT INTO testlines(gid, the_geom) VALUES (2, st_geomfromtext('LINESTRING(1972773.34674946 377707.210612508,1972913.11215175 377573.688032513)',-1));
>>> INSERT INTO testlines(gid, the_geom) VALUES (3, st_geomfromtext('LINESTRING(1972765.56033513 378288.726667813,1972865.08581219 378326.311279507)',-1));
>>> INSERT INTO testlines(gid, the_geom) VALUES (4, st_geomfromtext('LINESTRING(1972865.08581219 378326.311279507,1972817.2530921 378237.264198899)',-1));
>>> ...
>>> Is this a bug?
>>>
>>> _______________________________________________
>>> postgis-users mailing list
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at postgis.refractions.net
>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users

```