How to Set Up and Use PostGIS with Postgres Plus Standard Server
PostGIS is a powerful spatial database extension you can use with Postgres Plus Standard Server. This tutorial shows how quickly you can setup and begin using a spatially enabled database that can be applied to a variety of applications.
If using Postgres Plus Advanced Server, refer to PostGIS Tutorial for Postgres Plus Advanced Server
This EnterpriseDB Quick Tutorial helps you get started with the Postgres Plus Standard Server database in a Linux or Windows environment. It is assumed that you have already downloaded and installed Postgres Plus Standard Server on your desktop or laptop computer.
This Quick Tutorial is designed to help you expedite your Technical Evaluation of Postgres Plus Standard Server or 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 Standard Server that stores GIS objects. PostGIS supports storage of the following GIS object types:
In addition to adding GIS storage capabilities to Standard 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 Standard Server is comparable to support added by Oracle Spatial, DB2 Spatial, and SQL Server Spatial to their associated databases.
For detailed instructions on how to set up PostGIS, please see PostGIS documentation here.