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.

CivicIdeas for greater portland meetup May 27th, 6-8pm

From: http://civicapps.org/news/important-upcoming-events-civicapps

CivicApps Ideas scheduled for Thursday, May 27th, at the Portland Building Auditorium is a two-hour discussion of ideas and datasets between data providers and citizens. As a precursor to the CiviCode Day Event, scheduled one week later at Open Source Bridge, this meeting is your chance to initiate the discussion surrounding your project ideas and data needs with others.

Join us -> http://civicideas.eventbrite.com/