Comments (4)
What do you mean by server side?
from jquery-store-locator-plugin.
Instead of "SELECT * FROM location", I'd like to known if it's possible to send the location and only receive the nearest store (and prevent the client from receiving the entire list).
from jquery-store-locator-plugin.
If you pass the origin latitude and longitude over you can do the distance formula in the query but if you have lots of locations it's going to be pretty slow. If you don't have a lot be sure to index the latitude and longitude columns and you can do something like the following. Note the $origLat and $origLng variables and the "locations" table twice.
SELECT * FROM locations
JOIN(
SELECT (3956 * 2 * ASIN( LEAST(1, SQRT( ( POW(SIN((RADIANS(`lat`) - RADIANS($origLat)) / 2), 2) + COS(RADIANS($origLat)) * COS(RADIANS(`lat`)) * POW(SIN((RADIANS(`lng`) - RADIANS($origLng)) / 2), 2) ) ) ) ))
AS distance FROM locations
) AS location
WHERE `lat` BETWEEN $origLat - (50 / 69) AND $origLat + (50 / 69) AND `lng` BETWEEN $origLng - (50 / (69 * COS(RADIANS($origLat)))) AND $origLng + (50 / (69 * COS(RADIANS($origLng))))
ORDER BY distance
LIMIT 1
from jquery-store-locator-plugin.
Thanks bjorn
from jquery-store-locator-plugin.
Related Issues (20)
- Reloading Ajax call
- Enhancement: Store data
- fullMapStart shows map zoom smaller
- SortBy - Only sort storeLimit results?
- Some addresses does not show up without error HOT 2
- default sorts distance by string not as a float HOT 1
- Show all items on map when using paging HOT 1
- Cannot use combination of name search and taxonomy filters HOT 1
- exclusiveFiltering not working across filters HOT 1
- Uncaught TypeError: Cannot read property 'get' of undefined
- ERROR: Automatic location detection failed. Please fill in your address or zip code. HOT 2
- Filter on data in child array
- Zoom issue after filtering by category and with some other settings HOT 3
- Reload HOT 1
- Show nearest location if no results because of selected distance
- "API without a callback is not supported" HOT 3
- Start with marker's info window open? HOT 1
- Category filtering with JSON data: markers duplicate when Reset is selected and then selected again. HOT 4
- Icons for markers instead of images? HOT 2
- Only show featured locations at top
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from jquery-store-locator-plugin.