sql - 错误 : GEOSIntersects: TopologyException: side location conflict

Question

我有 PostgreSQL 9.2.4。这是我用来找出一些几何交集结果的表格:

             Column              |           Type           | Modifiers 
---------------------------------+--------------------------+-----------
 id                              | integer                  | 
 full_resolution                 | character varying(2000)  | 
 full_resolution_path            | character varying(256)   | 
 feature_id                      | text                     | 
 full_resolution_initiated_order | character varying(64)    | 
 true_image_feature_footprint_id | integer                  | 
 true_image_tile_footprint_id    | integer                  | 
 full_resolution_time_created    | timestamp with time zone | 
 feature_geom                    | geometry                 | 
 tile_geom                       | geometry                 | 

现在查询:

create Temp table temp4_test as
select id, ST_Intersects(feature_geom,tile_geom),full_resolution
     , full_resolution_path, feature_id, full_resolution_initiated_order
     , true_image_feature_footprint_id, true_image_tile_footprint_id
     , full_resolution_time_created
from temp3_test;

给我这个错误:

ERROR: GEOSIntersects: TopologyException: side location conflict at -122.42466 47.085999999999999

谁能指出我在这里做错了什么？

Answer 1

我找到了“Martin Davis”的答案in this thread :

This occurs because the geometries are invalid, and the current intersects algorithm used in JTS/GEOS has kittens when invalid geometries are used as input. The core dump thing is unfortunate (and obviously got fixed in later versions).

显然，相同的无效数据在 PostGis v1.5 中导致核心转储，但在 v2.0 中引发异常