Win a copy of Think Java: How to Think Like a Computer Scientist this week in the Java in General forum!
    Bookmark Topic Watch Topic
  • New Topic

PostGIS and spatial database

 
Connie Irwin
Greenhorn
Posts: 8
  • Mark post as helpful
  • send pies
  • Report post to moderator
So, does postGIS have it's own sql engine, or does it utilize the postgres sql. Can the two datatypes, the geometric and geographic be extended in the same fashion that a java class can be subclassed?

Thank-you

Connie Irwin
 
chris webster
Bartender
Posts: 2407
32
Linux Oracle Postgres Database Python Scala
  • Mark post as helpful
  • send pies
  • Report post to moderator
Hi Connie,

Already replied to your other post, but just in case it helps:

* PostGIS builds upon the existing geometric data types in PostgreSQL.
* PostGIS also extends the existing indexing mechanisms in PostgreSQL to support indexing of spatial data, which obeys different rules from scalar data.
* PostGIS provides a set of additional spatial functions that can be used within SQL (and PGPLSQL) code, but the underlying SQL engine is provided by PostgreSQL itself.

Hope this helps a bit.

(And where are the PostGIs authors anyway?)

Chris
 
    Bookmark Topic Watch Topic
  • New Topic