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 : 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
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…
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…