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.<\/p>\n
\r\nhg clone https:\/\/pyspatialite.googlecode.com\/hg\/ pyspatialite\r\n\r\ncd pyspatialite\r\nmv setup.cfg.OSX setup.cfg\r\npython setup.py build\r\nsudo python setup.py install\r\n\r\ncd ..\r\ncd pyod\r\n\r\nhg clone https:\/\/pyod.googlecode.com\/hg\/ pyod\r\n\r\n# unsatisfied dependency!\r\nsudo easy_install pyyaml\r\n\r\npypython fetcher.py\r\n<\/pre>\nThis creates a 1 GB sqlite database called ‘test.sqlite’.<\/p>\n
Next, I’ll be testing out loading this into a CouchDB instance and maybe playing with Max Ogden’s initial PostGIS export.<\/p>\n","protected":false},"excerpt":{"rendered":"
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 … Continue reading →<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[194,20],"tags":[306,315,314],"class_list":["post-1738","post","type-post","status-publish","format-standard","hentry","category-osbridge","category-portland","tag-civicapps","tag-instructions","tag-pdxapi"],"_links":{"self":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1738","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/comments?post=1738"}],"version-history":[{"count":1,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1738\/revisions"}],"predecessor-version":[{"id":1739,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/posts\/1738\/revisions\/1739"}],"wp:attachment":[{"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/media?parent=1738"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/categories?post=1738"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.chesnok.com\/daily\/wp-json\/wp\/v2\/tags?post=1738"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}