Publishing a PostGIS table¶
This tutorial walks through the steps of publishing a PostGIS table with GeoServer.
This tutorial assumes that PostgreSQL/PostGIS has been previously installed on the system and responding on
localhost on port
5432, and also that GeoServer is running at
First let’s gather that the data that we’ll be publishing.
Download the file
nyc_buildings.zip. It contains a PostGIS dump of a dataset of buildings from New York City.
Create a PostGIS database called
nyc. This can be done with the following commands:
createdb nyc psql -d nyc -c 'CREATE EXTENSION postgis'
You may need to supply a user name and password with these commands.
psql -f nyc_buildings.sql nyc
Creating a new workspace¶
The next step is to create a workspace for the data. A workspace is a container used to group similar layers together.
This step is optional if you’d like to use an existing workspace. Usually, a workspace is created for each project, which can include stores and layers that are related to each other.
In a web browser, navigate to
Log into GeoServer as described in the Logging In section.
Click the Add new workspace button.
You will be prompted to enter a workspace Name and Namespace URI.
Enter the Name as
nycand the Namespace URI as
A workspace name is a identifier describing your project. It must not exceed ten characters or contain spaces. A Namespace URI (Uniform Resource Identifier) can usually be a URL associated with your project with an added trailing identifier indicating the workspace. The Namespace URI filed does not need to resolve to an actual valid web address.
Click the Submit button. The
nycworkspace will be added to the Workspaces list.
Creating a store¶
Once the workspace is created, we are ready to add a new store. The store tells GeoServer how to connect to the shapefile.
You should see a list of stores, including the type of store and the workspace that the store belongs to.
Create a new store by clicking the
Enter the Basic Store Info:
- Select the
- Enter the Data Source Name as
- Add a brief Description
- Select the
Specify the PostGIS database Connection Parameters:
Option Value dbtype
passwd (Password for the
validate connections (Checked)
Leave all other fields at their default values.
Creating a layer¶
Now that the store is loaded, we can publish the layer.
Click Add a new resource.
From the New Layer chooser menu, select
On the resulting layer row, select the layer name
The Edit Layer page defines the data and publishing parameters for a layer. Enter a short Title and an Abstract for the
Generate the layer’s bounding boxes by clicking the Compute from data and then Compute from native bounds links.
Click the Publishing tab at the top of the page.
We can set the layer’s style here. Under WMS Settings, ensure that the Default Style is set to polygon.
Finalize the layer configuration by scrolling to the bottom of the page and clicking Save.
Previewing the layer¶
In order to verify that the
nyc_buildings layer is published correctly, we can preview the layer.
Navigate to the Layer Preview screen and find the
Click the OpenLayers link in the Common Formats column.
An OpenLayers map will load in a new tab and display the shapefile data with the default line style. You can use this preview map to zoom and pan around the dataset, as well as display the attributes of features.