PostGIS 查询点在线上

SELECT id FROM fm where st_intersects(st_transform(st_buffer(st_transform(st_geomfromtext(‘point(12989691.512 4798962.444)‘,3857),3857),1),3857),geom) ;
--如果坐标系统一，不用transform也可以
SELECT id FROM fm where st_intersects(st_buffer(st_geomfromtext(‘point(12989691.512 4798962.444)‘),0.0001),geom) ;

--geometry（例：0101000000D34D62709FC66841FA7E6A9C7C4E5241）
SELECT id FROM fm where st_intersects(st_buffer(‘0101000000D34D62709FC66841FA7E6A9C7C4E5241‘,0.0001),geom) ;

--带业务逻辑
select t.gid,t.geom from fm t where t.gid  in (
          select a.gid from fm a,(select c.* from zy c where c.gid = up_temprow.gid) b where ST_intersects(a.geom,b.geom) 
        )
--简化
select t.gid,t.geom from fm t where t.gid  in (
          select a.gid from fm a,zy b where ST_intersects(a.geom,b.geom) 
        )