twittering on 2010-06-04

Setting up a PDXAPI instance

Today I spent a little time setting up a PDXAPI instance of the CivicApps data. There are a few different tools out there for grabbing the data and loading it up, and so I’m documenting the basic steps here for setting up a spatial SQLite using @lokkju’s python projects.

hg clone https://pyspatialite.googlecode.com/hg/ pyspatialite

cd pyspatialite
mv setup.cfg.OSX setup.cfg
python setup.py build
sudo python setup.py install

cd ..
cd pyod

hg clone https://pyod.googlecode.com/hg/ pyod

# unsatisfied dependency!
sudo easy_install pyyaml

pypython fetcher.py

This creates a 1 GB sqlite database called ‘test.sqlite’.

Next, I’ll be testing out loading this into a CouchDB instance and maybe playing with Max Ogden’s initial PostGIS export.

twittering on 2010-06-03

  • Hello, rain! Heading to the PAM for day 2 of @osbridge. #
  • saw lots of great talks today. enjoyed @arielwaldman's space hacks, @geoloki and @schwern's talks #
  • i mean @geoloqi. now hearing more wisdom from Markus Robert's about pair emailing for personal growth. :) #osbridge #
  • listening to @fossygrl talk about non-profits and her experience with MusicBrainz #
  • Almost at saucebox #osbridge #
  • So did the testing bof just happen at saucebox? /cc @saucelabs #

twittering on 2010-06-03

  • Hello, rain! Heading to the PAM for day 2 of @osbridge. #
  • saw lots of great talks today. enjoyed @arielwaldman's space hacks, @geoloki and @schwern's talks #
  • i mean @geoloqi. now hearing more wisdom from Markus Robert's about pair emailing for personal growth. :) #osbridge #
  • listening to @fossygrl talk about non-profits and her experience with MusicBrainz #
  • Almost at saucebox #osbridge #
  • So did the testing bof just happen at saucebox? /cc @saucelabs #