PostGIS is a powerful spatial database extension bundled with Postgres Plus Advanced Server. This tutorial shows how to install, setup, and begin using a spatially enabled database that can be applied to a variety of applications.
- If using Postgres Plus Standard Server, refer to PostGIS Tutorial for Postgres Plus Standard Server
This EnterpriseDB Quick Tutorial helps you get started with the Postgres Plus Advanced Server database in a Linux or Windows environment. It is assumed that you have already downloaded and installed Postgres Plus Advanced Server on your desktop or laptop computer.
This Quick Tutorial is designed to help you expedite your Technical Evaluation of Postgres Plus Advanced Server. For more informational assets on conducting your evaluation of Postgres Plus, visit the self-service web site, Postgres Plus Open Source Adoption.
In this Quick Tutorial you will learn how to do the following:
- Install and set up a PostGIS enabled environment
- Deploy a PostGIS database
- View PostGIS database objects in pgAdmin
- Create spatial tables and indexes
- Insert test data into your tables and view the data
- Apply spatial functions against your PostGIS data
Using a PostGIS database
A Geographic Information System (GIS) object is a defined unit of geographical data that represents a specific spatial object. GIS technology has many applications, including:
- Resource Management
- Emergency Planning
- Surveying and Cartography
- Infrastructure Planning and Maintenance
- GPS Applications
PostGIS is an extension to Postgres Plus Advanced Server that stores GIS objects. PostGIS supports storage of the following GIS object types:
In addition to adding GIS storage capabilities to Advanced Server, PostGIS also adds support for GiST-based R-tree spatial indexes; these indexes allow you to quickly find GIS data based on criteria specified in terms of spatial relationship. An example of such a query would be to SELECT all Chinese restaurants within X miles of a given geographical point.
PostGIS also includes numerous functions you can use to analyze GIS objects; the functions provide features such as:
- Calculate the surface area of a given object
- Find the distance between two objects
- Locate the Geometric center of a given object
The support that PostGIS provides for GIS objects to Advanced Server is comparable to support added by Oracle Spatial, DB2 Spatial, and SQL Server Spatial to their associated databases.