[Gdal-dev] Re: ArcGIS connection with PostGIS

[Tyler Mitchell]

Jan,
There has been some initial work on an extension done, in VB, by one 
group.  It has been updated by a few others, but provides a decent ability 
to extract data from PostGIS into an ArcMap layer and stores enough 
metadata to allow you to edit the file and post it back into PostGIS, 
replacing the table with the updated info. 

This project is called PgArc - located at: 
http://sourceforge.net/projects/pgarc/ or http://pgarc.sourceforge.net/
I can add you to the developers list if you want to continue discussions 
there.

A side group has been working on developing a PostgreSQL ole db connector 
which can serve as a basis for read and write connectivity directly with 
the database using, from what I understand, a more standard ArcMap 
component. 

The website for this project appears to be down, but you can find it on: 
http://gborg.postgresql.org/

I highly recommend building on this previous work or at least building on 
the Ole db connector work, rather than using ODBC.  If interested, this is 
worthy of more discussion on the pgarc mailing list or one that you may 
have for your project.  I am interested in helping coordinate bringing the 
two projects together.  Feel free to also contact my off list to discuss.

Tyler


gdal-dev-admin at remotesensing.org wrote on 04/29/2004 05:36:15 AM:

> Hello,
> 
> We are a company that is creating a GIS for geologic purposes using
> open-source software solutions. Currently we have a PostgreSQL database
> running with the PostGIS extension. In order to view and edit spatial 
data
> we use ArcGIS from ESRI.
> 
> It appears however that connecting to a PostGIS table with ArcGIS is 
quite
> difficult.
> 
> The current option for us is to develop a new extension to ArcGIS so 
that
> the PostGIS possibilities become available, but this is a daunting task 
so
> we would like to check beforehand if some efforts have been made 
recently on
> this issue appearing regularly on several opensource GIS forums. It is 
most
> likely that we are going to use Delphi as primary development language 
and
> where needed we will use Visual C++. For PostgreSQL connectivity we are
> probably going to use ODBC or native Delphi components in combination 
with
> the GDAL library of Frank Warmerdam. If there is somebody here that is 
also
> working on such a project it might be interesting to get in contact and
> discuss the development process. For everybody who is also interested in
> such an application, please contact us so that we can see if we can meet
> your needs too.
> 
> Greetings,
> 
> Jan Boonen
> Zoutewelle Media Groep b.v
> Department of software development
> The Netherlands
> E-mail: janb at zmg.nl
> 
> _______________________________________________
> Gdal-dev mailing list
> Gdal-dev at remotesensing.org
> http://remotesensing.org/mailman/listinfo/gdal-dev