GIS notes

http://postgis.net/documentation/

http://postgis.refractions.net/

should probably use extensions to make apostgis database on the new server flatboy

http://postgis.net/docs/manual-2.1/postgis_installation.html#create_new_db_extensions

still need to figure out if sql statments have been run during postgis install on ubuntu

install3

http://technobytz.com/install-postgis-postgresql-9-3-ubuntu.html

Using the CREATE EXTENSION statement This is as simple as running a query in the data base where you want to enable PostGIS:

1 CREATE EXTENSION postgis;

http://postgis.net/docs/manual-2.1/postgis_installation.html#create_new_db_extensions

CREATE EXTENSION postgis; command.

psql -d [yourdatabase] -c “CREATE EXTENSION postgis;”

Topology is packaged as a separate extension and installable with command:

psql -d [yourdatabase] -c “CREATE EXTENSION postgis_topology;”

If you plan to restore an old backup from prior versions in this new db, run:

psql -d [yourdatabase] -f legacy.sql

You can later run uninstall_legacy.sql to get rid of the deprecated functions after you are done with restoring and cleanup.

Postgis Qgis Notes

AWS notes

Installed qgis server from qgis.org repository

deb http://qgis.org/debian trusty main

deb-source http://qgis.org/debian trusty main

Did this as root (sudo su)

gpg –export –armor D71472C4 | sudo apt-key add -
gpg –keyserver keyserver.ubuntu.com –recv D71472C4

Got the keys used above from a file:

http://qgis.org/debian/conf/distributions

Look for trusty and use the SignWith number