topic Re: Adress Locator - German Adresses - Problem with House Number Field in ArcGIS Enterprise Questions

Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Oct 2015 13:24:12 GMT

Dear Community,

i have a feature layer where each point represents the centre of a building (house coordinates). Within the attribute table i have further information regarding the exact adress of each point (example below):

OID	Rechtswert	Hochwert	Strasse (Street)	Hausnummer (House Number)	Zusatz (Extra)	Ort (City)	Postleitzahl (Postal Code)
XY	XY	XY	Weinbergweg	1	a	Berlin	xxxxxxx

Based on this dataset i want to create (or lets say i tried to create) an adress locator within ArcCatalog using the house coordinate layer as reference and i want to publish it later as my own geocoding service within AGO.

Problem:

Unfortunately, there is no adress locator style which is able to recognize the field: House Number. Consequentely i am able to locate the City, Postal Code and Street but the Adress matches with the wrong house number. If i try to use the pre-defined Adress Locator Style : "Single House" the geocoding fails at all, even if i define the House Number field as required.

Does anyone know if there is an pre-defined adress locator for germany? The adress information i have are provided from a governmental institution, so i don´t want to re-organiz these data.

I also do not want to add any extra fields or using an online geocoding service. I am using ArcMap 10.2.2.

Maybe someone can help me. I have the feeling ESRI does not want ppl within Germany to use there own geolocation service because the problem seems to be an issue for many years now.

Thanks in advice,

Thomas

Re: Adress Locator - German Adresses - Problem with House Number Field

TimWitt2 — Tue, 27 Oct 2015 13:29:22 GMT

Thomas,

can you share some of your data (a couple of points), so I can try creating an address locator?

Tim

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Oct 2015 13:52:16 GMT

Hello Tim,

attached you can find a sample dataset. The folder (Geocode) is in .zip - Format.

https://upload.uni-jena.de/data/562f8164b988f7.16903068/Geocode.zip (url valid for 3 months)

The layer "Textdaten_Reference.shp" is the reference layer used for Geocoding.

The xlsx file is the table to be geocoded (containing one point from the Reference Layer - Weinbergweg 1).

Thank you in advance,

best regards,

Thomas

Re: Adress Locator - German Adresses - Problem with House Number Field

TimWitt2 — Tue, 27 Oct 2015 14:21:48 GMT

What version are you using?

When you go to the following C:\Program Files\ArcGIS\Geocode do you have locators that start with ger_ ?

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Oct 2015 14:58:31 GMT

Hi Tim,

i only have these files within the Locators - Folder:

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Oct 2015 14:59:50 GMT

The Geocode - Folder is empty

Re: Adress Locator - German Adresses - Problem with House Number Field

TimWitt2 — Tue, 27 Oct 2015 15:15:08 GMT

Thomas,

I got it to Geocode, here is what I needed to do:

1) Created a US - Single House Address Locator ( I only used the Street and Housenumber)

2) I added a field to the excel spreadsheet called Voll and wrote in the full address: 1 Weinbergweg

3) I opened ArcGIS Desktop added the spreadsheet and opened the Geocoding Toolbar.

4) I went to geocode Address, chose the newly created geocoder and as "Street or Intersection" I used the Voll field.

This gave me a 100% match. Maybe the issue is that Germans use Street Name and then the Housenumber and not the other way around?

I hope this helps!

Tim

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Oct 2015 15:55:02 GMT

Tim,

thanks alot! The Adress-Locator is working fine by using the House number in front of the Street. By puting the Adress Locators Single House Locator (using your "raodmap") together with a Street Locator Style into a composite Adress Locator i Geocode adresses within different postal code areas and cities! Thank you very much!

Btw.

Is there some configuration file, where the order is defined? So that i could use "Weinbergweg 1" instead of "1 Weinbergweg"? I mean its working now and its just a formula in excel or within the sql database.

Thank you very much!

Best regards,

Thomas

Re: Adress Locator - German Adresses - Problem with House Number Field

TimWitt2 — Tue, 27 Oct 2015 16:10:31 GMT

Kein Problem!

Sadly, I don't know where the code would be to do this switch.

Re: Adress Locator - German Adresses - Problem with House Number Field

