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