Changes between Version 58 and Version 59 of BldgsGeomMisc


Ignore:
Timestamp:
Sep 22, 2019, 8:37:22 PM (5 years ago)
Author:
darkblueb
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • BldgsGeomMisc

    v58 v59  
    256256PostgreSQL 10.10 (Ubuntu 10.10-0ubuntu0.18.04.1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 7.4.0-1ubuntu1~18.04.1) 7.4.0, 64-bit
    257257 POSTGIS="2.5.2 r17328" [EXTENSION] PGSQL="100" GEOS="3.7.1-CAPI-1.11.1 27a5e771" PROJ="Rel. 5.2.0, September 15th, 2018" GDAL="GDAL 2.4.2, released 2019/06/28" LIBXML="2.9.4" LIBJSON="0.12.1" LIBPROTOBUF="1.2.1" RASTER
     258
     259}}}
     260
     261
     262**PostGIS 2.3 | GEOS 3.8dev |**  refvalid **MATCH**
     263{{{
     264user=# select pkey, refvalid, st_isValid(geom) from valids_delft ;
     265NOTICE:  Self-intersection at or near point 163.39202965708989 235.00834105653382
     266NOTICE:  Hole lies outside shell at or near point 130 292
     267NOTICE:  Interior is disconnected at or near point 170 170
     268NOTICE:  Interior is disconnected at or near point 170 170
     269NOTICE:  Self-intersection at or near point 200 201.76470588235293
     270NOTICE:  Self-intersection at or near point 200 202
     271NOTICE:  Holes are nested at or near point 180 200
     272NOTICE:  Self-intersection at or near point 200 210
     273NOTICE:  Self-intersection at or near point 219.6352644836272 111.99294710327453
     274NOTICE:  Self-intersection at or near point 129.99999999999989 210.99999999999991
     275NOTICE:  Self-intersection at or near point 212.95837780046392 99.000086530632473
     276 pkey | refvalid | st_isvalid
     277------+----------+------------
     278    1 | Valid    | t
     279    2 | Valid    | t
     280    3 | Valid    | t
     281    4 | Valid    | t
     282    5 | Valid    | t
     283    7 | Valid    | t
     284    6 | Valid    | t
     285    8 | Valid    | t
     286    9 | Valid    | t
     287   11 | Valid    | t
     288   12 | Valid    | t
     289   13 | Invalid  | f
     290   14 | Invalid  | f
     291   15 | Valid    | t
     292   16 | Valid    | t
     293   17 | Valid    | t
     294   18 | Valid    | t
     295   19 | Valid    | t
     296   20 | Invalid  | f
     297   21 | Invalid  | f
     298   22 | Invalid  | f
     299   23 | Invalid  | f
     300   24 | Invalid  | f
     301   25 | Invalid  | f
     302   26 | Valid    | t
     303   27 | Valid    | t
     304   28 | Valid    | t
     305   29 | Valid    | t
     306   30 | Invalid  | f
     307   31 | Valid    | t
     308   32 | Invalid  | f
     309   33 | Valid    | t
     310   34 | Valid    | t
     311   35 | Invalid  | f
     312   36 | Valid    | t
     313(35 rows)
     314
     315--
     316PostgreSQL 9.5.14 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
     317POSTGIS="2.3.2 r15302" GEOS="3.8.0dev-CAPI-1.12.0 " PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.3" LIBJSON="0.11.99" RASTER
    258318
    259319}}}
    … …  
    319379**PostGIS 2.4 | GEOS 3.6.2 |**  refvalid **MATCH**
    320380{{{
    321 dbb=#  select pkey, refvalid, st_isValid(geom) from valids_delft ;
    322 NOTICE:  Self-intersection at or near point 163.39202965708989 235.00834105653382
    323 NOTICE:  Hole lies outside shell at or near point 130 292
    324 NOTICE:  Interior is disconnected at or near point 170 170
    325 NOTICE:  Interior is disconnected at or near point 170 170
    326 NOTICE:  Self-intersection at or near point 200 201.76470588235293
    327 NOTICE:  Self-intersection at or near point 200 202
    328 NOTICE:  Holes are nested at or near point 180 200
    329 NOTICE:  Self-intersection at or near point 200 210
    330 NOTICE:  Self-intersection at or near point 219.6352644836272 111.99294710327453
    331 NOTICE:  Self-intersection at or near point 129.99999999999989 210.99999999999991
    332 NOTICE:  Self-intersection at or near point 212.95837780046392 99.000086530632473
    333  pkey | refvalid | st_isvalid
    334 ------+----------+------------
    335     1 | Valid    | t
    336     2 | Valid    | t
    337     3 | Valid    | t
    338     4 | Valid    | t
    339     5 | Valid    | t
    340     7 | Valid    | t
    341     6 | Valid    | t
    342     8 | Valid    | t
    343     9 | Valid    | t
    344    11 | Valid    | t
    345    12 | Valid    | t
    346    13 | Invalid  | f
    347    14 | Invalid  | f
    348    15 | Valid    | t
    349    16 | Valid    | t
    350    17 | Valid    | t
    351    18 | Valid    | t
    352    19 | Valid    | t
    353    20 | Invalid  | f
    354    21 | Invalid  | f
    355    22 | Invalid  | f
    356    23 | Invalid  | f
    357    24 | Invalid  | f
    358    25 | Invalid  | f
    359    26 | Valid    | t
    360    27 | Valid    | t
    361    28 | Valid    | t
    362    29 | Valid    | t
    363    30 | Invalid  | f
    364    31 | Valid    | t
    365    32 | Invalid  | f
    366    33 | Valid    | t
    367    34 | Valid    | t
    368    35 | Invalid  | f
    369    36 | Valid    | t
    370 (35 rows)
    371 
    372 --
    373381 PostgreSQL 10.10 (Ubuntu 10.10-1.pgdg16.04+1) on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.11) 5.4.0 20160609, 64-bit
    374382 POSTGIS="2.4.3" PGSQL="100" GEOS="3.6.2-CAPI-1.10.2 4d2925d6" SFCGAL="1.3.0" PROJ="Rel. 4.9.3, 15 August 2016" LIBXML="2.9.3" LIBJSON="0.11.99" LIBPROTOBUF="1.2.1"
    375 
    376 }}}
    377 
    378 **PostGIS 2.3 | GEOS 3.8dev |**  refvalid **MATCH**
    379 {{{
    380 user=# select pkey, refvalid, st_isValid(geom) from valids_delft ;
    381 NOTICE:  Self-intersection at or near point 163.39202965708989 235.00834105653382
    382 NOTICE:  Hole lies outside shell at or near point 130 292
    383 NOTICE:  Interior is disconnected at or near point 170 170
    384 NOTICE:  Interior is disconnected at or near point 170 170
    385 NOTICE:  Self-intersection at or near point 200 201.76470588235293
    386 NOTICE:  Self-intersection at or near point 200 202
    387 NOTICE:  Holes are nested at or near point 180 200
    388 NOTICE:  Self-intersection at or near point 200 210
    389 NOTICE:  Self-intersection at or near point 219.6352644836272 111.99294710327453
    390 NOTICE:  Self-intersection at or near point 129.99999999999989 210.99999999999991
    391 NOTICE:  Self-intersection at or near point 212.95837780046392 99.000086530632473
    392  pkey | refvalid | st_isvalid
    393 ------+----------+------------
    394     1 | Valid    | t
    395     2 | Valid    | t
    396     3 | Valid    | t
    397     4 | Valid    | t
    398     5 | Valid    | t
    399     7 | Valid    | t
    400     6 | Valid    | t
    401     8 | Valid    | t
    402     9 | Valid    | t
    403    11 | Valid    | t
    404    12 | Valid    | t
    405    13 | Invalid  | f
    406    14 | Invalid  | f
    407    15 | Valid    | t
    408    16 | Valid    | t
    409    17 | Valid    | t
    410    18 | Valid    | t
    411    19 | Valid    | t
    412    20 | Invalid  | f
    413    21 | Invalid  | f
    414    22 | Invalid  | f
    415    23 | Invalid  | f
    416    24 | Invalid  | f
    417    25 | Invalid  | f
    418    26 | Valid    | t
    419    27 | Valid    | t
    420    28 | Valid    | t
    421    29 | Valid    | t
    422    30 | Invalid  | f
    423    31 | Valid    | t
    424    32 | Invalid  | f
    425    33 | Valid    | t
    426    34 | Valid    | t
    427    35 | Invalid  | f
    428    36 | Valid    | t
    429 (35 rows)
    430 
    431 --
    432 PostgreSQL 9.5.14 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 5.4.0-6ubuntu1~16.04.10) 5.4.0 20160609, 64-bit
    433 POSTGIS="2.3.2 r15302" GEOS="3.8.0dev-CAPI-1.12.0 " PROJ="Rel. 4.9.2, 08 September 2015" GDAL="GDAL 2.1.3, released 2017/20/01" LIBXML="2.9.3" LIBJSON="0.11.99" RASTER
    434 
    435 }}}
     383}}}
     384