Hi,

 

 

I have 15-20 feature types that have values of the same type and they can be repetitive (e.g. FeatureType1: 1, 2, 3, 5, 4; FeatureType2: 1, 6, 8, 3, 5 and so on). These features are tables from SQL Server with relationships (because of that there are repeating values). I need to change all values of certain (different) attributes in all features to some other set (number sequence that starts from specific number). So, all primary and foreign keys from ex tables need to be mapped to some range. Confusing, I know, but I will try with example too.

 

 

Some example of data:

 

Parcel1: oid=224

 

Parcel2: oid=266

 

Parcel3: oid=214

 

Building1: oid=844, parcel=224

 

Building2: oid=415, parcel=266

 

Building3: oid=332, parcel=214

 

Building4: oid=711, parcel=214

 

 

Here I need to get parcel oids (e.g.) 21-23, building oids 24-27 and building parcels 21-23, respective to original attributes. New values could start from any number (set as parameter) and there must not be any skippings. It doesn't need to be ordered, but must be continuous. All features have oid and some of them has foreign keys to oids of another feature/

 

What is the simpliest way for doing this, no matter how much complicated it is?

AttributeValueMapper uses static mapping, but I need to use dynamic. Maybe I can extract all interesting fields to some file from SQL Server, but I'm not sure.

Any suggestions for solving this problem will be appreciated.

 

 

Greetings,

 

Aleksandar