Tags » PostGIS

PostgreSQL & PostGIS command line introduction

This post highlights some very useful commands for entering spatial data into a PostgreSQL database ready for analysis within GIS or using Postgis.

For entering spatial data into PostgreSQL you can either use the… 191 more words

Command Line

Migrating a PostGIS Database to MySQL Spatial Extensions (and vice versa)

Need to migrate a spatial database from PostGIS to MySQL but don’t want to install any new tool? If yes, then this post is for you. 244 more words

Database Migration

Installing the TIGER Geocoder with RHEL 6.6, PostgreSQL 9.4, PostGIS 2.1.7, and the TIGER 2013 Census Data

Yeah, I know we’re stuck with the TIGER 2013 census data, but the 2014 data doesn’t work easily with PostGIS 2.1.7; PostGIS 2.2, which is still in development, will support the 2014 dataset.  1,271 more words

Information Technology

TUTORIAL - Creating a PostGIS -database for QGIS PART 2

Source code
This is for everyone trying to learn about PostgreSQL, PostGIS and QGIS. This tutorial was created with Windows 7, PostgreSQL 9.4, PostGIS 2.1 and QGIS 2.8.2 Wien. 276 more words


This is strange, but I was unable to find instruction about importing QGIS layers into PostGIS database with PyQGIS API. The PyQGIS cookbook has the example of exporting layers as .shp-files via QgsVectorFileWriter.writeAsVectorFormat() function and says that the other other OGR-supported formats are available to use in this function as well. 261 more words


How to graphically compare the size of two countries

To overlay two countries, move them so that their centres are over the same point (eg 0, 0). The trick is to make sure that they stay the same size, and don’t get too distorted in the process. 223 more words

Geo Data

Scenic flight 3D

We’ve previously seen that our Air Safaris Scenic flight was close to the advertised flight path. To add some 3D information I’ve found a 8m… 94 more words

Geo Data