postgis学习

 

-- 如果实在找不到主键可以用ctid当主键

select * from bd_poi_son114 where id in(
select min(ctid)
from bd_poi_son114 where tag='房地产;写字楼' group by uid)

ST_GeomFromText('LINESTRING(-95.40 29.77,72.82 19.07)'),
'SPHEROID["GRS_1980",6378137,298.257222101]'
);