Category Archives: Geographical Information Systems

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 Getting Shape Files into SQL Server 2008 Express R2

For digital mapping the shp extension is the equivalent of csv files – A significant amount of information is still held in shape files and even if it is not, nearly every GIS package can export to shape format. It’s … Continue reading

Posted in All, Geographical Information Systems, QGIS 2.8.1, SQL 08 R2, SQL Server, Win 8.1 | Comments Off on QGIS 2.8.1 Getting Shape Files into SQL Server 2008 Express R2

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

Enabling Geospatial integration in applications.

Despite the fact that spatially enabled databases have been around pretty much everywhere for quite sometime there’s still a heck a lot of enterprise applications out there that are not using the feature even though their backends support it. SQL … Continue reading

Posted in All, Database Design, Geographical Information Systems, SQL 08 R2, SQL Server | Comments Off on Enabling Geospatial integration in applications.

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

VBA Function Collection for converting Eastings and Northings to Latitude and Longitude

Some years back we hired a young lad by the name of Iain Brodie on a temporary contract – The week before I had been at an ESRI conference which had extensively discussed Web Mapping and  a speaker had demonstrated … Continue reading

Posted in All, Applied Mathematics, Digital Mapping, Geographical Information Systems, GIS, VBA Code MS Access | Tagged , , , , , | Comments Off on VBA Function Collection for converting Eastings and Northings to Latitude and Longitude

VB Function for Zooming to location in Google Maps at 23 March 2014

Google recently slightly altered their URL to link to Google Maps. This code passes eastings and northings from fields into a function that calculates Longitude and Latitude and then passes those calculated coordinates to the google maps url for display … Continue reading

Posted in All, Geographical Information Systems, GIS, MS Access, VBA Code MS Access | Comments Off on VB Function for Zooming to location in Google Maps at 23 March 2014