Skip to content
Archive of entries posted on

PostGIS 2.1 on Debian 7

Newly released PostGIS 2.1 rocks.. How can I install it on a fresh Debian 7 ‘wheezy’ to try it out? Here is a recipe that worked for me: — Final Results debian_version 7.1 PostgreSQL 9.1.9 on x86_64-unknown-linux-gnu ———————————————– myrole=# select postgis_full_version(); POSTGIS=”2.1.1dev r11823″ GEOS=”3.4.2dev-CAPI-1.8.0 r3897″ PROJ=”Rel. 4.7.1, 23 September 2009″ GDAL=”GDAL 1.11dev, released 2013/04/13″ LIBXML=”2.8.0″ […]

Sizing Up California – Homes

I live in California, and it’s a big place. I was reviewing some records regarding residential homes. Using some simple stats, I broke the records into partitioned tables in PostgreSQL by county, and then let the rest fall into a general bucket. There is no one correct answer for this kind of analysis setup, but […]