| | 6 | |
| | 7 | !!What is PostGIS |
| | 8 | |
| | 9 | PostGIS is an extension to the [PostgreSQL | http://www.postgresql.org] object-relational database system that allows [GIS | http://en.wikipedia.org/wiki/Geographic_information_system] (Geographic Information System) objects to be stored in the database. |
| | 10 | PostGIS does for PostgreSQL what Oracle Spatial does for Oracle, ArcSDE does for Microsoft SQL Server/Oracle. |
| | 11 | |
| | 12 | !!Overview |
| | 13 | |
| | 14 | * [Features of PostGIS | FeaturesOfPostgis] |
| | 15 | * [PostGIS as a part of PostgreSQL (Article) | http://www.postgresonline.com/journal/index.php?/archives/7-PostGIS-for-geospatial-analysis-and-mapping.html] |
| | 16 | * [Tools that support PostGIS | ToolsSupportPostgis] |
| | 17 | * [Gallery] Collection of applications using PostGIS in the backend. |
| | 18 | * [PostgresqlCaseStudies | PostgreSQL Case Studies] |
| | 19 | * [PostGIS Hosters | PostGISHosters] |
| | 20 | * [PostGIS Wikipedia entry | http://en.wikipedia.org/wiki/PostGIS] |
| | 21 | * [PostGIS and ArcSDE/ArcGIS 9.3 Articles | Postgisarcgis] |
| | 22 | |
| | 23 | !!Installation Guides |
| | 24 | |
| | 25 | * Directions for [PostGIS RPM Installation|PostgisRpmInstallation]. |
| | 26 | * Directions for [PostGIS on Ubuntu| PostgisOnUbuntu]. |
| | 27 | |
| | 28 | !!Examples of Spatial SQL |
| | 29 | |
| | 30 | * [Find Nearby Features|ExamplesFindNearby] |
| | 31 | * [Find Features far from nearest neighbor - Anti-Near Neighbor | ExamplesAntiNear] |
| | 32 | * [Find Overlapping Features|ExamplesFindOverlapping] |
| | 33 | * [Join Spatial and Non-Spatial Tables|ExamplesJoinTables] |
| | 34 | * [Overlay Geometries in one table with Geometries in another|ExamplesOverlayTables] |
| | 35 | * [Find Features Inside a Particular Polygon|ExamplesInsidePolygon] |
| | 36 | * [Clean Invalid Polygon Topology|CleanPolygons] |
| | 37 | ** [Find points on interior rings within a certain distance to exterior ring|ExamplesInsidePolygon2] |
| | 38 | * [Splitting a Polygon with a Linestring|SplitPolygonWithLineString] |
| | 39 | * [Generating a hexagonal grid|GenerateHexagonalGrid] |
| | 40 | * [MultiPoint centroids from Multi geometries |ComputeMultiCentroid] |
| | 41 | * [OGR Examples] |
| | 42 | |
| | 43 | !!Extending PostGIS |
| | 44 | |
| | 45 | * [PostGIS EJB3 Integration| SpatialEJB3] |
| | 46 | * PostgisTopology - to be moved somewhere else ;) |
| | 47 | * [Raster support|RasterNotes] |
| | 48 | ** [WKT Raster - The new proposed raster implementation in PostGIS|WKTRasterHomePage] |
| | 49 | ** [PGCHIP - The GDAL Postgis driver for raster data | http://simon.benjamin.free.fr/pgchip/] - a corrected version can be found in current GDAL CVS |
| | 50 | * [WishList] of features for the future |
| | 51 | * [Code Sprint 2009 Notes|Sprint2009Notes] |
| | 52 | |
| | 53 | !!Newbie Common Problems and Questions |
| | 54 | |
| | 55 | * [function addgeometrycolumn("unknown", "unknown", integer, "unknown", integer) does not exist] |
| | 56 | * [What is the measurement returned by ST_Distance?] |
| | 57 | * [What unit of measurement do PostGIS functions use? | PostGISFunctionMeasurement] |
| | 58 | * [How to get distance measurement in meters|distance_in_meters] |
| | 59 | |
| | 60 | !!Extras |
| | 61 | |
| | 62 | * [TigerGeocoder | Tiger Geocoder] |
| | 63 | |
| | 64 | !!Summer of Code |
| | 65 | |
| | 66 | * [SummerOfCode2006] |
| | 67 | |
| | 68 | !!Notes |
| | 69 | |
| | 70 | * SpatialAlgorithmWebSites |
| | 71 | |
| | 72 | !!Useful Additional PL/PGSQL Functions |
| | 73 | * [PL/PGSQL Functions|plpgsqlfunctions] |
| | 74 | * [Nearest Neighbor Search] |
| | 75 | * [PL/PGSQL Pseudo Cascade Union Aggregate Function | upgis_cascadeunion] |
| | 76 | |
| | 77 | !!Known issues/patches pending review |
| | 78 | * [IssuesPatchesPending] |
| | 79 | |
| | 80 | !!What is GEOS |
| | 81 | |
| | 82 | [GEOS] is a C++ port of the JTS Topology Suite. |
| | 83 | It is used by PostGIS to implement Topological functions. |
| | 84 | |
| | 85 | !!Wiki How-To |
| | 86 | * Learn HowToUseWiki and learn about AddingPages. |
| | 87 | * Use the SandBox page to experiment with Wiki pages. |
| | 88 | * Please sign your name in RecentVisitors. |
| | 89 | * See RecentChanges for the latest page additions and changes. |
| | 90 | * Find out which pages are MostPopular. |
| | 91 | * Read the ReleaseNotes |
| | 92 | * Administer this Wiki in PhpWikiAdministration. |
