[postgis-users] Postgis and arcgis with data interoperability extension

[Andreas Neumann]

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" <georger.silva at gmail.com> 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 <rburhum at gmail.com>
>> wrote:
>>>
>>>> From: Thomas Jakubicka <crazyh at gmx.net>
>>>> Subject: [postgis-users] Postgis and arcgis with data interoperability
>>>>         extension
>>>> To: <postgis-users at postgis.refractions.net>
>>>> Message-ID: <C729D2DF.2936%crazyh at gmx.net
>>>> <mailto:C729D2DF.2936%25crazyh at gmx.net> >
>>>> 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
>>> postgis-users at postgis.refractions.net
>>> http://postgis.refractions.net/mailman/listinfo/postgis-users
>>>
>>
>>
>
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>


-- 
Andreas Neumann
http://www.carto.net/neumann/
http://www.svgopen.org/