Schiehallion – Contour lines and Maskelyne’s observatory

In 1774 large science was taking place in the heart of Scotland. Two men were about to weigh the earth. This was done using plumblines and measuring how much the hill in Perthshire, called Schiehallion, displaced them. Schiehallion was chosen for its uniform appearance and relative accessibility.

The two people responsible for the experiment were the astronomer Nevil Maskelyne and the surveyor Charles Hutton. Charles Hutton, in order to make calculations of the volume of the mountain, pioneered the use of contour lines. These were essential in joining up measurement points to create a continual observation. Maskelyne set up a cabin on each side of the mountain where he could live and take astronomical observations and plumbline readings. The hut on the north side of the mountain famously burned down during the whisky fuelled celebrations of completing the observations, taking with it a local boys precious fiddle. Upon returning to London Maskelyne compensated the boys loss by sending him a replacement fiddle, a Stradivarius.

A good account of the Scheihallion experiment can be found in Rachel Hewitt’s: Map of a Nation. Which also provides an excellent account of the early days of the Ordnance Survey.

My goal for the trip was to find the remains of Maskelyne’s ruined observatory, which according to some reports could still be found on the northern slopes of the mountain. The quest was inspired by Simon Ingram. Whose account of climbing Schiehallion in Between the Sunset and the Sea is definitely worth a read. I used the notes found in that book to narrow the search area.

I set off, driving past Dull (Paired with Boring, Oregon), which was not a sign of how the day would turn out.

Dull and Boring

The first views of Schiehallion do not show the characteristic conical shape, rather show a gradual slope.

First glimpse

However the uniformity can be seen in the Ordnance Survey One-inch to the mile, Popular edition, Scotland, 1920-1930.

At the head of the car park there is a memorial to the observation work that took place on the hill.

Monument

Schiehallion from the car park (parking is £2, and only coins are accepted), with a suggestion of nice weather ahead.

Schiehallion

Unfortunately the weather in Scotland is never predictable. With hail one minute.

Hail

And sunshine the next.

Sun

View from the top of Schiehallion. My goal was to attain the summit, and on the way down break off from the path and head downslope.

Schiehallion

The remains of the Ordnance Survey trig point at the top of Schiehallion.

OS Trig Point

The view of the northern slope, so the observatory remains would be somewhere down there. There were a couple of promising piles of rocks that could be seen from up high, but upon closer inspection turned out to be… piles of rocks.

Slope

View back up to the ridge.

View back

Northern slope. The terrain was not difficult, but the weather was not ideal.

View down

I was just about the give up the search, but after climbing one final rise I saw a suspiciously uniform pile of rocks.

Finally

The remains of Maskelyne’s observatory. One platform was for the cabin, with the other one for the astronomical instruments.

Maskelyne's observatory

Backpack for scale.

Backpack

A job well done. The way back was very boggy. I took some solace in the fact that I was contouring around the hill that established contour lines. I was also spurred by the success of actually finding the site.

Happy Mapper

Final view back to Schiehallion.

View back

A successful journey, and excellent adventure.

If you want to visit the site I would recommend reading the description in Simon Ingram’s: Between the Sunset and the Sea, and baseing your own search on the description provided.

However I did track my own route, and I had been about to give up my own search before I finally found the site. So my route:

View:

UK General Election Results

No GIS in this post, so best to skip if you are not interested in UK election results.

The data has been released by the electoral commission, so I thought I would run a few queries in PostgreSQL to look at the numbers. These queries are based on the initial results, so may be subject to change.

The raw data can be found from: the Electoral Commission.

First lets have a look at the description on the ballot paper (The party name or description used by the candidate on the ballot paper.) and look at a count of each:

