Archive for January, 2009

Getting to know PostGIS Part II

Published by Jonah on January 30, 2009 in geospatial, gis, linux, oss, software and ubuntu. 1 Comment

So its been over six months since I made my first tutorial post about PostGIS. I now use PostGIS on a regular basis and thought it would be good to update the tutorial with some meat on how to use PostGIS.

Get some data and import it

Grab populated places points

wget http://edcftp.cr.usgs.gov/pub/data/nationalatlas/citiesx020.tar.gz

Grab US counties map:

wget http://edcftp.cr.usgs.gov/pub/data/nationalatlas/countyp020.tar.gz

Lots more data available in the National Atlas
Continue reading ‘Getting to know PostGIS Part II’