Open Source ETL Tools

Moving spatial data into Postgres isn’t difficult to script. Suppose you have the shapefile ponies.shp in WGS84, and you want to dump it into PostGIS as ponies. A plain old batch script like this will do it for you: shp2

Read More...

PostgreSQL Upgrade Hack

Here’s a handy tip for you Postgres admins on Windows if you’re getting a “insufficient privileges” error on a minor rev (i.e. 8.3.3 to 8.3.6) upgrade. This tip falls squarely into the hack realm, so use your best judgme

Read More...

You Sank My Battleship and Other News

I’ve got a collection of things I’ve bookmarked that I thought were interesting, but none of them together were interesting enough for a blog post. Going under the belief that a great many mediocre stories = one good sto

Read More...

GIS Bailout Money to Make Benefit Glorious Nation of USA

This has been analyzed so much in the blogosphere I feel a bit late to the party. But in a nutshell, Jack Dangermond (ESRI) and Anne Miglarese (Booz Allen Hamilton) have proposed getting $1.2 billion in bailout funds for

Read More...