ManuelaEhrhardt — Fri, 09 Dec 2016 13:27:18 GMT

Same here ... the issue is that german adresse work the other way around. Did you find a solution to fix the problem until today?

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Thu, 22 Dec 2016 11:06:23 GMT

Hello Manuela,

until now i did not find any solution to solve the problem.

Re: Adress Locator - German Adresses - Problem with House Number Field

ManuelaEhrhardt — Wed, 25 Jan 2017 11:30:17 GMT

Hello Thomas,

lately I talked to someone I am in contact with from esri in Leipzig and told him about the problem that a german locator style is missing. He told me that the german style is existing and available "for free" ... but you only get it in connection with a one day consulting that costs. I am now trying to convince him that I won't need any consulting and am willing to get the locator style anyway. All in all it's a very stupid approach.

Re: Adress Locator - German Adresses - Problem with House Number Field

MartinPospisil — Fri, 16 Mar 2018 14:14:50 GMT

Hi Tim,

I´ve followed your proposed workflow about geocoding German addresses but without any success. After creating the US - Single House Address Locator (using the FC of my customer´s addresses as reference dataset (primary table)) and using the full address (hsnr + streetname) as “Street or Intersection” I got no matches in the geocoder as result. Maybe this is because of the wrong reference dataset in the created Address Locator? Maybe it should be always a street layer (I have just the addresses of the customers)? If so, do you know some open source street datasets including complete addresses? ArcGIS Online offers some street layers for Germany but these are mostly rasters or FC/shp without addresses.

I also don´t understand why I cannot simply use the Esri Word Geocoder Address Locator for geocoding my attribute table cause if I put a single address from my FC (no matter in which order the hsnr and the streetname are) I always got 100% match so it should theoretically work to geocode the whole dataset…

Thank you.

Re: Adress Locator - German Adresses - Problem with House Number Field

ThomasSteudel1 — Tue, 27 Mar 2018 13:53:04 GMT

Hi Manuela,

did you have any sucess with the ESRI contact? Did you manage to get the locator style without any consulting or cost? I do not know why they host tuturials and "How to Geocode" - webpages in german language, if you can not even use the Adress Locator Styles included in the standard ArcGIS Software package. I also do not understand why you need to pay for a one day consulting course on the one hand if the US Locator Styles on the other hands are available for free.

Anyway, I found a way to geocode adresses (from tables) - the question i asked myself now - why am i still using ArcGIS for postprocessing the geocoded adresses (creating shape files, Service layers etc.). I think QGIS does the Job within the Package..... In this case i do not see the advantage of using ArcGIS anymore.....

Best regards,

Thomas

Re: Adress Locator - German Adresses - Problem with House Number Field

ShanaBritt — Tue, 27 Mar 2018 16:58:39 GMT

Martin:

Can you show an example of the table you are not able to geocode with the Esri World Geocoder? Perhaps a screen shot of a single row and all of the fields in it.

-Shana

Re: Adress Locator - German Adresses - Problem with House Number Field

MartinPospisil — Thu, 29 Mar 2018 21:09:15 GMT

Hello Shana,

here the screenshot with some example data:

Martin

Re: Adress Locator - German Adresses - Problem with House Number Field

ShanaBritt — Wed, 11 Apr 2018 15:49:33 GMT

Martin,

Are you using Voll, Plz, and Ort fields as the input fields when geocoding? Are you able to show the table field mapping in the geocoding tool you are using so that I can see what fields are being used?

Re: Adress Locator - German Adresses - Problem with House Number Field

MartinPospisil — Fri, 13 Apr 2018 21:06:30 GMT

Yes.

Using ArcGIS World Geocoding Service as Address Locator:

Result:

ERROR 002105 (no geocoding privilege) (I don´t have an ArcGIS Online for Organizational account and I don´t wanna create an ArcGIS Online Organizational trial account)

ERROR 000010 : Geocode addresses failed

Trying create the Single House Address Locator:

primary table = table with addresses to geocode

Result:

ERROR 000042 : Failed to create the address locator.

according to the description above:

Single House Address Locator = roadmap???

Street Locator Style ???

= composite Address Locator

I´m not using the Enterprise version but just the Advanced licence and maybe that´s the issue.