Hi Thomas, did you have a look at ziggis? It enables data connection and editing of native Postgis geometries without the need for ArcSDE.
It is commercial, but much cheaper than SDE: http://pub.obtusesoft.com/ I don't have ESRI myself, so I don't have experience with it, but it is definitely worth a try. Andreas On Thu, November 19, 2009 10:19 am, Thomas wrote: > > Ok thanks for the OLE DB info. > I am still new to working with databases so maybe I am wrong, but ESRI > told > me that I can use ArcSDE only with the Server Version that I until now don > t > have. But still it should be possible to connect through the Data > Interoperability Extension. > The strange thing is that it works with polygons but not with point > geometry > > Thanks for your ideas > > thomas > > > On 18.11.09 22:51, "George Silva" <[email protected]> wrote: > >> This is very weird. Very weird. I have experience with Esri SDE and if >> you are >> working with OGC standarts everything should work fine. >> >> Did you registered all your tables trough ArcSDE? If not, you need to do >> it. >> >> OLE Connections will only let you handle tabular information, so let >> that go. >> It's not the way. >> >> AFAIK ESRI implements OGC standarts. You should NOT have problems with >> point >> geometry. >> >> Att >> >> George >> >> On Wed, Nov 18, 2009 at 6:39 PM, Ragi Y. Burhum <[email protected]> >> wrote: >>> >>>> From: Thomas Jakubicka <[email protected]> >>>> Subject: [postgis-users] Postgis and arcgis with data interoperability >>>> extension >>>> To: <[email protected]> >>>> Message-ID: <c729d2df.2936%[email protected] >>>> <mailto:c729d2df.2936%[email protected]> > >>>> Content-Type: text/plain; charset="US-ASCII" >>>> >>>> >>>> Hello, >>>> >>>> I am trying to access my postgis/postgreSQL database through the >>>> datainteroperability extension and have problems with all my point >>>> data. I >>>> can load and export polygons but no points. The connection to the >>>> database >>>> works fine but when i try to load point data the attribute table is >>>> empty >>>> and only the header row is shown >>> >>> That seems bizarre. FYI, ESRI provides their own implementation of a >>> Geometry >>> type on PostgreSQL. You can also use PostGIS. My "psychic debugging" >>> skills >>> tell me there is a chance you may be mixing the two? >>> >>> Also, did you load the PostGIS functions as described in the >>> documentation >>> for the database you are working with *before* loading the data? >>> >>>> >>>> I also tried to access the database through an OLE DB connection witch >>>> is >>>> working so far that I get access to all tables stored in the database >>>> but >>>> still can not show the spatial information. With this connection all >>>> datasets are shown with the table-symbol and the geometry field stays >>>> empty. >>> >>> This is how the ESRI OLE DB provider works - it doesn't load and >>> spatial >>> information. Anything you load from there will be "just a table" >>> >>>> We are using the Postgis/PostgreSQL version 8.3 and ArcEditor 9.3.1 >>>> >>>> Thanks for your help >>>> >>> >>> The best thing I could recommend to you now is to do some logging from >>> the >>> PostgreSQL side of things. See what SQL is being executed during the >>> load and >>> it should show you your problem right away. >>> >>> Hope this helps, >>> >>> - Ragi >>> >>> _______________________________________________ >>> postgis-users mailing list >>> [email protected] >>> http://postgis.refractions.net/mailman/listinfo/postgis-users >>> >> >> > > _______________________________________________ > postgis-users mailing list > [email protected] > http://postgis.refractions.net/mailman/listinfo/postgis-users > -- Andreas Neumann http://www.carto.net/neumann/ http://www.svgopen.org/ _______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
