We will transform the census data from a shapefile to a PostGIS table. Unless you already have a PostGIS installation, we will first need to build it up. You can install PostGIS in several ways, and official and user documentation on customized installation is widely available. In order to get you started, we will use nice packages freely distributed from EnterpriseDB™. Apart from choosing the proper binary package, the installation runs the same way on Linux or Windows:
- Open your browser and point it to https://www.enterprisedb.com/advanced-downloads; the page lists all available packages, both free and commercial. Scroll down to the Option B - POSTGRESQL section. Here, we can find the interactive installer ...