Tags » PostGIS

Misleading maps attempt 0: Replication

My first attempt at solving the misleading TFL maps problem is to replicate the maps, centred on Salisbury. The contour lines are based on arbitrary Google Maps routes. 36 more words

Geospatial Problems

OSGeo Code Sprint, Vienna

This is how OSGeo happens.  These are the folk who bring us a lot of that open-source geo-spatial goodness. You can follow the code sprint on Twitter using the hashtags #csprint and #viennacodesprint14… 87 more words

User Groups

Packt Sale -- 2 books for the price of one

Now I feel like a salesman. I feel obliged to mention the Packt buy one get one free sale (ends tomorrow):


If you want a postgresql title to go with the PostGIS Cookbook (just sayin’): 27 more words


How to install PostGIS 2.0 on Ubuntu 12.04 LTS (precise) from source

Adapted from: http://trac.osgeo.org/postgis/wiki/UsersWikiPostGIS20Ubuntu1204src

Spatially enabling a database

With PostgreSQL 9.1, there are two methods to add PostGIS functionality to a database: 
- using extensions, 
- using enabler scripts. 217 more words

FOSS4G is in Portland this year

This one’s for the PostGIS folks:

FOSS4G, the Open Source Geo conference, is being held in Portland this year.

The CFP is open now, available here, and closes April 15.


Setting up a PostGIS database for custom geonode app

Last time we setup a custom Geonode project based on Geonode template.

Lets setup a spatial database using PostGIS (PostgreSQL 9.3.3) to store spatial data. 403 more words


PostGIS Cookbook(s)

This is starting to feel real…

PostGIS Cookbook(s).  2904 pages.

Page count for a single book can be calculated as in the following code:

WITH distinction AS (
    SELECT DISTINCT( the_text) AS pages FROM postgis_cookbook
SELECT COUNT (pages) AS "Count of Pages" FROM distinction;
… 99 more words