Skip to content

Releases: hackoregon/postgis-geocoder-test

v2.0.0 - 2018 season

21 Jan 07:05
Compare
Choose a tag to compare

This is the first release for the 2018 season. This year, we're doing everything with Docker, so the relevant directory is https://github.com/hackoregon/postgis-geocoder-test/blob/master/Docker/README.md

Updated Docker build

11 Apr 00:54
Compare
Choose a tag to compare
  1. The geocoder database was updated, forcing a rebuild.
  2. The old copies of upstream README and Dockerfile for the base image were deleted.
  3. A README was added.

Only the Docker version has changed.

EC2 code done

10 Apr 23:19
Compare
Choose a tag to compare

Directory ec2-deploy has the scripts to build an Oregon geocoder. At this point it's easiest just to fire up an empty Ubuntu 16.04.2 LTS 64-bit box with 1 GB of RAM, 15 GB of disk, git, and sudo, clone the repo and run the root-install-postgis.bash script. If we run out of more pressing tasks before Demo Day I'll look at an automated deploy.

Release files:

  • geocoder.html: A database schema of the geocoder database made by PostgreSQL Autodoc
  • shapefiles.zip: a ZIP archive of the input shapefiles from the Census Bureau. You'll only need this if you hit their site too hard and get blacklisted. Note that I have been unable to find documentation on the blacklisting other than
    • I'm not the only one who's experienced it, and
    • The only use case that triggers it is the PostGIS scripts that populate a TIGER/Line geocoder.
  • geocoder.pgdump: restore this to a PostgreSQL 9.6 / PostGIS 2.3 system as the postgres database superuser with pg_restore and you've got an Oregon geocoder!

Initial release

16 Feb 04:58
Compare
Choose a tag to compare

This is the initial release of the Hack Oregon Portland PostGIS Geocoder. As the name implies, it's designed for the City of Portland, although it includes all of Washington, Multnomah and Clackamas counties. There are two versions:

  1. A set of instructions for installing the geocoder on a Linux workstation that has the EnterpriseDB PostgreSQL 9.6 and PostGIS 2.3 packages installed.
  2. A docker-compose compatible directory for building the geocoder as a Docker image.

At this point in the project life cycle, I don't know how much geocoding we'll be doing, so I haven't put a great deal of effort into deployment issues. I have some specific tasks for it with the Transportation data that I'll be tackling next, but those may be one-offs for data entry rather than something that will be in the final app.

Note that if you want your own local copy, you should be able to get it by:

  1. Installing PostgreSQL 9.6 and PostGIS 2.3. _Earlier versions will not work!_ You do not need pgrouting or other address standardizers.
  2. Restoring the attached file geocoder.pgdump using pg_restore.

Hosting the geocoder.pgdump data file

16 Feb 03:47
Compare
Choose a tag to compare
Pre-release

This isn't a real release. It exists only to host the binary file "geocoder.pgdump" used for creating the Docker image!