Export or edit this event...

Portland Python User Group: Geohash, PostGIS, GeoDjango, etc

851 SW 6th Ave., Suite 1600
Portland, OR 97204, US (map)
Public WiFi

Access Notes

Enter the the Pacific First building (851 SW 6th Ave) from the 6th Ave side. Security will code you into the elevator. Once on the 16th floor follow the sign.



Our first meeting of 2010 is nearly upon us and it's going to be a big one! The theme for January is: Geographic Information. In addition to 3 (count 'em: 3!) great feature presentations, there will be a giveaway of GIS and Python books. And, after, we'll adjourn to the pub for beer. (Map to be provided.)

First up we'll have Michel's Module of the Month, a lightning talk on a randomly chosen stdlib module by an unprepared volunteer.

Then, Michel Pelletier will introduce Geohash, a clever text encoding of latitude and longitude information that is very useful for non-traditional databases, among other things. Geohashing was cooked up by Gustavo Niemeyer of Mocker and Dateutil fame.

Webb Sprague will talk about how to incorporate geographic data into relational databases using PostGIS and PostgreSQL. He will cover making a connection with psycopg2, modeling using geographic data types, and associating geographic data with non-geographic attributes.

Building on Webb's talk, Tim Welch will introduce the geographic capabilities of the Django Framework (aka GeoDjango) which utilizes PostGIS and psycopg2. He'll briefly cover geometric data types, spatial operators, the Django geographic admin and creating geo-enabled web services. In addition to examples, at least one application will also be demoed.