background preloader

FusionTablesLayer Wizard

FusionTablesLayer Wizard

How To Count Queried Rows in a Google Fusion Table « Michelle Minkoff In my “free” time, I help people who are also on the JavaScript learning journey. Here’s a query, paraphrased. How can I count how many points I currently have displayed on a Fusion Table layer of a Google Map? This would be especially helpful when we’re using filters, to show how many points are currently displaying. I’m not the first one to come up with this, for more on the subject, and the creators of the code this is based off of, pleas see the “Getting Data” section of Robin Kraft’s post here. If we assume that searchString stands for the value a user inputs in a filter (look into how to use HTML forms and connect it with JavaScript elsewhere, that’s left as an exercise to the reader, and I’m pulling info from Fusion Table ID which we will call…tableid…here’s the code you would need to get that count. First, set a variable which contains the beginning of a URL, which allows you to query the Google Fusion Table SQL API. var queryUrlHead = '

GViz API Example: Fusion Tables Data Source TableID: Query: Link to this page BESbewy This is a great example of the possibilities of Google visualisation api

Related: