Skip to main content
  • EN

Hi there,

I'm a bit helpless after trying the hole day. Well, what is my problem. Let me try to describe it.

I have a huge amount of adresses, consisting of postcode, town, district, street, hous no, coordinates etc. I concatenated all to a adress-string. Saved in a Geodatabase.

Now I'm trying to geocode some adresses, by comparing with the adress-strings in the database. This is not the problem, i can do this but it takes a long long time.

Now, my idea was to send every single adress with the workspacerunner to a new workbench, where I filter the Reader (my adress database) by using the Where clause to a district. Result of this should be, that fme only have to compare the adresses of a district and not all adresses. I can't compare for 1000 adresses with my database this takes too long.

Well, nice idea, but I can't use a user paramater in the Where clause in my Reader, is this correct?. I tried it by transfering the district from the adress via the workspacerunner and userparameter. Where clause: district=$(district)

Any idea how I can solve this?

If you have ArcGIS then create a geocoding locator and geocode in ArcGIS.

You can set the where clause on the Feature Type. If you click on the down arrow next to WHERE Clause: you can open the Text editor, and use the attributes and parameters listed on the left side of the dialog to create your where clause.

You can set the where clause on the Feature Type. If you click on the down arrow next to WHERE Clause: you can open the Text editor, and use the attributes and parameters listed on the left side of the dialog to create your where clause.

Thanks for your answer, but this is not working. Where clause was district=$(district) but seams not to work with a user parameter. In my case it's working with a real district like district='abc' but not with the user parameter.

 

 

Thanks for your answer, but this is not working. Where clause was district=$(district) but seams not to work with a user parameter. In my case it's working with a real district like district='abc' but not with the user parameter.

 

 

@dmasl, did you try it with quotes around the parameter name? district='$(district)'

If you have ArcGIS then create a geocoding locator and geocode in ArcGIS.

Unfortunately, not. The only professional Geotool that I can use is FME.

 

 

Use a FeatureReader rather than a classic reader, it's much more flexible.

@dmasl, in case you did not see my response to my existing comment below, I wanted to add it here. When you modified the where clause, did you try it with quotes around the parameter name? district='$(district)'

You need to use the quotes to specify that the parameter value should be read as a string.

-Courtney

Reply


Community Stats

30,466
Posts
115,639
Replies
38,155
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.