Changes between Version 48 and Version 49 of BldgsGeomMisc


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

--

Legend:

Unmodified
Added
Removed
Modified
  • BldgsGeomMisc

    v48 v49  
    306306
    307307}}}
     308
     309{{{
     310 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
     311
     312 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"
     313
     314dbb=#  select pkey, refvalid, st_isValid(geom) from valids_delft ;
     315NOTICE:  Self-intersection at or near point 163.39202965708989 235.00834105653382
     316NOTICE:  Hole lies outside shell at or near point 130 292
     317NOTICE:  Interior is disconnected at or near point 170 170
     318NOTICE:  Interior is disconnected at or near point 170 170
     319NOTICE:  Self-intersection at or near point 200 201.76470588235293
     320NOTICE:  Self-intersection at or near point 200 202
     321NOTICE:  Holes are nested at or near point 180 200
     322NOTICE:  Self-intersection at or near point 200 210
     323NOTICE:  Self-intersection at or near point 219.6352644836272 111.99294710327453
     324NOTICE:  Self-intersection at or near point 129.99999999999989 210.99999999999991
     325NOTICE:  Self-intersection at or near point 212.95837780046392 99.000086530632473
     326 pkey | refvalid | st_isvalid
     327------+----------+------------
     328    1 | Valid    | t
     329    2 | Valid    | t
     330    3 | Valid    | t
     331    4 | Valid    | t
     332    5 | Valid    | t
     333    7 | Valid    | t
     334    6 | Valid    | t
     335    8 | Valid    | t
     336    9 | Valid    | t
     337   11 | Valid    | t
     338   12 | Valid    | t
     339   13 | Invalid  | f
     340   14 | Invalid  | f
     341   15 | Valid    | t
     342   16 | Valid    | t
     343   17 | Valid    | t
     344   18 | Valid    | t
     345   19 | Valid    | t
     346   20 | Invalid  | f
     347   21 | Invalid  | f
     348   22 | Invalid  | f
     349   23 | Invalid  | f
     350   24 | Invalid  | f
     351   25 | Invalid  | f
     352   26 | Valid    | t
     353   27 | Valid    | t
     354   28 | Valid    | t
     355   29 | Valid    | t
     356   30 | Invalid  | f
     357   31 | Valid    | t
     358   32 | Invalid  | f
     359   33 | Valid    | t
     360   34 | Valid    | t
     361   35 | Invalid  | f
     362   36 | Valid    | t
     363(35 rows)
     364
     365 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"
     366
     367
     368}}}