Skip to main content
Question

How to geocode with my own adress database

D

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?

7 replies

bruceharold
Contributor
Forum|alt.badge.img+17
  • bruceharoldContributor
  • Contributor
  • August 10, 2017

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

courtney_m
Contributor
Forum|alt.badge.img+5
  • courtney_mContributor
  • Contributor
  • August 10, 2017

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.

D
  • dmasl
  • Author
  • August 10, 2017
courtney_m wrote:

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.

 

 

courtney_m
Contributor
Forum|alt.badge.img+5
  • courtney_mContributor
  • Contributor
  • August 10, 2017
dmasl wrote:
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)'
D
  • dmasl
  • Author
  • August 10, 2017
bruceharold wrote:

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.

 

 

david_r
Celebrity
  • david_rCelebrity
  • August 11, 2017

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

courtney_m
Contributor
Forum|alt.badge.img+5
  • courtney_mContributor
  • Contributor
  • August 11, 2017

@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


Helpful Members This Week

Community Stats

31,139
Posts
118,062
Replies
38,758
Members

Latest FME

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie 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.