File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes PostGIS and spatial database Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

PostGIS and spatial database

Connie Irwin

Joined: Aug 01, 2005
Posts: 8
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?


Connie Irwin
chris webster

Joined: Mar 01, 2009
Posts: 2289

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?)


No more Blub for me, thank you, Vicar.
I agree. Here's the link:
subject: PostGIS and spatial database
jQuery in Action, 3rd edition