= PostGIS Tracker and Wiki = {{{ #!html
FOSS4G 2021
}}} [[Image(OSGeo_project.svg, width=140, right, link=http://www.osgeo.org/)]] [[br]] ---- || Build status || \ ||= '''Debbie''' [[br]] ,,''Debian Buster/sid [[br]]GNU/Linux 64bit[[br]] gcc (Debian 9.3.0) 9.3.0[[br]] SFCGAL 1.3.8[[br]]Proj 7.2.0[[br]]Tests upgrades (3.0+)'',, =||\ ||= '''Winnie''' [[br]] ,,''Windows[[br]]32bit (mingw64 gcc 8.1.0)[[br]] / 64bit (mingw64 gcc 8.1.0) [[br]] SFCGAL 1.3.8'',, =||\ ||= '''Dronie''' [[br]] ,,''Trisquel[[br]]GNU/Linux 64bit[[br]]PG 9.6 to 10[[br]]GEOS 3.6.2[[br]]GDAL 2.2.3[[br]]----[[br]]Alpine Edge 64bit[[br]]PG 12[[br]]SFCGAL 1.3.8[[br]]GEOS 3.8.1[[br]]GDAL 3.0.3, Proj 7.1[[br]]----[[br]]All Test upgrades'',, =||\ ||= '''Github Actions''' [[br]] ,,''Ubuntu[[br]]Dockerized[[br]]See tags for details'',, =||\ ||= '''Gitlab-CI''' [[br]] ,,''Debian[[br]]see badge titles[[br]]for details[[br]]Tests dump-restore'',, =||\ ||= '''Bessie''' [[br]] ,,''FreeBSD 12.2 64-bit[[br]]clang version 8.0.1 w LLVM[[br]]PG 11.9 (>=2.3)[[br]]GDAL 3.1.1[[br]]GEOS 3.8.1[[br]]SFCGAL 1.3.8, Proj 7.2.0'',, =||\ ||= '''Bessie32''' [[br]] ,,''FreeBSD 12.2 32-bit[[br]]clang version 8.0.1 w LLVM[[br]]PG 11.9 (>=2.3)[[br]]GDAL 3.1.1[[br]]GEOS 3.8.1[[br]]SFCGAL 1.3.8, Proj 7.2.0'',, =||\ ||= '''Berrie''' [[br]] ,,''Rasberry Pi 32-bit[[br]](Debian Buster)[[br]]gcc 8.3.0[[br]]PG 13 (>=3.0)[[br]]GDAL 2.4.0[[br]]GEOS 3.7.1[[br]]Proj 5.2.0'',, =|| \ ||= '''Berrie64''' [[br]] ,,''Rasberry Pi 64-bit[[br]](Debian Buster)[[br]]gcc 8.3.0[[br]]PG 13 (>=3.0)[[br]]GDAL 2.4.0[[br]]GEOS 3.7.1[[br]]Proj 5.2.0'',, =|| ||= '''master''' =|| \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_trunk, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_trunk/, alt=status, height="20", title='PG 9.5-12 (branch), GDAL 2.3 branch, GEOS trunk')]] || \ || [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_trunk, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_trunk/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\ || [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/master, link=https://dronie.osgeo.org/postgis/postgis?branch=master, alt=status)]] ||\ || [[Image(https://github.com/postgis/postgis/workflows/CI/badge.svg?branch=master, link=https://github.com/postgis/postgis/actions?query=branch%3Amaster, alt=status, height="20")]] ||\ || [[Image(https://gitlab.com/postgis/postgis/badges/master/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/master, alt=status, title='PG 11.1, GDAL 2.4.0, GEOS 3.7.1, PROJ 5.2.0')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/master}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64, alt=status, height="20", title='PG 13(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || ||= '''3.1''' =|| \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_3.1, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_3.1/, alt=status, height="20", title='PG 9.3-12(branch), GDAL 2.3 branch, GEOS 2.4')]] || \ || [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_3.1, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_3.1/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\ || [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-3.1, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-3.1, alt=status)]] ||\ || [[Image(https://github.com/postgis/postgis/workflows/CI/badge.svg?branch=stable-3.1, link=https://github.com/postgis/postgis/actions?query=branch%3Astable-3.1, alt=status, height="20")]] ||\ || [[Image(https://gitlab.com/postgis/postgis/badges/stable-3.1/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-3.1, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/stable-3.1}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/stable-3.1}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/stable-3.1}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/stable-3.1}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64?build=last:${params.reference=refs/heads/stable-3.1, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || ||= '''3.0''' =|| \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_3.0, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_3.0/, alt=status, height="20", title='PG 9.3-12(branch), GDAL 2.3 branch, GEOS 2.4')]] || \ || [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_3.0, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_3.0/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\ || [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-3.0, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-3.0, alt=status)]] ||\ || [[Image(https://github.com/postgis/postgis/workflows/CI/badge.svg?branch=stable-3.0, link=https://github.com/postgis/postgis/actions?query=branch%3Astable-3.0, alt=status, height="20")]] ||\ || [[Image(https://gitlab.com/postgis/postgis/badges/stable-3.0/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-3.0, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 10.1(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/stable-3.0}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/stable-3.0, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64?build=last:${params.reference=refs/heads/stable-3.0, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || ||= '''2.5''' =|| \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_2.5, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_2.5/, alt=status, height="20", title='PG 9.3-12(branch), GDAL 2.3 branch, GEOS 2.4')]] || \ || [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_2.5, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_2.5/, alt=status, height="20", title='PG 9.5-11, GDAL 2.2.4, GEOS 3.8,32/64-bit')]] ||\ || [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-2.5, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-2.5, alt=status)]] ||\ || [[Image(https://github.com/postgis/postgis/workflows/CI/badge.svg?branch=stable-2.5, link=https://github.com/postgis/postgis/actions?query=branch%3Astable-2.5, alt=status, height="20")]] ||\ || [[Image(https://gitlab.com/postgis/postgis/badges/stable-2.5/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-2.5, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie, alt=status, height="20", title='PG 11 (branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=bessie32&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=bessie32, alt=status, height="20", title='PG 11(branch), GDAL 2.1 branch, GEOS 3.6')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] ||\ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_Worker_Run/label=berrie64&build=last:${params.reference=refs/heads/stable-2.5}, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_Worker_Run/label=berrie64, alt=status, height="20", title='PG 12(branch), GDAL 2.4.0 branch, GEOS 3.7.1')]] || ||= '''2.4''' =|| \ || [[Image(https://debbie.postgis.net/buildStatus/icon?job=PostGIS_2.4, link=https://debbie.postgis.net/view/PostGIS/job/PostGIS_2.4/, alt=status, height="20", title='PG 9.3-9.6 10(branch), GDAL 2.3 branch, GEOS 2.4')]] || \ || [[Image(https://winnie.postgis.net:444/buildStatus/icon?job=PostGIS_2.4, link=https://winnie.postgis.net:444/view/PostGIS/job/PostGIS_2.4/, alt=status, height="20", title='PG 9.3-9.6, GDAL 2.2.4, GEOS 3.7dev,32/64-bit')]] ||\ || [[Image(https://dronie.osgeo.org/api/badges/postgis/postgis/status.svg?ref=refs/heads/stable-2.4, link=https://dronie.osgeo.org/postgis/postgis?branch=stable-2.4, alt=status)]] ||\ || [[Image(https://github.com/postgis/postgis/workflows/CI/badge.svg?branch=stable-2.4, link=https://github.com/postgis/postgis/actions?query=workflow%3ACI, alt=status, height="20")]] ||\ || [[Image(https://gitlab.com/postgis/postgis/badges/stable-2.4/pipeline.svg, link=https://gitlab.com/postgis/postgis/commits/stable-2.4, alt=status, height="20", title='PG 9.6.10, GDAL 2.1.2, GEOS 3.5.1, PROJ 4.9.3')]] || == About PostGIS == PostGIS is a geospatial extension for PostgreSQL. It allows map data to be stored, queried and analyzed within the database. It is an [http://www.osgeo.org OSGeo] project. This Trac instance is used for bug, enhancement & task tracking for PostGIS. It also serves as a user and developer wiki, and a view into the [CodeRepository code repository]. To edit the wiki pages and bug/enhancement/task tickets you'll need to login with an [http://www.osgeo.org/osgeo_userid OSGeo Userid]. Read the TracGuide for details about how the site works. The project's website is [https://postgis.net] == Downloading == * [https://download.osgeo.org/postgis/source/ Released Tar Balls] * [CodeMirrors List of source repos] * [wiki:RCDownloads Release Candidate Downloads] == Documentation == * Doxygen Dev Documents [https://postgis.net/docs/doxygen/3.1 3.1] [https://postgis.net/docs/doxygen/3.0 3.0] [https://postgis.net/docs/doxygen/2.5 2.5] [https://postgis.net/docs/doxygen/2.4 2.4] * [http://postgis.net/documentation/ PostGIS Manuals] * [wiki:UsersWikiPostgreSQLPostGIS PostgreSQL/PostGIS GEOS GDAL /PostGIS version support matrix] == Mail lists == * [http://lists.osgeo.org/mailman/listinfo/postgis-users postgis-users] – Discussion of the use and uses of the PostGIS * [http://lists.osgeo.org/mailman/listinfo/postgis-devel postgis-devel] – Discussion of ongoing development to the PostGIS; technical issues and debates about changes to the internals of PostGIS belong here * [http://lists.osgeo.org/mailman/listinfo/postgis-tickets postgis-tickets] – Automatic notifications from Trac tickets (also called "issues") == Bug Tracking == * [/newticket Submit a new bug report] (you need to [http://trac.osgeo.org/postgis/login login] with an [http://www.osgeo.org/osgeo_userid OSGeo Userid]). If you need to reset your password use [https://www.osgeo.org/user OSGeo profile reset password] * Bug reports for the [wiki:WKTRaster PostGIS Raster] extension must have the summary prefixed with '''[raster]''' and the corresponding "raster" component assigned. * If possible, provide the output of gdalinfo run upon the source raster. * If the bug relates to the raster2pgsql loader, provide the command line parameters you are using. * [/report/3 List Open Bugs] * [query:status!=closed&type=enhancement&order=id&desc=1,compact List Open Enhancement Requests] == Related Planets == * [http://planet.postgis.net Planet PostGIS] * [http://planet.osgeo.org Planet OSGeo] * [http://planet.postgresql.org Planet PostgreSQL] * [http://planetgs.com Planet Geospatial] == Wiki == * [UsersWikiMain Users Wiki] * [wiki:UsersWikiInstall PostGIS Install and Compilation Guide] for different systems * [wiki:UsersWikiPackages PostGIS Pre-Built Packages] for different systems * [DevWikiMain Developer Wiki] * [wiki:DevWikiRFC PostGIS RFCs] * [wiki:GoogleSummerCode2021 Google Summer Of Code 2021] * [wiki:GoogleSummerCode2019 Google Summer Of Code 2019] * [wiki:GoogleSummerCode2018 Google Summer Of Code 2018] * [wiki:GoogleSummerCode Google Summer Of Code 2013] * [DevWikiEvent Code Sprint] * [wiki:PostGIS3] * [wiki:FAQ FAQ] == PostGIS Extensions == List of PostGIS extensions: === PostGIS Raster (formerly PostGIS WKT Raster) === * [wiki:WKTRaster PostGIS Raster] – Integration of a new raster type within PostGIS spec. * [wiki:WKTRasterTutorial01 Raster Tutorial] – Demonstrates how to use Raster with vector geometries and install on windows. * [http://postgis.net/docs/manual-dev/RT_reference.html Raster functions reference] – This is a list of already implemented functions. Documentation of functions still in progress. * [http://fuzzytolerance.info/code/postgis-raster-ftw/ PostGIS Raster FTW] – Real application – land classification /vector/raster operations * [http://trac.osgeo.org/gdal/wiki/frmts_wtkraster.html PostGIS Raster Driver for GDAL] – Information about PostGIS Raster driver for GDAL * [http://mateusz.loskot.net/2009/03/30/crunching-wkt-rasters/ Crunching Rasters with WKT Raster] === PostGIS Topology === * [wiki:UsersWikiPostgisTopology PostGIS Topology] == Trac Documentation == * TracGuide – Built-in Documentation * [http://trac.edgewall.org/ The Trac project] – Trac Open Source Project * [http://trac.edgewall.org/wiki/TracFaq Trac FAQ] – Frequently Asked Questions * TracSupport – Trac Support For a complete list of local wiki pages, see TitleIndex.