Medway Local Elections 2023

Disclaimer

This project is being developed as part of non-commercial research into voting behaviour and sentiment within the local council of Medway in the United Kingdom.

Description

web scraping of 2023 Medway Council local election results (with local caching)
data ETL
ward and candidate analysis

Languages, frameworks and libraries

Python
- requests
- Beautiful Soup
- pandas
- matplotlib
Jupyter Notebook

How to get boundary data

Download from National Archives - convert to GeoJSON

Get the mapping files from the National Archives

[Archived site] https://webarchive.nationalarchives.gov.uk/ukgwa/20221201172612/https://www.lgbce.org.uk/all-reviews/south-east/kent/medway

[Mapping files]
https://webarchive.nationalarchives.gov.uk/ukgwa/20221201172612mp_/https://s3-eu-west-2.amazonaws.com/lgbce/Reviews/South%20East/Kent/Medway/Final/Medway_final_proposals.zip

Extract ZIP and convert (projected coordiante) shp file to GeoJSON

import geopandas
myshpfile = geopandas.read_file('data/Medway_final_proposals.shp')
myshpfile.to_file('Medway.geojson', driver='GeoJSON')

Source: [StackOverflow] How to get lat and lon from a GeoPandas geodataframe polygon https://gis.stackexchange.com/questions/412817/how-to-get-lat-and-lon-from-a-geopandas-geodataframe-polygon

Alternative method for generating SVG file

Download Medway Boundary map from LGBC
Import PDF into Inkscape
Edit layers

Boundary data

Any Boundary-Line data owned by Ordance Survey that forms part of this repo falls under the Ordance Survey OpenData initiative and is subject to the terms of Open Government License linked below.

https://www.nationalarchives.gov.uk/doc/open-government-licence/version/3/

quinnphil/medway-local-elections-2023