TransWikia.com

How to create spatially filtered versions in ArcSDE 10.1?

Geographic Information Systems Asked by vajram on July 17, 2021

I am using ArcSDE 10.1 and Oracle 11g,

I have a SDE user (parent), and two more users (ex: user1,user2) in my oracle database with required SDE permissions.
In my SDE db, i have a polygon FeatureClass (Ex: world) with a field called region (attribute values are North and South) and it is registered as versioned under sde.default.

And now i would like create, two child versions for sde.default (Ex: version1,version2) for user1 and user2 respectively and i would like to allow user1(version1) to view/edit the data related to a particular region(Ex:North), similarly for the user2(version2) to view/edit data related to the region south.

Is it possible to apply the above filter while creating versions in ArcSDE database?

One Answer

To allow users to view/edit data based on geographical regions, replication is there for you. You can replicate your data and assign each dataset to individual user. If replication is too complex for your scenario (@vince's comment), you can use a Definition Query with spatial predicates (e.g. st_intersect) to limit users from viewing and editing your data.

Correct answer by Farid Cheraghi on July 17, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP