latitude/longitude meta_query

In both examples, you are searching between 'max' and 'min', where it should be between 'min' and 'max':

array( $dist['max_latitude'], $dist['min_latitude'] )

'value' => $dist['max_latitude'], 'compare' => '>=');
'value' => $dist['min_latitude'], 'compare' => '<=');

Both mean:

“Search for a value that ist greater than max_latitude and less than min_latitude”

Another finding why my own meta_query didn’t work with geo coordinates: 'type' => 'numeric' does an SQL CAST() to SIGNED. This removes all the decimals of the geo coordinates before comparison!

Related Posts:

  1. How to do a meta query using REST-API in WordPress 4.7+?
  2. Get result from meta_query() between two numbers
  3. Using meta_query on pre_get_posts to exclude a particular meta_key value
  4. Query between two meta keys
  5. Archives for custom post type based on a “date” meta value
  6. get_users meta_query
  7. meta_query with multiple values
  8. Return posts with specific meta key first, but the rest in alpha order by last name
  9. meta_query key value from array
  10. Order by nested named meta queries with ‘exists’ and ‘not exists’
  11. Advanced orderby with multiple meta_query
  12. Arrange Posts By Date In Order Of Closest To The Current Date
  13. Using get_terms() with meta_query parameters
  14. WP_User_Query with meta_query array relation ‘OR’
  15. meta_query problem
  16. Custom Upcoming Events List for Events Manager Plugin
  17. How to exlude posts that have certain meta_value?
  18. User Relationship
  19. meta_query results not the same with and without spaces
  20. meta_query all posts between to ages
  21. WordPress Core – Optimizing meta_query generated SQL?
  22. Edit post_content on posts with Featured Image
  23. Display no post when metavalue is 0
  24. Use both meta query and tax query
  25. Wildcard with LIKE operator in Meta query
  26. meta_query, number comparison, not quite working as it should
  27. Meta Query Compare with Date
  28. Does meta_query working with value paramater higher then 999?
  29. meta_query keys and sticky posts
  30. Custom post type archive with rand and meta_value
  31. Fastest way to do meta query when I don’t need the actual posts, and just need post_id?
  32. How to query post only with different excerpt?
  33. WP_Query with meta_query no results
  34. Documentation for post meta
  35. WP User Query Issues
  36. How to use meta query for greater than value in array?
  37. Wp Query custom search by meta query
  38. Filter posts by meta query?
  39. Help on multiple meta_query
  40. pre_get_posts and set
  41. Meta query date column add [x] days to validate
  42. How to use orderby with meta_query?
  43. wordpress Meta_query between numbers range (not working)
  44. Orderby doesn’t work like expected on custom query
  45. I would like to have add_post_meta to return the ID instead of true or false
  46. last_name + first_name orderby with meta_query [solved]
  47. meta query or with meta value
  48. how to get post meta where value is an array of key value pairs
  49. Meta Query Based on Month Range
  50. Find posts by related taxonomy field
  51. wordpress meta value compare between two date
  52. Can I use pre_get_posts to add up values from two different meta_keys?
  53. WP JSON API meta_query not working
  54. get_users with Serialized Custom Meta Value
  55. Sorting posts by ACF field
  56. Ordering custom posts by meta field date
  57. Unable to use meta_query between currency values when value is over 1 million
  58. Filtering all posts AND sticky posts through meta_query
  59. meta_query displays all results and none, my query is wrong
  60. How to cache the results of a query and display the cached results
  61. Delete all posts with a specific custom field using meta_query
  62. Use meta_query in args for relationship
  63. meta_query Array
  64. meta_query compare “=“ returns nothing when it seems it should
  65. How to send variable to wp meta_query value?
  66. Issue with user meta_query
  67. How to get an archive page meta?
  68. Search for value(s) in meta field for a multi select
  69. How can I create a meta_query with an array of dates?
  70. How to count items of meta query?
  71. WordPress meta query with meta serialized data array value
  72. Reading Content in an Array as it relates to a meta_query
  73. wordpress meta query with multiple meta condition causing a load on server and slows down the server..!
  74. Trouble with calling an imploded variable in an array
  75. Memory Leak in Processing Large JSON file
  76. Meta Query returning empty array
  77. meta_query not filering but meta_key works fine
  78. Query for user roles and their skills
  79. get posts meta query returning the latest post if no meta key found
  80. WordPress search between two newmeric values with a custom post type
  81. like_escape notice when using LIKE in meta query
  82. meta_query for user ID in array
  83. Display query post based on two orderby value in wordpress
  84. WP User Query with meta queries
  85. WP_Query with UNIX timestamp in meta query
  86. Querying by meta key and value
  87. How to compare date in post meta value
  88. Which Meta Query Compare Method Should I use?
  89. Sort posts by post views and consider meta key
  90. Meta query “OR” comparison not working as expected with array
  91. How to output meta_key in wp_postmeta?
  92. meta_query and strange orderby behaviour
  93. Sorting not working with get_posts
  94. Get_term with meta_query
  95. WordPress Meta Query very slow with NOT EXISTS comparison
  96. ACF meta_query field treated as “0” resulting in false negative search when testing ranges
  97. Is it possible to customize meta query in this way?
  98. Ordering WP_Query results by second meta_key
  99. How making a new search box in admin post table working on a specific column
  100. wp_user_query with meta_value_num for leaderboard