= Welcome to the Users PostGIS Wiki! = Everybody is welcome to contribute to this wiki. * You must login to create new pages and modify existing ones. You can create your own [https://www.osgeo.org/cgi-bin/ldap_create_user.py OSGEO Userid] or use your existing one or you can use the generic one (login:wiki;password:wiki). * Please prefix every new page names in this section with "!UsersWiki" in order to easily distinguish them from other Wiki Trac pages. * For a quick overview of how to format page's content [wiki:WikiFormatting see this page]. == What is PostGIS? == PostGIS is an extension to the [http://www.postgresql.org PostgreSQL] object-relational database system that allows [http://en.wikipedia.org/wiki/Geographic_information_system GIS] (Geographic Information System) objects to be stored in the database. PostGIS does for PostgreSQL what Oracle Spatial does for Oracle, ArcSDE does for Microsoft SQL Server/Oracle. * [http://www.ustream.tv/recorded/10667125 Foss4G JP 2010 State of PostGIS video] by Paul Ramsey * [http://blip.tv/file/2788616/ Foss4G 2009 State of PostGIS video] by Paul Ramsey * [http://wiki.postgresql.org/images/5/5e/Postgis_beyond_courtin_caveayland_pgdayEU2010.pdf PostGIS 1.5 and Beyond] PGDay EU 2010 talk by Mark Cave-Ayland and Olivier Coutin outlines the techical details of upcoming PostGIS 2.0 -- the new disc format, new geometry types etc. * [http://wiki.postgresql.org/images/5/5e/Postgis_beyond_courtin_caveayland_pgdayEU2010.pdf PostGIS 1.5 and Beyond] PGDay EU 2010 talk (more of a user perspective) by Vincent Picavet and Olivier Courtin == Overview == * [http://www.postgis.org/documentation PostGIS Manuals] * [wiki:UsersWikiPostgreSQLPostGIS PostgreSQL/PostGIS version support matrix] * [wiki:UsersWikiFeaturesOfPostgis Features of PostGIS] * [wiki:UsersWikiPostgreSQLPostGIS PostgreSQL/PostGIS GEOS/PostGIS version support matrix] * [wiki:UsersWikiTutorials PostGIS Tutorials] * [http://www.postgresonline.com/journal/index.php?/archives/7-PostGIS-for-geospatial-analysis-and-mapping.html PostGIS as a part of PostgreSQL] (Article)] * [wiki:UsersWikiToolsSupportPostgis Tools that support PostGIS] * [wiki:UsersWikiGallery Gallery] Collection of applications using PostGIS in the backend. * [wiki:UsersWikiPostgreSQLCaseStudies PostgreSQL Case Studies] * [wiki:UsersWikiPostGISHosters PostGIS Hosters] * [wiki:UsersWikiPostGISConsulting PostGIS Support and Consulting Services] * [http://en.wikipedia.org/wiki/PostGIS PostGIS Wikipedia entry] * [wiki:UsersWikiPostgisarcgis PostGIS and ESRI ArcSDE/ArcGIS Articles] * [http://wiki.postgresql.org/wiki/Snippets PostgreSQL general use user contributed functions and snippets] == Contrast / Compare / Port Guides == Don't know if PostGIS is right for you or if another spatial db is more suited or you are porting from another/going to another and not sure the gotchas * [http://www.postgis.us/downloads/ncgis2011/NCGISSDBCrossCompare_2011.pdf NCGIS 2011: Cross Comparison of Spatially Enabled Databases: PostGIS, SQL Server and JASPA] * [http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008r2_oracle11gr2_postgis15_compare Compare SQL Server 2008 R2, Oracle 11G R2, PostgreSQL/PostGIS 1.5 Spatial Features] * [http://www.bostongis.com/PrinterFriendly.aspx?content_name=sqlserver2008_postgis_mysql_compare SQL Server 2008, PostGIS, MySQL function/feature Spatial compare] * [http://www.spatialdbadvisor.com/blog/147/foss4g-2009-sydney-presentation/ Simon Greener's FOSS4G 2009 talk on Oracle Spatial/Locator and gotchas for porting between PostGIS/Oracle] - [http://blip.tv/file/2795843 complete with slides and sound] == Compilation and Installation Guides == * Directions for [wiki:UsersWikiPostgisRpmInstallation PostGIS RPM Installation]. * Directions for [wiki:UsersWikiPostgisOnUbuntu PostGIS on Ubuntu]. * Directions for [wiki:UsersWikiWinCompile Compiling in Windows]. * [http://symbiatch.jutut.fi/article/2955 Sami's Experimental Binaries for PostgreSQL 9.0 64-bit]. * Issues with Installing on Windows Vista [wiki:UsersWikiWinVista Windows Vista Gotchas]. * Directions for [http://www.postgresonline.com/journal/index.php?/archives/147-Compiling-PostGIS-1.5-and-installing-after-Yum-PostgreSQL-Install.html Compiling PostGIS from source for CentOS/Fedora/RedHat EL After Yum Install of PostgreSQL]. == PostGIS Books == * [http://www.postgis.org/documentation/ PostGIS official manuals] for all versions and for PostGIS JDBC driver. * [http://www.postgis.us PostGIS in Action] Due out in hard-copy Early 2011. All chapter drafts currently completed and on MEAP. Manning Early E-Book (MEAP) purchaseable now and with that purchase you get all chapter drafts and updates. This includes PostGIS 1.3-1.5, PostgreSQL 8.3-9.0 (with upcoming highlights of PostgreSQL 9.1 and PostGIS 2.0). You can also pre-order from Amazon now and to lock in the lowest price. All code and data downloads available for free on the book site even if you don't buy the book. Chapter 1 is also a free download. == Examples of Spatial SQL == * [wiki:UsersWikiExamplesFindNearby Find Nearby Features] * [wiki:UsersWikiExamplesFindNearbyLatLon Find Nearby Features in Lat/Lon (EPSG:4326)] * [wiki:UsersWikiExamplesAntiNear Find Features far from nearest neighbor - Anti-Near Neighbor] * [wiki:UsersWikiExamplesJoinTables Join Spatial and Non-Spatial Tables] * [wiki:UsersWikiExamplesOverlayTables Overlay Geometries in one table with Geometries in another] * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon] * [wiki:UsersWikiCleanPolygons Clean Invalid Polygon Topology] * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring] * [wiki:UsersWikiSplitPolygonWithLineString Splitting a Polygon with a Linestring] * [wiki:UsersWikiGenerateHexagonalGrid Generating a hexagonal grid] * [wiki:UsersWikiComputeMultiCentroid MultiPoint centroids from Multi geometries] * [wiki:UsersWikiOGR Examples OGR Examples] * [wiki:UsersWikiExamplesNetworkTopology Create a network topology from a set of noded linestrings] * [wiki:UsersWikiExamplesInterpolateWithOffset Geocode a point along a line with a left/right offset] * [wiki:UsersWikiExamplesSpikeAnalyzer Determining spikes in polygons] * [wiki:UsersWikiExamplesSpikeRemover Searching for spikes and removes them] * [wiki:UsersWikiBatchLoadShapefilesForWindowsUsingShp2pgsql Batch Load Shapefiles with shp2pgsql.exe on windows] == Extending PostGIS == * [wiki:UsersWikiSpatialEJB3 PostGIS EJB3 Integration] * [wiki:UsersWikiPostgisTopology Postgis Topology] - to be moved somewhere else ;) * [wiki:UsersWikiRasterNotes Raster support] * [wiki:WKTRaster WKT Raster] - The new raster implementation in PostGIS * [http://simon.benjamin.free.fr/pgchip/ PGCHIP] - The GDAL Postgis driver for raster data - a corrected version can be found in current GDAL CVS * [wiki:UsersWikiWishList WishList] of features for the future. * [wiki:UsersWikiSprint2009Notes Code Sprint 2009 Notes] * [wiki:SpatiaLite] export from PostGIS * [wiki:pgRouting] routing with PostGIS == Newbie Common Problems and Questions == * [wiki:UsersWikiNewbieAddgeometrycolumn function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist] * [wiki:UsersWikiNewbieDistanceMeasurement What is the measurement returned by ST_Distance?] * [wiki:UsersWikiNewbiePostGISFunctionMeasurement What unit of measurement do PostGIS functions use?] * [wiki:UsersWikiNewbieMeasurementInMeters How to get distance measurement in meters?] == Extras == * [wiki:UsersWikiTiger Geocoder TigerGeocoder] == Notes == * [wiki:UsersWikiSpatialAlgorithmWebSites Spatial Algorithm Web Sites] == Useful Additional PL/PGSQL Functions == * [wiki:UsersWikiplpgsqlfunctions PL/PGSQL Functions] * [wiki:UsersWikiwktrasterfunctions WKT Raster Helper Functions] * [wiki:UsersWikiNearest Neighbor Search Nearest Neighbor Search] * [wiki:UsersWikiCascadeUnion PL/PGSQL Pseudo Cascade Union Aggregate Function (use for pre-PostGIS 1.4] == What is GEOS == [http://geos.osgeo.org GEOS] is a C++ port of the [http://en.wikipedia.org/wiki/JTS_Topology_Suite JTS Topology Suite]. It is used by PostGIS to implement Topological functions.