<?xml version="1.0" encoding="utf-8"?>
<feed xml:lang="en-us" xmlns="http://www.w3.org/2005/Atom"><title>Simon Willison's Weblog: postgis</title><link href="http://simonwillison.net/" rel="alternate"/><link href="http://simonwillison.net/tags/postgis.atom" rel="self"/><id>http://simonwillison.net/</id><updated>2010-07-11T12:15:00+00:00</updated><author><name>Simon Willison</name></author><entry><title>MapOSMatic</title><link href="https://simonwillison.net/2010/Jul/11/maposmatic/#atom-tag" rel="alternate"/><published>2010-07-11T12:15:00+00:00</published><updated>2010-07-11T12:15:00+00:00</updated><id>https://simonwillison.net/2010/Jul/11/maposmatic/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://www.maposmatic.org/"&gt;MapOSMatic&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
Clever service built on top of OpenStreetMap, which renders double sided city maps with a map and grid on one size and an A-Z street name index on the other. Runs on top of Mapnik, PostGIS and Cairo, with a few thousand additional lines of Python and Django.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/cairo"&gt;cairo&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/django"&gt;django&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/mapping"&gt;mapping&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/openstreetmap"&gt;openstreetmap&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgresql"&gt;postgresql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/python"&gt;python&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/recovered"&gt;recovered&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/maposmatic"&gt;maposmatic&lt;/a&gt;&lt;/p&gt;



</summary><category term="cairo"/><category term="django"/><category term="mapping"/><category term="openstreetmap"/><category term="postgis"/><category term="postgresql"/><category term="python"/><category term="recovered"/><category term="maposmatic"/></entry><entry><title>Doing things with Ordnance Survey OpenData</title><link href="https://simonwillison.net/2010/May/20/os/#atom-tag" rel="alternate"/><published>2010-05-20T15:22:00+00:00</published><updated>2010-05-20T15:22:00+00:00</updated><id>https://simonwillison.net/2010/May/20/os/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://frot.org/t/talks/techmeetup.html"&gt;Doing things with Ordnance Survey OpenData&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
Jo Walsh’s guide to processing Ordnance Survey OpenData using PostgreSQL and PostGIS.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/mapping"&gt;mapping&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/open-data"&gt;open-data&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/ordnancesurvey"&gt;ordnancesurvey&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgresql"&gt;postgresql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/recovered"&gt;recovered&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/jo-walsh"&gt;jo-walsh&lt;/a&gt;&lt;/p&gt;



</summary><category term="mapping"/><category term="open-data"/><category term="ordnancesurvey"/><category term="postgis"/><category term="postgresql"/><category term="recovered"/><category term="jo-walsh"/></entry><entry><title>Installing GeoDjango Dependencies with Homebrew</title><link href="https://simonwillison.net/2010/May/7/homebrew/#atom-tag" rel="alternate"/><published>2010-05-07T14:40:00+00:00</published><updated>2010-05-07T14:40:00+00:00</updated><id>https://simonwillison.net/2010/May/7/homebrew/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://lincolnloop.com/blog/2010/apr/30/installing-geodjango-dependencies-homebrew/"&gt;Installing GeoDjango Dependencies with Homebrew&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
brew update &amp;amp;&amp;amp; brew install postgis &amp;amp;&amp;amp; brew install gdal


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/django"&gt;django&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/geodjango"&gt;geodjango&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/homebrew"&gt;homebrew&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/macos"&gt;macos&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgresql"&gt;postgresql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/recovered"&gt;recovered&lt;/a&gt;&lt;/p&gt;



</summary><category term="django"/><category term="geodjango"/><category term="homebrew"/><category term="macos"/><category term="postgis"/><category term="postgresql"/><category term="recovered"/></entry><entry><title>Install Django, GeoDjango, PostgreSQL and PostGIS on OSX Leopard</title><link href="https://simonwillison.net/2009/Jul/24/geodjango/#atom-tag" rel="alternate"/><published>2009-07-24T11:47:49+00:00</published><updated>2009-07-24T11:47:49+00:00</updated><id>https://simonwillison.net/2009/Jul/24/geodjango/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://www.tokumine.com/2009/06/01/install-django-geodjango-postgresql-postgis-on-osx-leopard/"&gt;Install Django, GeoDjango, PostgreSQL and PostGIS on OSX Leopard&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
This tutorial worked perfectly for me.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/django"&gt;django&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/geodjango"&gt;geodjango&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/macos"&gt;macos&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgresql"&gt;postgresql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/python"&gt;python&lt;/a&gt;&lt;/p&gt;



</summary><category term="django"/><category term="geodjango"/><category term="macos"/><category term="postgis"/><category term="postgresql"/><category term="python"/></entry><entry><title>Google Maps Data API</title><link href="https://simonwillison.net/2009/May/20/mapdata/#atom-tag" rel="alternate"/><published>2009-05-20T21:07:10+00:00</published><updated>2009-05-20T21:07:10+00:00</updated><id>https://simonwillison.net/2009/May/20/mapdata/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://code.google.com/apis/maps/documentation/mapsdata/"&gt;Google Maps Data API&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
I’m disappointed by this one—it’s really just a CRUD store for the KML files used in Google MyMaps. It would be a lot more useful if it let you perform geospatial calculations against your stored map data using some kind of query API—a cloud service alternative to tools like PostGIS.

    &lt;p&gt;&lt;small&gt;&lt;/small&gt;Via &lt;a href="http://googlegeodevelopers.blogspot.com/2009/05/introducing-google-maps-data-api-in.html"&gt;Google Geo Developers Blog&lt;/a&gt;&lt;/small&gt;&lt;/p&gt;


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/apis"&gt;apis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/gdata"&gt;gdata&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/geospatial"&gt;geospatial&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/google-maps"&gt;google-maps&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/google-maps-api"&gt;google-maps-api&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/googlemapsdataapi"&gt;googlemapsdataapi&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/kml"&gt;kml&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;&lt;/p&gt;



</summary><category term="apis"/><category term="gdata"/><category term="geospatial"/><category term="google-maps"/><category term="google-maps-api"/><category term="googlemapsdataapi"/><category term="kml"/><category term="postgis"/></entry><entry><title>Represent</title><link href="https://simonwillison.net/2008/Dec/29/represent/#atom-tag" rel="alternate"/><published>2008-12-29T22:10:26+00:00</published><updated>2008-12-29T22:10:26+00:00</updated><id>https://simonwillison.net/2008/Dec/29/represent/#atom-tag</id><summary type="html">
    
&lt;p&gt;&lt;strong&gt;&lt;a href="http://open.blogs.nytimes.com/2008/12/22/represent/"&gt;Represent&lt;/a&gt;&lt;/strong&gt;&lt;/p&gt;
Andrei Scheinkman and Derek Willis describe how they built the NYTimes Represent feature using GeoDjango and PostGIS.


    &lt;p&gt;Tags: &lt;a href="https://simonwillison.net/tags/andrei-scheinkman"&gt;andrei-scheinkman&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/derek-willis"&gt;derek-willis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/django"&gt;django&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/geodjango"&gt;geodjango&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/geospatial"&gt;geospatial&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/new-york-times"&gt;new-york-times&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgis"&gt;postgis&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/postgresql"&gt;postgresql&lt;/a&gt;, &lt;a href="https://simonwillison.net/tags/python"&gt;python&lt;/a&gt;&lt;/p&gt;



</summary><category term="andrei-scheinkman"/><category term="derek-willis"/><category term="django"/><category term="geodjango"/><category term="geospatial"/><category term="new-york-times"/><category term="postgis"/><category term="postgresql"/><category term="python"/></entry></feed>