Category Archives: QGIS General

Creation of SITE History from Planning Application Polygons using QGIS

In planning it is important to know the planning history on a site. The status and likelihood of approved permission will often relate to previous permissions. Many council planning systems do not specifically relate planning applications to each other and … Continue reading

Posted in Continual Professional Development, Digital Mapping, Geographical Information Systems, GIS, QGIS 2.8.1, QGIS General | Comments Off on Creation of SITE History from Planning Application Polygons using QGIS

QGIS – Import shape file into PostGIS Table

The following uses QGIS 2.14.2 Essen and PostGres 9.5 A number of local authorities have released information through the UK’s data government site. The following example uses a shape file obtained from Lichfield District Council – At 2nd of October … Continue reading

Posted in All, Geographical Information Systems, GIS, PostGIS, Postgres, QGIS General | Comments Off on QGIS – Import shape file into PostGIS Table

QGIS 2.8.1 – Useful Functions and Operators – Field Calculator

Calculate eastings and northings of centroid within polygon layer xmin(centroid($geometry)) ymin(centroid($geometry)) Calculate area and perimeter of a polygon layer $area $perimeter Calculate eastings and northings of a point layer $x $y Calculate the length of a line layer $length Capitalise … Continue reading

Posted in All, Digital Mapping, QGIS 2.8.1, QGIS General | Comments Off on QGIS 2.8.1 – Useful Functions and Operators – Field Calculator

QGIS 2.8.1 Raster / Extraction / Clipper – Extent Quick Reference

Raster Extraction Conversion guide landscape paper standard scales -SRID27700 Assumes that you are taking the map to the very edge of a landscape paper if you require a border you will need to use formula. Reverse calculations for portrait papers

Posted in All, Geographical Information Systems, QGIS 2.8.1, QGIS General | Comments Off on QGIS 2.8.1 Raster / Extraction / Clipper – Extent Quick Reference

Connecting to PostgreSQL 9.3 from QGIS 2.8.1 – local host

First ensure that you have both Postgres and QGIS installed on your machine. In order for you to be able to connect to Postgres from QGIS on local host you must ensure 2 things. Firstly that the PostGIS plugin has … Continue reading

Posted in All, Geographical Information Systems, GIS, PostGIS, Postgres, QGIS General | Comments Off on Connecting to PostgreSQL 9.3 from QGIS 2.8.1 – local host

QGIS 2.8.1 Updating Copyright Label in your QGIS Projects

Specific example QGIS 2.8.1 probably same in other versions. Ensure you have copyright quote correct on QGIS projects View / Decorations / Copyright Label

Posted in All, Configuration, QGIS 2.8.1, QGIS General | Comments Off on QGIS 2.8.1 Updating Copyright Label in your QGIS Projects

Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Programs used; 1- SQL Server 2008R2 Express 2- SQL Server Management Studio 2008R2 Express 3- QGIS The example uses UK national grids coordinates to create a Triangle Polygon in a SQL Server Table I’ve previously written that while we’ve had … Continue reading

Posted in All, Configuration, Database Design, Dev Ops, QGIS General, SQL 08 R2, SSMS | Comments Off on Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

The following TSQL will spatially enable a SQL Server Table called T1RainbowTable when it has two Fields called East and North with UK National Grid References. UPDATE T1RainbowTable SET Coordinates=geometry::Point([East],[North],27700)

Posted in All, Database Design, Dev Ops, QGIS General, SQL 08 R2, SQL Server, SSMS | Comments Off on Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

Connecting to SQL Server – authentication and QGIS

Within QGIS when you set up a connection to a MS SQL Server instance you are presented with two options. Here’s a bit of clarification on what the two options entail. * Trusted connection – this is the same thing … Continue reading

Posted in All, Configuration, QGIS General, SQL Server | Comments Off on Connecting to SQL Server – authentication and QGIS

Introduction to Basic Printing QGIS 2.2

Creating maps that you can pass on to others is often a central and regular requirement if not in paper format then in a digital format that can be e-mailed or printed out. Here’s a quick reference for myself as … Continue reading

Posted in All, Digital Mapping, Geographical Information Systems, GIS, QGIS 2.2, QGIS General | Comments Off on Introduction to Basic Printing QGIS 2.2

QGIS – Free GREAT Digital Mapping Software

A map showing winds over the Atlantic Looking for a desktop digital mapping package? You really need to check out QGIS it is an absolutely excellent open source geographical information system. At the time of writing the latest version was … Continue reading

Posted in All, Digital Mapping, General Opinion, Geographical Information Systems, Open Source, QGIS General | Comments Off on QGIS – Free GREAT Digital Mapping Software