本文共 1427 字,大约阅读时间需要 4 分钟。
转自:
postgresql计算两点距离
jpa中写法,加上::geography转化经纬度的坐标计算,\\作为转译符
@Query(value = "select f from bc_contact f where f.data_end='2' and " + " ST_Distance(ST_SetSRID(f.point,4326)\\:\\:geography," + " ST_SetSRID(ST_MakePoint(:lon,:lat),4326)\\:\\:geography) < :distance ",nativeQuery = true) ListnearbyList(@Param("lon") double lon,@Param("lat") double lat,@Param("distance") double distance) ;
下面两种方法:
select
ST_Distance( ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326)::geography, ST_SetSRID(ST_MakePoint(106.00231199774656,29.719258550486572),4326)::geography ), ST_Length( ST_MakeLine( ST_MakePoint(115.97166453999147,28.716493914230423), ST_MakePoint(106.00231199774656,29.719258550486572) )::geography ) 备注:ST_GeomFromText('LINESTRING(115.97166453999147 28.716493914230423,106.00231199774656 29.719258550486572)')与
ST_MakeLine( ST_MakePoint(115.97166453999147,28.716493914230423), ST_MakePoint(106.00231199774656,29.719258550486572) )等价ST_GeomFromText('POINT(115.97166453999147 28.716493914230423)',4326)与
ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326)等价ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326)::geography与
Geography(ST_SetSRID(ST_MakePoint(115.97166453999147,28.716493914230423),4326))、 ST_GeographyFromText('SRID=4326;POINT(115.97166453999147 28.716493914230423)')等价 (::geography是postgis中的转换类型语法,把geometry转成geography)
转载地址:http://mradi.baihongyu.com/