mvn clean deploy -P release


SELECT areaid,earth_distance( ll_to_earth(29.295345,106.260376),ll_to_earth(latitude, longitude))  as distancefromcurretnlocation
,id, adddate, address, gps, lastdate, latitude, longitude, name, 
       phone, website, userid
  FROM shop  where shop.areaid=408
ORDER BY distancefromcurretnlocation asc limit 100;

CREATE INDEX gisindex on shop USING gist(ll_to_earth(latitude, longitude));



select getDistance(108.95678,34.2775,shop.longitude,shop.latitude) as l,  shop.* from shop  order by l desc limit 100