<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>PostGIS — OSGeo Live v4.0 documentation</title>
<link rel="stylesheet" href="_static/overview.css" type="text/css" />
<link rel="stylesheet" href="_static/pygments.css" type="text/css" />
<script type="text/javascript">
var DOCUMENTATION_OPTIONS = {
URL_ROOT: '#',
VERSION: '4.0',
COLLAPSE_MODINDEX: false,
FILE_SUFFIX: '.html',
HAS_SOURCE: true
};
</script>
<script type="text/javascript" src="_static/jquery.js"></script>
<script type="text/javascript" src="_static/doctools.js"></script>
<link rel="top" title="OSGeo Live v4.0 documentation" href="index.html" />
<link rel="next" title="osgEarth" href="osgearth_overview.html" />
<link rel="prev" title="Welcome to OSGeo-Live" href="overview.html" />
</head>
<body>
<div class="header">
<div class="wrap">
<ul id="top-nav">
<li class="first"><a href="http://osgeo.org">OSGeo</a></li>
</ul>
</div>
</div>
<div class="related">
<ul id="breadcrumbs">
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
accesskey="I">index</a></li>
<li class="right" >
<a href="osgearth_overview.html" title="osgEarth"
accesskey="N">next</a> |</li>
<li class="right" >
<a href="overview.html" title="Welcome to OSGeo-Live"
accesskey="P">previous</a> |</li>
<li><a href="overview.html">OSGeo Live v4.0 documentation</a> »</li>
<li><a href="#">PostGIS</a></li>
</ul>
</div>
<div class="document">
<div class="documentwrapper">
<div class="body">
<span class="target" id="postigs-overview"></span><a class="reference external image-reference" href="http://postgis.refractions.net/"><img align="right" alt="project logo" class="align-right" src="_images/logo-PostGIS.png" style="width: 89.7px; height: 131.7px;" /></a>
<a class="reference external image-reference" href="http://www.osgeo.org/incubator/process/principles.html"><img align="right" alt="OSGeo Project" class="align-right" src="_images/OSGeo_incubation.png" style="width: 150.0px; height: 53.0px;" /></a>
<div class="section" id="postgis">
<h1>PostGIS<a class="headerlink" href="#postgis" title="Permalink to this headline">¶</a></h1>
<div class="section" id="spatial-database">
<h2>Spatial Database<a class="headerlink" href="#spatial-database" title="Permalink to this headline">¶</a></h2>
<p>PostGIS spatially enables the popular PostgreSQL object-relational database, allowing it to be used as a back-end database for geographic information systems (GIS) and web-mapping applications in the same manner as Oracle Spatial enables the Oracle database.</p>
<p>PostGIS is stable, fast, standards compliant, with hundreds of spatial functions and is currently the most widely used Open Source spatial database. PostGIS is used by diverse organisations from around the world, including risk adverse government agencies and organisations storing terrabytes of data serving millions of web requests per day.</p>
<p>Database administration is available via pgAdmin, phpPgAdmin, among others. Importing and exporting data is provided by various converter tools (shp2pgsql, pgsql2shp, ogr2ogr, dxf2postgis). And there are numerous desktop and browser GIS clients for viewing PostGIS data.</p>
<a class="reference external image-reference" href="_images/pgadmin.gif"><img align="right" alt="project logo" class="align-right" src="_images/pgadmin.gif" style="width: 403.0px; height: 288.5px;" /></a>
<div class="section" id="core-features">
<h3>Core Features<a class="headerlink" href="#core-features" title="Permalink to this headline">¶</a></h3>
<ul class="simple">
<li>Hundreds of spatial functions<ul>
<li>Buffers, unions, overlays, distance and more</li>
</ul>
</li>
<li>ACID transactional integrity</li>
<li>R-Tree spatial index</li>
<li>Multi-user support</li>
<li>Row-level locking</li>
<li>Replication</li>
<li>Partitioning</li>
<li>Role-based security</li>
<li>Table-spaces, schemas</li>
</ul>
</div>
<div class="section" id="implemented-standards">
<h3>Implemented Standards<a class="headerlink" href="#implemented-standards" title="Permalink to this headline">¶</a></h3>
<ul class="simple">
<li>OGC standards compliant (SFSQL)</li>
</ul>
</div>
<div class="section" id="details">
<h3>Details<a class="headerlink" href="#details" title="Permalink to this headline">¶</a></h3>
<p><strong>Website:</strong> <a class="reference external" href="http://postgis.refractions.net/">http://postgis.refractions.net/</a></p>
<p><strong>Licence:</strong> GNU General Public License (GPL) version 2</p>
<p><strong>Software Version:</strong> 1.5</p>
<p><strong>Supported Platforms:</strong> Windows, Linux, Mac</p>
<p><strong>API Interfaces:</strong> SQL</p>
<p><strong>Support:</strong> <a class="reference external" href="http://www.osgeo.org/search_profile">http://www.osgeo.org/search_profile</a></p>
</div>
</div>
</div>
</div>
</div>
<div class="clearer"></div>
</div>
<div class="related">
<ul id="breadcrumbs">
<li class="right" style="margin-right: 10px">
<a href="genindex.html" title="General Index"
>index</a></li>
<li class="right" >
<a href="osgearth_overview.html" title="osgEarth"
>next</a> |</li>
<li class="right" >
<a href="overview.html" title="Welcome to OSGeo-Live"
>previous</a> |</li>
<li><a href="overview.html">OSGeo Live v4.0 documentation</a> »</li>
<li><a href="#">PostGIS</a></li>
</ul>
</div>
<div class="footer">
© Copyright 2010, OSGeo.
Last updated on Jul 28, 2010.
Created using <a href="http://sphinx.pocoo.org/">Sphinx</a> 0.6.4.
</div>
</body>
</html>