topic Re: How do you use stand alone tables? in ArcGIS JavaScript Maps SDK Questions

How do you use stand alone tables?

SteveCole — Fri, 28 Sep 2012 15:06:16 GMT

I'm looking for some guidance on how to proceed with a certain task I'd like to implement which would use a standalone table. My app works with Census data and so once the user clicks on a cenus tract, I'd like to load up some additional information (based on the census tract number) which is stored in a separate, stand alone table. That's what I want to do- now how do I do that?

After reviewing the API, I'm not sure how you "add" the table as a layer so that you can query it. The table will have a one to many relationship so I can't just join the table to my census tracts feature layer before serving it up as a service.

Thanks!
Steve

Re: How do you use stand alone tables?

Anonymous User — Mon, 01 Oct 2012 12:28:36 GMT

If your related table is accessible as a feature service, then you can add/update/delete records using applyEdits as you would with any other feature service layer.

Some of the apps published by the local government team do this. For example, take a look at Land Use Public Comment or Citizen Service Reqeust applications.

Re: How do you use stand alone tables?

JohnGravois — Mon, 01 Oct 2012 17:31:58 GMT

we also have a sample in the JS API Resource center for 1:M related table queries.

Query related records
http://help.arcgis.com/en/webapi/javascript/arcgis/help/jssamples/fl_query_related.html

Re: How do you use stand alone tables?

SteveCole — Mon, 01 Oct 2012 17:55:01 GMT

John/Mike,

Thanks for responding. My table is located in a FileGeoDatabase so I can certainly publish it via ArcGIS Server. How do I publish JUST the table in ArcGIS Server? I tried adding the table to a blank MXD and publishing the MXD but the table isn't listed in the published service.

Worst comes to worse, I could add the table into another existing map service and then access it through that service but I'd like to know how to publish a stand alone table.

Re: How do you use stand alone tables?

JohnGravois — Mon, 01 Oct 2012 17:59:21 GMT

these samples rely on the fact that you have set up the appropriate relationship between the feature class and related table in ArcGIS Desktop prior to publishing services.

http://resources.arcgis.com/en/help/main/10.1/index.html#/Creating_a_simple_relationship_class/004t00000007000000/

as you can see from this REST service endpoint used in the sample i mentioned previously, both the layer and table are published. this gives the feature layer the capability queryRelatedRecords

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/Petroleum/KSPetro/MapServer/0/queryRelatedRecords

Re: How do you use stand alone tables?

Anonymous User — Mon, 01 Oct 2012 20:14:06 GMT

John/Mike,

Thanks for responding. My table is located in a FileGeoDatabase so I can certainly publish it via ArcGIS Server. How do I publish JUST the table in ArcGIS Server? I tried adding the table to a blank MXD and publishing the MXD but the table isn't listed in the published service.

Worst comes to worse, I could add the table into another existing map service and then access it through that service but I'd like to know how to publish a stand alone table.

I have run into the same issue. I worked around it the same way you describe (by ensuring that the map that contained my non-spatial table also included at least one layer with spatial features). I don't know if there is an easy way around this currently, since you need to have layers in your data frame when publishing the map from ArcMap.

Re: How do you use stand alone tables?

SteveCole — Tue, 02 Oct 2012 13:57:42 GMT

I decided to re-publish my service with the standalone table tucked inside it. Just seems like the easiest way to do it.

Thanks again for the ideas!
Steve

Re: How do you use stand alone tables?

YueWu1 — Mon, 08 Dec 2014 16:22:14 GMT

Hi Steve,

I found this thread when I encountered the same issue.

There has been a NIM logged for the ability to publish a standalone table as a service: NIM084140 - Unable to share a map containing only a stand-alone table as service.

http://support.esri.com/en/bugs/nimbus/role/beta10_1/TklNMDg0MTQw

Like you said, the current workaround is publish map document with table and include an empty, unchecked feature class and then will be able to publish/query the table as REST.

Re: How do you use stand alone tables?

JohnPlunkett — Wed, 01 Apr 2015 03:41:15 GMT

I had a customer with a similar issue,

What I did to resolve this

Turn the nonspatial table into a Feature Class with a 'dummy' point

Publish the service with WFS enabled

Using the Interopablity Connection I managed to view the Attribute Table Successfully in the map.