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@...
_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users

[Abe Gillespie]

I'm sure others know better, but it is my understanding that if you're
using 1.0+ of PostGIS you won't be able to use the Data
Interoperability extensions.  I think there were breaking changes in
1.0+.

-Abe

On 7/29/05, Marco Vieira <marco_vieira@...> wrote:

> 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@...
> _______________________________________________
> postgis-users mailing list
> postgis-users@...
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>

_______________________________________________
postgis-users mailing list
postgis-users@...
http://postgis.refractions.net/mailman/listinfo/postgis-users