Book Image

Mastering Geoserver

By : Colin Henderson
Book Image

Mastering Geoserver

By: Colin Henderson

Overview of this book

Related Content you might be interested in

Current Title:

Small book image
Mastering Geoserver
Colin Henderson
Nov, 2014 | 420 pages
No titles found
Table of Contents (19 chapters)
Mastering GeoServer
Mastering GeoServer
Credits
Credits
About the Author
About the Author
About the Reviewers
About the Reviewers
www.PacktPub.com
www.PacktPub.com
Preface
Preface
Free Chapter
1
Installing GeoServer for Production
Installing GeoServer for Production
Java requirements
Installing Apache Tomcat
Deploying GeoServer to Apache Tomcat
Configuring GeoServer for maximum performance and availability
Configuring multiple GeoServer instances on a single server
Summary
2
Working with Raster Data
Working with Raster Data
Increasing the raster formats supported by GeoServer
How to optimize raster data for better performance
How to serve very large raster datasets
Summary
3
Working with Vector Data in Spatial Databases
Working with Vector Data in Spatial Databases
Database connection pooling
JNDI connection or JDBC
General database connection parameters
Serving data from PostGIS
Serving data from Oracle
Serving data from Microsoft SQL Server and SQL Azure
Creating SQL View layers
Summary
4
Using GeoServer to Serve Complex Features
Using GeoServer to Serve Complex Features
The difference between simple and complex features
Using GeoServer application schemas
Publishing data with an application schema
Summary
5
Using GeoServer as a Proxy
Using GeoServer as a Proxy
Defining cascaded services
Using cascaded services
Creating a cascaded WMS connection
Connecting to a cascaded WFS
Extending server capabilities
Summary
6
Controlling the Output of GeoServer
Controlling the Output of GeoServer
Styling data with Styled Layer Descriptor
Styling data using Cascaded Style Sheets
Per-request styling of map features
Per-request filtering of data
Using Freemarker templates to change WMS responses
Summary
7
Using GeoServer to Print Maps
Using GeoServer to Print Maps
The GeoServer print extension
Installing the print extension
Configuring the print extension
Defining print layouts
Making print requests
An example OpenLayers application
Summary
8
Integrating GeoServer in a Spatial Data Infrastructure
Integrating GeoServer in a Spatial Data Infrastructure
Definition of a spatial data infrastructure
User perspective – editing data through WFS-T
User perspective – consuming data
Summary
9
GeoServer as a Spatial Analysis Platform
GeoServer as a Spatial Analysis Platform
Understanding Web Processing Services
Installing the WPS extension
Using WPS to perform spatial analysis
Understanding GeoScript
Installing the GeoScript extension
Scripting GeoServer
Summary
10
Enterprise Security and GeoServer
Enterprise Security and GeoServer
Authentication and authorization
Using Active Directory for user authentication and authorization
Using Digest for user authentication
Using HTTP Header for user authentication
Summary
11
Monitoring the Performance and Health of GeoServer
Monitoring the Performance and Health of GeoServer
The importance of monitoring GeoServer
The GeoServer monitor extension
Stress testing GeoServer
Analyzing the results of the stress test
Summary
12
Optimizing GeoServer for Production
Optimizing GeoServer for Production
Deploying GeoServer in a cluster
Optimizing GeoServer
Automatic recovery from service failures
Summary
Index
Index

Serving data from Microsoft SQL Server and SQL Azure

GeoServer does not come with support for Microsoft SQL Server or SQL Azure out of the box. To enable support for Microsoft SQL Server databases as a source format, we need to install the GeoServer extension and supporting Microsoft JDBC drivers.

Installing the Microsoft SQL Server extension

To get support for Microsoft SQL Server as a data store, we need to install two components. First, we must install the GeoServer extension to enable the format, and then we need to install some supporting Microsoft files. Due to licensing restrictions, the GeoServer extension does not come with the necessary Microsoft JDBC driver files, and so, these will need to be installed separately.

We need to download the GeoServer extension for SQL Server, ensuring we choose the download matching the version of GeoServer that we installed. We have been using the current stable version (which at the time of writing is 2.5.2), so this is the version of the extension...

Previous Section
End of Section 7
Next Section