Offline non-spatial tables

2786
7
Jump to solution
05-28-2014 03:53 PM
mikedavis2
New Contributor II
Really need to be able to see and query the non-spatial tables in a .geodatabase file.  Is this on the radar soon? 

-Mike
0 Kudos
1 Solution

Accepted Solutions
DiveshGoyal
Esri Regular Contributor
This appears to be a bug in ArcMap.
We've taken note of it and hope to fix it in a future release. Thanks for reporting.

View solution in original post

0 Kudos
7 Replies
DiveshGoyal
Esri Regular Contributor
Non-spatial tables in the geodatabase are already supported.
You won't be able to visualize them on a map through a layer (after all, they have no geometry), but you should be able to query & edit.
0 Kudos
MattCooper
Occasional Contributor
What class would we want to look at for querying/listing/etc the non-spatial tables? featureTableForLayerName in the AGSGDBGeodatabase works just fine on spatial datasets but not our non-sptial tables.  Is there somewhere else we should be looking.  I haven't seen anything in the documentation aside from the AGSGDBFeatureTable that references "non-geographic" datasets.

Any pointers would be appreciated.

Thanks!
Matt
0 Kudos
DiveshGoyal
Esri Regular Contributor
You should be able to use featureTableForLayerName to retrieve non-spatial tables from the geodatabase. These would be returned just like the spatial tables as AGSGDBFeatureTable objects. There is no difference in querying spatial or non-spatial tables. You use the same class and the same methods, the only difference being that the results (AGSGDBFeature objects) won't have a geometry for non-spatial tables.

Where did you create the geodatabase from? ArcMap or from a feature service?
0 Kudos
MattCooper
Occasional Contributor
We generated it from ArcMap.  Can you only access non-spatial tables when they are generated from a feature service? 

Thanks for getting back to us!
Matt
0 Kudos
DiveshGoyal
Esri Regular Contributor
Per this document (http://resources.arcgis.com/en/help/main/10.2/index.html#//00660000045q000000), tabular data is supported in ArcMap too for creating runtime content. I haven't tried this myself yet though.

What version of ArcMap are you using?
0 Kudos
MattCooper
Occasional Contributor
We're using Desktop 10.2.2 to generate the .geodatabase.  It does indeed bundle the non-spatial tables.  The problem is that the featureTableForLayerName method does not find it and the featureTables method doesn't return it in the array of tables within the AGSGDBGeodatabase.  Both of those methods only return the spatial tables.

Matt
0 Kudos
DiveshGoyal
Esri Regular Contributor
This appears to be a bug in ArcMap.
We've taken note of it and hope to fix it in a future release. Thanks for reporting.
0 Kudos