用给定经纬度求一定距离内相交的国家时,使用下面查询语句:
SELECT * from country WHERE ST_Intersects(the_geom,st_buffer(st_geomfromewkt('SRID=3857;point(0 0)'), 1000000));
抛出一下错误:
ERROR: GEOSIntersects: IllegalArgumentException: RobustDeterminant encountered non-finite numbers
查看数据后得出结论,在此记录:
由于数据是从4326重投影到3857,过程中南极洲变形严重,超出实际坐标范围,删除南极洲或对南极洲做裁剪可解决此问题