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

[Melpati, Muni]

The selected unique identifier column is GID (created by postgis). So, it has to be unique identifier.

Based on the fact that I could see selected feature attributes or I could see attributes using identifier tool,

I have to assume that query tool retrieves this information upon user action (in this case select a feature).



That is why I am wondering if I need to modify something like it was done with SDE Server config file to improve the performance of the query application. Thanks.





Message: 18

Date: Tue, 03 Jul 2012 17:50:55 +0200

From: William Humphrey Temperley <william.temperley at jrc.ec.europa.eu<mailto: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<mailto:postgis-users at postgis.refractions.net>>

Message-ID: <013c01cd5933$a1af3230$e50d9690$@jrc.ec.europa.eu<mailto:013c01cd5933$a1af3230$e50d9690$@jrc.ec.europa.eu>>

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



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>

[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<mailto: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.

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