我有一个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;
我遇到了这个错误:
错误: GEOSIntersects: TopologyException: 在-122.42466 47.085999999999999处发生了边界冲突
有谁能指出我在这里做错了什么吗?