Differences

This shows you the differences between two versions of the page.

--- general:gis [2014/12/01 15:06] – [Links] rfile
+++ general:gis [2014/12/01 15:07] (current) – removed rfile
@@ Line 1: / Line 1: @@
-====== GIS notes ======
-dragon is postgresql 8.4.11  postgis 1.5.1
-flatboy is postgresql 9.3.5    postgis 2.1.2
-using public schema in db not necessarily a good thing:
-http://gis.stackexchange.com/questions/43187/are-there-any-tricks-to-using-a-schema-other-than-public-in-postgis
-http://gis.stackexchange.com/questions/2182/moving-a-postgis-installation/2323#2323
-http://blog.cleverelephant.ca/2010/09/postgis-back-up-restore.html
-http://traviscline.com/blog/2010/04/28/moving-postgis-databases-between-machines/
-look for the script above on gihub
-[[https://gist.github.com/tmc/380278#file-pgsql_schema_diff-py|Tcline Postgres Link]]
-===== Install 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:
-CREATE EXTENSION postgis;
-<box 95% orange>
-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.
-</box>
-==== Postgis Qgis Notes ====
-http://planet.qgis.org/planet/user/2/tag/postgres%20%26%20postgis/
-youtube vid about using QGIS to update
-https://www.youtube.com/watch?v=oOhbbEkl4Kg
-===== Links =====
-  * http://qgis.org/en/docs/index.html
-  *
-  * http://www.spatialanalysisonline.com/
-  *
-  *
-  * http://blog.geomusings.com/2013/12/11/building-a-simple-geodata-service-with-node-and-amazon-rds/
-  *
-  * http://docs.aws.amazon.com/elasticbeanstalk/latest/dg/create_deploy_PHP.rds.html
-  *
-  * http://plugins.qgis.org/plugins/postgisQueryBuilder/
-  *
-  *   http://workshops.boundlessgeo.com/postgis-intro/
-  *
-  * http://technobytz.com/automatic-sql-database-backup-postgres.html
-  * https://geogear.wordpress.com/  - qgis plugins
-  * http://spatialgalaxy.com/2014/10/09/a-quick-guide-to-getting-started-with-pyqgis-on-windows/#python-packages
-  *
-  * review of plugins   http://planet.qgis.org/planet/tag/pyqgis/
-  * http://gis.stackexchange.com/questions/43866/merging-multipolygon-data-into-a-polygon
-  *