Cannot view postgis data in ArcGIS when using the data interoperability extension

SindileBidla — Mon, 13 Jun 2011 06:37:41 GMT

I am unable to view postgis data when using the data interoperability
extension.
Using:
ArcGIS Desktop 10 Service Pack 2 Build 3200
Data Interoperability Extension Build 6233
This is the error message I get:
Error executing SQL query ('SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_proposed"'): 'ERROR: function box3d(box3d_extent) is
not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_propos...
               ^
HINT: Could not choose a best candidate function. You might need to
add explicit type casts.
Below is the complete log:
2011-05-31 16:55:26|   0.1| 0.0|INFORM|Data Interoperability
(20101013 - Build 6233 - WIN32)
2011-05-31 16:55:26|   0.1| 0.0|INFORM|Feature Manipulation Engine
2010 SP3 (ESRI DESKTOP) (Build 6233)
2011-05-31 16:56:38| 10.7| 10.6|INFORM|Loaded module 'POSTGIS' from
file 'C:\Program Files (x86)\ESRI\Data Interoperability Extension
\plugins/postgis/POSTGIS.dll'
2011-05-31 16:56:38| 10.7| 0.0|INFORM|FME API version of module
'POSTGIS' matches current internal version (3.6 20090807)
2011-05-31 16:56:38| 10.7| 0.0|INFORM|Opening POSTGIS reader for
dataset 'geodb'
2011-05-31 16:56:43| 12.0| 1.3|INFORM|PostgreSQL 8.4.8 on x86_64-pc-
linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4)
4.5.2, 64-bit
2011-05-31 16:56:43| 12.0| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:45| 12.0| 0.0|INFORM|PostGIS client encoding:
'LATIN1'
2011-05-31 16:56:45| 12.0| 0.0|INFORM|Using Dynamic Reader
$Revision: 62876 $ ( $Date: 2009-08-27 11:28:55 -0700 (Thu, 27 Aug
2009) $ ) with module POSTGIS to read data from dataset `geodb'
2011-05-31 16:56:48| 12.0| 0.0|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:56:51| 13.3| 1.3|INFORM|FME Configuration: Source
coordinate system for reader R_1[POSTGIS] set to `EPSG:4326' as read
from input data
2011-05-31 16:56:54| 15.5| 2.2|INFORM|Coordinate System `EPSG:4326'
parameters: CS_NAME=`LL84' DESC_NM=`WGS84 datum, Latitude-Longitude;
Degrees' DT_NAME=`WGS84' EPSG=`4326' GROUP=`LL' MAP_SCL=`1' PROJ=`LL'
QUAD=`1' SCL_RED=`1' SOURCE=`Mentor Software' UNIT=`DEGREE'
2011-05-31 16:56:54| 15.5| 0.0|INFORM|Coordinate System `EPSG:4326'
as OGC Well Known Text: GEOGCS["WGS84 datum, Latitude-Longitude;
Degrees",DATUM["WGS_1984",SPHEROID["World Geodetic System of 1984, GEM
10C",
6378137,298.257223563,AUTHORITY["EPSG","7030"]],AUTHORITY["EPSG","6326"]],P RIMEM["Greenwich",
0],UNIT["degree",0.0174532925199433],AUTHORITY["EPSG","4326"]]
2011-05-31 16:56:54| 15.6| 0.1|INFORM|FME API version of module
'POSTGIS' matches current internal version (3.6 20090807)
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Opening POSTGIS reader for
dataset 'geodb'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostgreSQL 8.4.8 on x86_64-pc-
linux-gnu, compiled by GCC gcc-4.5.real (Ubuntu/Linaro 4.5.2-8ubuntu4)
4.5.2, 64-bit
2011-05-31 16:56:54| 15.6| 0.0|INFORM|1.5 USE_GEOS=1 USE_PROJ=1
USE_STATS=1
2011-05-31 16:56:54| 15.6| 0.0|INFORM|PostGIS client encoding:
'LATIN1'
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Successfully closed POSTGIS
database reader
2011-05-31 16:56:54| 15.6| 0.0|INFORM|Merged 1 schema features read
from 1 datasets into 1 resulting feature types
2011-05-31 16:57:04| 17.0| 1.3|ERROR |Error executing SQL query
('SELECT BOX3D(extent("the_geom")) FROM "mdb"."PROV2011_proposed"'):
'ERROR: function box3d(box3d_extent) is not unique
LINE 1: SELECT BOX3D(extent("the_geom")) FROM
"mdb"."PROV2011_propos...
               ^
HINT: Could not choose a best candidate function. You might need to
add explicit type casts.
'
2011-05-31 16:57:05| 17.2| 0.2|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:09| 20.2| 3.0|STATS |
POSTGIS::__CollectionTest(TestFactory): Tested 10 input feature(s) --
0 feature(s) passed and 10 feature(s) failed
2011-05-31 16:57:09| 20.2| 0.0|STATS |
POSTGIS::__DeaggCollections(DeaggregateFactory): Split 0 input
feature(s) into 0 point-in-polygon feature(s), 0 donut polygon(s), 0
polygon(s), 0 line(s), 0 point(s), and 0 aggregate(s)
2011-05-31 16:57:09| 20.2| 0.0|STATS |
POSTGIS::__AggregateHomo(AggregateFactory): Combined 0 input
feature(s) into 0 output feature(s), including 0 singleton(s)
2011-05-31 16:57:14| 20.6| 0.5|INFORM|Reading POSTGIS table:
'mdb.PROV2011_proposed'...
2011-05-31 16:57:51| 33.9| 13.2|INFORM|... Last line repeated 10
times ...
2011-05-31 16:57:51| 33.9| 0.0|INFORM|Loaded module 'fmeprompter'
from file 'fmeprompter.dll'

Re: Cannot view postgis data in ArcGIS when using the data interoperability extension

PaulNalos — Fri, 17 Jun 2011 22:36:42 GMT

Hi Bidla,

This is a known issue in Data Interoperability Extension 10.0, and is expected to be resolved at version 10.1.

The Data Interoperability Extension is based on FME (www.safe.com). One possible solution is to install FME 2011, which when configured to extend ArcGIS, acts like the Data Interoperability Extension. This issue (tracked by our PR 26972) has been resolved as of FME 2011 SP1. If you or others are interested in pursuing this option, feel free to contact me or support@safe.com.

I see you've posted this question to the PostGIS mailing list as well, and will reply in both places.

Regards,

Paul Nalos
Database Team Lead, Safe Software
paul.nalos@safe.com

Re: Cannot view postgis data in ArcGIS when using the data interoperability extension

KowchKoh — Thu, 25 Aug 2011 18:02:23 GMT

There are some other third party tools you can use to view spatial data in PostGIS. ZigGIS, and ST-Links PgMap are the most popular for PostGIS.

topic Cannot view postgis data in ArcGIS when using the data interoperability extension in Data Management Questions

Cannot view postgis data in ArcGIS when using the data interoperability extension

Re: Cannot view postgis data in ArcGIS when using the data interoperability extension

Re: Cannot view postgis data in ArcGIS when using the data interoperability extension