Google Fusion Tables now offers spatial queries. Using spatial queries, developers can find all features that are located within a given distance of a specified location, find all features that are located within a given bounding box, and find a given number of features closest to a location.
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!
________________
Thursday, November 11, 2010
Subscribe to:
Post Comments (Atom)
Blog Archive
-
▼
2010
(1206)
-
▼
November
(84)
- Local Listings on Google Maps
- Campus Travel on Google Maps
- The Beer Lovers Android Application
- Touring Australia with Google Maps
- Foursquare Location Updates on Google Maps
- Limp Bizkit Videos on Google Maps
- Nature Spotting with Google Maps
- Webcams on Google Maps
- UK Jobs on Google Maps
- Kayaking Around New Zealand
- Plane Crash on Google Maps
- The Sally Army on Google Maps
- More Local Problems with Google Maps
- Google Map of Korean Incidents
- Report Local Problems with Google Maps
- Visualise GPS Tracks with Google Maps
- Google Maps Tutorials
- Mapping the Recovery Act
- UKSnow Map Back in Action
- Danish Google Maps Mashups Roundup
- Google Maps Encourage Serendipity
- Bahamas Nautical Charts on Google Maps
- Tag Google Maps
- Black Friday Deals on Google Maps
- Find Historical Buildings on Google Maps
- Find Your Neighbours with Google Maps
- Amsterdam Coffee Shops on Google Maps
- Toronto Video Guide on Google Maps
- Gothic France on Google Maps
- Google Map of Tourist Attractions
- The Hitchhikers Guide on Google Maps
- Guess the Street View Location
- More Fusion Tables Spatial Queries
- Real-Time Edits to Google Maps
- Track Your C##p With Google Maps
- Real-Time German Buses Map
- Fusion Tables
- Street View Expands in Germany
- It's Street View but Is it Art?
- Skiing with Google Maps
- Google Hotpot
- Facebook Events with Google Maps
- Foursquare Check-ins on Google Maps
- Recording Your Tracks with Google Maps
- It Gets Better with Google Maps
- Friday Fun with Google Maps Mania
- Live Auctions with Google Maps
- Real-time Alerts with Google Maps
- Film Locations on Google Maps
- Spatial Queries Added to Fusion Tables!
- Canada's Afghan War Dead on Google Maps
- New Orleans Cycling on Google Maps
- Local Reviews on Google Maps
- New Aerial Imagery Released
- jQuery and Google Maps
- All Australian Life on Google Maps
- Houston's Culture on Google Maps
- Prison of War Camps on Google Maps
- Finding Red M&M's with Google Maps
- Virtual Tours with Google Maps
- Remembering WWII with Google Maps
- Turkey Google Maps Mashups Round-Up
- News Timelines on Google Maps
- Jet Skiing to Nicaragua on Google Maps
- Street View used in Game Trailer -Updated
- Find a Taxi with Google Maps
- Floor-Plans with Google Maps
- Tokyo Shopping on Google Maps
- Dangerous Companies on Google Maps
- Google Map of Your Twitter Followers
- Using Styled Maps with the Static Maps API
- Styled Static Maps Launches
- Find an Apartment with Google Maps
- Guess the Photo with Google Maps
- Google Map of London Coffee Houses
- Overheard in New York on Google Maps
- Create Your Own Google Maps
- The New York Marathon on Google Maps
- Street View Germany - Part 2
- First German Street View Animation
- Street View Arrives in Germany - Updated
- Travel Times on Google Maps
- Voting Help from Google Maps
- Louisiana Planning on Google Maps
-
▼
November
(84)
0 comments:
Post a Comment