3. Working with Vector Data in Spatial Databases | Mastering Geoserver

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents
Feedback & Rating

Mastering Geoserver

By : Henderson

4.6 (7)

Mastering Geoserver

4.6 (7)

By: Henderson

Overview of this book

If you are a GIS professional who intends to explore advanced techniques and get more out of GeoServer deployment rather than simply delivering good looking maps, then this book is for you.

Preface

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Installing GeoServer for Production

1. 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

2. 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

3. 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

4. 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

5. 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

6. 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

7. 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

8. 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

9. 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

10. 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

11. 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

12. Optimizing GeoServer for Production

Deploying GeoServer in a cluster

Optimizing GeoServer

Automatic recovery from service failures

Summary

Index

Index

Customer Reviews

4.6 (7)

5 star

57.1%

4 star

42.9%

3 star

0%

2 star

0%

1 star

0%

General database connection parameters

Irrespective of the database platform you use to serve your vector data, there is a set of parameters that is common to all. In this section, we will take a look at:

How primary keys can be managed
Database startup session scripts
Database shutdown session scripts

The primary key metadata table

While not necessary, it is usually best practice to have your database tables configured with a primary key. A primary key should be a unique value for each record in the table, and most often, it's not a simple integer incremented by some value, often 1, for each newly inserted record. GeoServer usually derives its feature ID values from the table's primary key column, and it will make assumptions about how to generate new IDs when inserting features, for example, as a result of a WFS-Transaction (WFS-T) insert transaction. These will usually be based on common conventions for a database platform, for example, looking for an auto-incrementing column in PostGIS. If...

Visually different images

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Mastering Geoserver

Search

Your notes and bookmarks