Error in Presentation of Kenya Polling Data

Question

Error in Presentation of Kenya Polling Data

Opened this issue 4 years ago · 11 comments

Hello Team,

I downloaded the pollingstations shapefiles from your site for use in Power BI analysis but the data is not rendering well with the shape map visualization in Power BI

Kindly see attached screen shots and help.

Answer 1 · 2021-02-11T15:33:23.000Z

@bosirejustine Looks to me like there are polling places misplaced due to incorrect longitude in the source data. The data distributed here results from scraping data shared by IEBC years ago, and I did no work to QA or clean up the data. You might be able to correct the data by looking in detail at the misplaced points, and repositioning them

Answer 2 · 2021-02-12T13:19:47.000Z

Dear Mikel, My only worry is why it is not rendering well for the many stations that are within the borders of Kenya. See how the wards have rendered in the attachment. Kind Regards, Justine Bosire

…

On Thu, Feb 11, 2021 at 6:33 PM Mikel Maron ***@***.***> wrote: @bosirejustine <https://github.com/bosirejustine> Looks to me like there are polling places misplaced due to incorrect longitude in the source data. The data distributed here results from scraping data shared by IEBC years ago, and I did no work to QA or clean up the data. You might be able to correct the data by looking in detail at the misplaced points, and repositioning them — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFQQELT3J2UHYFVDNNTHFV3S6P2FPANCNFSM4XOOHF3A> .

Answer 3 · 2021-02-12T13:23:23.000Z

@bosirejustine then I suggest filtering them out before you load in PowerBI. Could do in QGIS, or scripting.

Answer 4 · 2021-02-15T07:01:49.000Z

Dear Mikel, I have no idea how to do it in QGIS. Could you help please? Kind Regards, Justine Bosire

…

On Fri, Feb 12, 2021 at 4:23 PM Mikel Maron ***@***.***> wrote: @bosirejustine <https://github.com/bosirejustine> then I suggest filtering them out before you load in PowerBI. Could do in QGIS, or scripting. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFQQELUUQ2TWK7HXRA6OYM3S6UTVTANCNFSM4XOOHF3A> .

Answer 5 · 2021-02-16T13:22:32.000Z

@bosirejustine I went into QGIS, loaded the pollingstations layer, went into edit mode, selected the points outside Kenya, hit delete, exited edit mode, and saved the layer as a new file.

pollingstations_clipped.zip

Note there were 10,052 polling stations misplaced and deleted.

Answer 6 · 2021-02-16T19:50:53.000Z

Dear Mikel, This is how it renders on powerbi (see map1 in attachments) - I don't want it this way. I want it to render as per map2 in attachments Kind Regards, Justine Bosire

…

On Tue, Feb 16, 2021 at 4:22 PM Mikel Maron ***@***.***> wrote: @bosirejustine <https://github.com/bosirejustine> I went into QGIS, loaded the pollingstations layer, went into edit mode, selected the points outside Kenya, hit delete, exited edit mode, and saved the layer as a new file. pollingstations_clipped.zip <https://github.com/mikelmaron/kenya-election-data/files/5988814/pollingstations_clipped.zip> Note there were 10,052 polling stations misplaced and deleted. — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFQQELTDDBI45IAD6HP76KLS7JWS3ANCNFSM4XOOHF3A> .

Answer 7 · 2021-02-16T20:17:37.000Z

no attachments came through @bosirejustine. you may need to post directly in github

Answer 8 · 2021-02-17T06:54:15.000Z

Hello Mikel,
See below images

Answer 9 · 2021-02-17T11:04:26.000Z

@bosirejustine the second map is using the ward boundaries I think, not the polling places

Answer 10 · 2021-02-17T13:26:22.000Z

Dear Mikel, That's correct. I would like to achieve a similar rendering for all the polling stations found under the wards of Kenya. Kind Regards, Justine Bosire

…

On Wed, Feb 17, 2021 at 2:04 PM Mikel Maron ***@***.***> wrote: @bosirejustine <https://github.com/bosirejustine> the second map is using the ward boundaries I think, not the polling places — You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub <#2 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFQQELSBOOQL4SYBNCVSMZLS7OPEXANCNFSM4XOOHF3A> .

Answer 11 · 2021-02-17T16:40:39.000Z

@bosirejustine well there is boundaries data as well you use. can't help with specific rendering questions in PowerBI. As long as the error you pointed out has been addressed with https://github.com/mikelmaron/kenya-election-data/files/5988814/pollingstations_clipped.zip, I'd like to go ahead and close this ticket.