Description on Ballot Paper Number of Candidates
UK Independence Party (UKIP) 531
The Conservative Party Candidate 497
Labour Party 482
Liberal Democrats 370
Green Party 367
Liberal Democrat 141
Independent 137
Trade Unionist and Socialist Coalition 115
The Green Party 89
Scottish Conservative and Unionist 59
Scottish Liberal Democrats 59
Scottish National Party (SNP) 59
Scottish Labour Party 58
UKIP 42
Plaid Cymru - The Party of Wales 39
Welsh Labour/Llafur Cymru 38
Welsh Conservative Party Candidate/Ymgeisydd Plaid Geidwadol Cymru 37
UK Independence Party (UK I P) 32
Cannabis is Safer than Alcohol 31
Scottish Green Party 31
English Democrats - Putting England First! 30
Welsh Liberal Democrats - Democratiaid Rhyddfrydol Cymru 30
no description 29
Labour and Co-operative Party 25
Green Party/Plaid Werdd 20
Conservative Party Candidate 19
SDLP (Social Democratic & Labour Party) 18
Sinn Féin 18
Christian Peoples Alliance 17
Green Party Candidate 17
Liberal Democrats - Stronger Economy Fairer Society 17
Conservatives 16
Democratic Unionist Party - D.U.P. 16
Green Party candidate 16
Ulster Unionist Party 15
The Official Monster Raving Loony Party 14
Alliance Party 11
National Health Action Party 11
The Green Party Candidate 11
The Labour Party Candidate 11
Conservative Party 10
Labour Party Candidate 10
The Socialist Party of Great Britain 10
Scottish Trade Unionist and Socialist Coalition 9
British National Party 8
Socialist Labour Party/Plaid Lafur Sosialaidd 8
Alliance 7
Class War 7
The Green Party/Plaid Werdd 7
Traditional Unionist Voice - TUV 7
Wales Green Party 7
Workers Revolutionary Party 7
National Front 6
Yorkshire First 6
A Voice for the Region 5
Christian Party Proclaiming Christ's Lordship 5
Communities United Party 5
Independence from Europe 5
Labour and Cooperative Party 5
Lincolnshire Independents 5
Mebyon Kernow - The Party for Cornwall 5
The Workers Party 5
UK Independence Party 5
Welsh Liberal Democrats 5
All People's Party 4
Animal Welfare Party 4
Communist Party 4
Left Unity- Trade Unionist and Socialists 4
Scottish Socialist Party 4
The North East Party 4
UK Independence Party 4
UK Independence Party (UK IP) 4
A voice for the region 3
Green Party Stop Fracking Now 3
Left Unity 3
The Above and Beyond Party 3
The Conservative Party 3
Trade Unionists and Socialists Against Cuts 3
UK Independence Party (Ukip) 3
We Are The Reality Party 3
Welsh Conservative Party Candidate 3
Alliance For Green Socialism - Save NHS 2
Communist League 2
Communist Party of Britain 2
Green Party 2
Justice For Men & Boys 2
Left Unity- Trade Unionists and Socialists 2
Liberal Democrat/Democratiaid Rhyddfrydol 2
Liberal Democrat Focus Team 2
Liberal Democrat - Stronger Economy Fairer Society 2
No to terrorism, yes to Britain 2
Party for a United Thanet 2
Patria 2
Patriotic Socialist Party 2
People Before Profit 2
Pirate Party UK 2
Red Flag - Anti-Corruption 2
Respect (George Galloway) 2
Respect - Peace, Justice, Equality 2
Scottish Christian Party Proclaiming Christ's Lordship 2
Social Democratic Party 2
The Green Party candidate 2
The Justice & Anti-Corruption Party 2
The Liberal Party 2
The Northern Party 2
The Peace Party- Non-Violence, Justice, Environment 2
The Pirate Party 2
The Whig Party 2
UKIP - Scrap HS2 2
Whig Party Candidate 2
After Change- Politics Only Different 1
Alliance For Green Socialism 1
Alliance for Green Socialism-Save NHS 1
Al-Zebabist Nation of Ooog 1
Annibynnol-Independent 1
Apni Party 1
Apolitical Democrats 1
Beer, Baccy and Scratchings 1
Bournemouth Independent Alliance 1
British Democrats 1
British independents 1
Campaign 1
Cannabis is Safer than Alcohol Candidate 1
Children of the Atom 1
Christian Movement for Great Britain 1
Christian Party 'Proclaiming Christ's Lordship' 1
Common Sense Party 1
Communist 1
Conservative and Unionist Party 1
Conservative Party 1
Demanding a New Vision in Politics 1
Democratic Reform Party 1
Digital Democracy 1
English Democrats - Letting Monmouthshire Decide 1
Europeans Party 1
For Socialism Against austerity and war 1
Free Public Transport Party 1
Green Party / Plaid Werdd 1
Guildford Greenbelt Group 1
Hoi Polloi 1
Humanity 1
Independent/Annibynnol 1
Independent Community and Health Concern 1
Independent Political Alliance Party 1
Independents Against Social Injustice 1
Independent save Withybush Save Lives/ Annibynnol Achub llwynhelyg Achub Bywyda 1
Independents for Bristol 1
Independent-Tell It Like It is 1
Islam Zinda Baad Platform 1
Labour 1
Labour & Cooperative Party 1
Land Party 1
Left Unity - Trade Unionists and Socialists (Joint Description with Left Unity) 1
Let every child have both parents 1
Let' s Keep It Real 1
Liberal Democrat 1
Liberal Democrats-Stronger Economy Fairer Society 1
Liberal Party Candidate And Local Resident 1
Locally Informed Health and Social Care 1
Magna Carta Conservation Party Great Britain 1
Magna Carta Party 1
Mainstream 1
Manston Airport Independent Party 1
Mebyon Kernow- The Party For Cornwall 1
Movement for Active Democracy 1
National Front 1
National Liberal Party-Self determination for all 1
National Liberal Party - Self Determination For All 1
New Independent Centralists 1
No Description 1
Northern Party 1
Nothing borrowed. Nothing old. Something New 1
Official Monster Raving Loony Party 1
Official Pirate Party Candidate 1
People Before Profit Alliance 1
People First - Gwerin Gyntaf 1
Pirate Party 1
Plaid Cymru - Carmarthenshire's Voice 1
Poole People - independent and local 1
Population Party UK 1
Putting Croydon First! 1
Reduce VAT in Sport 1
Removing the politicians 1
Republican Socialist 1
Residents for Uttlesford 1
Rochdale First Party 1
Scottish Communist Party 1
Socialist Equality Party 1
Something New 1
Stop emotional child abuse, Vote Elmo 1
The 30-50 Coalition 1
The Birthday Party 1
The Conservative Party 1
The Democratic Party 1
The Eccentric Party of Great Britain 1
The English Democrats - Putting England First! 1
The Evolution Party 1
The Liberal Democrat Candidate 1
The Liberal Party Candidate 1
The New Society of Worth 1
The Official Raving Loony Party 1
The Peace Party - Non-violence, Justice, Environment 1
The Peace Party- Non violence, Justice, Environment 1
The Pilgrim Party 1
The Pluralist Party - Liverpool's People's Party 1
The Principles of Politics Party 1
The Realists' Party 1
The Roman Party. Ave 1
The Southport Party 1
The Speaker seeking re-election 1
The Sustainable Population Party 1
The Ubuntu Party 1
The U K Progressive Democracy Party 1
Trying to fix a broken system 1
Ubuntu Party 1
(UKIP) UK Independence Party 1
U Party 1
Vapers in power 1
Vapers In Power 1
Vote for real people, not politicians! 1
Walsall Socialist and Trade Union Candidate 1
War Veteran's Pro-Traditional Family Party 1
Welsh Christian Party Proclaiming Christ's Lordship 1
Wessex Regionalists 1
Wigan Independents 1
World Peace Through Song 1
Young People's Party UK 1
Young People's Party YPP 1
Your local Communist candidate 1
Your Vote Could Save Our Hospital 1

