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 pyspatialite

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

cd ..
cd pyod

hg clone pyod

# unsatisfied dependency!
sudo easy_install pyyaml


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.