Google Fusion Table Query Data Manipulation

Question

I have been querying locations from a Google fusion table and mapping the points to a Google maps layer using the following code:

        function mapPoints() {
            searchStr = 'ST_INTERSECTS(Location, RECTANGLE(' + 'LATLNG' + map.getBounds().getSouthWest() + ',' + 'LATLNG' + map.getBounds().getNorthEast() + '))';
            layer.setOptions({
                query: {
                    select: 'Location',
                    from: tableid,
                    where: searchStr
                }
            });
        }

In addition to mapping the locations I'd like to store the data returned from the query in some sort of table for further manipulation/reference. Can anyone advise me on how to do this.

Answer 1

But there is an "undocumented" JSONP option for querying Fusion Tables. I gave some example code in this answer. It's the same API and returns the actual FT features as well as the Location.