I'm in the process of trying to implement this code, but (as i'm a beginner) its going slow. Do you have a working page using this code I might visit?
Thanks, A On Jul 26, 6:11 pm, Riccardo Govoni ☢ <[email protected]> wrote: > Your fusion table contains kml data, which makes it very large to download. > Just downloading it as a simple csv (via this > urlhttps://www.google.com/fusiontables/api/query?sql=SELECT%20geometry%2...) > 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.
