Using QGIS Cloud as a PostGIS database

This post will demonstrate how to deploy layers created in QGIS Desktop as PostGIS tables in QGIS Cloud. The GI Analyst can access spatial data on the cloud and download for use on desktop GIS.

An account in QGIS Cloud will be required to follow this demonstration.

Download a sample shapefile to practice along with:

https://www.dropbox.com/sh/ee0frh1swn7425e/AADINp5P80JbSwmX602Mrx46a?dl=0

 

1.  First, we load the shapefile comprising point features

m1

 

2. Click on the ‘Cloud Settings’ icon button to launch the QGIS Cloud Plugin

m2

 

3. Login into the QGIS Cloud using the plugin

m3

 

4. On the screenshot, the account is open. The QGIS Cloud account contains one

database – Jovizo_dwasov.

m4

 

5. Click on ‘Upload Data’ tab to open the Upload Data dialog window of the QGIS Cloud plugin.

m5

 

6. The vector layer in the Layers window is automatically converted to a Spatially indexed table

m6

 

7. Click on the ‘Upload data’ button( boxed in red)

m7

 

8. You will be prompted to save the project.

m8

 

Once this is done, the layer becomes stored as a spatially indexed table in QGIS Cloud database.

 

9. Let us retrieve the layer from the database as PostGIS layers and add to the map canvas on theQGIS Desktop. Click on the ‘Add PostGIS Layers’ icon button as shown on the screenshot below.

m9

 

10. Click ‘New’ in the dialog window to make a fresh connection  to the QGIS Cloud database

2

 

11. Fill in the parameters as it meets with the configuration in your QGIS Cloud account.

Parameters for Host is standard while SSL mode may be disabled not preferred.

1

 

12. Connect to the QGIS Cloud database connection you just created.

Note that the QGIS Cloud database is now working like a PostGIS connection.

m10

 

13. Select the Table we just uploaded. See it highlighted and red boxed in the screenshot below. Click Add.

m11

 

14. The Table is added as a vector layer on the QGIS map canvas.

m12

 

Thank you for following the blog.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s