SchemaMapper Use Case Example

Use Case

The attached workspace provides an example workspace showing thirteen different ways to use the SchemaMapper transformer.

The various uses of the SchemaMapper demonstrated in the workspace are:

Type 1: Simple feature type to feature type mappings (1:1)

Type 2: Feature type to feature type, where one feature maps to many features

1:M feature mapping based on a source attribute value

Type 3: Feature type to feature type ,where many features map to a single feature

M:1 feature mapping

Type 4: Attribute to attribute mapping

1:1 attribute mapping

Type 5: The same attribute (type) in different tables maps to different attributes in the destination feature type

Pole/type > pole_type    
Manhole/type > manhole_type
Multple entries per attribute, based on feature

Type 6: Attributes in a table map to the different attributes based on the value of the source attribute

Pole/type = 1 > pole_type = 1   
Pole/type = 2 > material = 2
Multiple entries per attribute, based on feature & value

Type 7: Attributes in a table map to the different attributes based on the value of the source attribute

Pole/type = 1 > pole_type = 1    
Pole/type = 2 > material = 2
Multiple entries per attribute, based on feature & value

Type 8: Feature & attribute mapping

Feature to feature mapping 1:1
Attribute to attribute mapping 1:1 i.e.
Pole/typeA  > pole_type     
Pole/typeB  > material

Type 9: Simple attribute value mapping (domain mapping). Requires a separate schemamapper for each domain (basically, the idea is that this could be a dynamic ValueMapper)

Type 10: Attribute value mapping

Attribute to attribute mapping 1:1
Value mapping 1:1
type X > A
type Y > B
material X > A
material Y > B

Type 11: Attribute value mapping - for multiple attributes across different feature types.

Attribute to attribute mapping 1:1
Value mapping 1:1
Pole type X > A
Pole type Y > B
Pole  material X > A
Pole  material Y > B
Manhole type u    >  1
Manhole  type v   >  2

Type 12: Attribute value mapping - for multiple attributes across different feature types.

Attribute to attribute mapping 1:1
Value mapping 1:1
Pole  type X > pole_type A
Pole  type Y > pole_type B
Pole  material X > material_type A
Pole  material Y > material_type B
Manhole type u > manhole_type 1
Manhole  type v > manhole_type  2

Type 13: Attribute value mapping - for multiple attributes across different feature types. attribute to attribute mapping 1:1 value mapping 1:1

Pole  type X > supportStructures pole_type A
Pole  type Y > supportStructures pole_type B
Pole  material X > supportStructures material_type A
Pole  material Y > supportStructures material_type B
Manhole type u > AccessPoint manhole_type 1
Manhole  type v > AccessPoint manhole_type  2