PostGIS



PostGIS is a Spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. IFM and Cadcorp products utlise PostGIS as part of our solutions and support Open Source initiatives.

PostGIS offers many features rarely found in other competing spatial databases such as Oracle Spatial and SQL Server 2008
  • Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, raster map algebra and collecting/unioning with the power of SQL
  • Spatial reprojection SQL callable functions for both vector and raster data
  • Support for importing / exporting ESRI shapefile vector data via both commandline and GUI packaged tools and support for more formats via other 3rd-party Open Source tools
  • Packaged command-line for importing raster data from many standard formats: GeoTiff, NetCDF, PNG, JPG to name a few
  • Rendering and importing vector data support functions for standard textual formats such as KML,GML, GeoJSON,GeoHash and WKT using SQL
  • Rendering raster data in various standard formats GeoTIFF, PNG, JPG, NetCDF, to name a few using SQL
  • Seamless raster/vector SQL callable functions for extrusion of pixel values by geometric region, running stats by region, clipping rasters by a geometry, and vectorizing rasters
  • 3D object support, spatial index, and functions
  • Network Topology support
PostGIS follows the Open Geospatial Consortium’s “Simple Features for SQL Specification ” and has been certified as compliant with the “Types and Functions” profile. PostGIS is open source software, released under the GNU General Public License.