Set Up the PostgreSQL Database
Welcome back! You’re ready to build the foundation for a GIS enabled web application. This video will walk you through installing the necessary components for our app, starting with our database system. For review, these are the components of our application:
The data is stored in PostGreSQL with the PostGIS extension. Because we have a GIS enabled database, we will also want a GIS-enabled model, which is able to recognize and work with geographic queries. We can achieve this on our Django web application by enabling the GeoDjango framework.
GeoDjango needs a few dependencies to operate correctly, such as GDAL, GEOS and PROJ.4. These drivers can be installed individually, but getting them to install and work correctly can be tricky.
Since the objective of this tutorial is to get you up and running quickly with a simple location-aware app, we will install an open-source GIS application called QGIS, which just happens to install these drivers correctly and efficiently. The only caveat is, at the time of this video recording, QGIS does not yet work with Python 3.7 so if you don’t have it installed already you’ll need a copy of Python 3.6 on your system as well.
You’ll be installing our components in this order: PostgreSQL with PostGIS extension, followed by a copy of Python 3.6 (if you don’t have it already installed). After that, QGIS (so we have an easy driver installation), then Django through Pip followed by enabling GeoDjango. And if you stick around, I’ve also included a bonus video on adding Leaflet mapping to your web page.
Comments & Discussion
Become a Member to join the conversation.