PDXPUG - PostGIS and the Census Data
Most classes require prior sign up. Please check in at the front desk when you arrive to let them know you are here for the class. Bags must be checked at the front entrance.
Webb Sprague will be speaking about PostGIS and the Census Data at the next PDXPUG meeting at FreeGeek (at 7:00pm - 1731 SE 10th Avenue, Portland, OR).
Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab http://www.luckylab.com/ ) at 915 SE Hawthorne Blvd. afterwards.
More details from Webb:
If anyone is wondering about specifics, I will describe how I recently created a "crosswalk" table that correlates census tracts in 1980 with census tracts in 2000 in the Portland region (well, Washington, Multnomah, and Clackamas counties), so that we could see poverty trends over the last 25 years.
I used PostGIS, Census naming conventions ("FIPS codes"), and lots of outer joins. So if you like that sort of thing, I would love to hear your comments tomorrow!