Postgres 4 Planners : CSV Export Tool
So a sister tool to CSV Import created because I was faced with a situation where I wanted to export a view (Housing Land Audit data in this case) into…
Postgres 4 Planners : QGIS optimisation – SAVE database connection
Example here QGIS v3.40 Bratislava Opening projects in QGIS can result in multiple and continual requests to authenticate every database connected to a project. This gets old quickly. You will…
OS Open Network – Shortest Route Measurement
It is February 2019 and I had written about using pgrouting to display the shortest distance between 2 points on a network using Postgres and the Ordnance Survey Network on…
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…
Protected: 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…
Protected: Postgres 4 Planners : SHP File Command Import Tool
Unfortunately - the shape 2 pgsql command cannot be installed separately (easily ie without resorting to binary files) using the psql tool separate installer. So it is easier just to…
Protected: Postgres 4 Planners: Dump and Restore Tool
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…
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…
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…
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…