Some descripancies to note are extra spaces in the raw data. Overall a good correlation might be to look how many descriptions each party has and election outcome.

Next what I have found puzzling is some of the analysis based on raw voter numbers. One example by AVAAZ.org:

Voter percentage

I find it misleading to say that the SNP only received 5% of the vote. They only revived 5% of the vote overall, but even had they received a 100% vote in Scotland, and voter turnout in Scotland had been 100% they would still only have received 4094784 votes. Had the SNP run in more than the 59 Scottish constituencies, then they would have revived more overall votes. It is useless looking at overall votes compared to seats, the percentage of possible votes provides a better comparison in my opinion with the current electoral format.

To do this the data needed to be slightly cleansed, with some descriptions combined, for example:
Lib Dems are made up of:
“liberaldemocratstrongereconomyfairersociety”, “liberaldemocratsstrongereconomyfairersociety”, “liberaldemocratsdemocratiaidrhyddfrydolcymru”, “liberaldemocrats”, “liberaldemocratfocusteam”, “liberaldemocrat/democratiaidrhyddfrydol”, “liberaldemocrat”

And conservatives:
“conservatives”, “conservativeparty/ymgeisyddplaidgeidwadolcymru”, “conservativeparty”, “conservativeandunionistparty”, “conservativeandunionist”

