I am trying to query SQL spatial data in Bentley Map SS3. I can connect to the database fine and see my features lists. When I zoom into an area and query the features, it always returns "Query Complete (0 features in x.xx seconds)". However, in map manager I can take that same feature and do a data browzer. I can click on any of the recods and do a locate on them and they magically appear in my map (the same location I was trying to query from). Why does it return 0 features, when obviously there are features there and I can connect to them?
Thanks
Jeremy
Jeremy,
When you apply an attribute filter of some type and use the "All" spatial filter (as opposed to "View"), are the expected feature instances returned? Would you be able to provide us with a Microsoft SQL Server .bak file containing some of your data for analysis? If so, please contact me offline after using these FTP posting instructions. Please include a copy of your seed design file as well.
Regards,
Jeff Bielefeld [Bentley]
It is somewhat working today. Friday I installed BM SS3 and was having the subjected trouble. Over the weekend my machine was rebooted and it appears to be working better today. The reboot is the only difference I know of. Anyhow, it only works when I switch the spatial filter to "All" (I had tried the "All" several times Friday as well).
So why is the spatial filter of "View" not working? It took nearly 5 minutes to load all roads. which is understandable, but would have taken just seconds if the spatial filter for "View" was working.
Most generally, when the view retrieval is not working, it means that the spatial index has not been set on the table , in the database. Try setting a spatial index on the tables. If this is functioning ESRI feature sets, then you need to proceed with caution, and make sure adding the spatial indexes does not mess with the ESRI users.
Yes, this is a ESRI feature class, but only one I created for testing. With that said, it does have a spatial index. I have deleted it and recreated the index in both ArcCatalog and in SQL server, but still no luck. Here is what the spatial index looks like.
CREATE SPATIAL INDEX [S78_idx] ON [dbo].[BMLAKES]
(
[Shape]
)USING GEOMETRY_GRID
WITH (
BOUNDING_BOX =(3810176.005626, 3345390.7158, 5932580.555428, 4287413.021384), GRIDS =(LEVEL_1 = MEDIUM,LEVEL_2 = MEDIUM,LEVEL_3 = MEDIUM,LEVEL_4 = MEDIUM),
CELLS_PER_OBJECT = 16, PAD_INDEX = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO
Is there a primary key on the table ? If so, can you send me a backup of that table, and I can take a look at it.
jerry.walter@bentley.com