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