-
Recent Posts
- SQL Azure link to managing permissions
- SQL Azure – Take Complete Backup of Azure Database (Structure and Data)
- Connect MS Access 2003 to MySQL
- VBA : Scripting in MS ACCESS to run multiple Queries consecutively
- VBA Code : Run a Function and Link Functions together ( or Scripting in MS Access)
- Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line
- VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server
- SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables
- MS Access VBA Function (Part 5) – Run SQL Queries from a table
- MS Access VBA Function (Part 4) – Write queries to a table
- MS Access VBA Function (Part 3) Address Matching – Find X Replace Y
- MS Access VBA Functions (Part 2) Address Matching – UK Postcode String Finder
- MS Access VBA Functions (Part 1) Address Matching – Add and Drop Fields
- MS Access – Separate Number from a combined Number Street Field
- MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group
- MS Access VBA Function – create UID starting at prescribed number
- Linking to SQL Server / Oracle – don’t skip the set key field on linking
- MS Access VBA Function – Loop through Query Objects and write SQL to Table
- MS Access VBA Function – Automated Multiple Query Object Creation from previously created table of SQL
- Chrome v:56.0.2924.87 – Run Web Applications in Application Mode
Archives
- September 2017 (2)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- August 2012 (1)
Category Archives: Digital Mapping
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 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
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 Digital Mapping, Eastings and Northings, Geographical Information Systems, Longitude and Latitude, Ordnance Survey, VBA Code MS Access
Comments Off on VBA Function Collection for converting Eastings and Northings to Latitude and Longitude