Re: Storing GI Data in Postgres

Hi Stephen,

I am not sure if this is the information you are looking for but ESRI is
in the process of developing their ArcSDE technology for PostgreSQL. If
you are familiar with the ESRI suite of software, ArcSDE is the spatial
database engine which allows for storing vector and raster data along
with their relationships in an rdbms - i.e a geodatabase.

So far all of the rdbms' were commercial ( Informix, db2, oracle and sql
server) but around the early part of 2008 postgresql will be added to
the list. The spatial type that postgres will utilize will allow for non
ESRI applications like MapInfo or AutoCAD to interact with the data on
the sql level. Meaning, that you will be able to query the vertices that
make up the geometry along with attributes through sql functions
provided for consumption by non ESRI products, but the geodatabase
relationships, along with visualization of the data will be available
through ArcGIS clients.

I did not mean to sound like a marketing spiel, I have been working on
this project for a while now and if you have any other questions please
let me know.

Sincerely,

Kasia Tuszynska

ArcSDE Product Engineer

ESRI

________________________________

From: pgsql-novice-owner(at)postgresql(dot)org
[mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Brooks, Stephen
Sent: Thursday, September 06, 2007 3:45 AM
To: pgsql-novice(at)postgresql(dot)org
Subject: [NOVICE] Storing GI Data in Postgres

Hi all,

I am relatively new to this mailing list and to the concept of
Geodatabases.

We are looking to implement a single geodatabase as the main storage for
all of our GI data. We would like to access this data from MapInfo and
ArcGIS and potentially AutoCAD.

Does anyone have any experience of using Postgres to serve this purpose?

Regards

Stephen