PostGIS stores and queries for information about location and mapping and provides spatial objects (geometry, geography, and raster as well as others) for the PostgreSQL object-relational database. It also adds functions, operators, and index enhancements to these spatial types that augment the power of the core PostgreSQL DBMS, making it a fast, featureful, and robust spatial database management system.
Support for common and advanced spatial operations such as geometry creation and conversion, reprojection, buffer, convex hull, generalization, union, and more
Rendering and importing vector data formats such as Shapefiles KML, GML, GeoJSON, GeoHash and WKT using SQL
Rendering and importing raster data formats such as GeoTIFF, PNG, JPG, NetCDF, etc.