[GIS] Create a One-to-Many Spatial View with ArcGIS 10.1

arcgis-10.1arcgis-serverenterprise-geodatabase

We have two datasets: parcels and owners. This is a many-to-many relationship, where a parcel can have multiple owners and there may be multiple properties on a single parcel (also with multiple owners: condos or strata property)

We would like to publish this data to ArcGIS Server, and issue queries on it, so that we can get a single result for a single condo owner. Currently, when mapping the condo owners back to the parcel, we get all other condo owners, which gets confusing if the result was obtained by a text search.

In ArcGIS 10 and earlier, it's possible to create a spatial view that generates a unique Object ID field for repeated geometries. This lets us publish a parcels layer with stacked parcels for owners.

Is this possible with ArcGIS 10.1? The online documentation implies that ObjectID and Geometry must be obtained from the same feature class in a spatial view.

The underlying database is SQL Server. We do not want to convert the data storage type.

Best Answer

This problem often comes up when doing animations. I suggest trying either the Make Query Layer or Make Query Table tools.

Related Solutions

[GIS] One-to-Many table relate viewed through ArcGIS Server

Regarding your question about identify: no, an identify wouldn't bring back the related records.

But you're in luck since you're using 10. You can now query via relationship classes through REST. You could use a RelationshipQuery to find your related records. Here's a JS API sample showing how this works: Query related records

[GIS] Not able to register spatial view with sde

Without more information it's difficult to be positive, but the likely cause of your "invalid entity" error is an invalid entity (the geometry scan on the view found a nil or multi-part polygon when your -e parameter only allowed for single-part polygons).

The safest way to create views is to look at the properties of the feature class on which the view is based, and copy them to the sdelayer -o register command. Among the key properties that you didn't copy would have been the supported entities (likely "na+") and the coordinate reference parameter(s).

There are two ways to specify a coordinate reference, by using the -x, -P, and -G (and possibly -z or -m, if they're non-default), or by using the -R for the SRID of the source table for the view. If there are no registered tables with an appropriate existing COORDREF, then you'd need to run the -x/-P/-G/-z/-m gauntlet, the parameters for which are described in the Esri Understanding Coordinate Management in the Geodatabase whitepaper, but for WGS1984 data at ~1cm precsion would look like "-P HIGH -G 4326 -x -400,-400,10000000" .

You should also always explicitly name the registered rowid column and the fact that it is USER-set (in this case, with -C OBJECTID,USER). You should also verify that the rowid column does in fact represent a unique value after joins are applied (many-to-one is only permitted if a unique id off the "many" side is used for rowid).

In summary, I think your registration command should have looked like:

sdelayer -o register -l pipeline_test,SHAPE -e na+ -k Geometry -t Geometry ^
    -C OBJECTID,USER -R *N* -i sde:SQLSERVER:GISDATA -D pipelines -u gis -p ***

Best Answer

Related Solutions

[GIS] One-to-Many table relate viewed through ArcGIS Server

[GIS] Not able to register spatial view with sde

Related Question