[postgis-users] ESRI Data Interoperability - ArcGIS + PostGIS

[Marco Vieira]

Hi list.
I'm trying the ESRI Data Interoperability extension with PostGIS and
ArcMAP hangs when load any spatial data from may PostGIS Database.

- Any map tried can be loaded sucessfuly with QGIS and MapServer.
- I followed the instructions about unique index creating on DI Help
- By example:
  I loaded this shapefile with shp2psql and added constrains and indexes
like this:

CREATE TABLE claro.cod_area
(
  gid serial NOT NULL,
  cod_area varchar,
  the_geom geometry,
  CONSTRAINT cod_area_pkey PRIMARY KEY (gid),
  CONSTRAINT enforce_dims_the_geom CHECK (ndims(the_geom) = 2),
  CONSTRAINT enforce_geotype_the_geom CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL),
  CONSTRAINT enforce_srid_the_geom CHECK (srid(the_geom) = 4291)
)
WITH OIDS;

  And with GRANT ALL for the user tested.

The table was vaccumed after.
The geometry_columns table shows OK.

I used:
-- Client:
  Windows XP SP1
  ArcMap 9.0 build 535 with permanent license
  Data Interoperability Extension (FME 2004 ICE) Build 1374 (20040919)  60
days Trial License

--Server:
PostgreSQL 8.0.3 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.3.5
(Debian 1:3.3.5-13)
PostGIS 1.0.0 USE_GEOS=1 USE_PROJ=1 USE_STATS=1
GEOS 2.1.1
Proj 4.4.9, 29 Oct 2004

 The DI log shows error when loading OID and WKB:

2005-07-29 18:22:10|   6.1|  0.0|INFORM|Feature Manipulation Engine
Version 2004 ICE (ESRI DESKTOP) (20040919 - Build 1374)
2005-07-29 18:22:10|   6.1|  0.0|INFORM|FME_HOME is 'D:\Program
Files\ArcGIS\Data Interoperability Extension\'.
2005-07-29 18:22:10|   6.1|  0.0|INFORM|Data Interoperability (20040919 -
Build 1374)
2005-07-29 18:22:10|   6.1|  0.0|INFORM|Feature Manipulation Engine
Version 2004 ICE (ESRI DESKTOP) (Build 1374)
2005-07-29 18:22:38|   6.5|  0.5|INFORM|Data Interoperability (20040919 -
Build 1374)
2005-07-29 18:22:38|   6.5|  0.0|INFORM|Feature Manipulation Engine
Version 2004 ICE (ESRI DESKTOP) (Build 1374)
2005-07-29 18:49:40|  13.3|  6.8|INFORM|Module `POSTGIS' uses FME Internal
API Version `3.1 20031010'
2005-07-29 18:49:40|  13.3|  0.0|INFORM|Opening POSTGIS reader for dataset
'testgis'.
2005-07-29 18:49:40|  13.3|  0.0|WARN  |Could not determine OID of
geometry from PostGIS database, assuming default '17244'.
2005-07-29 18:49:40|  13.3|  0.0|INFORM|Using Dynamic Reader $Revision:
14.0 $ ( $Date: 2003/11/07 23:23:05 $ ) with module POSTGIS to read data
from dataset `testgis'
2005-07-29 18:49:41|  13.3|  0.0|WARN  |Error in the OGR while importing
well known binary geometry.
2005-07-29 18:49:41|  13.3|  0.0|INFORM|Reading POSTGIS table: 'cod_area'...
2005-07-29 18:49:58|  13.4|  0.1|WARN  |Error in the OGR while importing
well known binary geometry.
2005-07-29 18:49:58|  13.5|  0.1|INFORM|Module `POSTGIS' uses FME Internal
API Version `3.1 20031010'
2005-07-29 18:49:58|  13.5|  0.0|INFORM|Opening POSTGIS reader for dataset
'testgis'.
2005-07-29 18:49:59|  13.6|  0.0|WARN  |Could not determine OID of
geometry from PostGIS database, assuming default '17244'.
2005-07-29 18:49:59|  13.6|  0.0|INFORM|Successfully closed POSTGIS
database reader.
2005-07-29 18:49:59|  13.6|  0.0|INFORM|Merged 1 schema features read from
1 datasets into 1 resulting feature types.


Have anyone had this problem before?


Marco Vieira.
Fone:    + 55 21 9499-6800
marco_vieira at uk2.net