nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Find more posts tagged with

Accepted answers

All comments

VinceAngelo

No one can answer this without information on the cardinality of the relationships between TX_COUNTY_PARKS and TX_COUNTY_PARK_FEATURES and TX_COUNTY_PARKS with TX_COUNTY_PARK_TRAILS. If either is one-to-many, you cannot use TX_COUNTY_PARKS.OBJECTID as a rowid.

- V

IreneEgbulefu2

Hi Vince, Please how do I go about inserting this rowID because I'm having exactly the same issue here but imj yet to try including the rowid that would help tie the geometry

"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)"

I strongly believe this could be the answer to my issue unfortunately, I dont know where to fix in the rowid

This is what my SQL query looks like.

CREATE VIEW PARKVIEW AS

SELECT TC_User.TX_COUNTY_PARKS.ParkID, TC_User.TX_COUNTY_PARKS.Name, TC_User.TX_COUNTY_PARKS.Park_Acres,
                 TC_User.TX_COUNTY_PARKS.YearOpen, TC_User.TX_COUNTY_PARKS.ParkStatus, TC_User.TX_COUNTY_PARKS.StatusCmnt,
                  TC_User.TX_COUNTY_PARKS.ParkType, TC_User.TX_COUNTY_PARKS.Shape, TC_User.TX_COUNTY_PARK_FEATURES.FEATURE_NAME,
                  TC_User.TX_COUNTY_PARK_FEATURES.FEATURE_TYPE, TC_User.TX_COUNTY_PARK_FEATURES.FEATURE_LABEL,
                  TC_User.TX_COUNTY_PARK_FEATURES.GIS_Acres, TC_User.TX_COUNTY_PARK_FEATURES.Shape AS Expr1,
                  TC_User.TX_COUNTY_PARK_FEATURES.GIS_SqFt, TC_User.TX_COUNTY_PARK_TRAILS.LENGTH, TC_User.TX_COUNTY_PARK_TRAILS.WIDTH,
                  TC_User.TX_COUNTY_PARK_TRAILS.Trail_Name, TC_User.TX_COUNTY_PARK_TRAILS.Trail_Type,
                  TC_User.TX_COUNTY_PARK_TRAILS.Shape AS Expr2
FROM     TC_User.TX_COUNTY_PARKS INNER JOIN
                  TC_User.TX_COUNTY_PARK_FEATURES ON TC_User.TX_COUNTY_PARKS.OBJECTID = TC_User.TX_COUNTY_PARK_FEATURES.OBJECTID INNER JOIN
                           TC_User.TX_COUNTY_PARK_TRAILS ON TC_User.TX_COUNTY_PARKS.OBJECTID = TC_User.TX_COUNTY_PARK_TRAILS.OBJECTID

VinceAngelo

Best practice is to avoid ever registering a connection with the 'sde' USER. The 'sde' user should only be used for instance administration, not for table creation, and certainly not for web-based table access.

- V

VinceAngelo

Without the SQL it's hard to be positive, but I can't imagine how that wouldn't have the same issue as a row number. The value must be organic to the table/view, so that a query by ID returns the same row it did on a previous query. This is why a row number doesn't work, since row 5 returned with a WHERE clause of "color = 'RED'" might return a row with "color = 'BLUE'" when queried by ID.

WalterDziuba1

I created a stand alone table and populated the table with 200,000 auto incremental numbers.

From there, I used this table as a temporary table in my next script and used those number and then assigned them to be a value in my spatial view with the column name "AutoID'

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

WalterDziuba1

Checked the "Data Store" on the server and have validated all registered connections. Also, reviewed database connection properties with the database name being correct, USER = sde and version=dbo.DEFAULT.

Walter

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.xyz\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

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

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

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 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

bixb0012

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

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

bixb0012

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?

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.