Wikidata:Property proposal/EKATTE

From Wikidata
Jump to navigation Jump to search

EKATTE place ID[edit]

Originally proposed at Wikidata:Property proposal/Authority control

DescriptionBulgarian place ID (settlement, community=Kmetstvo, municipality=Obshtina, province=Oblast by BG National Statistical Institute (NSI)
RepresentsEKATTE (Q3658617)
Data typeExternal identifier
Template parameter"екатте" in bg:Шаблон:Селище_в_България
DomainPlaces in Bulgaria
Allowed valuesstring: (\d{6}|[A-Z]{3}\d{2})(-\d{2})?
ExampleEg a few examples of the admin hierarchy in Kardzhali province:

More complicated around Sofia:

Sourcehttp://www.nsi.bg/nrnm/index.php?ezik=en, http://www.nsi.bg/sites/default/files/files/EKATTE/Ekatte.zip
Robot and gadget jobshttp://www.nsi.bg/sites/default/files/files/EKATTE/Ekatte.zip, http://bg.dbpedia.org/sparql (see bg:Уикипедия:Разговори#ЕКАТТЕ for query)
Motivation

The official BG place register by NSI, including some 5.5k places. There's a zip file with excels, updated regularly. This property can be populated as follows:

  • As discussed at bg:Уикипедия:Разговори#ЕКАТТЕ: EKATTE is currently stored in the infoboxes, and BG WP is ready to move them to WD with a bot.
  • Should be easy to match fully to WD/Geonames because there's a full place hierarchy; Ontotext and OpenCorporates plan to do that at the end of Mar 2017 as part of a BG Trade Register datathon.

Strictly speaking EKATTE is the settlement code (eg 68134), but the Oblast/Obshtina/Kmetstvo codes (eg SOF46-00) are also in the same dataset. Share your feedback whether it's smart to keep both Settlement and Kmetstvo (community/mayorate) codes in one property. Small settlements don't have their own Kmetstvo but only Settlement code. Vladimir Alexiev (talk) 10:47, 27 February 2017 (UTC)

Discussion
  • Symbol support vote.svg Support --Лорд Бъмбъри (talk) 14:04, 27 February 2017 (UTC)
  • Symbol support vote.svg Support --Nk (talk) 12:08, 2 March 2017 (UTC)
  • How about EKATTE place ID as the label name? ChristianKl (talk) 21:07, 6 March 2017 (UTC)
  • http://www.geonames.org/statistics/bulgaria.html shows that Geonames has complete data about BG Kmetstva (2.589 A.ADM3) and populated places (5.692 P.PPL). I bet that all of these are on WD too (if not, we'll add the missing ones). --Vladimir Alexiev (talk) 20:03, 7 March 2017 (UTC)
  • I don't think "community=Kmetstvo, municipality=Obshtina, province=Oblast" is clear. Is the suggestion that all places in the database are in Kmetstvo? ChristianKl (talk) 08:23, 9 March 2017 (UTC)
    • @ChristianKl: The "equalities" above simply provide translations of these Bulgarian words. There are 5.5k places, but only 2.8k Kmetstvo: the tiniest places don't have a Kmetstvo of their own. Does that answer the question? --Vladimir Alexiev (talk) 10:26, 14 March 2017 (UTC)
  • Symbol oppose vote.svg Oppose - given the examples, the intended usage is not clear. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 16:08, 19 March 2017 (UTC)
    • Hi @Pigsonthewing:, what is not clear? If you don't like mixing two sorts of numbers in one prop, I can split it to EKATTE and "BG Community code". We got the EKATTE extracted, and all BG settlements matched to Geonames, so we're waiting for this prop. --Vladimir Alexiev (talk) 18:47, 27 March 2017 (UTC)
      • Well, for a start, at least three of the example items have two values each, apparently relating to different concepts. Andy Mabbett (Pigsonthewing); Talk to Andy; Andy's edits 21:31, 27 March 2017 (UTC)
        • @Pigsonthewing: I explicitly asked whether you'd prefer me to split to two props. The two IDs are "id as a place" and "id as a community", but they are from the same source: BG NSI EKATTE --Vladimir Alexiev (talk) 08:50, 22 April 2017 (UTC)
  • Symbol support vote.svg Support--Mikey641 (talk) 10:58, 2 April 2017 (UTC)
  • @Mikey641, Pigsonthewing, Vladimir Alexiev, Лорд Бъмбъри, Nk: ✓ Done ChristianKl (talk) 14:25, 24 May 2017 (UTC)