TGIS 503 WebGIS Fall 2016

Homework Review

Installing GeoServer and poking around...


GeoServer +

another example


GeoServer plays well with others.

GeoServer is written in Java

It offers highly scalable and standard web-mapping engine implementation, with a nice user interface and web admin interface.

PostGIS Cookbook

Somethings possible with PostGIS
Moving data in and out of PostGIS
  • import data tabular data using PostGIS or GDAL
  • Import shapefiles with shp2pgsql
  • import and exporting data using ogr2ogr GDAL command
  • exporting data to a shp file using pgsql2shp PostGIS command
  • importing raster data with the raster2pgsql PostGIS command
  • importing and exporting multiple rasters at a time


"most popular and most capable of all the open source relational databases with spatial capabilities, and its features are constantly increasing...not an easy horse to ride." (GeoServer Beginner's Guide 2013 by Brian Youngblood and Stefano Iacovello page 110)

Getting Started with PostGIS

Let's create a database!

Follow directions found here using pgAdmin

Alternatively, you may use command line, but I will not be providing you support with at this time.

Helpful tool to find info required for formatting your data on GeoServer

Similar to adding a shapefile

This is what the GUI looks like when you have inserted the XML and clicked "preview legend"


  • If you change the color HEX and click preview legend, it might not appear, but it will change the color
  • to make sure - click submit then click style again and when you bring up that style, the next time you click preview legend, it should work! :)

Adding Style with XML

<?xml version="1.0" encoding="UTF-8"?>
<sld:StyledLayerDescriptor xmlns=""
                           xmlns:gml="" version="1.0.0">
      <sld:Title>County area classification</sld:Title>
            <sld:Title>Large counties</sld:Title>
             <sld:Title>Small counties</sld:Title>

OGC schemes if you have validation errors

designing maps and software, think carefully.

Copy of GeoServer Part 2

By Britta Ricker

Copy of GeoServer Part 2

  • 1,039