Hi, Thanks a ton for helping me out :) But Fusion table is still doing the same. Only keeping constituencies that have values. I think it is something to do with shpescape.
On 17 July 2014 19:46, Sajjad Anwar <[email protected]> wrote: > > On Jul 17, 2014 3:43 PM, "Saurabh Datar" <[email protected]> wrote: > > > > Hi, > > > > Is it a mistake on my part? Because I used the shapefiles and converted > it using shpescape. Also, is it necessary to have all data points to merge? > E.g. does my sheet need all 544 constituencies, even though relevant data > is only for a smaller number? > > Not necessarily. But you had to tell the join operation to keep the > records without matches as well. > > > > > > > On 17 July 2014 19:11, Sajjad Anwar <[email protected]> wrote: > >> > >> Hello Saurabh, > >> > >> The data you sent does have issues - some of the geometry columns are > >> empty. Plus, there are 544 constituencies in the shapefile but the > >> criminal dataset has only 184 data points, and the MP assets dataset > >> has only 443. > >> > >> I've did the spatial join as you require and uploaded them here - > >> http://sajjad.in/datameet/ > >> Let me know if it looks okay. > >> > >> HTH. > >> > >> Cheers, > >> Sajjad. > >> > >> -- > >> Datameet is a community of Data Science enthusiasts in India. Know more > about us by visiting http://datameet.org > >> --- > >> You received this message because you are subscribed to a topic in the > Google Groups "datameet" group. > >> To unsubscribe from this topic, visit > https://groups.google.com/d/topic/datameet/srloeXEP5kc/unsubscribe. > >> To unsubscribe from this group and all its topics, send an email to > [email protected]. > >> For more options, visit https://groups.google.com/d/optout. > > > > > > > > > > -- > > Best regards, > > Saurabh Datar > > > > -- > > Datameet is a community of Data Science enthusiasts in India. Know more > about us by visiting http://datameet.org > > --- > > You received this message because you are subscribed to the Google > Groups "datameet" group. > > To unsubscribe from this group and stop receiving emails from it, send > an email to [email protected]. > > > For more options, visit https://groups.google.com/d/optout. > > -- > Datameet is a community of Data Science enthusiasts in India. Know more > about us by visiting http://datameet.org > --- > You received this message because you are subscribed to a topic in the > Google Groups "datameet" group. > To unsubscribe from this topic, visit > https://groups.google.com/d/topic/datameet/srloeXEP5kc/unsubscribe. > To unsubscribe from this group and all its topics, send an email to > [email protected]. > For more options, visit https://groups.google.com/d/optout. > -- Best regards, Saurabh Datar -- Datameet is a community of Data Science enthusiasts in India. Know more about us by visiting http://datameet.org --- You received this message because you are subscribed to the Google Groups "datameet" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
