Creative Commons License
Except where otherwise noted, content on this site is licensed under a
Creative Commons Attribution-NonCommercial-ShareAlike 2.5 UK: Scotland License.
Read more about this sites license here .
( Clicking on images will display larger versions )

Glasgow Under Construction


Following a post about the emerging Berlin skyline a number of other views of cities ( London , Historical New York ) have been put online using the fantastic OSM Buildings tool.

I have wanted to enable better views of Glasgow and the current construction and planning. There is an existing Urban Model which is kept in a proprietary and licensed format. It would be ideal if under the banner of the Open Data initiative this was released either directly to the Open Street Map project or via api as has been done in cities like New York .

My contribution is this interactive map , showing planned, recently constructed and some speculative models that i could find.There is a tutorial to add buildings or play with ideas.

( NB just leaving these links to what other cities who have real open data policies can do . Data should "Default To Open" )

As is the nature of these planned buildings visualisation in context is not generally available. To this end i have been trying to make the model creation easier. It would be an interesting step forward if architects submitted obj or GeoJSON models as part of the planning process.

Luckily as part of the process site layouts are submitted. Usually very helpfully in pdf format.
Importing into Inkscape gives you this;

Buildings and any other features of interest can be separated and cleaned up.Repositioning to make the GIS translations simpler is trivial with align tools.


Export to DXF and making use of the GDAL tools, and ogr2ogr in particular, generate an appropriate file.
I "gently coerce" the output file GeoJSON to the correct polygon format and add some data needed by OSMBuildings.
This is then read into geojson.io to allow further editing and referencing to use in display.NB A polygon, rather than just point, move would be a big help in geojson.io

HELP !
Here is where my lack of proper GIS knowledge shows, there is a choice of coordinate system that i am missing or not choosing correctly. The model is shearing in the transform as i try to geolocate the model. I need a simple translate in a normal cartesian rectangular frame, so unfortunately the model is distorted just now. This should be an easy fix for someone who knows what they are doing.
Here is what i am currently doing, the srs coord frames are what needs changing, or something in the sql needs to specify a coord frame; ( geojson.io needs WGS84 )

ogr2ogr -f "GeoJSON" -overwrite "$oFileName".geojson -s_srs EPSG:4326 -t_srs EPSG:4326 "$bname".shp -dialect sqlite
-sql "SELECT ShiftCoords(ScaleCoords(ShiftCoords( geometry,-X(Centroid(GEOMETRY)),
-Y(Centroid(GEOMETRY))),$scale),$long+(X(Centroid(GEOMETRY))*$scale),$lat+(Y(Centroid(GEOMETRY))*$scale)) FROM $bname"
( edited to change srs to 4326 )
NB if i leave centred at 0,0 the images are straight and right angled so it is the shiftCoords and/or the srs coord frames not the other manipulations that are doing the shear. Could it just be rounding/precision issue ?
ie

Linking the geojson model in to the Glasgow model gives this;
( Live Map View )

A good step forward but not the complete tool by any means. Too many workarounds , it may actually be easier to rework the openSCAD export extension in Inkscape but that would then limit use to only inkscape users. Fixes in gdal 2.0+ make the polygon creation simpler. A better way to calculate rescale value and specifying the geolocate origin as well

Rio Cafe

Rio Cafe
27 Hyndland Street, Glasgow
14th November 2015

All change.
Rio Cafe, Glasgow

Raised area gone which is nice as it was always cramped and awkward. Minor quibble; Could have extended the seats i was in to make a corner seat like the opposite booth. Now you could be sat with your head at someones backside in the window seats.

Similar view from January 2015
Rio Cafe, Glasgow


Big Rio sign has gone
Rio Cafe, Glasgow

Previously
Rio Cafe, Glasgow

Doghouse Brewdog

Doghouse Merchant City
99 Hutcheson St, Glasgow, G1 1SN
4th November 2015
Doghouse,Brewdog,Glasgow
The second Brewdog bar opened in Glasgow over the Halloween weekend. Much larger than the original it has a different menu and includes a distinct bottle shop.
It is probably most like Drygate with the benefit of it being more easily walkable from other places that people would want to visit.A bit table deficient and feels a bit sparse due to the sheer size of it.

Rio Cafe

Rio Cafe
27 Hyndland Street, Glasgow
31st October 2015

Rio Cafe, Glasgow
As the Rio closes for 10 days for a refurb, a snapshot from Oct 31st of the old look

Rio Cafe, Glasgow

( The next week as the internal work continues. Photos on facebook show it has been gutted. It will be interesting to see the changes )
Rio Cafe, Glasgow

Great Scottish Run 2015

5th October 2015

110 Queen St appears

Our own little High Line. A trip on this should be part of Doors Open Days in 20016.

Little glass cap

Look how narrow the front of Central Station is.Also the central hole in the building opposite

All the unimaginative boxes built on the south side of the Clyde. Is there any other city in the world that wastes the opportunity of having two rivers running through it.

Can just see the grey slabs in Anderston that are in the process of being demolished

Debris on the roof and the sinks in the back.

This could be your luxury apartment !

This is from last years run ( GOMA:no scaffolding and 110 Queen St being built )

Just the eight of the bridges

Our river of road.

So, What Comes Next

So,What Comes Next
182 Queen Margaret Drive,Glasgow, G20 8NX
7th October 2015

So,What Comes Next,Glasgow

The old Crosslands bar , redone as a series of popups before a more formal change similar to the companies other recent popup in the old Sammy Dows . Current version is for Oktoberfest, then a month of Wine then a Christmas Market. Ceiling by Rogue-One

The Strathmore

The Strathmore
795 Maryhill Road,Glasgow
7th October 2015

The Strathmore,Glasgow
An extensive refurbishment and extension from the old Strathmore. Aiming for more of the surrounding student population by the looks of it. Bar is through opening to the right where you enter from Maryhill Road.

Inn Deep

Inn Deep
445 Great Western Rd, Glasgow , G12 8HH
1st October 2015
Just turned 3 years old.

"Ch-ch-ch-ch-ch-changes" LINK ; "A Change is Gonna Come" LINK
inn Deep, Glasgow

10th September 2014 2 Years Old
inn Deep, Glasgow

3rd August 2013 1 Year Old
inn Deep, Glasgow

10th September 2012 :) All new and baby fresh
inn Deep, Glasgow

Doors Open Day 2015

Fewer things this year . Trying to get to newer or more unique places.

Friday 19th

Argyll Chambers, 34 Argyle Arcade

Britannia Panopticon

Mackintosh Church

Saturday 20th

Muirhead Leather
First public tour in 175 years. This is exactly what Doors Open Days should be about.
Insightful, knowledgeable and original.

Anniesland Court
Another fantastic tour and description.