Stream

Matt Travis
moderator

Discussion  - 
 
We are holding a QGIS user group meetup on Thursday 29th September at Dartmoor National Park. Tickets will be free (thanks to Clearmapping Co for sponsoring) and available very soon.

If you would like to present something please let me know. It doesn't necessarily have to be about QGIS. If you're up to stuff with postgis, geoserver, leaflet or R then come and let us know.
4
Add a comment...

Antony Scott

Discussion  - 
 
I've been trying to work out whether it's possible to include x/y coords (for example of the centroid of a map frame) as an expression/field in a text label in a QGIS Print Composer, and so far have failed... anyone been able to do this? many thanks
Ant
1
Antony Scott's profile photoMatt Travis's profile photo
4 comments
 
Possibly. I'll check out the QGIS api docs when I get a chance.
Add a comment...

Mark Percival

Discussion  - 
 
I have a spatialite db with a table containing x & y coordinates and want to add a spatial column from those - how do I do that (I don't want a csv which I then bring into QGIS)?
1
Ross McDonald's profile photoMark Percival's profile photo
2 comments
 
The way I did this was to join it (by sql) to another table with an existing geom column and it worked brilliant !
Add a comment...

Michael Spencer

Discussion  - 
 
Does anyone know how I can get this in a shp file format? Or at least make it play nicely with gdal!

https://data.gov.uk/dataset/data-zone-boundaries-2011

I did find a shp version here: https://saspac.org/data/2011-census/scotland-2011/, but the data zone codes don't match the others I'm working with...
1
Liam Mason's profile photoMichael Spencer's profile photo
3 comments
 
Magical, thanks both!
Add a comment...

Matt Pitts

Discussion  - 
 
Hi Guys, Just a quick question, I'm putting together a walking route guide and wondering if there is a way to label distances on a route say every km? Maybe a plugin or some other simple solution I haven't thought of?
2
Matt Pitts's profile photoJoshua Dickerson's profile photo
3 comments
 
No worries, I imagine there will be a fancy rule based way someone will be able to suggest but that works well enough for me as a little workaround! 
Add a comment...

Ross McDonald
moderator

Discussion  - 
 
Has anyone looked at the new OS Highways layer? I'm needing some PostgreSQL help to generate a list of turn restriction for grade separated links.

Nodes are tagged as grade separated.

Links have a toid, a start and end node toid, a direction (in or opposite digitised direction) and a start and end grade separation value (0 ground, 1 elevated).

My flaky first attempt here: https://github.com/mixedbredie/highways-for-pgrouting#grade-separation-turn-restrictions
1
Add a comment...

Richard Harlow

Discussion  - 
 
I have a number of files from a program called MapInQuest and they are labeled .qff any ideas how to process them into QGIS.
1
Add a comment...

Lutra GIS

Discussion  - 
 
Here is a step-by-step guide to set up and configure Discovery plugin in QGIS to work with +Ordnance Survey AddressBase data:

http://www.lutraconsulting.co.uk/blog/2016/05/27/using-os-addressbase-for-address-search-in-qgis/
3
Add a comment...

Tom Armitage

Discussion  - 
 
Just a couple of the learning outcomes from the workshop I'm presenting at FOSS4G UK: Visualising Arts & Humanities Data in QGIS.

Of course the principles are the same for any other type of data, and the process is remarkably simple thanks to QGIS and its community of plugin developers, so everyone is welcome!

Register for your place at the conference soon, before the reduced price tickets all disappear: http://uk.osgeo.org/foss4guk2016/
2
Add a comment...

Lutra GIS

Discussion  - 
 
Here is a webinar helping you load your +Ordnance Survey MasterMap in PostGIS, through OS Translator II plugin in QGIS:

http://www.lutraconsulting.co.uk/blog/2016/05/03/loading-mastermap-in-postgis-webinar/
We have had several requests from users about the OS Translator II (OST II) plugin for QGIS. Unlike the previous version, the OST II requires PostGIS to store the data. In this webinar we will talk you through various steps to have your geo-database set up and running with the OS MasterMap ...
3
Charley Glynn's profile photoLutra GIS's profile photo
2 comments
 
Hi +Charley Glynn not at the moment. But step-by-step guide is available for our supported customers which includes additionl info for user configuration (+ Active Directory integration), Postgres optimisation, back-up and restore.
Add a comment...

Ross McDonald
moderator

Discussion  - 
 
#FOSS4GUK is looking for talks and workshop proposals. Have you got something worth sharing?

Submit it here - https://docs.google.com/forms/d/13wSDVU-EaUumNxypVJ5Jgc0qKFDdGrXTxynHkSIcfDo/viewform
Drive
FOSS4G UK 2016 ProposalUse this form to submit a proposal for FOSS4G UK, being held at Ordnance Survey in Southampton from 14th-16th June. The call for proposals will end on 30th April 2016. Note that for workshops, we'll liaise regarding logistics nearer the time. You are welcome to submit more than one proposal, and for any questions please contact osgeouk[at]gmail.com. http://uk.osgeo.org/foss4guk2016
1
Add a comment...

About this community

The UK QGIS User Group has been setup to primarily provide a forum where UK QGIS users can share information and experiences of QGIS and other Open Source GIS resources. The purpose of forum is not for individuals to ask general question about QGIS, these should be directed to the GIS Stackexchange.

PJ Hooker

Discussion  - 
 
Simplifies geojson geometry of your web map with Mapsharper >> https://goo.gl/Gp1vzn
1
Matt Travis's profile photoPJ Hooker's profile photo
2 comments
 
Near ... But in the previous video i create this map with QGis 😉
Add a comment...

PJ Hooker

Discussion  - 
 
GeoJSON file format? #gistips ⬈ A basic example with geojson.io and ♥ QGis. YouTube ITA Tutorial: Capire il formato #geojson con QGis ►https://goo.gl/ilONnQ
 ·  Translate
1
Add a comment...

Mark Percival

Discussion  - 
 
I know this is off-topic but could people tell me what system they are using to manage their LLPG - we have to change next year so i'm trying to gather information on the options and how they fit in with QGIS.

Any replies welcome.
1
Simon Miles's profile photoRoss McDonald's profile photo
3 comments
 
IDOX Uniform for LLPG and QGIS plugin for LSG @ Angus Council.
Add a comment...

Mark Percival

Discussion  - 
 
Recently started work at Rugby Borough Council and they have MSSQL as their standard back-end databases.
I've never used these with QGIS before and am having trouble getting spatial objects (mainly points) into QGIS.  I ca odbc into the tables and views and see them ok but cannot seem to get QGIS to recognize the X & Y columns.

If anyone has experience of setting MSSQL as spatial please let me know - it will allow me to keep my hair a tad longer!!
1
Mark Percival's profile photoChris Page's profile photo
10 comments
 
I suggest you use SQL Server Profiler to troubleshoot:

From Microsoft SQL Server Management Studio, open SQL Server Profiler

Record trace whilst accessing your MSSQL table from QGIS

Save trace to SQL Table

Report on Trace for your user over this period
SELECT [RowNumber]
,[EventClass]
,[TextData]
,[ApplicationName]
,[NTUserName]
,[LoginName]
,[CPU]
,[Reads]
,[Writes]
,[Duration]
,[ClientProcessID]
,[SPID]
,[StartTime]
,[EndTime]
,[BinaryData]
FROM [BDUK 3.0].[dbo].[db Trace]
WHERE [NTUserName] = 'page.c4'



Copy TextData to see the SQL commands

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
exec [sys].sp_datatype_info_100 11
SET QUOTED_IDENTIFIER ON
SET QUOTED_IDENTIFIER ON
SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'geometry_columns'
SELECT count(*) FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'geometry_columns'
select f_table_schema, f_table_name, f_geometry_column, srid, geometry_type from geometry_columns
select f_table_schema, f_table_name, f_geometry_column, srid, geometry_type from geometry_columns
exec sp_columns @table_name = N'QGIS AB Premium 2015-11-25', @table_owner = 'dbo'
exec sp_columns @table_name = N'QGIS AB Premium 2015-11-25', @table_owner = 'dbo'
exec sp_pkeys @table_name = N'QGIS AB Premium 2015-11-25', @table_owner = 'dbo'
exec sp_pkeys @table_name = N'QGIS AB Premium 2015-11-25', @table_owner = 'dbo'
select count(distinct [UPRN]), count([UPRN]) from [dbo].[QGIS AB Premium 2015-11-25]
select count(distinct [UPRN]), count([UPRN]) from [dbo].[QGIS AB Premium 2015-11-25]
SELECT min(bounding_box_xmin), min(bounding_box_ymin), max(bounding_box_xmax), max(bounding_box_ymax) FROM sys.spatial_index_tessellations WHERE object_id = OBJECT_ID('[dbo].[QGIS AB Premium 2015-11-25]')
SELECT min(bounding_box_xmin), min(bounding_box_ymin), max(bounding_box_xmax), max(bounding_box_ymax) FROM sys.spatial_index_tessellations WHERE object_id = OBJECT_ID('[dbo].[QGIS AB Premium 2015-11-25]')
select min([Geom].STEnvelope().STPointN(1).STX), min([Geom].STEnvelope().STPointN(1).STY), max([Geom].STEnvelope().STPointN(3).STX), max([Geom].STEnvelope().STPointN(3).STY) from [dbo].[QGIS AB Premium 2015-11-25]
select min([Geom].STEnvelope().STPointN(1).STX), min([Geom].STEnvelope().STPointN(1).STY), max([Geom].STEnvelope().STPointN(3).STX), max([Geom].STEnvelope().STPointN(3).STY) from [dbo].[QGIS AB Premium 2015-11-25]
NULL
-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
exec [sys].sp_datatype_info_100 11
SET QUOTED_IDENTIFIER ON
SET QUOTED_IDENTIFIER ON
SELECT [UPRN],[Geom]FROM [dbo].[QGIS AB Premium 2015-11-25] where [Geom].STIntersects([geometry]::STGeomFromText('POLYGON((342221.55042812105966732 226965.69515125697944313, 515924.45062615891220048 226965.69515125697944313, 515924.45062615891220048 311440.30645778297912329, 342221.55042812105966732 311440.30645778297912329, 342221.55042812105966732 226965.69515125697944313))',27700)) = 1

These commands can be issued from Microsoft SQL Server Management Studio where you will be able to see if they produce errors.

Add a comment...

Michael Spencer

Discussion  - 
 
I've been trying out CartoDB via the QGIS plugin. Here's a map showing the distance from Scottish postcodes to the nearest train station, using Ordnance Survey Open Roads and network analysis in GRASS.
Map to show the distance from Scottish mainland postcodes to the nearest train station, by road. Map uses Ordnance Survey OpenData: Open Roads; Code-Point Open; Strategi. Contains Ordnance Survey data © Crown copyright and database right 2016. — Map created by Mike Spencer in CartoDB
6
1
Matt Davies's profile photoMichael Spencer's profile photo
9 comments
 
It's a shame it doesn't include ferry routes...
Add a comment...

Matt Travis
moderator

Discussion  - 
 
There are still reduced price tickets available for the Foss4guk conference in June (14-16th). There are loads of great presentations and workshops about QGIS and many other open source tools.

If you have got a ticket already and still haven't got a party ticket please go and do so soon as the organisers need to get the final number. The venue and food sound great and if they get enough numbers they can secure a DJ playing geo themed tunes!

Finally, there is a QGIS code sprint on the Thursday and the tickets are free. If you're interested in helping the QGIS project, no matter what your ability, please sign up.

It's going to be a great event and I'm looking forward to seeing you there.

Cheers, Matt

5
Lutra GIS's profile photo
 
We will publish a blog post later today/this weekend with more details of the things your need to prepare in advance.
Add a comment...

Tom Armitage

Discussion  - 
 
Here is a sneak preview of the workshop I'll be running at FOSS4G UK in June.

There is a post about creating animated heat maps from geoparsed books here:
http://bit.ly/MappingBooks

...and a YouTube video of the final animated map here:
https://youtu.be/JXlb6MV2Qd8

The workshop is called Visualising Arts and Humanities Data in QGIS, I hope a few of you can make it!
4
Add a comment...

Lutra GIS

Discussion  - 
 
A quick note on how to set up and configure Discovery plugin in QGIS to work with the +Ordnance Survey Open Names dataset:
As a part of migrating to Open Source GIS, the Newcastle City Council has commissioned us to create a user friendly gazetteer plugin. In this post, we will import the OS Open Names and configure the Discovery plugin to use the data. In the following sections, we are going to set up a PostGIS ...
3
Add a comment...

Ross McDonald
moderator

Discussion  - 
3
Add a comment...