Example Description Cleaned Description Number of Candidates Total Votes Recieved Contested Electorate Votes Cast in Contested Constitiencies Percatage of Total Electorate Percatage of Votes
The Speaker seeking re-election speakerseekingreelection 1 34617 77572 53692 44.63 64.47
Scottish National Party (SNP) nationalpartysnp 59 1454436 4094784 2910465 35.52 49.97
Welsh Conservative Party Candidate conservativeparty 647 11299969 46209246 30552696 24.45 36.99
Welsh Labour/Llafur Cymru labourparty 631 9347304 45111221 29926050 20.72 31.23
Democratic Unionist Party - D.U.P. democraticunionistpartyd.u.p. 16 184260 1088955 617362 16.92 29.85
Sinn Féin sinnféin 18 176232 1236683 718103 14.25 24.54
People Before Profit Alliance peoplebeforeprofitalliance 1 6798 62685 35329 10.84 19.24
Ulster Unionist Party ulsterunionistparty 15 114935 1040770 601881 11.04 19.1
Independent Community and Health Concern independentcommunityandhealthconcern 1 7211 77451 49440 9.31 14.59
SDLP (Social Democratic & Labour Party) sdlpsocialdemocraticandlabourparty 18 99809 1236683 718103 8.07 13.9
UK Independence Party (UKIP) ukindependenceparty 624 3878068 44681335 29528054 8.68 13.13
Plaid Cymru - The Party of Wales plaidcymrupartyofwales 40 181704 2282297 1498063 7.96 12.13
Respect (George Galloway) respectgeorgegalloway 2 9022 133832 84043 6.74 10.73
Alliance Party allianceparty 11 44335 745333 434355 5.95 10.21
Independent save Withybush Save Lives independentsavewithybushsavelives 1 3729 57291 40556 6.51 9.19
Welsh Liberal Democrats - Democratiaid Rhyddfrydol Cymru liberaldemocrats 631 2418893 45111221 29926050 5.36 8.08
Alliance alliance 7 17221 491350 283748 3.5 6.07
Traditional Unionist Voice - TUV traditionalunionistvoicetuv 7 16538 473571 262515 3.49 6.3
Annibynnol-Independent annibynnolindependent 1 1388 44395 28913 3.13 4.8
Green Party/Plaid Werdd greenparty 573 1157613 41023812 27157251 2.82 4.26
Poole People - independent and local poolepeople 1 1766 72557 47393 2.43 3.73
Rochdale First Party rochdalefirstparty 1 1535 79170 45430 1.94 3.38
Residents for Uttlesford residentsforuttlesford 1 1658 80615 57563 2.06 2.88
The Liberal Party liberalparty 3 3815 213847 140471 1.78 2.72
The Southport Party southportparty 1 992 67328 44101 1.47 2.25
National Health Action Party nationalhealthactionparty 11 12999 828465 579289 1.57 2.24
Your Vote Could Save Our Hospital yourvotecouldsaveourhospital 1 849 69516 39490 1.22 2.15
Bournemouth Independent Alliance bournemouthindependentalliance 1 903 71956 44827 1.25 2.01
Mebyon Kernow - The Party for Cornwall mebyonkernowpartyforcornwall 6 5675 420985 294828 1.35 1.92
Lincolnshire Independents lincolnshireindependents 5 5407 390952 262148 1.38 2.06
Wigan Independents wiganindependents 1 768 76068 45293 1.01 1.7
Independent independent 137 95226 9882195 6581199 0.96 1.45
Walsall Socialist and Trade Union Candidate walsallsocialistandtradeunion 1 545 67080 36883 0.81 1.48
Independent/Annibynnol independent/annibynnol 1 459 61719 32715 0.74 1.4
The North East Party norastparty 4 2138 259893 160005 0.82 1.34
The Workers Party workersparty 5 2724 344032 203020 0.79 1.34
Socialist Labour Party/Plaid Lafur Sosialaidd socialistlabourparty 8 3481 427178 272713 0.81 1.28
Yorkshire First yorkshirefirst 6 3332 430384 259884 0.77 1.28
Liberal Party Candidate And Local Resident liberalpartyandlocalresident 1 665 78580 53817 0.85 1.24
Locally Informed Health and Social Care locallyinformedhealthandsocialcare 1 637 73724 52302 0.86 1.22
Christian Party "Proclaiming Christ's Lordship" christianparty 9 3205 590395 412445 0.54 0.78
People Before Profit peoplebeforeprofit 2 1056 146854 90349 0.72 1.17
Independents Against Social Injustice independentsagainstsocialinjustice 1 603 75109 51797 0.8 1.16
People First - Gwerin Gyntaf peoplefirstgweringyntaf 1 407 59314 38574 0.69 1.06
Respect - Peace, Justice, Equality respectpeace,justice,equality 2 967 148476 88197 0.65 1.1
Left Unity- Trade Unionists and Socialists leftunitytradeunionistsandsocialists 2 1091 163429 104348 0.67 1.05
Guildford Greenbelt Group guildfordgreenbeltgroup 1 538 76554 53986 0.7 1
A voice for the region avoiceforregion 8 3479 597776 396741 0.58 0.88
We Are The Reality Party wearerealityparty 3 1029 216646 134710 0.47 0.76
Christian Movement for Great Britain christianmovementforgreatbritain 1 292 76401 42231 0.38 0.69
National Liberal Party-Self determination for all nationalliberalparty 2 627 138714 94543 0.45 0.66
Nothing borrowed. Nothing old. Something New nothingborrowed 1 375 78181 56925 0.48 0.66
Trade Unionist and Socialist Coalition tradeunionistandsocialistcoalition 124 32961 8821526 5553062 0.37 0.59
Vote for real people, not politicians! voteforrealpeople,notpoliticians! 1 216 68128 35916 0.32 0.6
Cannabis is Safer than Alcohol cannabisissaferthanalcohol 32 8419 2283215 1445292 0.37 0.58
Left Unity - Trade Unionists and Socialists leftunitytradeunionistsandsocialists 1 292 80507 51561 0.36 0.57
Something New somethingnew 1 320 77050 57119 0.42 0.56
Left Unity- Trade Unionist and Socialists leftunitytradeunionistandsocialists 4 1046 302050 203876 0.35 0.51
Alliance For Green Socialism - Save NHS allianceforgreensocialismsavenhs 3 737 204582 139387 0.36 0.53
The Official Monster Raving Loony Party officialmonsterravingloonyparty 15 3604 1068661 706509 0.34 0.51
The Official Raving Loony Party officialravingloonyparty 1 294 81144 58060 0.36 0.51
British Democrats britishdemocrats 1 210 66123 41406 0.32 0.51
Trying to fix a broken system tryingtofixabrokensystem 1 194 58657 38028 0.33 0.51
Independent-Tell It Like It is independenttellitlikeitis 1 201 69516 39490 0.29 0.51
Scottish Socialist Party socialistparty 4 875 263714 178850 0.33 0.49
The Pirate Party pirateparty 3 642 237382 132765 0.27 0.48
All People's Party allpeople'sparty 4 981 313924 203911 0.31 0.48
English Democrats - Putting England First! englishdemocrats 31 6431 2174239 1386541 0.3 0.46
The Peace Party - Non-violence, Justice, Environment peacepartynonviolence 4 957 297622 199036 0.32 0.48
Common Sense Party commonsenseparty 1 256 79666 57267 0.32 0.45
British National Party britishnationalparty 8 1667 564765 376865 0.3 0.44
Pirate Party UK piratepartyuk 2 382 154657 89960 0.25 0.42
Communities United Party communitiesunitedparty 5 1102 408509 249850 0.27 0.44
Islam Zinda Baad Platform islamzindabaadplatform 1 191 79170 45430 0.24 0.42
Apni Party apniparty 1 156 60718 37992 0.26 0.41
Animal Welfare Party animalwelfareparty 4 736 295310 182445 0.25 0.4
Apolitical Democrats apoliticaldemocrats 1 228 79058 57300 0.29 0.4
Christian Peoples Alliance christianpeoplesalliance 17 3260 1269892 830955 0.26 0.39
Trade Unionists and Socialists Against Cuts tradeunionistsandsocialistsagainstcuts 3 555 229173 148257 0.24 0.37
Manston Airport Independent Party manstonairportindependentparty 1 191 70182 49401 0.27 0.39
Putting Croydon First! puttingcroydonfirst! 1 221 82010 57712 0.27 0.38
Communist Party communistparty 5 723 343784 210999 0.21 0.34
Removing the politicians removingpoliticians 1 187 83384 51774 0.22 0.36
British independents britishindependents 1 143 70247 40820 0.2 0.35
National Front nationalfront 7 1114 508626 319991 0.22 0.35
Communist Party of Britain communistpartyofbritain 2 275 149414 80261 0.18 0.34
no description nodescription 30 4623 2133828 1417002 0.22 0.33
Movement for Active Democracy movementforactivedemocracy 1 164 71974 48597 0.23 0.34
The Pilgrim Party pilgrimparty 1 143 67834 43339 0.21 0.33
Left Unity leftunity 3 455 234827 151808 0.19 0.3
Alliance For Green Socialism allianceforgreensocialism 1 115 61333 34828 0.19 0.33
Independents for Bristol independentsforbristol 1 204 89198 64218 0.23 0.32
Humanity humanity 1 149 63470 47361 0.23 0.31
World Peace Through Song worldpeacethroughsong 1 165 77753 53541 0.21 0.31
War Veteran's Pro-Traditional Family Party warveteran'sprotraditionalfamilyparty 1 150 70945 49676 0.21 0.3
Digital Democracy digitaldemocracy 1 139 65245 48791 0.21 0.28
Whig Party Candidate whigparty 4 561 314520 198812 0.18 0.28
Official Pirate Party Candidate officialpirateparty 1 106 59998 39453 0.18 0.27
The Northern Party norrnparty 3 332 212159 131974 0.16 0.25
Independence from Europe independencefromeurope 5 578 367889 247086 0.16 0.23
The Sustainable Population Party sustainablepopulationparty 1 116 69455 48045 0.17 0.24
Beer, Baccy and Scratchings beer,baccyandscratchings 1 133 79609 55505 0.17 0.24
No to terrorism, yes to Britain nototerrorism,yestobritain 2 202 139523 90341 0.14 0.22
Communist communist 1 125 85951 53522 0.15 0.23
Justice For Men & Boys justiceformenandboys 2 216 148991 100849 0.14 0.21
Your local Communist candidate yourlocalcommunist 1 106 69146 47963 0.15 0.22
Patria patria 2 205 155657 98912 0.13 0.21
English Democrats - Letting Monmouthshire Decide englishdemocratslettingmonmouthshiredecide 1 100 65706 47462 0.15 0.21
Party for a United Thanet partyforaunitedthanet 2 199 140686 96454 0.14 0.21
The Ubuntu Party ubuntuparty 2 197 137206 81938 0.14 0.24
The Justice & Anti-Corruption Party justiceandanticorruptionparty 2 171 144744 87293 0.12 0.2
For Socialism Against austerity and war forsocialismagainstausterityandwar 1 108 86864 54917 0.12 0.2
Let' s Keep It Real let'skeepitreal 1 116 87968 58949 0.13 0.2
The Above and Beyond Party aboveandbeyondparty 3 304 221491 148162 0.14 0.21
Mainstream mainstream 1 86 71380 43699 0.12 0.2
The Socialist Party of Great Britain socialistpartyofgreatbritain 10 899 745723 483348 0.12 0.19
Wessex Regionalists wessexregionalists 1 110 79767 58482 0.14 0.19
Communist League communistleague 2 174 169273 95218 0.1 0.18
Vapers In Power vapersinpower 2 152 137127 86642 0.11 0.18
Population Party UK populationpartyuk 1 83 69490 46386 0.12 0.18
Free Public Transport Party freepublictransportparty 1 100 80522 60819 0.12 0.16
Young People's Party YPP youngpeople'spartyypp 1 80 73545 49348 0.11 0.16
Democratic Reform Party democraticreformparty 1 74 73426 47426 0.1 0.16
Social Democratic Party socialdemocraticparty 2 125 137752 76295 0.09 0.16
After Change- Politics Only Different afterchangepoliticsonlydifferent 1 78 67193 51151 0.12 0.15
Class War classwar 7 526 516204 342184 0.1 0.15
The 30-50 Coalition 3050coalition 1 78 82825 52924 0.09 0.15
Magna Carta Conservation Party Great Britain magnacartaconservationpartygreatbritain 1 77 74287 51964 0.1 0.15
Children of the Atom childrenofatom 1 83 76460 54102 0.11 0.15
Socialist Equality Party socialistequalityparty 1 58 70945 39318 0.08 0.15
Red Flag - Anti-Corruption redflaganticorruption 2 147 164901 103968 0.09 0.14
The Birthday Party birthdayparty 1 81 79405 56904 0.1 0.14
Workers Revolutionary Party workersrevolutionaryparty 7 488 533924 343752 0.09 0.14
U Party uparty 1 77 80241 53964 0.1 0.14
Young People's Party UK youngpeople'spartyuk 1 72 83612 55010 0.09 0.13
The Roman Party. Ave romanparty.ave 1 64 72302 48404 0.09 0.13
Let every child have both parents leteverychildhavebothparents 1 52 67192 48245 0.08 0.11
The Eccentric Party of Great Britain eccentricpartyofgreatbritain 1 50 70634 44811 0.07 0.11
Independent Political Alliance Party independentpoliticalallianceparty 1 56 77873 52243 0.07 0.11
The U K Progressive Democracy Party ukprogressivedemocracyparty 1 57 78171 52941 0.07 0.11
Patriotic Socialist Party patrioticsocialistparty 2 106 157431 107779 0.07 0.1
Reduce VAT in Sport reducevatinsport 1 56 79767 58482 0.07 0.1
Hoi Polloi hoipolloi 1 45 79241 57785 0.06 0.08
Europeans Party europeansparty 1 39 71238 50894 0.05 0.08
The Evolution Party evolutionparty 1 41 74287 51964 0.06 0.08
The Principles of Politics Party principlesofpoliticsparty 1 37 73601 51544 0.05 0.07
New Independent Centralists newindependentcentralists 1 23 61333 34828 0.04 0.07
Campaign campaign 1 28 79962 47610 0.04 0.06
The Pluralist Party - Liverpool's People's Party pluralistpartyliverpool'speople'sparty 1 23 62868 38403 0.04 0.06
Demanding a New Vision in Politics demandinganewvisioninpolitics 1 24 61974 43357 0.04 0.06
Stop emotional child abuse, Vote Elmo stopemotionalchildabuse,voteelmo 1 37 79767 58482 0.05 0.06
Land Party landparty 1 35 79767 58482 0.04 0.06
Al-Zebabist Nation of Ooog alzebabistnationofooog 1 30 70182 49401 0.04 0.06
The New Society of Worth newsocietyofworth 1 23 57291 40556 0.04 0.06
The Democratic Party democraticparty 1 33 77251 54779 0.04 0.06
The Realists' Party realists'party 1 18 70634 44811 0.03 0.04
Republican Socialist republicansocialist 1 20 80604 51424 0.02 0.04
Magna Carta Party magnacartaparty 1 26 80242 62004 0.03 0.04

