Bounding box queries take the form of:
SELECT * FROM 297050 WHERE ST_INTERSECTS(Address, RECTANGLE(LATLNG(37.2, -122.3), LATLNG(37.6, -121.9)))
Where 297050 is the key for your Fusion Table and the LATLNG coordinates represent the bounding box.
If you want to see how you can add buttons to a Google Fusion map that will load a spatial query I've created a quick example, World Crime Rates. This map shows world crime and homicide rates. The map has queries to view only countries with crime rates over certain figures. It also has two spatial queries - one to show results only from Europe and one that shows results from the Americas. The two spatial queries use the bounding box function.
You can learn more about the new spatial query offering in Fusion Tables in the Fusion Tables documentation.
Via: Search your geo data using spatial queries from Fusion Tables!
________________
Any idea if you can query across two tables? Example: query all the points in one table that intersect a polygon (i.e. city boundary imported from another table)?
ReplyDeleteThanks!
Interesting idea. You might need to use the Fusion Tables API itself to do that.
ReplyDelete@Tom - the Fusion Tables Users Group would probably be the best place to get a definitive answer to your question. http://groups.google.com/group/fusion-tables-users-group
ReplyDeleteFrom researching spatial queries in Fusion Tables, it seems you can only query using a circle or rectangle. I too would like to be able to query using polygons.
ReplyDeleteDoes anyone know if there are plans to implement query by polygon in Fusion Tables?
Thanks.