Error in Presentation of Kenya Polling Data

[bosirejustine]

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.

[mikelmaron]

@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

[bosirejustine]

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 notifications@github.com 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 https://github.com/mikelmaron/kenya-election-data/issues/2#issuecomment-777580857, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFQQELT3J2UHYFVDNNTHFV3S6P2FPANCNFSM4XOOHF3A .

[mikelmaron]

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

[bosirejustine]

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 notifications@github.com 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 https://github.com/mikelmaron/kenya-election-data/issues/2#issuecomment-778192738, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFQQELUUQ2TWK7HXRA6OYM3S6UTVTANCNFSM4XOOHF3A .

[mikelmaron]

@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.

[bosirejustine]

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 notifications@github.com 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 https://github.com/mikelmaron/kenya-election-data/issues/2#issuecomment-779833508, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFQQELTDDBI45IAD6HP76KLS7JWS3ANCNFSM4XOOHF3A .

[mikelmaron]

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

[bosirejustine]

Hello Mikel, See below images

[mikelmaron]

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

[bosirejustine]

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 notifications@github.com 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 https://github.com/mikelmaron/kenya-election-data/issues/2#issuecomment-780480066, or unsubscribe https://github.com/notifications/unsubscribe-auth/AFQQELSBOOQL4SYBNCVSMZLS7OPEXANCNFSM4XOOHF3A .

[mikelmaron]

@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.