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.
In addition to basic location awareness, PostGIS offers many features rarely found in other competing spatial databases such as Oracle Locator/Spatial and SQL Server. Refer to PostGIS Feature List for more details.
LicensePostGIS is released under the GNU General Public License (GPLv2 or later). Refer to License FAQ for more information. PostGIS is developed by a group of contributors led by a Project Steering Committee.
Should you upgrade now?
Not sure if you are running the best possible PostGIS for your PostgreSQL? Refer to our Version compatibility and EOL Policy.
Here is a sample spatial query to try out in your PostGIS enabled database:
1WITH city AS ( 2 SELECT 'Gotham' AS name, 3 ST_Buffer(ST_Point(0,0), 10) AS geom 4) 5 , superhero(name,geom) AS ( 6 VALUES 7 ('Bat Boy', ST_Point(0.1,0)) 8 , ('Bat Girl', ST_Point(1,1) ) 9) 10SELECT superhero.name 11FROM city INNER JOIN superhero 12 ON ST_Contains(city.geom, superhero.geom);