Export to

• Google Calendar
• iCalendar file
• hCalendar markup
  <div class="vevent h-event"> <h1 class="summary p-name">PDXPUG - PostGIS and the Census Data</h1> <div class='date'><time class="dtstart dt-start" title="2009-07-16T19:00:00" datetime="2009-07-16T19:00:00">Thursday, July 16, 2009 from 7</time>–<time class="dtend dt-end" title="2009-07-16T20:00:00" datetime="2009-07-16T20:00:00">8pm</time></div> <div class="location vcard p-location h-card"> <a class="url" href='http://calagator.org/venues/202389965'><span class='fn org p-name'>Free Geek</span></a> <div class="adr p-adr h-adr"> <div class="street-address p-street-address">1731 SE 10th Avenue</div> <span class="locality p-locality">Portland</span> , <span class="region p-region">OR</span> <span class="postal-code p-postal-code">97214</span> <div class="country-name p-country-name">US</div> (<a href='https://maps.google.com/maps?q=1731%20SE%2010th%20Avenue,%20Portland%20OR%2097214%20US'>map</a>) </div> </div> <div class="description p-description"> <p>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).</p> <p>Looking forward to seeing everyone there....and of course, drinks at the Lucky Lab <a href="http://www.luckylab.com/">http://www.luckylab.com/</a> ) at 915 SE Hawthorne Blvd. afterwards.</p> <p>More details from Webb:</p> <p>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.</p> <p>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!</p> </div> <h3>Links</h3> <ul> <li><a class="url u-url" href="http://pugs.postgresql.org/node/554">Website</a></li> </ul> </div>