Postgres 4 Planners : Housing Land Audit Automation
Simple Question : Using automation can we get an idea of completions on Scotlands Housing Land Supply sites only from open source data? Here I use the Ordnance Survey's Open…
Postgres 4 Planners : CSV Import Tool
Requirements - psql tooling installed locally link It continues to be outrageously easy to use AI to help create tools that assist in daily tasks. Here I create a simple…
Postgres 4 Planners : SHP File Command Import Tool
Requirements : psql tooling installed locally link Identify the shape file you are wanting to import move it to a c:\shp\ directory and then using your known server parameters run…
Geoserver WFS Creator 2.0.0 Tool
Its possible to limit the number of layers that are brought back from a capabilities request to a Geoserver. I have not been able to limit to an individual layer…
Postgres 4 Planners: Remote Backup and Remote Restore of a Single Database (using command line tools & custom format *.dump)
MY PREFERRED METHOD (Databases or Tables- here from Windows client) Overview (click to go straight to STEP) STEP 1 : Preparation STEP 2 : Make the Dump File* STEP 3 :…
OpenStreetMap : Participation is easy
I have been a contributor to the Open Street Map dataset on a very minor level for about 8 years now and I would recomend it to anyone doing research…
Overpass Turbo : Churches and Cathedrals
If you haven't used it before Overpass Turbo is a website that allows the user to interrogate the global OpenStreetMap database. This is excellent for identifying at scale building types…
Overpass Turbo : Schools
Following on the theme of using Openstreet map to identify spatial context of building here's the syntax to identify schools within a bounding box defined as your selected field of…
MapLibre / Leaflet / OpenLayers – a quick overview
So I've been investigating Javascript mapping libraries and I've had a chance to investigate three. I've been working with them and chatGPT to build basic applications using data from the…
IDOX – Using Public Access to Find Planning Applications
This Guide in PDF FormatDownload . A significant number of authorities in the UK have the same software that allows members of the public viewing access to most of their…
IDOX – Public Access – Online Comments
Procedure for making online comments Register online at the public planning portal sign in and then navigate to the application you are interested in e.g. 0816/FUL/24 Using your online account…
AI Experimentation Example
I thought it would be fun to show you the kind of things that I am using AI for. Here I take a visual basic script that created a set…
Postgres 4 Planners : Automating Site Constraint Checks
Introduction In terms of the Housing Land Audit , Employment land and Vacant and Derelict land it is important to quickly identify what constraints/policies and education catchment areas a site…
Geoserver Installation (Configuration for SQL Server on Windows)
Once you have your data in an Enterprise Grade database sharing that information becomes important. Some vendors, in particular Digital mapping SAAS vendors want you to transfer your data into…
Add POSTGIS extension to Azure Postgres Database – Worked Example
Firstly we need to allow for the extension on the server.Within the Azure portal navigate to server parameters Search for azure.extensions Select which extensions to addREMEMBER to save before exit! Wait…
Spatial Data Hub Scotland
Planning in the UK has for a long time suffered from a classic siloing of data by authority resulting in slow and varied analysis of information. Authorities relied on talented…
Geoserver – CREATE View
Geoserver has this really great feature whereby admins are able to create views that are held with the configuration of the Geoserver but separate from the database. This allows admins…
GeoServer and ORACLE – WFS & WMS Config Tips
This post is a brief description of my findings on setting up Geoserver from scratch and some particular points on setting it up for an Oracle connection. I hope it…
ArcGIS Online (AGOL) – Observations and Reflections
Pros I recently started using ArcGIS Online (AGOL), a platform that seems to be widely regarded as a solid choice for online mapping. So far, I’ve found its user interface…
WordPress 4 planners – Introduction
Why you need it? You want to record procedures, you need multiple people to access one source, you are struggling with version control with your current sources, you need to…
Mapping Portals & Map Constraints
Historical Environment Scotland Map Portal – Listed building / Conservation Areas / Scheduled Ancient Monuments Coal Authority Interactive Map Viewer – Coal Mining Risk Assessment High Risk Areas Sites of Special Scientific…
Postgres 4 Planners : Basics of Database Administration
A lot of organisations don’t realise this but nearly all simple datasets with more than 10 records with 10 distinct attributes which need to be regularly edited by one or…
Postgres 4 Planners : Slow Changing Dimension
Immutable Identification of Maximum/Latest Minimum/Earliest As you gain experience with SQL and database queries, their power becomes increasingly evident. However, it's important to understand that there are both optimal and…
Postgres 4 Planners : Install psql without PostgreSQL
This is a slightly more advanced topic looking at something called psql which is a command line tool which you will want to do if you are doing basic database…
Postgres 4 Planners : Developer Contributions – Flexible Database Structure for accurate Policy Record maintenance
This is my attempt at creating a Postgres database schema that can be used by any authority or planning agency to record all development contribution policies. It is more likely…