wiki:SandBox

Version 4 (modified by anonymous, 16 years ago) ( diff )

The Sandbox

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 | http://www.postgresql.org] 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.

!!Overview

!!Installation Guides

!!Examples of Spatial SQL

[Find points on interior rings within a certain distance to exterior ring|ExamplesInsidePolygon2]

!!Extending PostGIS

[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]

!!Extras

!!Summer of Code

  • [SummerOfCode2006]

!!Notes

!!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

!!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

Note: See TracWiki for help on using the wiki.