-
Recent Posts
- MS Access Function – import all CSV files from a directory with the same structure into a single table
- MS Access Function – Scan through a directory and write list of files to a table
- MS Access – Code Snippets for Navigating using Internet Explorer
- MS Access Front End – Linked to PostGreSQL back end – a simple walk through using Access 2003
- MS Access Function Collection that can be used to Generate Housing Forecast Figures
- AHK – Useful AutoHotKeyScripts for Outlook specifically
- AHK – Useful AutoHotKeyScripts
- Navigate to Website directly from MS Access using Internet Explorer
- Add Open Street Map to Background QGIS Project and then Digitise against imported Raster
- Links to GIS information for test system design
- MS Access 2010 – Simple Function to loop through a list and Print to file an individual PDF
- SQL SERVER – Create TSQL Trigger to add date to existing record after INSERT or UPDATE
- MS Access – VBA Functions – Create Category Tag Junction Table by comparing a text field against a table of categories
- MS Access – VBA – Open Form and go to record from unbound List Box
- Simple Bat File to open multiple Web Pages in One Browser Window with alternate Tabs
- Pivoting Relationships from Many to Many – One to Many – One to One – and then Key Value – Relationships and Schemas
- SQL Azure – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value
- MS Access – SQL to Select Distinct list of Child Records based on a Maximum or Minimum Child Field Value
- Javascript – Nubuilder Specific to save Date to DateUpdated field on Record Change (not subform)
- SQL Azure link to managing permissions
Archives
- May 2018 (2)
- April 2018 (1)
- March 2018 (6)
- February 2018 (2)
- January 2018 (1)
- November 2017 (4)
- October 2017 (2)
- September 2017 (3)
- 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)
Category Archives: QGIS 2.8.1
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
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
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