Skip to content

Instantly share code, notes, and snippets.

@renoinn

renoinn/st_distance_sphere.md

Created August 25, 2020 15:31
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save renoinn/7439c0a854d77fcb09a565d5f9c79092 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save renoinn/7439c0a854d77fcb09a565d5f9c79092 to your computer and use it in GitHub Desktop.
Download ZIP
ST_Distance_Sphereの使い方
Raw
st_distance_sphere.md

lat:35.67679460, lng:139.73726860から1000メートル以内のresultを取得するクエリ

SELECT * FROM place WHERE st_distance_sphere(POINT(139.73726860,35.67679460),POINT(lng,lat)) <= 1000
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment