Posts Tagged ‘postgis’

Slides from my 2012 PGCon presentation Making your Own Maps are now available

The presentation covered

  • Common reasons people render their own maps
  • Where to get OpenStreetMap data and how to load it into your PostGIS database
  • How to use Tilemill to design your own map style
  • How to render map tiles, both statically and dynamically
  • How to use OpenLayers to display your map

The presentation was recorded. I will update this post when the recording comes online.

I’ve been a regular attendee of PGCON since the first year it was held in Ottawa. Like past years I enjoyed the conference and I would like to thank Dan Langille for putting together another first-rate conference. My favourite part of PostgreSQL conferences is meeting and reconnecting with users people in the community.

Updated: The video is available here

My talk on PostGIS replication at FOSS4G 2011 went well. It looked like there were about 150 people in the room. Most of them had not yet deployed a PostGIS replication solution.

My talk covered Slony and streaming replication. It gave an overview of different replication patterns that can crop on in the GIS space. I then gave an overview of the key features and limitation of Slony and streaming replication.

A video of the talk is available at FOSSLC

My slides are available here

This past week I attended FOSS4G in Denver, a conference run by the open-source geospatial foundation (OSGEO) that also happened to be the largest PostgreSQL conference in North America.

FOSS4G is a big tent conference that attracted about 900 attendees from all over the world with over 400 of them from the United States, over 50 from Canada.
A big tent conference is a conference is similar to a big-tent political party. The idea is appeal to a broad base of people by catering to as many groups as possible while keeping true to some key common themes. Out of the 900 people at the conference I’d say 75% raised their hands when asked if it was their first FOSS4G. Last years FOSS4G was held in Europe and also had over 800 attendees.

Tonight, I gave a short talk at OpenData, Waterloo Region on ‘Consuming & Presenting OSM Data‘. A discussion on how to use OSM data followed. The audience had a range of OSM experience. Some people had heard of OSM but never used it, a few people had used the data in applications or while traveling and some experienced mappers were also in attendance. The talk was geared to give an introduction to drive an informal discussion/Q&A versus as a ‘how to’ tutorial.

The meetup was held at ‘Mitsy Mountain Coffee‘. Mitsy Mountain is a spacious coffee shop that has room at the back with a meeting table and large screen that can be used by groups such as ours for meetings. Mitsy wasn’t around when I moved out of Waterloo, but seems like a nice place and is worth visiting again the next time I’m in KW.

My slides from the talk are available here

Recently I wanted to make a custom printed map of Peninsula Lake in Ontario Canada. The Canadian hydrographic service has been kind enough to give me some of the lake depth data that they had collected for the recent G8 summit. I wanted to take the OpenStreetMap data of the lake and surronding area and combine it with the depth data to produce a map of the lake.