3D Printed Scale Model of London

Definitely worth a visit if you are in the vicinity of London in the next year. Impressive in scale and in detail. Fascinating way to get an overview of future development plans in London and the current extents of the city centre.

Whole set:
View

Shard, London City, Tower of London, and Tower Bridge:
Shard

Tower of London and Tower Bridge:
Tower Bridge

Canary Wharf, the O2, and the Skyline
Canary Wharf

Visiting is free and the venue also has interesting displays if you are into architecture.

Opening times:
Mon – Fri: 9.00am – 6.00pm
Sat: 10.00am – 5.00pm*

Runs from:
23 Apr 2015 – 23 Apr 2016
With full interactivity available from: 21 May

More information at:
The Building Centre

More images:
Thames BarrierLondon EyeO2 and AirlineOlympic StadiumLondon City AirportCity and ShardCanary Wharf
WholeSouth WestEastCanary Wharf

X Percent of the Population of Scotland Lives Within Y Miles of Edinburgh

Follow up from the Glasgow post by request.

This is a pretty easy question to answer, using the 2011 Scottish Census population results and the Census Output Area Population Weighted Centroids. Then we get the extents of Edinburgh City Council from OS Boundary Line.

The results are:

Pop. Count: %
Scotland 5295403 100
Edinburgh 476626 9
25 km 1276757 24.1
50 km 2500093 47.2
50 miles 3919910 74
100 km 4310869 81.4
100 miles 4812421 90.9

