Search code examples
google-fusion-tables

My query has stopped returning any results (related to ST_DISTANCE)

For the past 4 months or so we've been happily using this query:

SELECT * FROM 2066206 ORDER BY ST_DISTANCE(geometry, LATLNG(51.5081289,-0.12800500000003012))

It now returns zero rows. If I change it to the following it works fine:

SELECT * FROM 2066206 ORDER BY geometry

Is there currently an issue with the ST_DISTANCE function?

This is function is documented on https://developers.google.com/fusiontables/docs/developers_reference

The 'geometry' field is a Google location field based on our lat + lng columns. For this example the lat lng is what Google returns for "London".

Really appreciate any possible insights.

Solution

  • It seems to be working for me now:

    http://www.google.com/fusiontables/api/query?sql=SELECT+*+FROM+2066206+ORDER+BY+ST_DISTANCE(geometry,+LATLNG(51.5081289,-0.12800500000003012))

    Are you still having issues?