hunt3ri.github.io

Articles in the Programming category

1. Address Search OS OpenNames with PostGIS, SQLAlchemy and Python – PART 2

   In Part 2 we look at writing a simple Python 3 CLI app that will show you how easy it is to integrate this powerful functionality into your apps and APIs. Other than Python the only dependency we need is the SQLAlchemy ORM to let our app communicate with Postgres

2. Address Search OS OpenNames with PostGIS, SQLAlchemy and Python – PART 1

   In this two part post we’ll look at implementing an address search using the Ordnance Survey Open Names dataset. We’ll use the power of Postgres with the PostGIS extension leveraging it’s built in Full Text Search, and use Python and the SQLAlchemy ORM to create a simple CLI.