Using PostGIS

PostGIS http://postgis.refractions.net is a spatial extension for the PostgreSQL RDBMS. A properly administered PostGIS database can serve as the backend for a PCL FeatureStore?. PostGIS is not trivial to set up. Read its excellent documentation carefully.

Common Sources of Trouble

Geometry columns

The PostGIS geometry_columns table is where we find typenames. Make sure it is consistent with the feature tables in the database.

SRIDs

PostGIS internal spatial reference ID number. Unlike MapServer?, PCL will not let you use improperly referenced data. The PostGIS default SRID of -1, indicating unreferenced data, isn't supported by PCL. Be careful to set the proper SRID when loading data into your database. You may also edit the appropriate item in the geometry_columns table to reference your data after it has been loaded. Read the PostGIS docs carefully.