Hot answers tagged distance
The aproach with cross-join doesn't use indexes and requires a lot of memory. So you basically have two choices. Pre 9.3 you'd use a correlated subquery. 9.3+ you can use a LATERAL JOIN. KNN GIST with a Lateral twist Coming soon to a database near you (exact queries to follow soon)
You are nearly there. There is a little trick which is to use Postgres's distinct operator, which will return the first match of each combination -- as you are ordering by ST_Distance, effectively it will return the closest point from each senal to each port. SELECT DISTINCT ON (senal.id) senal.id, port.id, ST_Distance(port."GEOMETRY", senal."GEOMETRY") ...
its not possible to get control over pan behavior in the JSAPI directly, but Ryan Mordoff wrote a really cool plugin and shared it on Github. i think most people are using it to increase the default multiplier, but you could also use it to achieve the inverse. see this thread for more info.
It is possible, but you may run against usage limits: Users of the free API: 100 elements per query. 100 elements per 10 seconds. 2 500 elements per 24 hour period. Read more at: https://developers.google.com/maps/documentation/distancematrix/#Limits
Only top voted, non community-wiki answers of a minimum length are eligible