Database Reference
In-Depth Information
Adding PostGIS layers - QGIS
Inthisrecipe,wewillestablishaconnectiontoourPostGISdatabaseinordertoadd
atableasalayerin
QGIS
(formerlyknownas
Quantum GIS
).Viewingtablesaslay-
ersisgreatforcreatingmapsorsimplyworkingonacopyofthedatabaseoutsidethe
database.
Please navigate to the following site to install the latest version of QGIS (2.0 as of
writing this topic):
On this page, click on
Download Now
and you will be able to choose the suitable
operatingsystemandsettings.QGISisavailableforAndroid,Linux,MacOSX,and
Windows. You might also be inclined to click on
Discover QGIS
to get an overview
ofsomebasicinformationabouttheprogram,alongwithfeatures,screenshots,and
case studies.
Getting ready
To begin, let's download data from the following U.S. Census Bureau's FTP site:
The shapefile consists of roads, streams, and other line features found within
Cuyahoga County, Ohio.
Tip
Extract the ZIP file to your working directory and then load it into your database
using
shp2pgsql
.Besuretospecifythespatialreferencesystem,EPSG/SRID:
4269.Whenindoubtaboutusingprojections,usethewonderfulserviceprovided
by the folks at OpenGeo, located at the following website: