Re: [postgis-users] Closed linestring is not closed?

2012-06-19 Thread georgew 
Hi all, I am seriously embarassed, I cannot reproduce the problem, I have no
idea why earlier I kept getting a false result, and not now, I can only
apologise for the false alarm. 
G.


--
View this message in context: 
http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998311p4998383.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Closed linestring is not closed?

2012-06-18 Thread Nicolas Ribot 
Hi,

Returns true here
(POSTGIS=2.0.0 GEOS=3.3.2-CAPI-1.7.2 PROJ=Rel. 4.7.1, 23
September 2009 LIBXML=2.7.8 USE_STATS (procs from 2.0 r7948 need
upgrade) On Mac OS X

Whats your version ?

Nicolas


On 16 June 2012 09:11, georgew gws...@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
 537,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 537,1581855.1284829 537)')

 --
 View this message in context: 
 http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998311.html
 Sent from the PostGIS - User mailing list archive at Nabble.com.
 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Closed linestring is not closed?

2012-06-18 Thread Paul Ramsey 
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 gws...@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
 537,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 537,1581855.1284829 537)')

 --
 View this message in context: 
 http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998311.html
 Sent from the PostGIS - User mailing list archive at Nabble.com.
 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

Re: [postgis-users] Closed linestring is not closed?

2012-06-18 Thread 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-boun...@postgis.refractions.net 
 [mailto:postgis-users-boun...@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 gws...@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
  537,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 537,1581855.1284829 537)')
 
  --
  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@postgis.refractions.net
  http://postgis.refractions.net/mailman/listinfo/postgis-users
 ___
 postgis-users mailing list
 postgis-users@postgis.refractions.net
 http://postgis.refractions.net/mailman/listinfo/postgis-users
 


___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users

[postgis-users] Closed linestring is not closed?

2012-06-16 Thread georgew 
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
537,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 537,1581855.1284829 537)')

--
View this message in context: 
http://postgis.17.n6.nabble.com/Closed-linestring-is-not-closed-tp4998311.html
Sent from the PostGIS - User mailing list archive at Nabble.com.
___
postgis-users mailing list
postgis-users@postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users