topic Re: Stand alone table with geometry in ArcGIS REST APIs and Services Questions

Stand alone table with geometry

LarryMathys — Tue, 25 Jan 2011 20:13:00 GMT

I'm hoping someone can help...

Currently, I have successfully setup and published a stand alone table with custom parcel data on my REST endpoint. So, our ArcGIS 10 REST endpoint currently has one published map layer with parcel data including shapes & property ids, and a second published stand alone table (I mentioned above) that contains custom property information for multiple years. I'd like to be able to query the stand alone table and include the shape data from the parcel data layer.

I can query the data in the stand alone table using property IDs for a given year and get back results. However, I'd like to be able to set the geometry of a query to the REST endpoint of my custom table like I can on a map layer. I've tried joining the map parcel layer with the custom table in ArcMap 10; creating a view on the database that joins the parcel/shape layer with our custom data table; but any queries I've tried on the REST endpoint of the stand alone table always return with an error.

Is there a way to include the shape/envelope information with a stand alone table so I can just query one layer with the current geometry?

Re: Stand alone table with geometry

LarryMathys — Fri, 28 Jan 2011 19:46:27 GMT

I've essentially given up. I was able to join the standalone table with a parcel layer in the map, but as soon as I assign the current geometry of the FeatureLayer to a query, and then execute that query on the standalone table, the server crashes:

ERROR: Container process 1936 has crashed on machine <MACHINENAME>. CODE: 1017

Can a standalone table be joined to a map layer and then query that table with the current map geometry? I need to retrieve year specific data from the standalone table for each of the parcels that are currently displayed on the map.

Re: Stand alone table with geometry

RaviNarayanan — Sun, 30 Jan 2011 20:33:19 GMT

Larry,

have you explored the possibility of using relationship instead of a join table? Please see below a couple of help documents on this topic:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_between_relationship_classes_joins_and_relates/004t00000002000000/

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000002n000000.htm

ArcGIS Server supports querying of related records.

Ravi

Re: Stand alone table with geometry

LarryMathys — Mon, 31 Jan 2011 19:55:40 GMT

Larry,

have you explored the possibility of using relationship instead of a join table? Please see below a couple of help documents on this topic:

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#/Deciding_between_relationship_classes_joins_and_relates/004t00000002000000/

http://help.arcgis.com/en/arcgisdesktop/10.0/help/index.html#//005s0000002n000000.htm

ArcGIS Server supports querying of related records.

Ravi

Yes, I've looked at this. However, this option doesn't seem to fit since I need to be able to query several properties at once. In other words, I need to be able to query those properties based on the current geometry.

The parcel layer returns updates to the map when the extent changes. I'd like to be able to include my custom data with the parcel layer data when the extent changes.

Re: Stand alone table with geometry

RaviNarayanan — Tue, 01 Feb 2011 17:42:15 GMT

However, this option doesn't seem to fit since I need to be able to query several properties at once. In other words, I need to be able to query those properties based on the current geometry.

Larry,
One suggestion is that you can query this parcel layer based on the geometry and fetch the OBJECTIDs of the features in the parcel layer. Those OIDs can then be used to query the related records in the table using the relationship between parcels and the table.

For example, here is a query on a parcels layer to return the OIDS that match the query constraints. The objectIDs can then be used to get the recrods from the table related to parcels layer.

http://sampleserver3.arcgisonline.com/ArcGIS/rest/services/BloomfieldHillsMichigan/Parcels/MapServer/2/query?text=&geometry=%7B%22xmin%22%3A13408524.0370735%2C%22ymin%22%3A386337.472112864%2C%22xmax%22%3A13409724.6978346%2C%22ymax%22%3A387600.530183733%7D&geometryType=esriGeometryEnvelope&inSR=&spatialRel=esriSpatialRelIntersects&relationParam=&objectIds=&where=&time=&returnIdsOnly=true&returnGeometry=true&maxAllowableOffset=&outSR=&outFields=&f=html

Query related records will return records from the table that are related to each Parcel OID.

http://help.arcgis.com/en/arcgisserver/10.0/apis/rest/queryrelatedrecords.html
Ravi