Wikidata:Property proposal/EKATTE
Jump to navigation
Jump to search
EKATTE place ID
[edit]Originally proposed at Wikidata:Property proposal/Authority control
Description | Bulgarian place ID (settlement, community=Kmetstvo, municipality=Obshtina, province=Oblast by BG National Statistical Institute (NSI) |
---|---|
Represents | NRPP (Q3658617) |
Data type | External identifier |
Template parameter | "екатте" in bg:Шаблон:Селище_в_България |
Domain | Places in Bulgaria |
Allowed values | string: (\d{6}|[A-Z]{3}\d{2})(-\d{2})? |
Example | Eg a few examples of the admin hierarchy in Kardzhali province:
More complicated around Sofia:
|
Source | http://www.nsi.bg/nrnm/index.php?ezik=en, http://www.nsi.bg/sites/default/files/files/EKATTE/Ekatte.zip |
Robot and gadget jobs | http://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
- Support --Лорд Бъмбъри (talk) 14:04, 27 February 2017 (UTC)
- 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)
- 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)
- 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)
- 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)
- Support--Mikey641 (talk) 10:58, 2 April 2017 (UTC)
- @Mikey641, Pigsonthewing, Vladimir Alexiev, Лорд Бъмбъри, Nk: Done ChristianKl (talk) 14:25, 24 May 2017 (UTC)