Take the 2-minute tour ×
Geographic Information Systems Stack Exchange is a question and answer site for cartographers, geographers and GIS professionals. It's 100% free, no registration required.

I'm running a PostgreSQL database on my local machine and have set up an connection to it from ArcMap 10.1. I can see all of my tables in the Catalog pane. There is one table that I cannot seem to load into ArcMap. When I drag it onto the map I get the error "Error Opening Feature Class, Attribute Column Not Found"

enter image description here

Other feature classes in the same database load without incident. The feature class is a relatively (~40 rows) small with point geometry. It loads without any problems in QGIS. Also, I can load the feature class from a query layer using SELECT * FROM [Feature Class].

So what's going on with ArcMap that I can't just load the FC straight in like I can with the other FCs in the database?

I'm running ArcMap 10.1, on a Windows 7 machine, with NO instance of ArcServer, PostgreSQL is running locally. I have the Postgres client files installed.

Thanks!

---------- EDIT ----------

The table has 14 columns: enter image description here

The spatial reference is 32613 (WGS 84 NAD 83 Zone 13N) and the permissions are no different than others in the database. Typically, I just drag the tables in from the Catalog pane to load them into ArcMap - perhaps Arc is building a query layer in the background, I don't know. However, when I do the drag-and-drop with this error it won't load. When I create a query layer using the "Add Query Layer..." dialog from the File menu it at least loads the points, however, I can't do any kind of selecting and the attribute table is empty.

An example of the columns for a table that I can simply drag-and-drop: enter image description here

share|improve this question
1  
I think in order to troubleshoot this, we need more information about this table. It really isn't a featureclass until it is in ArcMap, but that is semantics. What attributes does it have? Spatial reference? What is different compared to the other spatial tables that load in correctly? Are permissions different somehow? Basically, you need to provide these sorts of comparisons to figure out what is causing the behavior. A last bit... Since it is a table from PostgreSQL, isn't a Query Layer the default way of loading a spatial table in, when not using ArcServer, SDE or the like? –  Get Spatial Sep 30 '13 at 16:45
    
Thank you for adding that information. For comparison purposes, would you add the same sort of screenshot, but for a layer that you are able to just drag and drop in with no difficulties? –  Get Spatial Sep 30 '13 at 17:56
add comment

1 Answer

I had the same issue going from SQLServer2012 to ArcMap. The fix I found was to remove a space in one of the column names.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.