So we see more than people live close to Glasgow, but with 50 miles + they are closer to the capital.

To see how these boundaries look on a map:

Population buffers around Edinburgh

A few caveats:
We are using the population weighted centroids, which will produce some minor inaccuracies, but is a very good generalisation.
Also we are using euclidean buffers on the British National Grid plain, so these are not geodesic buffers. The difference will likely be small at these distances.

Mapvember 2014

Mapvember: A map/tutorial a day for every day in November.

Some days had more than one map, some had tutorials, one just had a photo. Some were very easy, others would have take a couple of days of work.

Excellent experience, good learning experience and an opportunity to post previous projects that were a bit short of being great. A little time consuming at times though. I started making the maps around half way through October, so I had almost the first week ready when November began, but the days ticked by quickly. Happy to have done it. I encourage everyone to join in next year, or any other month.

Visitor Statistics:

Total views: 3047
Uniques: 2289
Pageviews: 4327

Top 10 Countries:

Country Visitors
United Kingdom 1147
United States 363
Germany 183
France 120
Canada 85
Italy 67
Spain 66
Australia 56
Switzerland 42
India 39

Mapvember Countries

Top 10 Cities:

City Visitors
Glasgow 340
London 212
Edinburgh 122
Rostock 45
Aberdeen 42
Stirling 35
San Jose 31
Vienna 28
Berlin 28
Zagreb 26

