About 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.
Docs for latest stable release
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.
License
PostGIS 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.
Hello PostGIS
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);