Skip to content

Instantly share code, notes, and snippets.

View symroe's full-sized avatar

Sym Roe symroe

59 followers · 20 following
View GitHub Profile
@symroe
symroe / Columns.html
Created September 5, 2017 15:08
<!DOCTYPE html>
<html>
<head>
<style>
.box {
width:50%;
}
.box:nth-child(even) {
float:right;
@symroe
symroe / dc-widget-css.html
Created May 23, 2017 21:25
<style>
.democracy_club_embed{font-size:19px;color:#58595b}.democracy_club_embed .card{border-radius:0 3px;clear:both;padding:20px;background:#fff;box-shadow:0 4px 8px 0 rgba(0,0,0,0.1),0 3px 10px 0 rgba(0,0,0,0.09)}.democracy_club_embed .dc_logo{text-decoration:none;font-size:14px}.democracy_club_embed .dc_logo img{max-width:120px;vertical-align:middle}.democracy_club_embed button{background-color:#00AEEF;border:0;padding:0.4em 0.6em;margin:0.5em 0;font-size:1em;color:#FFF;border-bottom:3px solid #0089bc}.democracy_club_embed button:hover{background-color:#009bd6}.democracy_club_embed .link-button{display:inline-block;border:2px solid #00AEEF;color:#00AEEF;font-size:1rem;font-family:Avenir,sans-serif;margin:0;padding:1rem 2rem 1.0625rem 2rem;text-decoration:none}.democracy_club_embed .link-button:hover{background-color:#f9fdff}.democracy_club_embed .form-group{width:100%;clear:both}.democracy_club_embed .form-control{font-size:19px;line-height:1.31;border:2px solid #0b0c0c;padding:5px 4px 4px}.democracy_
@symroe
symroe / README.md
Last active February 24, 2026 14:46
The working beind this blog post https://democracyclub.org.uk/blog/2017/03/20/4314-times-when-postcodes-arent-good-enough/

This list was made using ONDAS and AddressBase. Here's a rough giude to how it was made:

  1. Get ONSAD
  • Get a CSV file with UPRN,Postcode, I got this from the AddressBase
  • Install csvkit
  • Remove all the columns in ONSAD that we don't care about (we only want the 'LAD' column): cat ../ONSAD_JAN_2017/Data/*.csv | csvcut -c 1,3 > uprn_lad.csv
  • We now have two CSV files, each with two columns. One UPRN,postcode the other UPRN,LAD.
  • Run join.py to join the two files in to a single file with 3 columns
  • Make a file with postcode,lad: cat joined.csv | csvcut -c 3,2 > postcode_lad.csv
  • Filter out duplicate rows: sort -u postcode_lad.csv&gt; unique_rows.csv
@symroe
symroe / ynr_fixup.py
Last active February 27, 2017 21:28
election_slugs = ['local.aberdeen-city.2017-05-04',
'local.aberdeenshire.2017-05-04',
'local.angus.2017-05-04',
'local.city-of-edinburgh.2017-05-04',
'local.clackmannanshire.2017-05-04',
'local.dumfries-and-galloway.2017-05-04',
'local.east-ayrshire.2017-05-04',
'local.east-dunbartonshire.2017-05-04',
'local.east-lothian.2017-05-04',
'local.east-renfrewshire.2017-05-04',
@symroe
symroe / police_areas.geojson
Created February 16, 2017 14:14
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@symroe
symroe / Council services
Created December 6, 2016 13:09
Appeal against a housing benefit decision
Appeal against your council's housing decision
Appeal against your parking fine
Apply for a community alarm
Apply for a council home
Apply for a disabled person's bus pass
Apply for a discount on council tax
Apply for a needs assessment by social services
Apply for a parking permit
Apply for a performance/stage licence for school age children
@symroe
symroe / Cambridge-and-Peterborough-Devolution-Deal.geojson
Created December 5, 2016 14:07
Loading
Sorry, something went wrong. Reload?
Sorry, we cannot display this file.
Sorry, this file is invalid so it cannot be displayed.
@symroe
symroe / polling_staton_addresses.csv
Created July 14, 2016 11:01
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 6.
"address","postcode","st_astext"
"BLACKFEN ROAD
SIDCUP","DA15 8QS","POINT(0.0959100982581493 51.4511501608113)"
"PICARDY ROAD
BELVEDERE","DA17 5AX","POINT(0.148883410691916 51.4865403697307)"
"HARVEL CRESCENT
ABBEY WOOD","SE2 0QA","POINT(0.129565784178912 51.4824863175941)"
"11 WOOLWICH ROAD
BELVEDERE","DA17 5HR","POINT(0.145217342248926 51.4839276204586)"
"ST AUGUSTINES ROAD
@symroe
symroe / kv_revisions.py
Created July 6, 2016 09:32
from django.db import transaction
from django.db import models
class Collection(models.Model):
name = models.CharField(blank=True, max_length=100)
revision = models.IntegerField(blank=True, null=False)
@transaction.atomic
def save(self, items_dict, *args, **kwargs):
@symroe
symroe / example_polling_stations.csv
Created June 22, 2016 17:23
We can make this file beautiful and searchable if this error is corrected: Unclosed quoted field in line 3.
postcode,ps_internal_council_id,ps_polling_district_id,ps_postcode,ps_address,ps_location_wkt
EN4 0EU,4538,YDA,EN4 0EN,"St. Pauls Church Hall
Crescent East
Hadley Wood
Barnet
Hertfordshire
EN4 0EN",POINT (-0.1724724088639866 51.6680869449261309)
N14 4DS,4548,YDD,N14 4AP,"14th Southgate Scout Headquarters
Green Road
Southgate