|Version 5 (modified by anonymous, 4 years ago)|
This is just a page to practice and learn WikiFormatting.
Go ahead, edit it freely.
!!What is PostGIS
PostGIS is an extension to the PostgreSQL object-relational database system that allows 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?.
* of PostGIS? * as a part of PostgreSQL (Article) * [Tools that support PostGIS | ToolsSupportPostgis?] * [Gallery] Collection of applications using PostGIS in the backend. * | PostgreSQL Case Studies? * [PostGIS Hosters | PostGISHosters] * [PostGIS Wikipedia entry | http://en.wikipedia.org/wiki/PostGIS] * [PostGIS and ArcSDE/ArcGIS 9.3 Articles | Postgisarcgis]
!!Examples of Spatial SQL
* [Find Nearby Features|ExamplesFindNearby?] * [Find Features far from nearest neighbor - Anti-Near Neighbor | ExamplesAntiNear?] * [Find Overlapping Features|ExamplesFindOverlapping?] * [Join Spatial and Non-Spatial Tables|ExamplesJoinTables?] * [Overlay Geometries in one table with Geometries in another|ExamplesOverlayTables?] * [Find Features Inside a Particular Polygon|ExamplesInsidePolygon?] * [Clean Invalid Polygon Topology|CleanPolygons?] ** [Find points on interior rings within a certain distance to exterior ring|ExamplesInsidePolygon?2] * [Splitting a Polygon with a Linestring|SplitPolygonWithLineString?] * [Generating a hexagonal grid|GenerateHexagonalGrid?] * centroids from Multi geometries |ComputeMultiCentroid? * [OGR Examples]
* [PostGIS EJB3 Integration| SpatialEJB3] * PostgisTopology? - to be moved somewhere else ;) * [Raster support|RasterNotes?] ** [WKT Raster - The new proposed raster implementation in PostGIS|WKTRasterHomePage] ** [PGCHIP - The GDAL Postgis driver for raster data | http://simon.benjamin.free.fr/pgchip/] - a corrected version can be found in current GDAL CVS * [WishList?] of features for the future * [Code Sprint 2009 Notes|Sprint2009Notes]
!!Newbie Common Problems and Questions
* [function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist] * [What is the measurement returned by ST_Distance?] * [What unit of measurement do PostGIS functions use? | PostGISFunctionMeasurement] * [How to get distance measurement in meters|distance_in_meters]
!!Summer of Code
!!Useful Additional PL/PGSQL Functions * [PL/PGSQL Functions|plpgsqlfunctions] * [Nearest Neighbor Search] * [PL/PGSQL Pseudo Cascade Union Aggregate Function | upgis_cascadeunion]
!!Known issues/patches pending review * [IssuesPatchesPending?]
!!What is GEOS
[GEOS] is a C++ port of the JTS Topology Suite. It is used by PostGIS to implement Topological functions.
!!Wiki How-To * Learn HowToUseWiki? and learn about AddingPages?. * Use the SandBox page to experiment with Wiki pages. * Please sign your name in RecentVisitors?. * See RecentChanges for the latest page additions and changes. * Find out which pages are MostPopular?. * Read the ReleaseNotes? * Administer this Wiki in PhpWikiAdministration?.