Stream

Shaun Lewis

Discussion  - 
 
Hi all. QGIS Cymru has changed its name to FOSS4G Cymru! The next event is on 19th October at the Principality Stadium. If you'd like to speak, please let me or +Kevin Williams know.

https://www.eventbrite.co.uk/e/foss4g-cymru-2016-tickets-27760768205
FOSS4G Cymru, Wednesday 19th October 2016 QGIS Cymru has changed its name to FOSS4G Cymru! Objectives Promoting the use of Open Source Geospatial software with its associated cost savings and benefits. Sharing Knowledge and experiences, providing real examples of use. Sharing training resources including digital and class-based. Sharing and collaboration on common code Removal of duplicated effort. Feedback and sharing with the UK group...
2
Kevin Williams's profile photoJo Cook's profile photo
5 comments
Jo Cook
 
Sure, that's a great idea :-) There is a process to go through to create one, but you guys would walk through most of it because you have a strong following already. See http://wiki.osgeo.org/wiki/Local_Chapter_Guidelines The UK chapter would be more than happy to support/advise/assist too. Since this is getting off-topic from your original post, feel free to drop me an email to discuss more if you like
Add a comment...

Ross McDonald
moderator

Discussion  - 
 
Would you like to present something at the next #QGIS User Group meeting in Scotland? It's at the Informatics Forum, University of Edinburgh on 3rd November 2016. We're looking for lightning talks (5-7min) and longer talks (20-25min) on QGIS & #FOSS4G.

Art Lembo (Assoc. Prof in GIS, Geography and Geosciences at Salisbury University, MD, USA) will be talking about terrain analysis with massively parallel processing techniques: a QGIS plugin with pyCUDA and NVIDIA graphics cards. Apparently known as "embarrassingly parallel solutions" because they are so fast.

Phil Taylor will be asking how deep is your loch.

EDINA on packaging and deploying QGIS across the University

Angus Council on managing street gazetteer and associated data at the new standards using QGIS and PostGIS

<your name here> will be talking about <your topic here>.

Shall we run a workshop session this time? What would you like? What have you got to offer?

Ordnance Survey and thinkWhere have offered to support the event again but from initial excitement it looks like we might have 100 folk wanting to come along. We'll need another sponsor or may have to forego the usual scrumptious morning snacks, lunch and afternoon coffee. Any offers?


4
1
Add a comment...

Michael Spencer

Discussion  - 
 
I need to convert 650 OS national grid references to easting and northing (m). I've seen some of the online conversion tools, has anyone come across a package for R/Python/QGIS/Grass/etc. that I can incorporate into a workflow? Failing that, which online (batch) conversion tool do you prefer?
4
Tom Armitage's profile photoMichael Spencer's profile photo
6 comments
 
Seems the R package didn't like NGRs of different lengths. As it's FOSS, it was easily solved! https://github.com/cvitolo/r_rnrfa/pull/4
Add a comment...

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...

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...

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...

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.

Ross McDonald
moderator

Discussion  - 
 
Tickets!

https://www.eventbrite.co.uk/e/uk-qgis-user-group-scotland-tickets-27955482601

QGIS UK user group meeting in Edinburgh.

We're still looking for a couple of speakers, so if you have something you want to share, let me know!
The 6th QGIS UK user group meeting in Scotland. A free one day event supported by thinkWhere, Ordnance Survey, Angus Council, Cawdor Forestry, EDINA at the University of Edinburgh (and eeGeo). The programme will include lightning talks and presentations on QGIS and FOSS4G. There will be something for everyone from newcomers to open source veterans. Draft programme 09:30 Registration: Coffee + Treats 09:45 Welcome 10:00 Talk 1 10:30 Talk 2 11:00...
5
1
Add a comment...

Lutra GIS

Discussion  - 
 
Editing raster cell values directly in QGIS through Serval plugin:

http://www.lutraconsulting.co.uk/blog/2016/09/05/serval/
Users can directly edit raster cell values using Serval plugin in QGIS. Read more for how to use this plugin… How to use Serval. Serval is available from QGIS plugin repository. Note that you will need to restart QGIS if you upgrade Serval from an earlier version.
4
Joshua Dickerson's profile photo
 
Nice work guys, looking forward to giving this a go!
Add a comment...

Matt Travis
moderator

Discussion  - 
 
Tickets available for the next South West QGIS event here.

We still need speakers if anyone is interested.
We are holding a QGIS user group meetup on Thursday 29th September at Dartmoor National Park. Tickets are free which is thanks to Clearmapping company who are sponsoring 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.
7
Antony Scott's profile photoMatt Travis's profile photo
2 comments
 
That sounds great thanks Ant. 
Add a comment...

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.
5
Sam Lavender's profile photoMatt Travis's profile photo
2 comments
 
Excellent news. We have spare slots at the moment so I'll pencil you in.
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
2
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...

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...

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...