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