Earth Science

PostGIS – spatial database extender for PostgreSQL object-relational database

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.

It also adds functions, operators, and index enhancements that apply to these spatial types. These additional functions, operators, index bindings and types augment the power of the core PostgreSQL DBMS, making it a fast, feature-plenty, and robust spatial database management system.

PostGIS includes support for GiST-based R-Tree spatial indexes, and functions for analysis and processing of GIS objects.

Key Features

  • Processing and analytic functions for both vector and raster data for splicing, dicing, morphing, reclassifying, and collecting/unioning with the power of SQL.
  • raster map algebra for fine-grained raster processing.
  • 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.
  • Packaged Tiger Loader / Geocoder/ Reverse Geocoder / utilizing US Census Tiger data.

Website: postgis.net
Support: Documentation, FAQ
Developer: PostGIS Development Group
License: GNU General Public License v2.0

PostGIS is written in C. Learn C with our recommended free books and free tutorials.


Related Software

Earth Science Software
GRASSGeographic Resources Analysis Support System
Quantum GISUser friendly Geographic Information System
SurvexCave surveying and mapping software
SAGASystem for Automated Geoscientific Analyses
GPlatesInteractive visualization of plate-tectonics
GMTCollection of tools that allow users to manipulate data sets
TherionCave surveying - 2D and 3D drawing software
GeoServerServer written in Java that allows users to share and edit geospatial data
OpenJUMPGeographic Information System written in Java
GrADSGrid Analysis and Display System for earth science data
gvSIG DesktopPowerful, user-friendly Geographic Information System
PostGISDatabase extender for PostgreSQL object-relational database
WhiteboxToolsAdvanced geospatial data analysis platform
ObsPyFramework to process, analyse, and visualise seismological data
ncviewVisual browser for NetCDF format files
MapServerSystem for developing web-based GIS applications
OpenDriftFramework for ocean trajectory modelling
MetPyRead, visualize and perform calculations with weather data
uDigSpatial data viewer/editor
OpenSeesOpen System for Earthquake Engineering Simulation
GrockDisplays a geological map of the UK

Read our verdict in the software roundup.


Best Free and Open Source Software Explore our comprehensive directory of recommended free and open source software. Our carefully curated collection spans every major software category.

This directory is part of our ongoing series of informative articles for Linux enthusiasts. It features hundreds of detailed reviews, along with open source alternatives to proprietary solutions from major corporations such as Google, Microsoft, Apple, Adobe, IBM, Cisco, Oracle, and Autodesk.

You’ll also find interesting projects to try, hardware coverage, free programming books and tutorials, and much more.

Discovered a useful open source Linux program that we haven’t covered yet? Let us know by completing this form.
Subscribe
Notify of
guest
0 Comments
Oldest
Newest Most Voted
Inline Feedbacks
View all comments