Search posts between two coordinates

• 

  • fmaso

  • May 15, 2016 at 11:06 pm

  Hello,
  I’m using ACF plugin in one WordPress theme, with a custom post named ‘listings’, every listing has a Google map ACF field called ‘location’ i see that the plugin save the informations in the database like this:

  meta_key: location
  meta_value: Bormio | 46.4663571,10.370467100000042

  Now i would like to show a list of listings between a range of coordinates starting from the two saved in the single listing location:

  For example:
  In the single post page that show the info about listing called Bormio i want to show a list of listings that have coordinates between this two coordinates
  46.7663571( the result of 46.4663571 + 0.3 ) and 10.670467100000042 ( the result of 10.370467100000042 + 0.3 )

  So i tried a lot of code solutions but i haven’t found the correct one.

  Do you have some solution to porpose to me?

  Thanks.
• 

  

  • James

  • May 16, 2016 at 4:15 pm

  Hi @fmaso

  I believe you can do it by using the coordinates, but you need to know how latitude and longitude works. For something like that, I believe Google Map support forum is a better place to ask that thing.

  After you get the right method, you can use it to query the custom posts or use wpdb if it’s not possible.

  I hope this makes sense. Thanks 🙂