How to build a dynamic test expression from values stored in attributes - FME Talk

The old Google Groups will be going away soon, but your browser is incompatible with the new version.
Message from discussion How to build a dynamic test expression from values stored in attributes
Received-SPF: pass (google.com: domain of johnnie...@gmail.com designates 209.85.160.53 as permitted sender) client-ip=209.85.160.53;
References: <47fd8a01-0143-406a-9846-9baab07f98a5@googlegroups.com> <A6A5F735-78B9-424E-8459-A0258D9C8...@gmail.com> <e7157bbf-b469-4f04-b011-aec7f7bc71b3@googlegroups.com>
In-Reply-To: <e7157bbf-b469-4f04-b011-aec7f7bc71b3@googlegroups.com>
Mime-Version: 1.0 (1.0)
Content-Type: multipart/alternative;
	boundary=Apple-Mail-7AD1D0D5-7FDE-4E82-A910-5626A8463A53
Message-Id: <72FCBB79-FCA3-45C9-94DE-0FB3D0B1D...@gmail.com>
Content-Transfer-Encoding: 7bit
Cc: "fmetalk@googlegroups.com" <fmetalk@googlegroups.com>
From: Johnnie GIS <johnnie...@gmail.com>
Subject: Re: [fme] How to build a dynamic test expression from values stored in attributes
Date: Mon, 30 Jul 2012 20:47:24 -0700
To: "fmetalk@googlegroups.com" <fmetalk@googlegroups.com>


--Apple-Mail-7AD1D0D5-7FDE-4E82-A910-5626A8463A53
Content-Transfer-Encoding: quoted-printable
Content-Type: text/plain;
	charset=us-ascii

Hey Mike
Just had another thought but don't know if you have access to the source dat=
abase.=20

If you can perhaps you could put the low and high values into the db and use=
 an AttributeRangeMapper. Might not need an 'operator' then.=20

My brain is kinda fried so not firing on all cylinders...

Regards,
Jonathon McIntyre
i-Open Technologies
Twitter: @JohnnieGIS
www.i-opentech.com
(C) 778-549-8382

Sent from my iPhone, please excuse any typos.

On Jul 30, 2012, at 7:54 PM, Mike Oberdries <oberdr...@gmail.com> wrote:

Hi Jonathon,
=20
I considered SchemaMapper, but to the best of my knowledge the filter mappin=
g does not let you specify an operator.
=20
Regards
Mike

On Tuesday, 31 July 2012 14:23:07 UTC+12, JohnnieGIS wrote:
Seems like a classic case for a SchemaMapper transformer...http://fmepedia.s=
afe.com/articles/Samples_and_Demos/Mapping-Schemas-using-SchemaMapper

Regards,
Jonathon McIntyre
i-Open Technologies
Twitter: @JohnnieGIS
www.i-opentech.com
(C) 778-549-8382

Sent from my iPhone, please excuse any typos.

On Jul 30, 2012, at 7:04 PM, Mike Oberdries <oberdr...@gmail.com> wrote:

I have collections of planning zone rules that allow me to filter parcel dat=
a.  Once I have tagged my parcel features with their respective zones I then=
 want to create the data filters as "TESTER like" expressions from values st=
ored in the parcel feature attributes.  Each parcel feature may be subject t=
o up to 5 separate rules and those individual rule expressions might be quit=
e different from one parcel feature to the next.
=20
Consider the following attributes:
=20
_attr_1 =3D parcel_area
_op_1 =3D >
_val_1 =3D 500
=20
_attr_2 =3D net_parcel_area
_op_2 =3D <
_val_2 =3D 250
=20
etc
=20
I would like to build an expression of the form @value(_attr_1) @value(_op_1=
) @value(_val_1) giving me "parcel_area > 500".
=20
I then want to pass that expression to a tester/query/filter type transforme=
r that can make sense of it.  My problem is that a transformer like a TESTER=
 requires that you select the operator from a dropdown list and syntacticall=
y other transformers do not seem to interpret the @value(_op_1) bit.
=20
I have played with the Tester, TestFilter, ExpressionEvaluator, FeatureReade=
r, InlineQuerier but without success.  Anyone have any thoughts?
=20
Thanks
Mike
--=20
Get all the FME resources you need at http://www.FMEpedia.com
Sign up to attend an FME World Tour event at http://www.safe.com/wt2012

You received this message because you are subscribed to the Google Groups "FM=
E Talk" group.

To post to this group, send email to fmetalk@googlegroups.com
To unsubscribe from this group, send email to fmetalk-unsubscribe@googlegrou=
ps.com
--=20
Get all the FME resources you need at http://www.FMEpedia.com
Sign up to attend an FME World Tour event at http://www.safe.com/wt2012

You received this message because you are subscribed to the Google Groups "FM=
E Talk" group.

To post to this group, send email to fmetalk@googlegroups.com
To unsubscribe from this group, send email to fmetalk-unsubscribe@googlegrou=
ps.com

--Apple-Mail-7AD1D0D5-7FDE-4E82-A910-5626A8463A53
Content-Transfer-Encoding: 7bit
Content-Type: text/html;
	charset=utf-8

<html><head></head><body bgcolor="#FFFFFF"><div>Hey Mike</div><div>Just had another thought but don't know if you have access to the source database.&nbsp;</div><div><br></div><div>If you can perhaps you could put the low and high values into the db and use an AttributeRangeMapper. Might not need an 'operator' then.&nbsp;</div><div><br></div><div>My brain is kinda fried so not firing on all cylinders...<br><br>Regards,<div>Jonathon McIntyre<div>i-Open Technologies</div><div>Twitter: @JohnnieGIS</div><div><a href="http://www.i-opentech.com">www.i-opentech.com</a></div><div>(C) 778-549-8382</div><div><br></div><div>Sent from my iPhone, please excuse any typos.</div></div></div><div><br>On Jul 30, 2012, at 7:54 PM, Mike Oberdries &lt;<a href="mailto:oberdr...@gmail.com">oberdr...@gmail.com</a>&gt; wrote:<br><br></div><div></div><div><div>Hi Jonathon,</div>
<div>&nbsp;</div>
<div>I considered SchemaMapper, but to the best of my knowledge the filter mapping does not let you specify an operator.</div>
<div>&nbsp;</div>
<div>Regards</div>
<div>Mike</div>
<div><br>On Tuesday, 31 July 2012 14:23:07 UTC+12, JohnnieGIS wrote:</div>
<blockquote style="BORDER-LEFT: #ccc 1px solid; MARGIN: 0px 0px 0px 0.8ex; PADDING-LEFT: 1ex" class="gmail_quote">
<div bgcolor="#FFFFFF">
<div>Seems like a classic case for a SchemaMapper transformer...<a href="http://fmepedia.safe.com/articles/Samples_and_Demos/Mapping-Schemas-using-SchemaMapper" target="_blank">http://fmepedia.<wbr>safe.com/articles/Samples_and_<wbr>Demos/Mapping-Schemas-using-<wbr>SchemaMapper</a><br><br>Regards, 
<div>Jonathon McIntyre 
<div>i-Open Technologies</div>
<div>Twitter: @JohnnieGIS</div>
<div><a href="http://www.i-opentech.com" target="_blank">www.i-opentech.com</a></div>
<div>(C) 778-549-8382</div>
<div><br></div>
<div>Sent from my iPhone, please excuse any typos.</div></div></div>
<div><br>On Jul 30, 2012, at 7:04 PM, Mike Oberdries &lt;<a href="mailto:oberdr...@gmail.com" target="_blank">oberdr...@gmail.com</a>&gt; wrote:<br><br></div>
<div></div>
<div>
<div>I have&nbsp;collections of planning zone rules that allow me to filter parcel data.&nbsp; Once I have tagged my parcel features with their respective zones I then want to create the data filters as "TESTER like" expressions from values stored in the parcel feature attributes.&nbsp; Each parcel feature may be subject to up to 5 separate rules and those individual rule expressions might be quite different from one parcel feature to the next.</div>
<div>&nbsp;</div>
<div>Consider the following attributes: </div>
<div>&nbsp;</div>
<div>_attr_1 = parcel_area</div>
<div>_op_1 = &gt;</div>
<div>_val_1 = 500</div>
<div>&nbsp;</div>
<div>_attr_2 = net_parcel_area</div>
<div>_op_2 = &lt;</div>
<div>_val_2 = 250</div>
<div>&nbsp;</div>
<div>etc</div>
<div>&nbsp;</div>
<div>I would like to build an expression of the form <strong>@value(_attr_1) @value(_op_1) @value(_val_1)</strong> giving me "parcel_area &gt; 500".</div>
<div>&nbsp;</div>
<div>I then want to pass that expression to a tester/query/filter type transformer that can make sense of it.&nbsp; My problem is that a transformer like a TESTER requires that you select the operator from a dropdown list and syntactically other&nbsp;transformers do&nbsp;not seem to interpret the @value(_op_1) bit.</div>
<div>&nbsp;</div>
<div>I have played with the Tester, TestFilter,&nbsp;<wbr>ExpressionEvaluator, FeatureReader, InlineQuerier but without success.&nbsp; Anyone have any thoughts?</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>Mike</div>
<p></p>-- <br>Get all the FME resources you need at <a href="http://www.FMEpedia.com" target="_blank">http://www.FMEpedia.com</a><br>Sign up to attend an FME World Tour event at <a href="http://www.safe.com/wt2012" target="_blank">http://www.safe.com/wt2012</a><br><br>You received this message because you are subscribed to the Google Groups "FME Talk" group.<br><br>To post to this group, send email to <a href="mailto:fmetalk@googlegroups.com" target="_blank">fmetalk@googlegroups.com</a><br>To unsubscribe from this group, send email to <a href="mailto:fmetalk-unsubscribe@googlegroups.com" target="_blank">fmetalk-unsubscribe@<wbr>googlegroups.com</a><br></div></div></blockquote>

<p></p>

-- <br>
Get all the FME resources you need at <a href="http://www.FMEpedia.com">http://www.FMEpedia.com</a><br>
Sign up to attend an FME World Tour event at <a href="http://www.safe.com/wt2012">http://www.safe.com/wt2012</a><br>
 <br>
You received this message because you are subscribed to the Google Groups "FME Talk" group.<br>
 <br>
To post to this group, send email to <a href="mailto:fmetalk@googlegroups.com">fmetalk@googlegroups.com</a><br>
To unsubscribe from this group, send email to <a href="mailto:fmetalk-unsubscribe@googlegroups.com">fmetalk-unsubscribe@googlegroups.com</a><br>
</div></body></html>
--Apple-Mail-7AD1D0D5-7FDE-4E82-A910-5626A8463A53--
Create a group - Google Groups - Google Home - Terms of Service - Privacy Policy
Account Options
