| | 1 | == What is PostGIS == |
| | 2 | |
| | 3 | 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. |
| | 4 | PostGIS does for PostgreSQL what Oracle Spatial does for Oracle, ArcSDE does for Microsoft SQL Server/Oracle. |
| | 5 | |
| | 6 | == Overview == |
| | 7 | |
| | 8 | * [wiki:UsersWikiFeaturesOfPostgis Features of PostGIS] |
| | 9 | * [http://www.postgresonline.com/journal/index.php?/archives/7-PostGIS-for-geospatial-analysis-and-mapping.html PostGIS as a part of PostgreSQL (Article)] |
| | 10 | * [wiki:UsersWikiToolsSupportPostgis Tools that support PostGIS] |
| | 11 | * [wiki:UsersWikiGallery Gallery] Collection of applications using PostGIS in the backend. |
| | 12 | * [wiki:UsersWikiPostgreSQL Case Studies PostgresqlCaseStudies] |
| | 13 | * [wiki:UsersWikiPostGISHosters PostGIS Hosters] |
| | 14 | * [http://en.wikipedia.org/wiki/PostGIS PostGIS Wikipedia entry] |
| | 15 | * [wiki:UsersWikiPostgisarcgis PostGIS and ArcSDE/ArcGIS 9.3 Articles] |
| | 16 | |
| | 17 | == Installation Guides == |
| | 18 | |
| | 19 | * Directions for [wiki:UsersWikiPostgisRpmInstallation PostGIS RPM Installation]. |
| | 20 | * Directions for [wiki:UsersWikiPostgisOnUbuntu PostGIS on Ubuntu]. |
| | 21 | |
| | 22 | == Examples of Spatial SQL == |
| | 23 | |
| | 24 | * [wiki:UsersWikiExamplesFindNearby Find Nearby Features] |
| | 25 | * [wiki:UsersWikiExamplesAntiNear Find Features far from nearest neighbor - Anti-Near Neighbor] |
| | 26 | * [wiki:UsersWikiExamplesFindOverlapping Find Overlapping Features] |
| | 27 | * [wiki:UsersWikiExamplesJoinTables Join Spatial and Non-Spatial Tables] |
| | 28 | * [wiki:UsersWikiExamplesOverlayTables Overlay Geometries in one table with Geometries in another] |
| | 29 | * [wiki:UsersWikiExamplesInsidePolygon Find Features Inside a Particular Polygon] |
| | 30 | * [wiki:UsersWikiCleanPolygons Clean Invalid Polygon Topology] |
| | 31 | * [wiki:UsersWikiExamplesInsidePolygon2 Find points on interior rings within a certain distance to exterior ring] |
| | 32 | * [wiki:UsersWikiSplitPolygonWithLineString Splitting a Polygon with a Linestring] |
| | 33 | * [wiki:UsersWikiGenerateHexagonalGrid Generating a hexagonal grid] |
| | 34 | * [wiki:UsersWikiComputeMultiCentroid MultiPoint centroids from Multi geometries] |
| | 35 | * [wiki:UsersWikiOGR Examples OGR Examples] |
| | 36 | |
| | 37 | == Extending PostGIS == |
| | 38 | |
| | 39 | * [wiki:UsersWikiSpatialEJB3 PostGIS EJB3 Integration] |
| | 40 | * PostgisTopology - to be moved somewhere else ;) |
| | 41 | * [wiki:UsersWikiRasterNotes Raster support] |
| | 42 | * [wiki:UsersWikiWKTRasterHomePage WKT Raster - The new proposed raster implementation in PostGIS] |
| | 43 | * [http://simon.benjamin.free.fr/pgchip/ PGCHIP - The GDAL Postgis driver for raster data] - a corrected version can be found in current GDAL CVS |
| | 44 | * [wiki:UsersWikiWishList WishList] of features for the future |
| | 45 | * [wiki:UsersWikiSprint2009Notes Code Sprint 2009 Notes] |
| | 46 | |
| | 47 | == Newbie Common Problems and Questions == |
| | 48 | |
| | 49 | * [wiki:UsersWikifunction addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist] |
| | 50 | * [wiki:UsersWikiWhat is the measurement returned by ST_Distance? What is the measurement returned by ST_Distance?] |
| | 51 | * [wiki:UsersWikiPostGISFunctionMeasurement What unit of measurement do PostGIS functions use?] |
| | 52 | * [wiki:UsersWikidistance_in_meters How to get distance measurement in meters] |
| | 53 | |
| | 54 | == Extras == |
| | 55 | |
| | 56 | * [wiki:UsersWikiTiger Geocoder TigerGeocoder] |
| | 57 | |
| | 58 | == Summer of Code == |
| | 59 | |
| | 60 | * [wiki:UsersWikiSummerOfCode2006 SummerOfCode2006] |
| | 61 | |
| | 62 | == Notes == |
| | 63 | |
| | 64 | * SpatialAlgorithmWebSites |
| | 65 | |
| | 66 | == Useful Additional PL/PGSQL Functions == |
| | 67 | * [wiki:UsersWikiplpgsqlfunctions PL/PGSQL Functions] |
| | 68 | * [wiki:UsersWikiNearest Neighbor Search Nearest Neighbor Search] |
| | 69 | * [wiki:UsersWikiupgis_cascadeunion PL/PGSQL Pseudo Cascade Union Aggregate Function] |
| | 70 | |
| | 71 | == Known issues/patches pending review == |
| | 72 | * [wiki:UsersWikiIssuesPatchesPending IssuesPatchesPending] |
| | 73 | |
| | 74 | == What is GEOS == |
| | 75 | |
| | 76 | [wiki:UsersWikiGEOS GEOS] is a C++ port of the JTS Topology Suite. |
| | 77 | It is used by PostGIS to implement Topological functions. |
| | 78 | |
| | 79 | == Wiki How-To == |
| | 80 | * Learn HowToUseWiki and learn about AddingPages. |
| | 81 | * Use the SandBox page to experiment with Wiki pages. |
| | 82 | * Please sign your name in RecentVisitors. |
| | 83 | * See RecentChanges for the latest page additions and changes. |
| | 84 | * Find out which pages are MostPopular. |
| | 85 | * Read the ReleaseNotes |
| | 86 | * Administer this Wiki in PhpWikiAdministration. |
