Tags » PostGIS

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


Shapefile Importer GUI for PGAdmin3 (for mac)

I had been struggling to add the Shapefile importer tool to PGAdmin3 for a PostGIS database we’re working on in my class but I figured out an alternative! 185 more words

Automatic spatial object mapping with GeoDjango

This tutorial shows how to examine Shapefiles files obtain interactive information through the console and create Pythonic code to use it directly as a Django App. 9 more words


Painless PostgreSQL + PostGIS + bc250 from IBGE setup with admin tips

This is my collection of notes on how to install and configure PostgreSQL (v9.4) and PostGIS (v2.1) from the official repository and how to load the bc250 dump from IBGE. 868 more words


Normalizing tables in PostgreSQL: experiments with Fulcrum

Fulcrum by Spatial Networks is an interesting and very useful hosted service for collecting geo data in the field with whatever smartphone or tablet you already own.  505 more words