Your fusion table contains kml data, which makes it very large to download. Just downloading it as a simple csv (via this url https://www.google.com/fusiontables/api/query?sql=SELECT%20geometry%20FROM%201182169) results in a 50Mb file. Formatted in JSON format is likely to be even bigger.
This is probably over the maximum size that Firefox accepts (I'm not sure whether the limitation is in firefox, firebug or the xmlhttprequest that you are firing) and anyway past the size that the browser can easily manage (just the download times are significant, and the browser javascript engine will likely fail / take forever when converting such a payload into a google.visualization.DataTable and displaying it. I think you should refactor your table and/or the data you fetch to limit the amount of data on the wire. Do you actually need all those kml data on the client ? /R. On 26 July 2011 20:26, Ramana <[email protected]> wrote: > Hi Riccardo, > I was also using jquery to use the raw fusion table api. And when i > looked at your code and tried the same thing, i noticed two things: > 1) when i have dataType:'json' , it does not work > 2) when i use jsonp instead, dataType : 'jsonp' , it is fetching data > but in Firebug i see an error message 'script too large'. Not sure > what's going on. > > Here is the code snippet i am using. > > function queryFusionTable() > { > $.ajax( > { > url: ' > https://www.google.com/fusiontables/api/query?sql=' > + > encodeURIComponent('SELECT geometry FROM > 1182169'), > dataType:'jsonp', > jsonp : > 'jsonCallback', > success : function(json) > { > var rows = json.table.rows; > var cols = json.table.cols; > ........ > ......... > } > } > ); > } > > Do you know what could be wrong here? > > On Jul 26, 12:38 pm, Riccardo Govoni ☢ <[email protected]> wrote: > > Note that there is indeed a limitation in the number of rows that you can > > get from a Fusion Table via the Google Chart Tools API and that is set to > > 500 rows. Seehttp:// > code.google.com/apis/fusiontables/docs/sample_code.html > > : > > > > "Using the Google Chart > > Tools<http://code.google.com/apis/charttools/index.html>, > > you can request data from Fusion Tables to use in visualizations or to > > display directly in an HTML page. Note: responses are limited to 500 rows > of > > data" > > > > I don't know the reason for such limitation, but you can work around it > by > > using the raw fusion tables SQL API ( > http://code.google.com/apis/fusiontables/docs/developers_guide.html) and > > query your datasource asking for a response in JSONP format. This doesn't > > seem to have the same row limitation. Once you have the response in JSONP > > format, you can easily transform it into a DataTable on the client and > then > > pass it to the visualization. > > > > You can use this > > file< > http://code.google.com/p/google-visualization-io2011/source/browse/js...>, > > starting from line 105 as an example of the process (using the jQuery > > library). > > > > /R. > > > > On 24 July 2011 08:33, visigoth <[email protected]> wrote: > > > > > > > > > > > > > > > > > Hi Ramana, > > > > > Could you please post this in the Fusion Table Users Group< > https://groups.google.com/forum/#!forum/fusion-tables-users-group> so > > > we can check whether this limitation is imposed by Fusion Tables? > > > I don't know of any such limitation as part of the GViz DataTable. > > > > > -- > > > You received this message because you are subscribed to the Google > Groups > > > "Google Visualization API" group. > > > To view this discussion on the web visit > > >https://groups.google.com/d/msg/google-visualization-api/-/ZLq586CqOQQJ > . > > > > > To post to this group, send email to > > > [email protected]. > > > To unsubscribe from this group, send email to > > > [email protected]. > > > For more options, visit this group at > > >http://groups.google.com/group/google-visualization-api?hl=en. > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
