[ddj] Query on integrating scraperwiki & Google fusion tables

[Srinivasan Ramani]

Dear Tim,

The code for scraping data from India's Election Commission website is
available here already:

https://classic.scraperwiki.com/profiles/vrsrini/index.html

The fusion table that I need to use to integrate data from the scraperwiki
tables is available here (as of now it carries turnout information on the
elections and it will be updated with party vote share information as data
comes in):

https://www.google.com/fusiontables/DataSource?docid=1gMha069AC-bkJjv7TZg5dzWbbbqq1ducBBMF_Sy7&pli=1#map:id=3

(Data above has been organised on the basis of constituency/district. India
has a simple majority electoral system).

Where I need help from you and others is creating an API call to query the
data tables from scraperwiki and populate the google fusion table above. I
intend to keep this table viewable and downloadable for all (media houses
in India unfortunately do not do so and are very proprietary about this).

If you can give me pointers about using the Google Fusion Tables API -
suitably an example that is already out there which can be modified and
used- it would be very useful and I would be very grateful!

Many thanks,
Srinivasan



Best Regards,
Srinivasan V. Ramani ,
Senior Assistant Editor,
Economic and Political Weekly ,
New Delhi: 110 067
09650855669
http://epw.in


On Thu, May 15, 2014 at 11:54 AM, Tim McNamara
<paperless at timmcnamara.co.nz>wrote:

> Srinivasan, what an excellent project!
>
> Is the code you have written so far available anywhere for others to
> comment on?
>
> Tim McNamara
> @timClicks <http://twitter.com/timClicks> | timmcnamara.co.nz
>
> <http://timmcnamara.co.nz/>
>
>
> On 15 May 2014 10:15, Srinivasan Ramani <srini at epw.in> wrote:
>
>> Dear all,
>>
>> I have written a scraperwiki that downloads electoral data from my
>> country's election commission website.
>>
>> https://classic.scraperwiki.com/profiles/vrsrini/index.html
>>
>> I have a Google Fusion Table that has constituency data and is rendered
>> in a map.
>>
>> I need to update the Google Fusion Table dynamically with data from the
>> scraperwiki tables, so that this data is shown dynamically on the rendered
>> map.
>>
>> I understand that Google Fusion Table API helps in this purpose. But I am
>> unable (as a tyro) to figure as to how to use this API and combine it with
>> my scraperwiki.
>>
>> Please send me pointers if any of you have expertise in this. Your help
>> will be much appreciated!
>>
>> Thanks and Best Regards,
>> Srinivasan V. Ramani ,
>> Senior Assistant Editor,
>> Economic and Political Weekly ,
>> New Delhi: 110 067
>> 09650855669
>> http://epw.in
>>
>> _______________________________________________
>> data-driven-journalism mailing list
>> data-driven-journalism at lists.okfn.org
>> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
>> Unsubscribe:
>> https://lists.okfn.org/mailman/options/data-driven-journalism
>>
>>
>
> _______________________________________________
> data-driven-journalism mailing list
> data-driven-journalism at lists.okfn.org
> https://lists.okfn.org/mailman/listinfo/data-driven-journalism
> Unsubscribe: https://lists.okfn.org/mailman/options/data-driven-journalism
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.okfn.org/pipermail/data-driven-journalism/attachments/20140515/f0981fa2/attachment-0003.html>