[postgis-users] Problem with using query layer in ArcGIS 10

[William Humphrey Temperley]

I haven't seen this behaviour -- being able to see the attributes with
identify but not being able to use the attribute table properly.

 

Are you 100% certain the unique identifier column you have chosen is unique,
i.e. is it a primary key, or does it have a unique constraint on it?
Duplicate keys might cause this behaviour, but I'm not sure.

 

Will

 

From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Melpati,
Muni
Sent: 03 July 2012 17:28
To: postgis-users at postgis.refractions.net
Subject: [postgis-users] Problem with using query layer in ArcGIS 10

 

Hi William,

Thank you for response. It is great that you showed interest in helping me
on this. After playing with the query tool, it was very evident that I need
to pick one single unique identifier field. The problem I am facing happens
despite the fact that I selected one single field as unique identifier.  I
have two layers (one with 13,000 records and another with 55,600 records).
Smaller file works like any other shape file. The larger file would through
up loading data problem. 

 

Note: If I, either select a bunch features  or use identify tool, I could
see all the attributes. In other cases, though I could not see attributes, I
could see all the features on the map.

I could also use attribute query tool on the same data and select records
and  view them.  However, I simply having trouble with opening the table and
viewing all the records. 

Also I am unable to export to shapefile from ArcMap when this problem
occurs.

Thanks.

 

Message: 5

Date: Mon, 02 Jul 2012 13:41:33 +0200

From: William Humphrey Temperley <william.temperley at jrc.ec.europa.eu>

Subject: Re: [postgis-users] Problem with using query layer in ArcGIS

      10

To: "'PostGIS Users Discussion'"

      <postgis-users at postgis.refractions.net>

Message-ID: <032201cd5847$a1790e40$e46b2ac0$@jrc.ec.europa.eu>

Content-Type: text/plain; charset="us-ascii"

 

 

 

From: postgis-users-bounces at postgis.refractions.net

[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Melpati,
Muni

Sent: 28 June 2012 21:19

To: postgis-users at postgis.refractions.net

Subject: [postgis-users] Problem with using query layer in ArcGIS 10

 

 

 

Hi I was querying posgis layers from ArcGIS 10. I found that if add postgis
layer with huge number of records, I am having trouble with accessing its
attributes. When I try to open the table I get "Could not load data from the
data source. If you can correct the problem, press the refresh button to
reload data. Possible problems can include bad network connection, invalid
field, etc. The SQL statement was not a select statement. The operation is
not supported by this implementation."

 

 

 

I found similar problem somewhere in GIS forums where the user had to change
the MAXBLOBSIZE value to -1 (unlimited) in the SDE SERVER CONFIG FILE. Is
there similar fix to postgis/postgres? I appreciate your support.

 

Thanks.

 

 

 

 

 

 

 

By default ArcGIS uses all the fields in the query as the unique key.  Tools
such as identify labeling and the attribute table do not work when this is
the case. To make them work the primary key of the data source should be
used as the unique key. This also speeds up the loading of data. 

 

 

 

After writing a query, you need to click the Validate button and tick "Show
advanced options". The Next button will now be highlighted - click it.

Uncheck all fields in the Unique identifier fields list except the correct
primary key or unique field.  The attribute table should now work if you
provided a unique key.

 

 

 

HTH, 

 

 

 

Will Temperley

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20120703/a51907b3/attachment.html>