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

Abe Gillespie abe.gillespie at gmail.com
Fri Jul 29 15:16:40 PDT 2005


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



More information about the postgis-users mailing list