Building a US Census Tracts PostGIS Database

This article shows how you (yes, you!) can build your very own US Census Tracts PostGIS database. I had looked over the interwebs for some time under the false assumption that someone, somewhere would have already done this, but it seems not. So this article documents my process. I am running a mac, so some […]

ogr2ogr 3D Shapefile Import to PostGIS Tip

A very quick tip for those scratching their heads over trying to import a 3D shapefile (which doesn’t actually have any 3D data, or at least none you care about) into a flat (2D) PostGIS data set and you keep getting a geometry constratint error.  with a command like: ogr2ogr -update -append -f PostgreSQL PG:”dbname=postGISdatbase” […]