Sparkblog

Building a US Census Tracts PostGIS Database

Posted by: Will Cadell in postgis technology open source tools ogr2ogr 4 years, 5 months ago

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 things could be done faster / smarter using other technology refinements, but I have tried to keep things pretty generic for 'nix users. Windows people; you will find this process is pretty simple, I am sure you can replicate it using what you have available.

read more / Comments

GIS - Human Translation Services

Posted by: Will Cadell in GIS 4 years, 5 months ago

I remember in a previous job, I had to travel 2000kms on two flights to spend three nights in our Alberta head office to, in the end, act as a translator between a forester and a GIS resource. Although there was an ethnic difference, it was clear that the information gap was caused by the differences between those who could speak GIS and those who could not.

read more / Comments

Python Geospatial Development Published

Posted by: Will Cadell in postgis technology open source tools GIS 4 years, 5 months ago

Will Cadell was recently a technical reviewer on the latest edition of Python Geospatial Development.

read more / Comments

ogr2ogr 3D Shapefile Import to PostGIS Tip

Posted by: Will Cadell in postgis GIS ogr2ogr 4 years, 5 months ago

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. 

read more / Comments

SF Geo Meetup Ignite Talk

Posted by: Will Cadell in technology open source tools 4 years, 6 months ago

I recently presented at the San Francisco Geo Meetup. It was during the Google I/O conference and it was great to be able to hook up with a bunch of geo people to talk mapping and geospatial!

read more / Comments

Recent Posts

Archive

2017
2016
2015
2014
2013
2012

Categories

Tags

Authors

Feeds

RSS / Atom