{"id":42747,"date":"2019-06-27T09:08:52","date_gmt":"2019-06-27T07:08:52","guid":{"rendered":"https:\/\/mamchenkov.net\/wordpress\/?p=42747"},"modified":"2019-06-27T09:38:18","modified_gmt":"2019-06-27T07:38:18","slug":"calculating-distance-using-mysql","status":"publish","type":"post","link":"https:\/\/mamchenkov.net\/wordpress\/2019\/06\/27\/calculating-distance-using-mysql\/","title":{"rendered":"Calculating distance using MySQL"},"content":{"rendered":"\n\n
\"\"<\/figure>\n\n\n\n

“Calculating distance using MySQL<\/a>” is a very useful blog post for everyone who works with geographical location data and MySQL. It shows a simple example of how to calculate the distance between two coordinates on a sphere (Earth in particular) within the MySQL itself.<\/p>\n\n\n

\nSELECT ST_Distance_Sphere(\n    point(-87.6770458, 41.9631174),\n    point(-73.9898293, 40.7628267)\n);\n<\/pre><\/div>\n\n\n
The above will return 1148978.6738241839, which is the distance between the two points in meters.<\/p>\n\n\n\n
This functionality is available since MySQL 5.7.  Have a look at the documentation of the spacial convenience functions<\/a>.<\/p>\n\n\n\n
MariaDB has similar functionality, but with a slightly different function names.  Use ST_DISTANCE()<\/a> instead of ST_Distance_Sphere().  Have a look at this blog post<\/a> for more details.<\/p>\n\n","protected":false},"excerpt":{"rendered":"\n
“Calculating distance using MySQL” is a very useful blog post for everyone who works with geographical location data and MySQL. It shows a simple example of how to calculate the distance between two coordinates on a sphere (Earth in particular) within the MySQL itself. The above will return 1148978.6738241839, which is the distance between the … Continue reading Calculating distance using MySQL<\/span><\/a><\/p>\n\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"Calculating distance using MySQL #WebDev #MySQL #databases #maps #navigation","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"jetpack_post_was_ever_published":false,"_links_to":"","_links_to_target":""},"categories":[1,18,62,1334],"tags":[1559,87,3066,1184,1330],"keyring_services":[],"class_list":["post-42747","post","type-post","status-publish","format-standard","hentry","category-general","category-programming","category-technology","category-web-work","tag-databases","tag-maps","tag-mysql","tag-navigation","tag-web-development"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t