search

codeforkansascity / address-api

A address database accessible through an API that will return attributes about the address, neighborhood, council district, zoning...
http://address-api.codeforkc.org
MIT License
5 stars 9 forks source link

Try Foreign data wrappers to bring in GEOjSON #54

Closed zmon closed 8 years ago

zmon commented 8 years ago

One problem is dependencies on the fdw.

name/url type install OS Postgres PostGIS Other
json_fdw2 native make Ubuntu 12.10+ 9.4 only
PostgreSQL OGR native make ? 9.3+ GDAL library gdal-config (OS dependent) and PostgreSQL development packages pg_config)

Installing GDAL

zmon commented 8 years ago

Install Ubuntu 14.04 from https://vagrantcloud.com/wk8/boxes/ubuntu-14.04 using

vagrant init wk8/ubuntu-14.04; vagrant up --provider virtualbox

And then was able to install GDAL/OGR following http://www.sarasafavi.com/installing-gdalogr-on-ubuntu.html but had to do the following first.

apt-get install python-software-properties
zmon commented 8 years ago

On 12.04 was able to do the above

zmon commented 8 years ago

Vagrant install for this is in master 33f2dd7