PostGIS

Spatial and Geographic objects for PostgreSQL

  • Home
  • Download
  • Documentation
  • Development
  • Support

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.

SELECT superhero.name
FROM city, superhero
WHERE ST_Contains(city.geom, superhero.geom)
AND city.name = 'Gotham';

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). Refer to License FAQ for more information. PostGIS is developed by a group of contributors led by a Project Steering Committee.

News

What's happening right now

Blogs, Tweets and more…

Follow @postgis

Foreign Data Wrappers for PostGIS

The last couple weeks have seen two interesting updates in the world of PostgreSQL “foreign data wrappers” (FDW). Foreign data wrappers allow you to access remote data inside your database, exactly like other tables. PostgreSQL ships with two example implementations, one for accessing text files, and the other for accessing remote PostgreSQL servers.

The two updates of interest to PostGIS users are:

  • The Oracle FDW implementation was recently enhanced to support spatial columns, so an Oracle table with SDO_GEOMETRY columns can be exposed in PostgreSQL as a table with PostGIS geometry columns.
  • A new OGR FDW implementation was released that supports exposing any OGR data source as a table with PostGIS geometry columns.

Now you can access your PostGIS data without even going to the trouble of importing it first!

PostGIS 2.1.5 Released

The 2.1.5 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.5 release. As befits a patch release, the focus is on bugs, breakages, and performance issues

http://download.osgeo.org/postgis/source/postgis-2.1.5.tar.gz

Read More…


PostGIS 2.1.4 Released

The 2.1.4 release of PostGIS is now available.

The PostGIS development team is happy to release patch for PostGIS 2.1, the 2.1.4 release. As befits a patch release, the focus is on bugs, breakages, and performance issues

http://download.osgeo.org/postgis/source/postgis-2.1.4.tar.gz

Read More…


Security releases 2.0.6 and 2.1.3

It has come to our attention that the PostGIS Raster support may give more privileges to users than an administrator is willing to grant. These include reading files from the filesystem and opening connections to network hosts.

Read More…


More News…

Upcoming Events

San Francisco CA, USA March 9th-12th, 2015 - FOSS4G NA and PGDay

FOSS4G-E 2015 logo Foss4G Europe Politecnico di Milano in Como, Italy, July 15th to 17th, 2015

Seoul, Korea Sept 14th-19th, 2015 - FOSS4G 2015

Recent past events

Avid Geo LocationTech Tour Boston, Dec 8th, 2014 - Cambridge, MA, USA

PostGIS Day Nov 20th, 2014 - London, UK

PostGIS Day Happenings Nov 20th 2014 - around the world

PostgreSQL Sessions (Paris)

FOSS4G 2014 Videos
Postgres Open 2014

Tips

Getting distinct pixel values and pixel value counts of a raster

PostGIS raster has so so many functions and probably at least 10 ways of doing something some much much slower than others. Suppose you have a raster, or you have a raster area of interest — say elevation raster for example, and you want to know the distinct pixel values in the area. The temptation is to reach for ST_Value function in raster, but there is a much much more efficient function to use, and that is the ST_ValueCount function.

ST_ValueCount function is one of many statistical raster functions available with PostGIS 2.0+. It is a set returning function that returns 2 values for each row: a pixel value (value), and a count of pixels (count) in the raster that have that value. It also has variants that allow you to filter for certain pixel values.

This tip was prompted by the question on stackexchange How can I extract all distinct values from a PostGIS Raster?

Read More…


More Tips…

Case Studies

Institut Géographique National

The Institut Géographique National (IGN) is the national mapping agency for France, with 1800 employees and a mandate to collect, integrate, manage and distribute reference geographical information for the whole country.

Read More…


InfoTerra

Infoterra has been in the geospatial business for over 25 years, since its founding in 1980 as the UK National Remote Sensing Centre. In that time, NRSC grew, formed international partnerships with space agencies, expanded into aerial data collection, and was eventually privatized and re-named “Infoterra” in the late 1990s.

Read More…


More Case Studies…

Site Map

  • Home
  • Install
  • Documentation
  • Development
  • Planet PostGIS
  • Support

PostGIS Project Steering Committee (PSC)

  • Paul Ramsey (Chair)
  • Sandro Santilli
  • Regina Obe
  • Mark Cave-Ayland
  • Bborie Park