DBS-derived entries missing "Regionalschlüssel"

[acka47]

From #89 (comment):

For some DBS-derived entries, the base data has a "Regionalschlüssel" in it, it can not be found in the RDF, though, and probably isn't used for matching with Geo Names.

• We have 12.304 entries with DBS ID, see http://beta.lobid.org/organisations/search?q=dbsID:*.
• We only have 4828 with DBS ID and rs: http://beta.lobid.org/organisations/search?q=dbsID:*%20AND%20rs:*
• We have 6649 entries over all with rs: http://beta.lobid.org/organisations/search?q=rs:*
• Most of the entries (6621) with rs also have containedIn: http://beta.lobid.org/organisations/search?q=containedIn:*%20AND%20rs:*
• 6986 entries have ags: http://beta.lobid.org/organisations/search?q=ags:*
• 6682 entries with ags have containedIn link: http://beta.lobid.org/organisations/search?q=containedIn:*%20AND%20ags:*

This is all quite strange. I will investigate this sometimes in 2016...

[acka47]

I took a look at the source DBS csv file. Actually, nearly every entry has a regionalschlüssel in it. I wanted to present some functions using the "rs" or "ags" field in our webcast tomorrow but won't do it as the necessary data isn't there...

[acka47]

I think, I found the problem. Actually, the Regionalschlüssel from DBS isn't taken into account at all. In the morph the field where the key comes from is name "gemeindekennzahl", see

lobid-organisations/src/main/resources/morph-enriched.xml

Lines 21 to 24 in 706adc1

	<data source="gemeindekennzahl" name="rs">
	<regexp match="(\d{11})" format="0${1}"/>
	</data>
	<data source="gemeindekennzahl" name="rs">

. In the csv file that is transformed the relevant field is named "stk_2007".

[fsteeg]

Deployed to staging: http://test.lobid.org/organisations/search?q=dbsID:*+AND+rs:*

I also changed what I believe was a bug in the previous version: if the DBS stk_2007 is 11 digits, a 0 is prependend (this wasn't actually working before). If it's 12 digits, it's used as it is. Does that make sense?

[acka47]

I also changed what I believe was a bug in the previous version: if the DBS stk_2007 is 11 digits, a 0 is prependend (this wasn't actually working before).

Hmm, @SBRitter and me did some work on the "rs" (Regionalschlüssel). In fact, it really has to have 12 digits, see https://de.wikipedia.org/wiki/Amtlicher_Gemeindeschl%C3%BCssel#Regionalschl.C3.BCssel. For today, I can not dig deeper into this.

Didn't find an error in th examples I looked at, so: +1

[fsteeg]

Yes, it looked like it was meant to be implemented that way, but due to an ordering bug it was not actually working (0 was prepended to 12 digit values, last digit was cut off).