Mapvember Cities

Other Months:
August Visitors: 303
September Visitors: 641
October Visitors: 523
November Visitors: 3047

AdSense:

Total AdSense earnings: £1.87

Which actually covers my servers costs. So break even!

Most popular posts:

Referrals:

Site Visitors
Reddit.com 747
OSGeo.org 381
Twitter 122
GIS.StackExchange.com 71
Facebook 70
Flickr 15

Top SubReddits:

SubReddit Visitors
/r/glasgow 200
/r/scotland 120
/r/london/ 46
/r/gis 19
/r/QGIS/ 4

Thanks for visiting.

Great Circle Flight Lines in PostGIS

There is an excellent post by Anita Graser about creating Great Circles in PostGIS.

However as of PostGIS version 2.1 this can be done in a different (better) way, using the geography functions.

PostGIS Great Circles

For more information about geography, see:
Introduction to PostGIS – Geography

This allows us to create the great circles without having to add in a new projection.

So we first need to create our three tables in PostGIS:

The data itself can be found at: openflights.org/data.html

We can then load our data through PGAdminIII. You can just right click on a table and select import. Remember to not load the “uid” column, because it is our primary key which will be populated automatically and not in the original data. You will also want to define it as the primary key.

Now we need a geometry column in the airports dataset.

We can define our geometry in the airports dataset from the Latitude and Longitude columns.

And create a spatial index.

Then we can create a flights table.

This table will have a source geometry and a destination geometry along with a few other attributes. I added a primary key to this table as well.

To filter out a specific airport, for example Honolulu we use the “Airport ID”.

Then we add in the actual line geometry column.

And populating the great circle geomtrey:

This is works great to an extent, but QGIS still has some trouble with lines that cross the date-line.

Screenshot[32]

We can fix this using a Pacific centered projection like EPSG:3832.

Screenshot[33]

We can either set QGIS to the projection. Or we could have set our geometry the this projection initially when creating the flight lines.

Thanks to:
The World Is A Village – PostGIS: using latitude and longitude to create geometry
http://gis.stackexchange.com/questions/84443/what-is-this-postgis-query-doing-to-show-great-circle-connections