[postgis-users] Closed linestring is not closed?

[Paragon Corporation]

It's not a win64 issue.  My Windows 2008 64-bit 9.1 shows this as closed as
well.

George, 
Are you sure this is the actual geometry you were testing with and not the
ST_AsText of it?  I suspect you have some long digits making this not
closed.  Can you please verify this does register as not closed.

If so please provide the 

SELECT version();

and SELECT postgis_full_version();

Regina
http://www.postgis.us




> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of Paul Ramsey
> Sent: Monday, June 18, 2012 11:57 AM
> To: PostGIS Users Discussion
> Subject: Re: [postgis-users] Closed linestring is not closed?
> 
> It returns true for me on OSX64. This is probably another Win64 quirk.
> I wonder why that platform has so many more oddities than win32.
> P.
> 
> On Sat, Jun 16, 2012 at 12:11 AM, georgew <gws293 at hotmail.com> wrote:
> > The following linestring which I believed to be closed, and looks 
> > closed, in fact gives me false in reply to st_isclosed(geom).
> > It's probably something very simple which is eluding me but 
> I am at a 
> > loss why I get this result. I am using postgis 2.0, Win 7 64.
> > Any suggestions?.
> > Thank you
> >
> > select ST_GeomFromEWKT ('SRID=2193;LINESTRING(1581855.1284829
> > 5370000,1581884.80445 5369966.19158,1581887.30288
> > 5369961.19296,1581902.69023 5369908.80888,1581907.78739
> > 5369901.31078,1581945.46961 5369869.11694,1582053.42388
> > 5369814.82165,1582068.01672 5369800.32473,1582058.81757
> > 5369782.83187,1582041.22099 5369762.24115,1582016.32738
> > 5369744.55038,1582008.82968 5369741.95223,1581956.34859
> > 5369744.1582,1581886.27473 5369753.66394,1581876.27826
> > 5369753.56525,1581858.78411 5369750.96838,1581848.78695
> > 5369745.8714,1581826.49107 5369718.28368,1581829.1853
> > 5369683.29527,1581789.4928 5369635.51667,1581784.59315
> > 5369625.42075,1581782.09266 5369615.42448,1581782.19125
> > 5369605.42788,1581762.49236 5369562.74497,1581757.49345
> > 5369557.74732,1581727.60161 5369540.0572,1581717.6048
> > 5369537.45937,1581690.11486 5369539.76211,1581654.93006
> > 5369559.55987,1581644.93496 5369569.45777,1581639.8378
> > 5369576.95587,1581612.24962 5369591.75436,1581597.25527
> > 5369594.15546,1581584.66075 5369601.55455,1581569.56816
> > 5369616.4514,1581567.06973 5369621.45002,1581564.37413
> > 5369646.44183,1581581.67146 5369671.63101,1581614.16168
> > 5369684.32251,1581626.55902 5369696.91662,1581628.95886
> > 5369701.9146,1581628.95989 5369709.41204,1581626.36184
> > 5369716.90982,1581603.67538 5369756.79911,1581598.57889
> > 5369769.19553,1581595.8826 5369789.18905,1581558.00391
> > 5369846.47434,1581532.81696 5369876.36736,1581527.72047
> > 5369888.76378,1581522.42785 5369928.75081,1581494.84072
> > 5369951.1467,1581492.24266 5369958.5445,1581492.04687
> > 5369988.63425,1581488.15835779 5370000,1581855.1284829 5370000)')
> >
> > --
> > View this message in context: 
> > 
> http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998
> > 311.html Sent from the PostGIS - User mailing list archive at 
> > Nabble.com.
> > _______________________________________________
> > 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
>