building a connection in qgis with postgres sql
DESCRIPTION
This was a my assignment of MS Remote Sensing ans GIS.TRANSCRIPT
WHAT IS QGIS?
Quantum GIS (often abbreviated to QGIS) is a free
software desktop Geographic Information Systems (GIS) application that
provides data viewing, editing, and analysis capabilities.
Gary Sherman began development of Quantum GIS in early 2002, and
it became an incubator project of the Open Source Geospatial
Foundation in 2004. Version 1.0 was released in January 2009.
Quantum GIS is written in C++, and its GUI uses the Qt library.
Quantum GIS allows integration of plug-in developed using either C++
or Python.
WHAT IS QGIS?
Quantum GIS is a multi-platform application and runs on
different operating systems including Mac OS
X, Linux, UNIX, and Microsoft Windows.
Quantum GIS has a small file size compared to
commercial GIS's and requires lessRAM and processing
power; hence it can be used on older hardware or running
simultaneously with other applications where CPU power
may be limited.
WHAT IS QGIS?
Quantum GIS is continually maintained by an active group
of volunteer developers who regularly release updates and
bug fixes. Currently, developers have converted Quantum
GIS into 31 languages and the application is used
internationally in academic and professional environments.
HOW IT WORK WITH POSTGRESQL
AFTER THE INSTALLATION OF BOTH POSTGRESQL
AND QGIS SOFTWARE, WE NEED I=ONE MORE THING
THAT IS POSTGIS FOR POSTGRESQL SPECIFIED
VERSION.
POSTGIS ACTUALLY A PLUG-IN OR WE CAN SAY IT AN
EXTENSION FOR POSTGRE THAT MAKE IT A “SPATIAL
DATABASE”.
HOW IT WORK WITH POSTGRESQL
FOR USING QGIS WITH POSTGRES WE MUST NEED
INSTALLATION OF POSTGIS.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGIS
We Simply
Open Our Qgis
Software.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGIS
FOR BUILDING A DATA
BASE CONNECTION OR
TO CONNECT WITH
POSTGRESQL/POSTGIS,
WE HAVE TO CLICK “ADD
POSTGIS LAYER” BUTTON
FROM MANAGE LAYER
BUTTON.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGISAfter This “Add Postgis
Table” A Dialouge Box Will
Prompt.
We Can Connect To Our
Database By Making a New
Connection, If We Already
Have a Connection Then We
Can Edit or Delete as Well.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGIS
For Creating A New
Connection, We Have
To Fill All The Mention
Parameters.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGIS
We fill all the
requirement as
shown in the
image.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGISAfter making a successful
connection when we connect
or database, we will able to
see our data, if we have
added to that specified
database.
BUILDING A DATA BASE CONNECTION WITH POSTGRE/POSTGIS
Data
Displayed In
Qgis Interface.
This is all for the data retrieval from data base if we have already added some data.
ADDING DATA TO DATABASE
FOR ADDING DATA WE
WILL USE “IMPORT
SHAPEFILES TO
POSTGRESQL” SPIT TOOL
IN PLUGN-IN TOOL BAR.
ADDING DATA TO DATABASE
YOU CAN SIMPLY ADD
THIS TOOL TO PLUGN –N
TOOL BAR BY FOLLOWING
THESE STEPS.
ADDING DATA TO DATABASE
Here We Define Our
Data Cnnection To
Data First, After
Cionnecting To
Database We Simply
Add Our Data From
Our Local Drive, And
Then Press Ok.
THANKS