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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Brooks, Stephen
Sent: Thursday, September 06, 2007 3:45 AM
To: pgsql-novice@postgresql.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
