Spatial View Not Displaying All Geometry

[WalterDziuba1]

Afternoon,

I've created a spatial view with ArcCatalog and have now added it as the data source to my project *.mxd

The view contains 149,400 records. lt's been constructed from one of our data sets and inner joined to three other tables from an external database. The view has a 1:M cardinality to the remaining external data.

When I attempt to update my map extent in ArcMap, not all of the geometry is being displayed. But only a small fraction of the points display correctly.

My Question : Why is the entire collection of points not being displayed?

Walter

[JoshuaBixby]

How do you know the view contains 149,400 records?  Are you getting that count from within ArcGIS, from a different SQL client, or somewhere else?  If within ArcGIS, does the table view show 149,000 records but you don't see or think all of those are being displayed on the map?

[WalterDziuba1]

Morning Joshua,

I can review the total number of records while in ArcCatalog > Preview > Table.

The view contains a 1:M cardinality, with one of our GIS data sets joined to three external database tables.

Yes, while in ArcMap, the attribute table lists the complete contents of the view, and I can see from the display that not all of the geometry is being displayed.

Walter

[JoshuaBixby]

Walter Dziuba wrote:

 the attribute table lists the complete contents of the view, and I can see from the display that not all of the geometry is being displayed.

Have you looked at or scrolled through all 149,000 records or are you relying on the record count being reported in the table?  How many records to you estimate are being displayed?  1,000; 10,000; 100,000?  What if you click the "Move to the end of the table" button when viewing the table, do more records display?

[WalterDziuba1]

I can open the attribute table and scroll to end of table, but no additional point data is being displayed. Out of the 1,837 data points I have in my GIS related table, approx only half of the point appear either while looking at the attribute table, or not.

Walter

[VinceAngelo]

Please clarify how the one-to-many cardinality is being manifested -- Does the feature class honor the absolute requirement that the objectid be unique?  If it doesn't, you're in the realm of undefined behavior, where literally anything can happen (including the creation of a black hole to swallow your server).

- V

[WalterDziuba1]

I'm using a pre-tested sql statement and am using ArcCatalog > New > View with the following statement that creates the joins in the view:

[VinceAngelo]

The purpose of the rowid column is to tie the geometries in the map canvas to the attributes in the table view (and vice-versa). If the rowid result set values are non-unique, all manner of strange results will occur.

In this context, you might be able to use a materialized view (called "indexed views" in SQL Server) to create a table with a unique ID (probably ought to preserve the source table IDs as well), or you can use relates and/or joins to teach ArcGIS the relationships between the tables (likely to be slower).

- V

[WalterDziuba1]

Now that I've realized that not all of my point data has connections to the spatial view that I am creating, therefore, not all the point geometry will show up. Great so far.

Thanks Vince... Was successful in populating a unique number in a new column in my spatial view and have added it to my SDE feature class. 

I've attempted to publish the map service, unfortunately, I get a 'SEVERE' error in ArcGIS server that states:

Error: DBMS table not found[42S02:[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'EDMS_GIS_Test_Deploy.xxxx\ARCGISDEV.GRWSPATIALRAD'.].

The spatial view attached in my .mxd document states that it's 

"EDMS_GIS_Test_Deploy.dbo.GRWSPATIALRAD

My Questions:

1. So where do these erroneous names come from?

2. How can the map publishing be successful after no errors were generated during the analyze phase?

Walter

[VinceAngelo]

Please explain how you went about

populating a unique number in a new column in my spatial view

If you used a row number in the view, this could cause random results (and undefined behavior).

- V