How to setup the data importing script

Preface

In this document we will cover the initial setup of a basic environment required to fix minor issues with the upstream data from act art

Prerequisites

• Internet connection
• Debian Wheezy (process can be ported by the the commands are based on Wheezy)
• Copy of the 1270.0.55.001 - Australian Statistical Geography Standard (ASGS): Volume 1 - Main Structure and Greater Capital City Statistical Areas, July 2011 -- Needs to be the "Statistical Area Level 1 (SA1) ASGS Ed 2011 Digital Boundaries in ESRI Shapefile Format" file

Preparing the environment

1. Perform the following

apt-get install postgresql-9.1-postgis

su postgis

createdb "postgis_template"

cd /usr/share/postgresql/9.1/contrib/postgis-1.5

psql -d postgis_template -f postgis.sql

psql -d postgis_template -f spartial_ref_sys.sql

createdb -T postgis_template abs_sa1

2. nano /etc/postgresql/9.1/main/pg_hba.conf Locate line which has:

local all postgres user

And change it to

local all postgres trust

3. Setup additional dependancies (NB: These dependencies can be setup inside of a python virtual environment)

apt-get install postgresql-server-dev-9.1

pip install psycopg2

Populating the database

su postgres mkdir /abs_sa1 cd /abs_sa1 unzip ~/Downloads/1270055001_sa1_2011_aust_shape.zip shp2pgsql -s SRID /abs_sa1/SA1_2011_AUST.shp | psql -d abs_sa1 postgres