Databases
StackOverflow2013
Postsdbo
POGetting around the 500 row limit
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POGetting around the 500 row limit
    text
    copied!<p>I have written a Google Fusion Tables script I'm happy with (below), but it's loading only 500 rows of points in my table, which has over 20,000 rows. This is my first time in this neighborhood and I was really surprised to find the limit. Is there some way to load all the rows?</p> <pre><code> &lt;!doctype html&gt; &lt;html class="no-js" lang="en"&gt; &lt;head&gt; &lt;meta charset="utf-8"&gt; &lt;meta content="IE=edge,chrome=1" http-equiv="X-UA-Compatible"&gt; &lt;title&gt;Points in box&lt;/title&gt; &lt;link href="./stylesheets/example.css" media="screen" rel="stylesheet" type="text/css" /&gt; &lt;link rel="shortcut icon" href="/images/favicon.ico" /&gt; &lt;noscript&gt;&lt;meta http-equiv="refresh" content="0;url=/no_javascript.html"&gt;&lt;/noscript&gt; &lt;!-- Find box coordinates javascript --&gt; &lt;script type ="text/javascript" src="http://www.movable-type.co.uk/scripts/latlon.js"&gt;&lt;/script&gt; &lt;!-- Type label text javascript --&gt; &lt;script type="text/javascript" src="http://maps.google.com/maps/api/js?sensor=false"&gt;&lt;/script&gt; &lt;script type="text/javascript" src="./js/label.js"&gt;&lt;/script&gt; &lt;!-- Visulization javascript --&gt; &lt;script type="text/javascript" src="http://www.google.com/jsapi"&gt;&lt;/script&gt; &lt;!-- Initialize visualization --&gt; &lt;script type="text/javascript"&gt; google.load('visualization', '1', {}); &lt;/script&gt; &lt;/head&gt; &lt;body class="developers examples examples_downloads examples_downloads_points-in-box examples_downloads_points-in-box_index"&gt; &lt;script src="http://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js" type="text/javascript"&gt;&lt;/script&gt; &lt;script type="text/javascript"&gt; var store_table = 4121905; //send a call to GViz to retrieve lat/long coordinates of the stores function getStoreData() { //set the query using the input from the user var queryText = encodeURIComponent("SELECT Latitude,Longitude,Impressions FROM " + store_table); var query = new google.visualization.Query('http://www.google.com/fusiontables/gvizdata?tq=' + queryText); //set the callback function query.send(doLoop); } function drawBox(topleftx, toplefty, bottomrightx, bottomrighty) { var bounds = new google.maps.LatLngBounds( new google.maps.LatLng( topleftx, toplefty ), new google.maps.LatLng( bottomrightx, bottomrighty ) ); var overlay = new google.maps.Rectangle({ map: carto_map, bounds: bounds, strokeColor: "#0000ff", strokeOpacity: 0.20, strokeWeight: 2, fillColor: "#0000ff", fillOpacity: 0.050, }); } function doLoop(response) { numRows = response.getDataTable().getNumberOfRows(); //Basic var cartodbMapOptions = { zoom: 7, center: new google.maps.LatLng( 37.926868, -121.68457 ), // center: new google.maps.LatLng( 40.7248057566452, -74.003 ), // disableDefaultUI: true, mapTypeId: google.maps.MapTypeId.ROADMAP } // Init the map carto_map = new google.maps.Map(document.getElementById("map"),cartodbMapOptions); for(i = 0; i &lt; numRows; i++) { var centerX = response.getDataTable().getValue(i,0); var centerY = response.getDataTable().getValue(i,1); var imps = response.getDataTable().getValue(i,2); var centerPoint = new LatLon(centerX,centerY); var latLng = new google.maps.LatLng(centerX,centerY); var toplefty = centerPoint.destinationPoint(-45, 6)._lon; var topleftx = centerPoint.destinationPoint(-45, 7.7)._lat; var bottomrighty = centerPoint.destinationPoint(135, 6)._lon; var bottomrightx = centerPoint.destinationPoint(135, 7.7)._lat; drawBox(topleftx, toplefty, bottomrightx, bottomrighty); var marker = new google.maps.Marker({ position: latLng, draggable: false, markertext: imps, flat: true, map: carto_map }); var label = new Label({ map: carto_map, position: latLng, draggable: true }); label.bindTo('text', marker, 'markertext'); marker.setMap(null); } } $(function() { getStoreData(); }); &lt;/script&gt; &lt;div id="map"&gt;&lt;/div&gt; &lt;/body&gt; &lt;/html&gt; </code></pre>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload