Tags » PostGIS

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

I know there are a number of guides on this matter out there, but it still took me enough work to get this process right for my particular distribution (RHEL 6.6 in this case) that I hope it’ll be valuable to others as well, so here’s the procedure I performed to get this up and running! 1,206 more words

Information Technology

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

Imagine there's no countries

Imagine there’s no countries.
It isn’t hard to do.

Imagine unioning all of the countries (turning all of the separate shapes below into one) … it turns out to be harder than I thought.

124 more words
Geo Data

Setting up PostGIS on AWS RDS PostgreSQL Database Server

The greatest capability of PostgreSQL database, in my opinion, is the PostGIS extension. The AWS RDS creation procedures for PostgreSQL does not set up this extension by default. 234 more words


PostgreSQL: An Analyst's Best Friend

There is a common belief that databases are best only in certain situations, namely when the data is large, when the data is complex, or when there’s enough time to properly design a schema in order to contain the data.  820 more words