Zen

Source string Source string

194/10000 · 194

The string is read only.

English Actions
Mapping
To produce a map from PostGIS data, you need a client that can get at the data. Most of the open source desktop GIS programs can do this - QGIS, gvSIG, uDig for example. Now we'll show you how to make a map from QGIS.
Start QGIS from the Desktop GIS menu and choose ``Add PostGIS layers`` from the layer menu. The parameters for connecting to the Natural Earth data in PostGIS are already defined in the Connections drop-down menu. You can define new server connections here, and store the settings for easy recall. Click on Connections drop down menu and choose Natural Earth. Hit ``Edit`` if you want to see what those parameters are for Natural Earth, or just hit ``Connect`` to continue:
Connect to Natural Earth
You will now get a list of the spatial tables in the database:
Natural Earth Layers
Choose the ne_10m_lakes table and hit ``Add`` at the bottom (not ``Load`` at the top - that loads database connection parameters), and it should be loaded into QGIS:
My First PostGIS layer
You should now see a map of the lakes. QGIS doesn't know they are lakes, so might not colour them blue for you - use the QGIS documentation to work out how to change this. Zoom in to a famous group of lakes in Canada.
Importing spatial data into the database
Most of the OSGeo desktop tools have functions for importing spatial data from other formats (f.e. ESRI Shape) into the database. Again we'll use QGIS to show this.
Importing shapefiles to QGIS can be done via the handy QGIS Database Manager. You find the manager in the menu. Go to ``Database -> DB Manager``.
Deploys the Postgis item, then the NaturalEarth item. It will then connect to the Natural Earth database. Leave the password blank if it asks. In the public item, there is the list of the layers provided by the database. You'll see the main manager window. On the left you can select tables from the database and use the tabs on the right find out about them. The Preview tab will show you a little map.
QGIS Manager Preview
We will now use the DB Manager to import a shapefile into the database. We'll use the North Carolina sudden infant death syndrome (SIDS) data that is included with one of the R statistics package add-ons.
From the ``Table`` menu choose the ``Import layer/file`` option. Hit the ``...`` button and browse to the ``sids.shp`` shapefile in the R directory. (located in /home/user/data/vector/R/shapes):
Find the shapefile
Leave everything else as it is and hit ``Load``
Import a shapefile
Let the Coordinate Reference System Selector default to (WGS 84 EPSG:4326) and hit ``OK``. The shapefile should be imported into PostGIS with no errors. Close the DB Manager and get back to the main QGIS window.
Now load the SIDS data into the map using the 'Add PostGIS Layer' option. With a bit of rearranging of the layers and some colouring, you should be able to produce a choropleth map of the sudden infant death syndrome counts (sid74 or sid79 fields) in North Carolina:
SIDS data mapped
Depending on the version of OSGeoLive you are using (ISO or VMDK), you will not find the same clients available. ``pgAdmin`` is the official client for PostgreSQL, however, for technical reasons, it can't do in the ISO, so it is only available in the VMDK version. The ISO version has the ``phpPgAdmin`` client which offers the same core functionality.
Get to know phpPgAdmin (ISO & VMDK)
In both versions, you can use the graphical database client phpPgAdmin.
phpPgAdmin lets you use SQL to manipulate your data tables. You can find and launch phpPgAdmin from the Databases folder, existing on the OSGeoLive Desktop.
phpPgAdmin main
Here, you have the option of creating a new connection to a PostgreSQL server, or connecting to an existing server. The red "X" on the ``PostgreSQL`` server denotes that you haven't been yet connected. Click on it then enter the user name ``user`` and the master password ``user``.
After connection established, you can see the list of the databases already existing in the system.
phpPgAdmin
At this point you are able only to see the existing databases on the system. You can connect, by clicking, on plus sign at the left of the name of a database. Do it for the ``natural_earth2`` database.

Loading…

User avatar None

String updated in the repository

  1. OSGeoLive
  2. postgis_quickstart
  3. English
From the ``Table`` menu choose the ``Import layer/file`` option. Hit the ``...`` button and browse to the ``sids.shp`` shapefile in the R directory. (located in /home/user/data/vector/R/shapes):
From the ``Table`` menu choose the ``Import layer/file`` option. Hit the ``...`` button and browse to the ``sids.shp`` shapefile in the R directory. (located in /home/user/data/vector/R/shapes):
a year ago
Browse all string changes

Things to check

Ellipsis

The string uses three dots (...) instead of an ellipsis character (…)

Reset

Glossary

English English
No related strings found in the glossary.

String information

Flags
read-only
Source string location
../../build/doc/quickstart/postgis_quickstart.rst:434
String age
a year ago
Last updated
a year ago
Source string age
a year ago
Translation file
locale/pot/quickstart/postgis_quickstart.pot, string 75