We have discussed how to start with Postgresql / Postgis. Once you have
your database, the next most common need is to upload online the data.
Of course, there are many technical possibilities to do this. To keep
within the most standard, the WFS and WMS streams setting from Postgresql /
Postgis data is one of the most robust ways.
Therefore, we will now see how to start with Geoserver.
NOTE: The original article was written for
Geoserver version 2.8. I updated it on 9/9/2016 to take into account the installation
changes for version 2.9.1.
GeoServer is an open source computer server written in Java that allows
users to share and modify geographic data. Designed for interoperability, it
publishes data from all major sources of spatial data using open standards:
PostGIS, Oracle Spatial, ArcSDE, DB2, MySQL, Shapefiles, GeoTIFF, GTOPO30, ECW,
MrSID, JPEG 2000.
Using standard protocols, it provides KML, GML, Shapefile, GeoRSS, PDF,
GeoJSON, JPEG, GIF, SVG, PNG files and more. GeoServer OpenLayers includes an
integrated client for the preview of data layers.
Downloading Geoserver
You can download the latest Geoserver stable version of at http://geoserver.org/release/stable/
Installing Geoserver 2.9.1
The installation itself is very simple. On the other hand, a
prerequisite for Geoserver is the installation of the Java Runtime Environment
(JRE).
A further complication is that Geoserver does not work with the latest
version (JRE9). It needs Jre8.
It is not a problem in itself, each Jre version is installed in a
separate directory and several versions can coexist in the same place.
To download the Jre version that corresponds to your computer (32 or 64 bits)
Install Jre 8 and mark the directory in which you perform this
installation (usually Program Files / Java / jre1.8.0_65), you will need to
fill it during the Geoserver installation.
Launch the Geoserver installing programme. The following slideshow
guides you through the answers of the different windows. Note: if you place the mouse pointer over the
image, automatic scrolling stops
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
If you have a 64-bit jre installation, the first
option is mandatory
The only fundamental point is one before last
window:
If you have installed a Jre 8 64-bit version, you must check the
first option.
If not, you have the choice.
The second option is clear. Geoserver launches itself as a Windows
service, at the start of your post. You do not have to worry about it.
If you check the first option, you will have to manually start and stop
Geoserver. In the Windows program bar, under Geoserver, you have two programs:
Start Geoserver and Stop Geoserver.
The first opens a command window that you can minimize (not close!). The
second stops the server and permanently closes the command window.
Tip: Always close Geoserver strictly using the Stop
Geoserver program.
Once the installation is completed, either Geoserver is running (Service
option) or you can launch it with the Start Geoserver program.
Interface administration
Geoserver is managed from a web interface. To
access it, type the following address in your browser: http: //
localhost: 8080 / geoserver.
Enter
your username and password to login.
For a “quickstart” visit http://docs.geoserver.org/stable/en/user/gettingstarted/web-admin-quickstart/index.html
Uploading the Postgis table created in the
Postgresql / Postgis tutorial.
We’ll refer to the basics, to upload a WFS / WMS feed from the Postgis
table created in the previous tutorial.
We will use two Geoserver concepts: the Data Store and the Layer.
If we want to upload a shapefile, we’ll have to use two concepts: Data
Directory and Workspace.
The Data Directory has been defined during the installation. By
default it is geoserver / data_dir / data.
If you want to upload a shapefile, you have to create a subdirectory in
the Data Directory, and copy it into this subdirectory.
Physically, the data is correctly place in Geoserver. But it must also
be logically placed. We must, therefore, define this subdirectory as Workspace
in the administration interface-> Workspace> Add workspace.
Then, you will allocate a name that may be the same or not.
In the case of a Postgis database, it cannot be in the Data Directory. These
two notions are then omitted, the Postgis database being in itself a workspace
for Geoserver.
Here are some examples of data warehouses in a Geoserver installation:
Adding a Data Store – Data Warehouse – Postgis
In the left menu bar, click Warehouses
Click
Add New Datastore. The following window opens
Click
Postgis, the configuration window opens:
Leave the workspace by default (quote)
Give a name to the data source (name that will appear in the admin
interface and not necessarily the same as the layer name)
Give the database connection information: host (localhost), port (5432),
database (postgis_22_sample), schema (public), user (postgres), passwd (the
postgres password for your database).
Click the Save button at the very bottom of the page.
Adding a layer
Click on the Layers option in the left menu. The
available layers page opens
Click
Add New Resource
You will see the Data Store you just created (quote: your name).
Select it.
In the line corresponding to the layer you want
to upload, click Publish.
The
configuration page fort the uploading of your layer opens:
Enter a title and a summary.
Leave the rest by default, except the
rights-of-way. Click on ” Data based »And« Calculated
on native rights of way To fill the control values .
Fill
in the definition of the coordinate system for the layer.
To do this, click on the Search button and look for the
coordinate system of your layer. In this case it’s Lambert 93. The Native
SRC is not defined. (When loading the layer into the Postgis database
it was set to zero = no system).
In CRS Management select Force the variable
definition.
You can now save the layer.
To see the result, on the left menu bar, click
Layer Preview, and then in the corresponding line for the layer you just
created, click OpenLayers.
A
page with the result of the layer is displayed:
Note that the address of the page, in the browser address bar “C” is the
address that you will be using if you want to connect with the WMS stream with
QGis (http: // localhost: 8080 / geoserver / cite / wms?) or to the WFS feed (http:
// localhost: 8080 / geoserver / quote / wfs?)
